2 # Structure de la table `accountlines`
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,
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)
19 # --------------------------------------------------------
22 # Structure de la table `accountoffsets`
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
32 # --------------------------------------------------------
35 # Structure de la table `additionalauthors`
38 CREATE TABLE additionalauthors (
40 biblionumber int(11) NOT NULL default '0',
41 KEY bibidx (biblionumber)
43 # --------------------------------------------------------
46 # Structure de la table `aqbookfund`
49 CREATE TABLE aqbookfund (
50 bookfundid varchar(5) NOT NULL default '''''',
52 bookfundgroup varchar(5) default NULL,
53 PRIMARY KEY (bookfundid)
55 # --------------------------------------------------------
58 # Structure de la table `aqbooksellers`
61 CREATE TABLE aqbooksellers (
62 id int(11) default NULL,
68 phone varchar(30) default NULL,
71 currency char(3) NOT NULL default '',
72 deliverydays smallint(6) default NULL,
73 followupdays smallint(6) default NULL,
74 followupscancel smallint(6) default NULL,
80 contact varchar(100) default NULL,
82 url varchar(255) default NULL,
83 contpos varchar(100) default NULL,
84 contphone varchar(100) default NULL,
85 contfax varchar(100) default NULL,
86 contaltphone varchar(100) default NULL,
87 contemail varchar(100) default NULL,
89 active tinyint(4) default NULL,
90 listprice varchar(5) default NULL,
91 invoiceprice varchar(5) default NULL,
92 gstreg tinyint(4) default NULL,
93 listincgst tinyint(4) default NULL,
94 invoiceincgst tinyint(4) default NULL,
95 discount float(6,4) default NULL,
96 fax varchar(50) default NULL,
97 nocalc int(11) default NULL,
98 invoicedisc float(6,4) default NULL
100 # --------------------------------------------------------
103 # Structure de la table `aqbudget`
106 CREATE TABLE aqbudget (
107 bookfundid char(5) NOT NULL default '',
108 startdate date NOT NULL default '0000-00-00',
109 enddate date default NULL,
110 budgetamount decimal(13,2) default NULL,
111 aqbudgetid tinyint(4) NOT NULL auto_increment,
112 PRIMARY KEY (aqbudgetid)
114 # --------------------------------------------------------
117 # Structure de la table `aqorderbreakdown`
120 CREATE TABLE aqorderbreakdown (
121 ordernumber int(11) default NULL,
122 linenumber int(11) default NULL,
123 branchcode char(4) default NULL,
124 bookfundid char(5) NOT NULL default '',
125 allocation smallint(6) default NULL
127 # --------------------------------------------------------
130 # Structure de la table `aqorderdelivery`
133 CREATE TABLE aqorderdelivery (
134 ordernumber date NOT NULL default '0000-00-00',
135 deliverynumber smallint(6) NOT NULL default '0',
136 deliverydate varchar(18) default NULL,
137 qtydelivered smallint(6) default NULL,
138 deliverycomments text
140 # --------------------------------------------------------
143 # Structure de la table `aqorders`
146 CREATE TABLE aqorders (
147 ordernumber int(11) NOT NULL auto_increment,
148 biblionumber int(11) default NULL,
150 requisitionedby varchar(10) default NULL,
151 authorisedby varchar(10) default NULL,
152 booksellerid varchar(10) NOT NULL default '',
153 deliverydays smallint(6) default NULL,
154 followupdays smallint(6) default NULL,
155 numberfollowupsallowed smallint(6) default NULL,
156 numberfollowupssent smallint(6) default NULL,
157 entrydate date default NULL,
158 dateprinted date default NULL,
159 quantity smallint(6) default NULL,
160 currency char(3) default NULL,
161 listprice decimal(28,6) default NULL,
162 totalamount decimal(28,6) default NULL,
163 datereceived date default NULL,
164 booksellerinvoicenumber text,
165 freight decimal(28,6) default NULL,
166 unitprice decimal(28,6) default NULL,
167 quantityreceived smallint(6) default NULL,
169 cancelledby varchar(10) default NULL,
170 quantityreceiveddamaged smallint(6) default NULL,
171 datecancellationprinted date default NULL,
173 supplierreference text,
174 purchaseordernumber text,
175 subscription tinyint(1) default NULL,
176 subscriptionfrom date default NULL,
177 subscriptionto date default NULL,
178 serialid varchar(30) default NULL,
179 basketno int(11) default NULL,
180 biblioitemnumber int(11) default NULL,
181 timestamp timestamp(14) NOT NULL,
182 rrp decimal(13,2) default NULL,
183 ecost decimal(13,2) default NULL,
184 gst decimal(13,2) default NULL,
185 budgetdate date default NULL,
186 PRIMARY KEY (ordernumber)
188 # --------------------------------------------------------
191 # Structure de la table `authorised_values`
194 CREATE TABLE authorised_values (
195 id int(11) NOT NULL auto_increment,
196 category char(10) NOT NULL default '',
197 authorised_value char(80) NOT NULL default '',
198 lib char(80) default NULL,
202 # --------------------------------------------------------
205 # Structure de la table `biblio`
208 CREATE TABLE biblio (
209 biblionumber int(11) NOT NULL default '0',
214 serial tinyint(1) default NULL,
216 copyrightdate smallint(6) default NULL,
217 timestamp timestamp(14) NOT NULL,
219 PRIMARY KEY (biblionumber),
220 KEY blbnoidx (biblionumber)
222 # --------------------------------------------------------
225 # Structure de la table `biblioanalysis`
228 CREATE TABLE biblioanalysis (
229 analyticaltitle text,
230 biblionumber int(11) NOT NULL default '0',
231 analyticalauthor text
233 # --------------------------------------------------------
236 # Structure de la table `biblioitems`
239 CREATE TABLE biblioitems (
240 biblioitemnumber int(11) NOT NULL default '0',
241 biblionumber int(11) NOT NULL default '0',
244 classification varchar(25) default NULL,
245 itemtype varchar(4) default NULL,
246 isbn varchar(14) default NULL,
247 issn varchar(9) default NULL,
248 dewey double(8,6) default NULL,
249 subclass char(3) default NULL,
250 publicationyear smallint(6) default NULL,
251 publishercode varchar(255) default NULL,
252 volumedate date default NULL,
253 volumeddesc varchar(255) default NULL,
254 timestamp timestamp(14) NOT NULL,
255 illus varchar(255) default NULL,
256 pages varchar(255) default NULL,
258 size varchar(255) default NULL,
259 place varchar(255) default NULL,
260 lccn varchar(25) default NULL,
262 url varchar(255) default NULL,
263 PRIMARY KEY (biblioitemnumber),
264 KEY bibinoidx (biblioitemnumber),
265 KEY bibnoidx (biblionumber)
267 # --------------------------------------------------------
270 # Structure de la table `bibliosubject`
273 CREATE TABLE bibliosubject (
274 subject text NOT NULL,
275 biblionumber int(11) NOT NULL default '0'
277 # --------------------------------------------------------
280 # Structure de la table `bibliosubtitle`
283 CREATE TABLE bibliosubtitle (
284 subtitle text NOT NULL,
285 biblionumber int(11) NOT NULL default '0',
286 KEY bibsubidx (biblionumber)
288 # --------------------------------------------------------
291 # Structure de la table `bibliothesaurus`
294 CREATE TABLE bibliothesaurus (
295 id bigint(20) NOT NULL auto_increment,
296 freelib char(255) NOT NULL default '',
297 stdlib char(255) NOT NULL default '',
298 category char(10) NOT NULL default '',
299 level tinyint(4) NOT NULL default '1',
300 hierarchy char(80) NOT NULL default '',
301 father char(80) NOT NULL default '',
303 KEY freelib (freelib),
305 KEY category (category),
306 KEY hierarchy (hierarchy),
307 FULLTEXT KEY category_2 (category,freelib)
309 # --------------------------------------------------------
312 # Structure de la table `bookshelf`
315 CREATE TABLE bookshelf (
316 shelfnumber int(11) NOT NULL auto_increment,
317 shelfname char(255) default NULL,
318 PRIMARY KEY (shelfnumber)
320 # --------------------------------------------------------
323 # Structure de la table `borexp`
326 CREATE TABLE borexp (
327 borrowernumber int(11) default NULL,
328 newexp date default NULL
330 # --------------------------------------------------------
333 # Structure de la table `borrowers`
336 CREATE TABLE borrowers (
337 borrowernumber int(11) NOT NULL auto_increment,
338 cardnumber varchar(16) NOT NULL default '',
339 surname text NOT NULL,
340 firstname text NOT NULL,
343 initials text NOT NULL,
344 streetaddress text NOT NULL,
351 altstreetaddress text,
355 dateofbirth date default NULL,
356 branchcode varchar(4) NOT NULL default '',
357 categorycode char(2) default NULL,
358 dateenrolled date default NULL,
359 gonenoaddress tinyint(1) default NULL,
360 lost tinyint(1) default NULL,
361 debarred tinyint(1) default NULL,
366 guarantor int(11) default NULL,
367 area char(2) default NULL,
368 ethnicity varchar(50) default NULL,
369 ethnotes varchar(255) default NULL,
370 sex char(1) default NULL,
371 expiry date default NULL,
372 altnotes varchar(255) default NULL,
373 altrelationship varchar(100) default NULL,
375 phoneday varchar(50) default NULL,
376 preferredcont char(1) default NULL,
377 physstreet varchar(100) default NULL,
378 password varchar(30) default NULL,
379 flags int(11) default NULL,
380 userid varchar(30) default NULL,
381 homezipcode varchar(25) default NULL,
382 zipcode varchar(25) default NULL,
383 UNIQUE KEY cardnumber (cardnumber),
384 KEY borrowernumber (borrowernumber)
386 # --------------------------------------------------------
389 # Structure de la table `branchcategories`
392 CREATE TABLE branchcategories (
393 categorycode varchar(4) NOT NULL default '',
395 codedescription text,
396 PRIMARY KEY (categorycode)
398 # --------------------------------------------------------
401 # Structure de la table `branches`
404 CREATE TABLE branches (
405 branchcode varchar(4) NOT NULL default '',
406 branchname text NOT NULL,
413 issuing tinyint(4) default NULL,
414 UNIQUE KEY branchcode (branchcode)
416 # --------------------------------------------------------
419 # Structure de la table `branchrelations`
422 CREATE TABLE branchrelations (
423 branchcode varchar(4) default NULL,
424 categorycode varchar(4) default NULL
426 # --------------------------------------------------------
429 # Structure de la table `branchtransfers`
432 CREATE TABLE branchtransfers (
433 itemnumber int(11) NOT NULL default '0',
434 datesent datetime default NULL,
435 frombranch varchar(4) default NULL,
436 datearrived datetime default NULL,
437 tobranch varchar(4) default NULL,
440 # --------------------------------------------------------
443 # Structure de la table `catalogueentry`
446 CREATE TABLE catalogueentry (
447 catalogueentry text NOT NULL,
448 entrytype char(2) default NULL,
452 biblionumber int(11) default NULL
454 # --------------------------------------------------------
457 # Structure de la table `categories`
460 CREATE TABLE categories (
461 categorycode char(2) NOT NULL default '',
463 enrolmentperiod smallint(6) default NULL,
464 upperagelimit smallint(6) default NULL,
465 dateofbirthrequired tinyint(1) default NULL,
466 finetype varchar(30) default NULL,
467 bulk tinyint(1) default NULL,
468 enrolmentfee decimal(28,6) default NULL,
469 overduenoticerequired tinyint(1) default NULL,
470 issuelimit smallint(6) default NULL,
471 reservefee decimal(28,6) default NULL,
472 UNIQUE KEY categorycode (categorycode)
474 # --------------------------------------------------------
477 # Structure de la table `categoryitem`
480 CREATE TABLE categoryitem (
481 categorycode char(2) NOT NULL default '',
482 itemtype varchar(4) NOT NULL default '',
483 restrictedtype tinyint(1) default NULL,
484 rentaldiscount decimal(28,6) default NULL,
485 reservecharge decimal(28,6) default NULL,
486 fine decimal(28,6) default NULL,
487 firstremind int(11) default NULL,
488 chargeperiod int(11) default NULL,
489 accountsent int(11) default NULL,
490 chargename varchar(100) default NULL
492 # --------------------------------------------------------
495 # Structure de la table `currency`
498 CREATE TABLE currency (
499 currency varchar(10) default NULL,
500 rate float(7,5) default NULL
502 # --------------------------------------------------------
505 # Structure de la table `deletedbiblio`
508 CREATE TABLE deletedbiblio (
509 biblionumber int(11) NOT NULL default '0',
514 serial tinyint(1) default NULL,
516 copyrightdate smallint(6) default NULL,
517 timestamp timestamp(14) NOT NULL,
520 PRIMARY KEY (biblionumber),
521 KEY blbnoidx (biblionumber)
523 # --------------------------------------------------------
526 # Structure de la table `deletedbiblioitems`
529 CREATE TABLE deletedbiblioitems (
530 biblioitemnumber int(11) NOT NULL default '0',
531 biblionumber int(11) NOT NULL default '0',
534 classification varchar(25) default NULL,
535 itemtype varchar(4) default NULL,
536 isbn varchar(14) default NULL,
537 issn varchar(9) default NULL,
538 dewey double(8,6) default NULL,
539 subclass char(3) default NULL,
540 publicationyear smallint(6) default NULL,
541 publishercode varchar(255) default NULL,
542 volumedate date default NULL,
543 volumeddesc varchar(255) default NULL,
544 timestamp timestamp(14) NOT NULL,
545 illus varchar(255) default NULL,
546 pages varchar(255) default NULL,
548 size varchar(255) default NULL,
549 lccn varchar(25) default NULL,
551 url varchar(255) default NULL,
552 PRIMARY KEY (biblioitemnumber),
553 KEY bibinoidx (biblioitemnumber),
554 KEY bibnoidx (biblionumber)
556 # --------------------------------------------------------
559 # Structure de la table `deletedborrowers`
562 CREATE TABLE deletedborrowers (
563 borrowernumber int(11) NOT NULL default '0',
564 cardnumber varchar(9) NOT NULL default '',
565 surname text NOT NULL,
566 firstname text NOT NULL,
569 initials text NOT NULL,
570 streetaddress text NOT NULL,
576 altstreetaddress text,
580 dateofbirth date default NULL,
581 branchcode varchar(4) NOT NULL default '',
582 categorycode char(2) default NULL,
583 dateenrolled date default NULL,
584 gonenoaddress tinyint(1) default NULL,
585 lost tinyint(1) default NULL,
586 debarred tinyint(1) default NULL,
591 guarantor int(11) default NULL,
592 area char(2) default NULL,
593 ethnicity varchar(50) default NULL,
594 ethnotes varchar(255) default NULL,
595 sex char(1) default NULL,
596 expiry date default NULL,
597 altnotes varchar(255) default NULL,
598 altrelationship varchar(100) default NULL,
600 phoneday varchar(50) default NULL,
601 preferredcont varchar(100) default NULL,
602 physstreet varchar(100) default NULL,
603 KEY borrowernumber (borrowernumber),
604 KEY cardnumber (cardnumber)
606 # --------------------------------------------------------
609 # Structure de la table `deleteditems`
612 CREATE TABLE deleteditems (
613 itemnumber int(11) NOT NULL default '0',
614 biblionumber int(11) NOT NULL default '0',
615 multivolumepart varchar(30) default NULL,
616 biblioitemnumber int(11) NOT NULL default '0',
617 barcode varchar(9) NOT NULL default '',
618 dateaccessioned date default NULL,
619 booksellerid varchar(10) default NULL,
620 homebranch varchar(4) default NULL,
621 price decimal(28,6) default NULL,
622 replacementprice decimal(28,6) default NULL,
623 replacementpricedate date default NULL,
624 datelastborrowed date default NULL,
625 datelastseen date default NULL,
626 multivolume tinyint(1) default NULL,
627 stack tinyint(1) default NULL,
628 notforloan tinyint(1) default NULL,
629 itemlost tinyint(1) default NULL,
630 wthdrawn tinyint(1) default NULL,
631 bulk varchar(30) default NULL,
632 issues smallint(6) default NULL,
633 renewals smallint(6) default NULL,
634 reserves smallint(6) default NULL,
635 restricted tinyint(1) default NULL,
636 binding decimal(28,6) default NULL,
638 holdingbranch varchar(4) default NULL,
639 interim tinyint(1) default NULL,
640 timestamp timestamp(14) NOT NULL,
643 PRIMARY KEY (itemnumber),
644 UNIQUE KEY barcode (barcode),
645 KEY itembarcodeidx (barcode),
646 KEY itembinoidx (biblioitemnumber),
647 KEY itembibnoidx (biblionumber)
649 # --------------------------------------------------------
652 # Structure de la table `ethnicity`
655 CREATE TABLE ethnicity (
656 code varchar(10) NOT NULL default '',
657 name varchar(255) default NULL,
660 # --------------------------------------------------------
663 # Structure de la table `issues`
666 CREATE TABLE issues (
667 borrowernumber int(11) NOT NULL default '0',
668 itemnumber int(11) NOT NULL default '0',
669 date_due date default NULL,
670 branchcode char(4) default NULL,
671 issuingbranch char(18) default NULL,
672 returndate date default NULL,
673 lastreneweddate date default NULL,
674 return char(4) default NULL,
675 renewals tinyint(4) default NULL,
676 timestamp timestamp(14) NOT NULL,
677 KEY issuesborridx (borrowernumber),
678 KEY issuesitemidx (itemnumber),
679 KEY bordate (borrowernumber,timestamp)
681 # --------------------------------------------------------
684 # Structure de la table `items`
688 itemnumber int(11) NOT NULL default '0',
689 biblionumber int(11) NOT NULL default '0',
690 multivolumepart varchar(30) default NULL,
691 biblioitemnumber int(11) NOT NULL default '0',
692 barcode varchar(20) default NULL,
693 dateaccessioned date default NULL,
694 booksellerid varchar(10) default NULL,
695 homebranch varchar(4) default NULL,
696 price decimal(8,2) default NULL,
697 replacementprice decimal(8,2) default NULL,
698 replacementpricedate date default NULL,
699 datelastborrowed date default NULL,
700 datelastseen date default NULL,
701 multivolume tinyint(1) default NULL,
702 stack tinyint(1) default NULL,
703 notforloan tinyint(1) default NULL,
704 itemlost tinyint(1) default NULL,
705 wthdrawn tinyint(1) default NULL,
706 bulk varchar(30) default NULL,
707 issues smallint(6) default NULL,
708 renewals smallint(6) default NULL,
709 reserves smallint(6) default NULL,
710 restricted tinyint(1) default NULL,
711 binding decimal(28,6) default NULL,
713 holdingbranch varchar(4) default NULL,
715 timestamp timestamp(14) NOT NULL,
716 PRIMARY KEY (itemnumber),
717 KEY itembarcodeidx (barcode),
718 KEY itembinoidx (biblioitemnumber),
719 KEY itembibnoidx (biblionumber)
721 # --------------------------------------------------------
724 # Structure de la table `itemsprices`
727 CREATE TABLE itemsprices (
728 itemnumber int(11) default NULL,
729 price1 decimal(28,6) default NULL,
730 price2 decimal(28,6) default NULL
732 # --------------------------------------------------------
735 # Structure de la table `itemtypes`
738 CREATE TABLE itemtypes (
739 itemtype varchar(4) NOT NULL default '',
741 loanlength smallint(6) default NULL,
742 renewalsallowed smallint(6) default NULL,
743 rentalcharge double(16,4) default NULL,
744 notforloan smallint(6) default NULL,
745 UNIQUE KEY itemtype (itemtype)
747 # --------------------------------------------------------
750 # Structure de la table `marc_biblio`
753 CREATE TABLE marc_biblio (
754 bibid bigint(20) unsigned NOT NULL auto_increment,
755 biblionumber int(11) NOT NULL default '0',
756 datecreated date NOT NULL default '0000-00-00',
757 datemodified date default NULL,
758 origincode char(20) default NULL,
760 KEY origincode (origincode),
761 KEY biblionumber (biblionumber)
763 # --------------------------------------------------------
766 # Structure de la table `marc_blob_subfield`
769 CREATE TABLE marc_blob_subfield (
770 blobidlink bigint(20) NOT NULL auto_increment,
771 subfieldvalue longtext NOT NULL,
772 PRIMARY KEY (blobidlink)
774 # --------------------------------------------------------
777 # Structure de la table `marc_breeding`
780 CREATE TABLE marc_breeding (
781 id bigint(20) NOT NULL auto_increment,
782 file varchar(80) NOT NULL default '',
783 isbn varchar(10) NOT NULL default '',
784 title varchar(128) default NULL,
785 author varchar(80) default NULL,
787 encoding varchar(40) NOT NULL default '''''',
788 z3950random varchar(40) default NULL,
793 # --------------------------------------------------------
796 # Structure de la table `marc_subfield_structure`
799 CREATE TABLE marc_subfield_structure (
800 tagfield char(3) NOT NULL default '',
801 tagsubfield char(1) NOT NULL default '',
802 liblibrarian char(255) NOT NULL default '',
803 libopac char(255) NOT NULL default '',
804 repeatable tinyint(4) NOT NULL default '0',
805 mandatory tinyint(4) NOT NULL default '0',
806 kohafield char(40) default NULL,
807 tab tinyint(1) default NULL,
808 authorised_value char(10) default NULL,
809 thesaurus_category char(10) default NULL,
810 value_builder char(80) default NULL,
811 PRIMARY KEY (tagfield,tagsubfield),
812 KEY kohafield (kohafield),
815 # --------------------------------------------------------
818 # Structure de la table `marc_subfield_table`
821 CREATE TABLE marc_subfield_table (
822 subfieldid bigint(20) unsigned NOT NULL auto_increment,
823 bibid bigint(20) unsigned NOT NULL default '0',
824 tag char(3) NOT NULL default '',
825 tagorder tinyint(4) NOT NULL default '1',
826 tag_indicator char(2) NOT NULL default '',
827 subfieldcode char(1) NOT NULL default '',
828 subfieldorder tinyint(4) NOT NULL default '1',
829 subfieldvalue varchar(255) default NULL,
830 valuebloblink bigint(20) default NULL,
831 PRIMARY KEY (subfieldid),
834 KEY tag_indicator (tag_indicator),
835 KEY subfieldorder (subfieldorder),
836 KEY subfieldcode (subfieldcode),
837 KEY subfieldvalue (subfieldvalue),
838 KEY tagorder (tagorder)
840 # --------------------------------------------------------
843 # Structure de la table `marc_tag_structure`
846 CREATE TABLE marc_tag_structure (
847 tagfield char(3) NOT NULL default '',
848 liblibrarian char(255) NOT NULL default '',
849 libopac char(255) NOT NULL default '',
850 repeatable tinyint(4) NOT NULL default '0',
851 mandatory tinyint(4) NOT NULL default '0',
852 authorised_value char(10) default NULL,
853 PRIMARY KEY (tagfield)
855 # --------------------------------------------------------
858 # Structure de la table `marc_word`
861 CREATE TABLE marc_word (
862 bibid bigint(20) NOT NULL default '0',
863 tag char(3) NOT NULL default '',
864 tagorder tinyint(4) NOT NULL default '1',
865 subfieldid char(1) NOT NULL default '',
866 subfieldorder tinyint(4) NOT NULL default '1',
867 word varchar(255) NOT NULL default '',
868 sndx_word varchar(255) NOT NULL default '',
871 KEY tagorder (tagorder),
872 KEY subfieldid (subfieldid),
873 KEY subfieldorder (subfieldorder),
875 KEY sndx_word (sndx_word)
877 # --------------------------------------------------------
880 # Structure de la table `marcrecorddone`
883 CREATE TABLE marcrecorddone (
884 isbn char(40) default NULL,
885 issn char(40) default NULL,
886 lccn char(40) default NULL,
887 controlnumber char(40) default NULL
889 # --------------------------------------------------------
892 # Structure de la table `printers`
895 CREATE TABLE printers (
896 printername char(40) NOT NULL default '''''',
897 printqueue char(20) default NULL,
898 printtype char(20) default NULL,
899 PRIMARY KEY (printername)
901 # --------------------------------------------------------
904 # Structure de la table `reserveconstraints`
907 CREATE TABLE reserveconstraints (
908 borrowernumber int(11) NOT NULL default '0',
909 reservedate date NOT NULL default '0000-00-00',
910 biblionumber int(11) NOT NULL default '0',
911 biblioitemnumber int(11) default NULL,
912 timestamp timestamp(14) NOT NULL
914 # --------------------------------------------------------
917 # Structure de la table `reserves`
920 CREATE TABLE reserves (
921 borrowernumber int(11) NOT NULL default '0',
922 reservedate date NOT NULL default '0000-00-00',
923 biblionumber int(11) NOT NULL default '0',
924 constrainttype char(1) default NULL,
925 branchcode varchar(4) default NULL,
926 notificationdate date default NULL,
927 reminderdate date default NULL,
928 cancellationdate date default NULL,
930 priority smallint(6) default NULL,
931 found char(1) default NULL,
932 timestamp timestamp(14) NOT NULL,
933 itemnumber int(11) default NULL
935 # --------------------------------------------------------
938 # Structure de la table `sessionqueries`
941 CREATE TABLE sessionqueries (
942 sessionID varchar(255) NOT NULL default '',
943 userid varchar(100) NOT NULL default '',
944 ip varchar(18) NOT NULL default '',
947 # --------------------------------------------------------
950 # Structure de la table `sessions`
953 CREATE TABLE sessions (
954 sessionID varchar(255) NOT NULL default '',
955 userid varchar(255) default NULL,
956 ip varchar(16) default NULL,
957 lasttime int(11) default NULL,
958 PRIMARY KEY (sessionID)
960 # --------------------------------------------------------
963 # Structure de la table `shelfcontents`
966 CREATE TABLE shelfcontents (
967 shelfnumber int(11) NOT NULL default '0',
968 itemnumber int(11) NOT NULL default '0',
969 flags int(11) default NULL
971 # --------------------------------------------------------
974 # Structure de la table `statistics`
977 CREATE TABLE statistics (
978 datetime datetime NOT NULL default '0000-00-00 00:00:00',
979 branch varchar(4) default NULL,
980 proccode varchar(4) default NULL,
981 value double(16,4) default NULL,
982 type varchar(16) default NULL,
984 usercode varchar(10) default NULL,
985 itemnumber int(11) default NULL,
986 itemtype varchar(4) default NULL,
987 borrowernumber int(11) default NULL,
988 KEY timeidx (datetime)
990 # --------------------------------------------------------
993 # Structure de la table `stopwords`
996 CREATE TABLE stopwords (
997 word varchar(255) default NULL
999 # --------------------------------------------------------
1002 # Structure de la table `systempreferences`
1005 CREATE TABLE systempreferences (
1006 variable varchar(50) NOT NULL default '',
1007 value varchar(200) default NULL,
1009 explanation varchar(80) default NULL,
1010 type varchar(20) default NULL,
1011 PRIMARY KEY (variable)
1013 # --------------------------------------------------------
1016 # Structure de la table `uploadedmarc`
1019 CREATE TABLE uploadedmarc (
1020 id int(11) NOT NULL auto_increment,
1022 hidden smallint(6) default NULL,
1023 name varchar(255) default NULL,
1026 # --------------------------------------------------------
1029 # Structure de la table `userflags`
1032 CREATE TABLE userflags (
1033 bit int(11) NOT NULL default '0',
1034 flag char(30) default NULL,
1035 flagdesc char(255) default NULL,
1036 defaulton int(11) default NULL
1038 # --------------------------------------------------------
1041 # Structure de la table `users`
1044 CREATE TABLE users (
1045 usercode varchar(10) default NULL,
1048 level smallint(6) default NULL
1050 # --------------------------------------------------------
1053 # Structure de la table `websites`
1056 CREATE TABLE websites (
1057 websitenumber int(11) NOT NULL auto_increment,
1058 biblionumber int(11) NOT NULL default '0',
1061 url varchar(255) default NULL,
1062 PRIMARY KEY (websitenumber)
1064 # --------------------------------------------------------
1067 # Structure de la table `z3950queue`
1070 CREATE TABLE z3950queue (
1071 id int(11) NOT NULL auto_increment,
1073 type varchar(10) default NULL,
1074 startdate int(11) default NULL,
1075 enddate int(11) default NULL,
1076 done smallint(6) default NULL,
1078 numrecords int(11) default NULL,
1080 identifier varchar(30) default NULL,
1083 # --------------------------------------------------------
1086 # Structure de la table `z3950results`
1089 CREATE TABLE z3950results (
1090 id int(11) NOT NULL auto_increment,
1091 queryid int(11) default NULL,
1092 server varchar(255) default NULL,
1093 startdate int(11) default NULL,
1094 enddate int(11) default NULL,
1096 numrecords int(11) default NULL,
1097 numdownloaded int(11) default NULL,
1098 highestseen int(11) default NULL,
1099 active smallint(6) default NULL,
1101 UNIQUE KEY query_server (queryid,server)
1103 # --------------------------------------------------------
1106 # Structure de la table `z3950servers`
1109 CREATE TABLE z3950servers (
1110 host varchar(255) default NULL,
1111 port int(11) default NULL,
1112 db varchar(255) default NULL,
1113 userid varchar(255) default NULL,
1114 password varchar(255) default NULL,
1116 id int(11) NOT NULL auto_increment,
1117 checked smallint(6) default NULL,
1118 rank int(11) default NULL,
1119 syntax varchar(80) default NULL,