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 renewalsallowed smallint(6) default NULL,
742 rentalcharge double(16,4) default NULL,
743 notforloan smallint(6) default NULL,
744 UNIQUE KEY itemtype (itemtype)
746 # --------------------------------------------------------
749 # Structure de la table `marc_biblio`
752 CREATE TABLE marc_biblio (
753 bibid bigint(20) unsigned NOT NULL auto_increment,
754 biblionumber int(11) NOT NULL default '0',
755 datecreated date NOT NULL default '0000-00-00',
756 datemodified date default NULL,
757 origincode char(20) default NULL,
759 KEY origincode (origincode),
760 KEY biblionumber (biblionumber)
762 # --------------------------------------------------------
765 # Structure de la table `marc_blob_subfield`
768 CREATE TABLE marc_blob_subfield (
769 blobidlink bigint(20) NOT NULL auto_increment,
770 subfieldvalue longtext NOT NULL,
771 PRIMARY KEY (blobidlink)
773 # --------------------------------------------------------
776 # Structure de la table `marc_breeding`
779 CREATE TABLE marc_breeding (
780 id bigint(20) NOT NULL auto_increment,
781 file varchar(80) NOT NULL default '',
782 isbn varchar(10) NOT NULL default '',
783 title varchar(128) default NULL,
784 author varchar(80) default NULL,
786 encoding varchar(40) NOT NULL default '''''',
787 z3950random varchar(40) default NULL,
792 # --------------------------------------------------------
795 # Structure de la table `marc_subfield_structure`
798 CREATE TABLE marc_subfield_structure (
799 tagfield char(3) NOT NULL default '',
800 tagsubfield char(1) NOT NULL default '',
801 liblibrarian char(255) NOT NULL default '',
802 libopac char(255) NOT NULL default '',
803 repeatable tinyint(4) NOT NULL default '0',
804 mandatory tinyint(4) NOT NULL default '0',
805 kohafield char(40) default NULL,
806 tab tinyint(1) default NULL,
807 authorised_value char(10) default NULL,
808 thesaurus_category char(10) default NULL,
809 value_builder char(80) default NULL,
810 PRIMARY KEY (tagfield,tagsubfield),
811 KEY kohafield (kohafield),
814 # --------------------------------------------------------
817 # Structure de la table `marc_subfield_table`
820 CREATE TABLE marc_subfield_table (
821 subfieldid bigint(20) unsigned NOT NULL auto_increment,
822 bibid bigint(20) unsigned NOT NULL default '0',
823 tag char(3) NOT NULL default '',
824 tagorder tinyint(4) NOT NULL default '1',
825 tag_indicator char(2) NOT NULL default '',
826 subfieldcode char(1) NOT NULL default '',
827 subfieldorder tinyint(4) NOT NULL default '1',
828 subfieldvalue varchar(255) default NULL,
829 valuebloblink bigint(20) default NULL,
830 PRIMARY KEY (subfieldid),
833 KEY tag_indicator (tag_indicator),
834 KEY subfieldorder (subfieldorder),
835 KEY subfieldcode (subfieldcode),
836 KEY subfieldvalue (subfieldvalue),
837 KEY tagorder (tagorder)
839 # --------------------------------------------------------
842 # Structure de la table `marc_tag_structure`
845 CREATE TABLE marc_tag_structure (
846 tagfield char(3) NOT NULL default '',
847 liblibrarian char(255) NOT NULL default '',
848 libopac char(255) NOT NULL default '',
849 repeatable tinyint(4) NOT NULL default '0',
850 mandatory tinyint(4) NOT NULL default '0',
851 authorised_value char(10) default NULL,
852 PRIMARY KEY (tagfield)
854 # --------------------------------------------------------
857 # Structure de la table `marc_word`
860 CREATE TABLE marc_word (
861 bibid bigint(20) NOT NULL default '0',
862 tag char(3) NOT NULL default '',
863 tagorder tinyint(4) NOT NULL default '1',
864 subfieldid char(1) NOT NULL default '',
865 subfieldorder tinyint(4) NOT NULL default '1',
866 word varchar(255) NOT NULL default '',
867 sndx_word varchar(255) NOT NULL default '',
870 KEY tagorder (tagorder),
871 KEY subfieldid (subfieldid),
872 KEY subfieldorder (subfieldorder),
874 KEY sndx_word (sndx_word)
876 # --------------------------------------------------------
879 # Structure de la table `marcrecorddone`
882 CREATE TABLE marcrecorddone (
883 isbn char(40) default NULL,
884 issn char(40) default NULL,
885 lccn char(40) default NULL,
886 controlnumber char(40) default NULL
888 # --------------------------------------------------------
891 # Structure de la table `printers`
894 CREATE TABLE printers (
895 printername char(40) NOT NULL default '''''',
896 printqueue char(20) default NULL,
897 printtype char(20) default NULL,
898 PRIMARY KEY (printername)
900 # --------------------------------------------------------
903 # Structure de la table `reserveconstraints`
906 CREATE TABLE reserveconstraints (
907 borrowernumber int(11) NOT NULL default '0',
908 reservedate date NOT NULL default '0000-00-00',
909 biblionumber int(11) NOT NULL default '0',
910 biblioitemnumber int(11) default NULL,
911 timestamp timestamp(14) NOT NULL
913 # --------------------------------------------------------
916 # Structure de la table `reserves`
919 CREATE TABLE reserves (
920 borrowernumber int(11) NOT NULL default '0',
921 reservedate date NOT NULL default '0000-00-00',
922 biblionumber int(11) NOT NULL default '0',
923 constrainttype char(1) default NULL,
924 branchcode varchar(4) default NULL,
925 notificationdate date default NULL,
926 reminderdate date default NULL,
927 cancellationdate date default NULL,
929 priority smallint(6) default NULL,
930 found char(1) default NULL,
931 timestamp timestamp(14) NOT NULL,
932 itemnumber int(11) default NULL
934 # --------------------------------------------------------
937 # Structure de la table `sessionqueries`
940 CREATE TABLE sessionqueries (
941 sessionID varchar(255) NOT NULL default '',
942 userid varchar(100) NOT NULL default '',
943 ip varchar(18) NOT NULL default '',
946 # --------------------------------------------------------
949 # Structure de la table `sessions`
952 CREATE TABLE sessions (
953 sessionID varchar(255) NOT NULL default '',
954 userid varchar(255) default NULL,
955 ip varchar(16) default NULL,
956 lasttime int(11) default NULL,
957 PRIMARY KEY (sessionID)
959 # --------------------------------------------------------
962 # Structure de la table `shelfcontents`
965 CREATE TABLE shelfcontents (
966 shelfnumber int(11) NOT NULL default '0',
967 itemnumber int(11) NOT NULL default '0',
968 flags int(11) default NULL
970 # --------------------------------------------------------
973 # Structure de la table `statistics`
976 CREATE TABLE statistics (
977 datetime datetime NOT NULL default '0000-00-00 00:00:00',
978 branch varchar(4) default NULL,
979 proccode varchar(4) default NULL,
980 value double(16,4) default NULL,
981 type varchar(16) default NULL,
983 usercode varchar(10) default NULL,
984 itemnumber int(11) default NULL,
985 itemtype varchar(4) default NULL,
986 borrowernumber int(11) default NULL,
987 KEY timeidx (datetime)
989 # --------------------------------------------------------
992 # Structure de la table `stopwords`
995 CREATE TABLE stopwords (
996 word varchar(255) default NULL
998 # --------------------------------------------------------
1001 # Structure de la table `systempreferences`
1004 CREATE TABLE systempreferences (
1005 variable varchar(50) NOT NULL default '',
1006 value varchar(200) default NULL,
1008 explanation varchar(80) default NULL,
1009 type varchar(20) default NULL,
1010 PRIMARY KEY (variable)
1012 # --------------------------------------------------------
1015 # Structure de la table `uploadedmarc`
1018 CREATE TABLE uploadedmarc (
1019 id int(11) NOT NULL auto_increment,
1021 hidden smallint(6) default NULL,
1022 name varchar(255) default NULL,
1025 # --------------------------------------------------------
1028 # Structure de la table `userflags`
1031 CREATE TABLE userflags (
1032 bit int(11) NOT NULL default '0',
1033 flag char(30) default NULL,
1034 flagdesc char(255) default NULL,
1035 defaulton int(11) default NULL
1037 # --------------------------------------------------------
1040 # Structure de la table `users`
1043 CREATE TABLE users (
1044 usercode varchar(10) default NULL,
1047 level smallint(6) default NULL
1049 # --------------------------------------------------------
1052 # Structure de la table `websites`
1055 CREATE TABLE websites (
1056 websitenumber int(11) NOT NULL auto_increment,
1057 biblionumber int(11) NOT NULL default '0',
1060 url varchar(255) default NULL,
1061 PRIMARY KEY (websitenumber)
1063 # --------------------------------------------------------
1066 # Structure de la table `z3950queue`
1069 CREATE TABLE z3950queue (
1070 id int(11) NOT NULL auto_increment,
1072 type varchar(10) default NULL,
1073 startdate int(11) default NULL,
1074 enddate int(11) default NULL,
1075 done smallint(6) default NULL,
1077 numrecords int(11) default NULL,
1079 identifier varchar(30) default NULL,
1082 # --------------------------------------------------------
1085 # Structure de la table `z3950results`
1088 CREATE TABLE z3950results (
1089 id int(11) NOT NULL auto_increment,
1090 queryid int(11) default NULL,
1091 server varchar(255) default NULL,
1092 startdate int(11) default NULL,
1093 enddate int(11) default NULL,
1095 numrecords int(11) default NULL,
1096 numdownloaded int(11) default NULL,
1097 highestseen int(11) default NULL,
1098 active smallint(6) default NULL,
1100 UNIQUE KEY query_server (queryid,server)
1102 # --------------------------------------------------------
1105 # Structure de la table `z3950servers`
1108 CREATE TABLE z3950servers (
1109 host varchar(255) default NULL,
1110 port int(11) default NULL,
1111 db varchar(255) default NULL,
1112 userid varchar(255) default NULL,
1113 password varchar(255) default NULL,
1115 id int(11) NOT NULL auto_increment,
1116 checked smallint(6) default NULL,
1117 rank int(11) default NULL,
1118 syntax varchar(80) default NULL,