View | Details | Raw Unified | Return to bug 10296
Collapse All | Expand All

(-)a/t/data/db_schemas/koha.mysql-2.2.9 (-1357 lines)
Lines 1-1357 Link Here
1
#
2
# Structure de la table `accountlines`
3
#
4
5
CREATE TABLE accountlines (
6
  borrowernumber int(11) NOT NULL default '0',
7
  accountno smallint(6) NOT NULL default '0',
8
  itemnumber int(11) default NULL,
9
  date date default NULL,
10
  amount decimal(28,6) default NULL,
11
  description text,
12
  dispute text,
13
  accounttype varchar(5) default NULL,
14
  amountoutstanding decimal(28,6) default NULL,
15
  timestamp timestamp(14) NOT NULL,
16
  KEY acctsborridx (borrowernumber),
17
  KEY timeidx (timestamp)
18
) TYPE=MyISAM;
19
# --------------------------------------------------------
20
21
#
22
# Structure de la table `accountoffsets`
23
#
24
25
CREATE TABLE accountoffsets (
26
  borrowernumber int(11) NOT NULL default '0',
27
  accountno smallint(6) NOT NULL default '0',
28
  offsetaccount smallint(6) NOT NULL default '0',
29
  offsetamount decimal(28,6) default NULL,
30
  timestamp timestamp(14) NOT NULL
31
) TYPE=MyISAM;
32
# --------------------------------------------------------
33
34
#
35
# Structure de la table `additionalauthors`
36
#
37
38
CREATE TABLE additionalauthors (
39
  author text NOT NULL,
40
  biblionumber int(11) NOT NULL default '0',
41
  KEY bibidx (biblionumber)
42
) TYPE=MyISAM;
43
# --------------------------------------------------------
44
45
#
46
# Structure de la table `aqbasket`
47
#
48
49
CREATE TABLE aqbasket (
50
  basketno int(11) NOT NULL auto_increment,
51
  creationdate date default NULL,
52
  closedate date default NULL,
53
  booksellerid varchar(10) default NULL,
54
  authorisedby varchar(10) default NULL,
55
  booksellerinvoicenumber text,
56
  PRIMARY KEY  (basketno)
57
) TYPE=MyISAM;
58
# --------------------------------------------------------
59
60
#
61
# Structure de la table `aqbookfund`
62
#
63
64
CREATE TABLE aqbookfund (
65
  bookfundid varchar(5) NOT NULL default '''''',
66
  bookfundname text,
67
  bookfundgroup varchar(5) default NULL,
68
  PRIMARY KEY  (bookfundid)
69
) TYPE=MyISAM;
70
# --------------------------------------------------------
71
72
#
73
# Structure de la table `aqbooksellers`
74
#
75
76
CREATE TABLE aqbooksellers (
77
  id int(11) default NULL,
78
  name text,
79
  address1 text,
80
  address2 text,
81
  address3 text,
82
  address4 text,
83
  phone varchar(30) default NULL,
84
  accountnumber text,
85
  othersupplier text,
86
  currency char(3) NOT NULL default '',
87
  deliverydays smallint(6) default NULL,
88
  followupdays smallint(6) default NULL,
89
  followupscancel smallint(6) default NULL,
90
  specialty text,
91
  booksellerfax text,
92
  notes text,
93
  bookselleremail text,
94
  booksellerurl text,
95
  contact varchar(100) default NULL,
96
  postal text,
97
  url varchar(255) default NULL,
98
  contpos varchar(100) default NULL,
99
  contphone varchar(100) default NULL,
100
  contfax varchar(100) default NULL,
101
  contaltphone varchar(100) default NULL,
102
  contemail varchar(100) default NULL,
103
  contnotes text,
104
  active tinyint(4) default NULL,
105
  listprice varchar(5) default NULL,
106
  invoiceprice varchar(5) default NULL,
107
  gstreg tinyint(4) default NULL,
108
  listincgst tinyint(4) default NULL,
109
  invoiceincgst tinyint(4) default NULL,
110
  discount float(6,4) default NULL,
111
  fax varchar(50) default NULL,
112
  nocalc int(11) default NULL,
113
  invoicedisc float(6,4) default NULL
114
) TYPE=MyISAM;
115
# --------------------------------------------------------
116
117
#
118
# Structure de la table `aqbudget`
119
#
120
121
CREATE TABLE aqbudget (
122
  bookfundid char(5) NOT NULL default '',
123
  startdate date NOT NULL default '0000-00-00',
124
  enddate date default NULL,
125
  budgetamount decimal(13,2) default NULL,
126
  aqbudgetid tinyint(4) NOT NULL auto_increment,
127
  PRIMARY KEY  (aqbudgetid)
128
) TYPE=MyISAM;
129
# --------------------------------------------------------
130
131
#
132
# Structure de la table `aqorderbreakdown`
133
#
134
135
CREATE TABLE aqorderbreakdown (
136
  ordernumber int(11) default NULL,
137
  linenumber int(11) default NULL,
138
  branchcode char(4) default NULL,
139
  bookfundid char(5) NOT NULL default '',
140
  allocation smallint(6) default NULL
141
) TYPE=MyISAM;
142
# --------------------------------------------------------
143
144
#
145
# Structure de la table `aqorderdelivery`
146
#
147
148
CREATE TABLE aqorderdelivery (
149
  ordernumber date NOT NULL default '0000-00-00',
150
  deliverynumber smallint(6) NOT NULL default '0',
151
  deliverydate varchar(18) default NULL,
152
  qtydelivered smallint(6) default NULL,
153
  deliverycomments text
154
) TYPE=MyISAM;
155
# --------------------------------------------------------
156
157
#
158
# Structure de la table `aqorders`
159
#
160
161
CREATE TABLE aqorders (
162
  ordernumber int(11) NOT NULL auto_increment,
163
  biblionumber int(11) default NULL,
164
  title text,
165
  entrydate date default NULL,
166
  quantity smallint(6) default NULL,
167
  currency char(3) default NULL,
168
  listprice decimal(28,6) default NULL,
169
  totalamount decimal(28,6) default NULL,
170
  datereceived date default NULL,
171
  booksellerinvoicenumber text,
172
  freight decimal(28,6) default NULL,
173
  unitprice decimal(28,6) default NULL,
174
  quantityreceived smallint(6) default NULL,
175
  cancelledby varchar(10) default NULL,
176
  datecancellationprinted date default NULL,
177
  notes text,
178
  supplierreference text,
179
  purchaseordernumber text,
180
  subscription tinyint(1) default NULL,
181
  serialid varchar(30) default NULL,
182
  basketno int(11) default NULL,
183
  biblioitemnumber int(11) default NULL,
184
  timestamp timestamp(14) NOT NULL,
185
  rrp decimal(13,2) default NULL,
186
  ecost decimal(13,2) default NULL,
187
  gst decimal(13,2) default NULL,
188
  budgetdate date default NULL,
189
  sort1 varchar(80) default NULL,
190
  sort2 varchar(80) default NULL,
191
  PRIMARY KEY  (ordernumber)
192
) TYPE=MyISAM;
193
# --------------------------------------------------------
194
195
#
196
# Structure de la table `auth_header`
197
#
198
199
CREATE TABLE auth_header (
200
  authid bigint(20) unsigned NOT NULL auto_increment,
201
  authtypecode char(10) NOT NULL default '',
202
  datecreated date NOT NULL default '0000-00-00',
203
  datemodified date default NULL,
204
  origincode char(20) default NULL,
205
  PRIMARY KEY  (authid),
206
  KEY origincode (origincode)
207
) TYPE=MyISAM;
208
# --------------------------------------------------------
209
210
#
211
# Structure de la table `auth_subfield_structure`
212
#
213
214
CREATE TABLE auth_subfield_structure (
215
  authtypecode char(10) NOT NULL default '',
216
  tagfield char(3) NOT NULL default '',
217
  tagsubfield char(1) NOT NULL default '',
218
  liblibrarian char(255) NOT NULL default '',
219
  libopac char(255) NOT NULL default '',
220
  repeatable tinyint(4) NOT NULL default '0',
221
  mandatory tinyint(4) NOT NULL default '0',
222
  tab tinyint(1) default NULL,
223
  authorised_value char(10) default NULL,
224
  value_builder char(80) default NULL,
225
  seealso char(255) default NULL,
226
  PRIMARY KEY  (authtypecode,tagfield,tagsubfield),
227
  KEY tab (authtypecode,tab)
228
) TYPE=MyISAM;
229
# --------------------------------------------------------
230
231
#
232
# Structure de la table `auth_subfield_table`
233
#
234
235
CREATE TABLE auth_subfield_table (
236
  subfieldid bigint(20) unsigned NOT NULL auto_increment,
237
  authid bigint(20) unsigned NOT NULL default '0',
238
  tag char(3) NOT NULL default '',
239
  tagorder tinyint(4) NOT NULL default '1',
240
  tag_indicator char(2) NOT NULL default '',
241
  subfieldcode char(1) NOT NULL default '',
242
  subfieldorder tinyint(4) NOT NULL default '1',
243
  subfieldvalue varchar(255) default NULL,
244
  PRIMARY KEY  (subfieldid),
245
  KEY authid (authid),
246
  KEY tag (tag),
247
  KEY subfieldcode (subfieldcode),
248
  KEY subfieldvalue (subfieldvalue)
249
) TYPE=MyISAM;
250
# --------------------------------------------------------
251
252
#
253
# Structure de la table `auth_tag_structure`
254
#
255
256
CREATE TABLE auth_tag_structure (
257
  authtypecode char(10) NOT NULL default '',
258
  tagfield char(3) NOT NULL default '',
259
  liblibrarian char(255) NOT NULL default '',
260
  libopac char(255) NOT NULL default '',
261
  repeatable tinyint(4) NOT NULL default '0',
262
  mandatory tinyint(4) NOT NULL default '0',
263
  authorised_value char(10) default NULL,
264
  PRIMARY KEY  (authtypecode,tagfield)
265
) TYPE=MyISAM;
266
# --------------------------------------------------------
267
268
#
269
# Structure de la table `auth_types`
270
#
271
272
CREATE TABLE auth_types (
273
  authtypecode varchar(10) NOT NULL default '',
274
  authtypetext varchar(255) NOT NULL default '',
275
  auth_tag_to_report char(3) NOT NULL default '',
276
  summary text NOT NULL,
277
  PRIMARY KEY  (authtypecode)
278
) TYPE=MyISAM;
279
# --------------------------------------------------------
280
281
#
282
# Structure de la table `auth_word`
283
#
284
285
CREATE TABLE auth_word (
286
  authid bigint(20) NOT NULL default '0',
287
  tagsubfield varchar(4) NOT NULL default '',
288
  tagorder tinyint(4) NOT NULL default '1',
289
  subfieldorder tinyint(4) NOT NULL default '1',
290
  word varchar(255) NOT NULL default '',
291
  sndx_word varchar(255) NOT NULL default '',
292
  KEY authid (authid),
293
  KEY marc_search (tagsubfield,word),
294
  KEY word (word),
295
  KEY sndx_word (sndx_word)
296
) TYPE=MyISAM;
297
# --------------------------------------------------------
298
299
#
300
# Structure de la table `authorised_values`
301
#
302
303
CREATE TABLE authorised_values (
304
  id int(11) NOT NULL auto_increment,
305
  category char(10) NOT NULL default '',
306
  authorised_value char(80) NOT NULL default '',
307
  lib char(80) default NULL,
308
  PRIMARY KEY  (id),
309
  KEY name (category)
310
) TYPE=MyISAM;
311
# --------------------------------------------------------
312
313
#
314
# Structure de la table `biblio`
315
#
316
317
CREATE TABLE biblio (
318
  biblionumber int(11) NOT NULL default '0',
319
  author text,
320
  title text,
321
  unititle text,
322
  notes text,
323
  serial tinyint(1) default NULL,
324
  seriestitle text,
325
  copyrightdate smallint(6) default NULL,
326
  timestamp timestamp(14) NOT NULL,
327
  abstract text,
328
  PRIMARY KEY  (biblionumber),
329
  KEY blbnoidx (biblionumber)
330
) TYPE=MyISAM;
331
# --------------------------------------------------------
332
333
#
334
# Structure de la table `biblio_framework`
335
#
336
337
CREATE TABLE biblio_framework (
338
  frameworkcode char(4) NOT NULL default '',
339
  frameworktext char(255) NOT NULL default '',
340
  PRIMARY KEY  (frameworkcode)
341
) TYPE=MyISAM;
342
# --------------------------------------------------------
343
344
#
345
# Structure de la table `biblioanalysis`
346
#
347
348
CREATE TABLE biblioanalysis (
349
  analyticaltitle text,
350
  biblionumber int(11) NOT NULL default '0',
351
  analyticalauthor text
352
) TYPE=MyISAM;
353
# --------------------------------------------------------
354
355
#
356
# Structure de la table `biblioitems`
357
#
358
359
CREATE TABLE biblioitems (
360
  biblioitemnumber int(11) NOT NULL default '0',
361
  biblionumber int(11) NOT NULL default '0',
362
  volume text,
363
  number text,
364
  classification varchar(25) default NULL,
365
  itemtype varchar(4) default NULL,
366
  isbn varchar(14) default NULL,
367
  issn varchar(9) default NULL,
368
  dewey varchar(50) default NULL,
369
  subclass char(3) default NULL,
370
  publicationyear smallint(6) default NULL,
371
  publishercode varchar(255) default NULL,
372
  volumedate date default NULL,
373
  volumeddesc varchar(255) default NULL,
374
  timestamp timestamp(14) NOT NULL,
375
  illus varchar(255) default NULL,
376
  pages varchar(255) default NULL,
377
  notes text,
378
  size varchar(255) default NULL,
379
  place varchar(255) default NULL,
380
  lccn varchar(25) default NULL,
381
  marc text,
382
  url varchar(255) default NULL,
383
  PRIMARY KEY  (biblioitemnumber),
384
  KEY bibinoidx (biblioitemnumber),
385
  KEY bibnoidx (biblionumber)
386
) TYPE=MyISAM;
387
# --------------------------------------------------------
388
389
#
390
# Structure de la table `bibliosubject`
391
#
392
393
CREATE TABLE bibliosubject (
394
  subject text NOT NULL,
395
  biblionumber int(11) NOT NULL default '0'
396
) TYPE=MyISAM;
397
# --------------------------------------------------------
398
399
#
400
# Structure de la table `bibliosubtitle`
401
#
402
403
CREATE TABLE bibliosubtitle (
404
  subtitle text NOT NULL,
405
  biblionumber int(11) NOT NULL default '0',
406
  KEY bibsubidx (biblionumber)
407
) TYPE=MyISAM;
408
# --------------------------------------------------------
409
410
#
411
# Structure de la table `bibliothesaurus`
412
#
413
414
CREATE TABLE bibliothesaurus (
415
  id bigint(20) NOT NULL auto_increment,
416
  freelib char(255) NOT NULL default '',
417
  stdlib char(255) NOT NULL default '',
418
  category char(10) NOT NULL default '',
419
  level tinyint(4) NOT NULL default '1',
420
  hierarchy char(80) NOT NULL default '',
421
  father char(80) NOT NULL default '',
422
  PRIMARY KEY  (id),
423
  KEY freelib (freelib),
424
  KEY stdlib (stdlib),
425
  KEY category (category),
426
  KEY hierarchy (hierarchy),
427
  FULLTEXT KEY category_2 (category,freelib)
428
) TYPE=MyISAM;
429
# --------------------------------------------------------
430
431
#
432
# Structure de la table `bookshelf`
433
#
434
435
CREATE TABLE bookshelf (
436
  shelfnumber int(11) NOT NULL auto_increment,
437
  shelfname char(255) default NULL,
438
  owner char(80) default NULL,
439
  category char(1) default NULL,
440
  PRIMARY KEY  (shelfnumber)
441
) TYPE=MyISAM;
442
# --------------------------------------------------------
443
444
#
445
# Structure de la table `borexp`
446
#
447
448
CREATE TABLE borexp (
449
  borrowernumber int(11) default NULL,
450
  newexp date default NULL
451
) TYPE=MyISAM;
452
# --------------------------------------------------------
453
454
#
455
# Structure de la table `borrowers`
456
#
457
458
CREATE TABLE borrowers (
459
  borrowernumber int(11) NOT NULL auto_increment,
460
  cardnumber varchar(16) NOT NULL default '',
461
  surname text NOT NULL,
462
  firstname text NOT NULL,
463
  title text,
464
  othernames text,
465
  initials text NOT NULL,
466
  streetaddress text NOT NULL,
467
  suburb text,
468
  city text NOT NULL,
469
  phone text NOT NULL,
470
  emailaddress text,
471
  faxnumber text,
472
  textmessaging text,
473
  altstreetaddress text,
474
  altsuburb text,
475
  altcity text,
476
  altphone text,
477
  dateofbirth date default NULL,
478
  branchcode varchar(4) NOT NULL default '',
479
  categorycode char(2) default NULL,
480
  dateenrolled date default NULL,
481
  gonenoaddress tinyint(1) default NULL,
482
  lost tinyint(1) default NULL,
483
  debarred tinyint(1) default NULL,
484
  studentnumber text,
485
  school text,
486
  contactname text,
487
  borrowernotes text,
488
  guarantor int(11) default NULL,
489
  area char(2) default NULL,
490
  ethnicity varchar(50) default NULL,
491
  ethnotes varchar(255) default NULL,
492
  sex char(1) default NULL,
493
  expiry date default NULL,
494
  altnotes varchar(255) default NULL,
495
  altrelationship varchar(100) default NULL,
496
  streetcity text,
497
  phoneday varchar(50) default NULL,
498
  preferredcont char(1) default NULL,
499
  physstreet varchar(100) default NULL,
500
  password varchar(30) default NULL,
501
  flags int(11) default NULL,
502
  userid varchar(30) default NULL,
503
  homezipcode varchar(25) default NULL,
504
  zipcode varchar(25) default NULL,
505
  sort1 varchar(80) default NULL,
506
  sort2 varchar(80) default NULL,
507
  UNIQUE KEY cardnumber (cardnumber),
508
  KEY borrowernumber (borrowernumber)
509
) TYPE=MyISAM;
510
# --------------------------------------------------------
511
512
#
513
# Structure de la table `branchcategories`
514
#
515
516
CREATE TABLE branchcategories (
517
  categorycode varchar(4) NOT NULL default '',
518
  categoryname text,
519
  codedescription text,
520
  PRIMARY KEY  (categorycode)
521
) TYPE=MyISAM;
522
# --------------------------------------------------------
523
524
#
525
# Structure de la table `branches`
526
#
527
528
CREATE TABLE branches (
529
  branchcode varchar(4) NOT NULL default '',
530
  branchname text NOT NULL,
531
  branchaddress1 text,
532
  branchaddress2 text,
533
  branchaddress3 text,
534
  branchphone text,
535
  branchfax text,
536
  branchemail text,
537
  issuing tinyint(4) default NULL,
538
  UNIQUE KEY branchcode (branchcode)
539
) TYPE=MyISAM;
540
# --------------------------------------------------------
541
542
#
543
# Structure de la table `branchrelations`
544
#
545
546
CREATE TABLE branchrelations (
547
  branchcode varchar(4) default NULL,
548
  categorycode varchar(4) default NULL
549
) TYPE=MyISAM;
550
# --------------------------------------------------------
551
552
#
553
# Structure de la table `branchtransfers`
554
#
555
556
CREATE TABLE branchtransfers (
557
  itemnumber int(11) NOT NULL default '0',
558
  datesent datetime default NULL,
559
  frombranch varchar(4) default NULL,
560
  datearrived datetime default NULL,
561
  tobranch varchar(4) default NULL,
562
  comments text
563
) TYPE=MyISAM;
564
# --------------------------------------------------------
565
566
#
567
# Structure de la table `catalogueentry`
568
#
569
570
CREATE TABLE catalogueentry (
571
  catalogueentry text NOT NULL,
572
  entrytype char(2) default NULL,
573
  see text,
574
  seealso text,
575
  seeinstead text,
576
  biblionumber int(11) default NULL
577
) TYPE=MyISAM;
578
# --------------------------------------------------------
579
580
#
581
# Structure de la table `categories`
582
#
583
584
CREATE TABLE categories (
585
  categorycode char(2) NOT NULL default '',
586
  description text,
587
  enrolmentperiod smallint(6) default NULL,
588
  upperagelimit smallint(6) default NULL,
589
  dateofbirthrequired tinyint(1) default NULL,
590
  finetype varchar(30) default NULL,
591
  bulk tinyint(1) default NULL,
592
  enrolmentfee decimal(28,6) default NULL,
593
  overduenoticerequired tinyint(1) default NULL,
594
  issuelimit smallint(6) default NULL,
595
  reservefee decimal(28,6) default NULL,
596
  UNIQUE KEY categorycode (categorycode)
597
) TYPE=MyISAM;
598
# --------------------------------------------------------
599
600
#
601
# Structure de la table `currency`
602
#
603
604
CREATE TABLE currency (
605
  currency varchar(10) default NULL,
606
  rate float(7,5) default NULL
607
) TYPE=MyISAM;
608
# --------------------------------------------------------
609
610
#
611
# Structure de la table `deletedbiblio`
612
#
613
614
CREATE TABLE deletedbiblio (
615
  biblionumber int(11) NOT NULL default '0',
616
  author text,
617
  title text,
618
  unititle text,
619
  notes text,
620
  serial tinyint(1) default NULL,
621
  seriestitle text,
622
  copyrightdate smallint(6) default NULL,
623
  timestamp timestamp(14) NOT NULL,
624
  marc blob,
625
  abstract text,
626
  PRIMARY KEY  (biblionumber),
627
  KEY blbnoidx (biblionumber)
628
) TYPE=MyISAM;
629
# --------------------------------------------------------
630
631
#
632
# Structure de la table `deletedbiblioitems`
633
#
634
635
CREATE TABLE deletedbiblioitems (
636
  biblioitemnumber int(11) NOT NULL default '0',
637
  biblionumber int(11) NOT NULL default '0',
638
  volume text,
639
  number text,
640
  classification varchar(25) default NULL,
641
  itemtype varchar(4) default NULL,
642
  isbn varchar(14) default NULL,
643
  issn varchar(9) default NULL,
644
  dewey varchar(50) default NULL,
645
  subclass char(3) default NULL,
646
  publicationyear smallint(6) default NULL,
647
  publishercode varchar(255) default NULL,
648
  volumedate date default NULL,
649
  volumeddesc varchar(255) default NULL,
650
  timestamp timestamp(14) NOT NULL,
651
  illus varchar(255) default NULL,
652
  pages varchar(255) default NULL,
653
  notes text,
654
  size varchar(255) default NULL,
655
  lccn varchar(25) default NULL,
656
  marc text,
657
  url varchar(255) default NULL,
658
  PRIMARY KEY  (biblioitemnumber),
659
  KEY bibinoidx (biblioitemnumber),
660
  KEY bibnoidx (biblionumber)
661
) TYPE=MyISAM;
662
# --------------------------------------------------------
663
664
#
665
# Structure de la table `deletedborrowers`
666
#
667
668
CREATE TABLE deletedborrowers (
669
  borrowernumber int(11) NOT NULL default '0',
670
  cardnumber varchar(9) NOT NULL default '',
671
  surname text NOT NULL,
672
  firstname text NOT NULL,
673
  title text,
674
  othernames text,
675
  initials text NOT NULL,
676
  streetaddress text NOT NULL,
677
  suburb text,
678
  city text NOT NULL,
679
  phone text NOT NULL,
680
  emailaddress text,
681
  faxnumber text,
682
  altstreetaddress text,
683
  altsuburb text,
684
  altcity text,
685
  altphone text,
686
  dateofbirth date default NULL,
687
  branchcode varchar(4) NOT NULL default '',
688
  categorycode char(2) default NULL,
689
  dateenrolled date default NULL,
690
  gonenoaddress tinyint(1) default NULL,
691
  lost tinyint(1) default NULL,
692
  debarred tinyint(1) default NULL,
693
  studentnumber text,
694
  school text,
695
  contactname text,
696
  borrowernotes text,
697
  guarantor int(11) default NULL,
698
  area char(2) default NULL,
699
  ethnicity varchar(50) default NULL,
700
  ethnotes varchar(255) default NULL,
701
  sex char(1) default NULL,
702
  expiry date default NULL,
703
  altnotes varchar(255) default NULL,
704
  altrelationship varchar(100) default NULL,
705
  streetcity text,
706
  phoneday varchar(50) default NULL,
707
  preferredcont varchar(100) default NULL,
708
  physstreet varchar(100) default NULL,
709
  KEY borrowernumber (borrowernumber),
710
  KEY cardnumber (cardnumber)
711
) TYPE=MyISAM;
712
# --------------------------------------------------------
713
714
#
715
# Structure de la table `deleteditems`
716
#
717
718
CREATE TABLE deleteditems (
719
  itemnumber int(11) NOT NULL default '0',
720
  biblionumber int(11) NOT NULL default '0',
721
  multivolumepart varchar(30) default NULL,
722
  biblioitemnumber int(11) NOT NULL default '0',
723
  barcode varchar(9) NOT NULL default '',
724
  dateaccessioned date default NULL,
725
  booksellerid varchar(10) default NULL,
726
  homebranch varchar(4) default NULL,
727
  price decimal(28,6) default NULL,
728
  replacementprice decimal(28,6) default NULL,
729
  replacementpricedate date default NULL,
730
  datelastborrowed date default NULL,
731
  datelastseen date default NULL,
732
  multivolume tinyint(1) default NULL,
733
  stack tinyint(1) default NULL,
734
  notforloan tinyint(1) default NULL,
735
  itemlost tinyint(1) default NULL,
736
  wthdrawn tinyint(1) default NULL,
737
  bulk varchar(30) default NULL,
738
  issues smallint(6) default NULL,
739
  renewals smallint(6) default NULL,
740
  reserves smallint(6) default NULL,
741
  restricted tinyint(1) default NULL,
742
  binding decimal(28,6) default NULL,
743
  itemnotes text,
744
  holdingbranch varchar(4) default NULL,
745
  interim tinyint(1) default NULL,
746
  timestamp timestamp(14) NOT NULL,
747
  marc blob,
748
  paidfor text,
749
  PRIMARY KEY  (itemnumber),
750
  UNIQUE KEY barcode (barcode),
751
  KEY itembarcodeidx (barcode),
752
  KEY itembinoidx (biblioitemnumber),
753
  KEY itembibnoidx (biblionumber)
754
) TYPE=MyISAM;
755
# --------------------------------------------------------
756
757
#
758
# Structure de la table `ethnicity`
759
#
760
761
CREATE TABLE ethnicity (
762
  code varchar(10) NOT NULL default '',
763
  name varchar(255) default NULL,
764
  PRIMARY KEY  (code)
765
) TYPE=MyISAM;
766
# --------------------------------------------------------
767
768
#
769
# Structure de la table `issues`
770
#
771
772
CREATE TABLE issues (
773
  borrowernumber int(11) NOT NULL default '0',
774
  itemnumber int(11) NOT NULL default '0',
775
  date_due date default NULL,
776
  branchcode char(4) default NULL,
777
  issuingbranch char(18) default NULL,
778
  returndate date default NULL,
779
  lastreneweddate date default NULL,
780
  `return` char(4) default NULL,
781
  renewals tinyint(4) default NULL,
782
  timestamp timestamp(14) NOT NULL,
783
  KEY issuesborridx (borrowernumber),
784
  KEY issuesitemidx (itemnumber),
785
  KEY bordate (borrowernumber,timestamp)
786
) TYPE=MyISAM;
787
# --------------------------------------------------------
788
789
#
790
# Structure de la table `issuingrules`
791
#
792
793
CREATE TABLE issuingrules (
794
  categorycode char(2) NOT NULL default '',
795
  itemtype varchar(4) NOT NULL default '',
796
  restrictedtype tinyint(1) default NULL,
797
  rentaldiscount decimal(28,6) default NULL,
798
  reservecharge decimal(28,6) default NULL,
799
  fine decimal(28,6) default NULL,
800
  firstremind int(11) default NULL,
801
  chargeperiod int(11) default NULL,
802
  accountsent int(11) default NULL,
803
  chargename varchar(100) default NULL,
804
  maxissueqty int(4) default NULL,
805
  issuelength int(4) default NULL,
806
  branchcode varchar(4) NOT NULL default '',
807
  PRIMARY KEY  (branchcode,categorycode,itemtype)
808
) TYPE=MyISAM;
809
# --------------------------------------------------------
810
811
#
812
# Structure de la table `items`
813
#
814
815
CREATE TABLE items (
816
  itemnumber int(11) NOT NULL default '0',
817
  biblionumber int(11) NOT NULL default '0',
818
  multivolumepart varchar(30) default NULL,
819
  biblioitemnumber int(11) NOT NULL default '0',
820
  barcode varchar(20) default NULL,
821
  dateaccessioned date default NULL,
822
  booksellerid varchar(10) default NULL,
823
  homebranch varchar(4) default NULL,
824
  price decimal(8,2) default NULL,
825
  replacementprice decimal(8,2) default NULL,
826
  replacementpricedate date default NULL,
827
  datelastborrowed date default NULL,
828
  datelastseen date default NULL,
829
  multivolume tinyint(1) default NULL,
830
  stack tinyint(1) default NULL,
831
  notforloan tinyint(1) default NULL,
832
  itemlost tinyint(1) default NULL,
833
  wthdrawn tinyint(1) default NULL,
834
  itemcallnumber varchar(30) default NULL,
835
  issues smallint(6) default NULL,
836
  renewals smallint(6) default NULL,
837
  reserves smallint(6) default NULL,
838
  restricted tinyint(1) default NULL,
839
  binding decimal(28,6) default NULL,
840
  itemnotes text,
841
  holdingbranch varchar(4) default NULL,
842
  paidfor text,
843
  timestamp timestamp(14) NOT NULL,
844
  location varchar(80) default NULL,
845
  PRIMARY KEY  (itemnumber),
846
  KEY itembarcodeidx (barcode),
847
  KEY itembinoidx (biblioitemnumber),
848
  KEY itembibnoidx (biblionumber)
849
) TYPE=MyISAM;
850
# --------------------------------------------------------
851
852
#
853
# Structure de la table `itemsprices`
854
#
855
856
CREATE TABLE itemsprices (
857
  itemnumber int(11) default NULL,
858
  price1 decimal(28,6) default NULL,
859
  price2 decimal(28,6) default NULL
860
) TYPE=MyISAM;
861
# --------------------------------------------------------
862
863
#
864
# Structure de la table `itemtypes`
865
#
866
867
CREATE TABLE itemtypes (
868
  itemtype varchar(4) NOT NULL default '',
869
  description text,
870
  renewalsallowed smallint(6) default NULL,
871
  rentalcharge double(16,4) default NULL,
872
  notforloan smallint(6) default NULL,
873
  UNIQUE KEY itemtype (itemtype)
874
) TYPE=MyISAM;
875
# --------------------------------------------------------
876
877
#
878
# Structure de la table `marc_biblio`
879
#
880
881
CREATE TABLE marc_biblio (
882
  bibid bigint(20) unsigned NOT NULL auto_increment,
883
  biblionumber int(11) NOT NULL default '0',
884
  datecreated date NOT NULL default '0000-00-00',
885
  datemodified date default NULL,
886
  origincode char(20) default NULL,
887
  frameworkcode char(4) NOT NULL default '',
888
  PRIMARY KEY  (bibid),
889
  KEY origincode (origincode),
890
  KEY biblionumber (biblionumber)
891
) TYPE=MyISAM;
892
# --------------------------------------------------------
893
894
#
895
# Structure de la table `marc_blob_subfield`
896
#
897
898
CREATE TABLE marc_blob_subfield (
899
  blobidlink bigint(20) NOT NULL auto_increment,
900
  subfieldvalue longtext NOT NULL,
901
  PRIMARY KEY  (blobidlink)
902
) TYPE=MyISAM;
903
# --------------------------------------------------------
904
905
#
906
# Structure de la table `marc_breeding`
907
#
908
909
CREATE TABLE marc_breeding (
910
  id bigint(20) NOT NULL auto_increment,
911
  file varchar(80) NOT NULL default '',
912
  isbn varchar(10) NOT NULL default '',
913
  title varchar(128) default NULL,
914
  author varchar(80) default NULL,
915
  marc text NOT NULL,
916
  encoding varchar(40) NOT NULL default '''''',
917
  z3950random varchar(40) default NULL,
918
  PRIMARY KEY  (id),
919
  KEY title (title),
920
  KEY isbn (isbn)
921
) TYPE=MyISAM;
922
# --------------------------------------------------------
923
924
#
925
# Structure de la table `marc_subfield_structure`
926
#
927
CREATE TABLE marc_subfield_structure (
928
  tagfield char(3) NOT NULL default '',
929
  tagsubfield char(1) NOT NULL default '',
930
  liblibrarian varchar(255) NOT NULL default '',
931
  libopac varchar(255) NOT NULL default '',
932
  repeatable tinyint(4) NOT NULL default '0',
933
  mandatory tinyint(4) NOT NULL default '0',
934
  kohafield varchar(40) default NULL,
935
  tab tinyint(1) default NULL,
936
  authorised_value varchar(10) default NULL,
937
  authtypecode varchar(10) default NULL,
938
  value_builder varchar(80) default NULL,
939
  isurl tinyint(1) default NULL,
940
  hidden tinyint(1) default NULL,
941
  frameworkcode varchar(4) NOT NULL default '',
942
  seealso text default NULL,
943
  link varchar(80) default NULL,
944
  PRIMARY KEY  (frameworkcode,tagfield,tagsubfield),
945
  KEY tab (frameworkcode,tab),
946
  KEY kohafield (frameworkcode,kohafield),
947
  KEY kohafield_2 (kohafield)
948
) TYPE=MyISAM;
949
# --------------------------------------------------------
950
951
#
952
# Structure de la table `marc_subfield_table`
953
#
954
955
CREATE TABLE marc_subfield_table (
956
  subfieldid bigint(20) unsigned NOT NULL auto_increment,
957
  bibid bigint(20) unsigned NOT NULL default '0',
958
  tag char(3) NOT NULL default '',
959
  tagorder tinyint(4) NOT NULL default '1',
960
  tag_indicator char(2) NOT NULL default '',
961
  subfieldcode char(1) NOT NULL default '',
962
  subfieldorder tinyint(4) NOT NULL default '1',
963
  subfieldvalue varchar(255) default NULL,
964
  valuebloblink bigint(20) default NULL,
965
  PRIMARY KEY  (subfieldid),
966
  KEY bibid (bibid),
967
  KEY tag (tag),
968
  KEY tag_indicator (tag_indicator),
969
  KEY subfieldorder (subfieldorder),
970
  KEY subfieldcode (subfieldcode),
971
  KEY subfieldvalue (subfieldvalue),
972
  KEY tagorder (tagorder)
973
) TYPE=MyISAM;
974
# --------------------------------------------------------
975
976
#
977
# Structure de la table `marc_tag_structure`
978
#
979
980
CREATE TABLE marc_tag_structure (
981
  tagfield char(3) NOT NULL default '',
982
  liblibrarian char(255) NOT NULL default '',
983
  libopac char(255) NOT NULL default '',
984
  repeatable tinyint(4) NOT NULL default '0',
985
  mandatory tinyint(4) NOT NULL default '0',
986
  authorised_value char(10) default NULL,
987
  frameworkcode char(4) NOT NULL default '',
988
  PRIMARY KEY  (frameworkcode,tagfield)
989
) TYPE=MyISAM;
990
# --------------------------------------------------------
991
992
#
993
# Structure de la table `marc_word`
994
#
995
996
CREATE TABLE marc_word (
997
  bibid bigint(20) NOT NULL default '0',
998
  tagsubfield varchar(4) NOT NULL default '',
999
  tagorder tinyint(4) NOT NULL default '1',
1000
  subfieldorder tinyint(4) NOT NULL default '1',
1001
  word varchar(255) NOT NULL default '',
1002
  sndx_word varchar(255) NOT NULL default '',
1003
  KEY bibid (bibid),
1004
  KEY tagorder (tagorder),
1005
  KEY subfieldorder (subfieldorder),
1006
  KEY word (word),
1007
  KEY sndx_word (sndx_word),
1008
  KEY Search_Marc (tagsubfield,word)
1009
) TYPE=MyISAM;
1010
# --------------------------------------------------------
1011
1012
#
1013
# Structure de la table `marcrecorddone`
1014
#
1015
1016
CREATE TABLE marcrecorddone (
1017
  isbn char(40) default NULL,
1018
  issn char(40) default NULL,
1019
  lccn char(40) default NULL,
1020
  controlnumber char(40) default NULL
1021
) TYPE=MyISAM;
1022
# --------------------------------------------------------
1023
1024
#
1025
# Structure de la table `printers`
1026
#
1027
1028
CREATE TABLE printers (
1029
  printername char(40) NOT NULL default '''''',
1030
  printqueue char(20) default NULL,
1031
  printtype char(20) default NULL,
1032
  PRIMARY KEY  (printername)
1033
) TYPE=MyISAM;
1034
# --------------------------------------------------------
1035
1036
#
1037
# Structure de la table `reserveconstraints`
1038
#
1039
1040
CREATE TABLE reserveconstraints (
1041
  borrowernumber int(11) NOT NULL default '0',
1042
  reservedate date NOT NULL default '0000-00-00',
1043
  biblionumber int(11) NOT NULL default '0',
1044
  biblioitemnumber int(11) default NULL,
1045
  timestamp timestamp(14) NOT NULL
1046
) TYPE=MyISAM;
1047
# --------------------------------------------------------
1048
1049
#
1050
# Structure de la table `reserves`
1051
#
1052
1053
CREATE TABLE reserves (
1054
  borrowernumber int(11) NOT NULL default '0',
1055
  reservedate date NOT NULL default '0000-00-00',
1056
  biblionumber int(11) NOT NULL default '0',
1057
  constrainttype char(1) default NULL,
1058
  branchcode varchar(4) default NULL,
1059
  notificationdate date default NULL,
1060
  reminderdate date default NULL,
1061
  cancellationdate date default NULL,
1062
  reservenotes text,
1063
  priority smallint(6) default NULL,
1064
  found char(1) default NULL,
1065
  timestamp timestamp(14) NOT NULL,
1066
  itemnumber int(11) default NULL
1067
) TYPE=MyISAM;
1068
# --------------------------------------------------------
1069
1070
#
1071
# Structure de la table `serial`
1072
#
1073
1074
CREATE TABLE serial (
1075
  serialid int(11) NOT NULL auto_increment,
1076
  biblionumber varchar(100) NOT NULL default '',
1077
  subscriptionid varchar(100) NOT NULL default '',
1078
  serialseq varchar(100) NOT NULL default '',
1079
  status tinyint(4) NOT NULL default '0',
1080
  planneddate date NOT NULL default '0000-00-00',
1081
  PRIMARY KEY  (serialid)
1082
) TYPE=MyISAM;
1083
# --------------------------------------------------------
1084
1085
#
1086
# Structure de la table `sessionqueries`
1087
#
1088
1089
CREATE TABLE sessionqueries (
1090
  sessionID varchar(255) NOT NULL default '',
1091
  userid varchar(100) NOT NULL default '',
1092
  ip varchar(18) NOT NULL default '',
1093
  url text NOT NULL
1094
) TYPE=MyISAM;
1095
# --------------------------------------------------------
1096
1097
#
1098
# Structure de la table `sessions`
1099
#
1100
1101
CREATE TABLE sessions (
1102
  sessionID varchar(255) NOT NULL default '',
1103
  userid varchar(255) default NULL,
1104
  ip varchar(16) default NULL,
1105
  lasttime int(11) default NULL,
1106
  PRIMARY KEY  (sessionID)
1107
) TYPE=MyISAM;
1108
# --------------------------------------------------------
1109
1110
#
1111
# Structure de la table `shelfcontents`
1112
#
1113
1114
CREATE TABLE shelfcontents (
1115
  shelfnumber int(11) NOT NULL default '0',
1116
  itemnumber int(11) NOT NULL default '0',
1117
  flags int(11) default NULL
1118
) TYPE=MyISAM;
1119
# --------------------------------------------------------
1120
1121
#
1122
# Structure de la table `statistics`
1123
#
1124
1125
CREATE TABLE statistics (
1126
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
1127
  branch varchar(4) default NULL,
1128
  proccode varchar(4) default NULL,
1129
  value double(16,4) default NULL,
1130
  type varchar(16) default NULL,
1131
  other text,
1132
  usercode varchar(10) default NULL,
1133
  itemnumber int(11) default NULL,
1134
  itemtype varchar(4) default NULL,
1135
  borrowernumber int(11) default NULL,
1136
  KEY timeidx (datetime)
1137
) TYPE=MyISAM;
1138
# --------------------------------------------------------
1139
1140
#
1141
# Structure de la table `stopwords`
1142
#
1143
1144
CREATE TABLE stopwords (
1145
  word varchar(255) default NULL
1146
) TYPE=MyISAM;
1147
# --------------------------------------------------------
1148
1149
#
1150
# Structure de la table `subscription`
1151
#
1152
1153
CREATE TABLE subscription (
1154
  biblionumber int(11) NOT NULL default '0',
1155
  subscriptionid int(11) NOT NULL auto_increment,
1156
  librarian varchar(100) default '',
1157
  startdate date default '0000-00-00',
1158
  aqbooksellerid int(11) default '0',
1159
  cost int(11) default '0',
1160
  aqbudgetid int(11) default '0',
1161
  weeklength tinyint(4) default '0',
1162
  monthlength tinyint(4) default '0',
1163
  numberlength tinyint(4) default '0',
1164
  periodicity tinyint(4) default '0',
1165
  dow varchar(100) default '',
1166
  numberingmethod varchar(100) default '',
1167
  notes text,
1168
  status varchar(100) NOT NULL default '',
1169
  add1 int(11) default '0',
1170
  every1 int(11) default '0',
1171
  whenmorethan1 int(11) default '0',
1172
  setto1 int(11) default NULL,
1173
  lastvalue1 int(11) default NULL,
1174
  add2 int(11) default '0',
1175
  every2 int(11) default '0',
1176
  whenmorethan2 int(11) default '0',
1177
  setto2 int(11) default NULL,
1178
  lastvalue2 int(11) default NULL,
1179
  add3 int(11) default '0',
1180
  every3 int(11) default '0',
1181
  innerloop1 int(11) default '0',
1182
  innerloop2 int(11) default '0',
1183
  innerloop3 int(11) default '0',
1184
  whenmorethan3 int(11) default '0',
1185
  setto3 int(11) default NULL,
1186
  lastvalue3 int(11) default NULL,
1187
  PRIMARY KEY  (subscriptionid)
1188
) TYPE=MyISAM;
1189
# --------------------------------------------------------
1190
1191
#
1192
# Structure de la table `subscriptionhistory`
1193
#
1194
1195
CREATE TABLE subscriptionhistory (
1196
  biblionumber int(11) NOT NULL default '0',
1197
  subscriptionid int(11) NOT NULL default '0',
1198
  histstartdate date NOT NULL default '0000-00-00',
1199
  enddate date default '0000-00-00',
1200
  missinglist longtext NOT NULL,
1201
  recievedlist longtext NOT NULL,
1202
  opacnote varchar(150) NOT NULL default '',
1203
  librariannote varchar(150) NOT NULL default '',
1204
  PRIMARY KEY  (subscriptionid),
1205
  KEY biblionumber (biblionumber)
1206
) TYPE=MyISAM;
1207
# --------------------------------------------------------
1208
1209
#
1210
# Structure de la table `suggestions`
1211
#
1212
1213
CREATE TABLE suggestions (
1214
  suggestionid int(8) NOT NULL auto_increment,
1215
  suggestedby int(11) NOT NULL default '0',
1216
  managedby int(11) default NULL,
1217
  STATUS varchar(10) NOT NULL default '',
1218
  note text,
1219
  author varchar(80) default NULL,
1220
  title varchar(80) default NULL,
1221
  copyrightdate smallint(6) default NULL,
1222
  publishercode varchar(255) default NULL,
1223
  date timestamp(8) NOT NULL,
1224
  volumedesc varchar(255) default NULL,
1225
  publicationyear smallint(6) default '0',
1226
  place varchar(255) default NULL,
1227
  isbn varchar(10) default NULL,
1228
  mailoverseeing smallint(1) default '0',
1229
  biblionumber int(11) default NULL,
1230
  PRIMARY KEY  (suggestionid),
1231
  KEY suggestedby (suggestedby),
1232
  KEY managedby (managedby)
1233
) TYPE=MyISAM;
1234
# --------------------------------------------------------
1235
1236
#
1237
# Structure de la table `systempreferences`
1238
#
1239
1240
CREATE TABLE systempreferences (
1241
  variable varchar(50) NOT NULL default '',
1242
  value text,
1243
  options text,
1244
  explanation varchar(80) default NULL,
1245
  type varchar(20) default NULL,
1246
  PRIMARY KEY  (variable)
1247
) TYPE=MyISAM;
1248
# --------------------------------------------------------
1249
1250
#
1251
# Structure de la table `uploadedmarc`
1252
#
1253
1254
CREATE TABLE uploadedmarc (
1255
  id int(11) NOT NULL auto_increment,
1256
  marc longblob,
1257
  hidden smallint(6) default NULL,
1258
  name varchar(255) default NULL,
1259
  PRIMARY KEY  (id)
1260
) TYPE=MyISAM;
1261
# --------------------------------------------------------
1262
1263
#
1264
# Structure de la table `userflags`
1265
#
1266
1267
CREATE TABLE userflags (
1268
  bit int(11) NOT NULL default '0',
1269
  flag char(30) default NULL,
1270
  flagdesc char(255) default NULL,
1271
  defaulton int(11) default NULL
1272
) TYPE=MyISAM;
1273
# --------------------------------------------------------
1274
1275
#
1276
# Structure de la table `users`
1277
#
1278
1279
CREATE TABLE users (
1280
  usercode varchar(10) default NULL,
1281
  username text,
1282
  password text,
1283
  level smallint(6) default NULL
1284
) TYPE=MyISAM;
1285
# --------------------------------------------------------
1286
1287
#
1288
# Structure de la table `websites`
1289
#
1290
1291
CREATE TABLE websites (
1292
  websitenumber int(11) NOT NULL auto_increment,
1293
  biblionumber int(11) NOT NULL default '0',
1294
  title text,
1295
  description text,
1296
  url varchar(255) default NULL,
1297
  PRIMARY KEY  (websitenumber)
1298
) TYPE=MyISAM;
1299
# --------------------------------------------------------
1300
1301
#
1302
# Structure de la table `z3950queue`
1303
#
1304
1305
CREATE TABLE z3950queue (
1306
  id int(11) NOT NULL auto_increment,
1307
  term text,
1308
  type varchar(10) default NULL,
1309
  startdate int(11) default NULL,
1310
  enddate int(11) default NULL,
1311
  done smallint(6) default NULL,
1312
  results longblob,
1313
  numrecords int(11) default NULL,
1314
  servers text,
1315
  identifier varchar(30) default NULL,
1316
  PRIMARY KEY  (id)
1317
) TYPE=MyISAM;
1318
# --------------------------------------------------------
1319
1320
#
1321
# Structure de la table `z3950results`
1322
#
1323
1324
CREATE TABLE z3950results (
1325
  id int(11) NOT NULL auto_increment,
1326
  queryid int(11) default NULL,
1327
  server varchar(255) default NULL,
1328
  startdate int(11) default NULL,
1329
  enddate int(11) default NULL,
1330
  results longblob,
1331
  numrecords int(11) default NULL,
1332
  numdownloaded int(11) default NULL,
1333
  highestseen int(11) default NULL,
1334
  active smallint(6) default NULL,
1335
  PRIMARY KEY  (id),
1336
  UNIQUE KEY query_server (queryid,server)
1337
) TYPE=MyISAM;
1338
# --------------------------------------------------------
1339
1340
#
1341
# Structure de la table `z3950servers`
1342
#
1343
1344
CREATE TABLE z3950servers (
1345
  host varchar(255) default NULL,
1346
  port int(11) default NULL,
1347
  db varchar(255) default NULL,
1348
  userid varchar(255) default NULL,
1349
  password varchar(255) default NULL,
1350
  name text,
1351
  id int(11) NOT NULL auto_increment,
1352
  checked smallint(6) default NULL,
1353
  rank int(11) default NULL,
1354
  syntax varchar(80) default NULL,
1355
  PRIMARY KEY  (id)
1356
) TYPE=MyISAM;
1357
(-)a/t/data/db_schemas/kohastructure.sql-3.00.00-alpha-044 (-4 lines)
Lines 1-1895 Link Here
1
-- MySQL dump 10.9
2
--
3
-- Host: localhost    Database: koha30test
4
-- ------------------------------------------------------
(-)a/t/data/db_schemas/kohastructure.sql-3.00.00-beta-067 (-4 lines)
Lines 1-2029 Link Here
1
-- MySQL dump 10.9
2
--
3
-- Host: localhost    Database: koha30test
4
-- ------------------------------------------------------

Return to bug 10296