3 -- http://www.phpmyadmin.net
6 -- Généré le : Mardi 06 Février 2007 à 15:21
7 -- Version du serveur: 4.1.12
8 -- Version de PHP: 5.0.4
10 -- Base de données: `Kohazebratest`
13 -- --------------------------------------------------------
16 -- Structure de la table `accountlines`
18 -- Création: Mardi 06 Février 2007 à 11:14
21 DROP TABLE IF EXISTS `accountlines`;
22 CREATE TABLE IF NOT EXISTS `accountlines` (
23 `borrowernumber` int(11) NOT NULL default '0',
24 `accountno` smallint(6) NOT NULL default '0',
25 `itemnumber` int(11) default NULL,
26 `date` date default NULL,
27 `amount` decimal(28,6) default NULL,
30 `accounttype` varchar(5) default NULL,
31 `amountoutstanding` decimal(28,6) default NULL,
32 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
33 `notify_id` int(11) NOT NULL default '0',
34 `notify_level` int(2) NOT NULL default '0',
35 KEY `acctsborridx` (`borrowernumber`),
36 KEY `timeidx` (`timestamp`),
37 KEY `itemnumber` (`itemnumber`)
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
40 -- --------------------------------------------------------
43 -- Structure de la table `accountoffsets`
45 -- Création: Lundi 27 Novembre 2006 à 17:56
48 DROP TABLE IF EXISTS `accountoffsets`;
49 CREATE TABLE IF NOT EXISTS `accountoffsets` (
50 `borrowernumber` int(11) NOT NULL default '0',
51 `accountno` smallint(6) NOT NULL default '0',
52 `offsetaccount` smallint(6) NOT NULL default '0',
53 `offsetamount` decimal(28,6) default NULL,
54 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57 -- --------------------------------------------------------
60 -- Structure de la table `action_logs`
62 -- Création: Lundi 27 Novembre 2006 à 17:56
65 DROP TABLE IF EXISTS `action_logs`;
66 CREATE TABLE IF NOT EXISTS `action_logs` (
67 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
68 `user` int(11) NOT NULL default '0',
71 `object` int(11) default '0',
73 PRIMARY KEY (`timestamp`,`user`)
74 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
76 -- --------------------------------------------------------
79 -- Structure de la table `alert`
81 -- Création: Lundi 27 Novembre 2006 à 17:56
84 DROP TABLE IF EXISTS `alert`;
85 CREATE TABLE IF NOT EXISTS `alert` (
86 `alertid` int(11) NOT NULL auto_increment,
87 `borrowernumber` int(11) NOT NULL default '0',
88 `type` varchar(10) NOT NULL default '',
89 `externalid` varchar(20) NOT NULL default '',
90 PRIMARY KEY (`alertid`),
91 KEY `borrowernumber` (`borrowernumber`),
92 KEY `type` (`type`,`externalid`)
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
95 -- --------------------------------------------------------
98 -- Structure de la table `aqbasket`
100 -- Création: Mardi 06 Février 2007 à 11:14
103 DROP TABLE IF EXISTS `aqbasket`;
104 CREATE TABLE IF NOT EXISTS `aqbasket` (
105 `basketno` int(11) NOT NULL auto_increment,
106 `creationdate` date default NULL,
107 `closedate` date default NULL,
108 `booksellerid` int(11) NOT NULL default '1',
109 `authorisedby` varchar(10) default NULL,
110 `booksellerinvoicenumber` text,
111 PRIMARY KEY (`basketno`),
112 KEY `booksellerid` (`booksellerid`)
113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115 -- --------------------------------------------------------
118 -- Structure de la table `aqbookfund`
120 -- Création: Mardi 06 Février 2007 à 11:14
123 DROP TABLE IF EXISTS `aqbookfund`;
124 CREATE TABLE IF NOT EXISTS `aqbookfund` (
125 `bookfundid` varchar(5) NOT NULL default '''''',
127 `bookfundgroup` varchar(5) default NULL,
128 `branchcode` varchar(4) NOT NULL default '',
129 PRIMARY KEY (`bookfundid`,`branchcode`)
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
132 -- --------------------------------------------------------
135 -- Structure de la table `aqbooksellers`
137 -- Création: Mardi 06 Février 2007 à 11:14
140 DROP TABLE IF EXISTS `aqbooksellers`;
141 CREATE TABLE IF NOT EXISTS `aqbooksellers` (
142 `id` int(11) NOT NULL default '0',
148 `phone` varchar(30) default NULL,
149 `accountnumber` text,
150 `othersupplier` text,
151 `currency` varchar(3) NOT NULL default '',
152 `deliverydays` smallint(6) default NULL,
153 `followupdays` smallint(6) default NULL,
154 `followupscancel` smallint(6) default NULL,
156 `booksellerfax` text,
158 `bookselleremail` text,
159 `booksellerurl` text,
160 `contact` varchar(100) default NULL,
162 `url` varchar(255) default NULL,
163 `contpos` varchar(100) default NULL,
164 `contphone` varchar(100) default NULL,
165 `contfax` varchar(100) default NULL,
166 `contaltphone` varchar(100) default NULL,
167 `contemail` varchar(100) default NULL,
169 `active` tinyint(4) default NULL,
170 `listprice` varchar(10) default '',
171 `invoiceprice` varchar(10) default '',
172 `gstreg` tinyint(4) default NULL,
173 `listincgst` tinyint(4) default NULL,
174 `invoiceincgst` tinyint(4) default NULL,
175 `discount` float(6,4) default NULL,
176 `fax` varchar(50) default NULL,
177 `nocalc` int(11) default NULL,
178 `invoicedisc` float(6,4) default NULL,
180 KEY `listprice` (`listprice`),
181 KEY `invoiceprice` (`invoiceprice`)
182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
184 -- --------------------------------------------------------
187 -- Structure de la table `aqbudget`
189 -- Création: Lundi 27 Novembre 2006 à 17:56
192 DROP TABLE IF EXISTS `aqbudget`;
193 CREATE TABLE IF NOT EXISTS `aqbudget` (
194 `bookfundid` varchar(5) NOT NULL default '',
195 `startdate` date NOT NULL default '0000-00-00',
196 `enddate` date default NULL,
197 `budgetamount` decimal(13,2) default NULL,
198 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
199 `branchcode` varchar(4) NOT NULL default '',
200 PRIMARY KEY (`aqbudgetid`,`branchcode`)
201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
203 -- --------------------------------------------------------
206 -- Structure de la table `aqorderbreakdown`
208 -- Création: Lundi 27 Novembre 2006 à 18:41
211 DROP TABLE IF EXISTS `aqorderbreakdown`;
212 CREATE TABLE IF NOT EXISTS `aqorderbreakdown` (
213 `ordernumber` int(11) default NULL,
214 `linenumber` int(11) default NULL,
215 `branchcode` char(4) default NULL,
216 `bookfundid` char(5) NOT NULL default '',
217 `allocation` smallint(6) default NULL,
218 KEY `ordernumber` (`ordernumber`),
219 KEY `bookfundid` (`bookfundid`)
220 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222 -- --------------------------------------------------------
225 -- Structure de la table `aqorderdelivery`
227 -- Création: Lundi 27 Novembre 2006 à 17:56
230 DROP TABLE IF EXISTS `aqorderdelivery`;
231 CREATE TABLE IF NOT EXISTS `aqorderdelivery` (
232 `ordernumber` date NOT NULL default '0000-00-00',
233 `deliverynumber` smallint(6) NOT NULL default '0',
234 `deliverydate` varchar(18) default NULL,
235 `qtydelivered` smallint(6) default NULL,
236 `deliverycomments` text
237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
239 -- --------------------------------------------------------
242 -- Structure de la table `aqorders`
244 -- Création: Lundi 27 Novembre 2006 à 18:41
247 DROP TABLE IF EXISTS `aqorders`;
248 CREATE TABLE IF NOT EXISTS `aqorders` (
249 `ordernumber` int(11) NOT NULL auto_increment,
250 `biblionumber` int(11) default NULL,
252 `entrydate` date default NULL,
253 `quantity` smallint(6) default NULL,
254 `currency` varchar(3) default NULL,
255 `listprice` decimal(28,6) default NULL,
256 `totalamount` decimal(28,6) default NULL,
257 `datereceived` date default NULL,
258 `booksellerinvoicenumber` text,
259 `freight` decimal(28,6) default NULL,
260 `unitprice` decimal(28,6) default NULL,
261 `quantityreceived` smallint(6) default NULL,
262 `cancelledby` varchar(10) default NULL,
263 `datecancellationprinted` date default NULL,
265 `supplierreference` text,
266 `purchaseordernumber` text,
267 `subscription` tinyint(1) default NULL,
268 `serialid` varchar(30) default NULL,
269 `basketno` int(11) default NULL,
270 `biblioitemnumber` int(11) default NULL,
271 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
272 `rrp` decimal(13,2) default NULL,
273 `ecost` decimal(13,2) default NULL,
274 `gst` decimal(13,2) default NULL,
275 `budgetdate` date default NULL,
276 `sort1` varchar(80) default NULL,
277 `sort2` varchar(80) default NULL,
278 PRIMARY KEY (`ordernumber`),
279 KEY `basketno` (`basketno`),
280 KEY `biblionumber` (`biblionumber`)
281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
283 -- --------------------------------------------------------
286 -- Structure de la table `auth_header`
288 -- Création: Lundi 27 Novembre 2006 à 17:56
291 DROP TABLE IF EXISTS `auth_header`;
292 CREATE TABLE IF NOT EXISTS `auth_header` (
293 `authid` bigint(20) unsigned NOT NULL auto_increment,
294 `authtypecode` varchar(10) NOT NULL default '',
295 `datecreated` date NOT NULL default '0000-00-00',
296 `datemodified` date default NULL,
297 `origincode` varchar(20) default NULL,
299 `linkid` bigint(20) default NULL,
301 `marcxml` text NOT NULL,
302 PRIMARY KEY (`authid`),
303 KEY `origincode` (`origincode`)
304 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
306 -- --------------------------------------------------------
309 -- Structure de la table `auth_subfield_structure`
311 -- Création: Lundi 27 Novembre 2006 à 18:39
314 DROP TABLE IF EXISTS `auth_subfield_structure`;
315 CREATE TABLE IF NOT EXISTS `auth_subfield_structure` (
316 `authtypecode` varchar(10) NOT NULL default '',
317 `tagfield` varchar(3) NOT NULL default '',
318 `tagsubfield` char(1) NOT NULL default '',
319 `liblibrarian` varchar(255) NOT NULL default '',
320 `libopac` varchar(255) NOT NULL default '',
321 `repeatable` tinyint(4) NOT NULL default '0',
322 `mandatory` tinyint(4) NOT NULL default '0',
323 `tab` tinyint(1) default NULL,
324 `authorised_value` varchar(10) default NULL,
325 `value_builder` varchar(80) default NULL,
326 `seealso` varchar(255) default NULL,
327 `hidden` tinyint(1) unsigned NOT NULL default '0',
328 `isurl` tinyint(1) unsigned NOT NULL default '0',
329 `link` varchar(80) default NULL,
330 `frameworkcode` varchar(8) NOT NULL default '',
331 `kohafield` varchar(40) default NULL,
332 `linkid` tinyint(1) NOT NULL default '0',
333 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
334 KEY `tab` (`authtypecode`,`tab`)
335 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
337 -- --------------------------------------------------------
340 -- Structure de la table `auth_subfield_table`
342 -- Création: Lundi 27 Novembre 2006 à 17:56
345 DROP TABLE IF EXISTS `auth_subfield_table`;
346 CREATE TABLE IF NOT EXISTS `auth_subfield_table` (
347 `subfieldid` bigint(20) unsigned NOT NULL auto_increment,
348 `authid` bigint(20) unsigned NOT NULL default '0',
349 `tag` varchar(3) NOT NULL default '',
350 `tagorder` tinyint(4) NOT NULL default '1',
351 `tag_indicator` varchar(2) NOT NULL default '',
352 `subfieldcode` char(1) NOT NULL default '',
353 `subfieldorder` tinyint(4) NOT NULL default '1',
354 `subfieldvalue` varchar(255) default NULL,
355 PRIMARY KEY (`subfieldid`),
356 KEY `authid` (`authid`),
358 KEY `subfieldcode` (`subfieldcode`),
359 KEY `subfieldvalue` (`subfieldvalue`)
360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
362 -- --------------------------------------------------------
365 -- Structure de la table `auth_tag_structure`
367 -- Création: Lundi 27 Novembre 2006 à 18:41
370 DROP TABLE IF EXISTS `auth_tag_structure`;
371 CREATE TABLE IF NOT EXISTS `auth_tag_structure` (
372 `authtypecode` char(10) NOT NULL default '',
373 `tagfield` char(3) NOT NULL default '',
374 `liblibrarian` char(255) NOT NULL default '',
375 `libopac` char(255) NOT NULL default '',
376 `repeatable` tinyint(4) NOT NULL default '0',
377 `mandatory` tinyint(4) NOT NULL default '0',
378 `authorised_value` char(10) default NULL,
379 PRIMARY KEY (`authtypecode`,`tagfield`)
380 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
382 -- --------------------------------------------------------
385 -- Structure de la table `auth_types`
387 -- Création: Lundi 27 Novembre 2006 à 17:56
390 DROP TABLE IF EXISTS `auth_types`;
391 CREATE TABLE IF NOT EXISTS `auth_types` (
392 `authtypecode` varchar(10) NOT NULL default '',
393 `authtypetext` varchar(255) NOT NULL default '',
394 `auth_tag_to_report` varchar(3) NOT NULL default '',
395 `summary` text NOT NULL,
396 PRIMARY KEY (`authtypecode`)
397 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
399 -- --------------------------------------------------------
402 -- Structure de la table `auth_word`
404 -- Création: Lundi 27 Novembre 2006 à 17:57
407 DROP TABLE IF EXISTS `auth_word`;
408 CREATE TABLE IF NOT EXISTS `auth_word` (
409 `authid` bigint(20) NOT NULL default '0',
410 `tagsubfield` varchar(4) NOT NULL default '',
411 `tagorder` tinyint(4) NOT NULL default '1',
412 `subfieldorder` tinyint(4) NOT NULL default '1',
413 `word` varchar(255) NOT NULL default '',
414 `sndx_word` varchar(255) NOT NULL default '',
415 KEY `authid` (`authid`),
416 KEY `marc_search` (`tagsubfield`,`word`),
418 KEY `sndx_word` (`sndx_word`)
419 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
421 -- --------------------------------------------------------
424 -- Structure de la table `authorised_values`
426 -- Création: Lundi 27 Novembre 2006 à 17:57
429 DROP TABLE IF EXISTS `authorised_values`;
430 CREATE TABLE IF NOT EXISTS `authorised_values` (
431 `id` int(11) NOT NULL auto_increment,
432 `category` char(10) NOT NULL default '',
433 `authorised_value` char(80) NOT NULL default '',
434 `lib` char(80) default NULL,
436 KEY `name` (`category`)
437 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
439 -- --------------------------------------------------------
442 -- Structure de la table `biblio`
444 -- Création: Lundi 27 Novembre 2006 à 17:57
447 DROP TABLE IF EXISTS `biblio`;
448 CREATE TABLE IF NOT EXISTS `biblio` (
449 `biblionumber` int(11) NOT NULL default '0',
454 `serial` tinyint(1) default NULL,
456 `copyrightdate` smallint(6) default NULL,
457 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
459 `frameworkcode` varchar(4) default NULL,
460 PRIMARY KEY (`biblionumber`),
461 KEY `blbnoidx` (`biblionumber`)
462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
464 -- --------------------------------------------------------
467 -- Structure de la table `biblio_framework`
469 -- Création: Lundi 27 Novembre 2006 à 17:57
472 DROP TABLE IF EXISTS `biblio_framework`;
473 CREATE TABLE IF NOT EXISTS `biblio_framework` (
474 `frameworkcode` char(4) NOT NULL default '',
475 `frameworktext` char(255) NOT NULL default '',
476 PRIMARY KEY (`frameworkcode`)
477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
479 -- --------------------------------------------------------
482 -- Structure de la table `biblioanalysis`
484 -- Création: Lundi 27 Novembre 2006 à 17:57
487 DROP TABLE IF EXISTS `biblioanalysis`;
488 CREATE TABLE IF NOT EXISTS `biblioanalysis` (
489 `analyticaltitle` text,
490 `biblionumber` int(11) NOT NULL default '0',
491 `analyticalauthor` text
492 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
494 -- --------------------------------------------------------
497 -- Structure de la table `biblioitems`
499 -- Création: Mardi 06 Février 2007 à 11:14
502 DROP TABLE IF EXISTS `biblioitems`;
503 CREATE TABLE IF NOT EXISTS `biblioitems` (
504 `biblioitemnumber` int(11) NOT NULL default '0',
505 `biblionumber` int(11) NOT NULL default '0',
508 `classification` varchar(25) default NULL,
509 `itemtype` varchar(4) default NULL,
510 `isbn` varchar(14) default NULL,
511 `issn` varchar(9) default NULL,
512 `dewey` varchar(30) default '',
513 `subclass` varchar(3) default NULL,
514 `publicationyear` smallint(6) default NULL,
515 `publishercode` varchar(255) default NULL,
516 `volumedate` date default NULL,
517 `volumeddesc` varchar(255) default NULL,
518 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
519 `illus` varchar(255) default NULL,
520 `pages` varchar(255) default NULL,
522 `size` varchar(255) default NULL,
523 `place` varchar(255) default NULL,
524 `lccn` varchar(25) default NULL,
526 `url` varchar(255) default NULL,
528 `lcsort` varchar(25) default NULL,
529 `ccode` varchar(4) default '',
530 PRIMARY KEY (`biblioitemnumber`),
531 KEY `bibinoidx` (`biblioitemnumber`),
532 KEY `bibnoidx` (`biblionumber`),
533 KEY `itemtype` (`itemtype`),
535 KEY `publishercode` (`publishercode`)
536 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
538 -- --------------------------------------------------------
541 -- Structure de la table `bibliothesaurus`
543 -- Création: Mercredi 04 Octobre 2006 à 23:21
544 -- Dernière modification: Mercredi 04 Octobre 2006 à 23:21
545 -- Dernière vérification: Mercredi 04 Octobre 2006 à 23:21
548 DROP TABLE IF EXISTS `bibliothesaurus`;
549 CREATE TABLE IF NOT EXISTS `bibliothesaurus` (
550 `id` bigint(20) NOT NULL auto_increment,
551 `freelib` char(255) NOT NULL default '',
552 `stdlib` char(255) NOT NULL default '',
553 `category` char(10) NOT NULL default '',
554 `level` tinyint(4) NOT NULL default '1',
555 `hierarchy` char(80) NOT NULL default '',
556 `father` char(80) NOT NULL default '',
558 KEY `freelib` (`freelib`),
559 KEY `stdlib` (`stdlib`),
560 KEY `category` (`category`),
561 KEY `hierarchy` (`hierarchy`),
562 KEY `category_2` (`category`,`freelib`)
563 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
565 -- --------------------------------------------------------
568 -- Structure de la table `bookshelf`
570 -- Création: Lundi 27 Novembre 2006 à 17:57
573 DROP TABLE IF EXISTS `bookshelf`;
574 CREATE TABLE IF NOT EXISTS `bookshelf` (
575 `shelfnumber` int(11) NOT NULL auto_increment,
576 `shelfname` char(255) default NULL,
577 `owner` char(80) default NULL,
578 `category` char(1) default NULL,
579 PRIMARY KEY (`shelfnumber`)
580 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
582 -- --------------------------------------------------------
585 -- Structure de la table `borexp`
587 -- Création: Lundi 27 Novembre 2006 à 17:57
590 DROP TABLE IF EXISTS `borexp`;
591 CREATE TABLE IF NOT EXISTS `borexp` (
592 `borrowernumber` int(11) default NULL,
593 `newexp` date default NULL
594 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
596 -- --------------------------------------------------------
599 -- Structure de la table `borrowers`
601 -- Création: Mardi 06 Février 2007 à 11:14
604 DROP TABLE IF EXISTS `borrowers`;
605 CREATE TABLE IF NOT EXISTS `borrowers` (
606 `borrowernumber` int(11) NOT NULL auto_increment,
607 `cardnumber` varchar(16) NOT NULL default '',
608 `surname` text NOT NULL,
613 `streetnumber` varchar(10) default NULL,
614 `streettype` varchar(50) default NULL,
615 `address` text NOT NULL,
617 `city` text NOT NULL,
618 `zipcode` varchar(25) default NULL,
621 `mobile` varchar(50) default NULL,
623 `B_streetnumber` varchar(10) default NULL,
624 `B_streettype` varchar(50) default NULL,
627 `B_address` varchar(100) default NULL,
629 `B_zipcode` varchar(25) default NULL,
632 `dateofbirth` date default NULL,
633 `branchcode` varchar(10) NOT NULL default '',
634 `categorycode` varchar(10) NOT NULL default '',
635 `dateenrolled` date default NULL,
636 `dateexpiry` date default NULL,
637 `gonenoaddress` tinyint(1) default NULL,
638 `lost` tinyint(1) default NULL,
639 `debarred` tinyint(1) default NULL,
641 `contactfirstname` text,
643 `guarantorid` int(11) default NULL,
644 `borrowernotes` text,
645 `relationship` varchar(100) default NULL,
646 `ethnicity` varchar(50) default NULL,
647 `ethnotes` varchar(255) default NULL,
648 `sex` char(1) default NULL,
649 `password` varchar(30) default NULL,
650 `flags` int(11) default NULL,
651 `userid` varchar(30) default NULL,
653 `contactnote` varchar(255) default NULL,
654 `sort1` varchar(80) default NULL,
655 `sort2` varchar(80) default NULL,
656 `textmessaging` varchar(30) default NULL,
657 `homezipcode` varchar(25) default NULL,
658 UNIQUE KEY `cardnumber` (`cardnumber`),
659 KEY `borrowernumber` (`borrowernumber`),
660 KEY `categorycode` (`categorycode`),
661 KEY `branchcode` (`branchcode`)
662 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
664 -- --------------------------------------------------------
667 -- Structure de la table `borrowers_to_borrowers`
669 -- Création: Lundi 27 Novembre 2006 à 17:57
672 DROP TABLE IF EXISTS `borrowers_to_borrowers`;
673 CREATE TABLE IF NOT EXISTS `borrowers_to_borrowers` (
674 `borrower1` int(11) default NULL,
675 `borrower2` int(11) default NULL
676 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
678 -- --------------------------------------------------------
681 -- Structure de la table `branchcategories`
683 -- Création: Lundi 27 Novembre 2006 à 17:57
686 DROP TABLE IF EXISTS `branchcategories`;
687 CREATE TABLE IF NOT EXISTS `branchcategories` (
688 `categorycode` varchar(4) NOT NULL default '',
690 `codedescription` text,
691 PRIMARY KEY (`categorycode`)
692 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
694 -- --------------------------------------------------------
697 -- Structure de la table `branches`
699 -- Création: Mardi 06 Février 2007 à 11:14
702 DROP TABLE IF EXISTS `branches`;
703 CREATE TABLE IF NOT EXISTS `branches` (
704 `branchcode` varchar(10) NOT NULL default '',
705 `branchname` text NOT NULL,
706 `branchaddress1` text,
707 `branchaddress2` text,
708 `branchaddress3` text,
712 `issuing` tinyint(4) default NULL,
713 `branchip` varchar(15) default '',
714 `branchprinter` varchar(100) default '',
715 UNIQUE KEY `branchcode` (`branchcode`)
716 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
718 -- --------------------------------------------------------
721 -- Structure de la table `branchrelations`
723 -- Création: Lundi 27 Novembre 2006 à 17:57
726 DROP TABLE IF EXISTS `branchrelations`;
727 CREATE TABLE IF NOT EXISTS `branchrelations` (
728 `branchcode` varchar(4) default NULL,
729 `categorycode` varchar(4) default NULL
730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
732 -- --------------------------------------------------------
735 -- Structure de la table `branchtransfers`
737 -- Création: Mardi 06 Février 2007 à 11:14
740 DROP TABLE IF EXISTS `branchtransfers`;
741 CREATE TABLE IF NOT EXISTS `branchtransfers` (
742 `itemnumber` int(11) NOT NULL default '0',
743 `datesent` datetime default NULL,
744 `frombranch` varchar(10) NOT NULL default '',
745 `datearrived` datetime default NULL,
746 `tobranch` varchar(10) NOT NULL default '',
748 KEY `frombranch` (`frombranch`),
749 KEY `tobranch` (`tobranch`),
750 KEY `itemnumber` (`itemnumber`)
751 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
753 -- --------------------------------------------------------
756 -- Structure de la table `catalogueentry`
758 -- Création: Lundi 27 Novembre 2006 à 17:57
761 DROP TABLE IF EXISTS `catalogueentry`;
762 CREATE TABLE IF NOT EXISTS `catalogueentry` (
763 `catalogueentry` text NOT NULL,
764 `entrytype` varchar(2) default NULL,
768 `biblionumber` int(11) default NULL
769 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
771 -- --------------------------------------------------------
774 -- Structure de la table `categories`
776 -- Création: Mardi 06 Février 2007 à 11:14
779 DROP TABLE IF EXISTS `categories`;
780 CREATE TABLE IF NOT EXISTS `categories` (
781 `categorycode` varchar(10) NOT NULL default '',
783 `enrolmentperiod` smallint(6) default NULL,
784 `upperagelimit` smallint(6) default NULL,
785 `dateofbirthrequired` tinyint(1) default NULL,
786 `finetype` varchar(30) default NULL,
787 `bulk` tinyint(1) default NULL,
788 `enrolmentfee` decimal(28,6) default NULL,
789 `overduenoticerequired` tinyint(1) default NULL,
790 `issuelimit` smallint(6) default NULL,
791 `reservefee` decimal(28,6) default NULL,
792 `category_type` char(1) NOT NULL default 'A',
793 PRIMARY KEY (`categorycode`),
794 UNIQUE KEY `categorycode` (`categorycode`)
795 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
797 -- --------------------------------------------------------
800 -- Structure de la table `categorytable`
802 -- Création: Lundi 27 Novembre 2006 à 17:57
805 DROP TABLE IF EXISTS `categorytable`;
806 CREATE TABLE IF NOT EXISTS `categorytable` (
807 `categorycode` varchar(5) NOT NULL default '',
809 `itemtypecodes` text,
810 PRIMARY KEY (`categorycode`)
811 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
813 -- --------------------------------------------------------
816 -- Structure de la table `charges`
818 -- Création: Vendredi 08 Décembre 2006 à 16:47
821 DROP TABLE IF EXISTS `charges`;
822 CREATE TABLE IF NOT EXISTS `charges` (
823 `charge_id` varchar(5) NOT NULL default '',
824 `description` text NOT NULL,
825 `amount` decimal(28,6) NOT NULL default '0.000000',
826 `min` int(4) NOT NULL default '0',
827 `max` int(4) NOT NULL default '0',
828 `level` int(1) NOT NULL default '0',
829 PRIMARY KEY (`charge_id`)
830 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
832 -- --------------------------------------------------------
835 -- Structure de la table `cities`
837 -- Création: Lundi 27 Novembre 2006 à 17:57
840 DROP TABLE IF EXISTS `cities`;
841 CREATE TABLE IF NOT EXISTS `cities` (
842 `cityid` int(11) NOT NULL auto_increment,
843 `city_name` char(100) NOT NULL default '',
844 `city_zipcode` char(20) default NULL,
845 PRIMARY KEY (`cityid`)
846 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
848 -- --------------------------------------------------------
851 -- Structure de la table `currency`
853 -- Création: Lundi 27 Novembre 2006 à 17:57
856 DROP TABLE IF EXISTS `currency`;
857 CREATE TABLE IF NOT EXISTS `currency` (
858 `currency` varchar(10) NOT NULL default '',
859 `rate` float(7,5) default NULL,
860 PRIMARY KEY (`currency`)
861 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
863 -- --------------------------------------------------------
866 -- Structure de la table `deletedbiblio`
868 -- Création: Lundi 27 Novembre 2006 à 17:57
871 DROP TABLE IF EXISTS `deletedbiblio`;
872 CREATE TABLE IF NOT EXISTS `deletedbiblio` (
873 `biblionumber` int(11) NOT NULL default '0',
878 `serial` tinyint(1) default NULL,
880 `copyrightdate` smallint(6) default NULL,
881 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
884 `frameworkcode` varchar(4) default NULL,
885 PRIMARY KEY (`biblionumber`),
886 KEY `blbnoidx` (`biblionumber`)
887 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
889 -- --------------------------------------------------------
892 -- Structure de la table `deletedbiblioitems`
894 -- Création: Lundi 27 Novembre 2006 à 18:40
897 DROP TABLE IF EXISTS `deletedbiblioitems`;
898 CREATE TABLE IF NOT EXISTS `deletedbiblioitems` (
899 `biblioitemnumber` int(11) NOT NULL default '0',
900 `biblionumber` int(11) NOT NULL default '0',
903 `classification` varchar(25) default NULL,
904 `itemtype` varchar(4) default NULL,
905 `isbn` varchar(14) default NULL,
906 `issn` varchar(9) default NULL,
907 `dewey` double(8,6) default NULL,
908 `subclass` varchar(3) default NULL,
909 `publicationyear` smallint(6) default NULL,
910 `publishercode` varchar(255) default NULL,
911 `volumedate` date default NULL,
912 `volumeddesc` varchar(255) default NULL,
913 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
914 `illus` varchar(255) default NULL,
915 `pages` varchar(255) default NULL,
917 `size` varchar(255) default NULL,
918 `lccn` varchar(25) default NULL,
920 `url` varchar(255) default NULL,
921 `place` varchar(255) default NULL,
923 `lcsort` varchar(25) default NULL,
924 `ccode` varchar(4) default NULL,
925 PRIMARY KEY (`biblioitemnumber`),
926 KEY `bibinoidx` (`biblioitemnumber`),
927 KEY `bibnoidx` (`biblionumber`)
928 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
930 -- --------------------------------------------------------
933 -- Structure de la table `deletedborrowers`
935 -- Création: Mardi 06 Février 2007 à 11:14
938 DROP TABLE IF EXISTS `deletedborrowers`;
939 CREATE TABLE IF NOT EXISTS `deletedborrowers` (
940 `borrowernumber` int(11) NOT NULL default '0',
941 `cardnumber` varchar(9) NOT NULL default '',
942 `surname` text NOT NULL,
947 `streetnumber` varchar(10) default NULL,
948 `streettype` varchar(50) default NULL,
949 `address` text NOT NULL,
951 `city` text NOT NULL,
952 `zipcode` varchar(25) default NULL,
955 `mobile` varchar(50) default NULL,
957 `B_streetnumber` varchar(10) default NULL,
958 `B_streettype` varchar(50) default NULL,
961 `B_address` varchar(100) default NULL,
963 `B_zipcode` varchar(25) default NULL,
966 `dateofbirth` date default NULL,
967 `branchcode` varchar(4) NOT NULL default '',
968 `categorycode` varchar(2) default NULL,
969 `dateenrolled` date default NULL,
970 `dateexpiry` date default NULL,
971 `gonenoaddress` tinyint(1) default NULL,
972 `lost` tinyint(1) default NULL,
973 `debarred` tinyint(1) default NULL,
975 `contactfirstname` text,
977 `guarantorid` int(11) default NULL,
978 `borrowernotes` text,
979 `relationship` varchar(100) default NULL,
980 `ethnicity` varchar(50) default NULL,
981 `ethnotes` varchar(255) default NULL,
982 `sex` char(1) default NULL,
983 `password` varchar(30) default NULL,
984 `flags` int(11) default NULL,
985 `userid` varchar(30) default NULL,
987 `contactnote` varchar(255) default NULL,
988 `sort1` varchar(80) default NULL,
989 `sort2` varchar(80) default NULL,
990 `textmessaging` varchar(30) default NULL,
991 `homezipcode` varchar(25) default NULL,
992 KEY `borrowernumber` (`borrowernumber`),
993 KEY `cardnumber` (`cardnumber`),
994 KEY `categorycode` (`categorycode`),
995 KEY `branchcode` (`branchcode`)
996 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
998 -- --------------------------------------------------------
1001 -- Structure de la table `deleteditems`
1003 -- Création: Lundi 27 Novembre 2006 à 18:40
1006 DROP TABLE IF EXISTS `deleteditems`;
1007 CREATE TABLE IF NOT EXISTS `deleteditems` (
1008 `itemnumber` int(11) NOT NULL default '0',
1009 `biblionumber` int(11) NOT NULL default '0',
1010 `multivolumepart` varchar(30) default NULL,
1011 `biblioitemnumber` int(11) NOT NULL default '0',
1012 `barcode` varchar(9) NOT NULL default '',
1013 `dateaccessioned` date default NULL,
1014 `booksellerid` varchar(10) default NULL,
1015 `homebranch` varchar(4) default NULL,
1016 `price` decimal(28,6) default NULL,
1017 `replacementprice` decimal(28,6) default NULL,
1018 `replacementpricedate` date default NULL,
1019 `datelastborrowed` date default NULL,
1020 `datelastseen` date default NULL,
1021 `multivolume` tinyint(1) default NULL,
1022 `stack` tinyint(1) default NULL,
1023 `notforloan` tinyint(1) default NULL,
1024 `itemlost` tinyint(1) default NULL,
1025 `wthdrawn` tinyint(1) default NULL,
1026 `bulk` varchar(30) default NULL,
1027 `issues` smallint(6) default NULL,
1028 `renewals` smallint(6) default NULL,
1029 `reserves` smallint(6) default NULL,
1030 `restricted` tinyint(1) default NULL,
1031 `binding` decimal(28,6) default NULL,
1033 `holdingbranch` varchar(4) default NULL,
1034 `interim` tinyint(1) default NULL,
1035 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1038 `location` varchar(80) default NULL,
1039 `itemcallnumber` varchar(30) default NULL,
1040 `onloan` date default NULL,
1041 `Cutterextra` varchar(45) default NULL,
1042 `issue_date` date default '0000-00-00',
1043 `itype` varchar(10) default NULL,
1044 PRIMARY KEY (`itemnumber`),
1045 UNIQUE KEY `barcode` (`barcode`),
1046 KEY `itembarcodeidx` (`barcode`),
1047 KEY `itembinoidx` (`biblioitemnumber`),
1048 KEY `itembibnoidx` (`biblionumber`)
1049 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1051 -- --------------------------------------------------------
1054 -- Structure de la table `ethnicity`
1056 -- Création: Lundi 27 Novembre 2006 à 17:57
1059 DROP TABLE IF EXISTS `ethnicity`;
1060 CREATE TABLE IF NOT EXISTS `ethnicity` (
1061 `code` varchar(10) NOT NULL default '',
1062 `name` varchar(255) default NULL,
1063 PRIMARY KEY (`code`)
1064 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1066 -- --------------------------------------------------------
1069 -- Structure de la table `issues`
1071 -- Création: Mardi 06 Février 2007 à 11:14
1074 DROP TABLE IF EXISTS `issues`;
1075 CREATE TABLE IF NOT EXISTS `issues` (
1076 `borrowernumber` int(11) default '0',
1077 `itemnumber` int(11) default '0',
1078 `date_due` date default NULL,
1079 `branchcode` varchar(10) default '',
1080 `issuingbranch` varchar(18) default NULL,
1081 `issuedate` date NOT NULL default '0000-00-00',
1082 `returndate` date default NULL,
1083 `lastreneweddate` date default NULL,
1084 `return` varchar(4) default NULL,
1085 `renewals` tinyint(4) default NULL,
1086 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1087 KEY `issuesborridx` (`borrowernumber`),
1088 KEY `issuesitemidx` (`itemnumber`),
1089 KEY `bordate` (`borrowernumber`,`timestamp`)
1090 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1092 -- --------------------------------------------------------
1095 -- Structure de la table `issuingrules`
1097 -- Création: Lundi 27 Novembre 2006 à 18:41
1100 DROP TABLE IF EXISTS `issuingrules`;
1101 CREATE TABLE IF NOT EXISTS `issuingrules` (
1102 `categorycode` varchar(2) NOT NULL default '',
1103 `itemtype` varchar(4) NOT NULL default '',
1104 `restrictedtype` tinyint(1) default NULL,
1105 `rentaldiscount` decimal(28,6) default NULL,
1106 `reservecharge` decimal(28,6) default NULL,
1107 `fine` decimal(28,6) default NULL,
1108 `firstremind` int(11) default NULL,
1109 `chargeperiod` int(11) default NULL,
1110 `accountsent` int(11) default NULL,
1111 `chargename` varchar(100) default NULL,
1112 `maxissueqty` int(4) default NULL,
1113 `issuelength` int(4) default NULL,
1114 `branchcode` varchar(4) NOT NULL default '',
1115 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
1116 KEY `categorycode` (`categorycode`),
1117 KEY `itemtype` (`itemtype`)
1118 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1120 -- --------------------------------------------------------
1123 -- Structure de la table `items`
1125 -- Création: Mardi 06 Février 2007 à 11:14
1128 DROP TABLE IF EXISTS `items`;
1129 CREATE TABLE IF NOT EXISTS `items` (
1130 `itemnumber` int(11) NOT NULL default '0',
1131 `biblionumber` int(11) NOT NULL default '0',
1132 `multivolumepart` varchar(30) default NULL,
1133 `biblioitemnumber` int(11) NOT NULL default '0',
1134 `barcode` varchar(20) default NULL,
1135 `dateaccessioned` date default NULL,
1136 `booksellerid` varchar(10) default NULL,
1137 `homebranch` varchar(4) default NULL,
1138 `price` decimal(8,2) default NULL,
1139 `replacementprice` decimal(8,2) default NULL,
1140 `replacementpricedate` date default NULL,
1141 `datelastborrowed` date default NULL,
1142 `datelastseen` date default NULL,
1143 `multivolume` tinyint(1) default NULL,
1144 `stack` tinyint(1) default NULL,
1145 `notforloan` tinyint(1) default '0',
1146 `itemlost` tinyint(1) default NULL,
1147 `wthdrawn` tinyint(1) default NULL,
1148 `itemcallnumber` varchar(30) default NULL,
1149 `issues` smallint(6) default NULL,
1150 `renewals` smallint(6) default NULL,
1151 `reserves` smallint(6) default NULL,
1152 `restricted` tinyint(1) default NULL,
1153 `binding` decimal(28,6) default NULL,
1155 `holdingbranch` varchar(10) default '',
1157 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1158 `location` varchar(80) default NULL,
1159 `onloan` date default NULL,
1160 `Cutterextra` varchar(45) default NULL,
1161 `issue_date` date default '0000-00-00',
1162 `itype` varchar(10) default '',
1163 PRIMARY KEY (`itemnumber`),
1164 KEY `itembarcodeidx` (`barcode`),
1165 KEY `itembinoidx` (`biblioitemnumber`),
1166 KEY `itembibnoidx` (`biblionumber`),
1167 KEY `homebranch` (`homebranch`),
1168 KEY `holdingbranch` (`holdingbranch`)
1169 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1171 -- --------------------------------------------------------
1174 -- Structure de la table `itemsprices`
1176 -- Création: Lundi 27 Novembre 2006 à 17:57
1179 DROP TABLE IF EXISTS `itemsprices`;
1180 CREATE TABLE IF NOT EXISTS `itemsprices` (
1181 `itemnumber` int(11) default NULL,
1182 `price1` decimal(28,6) default NULL,
1183 `price2` decimal(28,6) default NULL
1184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1186 -- --------------------------------------------------------
1189 -- Structure de la table `itemtypes`
1191 -- Création: Mardi 06 Février 2007 à 11:14
1194 DROP TABLE IF EXISTS `itemtypes`;
1195 CREATE TABLE IF NOT EXISTS `itemtypes` (
1196 `itemtype` varchar(10) NOT NULL default '',
1198 `renewalsallowed` smallint(6) default NULL,
1199 `rentalcharge` double(16,4) default NULL,
1200 `notforloan` smallint(6) default '0',
1201 `imageurl` varchar(200) default NULL,
1203 PRIMARY KEY (`itemtype`),
1204 UNIQUE KEY `itemtype` (`itemtype`)
1205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1207 -- --------------------------------------------------------
1210 -- Structure de la table `labels`
1212 -- Création: Lundi 27 Novembre 2006 à 17:57
1215 DROP TABLE IF EXISTS `labels`;
1216 CREATE TABLE IF NOT EXISTS `labels` (
1217 `labelid` int(11) NOT NULL auto_increment,
1218 `itemnumber` varchar(100) NOT NULL default '',
1219 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1220 PRIMARY KEY (`labelid`)
1221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1223 -- --------------------------------------------------------
1226 -- Structure de la table `labels_conf`
1228 -- Création: Lundi 27 Novembre 2006 à 17:57
1231 DROP TABLE IF EXISTS `labels_conf`;
1232 CREATE TABLE IF NOT EXISTS `labels_conf` (
1233 `id` int(4) NOT NULL auto_increment,
1234 `barcodetype` char(100) default '',
1235 `title` tinyint(1) default '0',
1236 `isbn` tinyint(1) default '0',
1237 `itemtype` tinyint(1) default '0',
1238 `barcode` tinyint(1) default '0',
1239 `dewey` tinyint(1) default '0',
1240 `class` tinyint(1) default '0',
1241 `author` tinyint(1) default '0',
1242 `papertype` char(100) default '',
1243 `startrow` int(2) default NULL,
1245 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1247 -- --------------------------------------------------------
1250 -- Structure de la table `letter`
1252 -- Création: Lundi 27 Novembre 2006 à 17:57
1255 DROP TABLE IF EXISTS `letter`;
1256 CREATE TABLE IF NOT EXISTS `letter` (
1257 `module` varchar(20) NOT NULL default '',
1258 `code` varchar(20) NOT NULL default '',
1259 `name` varchar(100) NOT NULL default '',
1260 `title` varchar(200) NOT NULL default '',
1262 PRIMARY KEY (`module`,`code`)
1263 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1265 -- --------------------------------------------------------
1268 -- Structure de la table `marc_biblio`
1270 -- Création: Lundi 27 Novembre 2006 à 17:57
1273 DROP TABLE IF EXISTS `marc_biblio`;
1274 CREATE TABLE IF NOT EXISTS `marc_biblio` (
1275 `bibid` bigint(20) unsigned NOT NULL auto_increment,
1276 `biblionumber` int(11) NOT NULL default '0',
1277 `datecreated` date NOT NULL default '0000-00-00',
1278 `datemodified` date default NULL,
1279 `origincode` char(20) default NULL,
1280 `frameworkcode` char(4) NOT NULL default '',
1281 PRIMARY KEY (`bibid`),
1282 KEY `origincode` (`origincode`),
1283 KEY `biblionumber` (`biblionumber`)
1284 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1286 -- --------------------------------------------------------
1289 -- Structure de la table `marc_blob_subfield`
1291 -- Création: Lundi 27 Novembre 2006 à 17:57
1294 DROP TABLE IF EXISTS `marc_blob_subfield`;
1295 CREATE TABLE IF NOT EXISTS `marc_blob_subfield` (
1296 `blobidlink` bigint(20) NOT NULL auto_increment,
1297 `subfieldvalue` longtext NOT NULL,
1298 PRIMARY KEY (`blobidlink`)
1299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1301 -- --------------------------------------------------------
1304 -- Structure de la table `marc_breeding`
1306 -- Création: Lundi 27 Novembre 2006 à 17:58
1309 DROP TABLE IF EXISTS `marc_breeding`;
1310 CREATE TABLE IF NOT EXISTS `marc_breeding` (
1311 `id` bigint(20) NOT NULL auto_increment,
1312 `file` varchar(80) NOT NULL default '',
1313 `isbn` varchar(10) NOT NULL default '',
1314 `title` varchar(128) default NULL,
1315 `author` varchar(80) default NULL,
1316 `marc` text NOT NULL,
1317 `encoding` varchar(40) NOT NULL default '',
1318 `z3950random` varchar(40) default NULL,
1320 KEY `title` (`title`),
1322 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1324 -- --------------------------------------------------------
1327 -- Structure de la table `marc_subfield_structure`
1329 -- Création: Lundi 27 Novembre 2006 à 17:58
1332 DROP TABLE IF EXISTS `marc_subfield_structure`;
1333 CREATE TABLE IF NOT EXISTS `marc_subfield_structure` (
1334 `tagfield` varchar(3) NOT NULL default '',
1335 `tagsubfield` char(1) NOT NULL default '',
1336 `liblibrarian` varchar(255) NOT NULL default '',
1337 `libopac` varchar(255) NOT NULL default '',
1338 `repeatable` tinyint(4) NOT NULL default '0',
1339 `mandatory` tinyint(4) NOT NULL default '0',
1340 `kohafield` varchar(40) default NULL,
1341 `tab` tinyint(1) default NULL,
1342 `authorised_value` varchar(10) default NULL,
1343 `authtypecode` varchar(10) default NULL,
1344 `value_builder` varchar(80) default NULL,
1345 `isurl` tinyint(1) default NULL,
1346 `hidden` tinyint(1) default NULL,
1347 `frameworkcode` varchar(4) NOT NULL default '',
1348 `seealso` varchar(255) default NULL,
1349 `link` varchar(80) default NULL,
1350 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1351 KEY `tab` (`frameworkcode`,`tab`),
1352 KEY `kohafield` (`frameworkcode`,`kohafield`)
1353 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1355 -- --------------------------------------------------------
1358 -- Structure de la table `marc_subfield_table`
1360 -- Création: Lundi 27 Novembre 2006 à 18:11
1363 DROP TABLE IF EXISTS `marc_subfield_table`;
1364 CREATE TABLE IF NOT EXISTS `marc_subfield_table` (
1365 `subfieldid` bigint(20) unsigned NOT NULL auto_increment,
1366 `bibid` bigint(20) unsigned NOT NULL default '0',
1367 `tag` varchar(3) NOT NULL default '',
1368 `tagorder` int(11) NOT NULL default '1',
1369 `tag_indicator` varchar(2) NOT NULL default '',
1370 `subfieldcode` char(1) NOT NULL default '',
1371 `subfieldorder` tinyint(4) NOT NULL default '1',
1372 `subfieldvalue` varchar(255) default NULL,
1373 `valuebloblink` bigint(20) default NULL,
1374 PRIMARY KEY (`subfieldid`),
1375 KEY `bibid` (`bibid`),
1377 KEY `tag_indicator` (`tag_indicator`),
1378 KEY `subfieldorder` (`subfieldorder`),
1379 KEY `subfieldcode` (`subfieldcode`),
1380 KEY `subfieldvalue` (`subfieldvalue`),
1381 KEY `tagorder` (`tagorder`)
1382 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1384 -- --------------------------------------------------------
1387 -- Structure de la table `marc_tag_structure`
1389 -- Création: Lundi 27 Novembre 2006 à 18:11
1392 DROP TABLE IF EXISTS `marc_tag_structure`;
1393 CREATE TABLE IF NOT EXISTS `marc_tag_structure` (
1394 `tagfield` char(3) NOT NULL default '',
1395 `liblibrarian` char(255) NOT NULL default '',
1396 `libopac` char(255) NOT NULL default '',
1397 `repeatable` tinyint(4) NOT NULL default '0',
1398 `mandatory` tinyint(4) NOT NULL default '0',
1399 `authorised_value` char(10) default NULL,
1400 `frameworkcode` char(4) NOT NULL default '',
1401 PRIMARY KEY (`frameworkcode`,`tagfield`)
1402 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1404 -- --------------------------------------------------------
1407 -- Structure de la table `marc_word`
1409 -- Création: Lundi 27 Novembre 2006 à 18:39
1412 DROP TABLE IF EXISTS `marc_word`;
1413 CREATE TABLE IF NOT EXISTS `marc_word` (
1414 `bibid` bigint(20) NOT NULL default '0',
1415 `tagsubfield` varchar(4) NOT NULL default '',
1416 `tagorder` tinyint(4) NOT NULL default '1',
1417 `subfieldorder` tinyint(4) NOT NULL default '1',
1418 `word` varchar(255) NOT NULL default '',
1419 `sndx_word` varchar(255) NOT NULL default '',
1420 KEY `bibid` (`bibid`),
1421 KEY `tagorder` (`tagorder`),
1422 KEY `subfieldorder` (`subfieldorder`),
1423 KEY `word` (`word`),
1424 KEY `sndx_word` (`sndx_word`),
1425 KEY `Search_Marc` (`tagsubfield`,`word`)
1426 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1428 -- --------------------------------------------------------
1431 -- Structure de la table `marcrecorddone`
1433 -- Création: Lundi 27 Novembre 2006 à 18:39
1436 DROP TABLE IF EXISTS `marcrecorddone`;
1437 CREATE TABLE IF NOT EXISTS `marcrecorddone` (
1438 `isbn` char(40) default NULL,
1439 `issn` char(40) default NULL,
1440 `lccn` char(40) default NULL,
1441 `controlnumber` char(40) default NULL
1442 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1444 -- --------------------------------------------------------
1447 -- Structure de la table `mediatypetable`
1449 -- Création: Lundi 27 Novembre 2006 à 18:39
1452 DROP TABLE IF EXISTS `mediatypetable`;
1453 CREATE TABLE IF NOT EXISTS `mediatypetable` (
1454 `mediatypecode` varchar(5) NOT NULL default '',
1456 `itemtypecodes` text,
1457 PRIMARY KEY (`mediatypecode`)
1458 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1460 -- --------------------------------------------------------
1463 -- Structure de la table `notifys`
1465 -- Création: Vendredi 08 Décembre 2006 à 16:47
1468 DROP TABLE IF EXISTS `notifys`;
1469 CREATE TABLE IF NOT EXISTS `notifys` (
1470 `notify_id` int(11) NOT NULL default '0',
1471 `borrowernumber` int(11) NOT NULL default '0',
1472 `itemnumber` int(11) NOT NULL default '0',
1473 `notify_date` date NOT NULL default '0000-00-00',
1474 `notify_send_date` date default NULL,
1475 `notify_level` int(1) NOT NULL default '0',
1476 `method` varchar(20) NOT NULL default ''
1477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1479 -- --------------------------------------------------------
1482 -- Structure de la table `opac_news`
1484 -- Création: Mardi 06 Février 2007 à 11:14
1487 DROP TABLE IF EXISTS `opac_news`;
1488 CREATE TABLE IF NOT EXISTS `opac_news` (
1489 `idnew` int(10) unsigned NOT NULL auto_increment,
1490 `title` varchar(250) NOT NULL default '',
1491 `new` text NOT NULL,
1492 `lang` varchar(4) NOT NULL default '',
1493 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1494 `expirationdate` date default NULL,
1495 `number` int(11) default '0',
1496 PRIMARY KEY (`idnew`)
1497 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1499 -- --------------------------------------------------------
1502 -- Structure de la table `overduerules`
1504 -- Création: Lundi 27 Novembre 2006 à 18:39
1507 DROP TABLE IF EXISTS `overduerules`;
1508 CREATE TABLE IF NOT EXISTS `overduerules` (
1509 `branchcode` varchar(255) NOT NULL default '',
1510 `categorycode` varchar(2) NOT NULL default '',
1511 `delay1` int(4) default '0',
1512 `letter1` varchar(20) default NULL,
1513 `debarred1` char(1) default '0',
1514 `delay2` int(4) default '0',
1515 `debarred2` char(1) default '0',
1516 `letter2` varchar(20) default NULL,
1517 `delay3` int(4) default '0',
1518 `letter3` varchar(20) default NULL,
1519 `debarred3` int(1) default '0',
1520 PRIMARY KEY (`branchcode`,`categorycode`)
1521 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1523 -- --------------------------------------------------------
1526 -- Structure de la table `phrase_log`
1528 -- Création: Lundi 27 Novembre 2006 à 18:39
1531 DROP TABLE IF EXISTS `phrase_log`;
1532 CREATE TABLE IF NOT EXISTS `phrase_log` (
1533 `phr_phrase` varchar(100) NOT NULL default '',
1534 `phr_resultcount` int(11) NOT NULL default '0',
1535 `phr_ip` varchar(30) NOT NULL default '',
1536 `user` varchar(45) default NULL,
1537 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1538 `actual` text NOT NULL,
1539 KEY `phr_ip` (`phr_ip`)
1540 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1542 -- --------------------------------------------------------
1545 -- Structure de la table `printers`
1547 -- Création: Lundi 27 Novembre 2006 à 18:39
1550 DROP TABLE IF EXISTS `printers`;
1551 CREATE TABLE IF NOT EXISTS `printers` (
1552 `printername` char(40) NOT NULL default '''''',
1553 `printqueue` char(20) default NULL,
1554 `printtype` char(20) default NULL,
1555 PRIMARY KEY (`printername`)
1556 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1558 -- --------------------------------------------------------
1561 -- Structure de la table `repeatable_holidays`
1563 -- Création: Lundi 27 Novembre 2006 à 18:39
1566 DROP TABLE IF EXISTS `repeatable_holidays`;
1567 CREATE TABLE IF NOT EXISTS `repeatable_holidays` (
1568 `id` int(11) NOT NULL auto_increment,
1569 `branchcode` varchar(4) NOT NULL default '',
1570 `weekday` smallint(6) default NULL,
1571 `day` smallint(6) default NULL,
1572 `month` smallint(6) default NULL,
1573 `title` varchar(50) NOT NULL default '',
1574 `description` text NOT NULL,
1576 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1578 -- --------------------------------------------------------
1581 -- Structure de la table `reserveconstraints`
1583 -- Création: Lundi 27 Novembre 2006 à 18:39
1586 DROP TABLE IF EXISTS `reserveconstraints`;
1587 CREATE TABLE IF NOT EXISTS `reserveconstraints` (
1588 `borrowernumber` int(11) NOT NULL default '0',
1589 `reservedate` date NOT NULL default '0000-00-00',
1590 `biblionumber` int(11) NOT NULL default '0',
1591 `biblioitemnumber` int(11) default NULL,
1592 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1595 -- --------------------------------------------------------
1598 -- Structure de la table `reserves`
1600 -- Création: Lundi 27 Novembre 2006 à 18:41
1603 DROP TABLE IF EXISTS `reserves`;
1604 CREATE TABLE IF NOT EXISTS `reserves` (
1605 `borrowernumber` int(11) NOT NULL default '0',
1606 `reservedate` date NOT NULL default '0000-00-00',
1607 `biblionumber` int(11) NOT NULL default '0',
1608 `constrainttype` char(1) default NULL,
1609 `branchcode` varchar(4) default NULL,
1610 `notificationdate` date default NULL,
1611 `reminderdate` date default NULL,
1612 `cancellationdate` date default NULL,
1613 `reservenotes` text,
1614 `priority` smallint(6) default NULL,
1615 `found` char(1) default NULL,
1616 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1617 `itemnumber` int(11) default NULL,
1618 `waitingdate` date default '0000-00-00',
1619 KEY `borrowernumber` (`borrowernumber`),
1620 KEY `biblionumber` (`biblionumber`),
1621 KEY `itemnumber` (`itemnumber`),
1622 KEY `branchcode` (`branchcode`)
1623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1625 -- --------------------------------------------------------
1628 -- Structure de la table `reviews`
1630 -- Création: Lundi 27 Novembre 2006 à 18:39
1633 DROP TABLE IF EXISTS `reviews`;
1634 CREATE TABLE IF NOT EXISTS `reviews` (
1635 `reviewid` int(11) NOT NULL auto_increment,
1636 `borrowernumber` int(11) default NULL,
1637 `biblionumber` int(11) default NULL,
1639 `approved` tinyint(4) default NULL,
1640 `datereviewed` datetime default NULL,
1641 PRIMARY KEY (`reviewid`)
1642 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1644 -- --------------------------------------------------------
1647 -- Structure de la table `roadtype`
1649 -- Création: Lundi 27 Novembre 2006 à 18:39
1652 DROP TABLE IF EXISTS `roadtype`;
1653 CREATE TABLE IF NOT EXISTS `roadtype` (
1654 `roadtypeid` int(11) NOT NULL auto_increment,
1655 `road_type` char(100) NOT NULL default '',
1656 PRIMARY KEY (`roadtypeid`)
1657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1659 -- --------------------------------------------------------
1662 -- Structure de la table `serial`
1664 -- Création: Mardi 06 Février 2007 à 11:14
1667 DROP TABLE IF EXISTS `serial`;
1668 CREATE TABLE IF NOT EXISTS `serial` (
1669 `serialid` int(11) NOT NULL auto_increment,
1670 `biblionumber` varchar(100) NOT NULL default '',
1671 `subscriptionid` varchar(100) NOT NULL default '',
1672 `serialseq` varchar(100) NOT NULL default '',
1673 `status` tinyint(4) NOT NULL default '0',
1674 `planneddate` date NOT NULL default '0000-00-00',
1677 `routingnotes` text,
1678 `publisheddate` date default NULL,
1679 `claimdate` date default '0000-00-00',
1680 PRIMARY KEY (`serialid`)
1681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1683 -- --------------------------------------------------------
1686 -- Structure de la table `sessionqueries`
1688 -- Création: Lundi 27 Novembre 2006 à 18:39
1691 DROP TABLE IF EXISTS `sessionqueries`;
1692 CREATE TABLE IF NOT EXISTS `sessionqueries` (
1693 `sessionID` varchar(255) NOT NULL default '',
1694 `userid` varchar(100) NOT NULL default '',
1695 `ip` varchar(18) NOT NULL default '',
1697 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1699 -- --------------------------------------------------------
1702 -- Structure de la table `sessions`
1704 -- Création: Lundi 27 Novembre 2006 à 18:39
1707 DROP TABLE IF EXISTS `sessions`;
1708 CREATE TABLE IF NOT EXISTS `sessions` (
1709 `sessionID` varchar(255) NOT NULL default '',
1710 `userid` varchar(255) default NULL,
1711 `ip` varchar(16) default NULL,
1712 `lasttime` int(11) default NULL,
1713 PRIMARY KEY (`sessionID`)
1714 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1716 -- --------------------------------------------------------
1719 -- Structure de la table `shelfcontents`
1721 -- Création: Lundi 27 Novembre 2006 à 18:41
1724 DROP TABLE IF EXISTS `shelfcontents`;
1725 CREATE TABLE IF NOT EXISTS `shelfcontents` (
1726 `shelfnumber` int(11) NOT NULL default '0',
1727 `itemnumber` int(11) NOT NULL default '0',
1728 `flags` int(11) default NULL,
1729 `dateadded` timestamp NULL default NULL,
1730 KEY `shelfnumber` (`shelfnumber`),
1731 KEY `itemnumber` (`itemnumber`)
1732 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1734 -- --------------------------------------------------------
1737 -- Structure de la table `special_holidays`
1739 -- Création: Lundi 27 Novembre 2006 à 18:39
1742 DROP TABLE IF EXISTS `special_holidays`;
1743 CREATE TABLE IF NOT EXISTS `special_holidays` (
1744 `id` int(11) NOT NULL auto_increment,
1745 `branchcode` varchar(4) NOT NULL default '',
1746 `day` smallint(6) NOT NULL default '0',
1747 `month` smallint(6) NOT NULL default '0',
1748 `year` smallint(6) NOT NULL default '0',
1749 `isexception` smallint(1) NOT NULL default '1',
1750 `title` varchar(50) NOT NULL default '',
1751 `description` text NOT NULL,
1753 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1755 -- --------------------------------------------------------
1758 -- Structure de la table `statistics`
1760 -- Création: Lundi 27 Novembre 2006 à 18:39
1763 DROP TABLE IF EXISTS `statistics`;
1764 CREATE TABLE IF NOT EXISTS `statistics` (
1765 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
1766 `branch` varchar(4) default NULL,
1767 `proccode` varchar(4) default NULL,
1768 `value` double(16,4) default NULL,
1769 `type` varchar(16) default NULL,
1771 `usercode` varchar(10) default NULL,
1772 `itemnumber` int(11) default NULL,
1773 `itemtype` varchar(4) default NULL,
1774 `borrowernumber` int(11) default NULL,
1775 `associatedborrower` int(11) default NULL,
1776 KEY `timeidx` (`datetime`)
1777 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1779 -- --------------------------------------------------------
1782 -- Structure de la table `stopwords`
1784 -- Création: Lundi 27 Novembre 2006 à 18:39
1787 DROP TABLE IF EXISTS `stopwords`;
1788 CREATE TABLE IF NOT EXISTS `stopwords` (
1789 `word` varchar(255) default NULL
1790 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1792 -- --------------------------------------------------------
1795 -- Structure de la table `subcategorytable`
1797 -- Création: Lundi 27 Novembre 2006 à 18:39
1800 DROP TABLE IF EXISTS `subcategorytable`;
1801 CREATE TABLE IF NOT EXISTS `subcategorytable` (
1802 `subcategorycode` varchar(5) NOT NULL default '',
1804 `itemtypecodes` text,
1805 PRIMARY KEY (`subcategorycode`)
1806 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1808 -- --------------------------------------------------------
1811 -- Structure de la table `subscription`
1813 -- Création: Vendredi 26 Janvier 2007 à 12:44
1816 DROP TABLE IF EXISTS `subscription`;
1817 CREATE TABLE IF NOT EXISTS `subscription` (
1818 `biblionumber` int(11) NOT NULL default '0',
1819 `manualhistory` tinyint(1) NOT NULL default '0',
1820 `subscriptionid` int(11) NOT NULL auto_increment,
1821 `librarian` varchar(100) default '',
1822 `startdate` date default '0000-00-00',
1823 `aqbooksellerid` int(11) default '0',
1824 `cost` int(11) default '0',
1825 `aqbudgetid` int(11) default '0',
1826 `weeklength` tinyint(4) default '0',
1827 `monthlength` tinyint(4) default '0',
1828 `numberlength` tinyint(4) default '0',
1829 `periodicity` tinyint(4) default '0',
1830 `dow` varchar(100) default '',
1831 `numberingmethod` varchar(100) default '',
1833 `status` varchar(100) NOT NULL default '',
1834 `add1` int(11) default '0',
1835 `every1` int(11) default '0',
1836 `whenmorethan1` int(11) default '0',
1837 `setto1` int(11) default NULL,
1838 `lastvalue1` int(11) default NULL,
1839 `add2` int(11) default '0',
1840 `every2` int(11) default '0',
1841 `whenmorethan2` int(11) default '0',
1842 `setto2` int(11) default NULL,
1843 `lastvalue2` int(11) default NULL,
1844 `add3` int(11) default '0',
1845 `every3` int(11) default '0',
1846 `innerloop1` int(11) default '0',
1847 `innerloop2` int(11) default '0',
1848 `innerloop3` int(11) default '0',
1849 `whenmorethan3` int(11) default '0',
1850 `setto3` int(11) default NULL,
1851 `lastvalue3` int(11) default NULL,
1852 `issuesatonce` tinyint(3) NOT NULL default '1',
1853 `firstacquidate` date NOT NULL default '0000-00-00',
1854 `irregularity` text,
1855 `letter` varchar(20) default NULL,
1856 `numberpattern` tinyint(3) default '0',
1857 `distributedto` text,
1859 `hemisphere` tinyint(3) default '0',
1860 `branchcode` varchar(12) NOT NULL default '''''',
1861 `internalnotes` longtext,
1862 PRIMARY KEY (`subscriptionid`)
1863 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1865 -- --------------------------------------------------------
1868 -- Structure de la table `subscriptionhistory`
1870 -- Création: Lundi 27 Novembre 2006 à 18:39
1873 DROP TABLE IF EXISTS `subscriptionhistory`;
1874 CREATE TABLE IF NOT EXISTS `subscriptionhistory` (
1875 `biblionumber` int(11) NOT NULL default '0',
1876 `subscriptionid` int(11) NOT NULL default '0',
1877 `histstartdate` date NOT NULL default '0000-00-00',
1878 `enddate` date default '0000-00-00',
1879 `missinglist` longtext NOT NULL,
1880 `recievedlist` longtext NOT NULL,
1881 `opacnote` varchar(150) NOT NULL default '',
1882 `librariannote` varchar(150) NOT NULL default '',
1883 PRIMARY KEY (`subscriptionid`),
1884 KEY `biblionumber` (`biblionumber`)
1885 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1887 -- --------------------------------------------------------
1890 -- Structure de la table `subscriptionroutinglist`
1892 -- Création: Lundi 27 Novembre 2006 à 18:39
1895 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1896 CREATE TABLE IF NOT EXISTS `subscriptionroutinglist` (
1897 `routingid` int(11) NOT NULL auto_increment,
1898 `borrowernumber` int(11) default NULL,
1899 `ranking` int(11) default NULL,
1900 `subscriptionid` int(11) default NULL,
1901 PRIMARY KEY (`routingid`)
1902 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1904 -- --------------------------------------------------------
1907 -- Structure de la table `suggestions`
1909 -- Création: Lundi 27 Novembre 2006 à 18:40
1912 DROP TABLE IF EXISTS `suggestions`;
1913 CREATE TABLE IF NOT EXISTS `suggestions` (
1914 `suggestionid` int(8) NOT NULL auto_increment,
1915 `suggestedby` int(11) NOT NULL default '0',
1916 `managedby` int(11) default NULL,
1917 `STATUS` varchar(10) NOT NULL default '',
1919 `author` varchar(80) default NULL,
1920 `title` varchar(80) default NULL,
1921 `copyrightdate` smallint(6) default NULL,
1922 `publishercode` varchar(255) default NULL,
1923 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1924 `volumedesc` varchar(255) default NULL,
1925 `publicationyear` smallint(6) default '0',
1926 `place` varchar(255) default NULL,
1927 `isbn` varchar(10) default NULL,
1928 `mailoverseeing` smallint(1) default '0',
1929 `biblionumber` int(11) default NULL,
1931 PRIMARY KEY (`suggestionid`),
1932 KEY `suggestedby` (`suggestedby`),
1933 KEY `managedby` (`managedby`)
1934 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1936 -- --------------------------------------------------------
1939 -- Structure de la table `systempreferences`
1941 -- Création: Lundi 27 Novembre 2006 à 18:40
1944 DROP TABLE IF EXISTS `systempreferences`;
1945 CREATE TABLE IF NOT EXISTS `systempreferences` (
1946 `variable` varchar(50) NOT NULL default '',
1950 `type` varchar(20) default NULL,
1951 PRIMARY KEY (`variable`)
1952 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1954 -- --------------------------------------------------------
1957 -- Structure de la table `tags`
1959 -- Création: Mardi 06 Février 2007 à 11:14
1962 DROP TABLE IF EXISTS `tags`;
1963 CREATE TABLE IF NOT EXISTS `tags` (
1964 `entry` varchar(255) NOT NULL default '',
1965 `weight` bigint(20) NOT NULL default '0',
1966 PRIMARY KEY (`entry`)
1967 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1969 -- --------------------------------------------------------
1972 -- Structure de la table `uploadedmarc`
1974 -- Création: Lundi 27 Novembre 2006 à 18:39
1977 DROP TABLE IF EXISTS `uploadedmarc`;
1978 CREATE TABLE IF NOT EXISTS `uploadedmarc` (
1979 `id` int(11) NOT NULL auto_increment,
1981 `hidden` smallint(6) default NULL,
1982 `name` varchar(255) default NULL,
1984 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1986 -- --------------------------------------------------------
1989 -- Structure de la table `userflags`
1991 -- Création: Lundi 27 Novembre 2006 à 18:39
1994 DROP TABLE IF EXISTS `userflags`;
1995 CREATE TABLE IF NOT EXISTS `userflags` (
1996 `bit` int(11) NOT NULL default '0',
1997 `flag` char(30) default NULL,
1998 `flagdesc` char(255) default NULL,
1999 `defaulton` int(11) default NULL
2000 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2002 -- --------------------------------------------------------
2005 -- Structure de la table `users`
2007 -- Création: Lundi 27 Novembre 2006 à 18:39
2010 DROP TABLE IF EXISTS `users`;
2011 CREATE TABLE IF NOT EXISTS `users` (
2012 `usercode` varchar(10) default NULL,
2015 `level` smallint(6) default NULL
2016 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018 -- --------------------------------------------------------
2021 -- Structure de la table `websites`
2023 -- Création: Lundi 27 Novembre 2006 à 18:39
2026 DROP TABLE IF EXISTS `websites`;
2027 CREATE TABLE IF NOT EXISTS `websites` (
2028 `websitenumber` int(11) NOT NULL auto_increment,
2029 `biblionumber` int(11) NOT NULL default '0',
2032 `url` varchar(255) default NULL,
2033 PRIMARY KEY (`websitenumber`)
2034 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2036 -- --------------------------------------------------------
2039 -- Structure de la table `z3950queue`
2041 -- Création: Lundi 27 Novembre 2006 à 18:39
2044 DROP TABLE IF EXISTS `z3950queue`;
2045 CREATE TABLE IF NOT EXISTS `z3950queue` (
2046 `id` int(11) NOT NULL auto_increment,
2048 `type` varchar(10) default NULL,
2049 `startdate` int(11) default NULL,
2050 `enddate` int(11) default NULL,
2051 `done` smallint(6) default NULL,
2053 `numrecords` int(11) default NULL,
2055 `identifier` varchar(30) default NULL,
2057 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2059 -- --------------------------------------------------------
2062 -- Structure de la table `z3950results`
2064 -- Création: Lundi 27 Novembre 2006 à 18:39
2067 DROP TABLE IF EXISTS `z3950results`;
2068 CREATE TABLE IF NOT EXISTS `z3950results` (
2069 `id` int(11) NOT NULL auto_increment,
2070 `queryid` int(11) default NULL,
2071 `server` varchar(255) default NULL,
2072 `startdate` int(11) default NULL,
2073 `enddate` int(11) default NULL,
2075 `numrecords` int(11) default NULL,
2076 `numdownloaded` int(11) default NULL,
2077 `highestseen` int(11) default NULL,
2078 `active` smallint(6) default NULL,
2080 UNIQUE KEY `query_server` (`queryid`,`server`)
2081 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2083 -- --------------------------------------------------------
2086 -- Structure de la table `z3950servers`
2088 -- Création: Lundi 27 Novembre 2006 à 18:39
2091 DROP TABLE IF EXISTS `z3950servers`;
2092 CREATE TABLE IF NOT EXISTS `z3950servers` (
2093 `host` varchar(255) default NULL,
2094 `port` int(11) default NULL,
2095 `db` varchar(255) default NULL,
2096 `userid` varchar(255) default NULL,
2097 `password` varchar(255) default NULL,
2099 `description` text NOT NULL,
2100 `id` int(11) NOT NULL auto_increment,
2101 `checked` smallint(6) default NULL,
2102 `rank` int(11) default NULL,
2103 `syntax` varchar(80) default NULL,
2104 `position` enum('primary','secondary','') NOT NULL default 'primary',
2106 `type` enum('zed','opensearch') NOT NULL default 'zed',
2108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2110 -- --------------------------------------------------------
2113 -- Structure de la table `zebraqueue`
2115 -- Création: Mardi 16 Janvier 2007 à 14:19
2118 DROP TABLE IF EXISTS `zebraqueue`;
2119 CREATE TABLE IF NOT EXISTS `zebraqueue` (
2120 `id` int(11) NOT NULL auto_increment,
2121 `biblio_auth_number` int(11) NOT NULL default '0',
2122 `operation` char(20) NOT NULL default '',
2123 `server` char(20) NOT NULL default '',
2125 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2128 -- Contraintes pour les tables exportées
2132 -- Contraintes pour la table `accountlines`
2134 ALTER TABLE `accountlines`
2135 ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2136 ALTER TABLE `accountlines`
2137 ADD CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
2140 -- Contraintes pour la table `aqbasket`
2142 ALTER TABLE `aqbasket`
2143 ADD CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE;
2146 -- Contraintes pour la table `aqbooksellers`
2148 ALTER TABLE `aqbooksellers`
2149 ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
2150 ALTER TABLE `aqbooksellers`
2151 ADD CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
2154 -- Contraintes pour la table `aqorderbreakdown`
2156 ALTER TABLE `aqorderbreakdown`
2157 ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2158 ALTER TABLE `aqorderbreakdown`
2159 ADD CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE;
2162 -- Contraintes pour la table `aqorders`
2164 ALTER TABLE `aqorders`
2165 ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE;
2166 ALTER TABLE `aqorders`
2167 ADD CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL;
2170 -- Contraintes pour la table `auth_tag_structure`
2172 ALTER TABLE `auth_tag_structure`
2173 ADD CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE;
2176 -- Contraintes pour la table `biblioitems`
2178 ALTER TABLE `biblioitems`
2179 ADD CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2182 -- Contraintes pour la table `borrowers`
2184 ALTER TABLE `borrowers`
2185 ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`);
2186 ALTER TABLE `borrowers`
2187 ADD CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`);
2190 -- Contraintes pour la table `branchtransfers`
2192 ALTER TABLE `branchtransfers`
2193 ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
2194 ALTER TABLE `branchtransfers`
2195 ADD CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
2196 ALTER TABLE `branchtransfers`
2197 ADD CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2200 -- Contraintes pour la table `issues`
2202 ALTER TABLE `issues`
2203 ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL;
2204 ALTER TABLE `issues`
2205 ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
2208 -- Contraintes pour la table `issuingrules`
2210 ALTER TABLE `issuingrules`
2211 ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE;
2212 ALTER TABLE `issuingrules`
2213 ADD CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE;
2216 -- Contraintes pour la table `items`
2219 ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2221 ADD CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE;
2224 -- Contraintes pour la table `reserves`
2226 ALTER TABLE `reserves`
2227 ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2228 ALTER TABLE `reserves`
2229 ADD CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2230 ALTER TABLE `reserves`
2231 ADD CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2232 ALTER TABLE `reserves`
2233 ADD CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
2236 -- Contraintes pour la table `shelfcontents`
2238 ALTER TABLE `shelfcontents`
2239 ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
2240 ALTER TABLE `shelfcontents`
2241 ADD CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;