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 `aqbasket`
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)
58 # --------------------------------------------------------
61 # Structure de la table `aqbookfund`
64 CREATE TABLE aqbookfund (
65 bookfundid varchar(5) NOT NULL default '''''',
67 bookfundgroup varchar(5) default NULL,
68 PRIMARY KEY (bookfundid)
70 # --------------------------------------------------------
73 # Structure de la table `aqbooksellers`
76 CREATE TABLE aqbooksellers (
77 id int(11) default NULL,
83 phone varchar(30) default NULL,
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,
95 contact varchar(100) default NULL,
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,
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
115 # --------------------------------------------------------
118 # Structure de la table `aqbudget`
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)
129 # --------------------------------------------------------
132 # Structure de la table `aqorderbreakdown`
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
142 # --------------------------------------------------------
145 # Structure de la table `aqorderdelivery`
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
155 # --------------------------------------------------------
158 # Structure de la table `aqorders`
161 CREATE TABLE aqorders (
162 ordernumber int(11) NOT NULL auto_increment,
163 biblionumber int(11) default NULL,
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,
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)
193 # --------------------------------------------------------
196 # Structure de la table `auth_header`
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)
208 # --------------------------------------------------------
211 # Structure de la table `auth_subfield_structure`
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)
229 # --------------------------------------------------------
232 # Structure de la table `auth_subfield_table`
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),
247 KEY subfieldcode (subfieldcode),
248 KEY subfieldvalue (subfieldvalue)
250 # --------------------------------------------------------
253 # Structure de la table `auth_tag_structure`
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)
266 # --------------------------------------------------------
269 # Structure de la table `auth_types`
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)
279 # --------------------------------------------------------
282 # Structure de la table `auth_word`
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 '',
293 KEY marc_search (tagsubfield,word),
295 KEY sndx_word (sndx_word)
297 # --------------------------------------------------------
300 # Structure de la table `authorised_values`
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,
311 # --------------------------------------------------------
314 # Structure de la table `biblio`
317 CREATE TABLE biblio (
318 biblionumber int(11) NOT NULL default '0',
323 serial tinyint(1) default NULL,
325 copyrightdate smallint(6) default NULL,
326 timestamp timestamp(14) NOT NULL,
328 PRIMARY KEY (biblionumber),
329 KEY blbnoidx (biblionumber)
331 # --------------------------------------------------------
334 # Structure de la table `biblio_framework`
337 CREATE TABLE biblio_framework (
338 frameworkcode char(4) NOT NULL default '',
339 frameworktext char(255) NOT NULL default '',
340 PRIMARY KEY (frameworkcode)
342 # --------------------------------------------------------
345 # Structure de la table `biblioanalysis`
348 CREATE TABLE biblioanalysis (
349 analyticaltitle text,
350 biblionumber int(11) NOT NULL default '0',
351 analyticalauthor text
353 # --------------------------------------------------------
356 # Structure de la table `biblioitems`
359 CREATE TABLE biblioitems (
360 biblioitemnumber int(11) NOT NULL default '0',
361 biblionumber int(11) NOT NULL default '0',
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,
378 size varchar(255) default NULL,
379 place varchar(255) default NULL,
380 lccn varchar(25) default NULL,
382 url varchar(255) default NULL,
383 PRIMARY KEY (biblioitemnumber),
384 KEY bibinoidx (biblioitemnumber),
385 KEY bibnoidx (biblionumber)
387 # --------------------------------------------------------
390 # Structure de la table `bibliosubject`
393 CREATE TABLE bibliosubject (
394 subject text NOT NULL,
395 biblionumber int(11) NOT NULL default '0'
397 # --------------------------------------------------------
400 # Structure de la table `bibliosubtitle`
403 CREATE TABLE bibliosubtitle (
404 subtitle text NOT NULL,
405 biblionumber int(11) NOT NULL default '0',
406 KEY bibsubidx (biblionumber)
408 # --------------------------------------------------------
411 # Structure de la table `bibliothesaurus`
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 '',
423 KEY freelib (freelib),
425 KEY category (category),
426 KEY hierarchy (hierarchy),
427 FULLTEXT KEY category_2 (category,freelib)
429 # --------------------------------------------------------
432 # Structure de la table `bookshelf`
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)
442 # --------------------------------------------------------
445 # Structure de la table `borexp`
448 CREATE TABLE borexp (
449 borrowernumber int(11) default NULL,
450 newexp date default NULL
452 # --------------------------------------------------------
455 # Structure de la table `borrowers`
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,
465 initials text NOT NULL,
466 streetaddress text NOT NULL,
473 altstreetaddress 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,
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,
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)
510 # --------------------------------------------------------
513 # Structure de la table `branchcategories`
516 CREATE TABLE branchcategories (
517 categorycode varchar(4) NOT NULL default '',
519 codedescription text,
520 PRIMARY KEY (categorycode)
522 # --------------------------------------------------------
525 # Structure de la table `branches`
528 CREATE TABLE branches (
529 branchcode varchar(4) NOT NULL default '',
530 branchname text NOT NULL,
537 issuing tinyint(4) default NULL,
538 UNIQUE KEY branchcode (branchcode)
540 # --------------------------------------------------------
543 # Structure de la table `branchrelations`
546 CREATE TABLE branchrelations (
547 branchcode varchar(4) default NULL,
548 categorycode varchar(4) default NULL
550 # --------------------------------------------------------
553 # Structure de la table `branchtransfers`
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,
564 # --------------------------------------------------------
567 # Structure de la table `catalogueentry`
570 CREATE TABLE catalogueentry (
571 catalogueentry text NOT NULL,
572 entrytype char(2) default NULL,
576 biblionumber int(11) default NULL
578 # --------------------------------------------------------
581 # Structure de la table `categories`
584 CREATE TABLE categories (
585 categorycode char(2) NOT NULL default '',
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)
598 # --------------------------------------------------------
601 # Structure de la table `currency`
604 CREATE TABLE currency (
605 currency varchar(10) default NULL,
606 rate float(7,5) default NULL
608 # --------------------------------------------------------
611 # Structure de la table `deletedbiblio`
614 CREATE TABLE deletedbiblio (
615 biblionumber int(11) NOT NULL default '0',
620 serial tinyint(1) default NULL,
622 copyrightdate smallint(6) default NULL,
623 timestamp timestamp(14) NOT NULL,
626 PRIMARY KEY (biblionumber),
627 KEY blbnoidx (biblionumber)
629 # --------------------------------------------------------
632 # Structure de la table `deletedbiblioitems`
635 CREATE TABLE deletedbiblioitems (
636 biblioitemnumber int(11) NOT NULL default '0',
637 biblionumber int(11) NOT NULL default '0',
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,
654 size varchar(255) default NULL,
655 lccn varchar(25) default NULL,
657 url varchar(255) default NULL,
658 PRIMARY KEY (biblioitemnumber),
659 KEY bibinoidx (biblioitemnumber),
660 KEY bibnoidx (biblionumber)
662 # --------------------------------------------------------
665 # Structure de la table `deletedborrowers`
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,
675 initials text NOT NULL,
676 streetaddress text NOT NULL,
682 altstreetaddress 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,
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,
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)
712 # --------------------------------------------------------
715 # Structure de la table `deleteditems`
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,
744 holdingbranch varchar(4) default NULL,
745 interim tinyint(1) default NULL,
746 timestamp timestamp(14) NOT NULL,
749 PRIMARY KEY (itemnumber),
750 UNIQUE KEY barcode (barcode),
751 KEY itembarcodeidx (barcode),
752 KEY itembinoidx (biblioitemnumber),
753 KEY itembibnoidx (biblionumber)
755 # --------------------------------------------------------
758 # Structure de la table `ethnicity`
761 CREATE TABLE ethnicity (
762 code varchar(10) NOT NULL default '',
763 name varchar(255) default NULL,
766 # --------------------------------------------------------
769 # Structure de la table `issues`
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)
787 # --------------------------------------------------------
790 # Structure de la table `issuingrules`
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)
809 # --------------------------------------------------------
812 # Structure de la 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,
841 holdingbranch varchar(4) default NULL,
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)
850 # --------------------------------------------------------
853 # Structure de la table `itemsprices`
856 CREATE TABLE itemsprices (
857 itemnumber int(11) default NULL,
858 price1 decimal(28,6) default NULL,
859 price2 decimal(28,6) default NULL
861 # --------------------------------------------------------
864 # Structure de la table `itemtypes`
867 CREATE TABLE itemtypes (
868 itemtype varchar(4) NOT NULL default '',
870 renewalsallowed smallint(6) default NULL,
871 rentalcharge double(16,4) default NULL,
872 notforloan smallint(6) default NULL,
873 UNIQUE KEY itemtype (itemtype)
875 # --------------------------------------------------------
878 # Structure de la table `marc_biblio`
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 '',
889 KEY origincode (origincode),
890 KEY biblionumber (biblionumber)
892 # --------------------------------------------------------
895 # Structure de la table `marc_blob_subfield`
898 CREATE TABLE marc_blob_subfield (
899 blobidlink bigint(20) NOT NULL auto_increment,
900 subfieldvalue longtext NOT NULL,
901 PRIMARY KEY (blobidlink)
903 # --------------------------------------------------------
906 # Structure de la table `marc_breeding`
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,
916 encoding varchar(40) NOT NULL default '''''',
917 z3950random varchar(40) default NULL,
922 # --------------------------------------------------------
925 # Structure de la table `marc_subfield_structure`
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)
949 # --------------------------------------------------------
952 # Structure de la table `marc_subfield_table`
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),
968 KEY tag_indicator (tag_indicator),
969 KEY subfieldorder (subfieldorder),
970 KEY subfieldcode (subfieldcode),
971 KEY subfieldvalue (subfieldvalue),
972 KEY tagorder (tagorder)
974 # --------------------------------------------------------
977 # Structure de la table `marc_tag_structure`
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)
990 # --------------------------------------------------------
993 # Structure de la table `marc_word`
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 '',
1004 KEY tagorder (tagorder),
1005 KEY subfieldorder (subfieldorder),
1007 KEY sndx_word (sndx_word),
1008 KEY Search_Marc (tagsubfield,word)
1010 # --------------------------------------------------------
1013 # Structure de la table `marcrecorddone`
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
1022 # --------------------------------------------------------
1025 # Structure de la table `printers`
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)
1034 # --------------------------------------------------------
1037 # Structure de la table `reserveconstraints`
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
1047 # --------------------------------------------------------
1050 # Structure de la table `reserves`
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,
1063 priority smallint(6) default NULL,
1064 found char(1) default NULL,
1065 timestamp timestamp(14) NOT NULL,
1066 itemnumber int(11) default NULL
1068 # --------------------------------------------------------
1071 # Structure de la table `serial`
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)
1083 # --------------------------------------------------------
1086 # Structure de la table `sessionqueries`
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 '',
1095 # --------------------------------------------------------
1098 # Structure de la table `sessions`
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)
1108 # --------------------------------------------------------
1111 # Structure de la table `shelfcontents`
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
1119 # --------------------------------------------------------
1122 # Structure de la table `statistics`
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,
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)
1138 # --------------------------------------------------------
1141 # Structure de la table `stopwords`
1144 CREATE TABLE stopwords (
1145 word varchar(255) default NULL
1147 # --------------------------------------------------------
1150 # Structure de la table `subscription`
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 '',
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)
1189 # --------------------------------------------------------
1192 # Structure de la table `subscriptionhistory`
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)
1207 # --------------------------------------------------------
1210 # Structure de la table `suggestions`
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 '',
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)
1234 # --------------------------------------------------------
1237 # Structure de la table `systempreferences`
1240 CREATE TABLE systempreferences (
1241 variable varchar(50) NOT NULL default '',
1244 explanation varchar(80) default NULL,
1245 type varchar(20) default NULL,
1246 PRIMARY KEY (variable)
1248 # --------------------------------------------------------
1251 # Structure de la table `uploadedmarc`
1254 CREATE TABLE uploadedmarc (
1255 id int(11) NOT NULL auto_increment,
1257 hidden smallint(6) default NULL,
1258 name varchar(255) default NULL,
1261 # --------------------------------------------------------
1264 # Structure de la table `userflags`
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
1273 # --------------------------------------------------------
1276 # Structure de la table `users`
1279 CREATE TABLE users (
1280 usercode varchar(10) default NULL,
1283 level smallint(6) default NULL
1285 # --------------------------------------------------------
1288 # Structure de la table `websites`
1291 CREATE TABLE websites (
1292 websitenumber int(11) NOT NULL auto_increment,
1293 biblionumber int(11) NOT NULL default '0',
1296 url varchar(255) default NULL,
1297 PRIMARY KEY (websitenumber)
1299 # --------------------------------------------------------
1302 # Structure de la table `z3950queue`
1305 CREATE TABLE z3950queue (
1306 id int(11) NOT NULL auto_increment,
1308 type varchar(10) default NULL,
1309 startdate int(11) default NULL,
1310 enddate int(11) default NULL,
1311 done smallint(6) default NULL,
1313 numrecords int(11) default NULL,
1315 identifier varchar(30) default NULL,
1318 # --------------------------------------------------------
1321 # Structure de la table `z3950results`
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,
1331 numrecords int(11) default NULL,
1332 numdownloaded int(11) default NULL,
1333 highestseen int(11) default NULL,
1334 active smallint(6) default NULL,
1336 UNIQUE KEY query_server (queryid,server)
1338 # --------------------------------------------------------
1341 # Structure de la table `z3950servers`
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,
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,