3 -- http://www.phpmyadmin.net
6 -- Généré le : Mardi 26 Juin 2007 à 15:21
7 -- Version du serveur: 5.0.37
8 -- Version de PHP: 5.2.1
12 -- --------------------------------------------------------
15 -- Structure de la table `accountlines`
18 CREATE TABLE `accountlines` (
19 `borrowernumber` int(11) NOT NULL default '0',
20 `accountno` smallint(6) NOT NULL default '0',
21 `itemnumber` int(11) default NULL,
22 `date` date default NULL,
23 `amount` decimal(28,6) default NULL,
24 `description` mediumtext,
26 `accounttype` varchar(5) default NULL,
27 `amountoutstanding` decimal(28,6) default NULL,
28 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
29 `notify_id` int(11) NOT NULL,
30 `notify_level` int(2) NOT NULL,
31 KEY `acctsborridx` (`borrowernumber`),
32 KEY `timeidx` (`timestamp`),
33 KEY `itemnumber` (`itemnumber`)
34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36 -- --------------------------------------------------------
39 -- Structure de la table `accountoffsets`
42 CREATE TABLE `accountoffsets` (
43 `borrowernumber` int(11) NOT NULL default '0',
44 `accountno` smallint(6) NOT NULL default '0',
45 `offsetaccount` smallint(6) NOT NULL default '0',
46 `offsetamount` decimal(28,6) default NULL,
47 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
48 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
50 -- --------------------------------------------------------
53 -- Structure de la table `action_logs`
56 CREATE TABLE `action_logs` (
57 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
58 `user` int(11) NOT NULL,
61 `object` int(11) default NULL,
63 PRIMARY KEY (`timestamp`,`user`)
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66 -- --------------------------------------------------------
69 -- Structure de la table `alert`
72 CREATE TABLE `alert` (
73 `alertid` int(11) NOT NULL auto_increment,
74 `borrowernumber` int(11) NOT NULL default '0',
75 `type` varchar(10) NOT NULL default '',
76 `externalid` varchar(20) NOT NULL default '',
77 PRIMARY KEY (`alertid`),
78 KEY `borrowernumber` (`borrowernumber`),
79 KEY `type` (`type`,`externalid`)
80 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
82 -- --------------------------------------------------------
85 -- Structure de la table `aqbasket`
88 CREATE TABLE `aqbasket` (
89 `basketno` int(11) NOT NULL auto_increment,
90 `creationdate` date default NULL,
91 `closedate` date default NULL,
92 `booksellerid` int(11) NOT NULL default '1',
93 `authorisedby` varchar(10) default NULL,
94 `booksellerinvoicenumber` mediumtext,
95 PRIMARY KEY (`basketno`),
96 KEY `booksellerid` (`booksellerid`)
97 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=182 ;
99 -- --------------------------------------------------------
102 -- Structure de la table `aqbookfund`
105 CREATE TABLE `aqbookfund` (
106 `bookfundid` varchar(5) NOT NULL default '''''',
107 `bookfundname` mediumtext,
108 `bookfundgroup` varchar(5) default NULL,
109 `branchcode` varchar(4) NOT NULL default '',
110 PRIMARY KEY (`bookfundid`,`branchcode`)
111 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
113 -- --------------------------------------------------------
116 -- Structure de la table `aqbooksellers`
119 CREATE TABLE `aqbooksellers` (
120 `id` int(11) NOT NULL auto_increment,
122 `address1` mediumtext,
123 `address2` mediumtext,
124 `address3` mediumtext,
125 `address4` mediumtext,
126 `phone` varchar(30) default NULL,
127 `accountnumber` mediumtext,
128 `othersupplier` mediumtext,
129 `currency` char(3) NOT NULL default '',
130 `deliverydays` smallint(6) default NULL,
131 `followupdays` smallint(6) default NULL,
132 `followupscancel` smallint(6) default NULL,
133 `specialty` mediumtext,
134 `booksellerfax` mediumtext,
136 `bookselleremail` mediumtext,
137 `booksellerurl` mediumtext,
138 `contact` varchar(100) default NULL,
140 `url` varchar(255) default NULL,
141 `contpos` varchar(100) default NULL,
142 `contphone` varchar(100) default NULL,
143 `contfax` varchar(100) default NULL,
144 `contaltphone` varchar(100) default NULL,
145 `contemail` varchar(100) default NULL,
146 `contnotes` mediumtext,
147 `active` tinyint(4) default NULL,
148 `listprice` varchar(10) default NULL,
149 `invoiceprice` varchar(10) default NULL,
150 `gstreg` tinyint(4) default NULL,
151 `listincgst` tinyint(4) default NULL,
152 `invoiceincgst` tinyint(4) default NULL,
153 `discount` float(6,4) default NULL,
154 `fax` varchar(50) default NULL,
155 `nocalc` int(11) default NULL,
156 `invoicedisc` float(6,4) default NULL,
158 KEY `listprice` (`listprice`),
159 KEY `invoiceprice` (`invoiceprice`)
160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=76 ;
162 -- --------------------------------------------------------
165 -- Structure de la table `aqbudget`
168 CREATE TABLE `aqbudget` (
169 `bookfundid` varchar(5) NOT NULL default '',
170 `startdate` date NOT NULL default '0000-00-00',
171 `enddate` date default NULL,
172 `budgetamount` decimal(13,2) default NULL,
173 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
174 `branchcode` varchar(4) default NULL,
175 PRIMARY KEY (`aqbudgetid`)
176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
178 -- --------------------------------------------------------
181 -- Structure de la table `aqorderbreakdown`
184 CREATE TABLE `aqorderbreakdown` (
185 `ordernumber` int(11) default NULL,
186 `linenumber` int(11) default NULL,
187 `branchcode` char(4) default NULL,
188 `bookfundid` char(5) NOT NULL default '',
189 `allocation` smallint(6) default NULL,
190 KEY `ordernumber` (`ordernumber`),
191 KEY `bookfundid` (`bookfundid`)
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
194 -- --------------------------------------------------------
197 -- Structure de la table `aqorderdelivery`
200 CREATE TABLE `aqorderdelivery` (
201 `ordernumber` date NOT NULL default '0000-00-00',
202 `deliverynumber` smallint(6) NOT NULL default '0',
203 `deliverydate` varchar(18) default NULL,
204 `qtydelivered` smallint(6) default NULL,
205 `deliverycomments` mediumtext
206 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
208 -- --------------------------------------------------------
211 -- Structure de la table `aqorders`
214 CREATE TABLE `aqorders` (
215 `ordernumber` int(11) NOT NULL auto_increment,
216 `biblionumber` int(11) default NULL,
218 `entrydate` date default NULL,
219 `quantity` smallint(6) default NULL,
220 `currency` char(3) default NULL,
221 `listprice` decimal(28,6) default NULL,
222 `totalamount` decimal(28,6) default NULL,
223 `datereceived` date default NULL,
224 `booksellerinvoicenumber` mediumtext,
225 `freight` decimal(28,6) default NULL,
226 `unitprice` decimal(28,6) default NULL,
227 `quantityreceived` smallint(6) default NULL,
228 `cancelledby` varchar(10) default NULL,
229 `datecancellationprinted` date default NULL,
231 `supplierreference` mediumtext,
232 `purchaseordernumber` mediumtext,
233 `subscription` tinyint(1) default NULL,
234 `serialid` varchar(30) default NULL,
235 `basketno` int(11) default NULL,
236 `biblioitemnumber` int(11) default NULL,
237 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
238 `rrp` decimal(13,2) default NULL,
239 `ecost` decimal(13,2) default NULL,
240 `gst` decimal(13,2) default NULL,
241 `budgetdate` date default NULL,
242 `sort1` varchar(80) default NULL,
243 `sort2` varchar(80) default NULL,
244 PRIMARY KEY (`ordernumber`),
245 KEY `basketno` (`basketno`),
246 KEY `biblionumber` (`biblionumber`)
247 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=618 ;
249 -- --------------------------------------------------------
252 -- Structure de la table `auth_header`
255 CREATE TABLE `auth_header` (
256 `authid` bigint(20) unsigned NOT NULL auto_increment,
257 `authtypecode` varchar(10) NOT NULL default '',
258 `datecreated` date NOT NULL default '0000-00-00',
259 `datemodified` date default NULL,
260 `origincode` varchar(20) default NULL,
261 `authtrees` mediumtext,
263 `linkid` bigint(20) default NULL,
264 `marcxml` longtext NOT NULL,
265 PRIMARY KEY (`authid`),
266 KEY `origincode` (`origincode`)
267 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=262156 ;
269 -- --------------------------------------------------------
272 -- Structure de la table `auth_subfield_structure`
275 CREATE TABLE `auth_subfield_structure` (
276 `authtypecode` char(10) NOT NULL default '',
277 `tagfield` char(3) NOT NULL default '',
278 `tagsubfield` char(1) NOT NULL default '',
279 `liblibrarian` char(255) NOT NULL default '',
280 `libopac` char(255) NOT NULL default '',
281 `repeatable` tinyint(4) NOT NULL default '0',
282 `mandatory` tinyint(4) NOT NULL default '0',
283 `tab` tinyint(1) default NULL,
284 `authorised_value` char(10) default NULL,
285 `value_builder` char(80) default NULL,
286 `seealso` char(255) default NULL,
287 `isurl` tinyint(1) default NULL,
288 `hidden` tinyint(3) NOT NULL default '0',
289 `linkid` tinyint(1) NOT NULL default '0',
290 `kohafield` varchar(45) NOT NULL default '',
291 `frameworkcode` varchar(8) NOT NULL,
292 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
293 KEY `tab` (`authtypecode`,`tab`)
294 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
296 -- --------------------------------------------------------
299 -- Structure de la table `auth_tag_structure`
302 CREATE TABLE `auth_tag_structure` (
303 `authtypecode` char(10) NOT NULL default '',
304 `tagfield` char(3) NOT NULL default '',
305 `liblibrarian` char(255) NOT NULL default '',
306 `libopac` char(255) NOT NULL default '',
307 `repeatable` tinyint(4) NOT NULL default '0',
308 `mandatory` tinyint(4) NOT NULL default '0',
309 `authorised_value` char(10) default NULL,
310 PRIMARY KEY (`authtypecode`,`tagfield`)
311 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
313 -- --------------------------------------------------------
316 -- Structure de la table `auth_types`
319 CREATE TABLE `auth_types` (
320 `authtypecode` varchar(10) NOT NULL default '',
321 `authtypetext` varchar(255) NOT NULL default '',
322 `auth_tag_to_report` char(3) NOT NULL default '',
323 `summary` mediumtext NOT NULL,
324 PRIMARY KEY (`authtypecode`)
325 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327 -- --------------------------------------------------------
330 -- Structure de la table `authorised_values`
333 CREATE TABLE `authorised_values` (
334 `id` int(11) NOT NULL auto_increment,
335 `category` char(10) NOT NULL default '',
336 `authorised_value` char(80) NOT NULL default '',
337 `lib` char(80) default NULL,
339 KEY `name` (`category`)
340 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3611 ;
342 -- --------------------------------------------------------
345 -- Structure de la table `biblio`
348 CREATE TABLE `biblio` (
349 `biblionumber` int(11) NOT NULL default '0',
350 `frameworkcode` varchar(4) NOT NULL,
353 `unititle` mediumtext,
355 `serial` tinyint(1) default NULL,
356 `seriestitle` mediumtext,
357 `copyrightdate` smallint(6) default NULL,
358 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
359 `abstract` mediumtext,
360 PRIMARY KEY (`biblionumber`),
361 KEY `blbnoidx` (`biblionumber`)
362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
364 -- --------------------------------------------------------
367 -- Structure de la table `biblio_framework`
370 CREATE TABLE `biblio_framework` (
371 `frameworkcode` char(4) NOT NULL default '',
372 `frameworktext` char(255) NOT NULL default '',
373 PRIMARY KEY (`frameworkcode`)
374 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
376 -- --------------------------------------------------------
379 -- Structure de la table `biblioitems`
382 CREATE TABLE `biblioitems` (
383 `biblioitemnumber` int(11) NOT NULL default '0',
384 `biblionumber` int(11) NOT NULL default '0',
387 `classification` varchar(25) default NULL,
388 `itemtype` varchar(4) default NULL,
389 `isbn` varchar(14) default NULL,
390 `issn` varchar(9) default NULL,
391 `dewey` varchar(30) default NULL,
392 `subclass` char(3) default NULL,
393 `publicationyear` smallint(6) default NULL,
394 `publishercode` varchar(255) default NULL,
395 `volumedate` date default NULL,
396 `volumeddesc` varchar(255) default NULL,
397 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
398 `illus` varchar(255) default NULL,
399 `pages` varchar(255) default NULL,
401 `size` varchar(255) default NULL,
402 `place` varchar(255) default NULL,
403 `lccn` varchar(25) default NULL,
405 `url` varchar(255) default NULL,
406 `lcsort` varchar(25) default NULL,
407 `ccode` varchar(4) default NULL,
408 `marcxml` longtext NOT NULL,
409 PRIMARY KEY (`biblioitemnumber`),
410 KEY `bibinoidx` (`biblioitemnumber`),
411 KEY `bibnoidx` (`biblionumber`),
413 KEY `publishercode` (`publishercode`)
414 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
416 -- --------------------------------------------------------
419 -- Structure de la table `bookshelf`
422 CREATE TABLE `bookshelf` (
423 `shelfnumber` int(11) NOT NULL auto_increment,
424 `shelfname` char(255) default NULL,
425 `owner` char(80) default NULL,
426 `category` char(1) default NULL,
427 PRIMARY KEY (`shelfnumber`)
428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;
430 -- --------------------------------------------------------
433 -- Structure de la table `borrowers`
436 CREATE TABLE `borrowers` (
437 `borrowernumber` int(11) NOT NULL auto_increment,
438 `cardnumber` varchar(16) default NULL,
439 `surname` mediumtext NOT NULL,
442 `othernames` mediumtext,
444 `streetnumber` char(10) default NULL,
445 `streettype` char(50) default NULL,
446 `address` mediumtext NOT NULL,
448 `city` mediumtext NOT NULL,
449 `zipcode` varchar(25) default NULL,
452 `mobile` varchar(50) default NULL,
456 `B_streetnumber` char(10) default NULL,
457 `B_streettype` char(50) default NULL,
458 `B_address` varchar(100) default NULL,
460 `B_zipcode` varchar(25) default NULL,
462 `B_phone` mediumtext,
463 `dateofbirth` date default NULL,
464 `branchcode` varchar(10) NOT NULL,
465 `categorycode` varchar(10) NOT NULL,
466 `dateenrolled` date default NULL,
467 `dateexpiry` date default NULL,
468 `gonenoaddress` tinyint(1) default NULL,
469 `lost` tinyint(1) default NULL,
470 `debarred` tinyint(1) default NULL,
471 `contactname` mediumtext,
472 `contactfirstname` text,
474 `guarantorid` int(11) default NULL,
475 `borrowernotes` mediumtext,
476 `relationship` varchar(100) default NULL,
477 `ethnicity` varchar(50) default NULL,
478 `ethnotes` varchar(255) default NULL,
479 `sex` char(1) default NULL,
480 `password` varchar(30) default NULL,
481 `flags` int(11) default NULL,
482 `userid` varchar(30) default NULL,
483 `opacnote` mediumtext,
484 `contactnote` varchar(255) default NULL,
485 `sort1` varchar(80) default NULL,
486 `sort2` varchar(80) default NULL,
487 UNIQUE KEY `cardnumber` (`cardnumber`),
488 KEY `borrowernumber` (`borrowernumber`),
489 KEY `categorycode` (`categorycode`),
490 KEY `branchcode` (`branchcode`)
491 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ;
493 -- --------------------------------------------------------
496 -- Structure de la table `branchcategories`
499 CREATE TABLE `branchcategories` (
500 `categorycode` varchar(4) NOT NULL default '',
501 `categoryname` mediumtext,
502 `codedescription` mediumtext,
503 PRIMARY KEY (`categorycode`)
504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
506 -- --------------------------------------------------------
509 -- Structure de la table `branches`
512 CREATE TABLE `branches` (
513 `branchcode` varchar(10) NOT NULL,
514 `branchname` mediumtext NOT NULL,
515 `branchaddress1` mediumtext,
516 `branchaddress2` mediumtext,
517 `branchaddress3` mediumtext,
518 `branchphone` mediumtext,
519 `branchfax` mediumtext,
520 `branchemail` mediumtext,
521 `issuing` tinyint(4) default NULL,
522 `branchip` varchar(15) default NULL,
523 `branchprinter` varchar(100) default NULL,
524 UNIQUE KEY `branchcode` (`branchcode`)
525 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
527 -- --------------------------------------------------------
530 -- Structure de la table `branchrelations`
533 CREATE TABLE `branchrelations` (
534 `branchcode` varchar(4) NOT NULL default '',
535 `categorycode` varchar(4) NOT NULL default '',
536 PRIMARY KEY (`branchcode`,`categorycode`),
537 KEY `branchcode` (`branchcode`),
538 KEY `categorycode` (`categorycode`)
539 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
541 -- --------------------------------------------------------
544 -- Structure de la table `branchtransfers`
547 CREATE TABLE `branchtransfers` (
548 `itemnumber` int(11) NOT NULL default '0',
549 `datesent` datetime default NULL,
550 `frombranch` varchar(10) NOT NULL,
551 `datearrived` datetime default NULL,
552 `tobranch` varchar(10) NOT NULL,
553 `comments` mediumtext,
554 KEY `frombranch` (`frombranch`),
555 KEY `tobranch` (`tobranch`),
556 KEY `itemnumber` (`itemnumber`)
557 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
559 -- --------------------------------------------------------
562 -- Structure de la table `browser`
565 CREATE TABLE `browser` (
566 `level` int(11) NOT NULL,
567 `classification` varchar(20) NOT NULL,
568 `description` varchar(255) NOT NULL,
569 `number` bigint(20) NOT NULL,
570 `endnode` tinyint(4) NOT NULL
571 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
573 -- --------------------------------------------------------
576 -- Structure de la table `catalogueentry`
579 CREATE TABLE `catalogueentry` (
580 `catalogueentry` mediumtext NOT NULL,
581 `entrytype` char(2) default NULL,
583 `seealso` mediumtext,
584 `seeinstead` mediumtext,
585 `biblionumber` int(11) default NULL,
586 KEY `entrytype` (`entrytype`,`catalogueentry`(250))
587 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
589 -- --------------------------------------------------------
592 -- Structure de la table `categories`
595 CREATE TABLE `categories` (
596 `categorycode` varchar(10) NOT NULL,
597 `description` mediumtext,
598 `enrolmentperiod` smallint(6) default NULL,
599 `upperagelimit` smallint(6) default NULL,
600 `dateofbirthrequired` tinyint(1) default NULL,
601 `finetype` varchar(30) default NULL,
602 `bulk` tinyint(1) default NULL,
603 `enrolmentfee` decimal(28,6) default NULL,
604 `overduenoticerequired` tinyint(1) default NULL,
605 `issuelimit` smallint(6) default NULL,
606 `reservefee` decimal(28,6) default NULL,
607 `category_type` char(1) NOT NULL default 'A',
608 PRIMARY KEY (`categorycode`),
609 UNIQUE KEY `categorycode` (`categorycode`)
610 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
612 -- --------------------------------------------------------
615 -- Structure de la table `categorytable`
618 CREATE TABLE `categorytable` (
619 `categorycode` char(5) NOT NULL default '',
620 `description` mediumtext,
621 `itemtypecodes` mediumtext,
622 PRIMARY KEY (`categorycode`)
623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
625 -- --------------------------------------------------------
628 -- Structure de la table `charges`
631 CREATE TABLE `charges` (
632 `charge_id` varchar(5) NOT NULL default '',
633 `description` mediumtext NOT NULL,
634 `amount` decimal(28,6) NOT NULL default '0.000000',
635 `min` int(4) NOT NULL default '0',
636 `max` int(4) NOT NULL default '0',
637 `level` int(1) NOT NULL default '0',
638 PRIMARY KEY (`charge_id`)
639 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
641 -- --------------------------------------------------------
644 -- Structure de la table `cities`
647 CREATE TABLE `cities` (
648 `cityid` int(11) NOT NULL auto_increment,
649 `city_name` char(100) NOT NULL,
650 `city_zipcode` char(20) default NULL,
651 PRIMARY KEY (`cityid`)
652 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
654 -- --------------------------------------------------------
657 -- Structure de la table `currency`
660 CREATE TABLE `currency` (
661 `currency` varchar(10) NOT NULL default '',
662 `rate` float(7,5) default NULL,
663 PRIMARY KEY (`currency`)
664 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
666 -- --------------------------------------------------------
669 -- Structure de la table `deletedbiblio`
672 CREATE TABLE `deletedbiblio` (
673 `biblionumber` int(11) NOT NULL default '0',
676 `unititle` mediumtext,
678 `serial` tinyint(1) default NULL,
679 `seriestitle` mediumtext,
680 `copyrightdate` smallint(6) default NULL,
681 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
683 `abstract` mediumtext,
684 `frameworkcode` varchar(4) NOT NULL,
685 PRIMARY KEY (`biblionumber`),
686 KEY `blbnoidx` (`biblionumber`)
687 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
689 -- --------------------------------------------------------
692 -- Structure de la table `deletedbiblioitems`
695 CREATE TABLE `deletedbiblioitems` (
696 `biblioitemnumber` int(11) NOT NULL default '0',
697 `biblionumber` int(11) NOT NULL default '0',
700 `classification` varchar(25) default NULL,
701 `itemtype` varchar(4) default NULL,
702 `isbn` varchar(14) default NULL,
703 `issn` varchar(9) default NULL,
704 `dewey` varchar(30) default NULL,
705 `subclass` char(3) default NULL,
706 `publicationyear` smallint(6) default NULL,
707 `publishercode` varchar(255) default NULL,
708 `volumedate` date default NULL,
709 `volumeddesc` varchar(255) default NULL,
710 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
711 `illus` varchar(255) default NULL,
712 `pages` varchar(255) default NULL,
714 `size` varchar(255) default NULL,
715 `lccn` varchar(25) default NULL,
717 `url` varchar(255) default NULL,
718 `place` varchar(255) default NULL,
719 `lcsort` varchar(25) default NULL,
720 `ccode` varchar(4) default NULL,
721 `marcxml` longtext NOT NULL,
722 PRIMARY KEY (`biblioitemnumber`),
723 KEY `bibinoidx` (`biblioitemnumber`),
724 KEY `bibnoidx` (`biblionumber`)
725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
727 -- --------------------------------------------------------
730 -- Structure de la table `deletedborrowers`
733 CREATE TABLE `deletedborrowers` (
734 `borrowernumber` int(11) NOT NULL default '0',
735 `cardnumber` varchar(9) NOT NULL default '',
736 `surname` mediumtext NOT NULL,
739 `othernames` mediumtext,
741 `streetnumber` char(10) default NULL,
742 `streettype` char(50) default NULL,
743 `address` mediumtext NOT NULL,
745 `city` mediumtext NOT NULL,
746 `zipcode` varchar(25) default NULL,
749 `mobile` varchar(50) default NULL,
753 `B_streetnumber` char(10) default NULL,
754 `B_streettype` char(50) default NULL,
755 `B_address` varchar(100) default NULL,
757 `B_zipcode` varchar(25) default NULL,
759 `B_phone` mediumtext,
760 `dateofbirth` date default NULL,
761 `branchcode` varchar(4) NOT NULL default '',
762 `categorycode` char(2) default NULL,
763 `dateenrolled` date default NULL,
764 `dateexpiry` date default NULL,
765 `gonenoaddress` tinyint(1) default NULL,
766 `lost` tinyint(1) default NULL,
767 `debarred` tinyint(1) default NULL,
768 `contactname` mediumtext,
769 `contactfirstname` text,
771 `guarantorid` int(11) default NULL,
772 `borrowernotes` mediumtext,
773 `relationship` varchar(100) default NULL,
774 `ethnicity` varchar(50) default NULL,
775 `ethnotes` varchar(255) default NULL,
776 `sex` char(1) default NULL,
777 `password` varchar(30) default NULL,
778 `flags` int(11) default NULL,
779 `userid` varchar(30) default NULL,
780 `opacnote` mediumtext,
781 `contactnote` varchar(255) default NULL,
782 `sort1` varchar(80) default NULL,
783 `sort2` varchar(80) default NULL,
784 KEY `borrowernumber` (`borrowernumber`),
785 KEY `cardnumber` (`cardnumber`)
786 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
788 -- --------------------------------------------------------
791 -- Structure de la table `deleteditems`
794 CREATE TABLE `deleteditems` (
795 `itemnumber` int(11) NOT NULL default '0',
796 `biblionumber` int(11) NOT NULL default '0',
797 `multivolumepart` varchar(30) default NULL,
798 `biblioitemnumber` int(11) NOT NULL default '0',
799 `barcode` varchar(20) NOT NULL,
800 `dateaccessioned` date default NULL,
801 `booksellerid` varchar(10) default NULL,
802 `homebranch` varchar(4) default NULL,
803 `price` decimal(28,6) default NULL,
804 `replacementprice` decimal(28,6) default NULL,
805 `replacementpricedate` date default NULL,
806 `datelastborrowed` date default NULL,
807 `datelastseen` date default NULL,
808 `multivolume` tinyint(1) default NULL,
809 `stack` tinyint(1) default NULL,
810 `notforloan` tinyint(1) default NULL,
811 `itemlost` tinyint(1) default NULL,
812 `wthdrawn` tinyint(1) default NULL,
813 `bulk` varchar(30) default NULL,
814 `issues` smallint(6) default NULL,
815 `renewals` smallint(6) default NULL,
816 `reserves` smallint(6) default NULL,
817 `restricted` tinyint(1) default NULL,
818 `binding` decimal(28,6) default NULL,
819 `itemnotes` mediumtext,
820 `holdingbranch` varchar(4) default NULL,
821 `interim` tinyint(1) default NULL,
822 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
824 `paidfor` mediumtext,
825 `location` varchar(80) default NULL,
826 `itemcallnumber` varchar(30) default NULL,
827 `onloan` date default '0000-00-00',
828 `cutterextra` varchar(45) default NULL,
829 `issue_date` date default NULL,
830 `itype` varchar(10) default NULL,
831 PRIMARY KEY (`itemnumber`),
832 UNIQUE KEY `barcode` (`barcode`),
833 KEY `itembarcodeidx` (`barcode`),
834 KEY `itembinoidx` (`biblioitemnumber`),
835 KEY `itembibnoidx` (`biblionumber`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
838 -- --------------------------------------------------------
841 -- Structure de la table `ethnicity`
844 CREATE TABLE `ethnicity` (
845 `code` varchar(10) NOT NULL default '',
846 `name` varchar(255) default NULL,
848 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
850 -- --------------------------------------------------------
853 -- Structure de la table `issues`
856 CREATE TABLE `issues` (
857 `borrowernumber` int(11) default NULL,
858 `itemnumber` int(11) default NULL,
859 `date_due` date default NULL,
860 `branchcode` varchar(10) default NULL,
861 `issuingbranch` char(18) default NULL,
862 `returndate` date default NULL,
863 `lastreneweddate` date default NULL,
864 `return` char(4) default NULL,
865 `renewals` tinyint(4) default NULL,
866 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
867 `issuedate` date NOT NULL default '0000-00-00',
868 KEY `issuesborridx` (`borrowernumber`),
869 KEY `issuesitemidx` (`itemnumber`),
870 KEY `bordate` (`borrowernumber`,`timestamp`)
871 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
873 -- --------------------------------------------------------
876 -- Structure de la table `issuingrules`
879 CREATE TABLE `issuingrules` (
880 `categorycode` char(2) NOT NULL default '',
881 `itemtype` varchar(4) NOT NULL default '',
882 `restrictedtype` tinyint(1) default NULL,
883 `rentaldiscount` decimal(28,6) default NULL,
884 `reservecharge` decimal(28,6) default NULL,
885 `fine` decimal(28,6) default NULL,
886 `firstremind` int(11) default NULL,
887 `chargeperiod` int(11) default NULL,
888 `accountsent` int(11) default NULL,
889 `chargename` varchar(100) default NULL,
890 `maxissueqty` int(4) default NULL,
891 `issuelength` int(4) default NULL,
892 `branchcode` varchar(4) NOT NULL default '',
893 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
894 KEY `itemtype` (`itemtype`),
895 KEY `categorycode` (`categorycode`)
896 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
898 -- --------------------------------------------------------
901 -- Structure de la table `items`
904 CREATE TABLE `items` (
905 `itemnumber` int(11) NOT NULL default '0',
906 `biblionumber` int(11) NOT NULL default '0',
907 `multivolumepart` varchar(30) default NULL,
908 `biblioitemnumber` int(11) NOT NULL default '0',
909 `barcode` varchar(20) default NULL,
910 `dateaccessioned` date default NULL,
911 `booksellerid` varchar(10) default NULL,
912 `homebranch` varchar(10) default NULL,
913 `price` decimal(8,2) default NULL,
914 `replacementprice` decimal(8,2) default NULL,
915 `replacementpricedate` date default NULL,
916 `datelastborrowed` date default NULL,
917 `datelastseen` date default NULL,
918 `multivolume` tinyint(1) default NULL,
919 `stack` tinyint(1) default NULL,
920 `notforloan` tinyint(1) default NULL,
921 `itemlost` tinyint(1) default NULL,
922 `wthdrawn` tinyint(1) default NULL,
923 `itemcallnumber` varchar(30) default NULL,
924 `issues` smallint(6) default NULL,
925 `renewals` smallint(6) default NULL,
926 `reserves` smallint(6) default NULL,
927 `restricted` tinyint(1) default NULL,
928 `binding` decimal(28,6) default NULL,
929 `itemnotes` mediumtext,
930 `holdingbranch` varchar(10) default NULL,
931 `paidfor` mediumtext,
932 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
933 `location` varchar(80) default NULL,
934 `onloan` date default '0000-00-00',
935 `cutterextra` varchar(45) default NULL,
936 `issue_date` date default NULL,
937 `itype` varchar(10) default NULL,
938 PRIMARY KEY (`itemnumber`),
939 KEY `itembarcodeidx` (`barcode`),
940 KEY `itembinoidx` (`biblioitemnumber`),
941 KEY `itembibnoidx` (`biblionumber`),
942 KEY `homebranch` (`homebranch`),
943 KEY `holdingbranch` (`holdingbranch`)
944 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
946 -- --------------------------------------------------------
949 -- Structure de la table `itemsprices`
952 CREATE TABLE `itemsprices` (
953 `itemnumber` int(11) default NULL,
954 `price1` decimal(28,6) default NULL,
955 `price2` decimal(28,6) default NULL
956 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
958 -- --------------------------------------------------------
961 -- Structure de la table `itemtypes`
964 CREATE TABLE `itemtypes` (
965 `itemtype` varchar(10) NOT NULL,
966 `description` mediumtext,
967 `renewalsallowed` smallint(6) default NULL,
968 `rentalcharge` double(16,4) default NULL,
969 `notforloan` smallint(6) default NULL,
970 `imageurl` char(200) default NULL,
972 PRIMARY KEY (`itemtype`),
973 UNIQUE KEY `itemtype` (`itemtype`)
974 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
976 -- --------------------------------------------------------
979 -- Structure de la table `labels`
982 CREATE TABLE `labels` (
983 `labelid` int(11) NOT NULL auto_increment,
984 `itemnumber` varchar(100) NOT NULL default '',
985 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
986 PRIMARY KEY (`labelid`)
987 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
989 -- --------------------------------------------------------
992 -- Structure de la table `labels_conf`
995 CREATE TABLE `labels_conf` (
996 `id` int(4) NOT NULL auto_increment,
997 `barcodetype` char(100) default '',
998 `title` tinyint(1) default '0',
999 `isbn` tinyint(1) default '0',
1000 `itemtype` tinyint(1) default '0',
1001 `barcode` tinyint(1) default '0',
1002 `dewey` tinyint(1) default '0',
1003 `class` tinyint(1) default '0',
1004 `author` tinyint(1) default '0',
1005 `papertype` char(100) default '',
1006 `startrow` int(2) default NULL,
1008 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1010 -- --------------------------------------------------------
1013 -- Structure de la table `letter`
1016 CREATE TABLE `letter` (
1017 `module` varchar(20) NOT NULL default '',
1018 `code` varchar(20) NOT NULL default '',
1019 `name` varchar(100) NOT NULL default '',
1020 `title` varchar(200) NOT NULL default '',
1021 `content` mediumtext,
1022 PRIMARY KEY (`module`,`code`)
1023 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1025 -- --------------------------------------------------------
1028 -- Structure de la table `marc_biblio`
1031 CREATE TABLE `marc_biblio` (
1032 `bibid` bigint(20) unsigned NOT NULL auto_increment,
1033 `biblionumber` int(11) NOT NULL default '0',
1034 `datecreated` date NOT NULL default '0000-00-00',
1035 `datemodified` date default NULL,
1036 `origincode` char(20) default NULL,
1037 `frameworkcode` char(4) NOT NULL default '',
1038 PRIMARY KEY (`bibid`),
1039 KEY `origincode` (`origincode`),
1040 KEY `biblionumber` (`biblionumber`)
1041 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1455122 ;
1043 -- --------------------------------------------------------
1046 -- Structure de la table `marc_breeding`
1049 CREATE TABLE `marc_breeding` (
1050 `id` bigint(20) NOT NULL auto_increment,
1051 `file` varchar(80) NOT NULL default '',
1052 `isbn` varchar(10) NOT NULL default '',
1053 `title` varchar(128) default NULL,
1054 `author` varchar(80) default NULL,
1056 `encoding` varchar(40) NOT NULL default '',
1057 `z3950random` varchar(40) default NULL,
1059 KEY `title` (`title`),
1061 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1063 -- --------------------------------------------------------
1066 -- Structure de la table `marc_subfield_structure`
1069 CREATE TABLE `marc_subfield_structure` (
1070 `tagfield` char(3) NOT NULL default '',
1071 `tagsubfield` char(1) NOT NULL default '',
1072 `liblibrarian` varchar(255) NOT NULL default '',
1073 `libopac` varchar(255) NOT NULL default '',
1074 `repeatable` tinyint(4) NOT NULL default '0',
1075 `mandatory` tinyint(4) NOT NULL default '0',
1076 `kohafield` varchar(40) default NULL,
1077 `tab` tinyint(1) default NULL,
1078 `authorised_value` varchar(10) default NULL,
1079 `authtypecode` varchar(10) default NULL,
1080 `value_builder` varchar(80) default NULL,
1081 `isurl` tinyint(1) default NULL,
1082 `hidden` tinyint(1) default NULL,
1083 `frameworkcode` varchar(4) NOT NULL default '',
1084 `seealso` varchar(255) default NULL,
1085 `link` varchar(80) default NULL,
1086 `defaultvalue` text,
1087 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1088 KEY `kohafield_2` (`kohafield`),
1089 KEY `tab` (`frameworkcode`,`tab`),
1090 KEY `kohafield` (`frameworkcode`,`kohafield`)
1091 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1093 -- --------------------------------------------------------
1096 -- Structure de la table `marc_tag_structure`
1099 CREATE TABLE `marc_tag_structure` (
1100 `tagfield` char(3) NOT NULL default '',
1101 `liblibrarian` char(255) NOT NULL default '',
1102 `libopac` char(255) NOT NULL default '',
1103 `repeatable` tinyint(4) NOT NULL default '0',
1104 `mandatory` tinyint(4) NOT NULL default '0',
1105 `authorised_value` char(10) default NULL,
1106 `frameworkcode` char(4) NOT NULL default '',
1107 PRIMARY KEY (`frameworkcode`,`tagfield`)
1108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1110 -- --------------------------------------------------------
1113 -- Structure de la table `notifys`
1116 CREATE TABLE `notifys` (
1117 `notify_id` int(11) NOT NULL default '0',
1118 `borrowernumber` int(11) NOT NULL default '0',
1119 `itemnumber` int(11) NOT NULL default '0',
1120 `notify_date` date NOT NULL default '0000-00-00',
1121 `notify_send_date` date default NULL,
1122 `notify_level` int(1) NOT NULL default '0',
1123 `method` varchar(20) NOT NULL default ''
1124 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1126 -- --------------------------------------------------------
1129 -- Structure de la table `opac_news`
1132 CREATE TABLE `opac_news` (
1133 `idnew` int(10) unsigned NOT NULL auto_increment,
1134 `title` varchar(250) NOT NULL default '',
1135 `new` mediumtext NOT NULL,
1136 `lang` varchar(4) NOT NULL default '',
1137 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1138 `expirationdate` date default NULL,
1139 `number` int(11) default NULL,
1140 PRIMARY KEY (`idnew`)
1141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
1143 -- --------------------------------------------------------
1146 -- Structure de la table `overduerules`
1149 CREATE TABLE `overduerules` (
1150 `branchcode` varchar(255) NOT NULL default '',
1151 `categorycode` char(2) NOT NULL default '',
1152 `delay1` int(4) default '0',
1153 `letter1` varchar(20) default NULL,
1154 `debarred1` char(1) default '0',
1155 `delay2` int(4) default '0',
1156 `debarred2` char(1) default '0',
1157 `letter2` varchar(20) default NULL,
1158 `delay3` int(4) default '0',
1159 `letter3` varchar(20) default NULL,
1160 `debarred3` int(1) default '0',
1161 PRIMARY KEY (`branchcode`,`categorycode`)
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1164 -- --------------------------------------------------------
1167 -- Structure de la table `printers`
1170 CREATE TABLE `printers` (
1171 `printername` char(40) NOT NULL default '''''',
1172 `printqueue` char(20) default NULL,
1173 `printtype` char(20) default NULL,
1174 PRIMARY KEY (`printername`)
1175 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1177 -- --------------------------------------------------------
1180 -- Structure de la table `repeatable_holidays`
1183 CREATE TABLE `repeatable_holidays` (
1184 `id` int(11) NOT NULL auto_increment,
1185 `branchcode` varchar(4) NOT NULL default '',
1186 `weekday` smallint(6) default NULL,
1187 `day` smallint(6) default NULL,
1188 `month` smallint(6) default NULL,
1189 `title` varchar(50) NOT NULL default '',
1190 `description` mediumtext NOT NULL,
1192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1194 -- --------------------------------------------------------
1197 -- Structure de la table `reserveconstraints`
1200 CREATE TABLE `reserveconstraints` (
1201 `borrowernumber` int(11) NOT NULL default '0',
1202 `reservedate` date NOT NULL default '0000-00-00',
1203 `biblionumber` int(11) NOT NULL default '0',
1204 `biblioitemnumber` int(11) default NULL,
1205 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1206 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1208 -- --------------------------------------------------------
1211 -- Structure de la table `reserves`
1214 CREATE TABLE `reserves` (
1215 `borrowernumber` int(11) NOT NULL default '0',
1216 `reservedate` date NOT NULL default '0000-00-00',
1217 `biblionumber` int(11) NOT NULL default '0',
1218 `constrainttype` char(1) default NULL,
1219 `branchcode` varchar(4) default NULL,
1220 `notificationdate` date default NULL,
1221 `reminderdate` date default NULL,
1222 `cancellationdate` date default NULL,
1223 `reservenotes` mediumtext,
1224 `priority` smallint(6) default NULL,
1225 `found` char(1) default NULL,
1226 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1227 `itemnumber` int(11) default NULL,
1228 `waitingdate` date default NULL,
1229 KEY `branchcode` (`branchcode`),
1230 KEY `borrowernumber` (`borrowernumber`),
1231 KEY `biblionumber` (`biblionumber`),
1232 KEY `itemnumber` (`itemnumber`)
1233 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1235 -- --------------------------------------------------------
1238 -- Structure de la table `reviews`
1241 CREATE TABLE `reviews` (
1242 `reviewid` int(11) NOT NULL auto_increment,
1243 `borrowernumber` int(11) default NULL,
1244 `biblionumber` int(11) default NULL,
1245 `review` mediumtext,
1246 `approved` tinyint(4) default NULL,
1247 `datereviewed` datetime default NULL,
1248 PRIMARY KEY (`reviewid`)
1249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1251 -- --------------------------------------------------------
1254 -- Structure de la table `roadtype`
1257 CREATE TABLE `roadtype` (
1258 `roadtypeid` int(11) NOT NULL auto_increment,
1259 `road_type` char(100) NOT NULL,
1260 PRIMARY KEY (`roadtypeid`)
1261 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1263 -- --------------------------------------------------------
1266 -- Structure de la table `serial`
1269 CREATE TABLE `serial` (
1270 `serialid` int(11) NOT NULL auto_increment,
1271 `biblionumber` varchar(100) NOT NULL default '',
1272 `subscriptionid` varchar(100) NOT NULL default '',
1273 `serialseq` varchar(100) NOT NULL default '',
1274 `status` tinyint(4) NOT NULL default '0',
1275 `planneddate` date NOT NULL default '0000-00-00',
1277 `publisheddate` date default NULL,
1279 `claimdate` date default NULL,
1280 `routingnotes` text,
1281 PRIMARY KEY (`serialid`)
1282 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2034 ;
1284 -- --------------------------------------------------------
1287 -- Structure de la table `sessionqueries`
1290 CREATE TABLE `sessionqueries` (
1291 `sessionID` varchar(255) NOT NULL default '',
1292 `userid` varchar(100) NOT NULL default '',
1293 `ip` varchar(18) NOT NULL default '',
1294 `url` mediumtext NOT NULL
1295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1297 -- --------------------------------------------------------
1300 -- Structure de la table `sessions`
1303 CREATE TABLE `sessions` (
1304 `sessionID` varchar(255) NOT NULL default '',
1305 `userid` varchar(255) default NULL,
1306 `ip` varchar(16) default NULL,
1307 `lasttime` int(11) default NULL,
1308 PRIMARY KEY (`sessionID`)
1309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1311 -- --------------------------------------------------------
1314 -- Structure de la table `shelfcontents`
1317 CREATE TABLE `shelfcontents` (
1318 `shelfnumber` int(11) NOT NULL default '0',
1319 `itemnumber` int(11) NOT NULL default '0',
1320 `flags` int(11) default NULL,
1321 `dateadded` timestamp NULL default NULL,
1322 KEY `shelfnumber` (`shelfnumber`),
1323 KEY `itemnumber` (`itemnumber`)
1324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1326 -- --------------------------------------------------------
1329 -- Structure de la table `special_holidays`
1332 CREATE TABLE `special_holidays` (
1333 `id` int(11) NOT NULL auto_increment,
1334 `branchcode` varchar(4) NOT NULL default '',
1335 `day` smallint(6) NOT NULL default '0',
1336 `month` smallint(6) NOT NULL default '0',
1337 `year` smallint(6) NOT NULL default '0',
1338 `isexception` smallint(1) NOT NULL default '1',
1339 `title` varchar(50) NOT NULL default '',
1340 `description` mediumtext NOT NULL,
1342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
1344 -- --------------------------------------------------------
1347 -- Structure de la table `statistics`
1350 CREATE TABLE `statistics` (
1351 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
1352 `branch` varchar(4) default NULL,
1353 `proccode` varchar(4) default NULL,
1354 `value` double(16,4) default NULL,
1355 `type` varchar(16) default NULL,
1357 `usercode` varchar(10) default NULL,
1358 `itemnumber` int(11) default NULL,
1359 `itemtype` varchar(4) default NULL,
1360 `borrowernumber` int(11) default NULL,
1361 `associatedborrower` int(11) default NULL,
1362 KEY `timeidx` (`datetime`)
1363 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1365 -- --------------------------------------------------------
1368 -- Structure de la table `stopwords`
1371 CREATE TABLE `stopwords` (
1372 `word` varchar(255) default NULL
1373 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1375 -- --------------------------------------------------------
1378 -- Structure de la table `subscription`
1381 CREATE TABLE `subscription` (
1382 `biblionumber` int(11) NOT NULL default '0',
1383 `subscriptionid` int(11) NOT NULL auto_increment,
1384 `librarian` varchar(100) default '',
1385 `startdate` date default '0000-00-00',
1386 `aqbooksellerid` int(11) default '0',
1387 `cost` int(11) default '0',
1388 `aqbudgetid` int(11) default '0',
1389 `weeklength` tinyint(4) default '0',
1390 `monthlength` tinyint(4) default '0',
1391 `numberlength` tinyint(4) default '0',
1392 `periodicity` tinyint(4) default '0',
1393 `dow` varchar(100) default '',
1394 `numberingmethod` varchar(100) default '',
1396 `status` varchar(100) NOT NULL default '',
1397 `add1` int(11) default '0',
1398 `every1` int(11) default '0',
1399 `whenmorethan1` int(11) default '0',
1400 `setto1` int(11) default NULL,
1401 `lastvalue1` int(11) default NULL,
1402 `add2` int(11) default '0',
1403 `every2` int(11) default '0',
1404 `whenmorethan2` int(11) default '0',
1405 `setto2` int(11) default NULL,
1406 `lastvalue2` int(11) default NULL,
1407 `add3` int(11) default '0',
1408 `every3` int(11) default '0',
1409 `innerloop1` int(11) default '0',
1410 `innerloop2` int(11) default '0',
1411 `innerloop3` int(11) default '0',
1412 `whenmorethan3` int(11) default '0',
1413 `setto3` int(11) default NULL,
1414 `lastvalue3` int(11) default NULL,
1415 `issuesatonce` tinyint(3) NOT NULL default '1',
1416 `firstacquidate` date NOT NULL,
1417 `manualhistory` tinyint(1) NOT NULL default '0',
1418 `irregularity` text,
1419 `letter` char(20) default NULL,
1420 `numberpattern` tinyint(3) default '0',
1421 `distributedto` text,
1422 `internalnotes` longtext,
1424 `branchcode` varchar(12) NOT NULL default '',
1425 `hemisphere` tinyint(3) default '0',
1426 PRIMARY KEY (`subscriptionid`)
1427 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=190 ;
1429 -- --------------------------------------------------------
1432 -- Structure de la table `subscriptionhistory`
1435 CREATE TABLE `subscriptionhistory` (
1436 `biblionumber` int(11) NOT NULL default '0',
1437 `subscriptionid` int(11) NOT NULL default '0',
1438 `histstartdate` date NOT NULL default '0000-00-00',
1439 `enddate` date default '0000-00-00',
1440 `missinglist` longtext NOT NULL,
1441 `recievedlist` longtext NOT NULL,
1442 `opacnote` varchar(150) NOT NULL default '',
1443 `librariannote` varchar(150) NOT NULL default '',
1444 PRIMARY KEY (`subscriptionid`),
1445 KEY `biblionumber` (`biblionumber`)
1446 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1448 -- --------------------------------------------------------
1451 -- Structure de la table `subscriptionroutinglist`
1454 CREATE TABLE `subscriptionroutinglist` (
1455 `routingid` int(11) NOT NULL auto_increment,
1456 `borrowernumber` int(11) default NULL,
1457 `ranking` int(11) default NULL,
1458 `subscriptionid` int(11) default NULL,
1459 PRIMARY KEY (`routingid`)
1460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1462 -- --------------------------------------------------------
1465 -- Structure de la table `suggestions`
1468 CREATE TABLE `suggestions` (
1469 `suggestionid` int(8) NOT NULL auto_increment,
1470 `suggestedby` int(11) NOT NULL default '0',
1471 `managedby` int(11) default NULL,
1472 `STATUS` varchar(10) NOT NULL default '',
1474 `author` varchar(80) default NULL,
1475 `title` varchar(80) default NULL,
1476 `copyrightdate` smallint(6) default NULL,
1477 `publishercode` varchar(255) default NULL,
1478 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1479 `volumedesc` varchar(255) default NULL,
1480 `publicationyear` smallint(6) default '0',
1481 `place` varchar(255) default NULL,
1482 `isbn` varchar(10) default NULL,
1483 `mailoverseeing` smallint(1) default '0',
1484 `biblionumber` int(11) default NULL,
1486 PRIMARY KEY (`suggestionid`),
1487 KEY `suggestedby` (`suggestedby`),
1488 KEY `managedby` (`managedby`)
1489 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=349 ;
1491 -- --------------------------------------------------------
1494 -- Structure de la table `systempreferences`
1497 CREATE TABLE `systempreferences` (
1498 `variable` varchar(50) NOT NULL default '',
1500 `options` mediumtext,
1502 `type` varchar(20) default NULL,
1503 PRIMARY KEY (`variable`)
1504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1506 -- --------------------------------------------------------
1509 -- Structure de la table `tags`
1512 CREATE TABLE `tags` (
1513 `entry` varchar(255) NOT NULL default '',
1514 `weight` bigint(20) NOT NULL default '0',
1515 PRIMARY KEY (`entry`)
1516 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1518 -- --------------------------------------------------------
1521 -- Structure de la table `userflags`
1524 CREATE TABLE `userflags` (
1525 `bit` int(11) NOT NULL default '0',
1526 `flag` char(30) default NULL,
1527 `flagdesc` char(255) default NULL,
1528 `defaulton` int(11) default NULL,
1530 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1532 -- --------------------------------------------------------
1535 -- Structure de la table `users`
1538 CREATE TABLE `users` (
1539 `usercode` varchar(10) default NULL,
1540 `username` mediumtext,
1541 `password` mediumtext,
1542 `level` smallint(6) default NULL
1543 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1545 -- --------------------------------------------------------
1548 -- Structure de la table `websites`
1551 CREATE TABLE `websites` (
1552 `websitenumber` int(11) NOT NULL auto_increment,
1553 `biblionumber` int(11) NOT NULL default '0',
1555 `description` mediumtext,
1556 `url` varchar(255) default NULL,
1557 PRIMARY KEY (`websitenumber`)
1558 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1560 -- --------------------------------------------------------
1563 -- Structure de la table `z3950queue`
1566 CREATE TABLE `z3950queue` (
1567 `id` int(11) NOT NULL auto_increment,
1569 `type` varchar(10) default NULL,
1570 `startdate` int(11) default NULL,
1571 `enddate` int(11) default NULL,
1572 `done` smallint(6) default NULL,
1574 `numrecords` int(11) default NULL,
1575 `servers` mediumtext,
1576 `identifier` varchar(30) default NULL,
1578 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1580 -- --------------------------------------------------------
1583 -- Structure de la table `z3950results`
1586 CREATE TABLE `z3950results` (
1587 `id` int(11) NOT NULL auto_increment,
1588 `queryid` int(11) default NULL,
1589 `server` varchar(255) default NULL,
1590 `startdate` int(11) default NULL,
1591 `enddate` int(11) default NULL,
1593 `numrecords` int(11) default NULL,
1594 `numdownloaded` int(11) default NULL,
1595 `highestseen` int(11) default NULL,
1596 `active` smallint(6) default NULL,
1598 UNIQUE KEY `query_server` (`queryid`,`server`)
1599 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1601 -- --------------------------------------------------------
1604 -- Structure de la table `z3950servers`
1607 CREATE TABLE `z3950servers` (
1608 `host` varchar(255) default NULL,
1609 `port` int(11) default NULL,
1610 `db` varchar(255) default NULL,
1611 `userid` varchar(255) default NULL,
1612 `password` varchar(255) default NULL,
1614 `id` int(11) NOT NULL auto_increment,
1615 `checked` smallint(6) default NULL,
1616 `rank` int(11) default NULL,
1617 `syntax` varchar(80) default NULL,
1619 `position` enum('primary','secondary','') NOT NULL default 'primary',
1620 `type` enum('zed','opensearch') NOT NULL default 'zed',
1621 `description` text NOT NULL,
1623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1625 -- --------------------------------------------------------
1628 -- Structure de la table `zebraqueue`
1631 CREATE TABLE `zebraqueue` (
1632 `id` int(11) NOT NULL auto_increment,
1633 `biblio_auth_number` int(11) NOT NULL,
1634 `operation` char(20) NOT NULL,
1635 `server` char(20) NOT NULL,
1637 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1640 -- Contraintes pour les tables exportées
1644 -- Contraintes pour la table `accountlines`
1646 ALTER TABLE `accountlines`
1647 ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1648 ADD CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1649 ADD CONSTRAINT `accountlines_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1650 ADD CONSTRAINT `accountlines_ibfk_4` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
1653 -- Contraintes pour la table `aqbasket`
1655 ALTER TABLE `aqbasket`
1656 ADD CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE;
1659 -- Contraintes pour la table `aqbooksellers`
1661 ALTER TABLE `aqbooksellers`
1662 ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
1663 ADD CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
1666 -- Contraintes pour la table `aqorderbreakdown`
1668 ALTER TABLE `aqorderbreakdown`
1669 ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1670 ADD CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE,
1671 ADD CONSTRAINT `aqorderbreakdown_ibfk_3` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE,
1672 ADD CONSTRAINT `aqorderbreakdown_ibfk_4` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
1675 -- Contraintes pour la table `aqorders`
1677 ALTER TABLE `aqorders`
1678 ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
1679 ADD CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1680 ADD CONSTRAINT `aqorders_ibfk_3` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1681 ADD CONSTRAINT `aqorders_ibfk_4` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE;
1684 -- Contraintes pour la table `auth_tag_structure`
1686 ALTER TABLE `auth_tag_structure`
1687 ADD CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE;
1690 -- Contraintes pour la table `biblioitems`
1692 ALTER TABLE `biblioitems`
1693 ADD CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
1696 -- Contraintes pour la table `borrowers`
1698 ALTER TABLE `borrowers`
1699 ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
1700 ADD CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1701 ADD CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1702 ADD CONSTRAINT `borrowers_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`);
1705 -- Contraintes pour la table `branchrelations`
1707 ALTER TABLE `branchrelations`
1708 ADD CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1709 ADD CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,
1710 ADD CONSTRAINT `branchrelations_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,
1711 ADD CONSTRAINT `branchrelations_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
1714 -- Contraintes pour la table `branchtransfers`
1716 ALTER TABLE `branchtransfers`
1717 ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1718 ADD CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1719 ADD CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1720 ADD CONSTRAINT `branchtransfers_ibfk_4` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1721 ADD CONSTRAINT `branchtransfers_ibfk_5` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
1724 -- Contraintes pour la table `issues`
1726 ALTER TABLE `issues`
1727 ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1728 ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1729 ADD CONSTRAINT `issues_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1730 ADD CONSTRAINT `issues_ibfk_4` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
1733 -- Contraintes pour la table `issuingrules`
1735 ALTER TABLE `issuingrules`
1736 ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,
1737 ADD CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
1738 ADD CONSTRAINT `issuingrules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
1739 ADD CONSTRAINT `issuingrules_ibfk_4` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE;
1742 -- Contraintes pour la table `items`
1745 ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1746 ADD CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1747 ADD CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1748 ADD CONSTRAINT `items_ibfk_4` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1749 ADD CONSTRAINT `items_ibfk_5` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1750 ADD CONSTRAINT `items_ibfk_6` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1751 ADD CONSTRAINT `items_ibfk_7` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE;
1754 -- Contraintes pour la table `reserves`
1756 ALTER TABLE `reserves`
1757 ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1758 ADD CONSTRAINT `reserves_ibfk_10` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1759 ADD CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1760 ADD CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1761 ADD CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1762 ADD CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1763 ADD CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1764 ADD CONSTRAINT `reserves_ibfk_7` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1765 ADD CONSTRAINT `reserves_ibfk_8` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1766 ADD CONSTRAINT `reserves_ibfk_9` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
1769 -- Contraintes pour la table `shelfcontents`
1771 ALTER TABLE `shelfcontents`
1772 ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1773 ADD CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1774 ADD CONSTRAINT `shelfcontents_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1775 ADD CONSTRAINT `shelfcontents_ibfk_4` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE;