3 -- Host: localhost Database: koha30test
4 -- ------------------------------------------------------
5 -- Server version 4.1.22
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
11 /*!40101 SET NAMES utf8 */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `auth_header`
22 DROP TABLE IF EXISTS `auth_header`;
23 CREATE TABLE `auth_header` (
24 `authid` bigint(20) unsigned NOT NULL auto_increment,
25 `authtypecode` varchar(10) NOT NULL default '',
26 `datecreated` date default NULL,
27 `datemodified` date default NULL,
28 `origincode` varchar(20) default NULL,
29 `authtrees` mediumtext,
31 `linkid` bigint(20) default NULL,
32 `marcxml` longtext NOT NULL,
33 PRIMARY KEY (`authid`),
34 KEY `origincode` (`origincode`)
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38 -- Table structure for table `auth_subfield_structure`
41 DROP TABLE IF EXISTS `auth_subfield_structure`;
42 CREATE TABLE `auth_subfield_structure` (
43 `authtypecode` varchar(10) NOT NULL default '',
44 `tagfield` varchar(3) NOT NULL default '',
45 `tagsubfield` varchar(1) NOT NULL default '',
46 `liblibrarian` varchar(255) NOT NULL default '',
47 `libopac` varchar(255) NOT NULL default '',
48 `repeatable` tinyint(4) NOT NULL default 0,
49 `mandatory` tinyint(4) NOT NULL default 0,
50 `tab` tinyint(1) default NULL,
51 `authorised_value` varchar(10) default NULL,
52 `value_builder` varchar(80) default NULL,
53 `seealso` varchar(255) default NULL,
54 `isurl` tinyint(1) default NULL,
55 `hidden` tinyint(3) NOT NULL default 0,
56 `linkid` tinyint(1) NOT NULL default 0,
57 `kohafield` varchar(45) NULL default '',
58 `frameworkcode` varchar(10) NOT NULL default '',
59 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
60 KEY `tab` (`authtypecode`,`tab`)
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64 -- Table structure for table `auth_tag_structure`
67 DROP TABLE IF EXISTS `auth_tag_structure`;
68 CREATE TABLE `auth_tag_structure` (
69 `authtypecode` varchar(10) NOT NULL default '',
70 `tagfield` varchar(3) NOT NULL default '',
71 `liblibrarian` varchar(255) NOT NULL default '',
72 `libopac` varchar(255) NOT NULL default '',
73 `repeatable` tinyint(4) NOT NULL default 0,
74 `mandatory` tinyint(4) NOT NULL default 0,
75 `authorised_value` varchar(10) default NULL,
76 PRIMARY KEY (`authtypecode`,`tagfield`),
77 CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
78 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81 -- Table structure for table `auth_types`
84 DROP TABLE IF EXISTS `auth_types`;
85 CREATE TABLE `auth_types` (
86 `authtypecode` varchar(10) NOT NULL default '',
87 `authtypetext` varchar(255) NOT NULL default '',
88 `auth_tag_to_report` varchar(3) NOT NULL default '',
89 `summary` mediumtext NOT NULL,
90 PRIMARY KEY (`authtypecode`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
94 -- Table structure for table `authorised_values`
97 DROP TABLE IF EXISTS `authorised_values`;
98 CREATE TABLE `authorised_values` (
99 `id` int(11) NOT NULL auto_increment,
100 `category` varchar(10) NOT NULL default '',
101 `authorised_value` varchar(80) NOT NULL default '',
102 `lib` varchar(80) default NULL,
103 `lib_opac` VARCHAR(80) default NULL,
104 `imageurl` varchar(200) default NULL,
106 KEY `name` (`category`),
108 KEY `auth_value_idx` (`authorised_value`)
109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
112 -- Table structure for table `biblio`
115 DROP TABLE IF EXISTS `biblio`;
116 CREATE TABLE `biblio` (
117 `biblionumber` int(11) NOT NULL auto_increment,
118 `frameworkcode` varchar(4) NOT NULL default '',
121 `unititle` mediumtext,
123 `serial` tinyint(1) default NULL,
124 `seriestitle` mediumtext,
125 `copyrightdate` smallint(6) default NULL,
126 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
127 `datecreated` DATE NOT NULL,
128 `abstract` mediumtext,
129 PRIMARY KEY (`biblionumber`),
130 KEY `blbnoidx` (`biblionumber`)
131 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
134 -- Table structure for table `biblio_framework`
137 DROP TABLE IF EXISTS `biblio_framework`;
138 CREATE TABLE `biblio_framework` (
139 `frameworkcode` varchar(4) NOT NULL default '',
140 `frameworktext` varchar(255) NOT NULL default '',
141 PRIMARY KEY (`frameworkcode`)
142 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
145 -- Table structure for table `biblioitems`
148 DROP TABLE IF EXISTS `biblioitems`;
149 CREATE TABLE `biblioitems` (
150 `biblioitemnumber` int(11) NOT NULL auto_increment,
151 `biblionumber` int(11) NOT NULL default 0,
154 `itemtype` varchar(10) default NULL,
155 `isbn` varchar(30) default NULL,
156 `issn` varchar(9) default NULL,
157 `publicationyear` text,
158 `publishercode` varchar(255) default NULL,
159 `volumedate` date default NULL,
161 `collectiontitle` mediumtext default NULL,
162 `collectionissn` text default NULL,
163 `collectionvolume` mediumtext default NULL,
164 `editionstatement` text default NULL,
165 `editionresponsibility` text default NULL,
166 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
167 `illus` varchar(255) default NULL,
168 `pages` varchar(255) default NULL,
170 `size` varchar(255) default NULL,
171 `place` varchar(255) default NULL,
172 `lccn` varchar(25) default NULL,
174 `url` varchar(255) default NULL,
175 `cn_source` varchar(10) default NULL,
176 `cn_class` varchar(30) default NULL,
177 `cn_item` varchar(10) default NULL,
178 `cn_suffix` varchar(10) default NULL,
179 `cn_sort` varchar(30) default NULL,
180 `totalissues` int(10),
181 `marcxml` longtext NOT NULL,
182 PRIMARY KEY (`biblioitemnumber`),
183 KEY `bibinoidx` (`biblioitemnumber`),
184 KEY `bibnoidx` (`biblionumber`),
187 KEY `publishercode` (`publishercode`),
188 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192 -- Table structure for table `borrowers`
195 DROP TABLE IF EXISTS `borrowers`;
196 CREATE TABLE `borrowers` (
197 `borrowernumber` int(11) NOT NULL auto_increment,
198 `cardnumber` varchar(16) default NULL,
199 `surname` mediumtext NOT NULL,
202 `othernames` mediumtext,
204 `streetnumber` varchar(10) default NULL,
205 `streettype` varchar(50) default NULL,
206 `address` mediumtext NOT NULL,
208 `city` mediumtext NOT NULL,
209 `zipcode` varchar(25) default NULL,
213 `mobile` varchar(50) default NULL,
217 `B_streetnumber` varchar(10) default NULL,
218 `B_streettype` varchar(50) default NULL,
219 `B_address` varchar(100) default NULL,
220 `B_address2` text default NULL,
222 `B_zipcode` varchar(25) default NULL,
225 `B_phone` mediumtext,
226 `dateofbirth` date default NULL,
227 `branchcode` varchar(10) NOT NULL default '',
228 `categorycode` varchar(10) NOT NULL default '',
229 `dateenrolled` date default NULL,
230 `dateexpiry` date default NULL,
231 `gonenoaddress` tinyint(1) default NULL,
232 `lost` tinyint(1) default NULL,
233 `debarred` tinyint(1) default NULL,
234 `contactname` mediumtext,
235 `contactfirstname` text,
237 `guarantorid` int(11) default NULL,
238 `borrowernotes` mediumtext,
239 `relationship` varchar(100) default NULL,
240 `ethnicity` varchar(50) default NULL,
241 `ethnotes` varchar(255) default NULL,
242 `sex` varchar(1) default NULL,
243 `password` varchar(30) default NULL,
244 `flags` int(11) default NULL,
245 `userid` varchar(30) default NULL,
246 `opacnote` mediumtext,
247 `contactnote` varchar(255) default NULL,
248 `sort1` varchar(80) default NULL,
249 `sort2` varchar(80) default NULL,
250 `altcontactfirstname` varchar(255) default NULL,
251 `altcontactsurname` varchar(255) default NULL,
252 `altcontactaddress1` varchar(255) default NULL,
253 `altcontactaddress2` varchar(255) default NULL,
254 `altcontactaddress3` varchar(255) default NULL,
255 `altcontactzipcode` varchar(50) default NULL,
256 `altcontactcountry` text default NULL,
257 `altcontactphone` varchar(50) default NULL,
258 `smsalertnumber` varchar(50) default NULL,
259 `privacy` integer(11) DEFAULT '1' NOT NULL,
260 UNIQUE KEY `cardnumber` (`cardnumber`),
261 PRIMARY KEY `borrowernumber` (`borrowernumber`),
262 KEY `categorycode` (`categorycode`),
263 KEY `branchcode` (`branchcode`),
264 KEY `userid` (`userid`),
265 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
266 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
267 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
270 -- Table structure for table `borrower_attribute_types`
273 DROP TABLE IF EXISTS `borrower_attribute_types`;
274 CREATE TABLE `borrower_attribute_types` (
275 `code` varchar(10) NOT NULL,
276 `description` varchar(255) NOT NULL,
277 `repeatable` tinyint(1) NOT NULL default 0,
278 `unique_id` tinyint(1) NOT NULL default 0,
279 `opac_display` tinyint(1) NOT NULL default 0,
280 `password_allowed` tinyint(1) NOT NULL default 0,
281 `staff_searchable` tinyint(1) NOT NULL default 0,
282 `authorised_value_category` varchar(10) default NULL,
283 PRIMARY KEY (`code`),
284 KEY `auth_val_cat_idx` (`authorised_value_category`)
285 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
288 -- Table structure for table `borrower_attributes`
291 DROP TABLE IF EXISTS `borrower_attributes`;
292 CREATE TABLE `borrower_attributes` (
293 `borrowernumber` int(11) NOT NULL,
294 `code` varchar(10) NOT NULL,
295 `attribute` varchar(64) default NULL,
296 `password` varchar(64) default NULL,
297 KEY `borrowernumber` (`borrowernumber`),
298 KEY `code_attribute` (`code`, `attribute`),
299 CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
300 ON DELETE CASCADE ON UPDATE CASCADE,
301 CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`)
302 ON DELETE CASCADE ON UPDATE CASCADE
303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
305 DROP TABLE IF EXISTS `branch_item_rules`;
306 CREATE TABLE `branch_item_rules` (
307 `branchcode` varchar(10) NOT NULL,
308 `itemtype` varchar(10) NOT NULL,
309 `holdallowed` tinyint(1) default NULL,
310 PRIMARY KEY (`itemtype`,`branchcode`),
311 KEY `branch_item_rules_ibfk_2` (`branchcode`),
312 CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
313 ON DELETE CASCADE ON UPDATE CASCADE,
314 CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
315 ON DELETE CASCADE ON UPDATE CASCADE
316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
319 -- Table structure for table `branchcategories`
322 DROP TABLE IF EXISTS `branchcategories`;
323 CREATE TABLE `branchcategories` (
324 `categorycode` varchar(10) NOT NULL default '',
325 `categoryname` varchar(32),
326 `codedescription` mediumtext,
327 `categorytype` varchar(16),
328 PRIMARY KEY (`categorycode`)
329 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
332 -- Table structure for table `branches`
335 DROP TABLE IF EXISTS `branches`;
336 CREATE TABLE `branches` (
337 `branchcode` varchar(10) NOT NULL default '',
338 `branchname` mediumtext NOT NULL,
339 `branchaddress1` mediumtext,
340 `branchaddress2` mediumtext,
341 `branchaddress3` mediumtext,
342 `branchzip` varchar(25) default NULL,
343 `branchcity` mediumtext,
344 `branchcountry` text,
345 `branchphone` mediumtext,
346 `branchfax` mediumtext,
347 `branchemail` mediumtext,
348 `branchurl` mediumtext,
349 `issuing` tinyint(4) default NULL,
350 `branchip` varchar(15) default NULL,
351 `branchprinter` varchar(100) default NULL,
352 `branchnotes` mediumtext,
353 UNIQUE KEY `branchcode` (`branchcode`)
354 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
357 -- Table structure for table `branchrelations`
360 DROP TABLE IF EXISTS `branchrelations`;
361 CREATE TABLE `branchrelations` (
362 `branchcode` varchar(10) NOT NULL default '',
363 `categorycode` varchar(10) NOT NULL default '',
364 PRIMARY KEY (`branchcode`,`categorycode`),
365 KEY `branchcode` (`branchcode`),
366 KEY `categorycode` (`categorycode`),
367 CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
368 CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
369 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
372 -- Table structure for table `branchtransfers`
375 DROP TABLE IF EXISTS `branchtransfers`;
376 CREATE TABLE `branchtransfers` (
377 `itemnumber` int(11) NOT NULL default 0,
378 `datesent` datetime default NULL,
379 `frombranch` varchar(10) NOT NULL default '',
380 `datearrived` datetime default NULL,
381 `tobranch` varchar(10) NOT NULL default '',
382 `comments` mediumtext,
383 KEY `frombranch` (`frombranch`),
384 KEY `tobranch` (`tobranch`),
385 KEY `itemnumber` (`itemnumber`),
386 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
387 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
388 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
389 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
393 -- Table structure for table `browser`
395 DROP TABLE IF EXISTS `browser`;
396 CREATE TABLE `browser` (
397 `level` int(11) NOT NULL,
398 `classification` varchar(20) NOT NULL,
399 `description` varchar(255) NOT NULL,
400 `number` bigint(20) NOT NULL,
401 `endnode` tinyint(4) NOT NULL
402 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
405 -- Table structure for table `categories`
408 DROP TABLE IF EXISTS `categories`;
409 CREATE TABLE `categories` (
410 `categorycode` varchar(10) NOT NULL default '',
411 `description` mediumtext,
412 `enrolmentperiod` smallint(6) default NULL,
413 `enrolmentperioddate` DATE NULL DEFAULT NULL,
414 `upperagelimit` smallint(6) default NULL,
415 `dateofbirthrequired` tinyint(1) default NULL,
416 `finetype` varchar(30) default NULL,
417 `bulk` tinyint(1) default NULL,
418 `enrolmentfee` decimal(28,6) default NULL,
419 `overduenoticerequired` tinyint(1) default NULL,
420 `issuelimit` smallint(6) default NULL,
421 `reservefee` decimal(28,6) default NULL,
422 `category_type` varchar(1) NOT NULL default 'A',
423 PRIMARY KEY (`categorycode`),
424 UNIQUE KEY `categorycode` (`categorycode`)
425 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
428 -- Table: collections
430 CREATE TABLE collections (
431 colId integer(11) NOT NULL auto_increment,
432 colTitle varchar(100) NOT NULL DEFAULT '',
433 colDesc text NOT NULL,
434 colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.',
436 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
439 -- Table: collections_tracking
441 CREATE TABLE collections_tracking (
442 ctId integer(11) NOT NULL auto_increment,
443 colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
444 itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
446 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
449 -- Table structure for table `borrower_branch_circ_rules`
452 DROP TABLE IF EXISTS `branch_borrower_circ_rules`;
453 CREATE TABLE `branch_borrower_circ_rules` (
454 `branchcode` VARCHAR(10) NOT NULL,
455 `categorycode` VARCHAR(10) NOT NULL,
456 `maxissueqty` int(4) default NULL,
457 PRIMARY KEY (`categorycode`, `branchcode`),
458 CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
459 ON DELETE CASCADE ON UPDATE CASCADE,
460 CONSTRAINT `branch_borrower_circ_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
461 ON DELETE CASCADE ON UPDATE CASCADE
462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
465 -- Table structure for table `default_borrower_circ_rules`
468 DROP TABLE IF EXISTS `default_borrower_circ_rules`;
469 CREATE TABLE `default_borrower_circ_rules` (
470 `categorycode` VARCHAR(10) NOT NULL,
471 `maxissueqty` int(4) default NULL,
472 PRIMARY KEY (`categorycode`),
473 CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
474 ON DELETE CASCADE ON UPDATE CASCADE
475 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
478 -- Table structure for table `default_branch_circ_rules`
481 DROP TABLE IF EXISTS `default_branch_circ_rules`;
482 CREATE TABLE `default_branch_circ_rules` (
483 `branchcode` VARCHAR(10) NOT NULL,
484 `maxissueqty` int(4) default NULL,
485 `holdallowed` tinyint(1) default NULL,
486 PRIMARY KEY (`branchcode`),
487 CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
488 ON DELETE CASCADE ON UPDATE CASCADE
489 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
492 -- Table structure for table `default_branch_item_rules`
494 DROP TABLE IF EXISTS `default_branch_item_rules`;
495 CREATE TABLE `default_branch_item_rules` (
496 `itemtype` varchar(10) NOT NULL,
497 `holdallowed` tinyint(1) default NULL,
498 PRIMARY KEY (`itemtype`),
499 CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
500 ON DELETE CASCADE ON UPDATE CASCADE
501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
504 -- Table structure for table `default_circ_rules`
507 DROP TABLE IF EXISTS `default_circ_rules`;
508 CREATE TABLE `default_circ_rules` (
509 `singleton` enum('singleton') NOT NULL default 'singleton',
510 `maxissueqty` int(4) default NULL,
511 `holdallowed` int(1) default NULL,
512 PRIMARY KEY (`singleton`)
513 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
516 -- Table structure for table `cities`
519 DROP TABLE IF EXISTS `cities`;
520 CREATE TABLE `cities` (
521 `cityid` int(11) NOT NULL auto_increment,
522 `city_name` varchar(100) NOT NULL default '',
523 `city_zipcode` varchar(20) default NULL,
524 PRIMARY KEY (`cityid`)
525 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
528 -- Table structure for table `class_sort_rules`
531 DROP TABLE IF EXISTS `class_sort_rules`;
532 CREATE TABLE `class_sort_rules` (
533 `class_sort_rule` varchar(10) NOT NULL default '',
534 `description` mediumtext,
535 `sort_routine` varchar(30) NOT NULL default '',
536 PRIMARY KEY (`class_sort_rule`),
537 UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
538 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
541 -- Table structure for table `class_sources`
544 DROP TABLE IF EXISTS `class_sources`;
545 CREATE TABLE `class_sources` (
546 `cn_source` varchar(10) NOT NULL default '',
547 `description` mediumtext,
548 `used` tinyint(4) NOT NULL default 0,
549 `class_sort_rule` varchar(10) NOT NULL default '',
550 PRIMARY KEY (`cn_source`),
551 UNIQUE KEY `cn_source_idx` (`cn_source`),
552 KEY `used_idx` (`used`),
553 CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
554 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
557 -- Table structure for table `currency`
560 DROP TABLE IF EXISTS `currency`;
561 CREATE TABLE `currency` (
562 `currency` varchar(10) NOT NULL default '',
563 `symbol` varchar(5) default NULL,
564 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
565 `rate` float(7,5) default NULL,
566 `active` tinyint(1) default NULL,
567 PRIMARY KEY (`currency`)
568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
571 -- Table structure for table `deletedbiblio`
574 DROP TABLE IF EXISTS `deletedbiblio`;
575 CREATE TABLE `deletedbiblio` (
576 `biblionumber` int(11) NOT NULL default 0,
577 `frameworkcode` varchar(4) NOT NULL default '',
580 `unititle` mediumtext,
582 `serial` tinyint(1) default NULL,
583 `seriestitle` mediumtext,
584 `copyrightdate` smallint(6) default NULL,
585 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
586 `datecreated` DATE NOT NULL,
587 `abstract` mediumtext,
588 PRIMARY KEY (`biblionumber`),
589 KEY `blbnoidx` (`biblionumber`)
590 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
593 -- Table structure for table `deletedbiblioitems`
596 DROP TABLE IF EXISTS `deletedbiblioitems`;
597 CREATE TABLE `deletedbiblioitems` (
598 `biblioitemnumber` int(11) NOT NULL default 0,
599 `biblionumber` int(11) NOT NULL default 0,
602 `itemtype` varchar(10) default NULL,
603 `isbn` varchar(30) default NULL,
604 `issn` varchar(9) default NULL,
605 `publicationyear` text,
606 `publishercode` varchar(255) default NULL,
607 `volumedate` date default NULL,
609 `collectiontitle` mediumtext default NULL,
610 `collectionissn` text default NULL,
611 `collectionvolume` mediumtext default NULL,
612 `editionstatement` text default NULL,
613 `editionresponsibility` text default NULL,
614 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
615 `illus` varchar(255) default NULL,
616 `pages` varchar(255) default NULL,
618 `size` varchar(255) default NULL,
619 `place` varchar(255) default NULL,
620 `lccn` varchar(25) default NULL,
622 `url` varchar(255) default NULL,
623 `cn_source` varchar(10) default NULL,
624 `cn_class` varchar(30) default NULL,
625 `cn_item` varchar(10) default NULL,
626 `cn_suffix` varchar(10) default NULL,
627 `cn_sort` varchar(30) default NULL,
628 `totalissues` int(10),
629 `marcxml` longtext NOT NULL,
630 PRIMARY KEY (`biblioitemnumber`),
631 KEY `bibinoidx` (`biblioitemnumber`),
632 KEY `bibnoidx` (`biblionumber`),
634 KEY `publishercode` (`publishercode`)
635 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
638 -- Table structure for table `deletedborrowers`
641 DROP TABLE IF EXISTS `deletedborrowers`;
642 CREATE TABLE `deletedborrowers` (
643 `borrowernumber` int(11) NOT NULL default 0,
644 `cardnumber` varchar(9) NOT NULL default '',
645 `surname` mediumtext NOT NULL,
648 `othernames` mediumtext,
650 `streetnumber` varchar(10) default NULL,
651 `streettype` varchar(50) default NULL,
652 `address` mediumtext NOT NULL,
654 `city` mediumtext NOT NULL,
655 `zipcode` varchar(25) default NULL,
659 `mobile` varchar(50) default NULL,
663 `B_streetnumber` varchar(10) default NULL,
664 `B_streettype` varchar(50) default NULL,
665 `B_address` varchar(100) default NULL,
666 `B_address2` text default NULL,
668 `B_zipcode` varchar(25) default NULL,
671 `B_phone` mediumtext,
672 `dateofbirth` date default NULL,
673 `branchcode` varchar(10) NOT NULL default '',
674 `categorycode` varchar(10) default NULL,
675 `dateenrolled` date default NULL,
676 `dateexpiry` date default NULL,
677 `gonenoaddress` tinyint(1) default NULL,
678 `lost` tinyint(1) default NULL,
679 `debarred` tinyint(1) default NULL,
680 `contactname` mediumtext,
681 `contactfirstname` text,
683 `guarantorid` int(11) default NULL,
684 `borrowernotes` mediumtext,
685 `relationship` varchar(100) default NULL,
686 `ethnicity` varchar(50) default NULL,
687 `ethnotes` varchar(255) default NULL,
688 `sex` varchar(1) default NULL,
689 `password` varchar(30) default NULL,
690 `flags` int(11) default NULL,
691 `userid` varchar(30) default NULL,
692 `opacnote` mediumtext,
693 `contactnote` varchar(255) default NULL,
694 `sort1` varchar(80) default NULL,
695 `sort2` varchar(80) default NULL,
696 `altcontactfirstname` varchar(255) default NULL,
697 `altcontactsurname` varchar(255) default NULL,
698 `altcontactaddress1` varchar(255) default NULL,
699 `altcontactaddress2` varchar(255) default NULL,
700 `altcontactaddress3` varchar(255) default NULL,
701 `altcontactzipcode` varchar(50) default NULL,
702 `altcontactcountry` text default NULL,
703 `altcontactphone` varchar(50) default NULL,
704 `smsalertnumber` varchar(50) default NULL,
705 KEY `borrowernumber` (`borrowernumber`),
706 KEY `cardnumber` (`cardnumber`)
707 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
710 -- Table structure for table `deleteditems`
713 DROP TABLE IF EXISTS `deleteditems`;
714 CREATE TABLE `deleteditems` (
715 `itemnumber` int(11) NOT NULL default 0,
716 `biblionumber` int(11) NOT NULL default 0,
717 `biblioitemnumber` int(11) NOT NULL default 0,
718 `barcode` varchar(20) default NULL,
719 `dateaccessioned` date default NULL,
720 `booksellerid` mediumtext default NULL,
721 `homebranch` varchar(10) default NULL,
722 `price` decimal(8,2) default NULL,
723 `replacementprice` decimal(8,2) default NULL,
724 `replacementpricedate` date default NULL,
725 `datelastborrowed` date default NULL,
726 `datelastseen` date default NULL,
727 `stack` tinyint(1) default NULL,
728 `notforloan` tinyint(1) NOT NULL default 0,
729 `damaged` tinyint(1) NOT NULL default 0,
730 `itemlost` tinyint(1) NOT NULL default 0,
731 `wthdrawn` tinyint(1) NOT NULL default 0,
732 `itemcallnumber` varchar(255) default NULL,
733 `issues` smallint(6) default NULL,
734 `renewals` smallint(6) default NULL,
735 `reserves` smallint(6) default NULL,
736 `restricted` tinyint(1) default NULL,
737 `itemnotes` mediumtext,
738 `holdingbranch` varchar(10) default NULL,
739 `paidfor` mediumtext,
740 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
741 `location` varchar(80) default NULL,
742 `permanent_location` varchar(80) default NULL,
743 `onloan` date default NULL,
744 `cn_source` varchar(10) default NULL,
745 `cn_sort` varchar(30) default NULL,
746 `ccode` varchar(10) default NULL,
747 `materials` varchar(10) default NULL,
748 `uri` varchar(255) default NULL,
749 `itype` varchar(10) default NULL,
750 `more_subfields_xml` longtext default NULL,
751 `enumchron` varchar(80) default NULL,
752 `copynumber` varchar(32) default NULL,
753 `stocknumber` varchar(32) default NULL,
755 PRIMARY KEY (`itemnumber`),
756 KEY `delitembarcodeidx` (`barcode`),
757 KEY `delitemstocknumberidx` (`stocknumber`),
758 KEY `delitembinoidx` (`biblioitemnumber`),
759 KEY `delitembibnoidx` (`biblionumber`),
760 KEY `delhomebranch` (`homebranch`),
761 KEY `delholdingbranch` (`holdingbranch`)
762 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
765 -- Table structure for table `ethnicity`
768 DROP TABLE IF EXISTS `ethnicity`;
769 CREATE TABLE `ethnicity` (
770 `code` varchar(10) NOT NULL default '',
771 `name` varchar(255) default NULL,
773 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
776 -- Table structure for table `export_format`
779 DROP TABLE IF EXISTS `export_format`;
780 CREATE TABLE `export_format` (
781 `export_format_id` int(11) NOT NULL auto_increment,
782 `profile` varchar(255) NOT NULL,
783 `description` mediumtext NOT NULL,
784 `marcfields` mediumtext NOT NULL,
785 `csv_separator` varchar(2) NOT NULL,
786 `field_separator` varchar(2) NOT NULL,
787 `subfield_separator` varchar(2) NOT NULL,
788 `encoding` varchar(255) NOT NULL,
789 PRIMARY KEY (`export_format_id`)
790 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export';
794 -- Table structure for table `hold_fill_targets`
797 DROP TABLE IF EXISTS `hold_fill_targets`;
798 CREATE TABLE hold_fill_targets (
799 `borrowernumber` int(11) NOT NULL,
800 `biblionumber` int(11) NOT NULL,
801 `itemnumber` int(11) NOT NULL,
802 `source_branchcode` varchar(10) default NULL,
803 `item_level_request` tinyint(4) NOT NULL default 0,
804 PRIMARY KEY `itemnumber` (`itemnumber`),
805 KEY `bib_branch` (`biblionumber`, `source_branchcode`),
806 CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`)
807 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
808 CONSTRAINT `hold_fill_targets_ibfk_2` FOREIGN KEY (`biblionumber`)
809 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
810 CONSTRAINT `hold_fill_targets_ibfk_3` FOREIGN KEY (`itemnumber`)
811 REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
812 CONSTRAINT `hold_fill_targets_ibfk_4` FOREIGN KEY (`source_branchcode`)
813 REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
814 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
817 -- Table structure for table `import_batches`
820 DROP TABLE IF EXISTS `import_batches`;
821 CREATE TABLE `import_batches` (
822 `import_batch_id` int(11) NOT NULL auto_increment,
823 `matcher_id` int(11) default NULL,
824 `template_id` int(11) default NULL,
825 `branchcode` varchar(10) default NULL,
826 `num_biblios` int(11) NOT NULL default 0,
827 `num_items` int(11) NOT NULL default 0,
828 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
829 `overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new',
830 `nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new',
831 `item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore') NOT NULL default 'always_add',
832 `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging',
833 `batch_type` enum('batch', 'z3950') NOT NULL default 'batch',
834 `file_name` varchar(100),
835 `comments` mediumtext,
836 PRIMARY KEY (`import_batch_id`),
837 KEY `branchcode` (`branchcode`)
838 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
841 -- Table structure for table `import_records`
844 DROP TABLE IF EXISTS `import_records`;
845 CREATE TABLE `import_records` (
846 `import_record_id` int(11) NOT NULL auto_increment,
847 `import_batch_id` int(11) NOT NULL,
848 `branchcode` varchar(10) default NULL,
849 `record_sequence` int(11) NOT NULL default 0,
850 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
851 `import_date` DATE default NULL,
852 `marc` longblob NOT NULL,
853 `marcxml` longtext NOT NULL,
854 `marcxml_old` longtext NOT NULL,
855 `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio',
856 `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match',
857 `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',
858 `import_error` mediumtext,
859 `encoding` varchar(40) NOT NULL default '',
860 `z3950random` varchar(40) default NULL,
861 PRIMARY KEY (`import_record_id`),
862 CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
863 REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
864 KEY `branchcode` (`branchcode`),
865 KEY `batch_sequence` (`import_batch_id`, `record_sequence`)
866 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
869 -- Table structure for `import_record_matches`
871 DROP TABLE IF EXISTS `import_record_matches`;
872 CREATE TABLE `import_record_matches` (
873 `import_record_id` int(11) NOT NULL,
874 `candidate_match_id` int(11) NOT NULL,
875 `score` int(11) NOT NULL default 0,
876 CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
877 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
878 KEY `record_score` (`import_record_id`, `score`)
879 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
882 -- Table structure for table `import_biblios`
885 DROP TABLE IF EXISTS `import_biblios`;
886 CREATE TABLE `import_biblios` (
887 `import_record_id` int(11) NOT NULL,
888 `matched_biblionumber` int(11) default NULL,
889 `control_number` varchar(25) default NULL,
890 `original_source` varchar(25) default NULL,
891 `title` varchar(128) default NULL,
892 `author` varchar(80) default NULL,
893 `isbn` varchar(30) default NULL,
894 `issn` varchar(9) default NULL,
895 `has_items` tinyint(1) NOT NULL default 0,
896 CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
897 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
898 KEY `matched_biblionumber` (`matched_biblionumber`),
899 KEY `title` (`title`),
901 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
904 -- Table structure for table `import_items`
907 DROP TABLE IF EXISTS `import_items`;
908 CREATE TABLE `import_items` (
909 `import_items_id` int(11) NOT NULL auto_increment,
910 `import_record_id` int(11) NOT NULL,
911 `itemnumber` int(11) default NULL,
912 `branchcode` varchar(10) default NULL,
913 `status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged',
914 `marcxml` longtext NOT NULL,
915 `import_error` mediumtext,
916 PRIMARY KEY (`import_items_id`),
917 CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`)
918 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
919 KEY `itemnumber` (`itemnumber`),
920 KEY `branchcode` (`branchcode`)
921 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
924 -- Table structure for table `issues`
927 DROP TABLE IF EXISTS `issues`;
928 CREATE TABLE `issues` (
929 `borrowernumber` int(11) default NULL,
930 `itemnumber` int(11) default NULL,
931 `date_due` date default NULL,
932 `branchcode` varchar(10) default NULL,
933 `issuingbranch` varchar(18) default NULL,
934 `returndate` date default NULL,
935 `lastreneweddate` date default NULL,
936 `return` varchar(4) default NULL,
937 `renewals` tinyint(4) default NULL,
938 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
939 `issuedate` date default NULL,
940 KEY `issuesborridx` (`borrowernumber`),
941 KEY `issuesitemidx` (`itemnumber`),
942 KEY `bordate` (`borrowernumber`,`timestamp`),
943 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
944 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
945 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
948 -- Table structure for table `issuingrules`
951 DROP TABLE IF EXISTS `issuingrules`;
952 CREATE TABLE `issuingrules` (
953 `categorycode` varchar(10) NOT NULL default '',
954 `itemtype` varchar(10) NOT NULL default '',
955 `restrictedtype` tinyint(1) default NULL,
956 `rentaldiscount` decimal(28,6) default NULL,
957 `reservecharge` decimal(28,6) default NULL,
958 `fine` decimal(28,6) default NULL,
959 `finedays` int(11) default NULL,
960 `firstremind` int(11) default NULL,
961 `chargeperiod` int(11) default NULL,
962 `accountsent` int(11) default NULL,
963 `chargename` varchar(100) default NULL,
964 `maxissueqty` int(4) default NULL,
965 `issuelength` int(4) default NULL,
966 `renewalsallowed` smallint(6) NOT NULL default "0",
967 `reservesallowed` smallint(6) NOT NULL default "0",
968 `branchcode` varchar(10) NOT NULL default '',
969 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
970 KEY `categorycode` (`categorycode`),
971 KEY `itemtype` (`itemtype`)
972 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
975 -- Table structure for table `items`
978 DROP TABLE IF EXISTS `items`;
979 CREATE TABLE `items` (
980 `itemnumber` int(11) NOT NULL auto_increment,
981 `biblionumber` int(11) NOT NULL default 0,
982 `biblioitemnumber` int(11) NOT NULL default 0,
983 `barcode` varchar(20) default NULL,
984 `dateaccessioned` date default NULL,
985 `booksellerid` mediumtext default NULL,
986 `homebranch` varchar(10) default NULL,
987 `price` decimal(8,2) default NULL,
988 `replacementprice` decimal(8,2) default NULL,
989 `replacementpricedate` date default NULL,
990 `datelastborrowed` date default NULL,
991 `datelastseen` date default NULL,
992 `stack` tinyint(1) default NULL,
993 `notforloan` tinyint(1) NOT NULL default 0,
994 `damaged` tinyint(1) NOT NULL default 0,
995 `itemlost` tinyint(1) NOT NULL default 0,
996 `wthdrawn` tinyint(1) NOT NULL default 0,
997 `itemcallnumber` varchar(255) default NULL,
998 `issues` smallint(6) default NULL,
999 `renewals` smallint(6) default NULL,
1000 `reserves` smallint(6) default NULL,
1001 `restricted` tinyint(1) default NULL,
1002 `itemnotes` mediumtext,
1003 `holdingbranch` varchar(10) default NULL,
1004 `paidfor` mediumtext,
1005 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1006 `location` varchar(80) default NULL,
1007 `permanent_location` varchar(80) default NULL,
1008 `onloan` date default NULL,
1009 `cn_source` varchar(10) default NULL,
1010 `cn_sort` varchar(30) default NULL,
1011 `ccode` varchar(10) default NULL,
1012 `materials` varchar(10) default NULL,
1013 `uri` varchar(255) default NULL,
1014 `itype` varchar(10) default NULL,
1015 `more_subfields_xml` longtext default NULL,
1016 `enumchron` varchar(80) default NULL,
1017 `copynumber` varchar(32) default NULL,
1018 `stocknumber` varchar(32) default NULL,
1019 PRIMARY KEY (`itemnumber`),
1020 UNIQUE KEY `itembarcodeidx` (`barcode`),
1021 UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
1022 KEY `itembinoidx` (`biblioitemnumber`),
1023 KEY `itembibnoidx` (`biblionumber`),
1024 KEY `homebranch` (`homebranch`),
1025 KEY `holdingbranch` (`holdingbranch`),
1026 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1027 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1028 CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1029 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1032 -- Table structure for table `itemtypes`
1035 DROP TABLE IF EXISTS `itemtypes`;
1036 CREATE TABLE `itemtypes` (
1037 `itemtype` varchar(10) NOT NULL default '',
1038 `description` mediumtext,
1039 `rentalcharge` double(16,4) default NULL,
1040 `notforloan` smallint(6) default NULL,
1041 `imageurl` varchar(200) default NULL,
1043 PRIMARY KEY (`itemtype`),
1044 UNIQUE KEY `itemtype` (`itemtype`)
1045 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1048 -- Table structure for table `creator_batches`
1051 DROP TABLE IF EXISTS `creator_batches`;
1052 SET @saved_cs_client = @@character_set_client;
1053 SET character_set_client = utf8;
1054 CREATE TABLE `creator_batches` (
1055 `label_id` int(11) NOT NULL AUTO_INCREMENT,
1056 `batch_id` int(10) NOT NULL DEFAULT '1',
1057 `item_number` int(11) DEFAULT NULL,
1058 `borrower_number` int(11) DEFAULT NULL,
1059 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1060 `branch_code` varchar(10) NOT NULL DEFAULT 'NB',
1061 `creator` char(15) NOT NULL DEFAULT 'Labels',
1062 PRIMARY KEY (`label_id`),
1063 KEY `branch_fk_constraint` (`branch_code`),
1064 KEY `item_fk_constraint` (`item_number`),
1065 KEY `borrower_fk_constraint` (`borrower_number`),
1066 CONSTRAINT `creator_batches_ibfk_1` FOREIGN KEY (`borrower_number`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1067 CONSTRAINT `creator_batches_ibfk_2` FOREIGN KEY (`branch_code`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE,
1068 CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE
1069 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1072 -- Table structure for table `creator_images`
1075 DROP TABLE IF EXISTS `creator_images`;
1076 SET @saved_cs_client = @@character_set_client;
1077 SET character_set_client = utf8;
1078 CREATE TABLE `creator_images` (
1079 `image_id` int(4) NOT NULL AUTO_INCREMENT,
1080 `imagefile` mediumblob,
1081 `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1082 PRIMARY KEY (`image_id`),
1083 UNIQUE KEY `image_name_index` (`image_name`)
1084 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1087 -- Table structure for table `creator_layouts`
1090 DROP TABLE IF EXISTS `creator_layouts`;
1091 SET @saved_cs_client = @@character_set_client;
1092 SET character_set_client = utf8;
1093 CREATE TABLE `creator_layouts` (
1094 `layout_id` int(4) NOT NULL AUTO_INCREMENT,
1095 `barcode_type` char(100) NOT NULL DEFAULT 'CODE39',
1096 `start_label` int(2) NOT NULL DEFAULT '1',
1097 `printing_type` char(32) NOT NULL DEFAULT 'BAR',
1098 `layout_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1099 `guidebox` int(1) DEFAULT '0',
1100 `font` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TR',
1101 `font_size` int(4) NOT NULL DEFAULT '10',
1102 `units` char(20) NOT NULL DEFAULT 'POINT',
1103 `callnum_split` int(1) DEFAULT '0',
1104 `text_justify` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'L',
1105 `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
1106 `layout_xml` text NOT NULL,
1107 `creator` char(15) NOT NULL DEFAULT 'Labels',
1108 PRIMARY KEY (`layout_id`)
1109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1112 -- Table structure for table `creator_templates`
1115 DROP TABLE IF EXISTS `creator_templates`;
1116 SET @saved_cs_client = @@character_set_client;
1117 SET character_set_client = utf8;
1118 CREATE TABLE `creator_templates` (
1119 `template_id` int(4) NOT NULL AUTO_INCREMENT,
1120 `profile_id` int(4) DEFAULT NULL,
1121 `template_code` char(100) NOT NULL DEFAULT 'DEFAULT TEMPLATE',
1122 `template_desc` char(100) NOT NULL DEFAULT 'Default description',
1123 `page_width` float NOT NULL DEFAULT '0',
1124 `page_height` float NOT NULL DEFAULT '0',
1125 `label_width` float NOT NULL DEFAULT '0',
1126 `label_height` float NOT NULL DEFAULT '0',
1127 `top_text_margin` float NOT NULL DEFAULT '0',
1128 `left_text_margin` float NOT NULL DEFAULT '0',
1129 `top_margin` float NOT NULL DEFAULT '0',
1130 `left_margin` float NOT NULL DEFAULT '0',
1131 `cols` int(2) NOT NULL DEFAULT '0',
1132 `rows` int(2) NOT NULL DEFAULT '0',
1133 `col_gap` float NOT NULL DEFAULT '0',
1134 `row_gap` float NOT NULL DEFAULT '0',
1135 `units` char(20) NOT NULL DEFAULT 'POINT',
1136 `creator` char(15) NOT NULL DEFAULT 'Labels',
1137 PRIMARY KEY (`template_id`),
1138 KEY `template_profile_fk_constraint` (`profile_id`)
1139 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1142 -- Table structure for table `letter`
1145 DROP TABLE IF EXISTS `letter`;
1146 CREATE TABLE `letter` (
1147 `module` varchar(20) NOT NULL default '',
1148 `code` varchar(20) NOT NULL default '',
1149 `name` varchar(100) NOT NULL default '',
1150 `title` varchar(200) NOT NULL default '',
1152 PRIMARY KEY (`module`,`code`)
1153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1156 -- Table structure for table `marc_subfield_structure`
1159 DROP TABLE IF EXISTS `marc_subfield_structure`;
1160 CREATE TABLE `marc_subfield_structure` (
1161 `tagfield` varchar(3) NOT NULL default '',
1162 `tagsubfield` varchar(1) NOT NULL default '' COLLATE utf8_bin,
1163 `liblibrarian` varchar(255) NOT NULL default '',
1164 `libopac` varchar(255) NOT NULL default '',
1165 `repeatable` tinyint(4) NOT NULL default 0,
1166 `mandatory` tinyint(4) NOT NULL default 0,
1167 `kohafield` varchar(40) default NULL,
1168 `tab` tinyint(1) default NULL,
1169 `authorised_value` varchar(20) default NULL,
1170 `authtypecode` varchar(20) default NULL,
1171 `value_builder` varchar(80) default NULL,
1172 `isurl` tinyint(1) default NULL,
1173 `hidden` tinyint(1) default NULL,
1174 `frameworkcode` varchar(4) NOT NULL default '',
1175 `seealso` varchar(1100) default NULL,
1176 `link` varchar(80) default NULL,
1177 `defaultvalue` text default NULL,
1178 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1179 KEY `kohafield_2` (`kohafield`),
1180 KEY `tab` (`frameworkcode`,`tab`),
1181 KEY `kohafield` (`frameworkcode`,`kohafield`)
1182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1185 -- Table structure for table `marc_tag_structure`
1188 DROP TABLE IF EXISTS `marc_tag_structure`;
1189 CREATE TABLE `marc_tag_structure` (
1190 `tagfield` varchar(3) NOT NULL default '',
1191 `liblibrarian` varchar(255) NOT NULL default '',
1192 `libopac` varchar(255) NOT NULL default '',
1193 `repeatable` tinyint(4) NOT NULL default 0,
1194 `mandatory` tinyint(4) NOT NULL default 0,
1195 `authorised_value` varchar(10) default NULL,
1196 `frameworkcode` varchar(4) NOT NULL default '',
1197 PRIMARY KEY (`frameworkcode`,`tagfield`)
1198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1201 -- Table structure for table `marc_matchers`
1204 DROP TABLE IF EXISTS `marc_matchers`;
1205 CREATE TABLE `marc_matchers` (
1206 `matcher_id` int(11) NOT NULL auto_increment,
1207 `code` varchar(10) NOT NULL default '',
1208 `description` varchar(255) NOT NULL default '',
1209 `record_type` varchar(10) NOT NULL default 'biblio',
1210 `threshold` int(11) NOT NULL default 0,
1211 PRIMARY KEY (`matcher_id`),
1212 KEY `code` (`code`),
1213 KEY `record_type` (`record_type`)
1214 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1217 -- Table structure for table `matchpoints`
1219 DROP TABLE IF EXISTS `matchpoints`;
1220 CREATE TABLE `matchpoints` (
1221 `matcher_id` int(11) NOT NULL,
1222 `matchpoint_id` int(11) NOT NULL auto_increment,
1223 `search_index` varchar(30) NOT NULL default '',
1224 `score` int(11) NOT NULL default 0,
1225 PRIMARY KEY (`matchpoint_id`),
1226 CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1227 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
1228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1232 -- Table structure for table `matchpoint_components`
1234 DROP TABLE IF EXISTS `matchpoint_components`;
1235 CREATE TABLE `matchpoint_components` (
1236 `matchpoint_id` int(11) NOT NULL,
1237 `matchpoint_component_id` int(11) NOT NULL auto_increment,
1238 sequence int(11) NOT NULL default 0,
1239 tag varchar(3) NOT NULL default '',
1240 subfields varchar(40) NOT NULL default '',
1241 offset int(4) NOT NULL default 0,
1242 length int(4) NOT NULL default 0,
1243 PRIMARY KEY (`matchpoint_component_id`),
1244 KEY `by_sequence` (`matchpoint_id`, `sequence`),
1245 CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
1246 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1247 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1250 -- Table structure for table `matcher_component_norms`
1252 DROP TABLE IF EXISTS `matchpoint_component_norms`;
1253 CREATE TABLE `matchpoint_component_norms` (
1254 `matchpoint_component_id` int(11) NOT NULL,
1255 `sequence` int(11) NOT NULL default 0,
1256 `norm_routine` varchar(50) NOT NULL default '',
1257 KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
1258 CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
1259 REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
1260 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1263 -- Table structure for table `matcher_matchpoints`
1265 DROP TABLE IF EXISTS `matcher_matchpoints`;
1266 CREATE TABLE `matcher_matchpoints` (
1267 `matcher_id` int(11) NOT NULL,
1268 `matchpoint_id` int(11) NOT NULL,
1269 CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1270 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1271 CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
1272 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1276 -- Table structure for table `matchchecks`
1278 DROP TABLE IF EXISTS `matchchecks`;
1279 CREATE TABLE `matchchecks` (
1280 `matcher_id` int(11) NOT NULL,
1281 `matchcheck_id` int(11) NOT NULL auto_increment,
1282 `source_matchpoint_id` int(11) NOT NULL,
1283 `target_matchpoint_id` int(11) NOT NULL,
1284 PRIMARY KEY (`matchcheck_id`),
1285 CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`)
1286 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1287 CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`)
1288 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1289 CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
1290 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1291 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1294 -- Table structure for table `notifys`
1297 DROP TABLE IF EXISTS `notifys`;
1298 CREATE TABLE `notifys` (
1299 `notify_id` int(11) NOT NULL default 0,
1300 `borrowernumber` int(11) NOT NULL default 0,
1301 `itemnumber` int(11) NOT NULL default 0,
1302 `notify_date` date default NULL,
1303 `notify_send_date` date default NULL,
1304 `notify_level` int(1) NOT NULL default 0,
1305 `method` varchar(20) NOT NULL default ''
1306 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1309 -- Table structure for table `nozebra`
1312 DROP TABLE IF EXISTS `nozebra`;
1313 CREATE TABLE `nozebra` (
1314 `server` varchar(20) NOT NULL,
1315 `indexname` varchar(40) NOT NULL,
1316 `value` varchar(250) NOT NULL,
1317 `biblionumbers` longtext NOT NULL,
1318 KEY `indexname` (`server`,`indexname`),
1319 KEY `value` (`server`,`value`))
1320 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1323 -- Table structure for table `old_issues`
1326 DROP TABLE IF EXISTS `old_issues`;
1327 CREATE TABLE `old_issues` (
1328 `borrowernumber` int(11) default NULL,
1329 `itemnumber` int(11) default NULL,
1330 `date_due` date default NULL,
1331 `branchcode` varchar(10) default NULL,
1332 `issuingbranch` varchar(18) default NULL,
1333 `returndate` date default NULL,
1334 `lastreneweddate` date default NULL,
1335 `return` varchar(4) default NULL,
1336 `renewals` tinyint(4) default NULL,
1337 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1338 `issuedate` date default NULL,
1339 KEY `old_issuesborridx` (`borrowernumber`),
1340 KEY `old_issuesitemidx` (`itemnumber`),
1341 KEY `old_bordate` (`borrowernumber`,`timestamp`),
1342 CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1343 ON DELETE SET NULL ON UPDATE SET NULL,
1344 CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1345 ON DELETE SET NULL ON UPDATE SET NULL
1346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1349 -- Table structure for table `old_reserves`
1351 DROP TABLE IF EXISTS `old_reserves`;
1352 CREATE TABLE `old_reserves` (
1353 `borrowernumber` int(11) default NULL,
1354 `reservedate` date default NULL,
1355 `biblionumber` int(11) default NULL,
1356 `constrainttype` varchar(1) default NULL,
1357 `branchcode` varchar(10) default NULL,
1358 `notificationdate` date default NULL,
1359 `reminderdate` date default NULL,
1360 `cancellationdate` date default NULL,
1361 `reservenotes` mediumtext,
1362 `priority` smallint(6) default NULL,
1363 `found` varchar(1) default NULL,
1364 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1365 `itemnumber` int(11) default NULL,
1366 `waitingdate` date default NULL,
1367 `expirationdate` DATE DEFAULT NULL,
1368 `lowestPriority` tinyint(1) NOT NULL,
1369 KEY `old_reserves_borrowernumber` (`borrowernumber`),
1370 KEY `old_reserves_biblionumber` (`biblionumber`),
1371 KEY `old_reserves_itemnumber` (`itemnumber`),
1372 KEY `old_reserves_branchcode` (`branchcode`),
1373 CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1374 ON DELETE SET NULL ON UPDATE SET NULL,
1375 CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`)
1376 ON DELETE SET NULL ON UPDATE SET NULL,
1377 CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1378 ON DELETE SET NULL ON UPDATE SET NULL
1379 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1382 -- Table structure for table `opac_news`
1385 DROP TABLE IF EXISTS `opac_news`;
1386 CREATE TABLE `opac_news` (
1387 `idnew` int(10) unsigned NOT NULL auto_increment,
1388 `title` varchar(250) NOT NULL default '',
1389 `new` text NOT NULL,
1390 `lang` varchar(25) NOT NULL default '',
1391 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1392 `expirationdate` date default NULL,
1393 `number` int(11) default NULL,
1394 PRIMARY KEY (`idnew`)
1395 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1398 -- Table structure for table `overduerules`
1401 DROP TABLE IF EXISTS `overduerules`;
1402 CREATE TABLE `overduerules` (
1403 `branchcode` varchar(10) NOT NULL default '',
1404 `categorycode` varchar(10) NOT NULL default '',
1405 `delay1` int(4) default 0,
1406 `letter1` varchar(20) default NULL,
1407 `debarred1` varchar(1) default 0,
1408 `delay2` int(4) default 0,
1409 `debarred2` varchar(1) default 0,
1410 `letter2` varchar(20) default NULL,
1411 `delay3` int(4) default 0,
1412 `letter3` varchar(20) default NULL,
1413 `debarred3` int(1) default 0,
1414 PRIMARY KEY (`branchcode`,`categorycode`)
1415 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1418 -- Table structure for table `patroncards`
1421 DROP TABLE IF EXISTS `patroncards`;
1422 CREATE TABLE `patroncards` (
1423 `cardid` int(11) NOT NULL auto_increment,
1424 `batch_id` varchar(10) NOT NULL default '1',
1425 `borrowernumber` int(11) NOT NULL,
1426 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1427 PRIMARY KEY (`cardid`),
1428 KEY `patroncards_ibfk_1` (`borrowernumber`),
1429 CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1430 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1433 -- Table structure for table `patronimage`
1436 DROP TABLE IF EXISTS `patronimage`;
1437 CREATE TABLE `patronimage` (
1438 `cardnumber` varchar(16) NOT NULL,
1439 `mimetype` varchar(15) NOT NULL,
1440 `imagefile` mediumblob NOT NULL,
1441 PRIMARY KEY (`cardnumber`),
1442 CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1443 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1446 -- Table structure for table `printers`
1449 DROP TABLE IF EXISTS `printers`;
1450 CREATE TABLE `printers` (
1451 `printername` varchar(40) NOT NULL default '',
1452 `printqueue` varchar(20) default NULL,
1453 `printtype` varchar(20) default NULL,
1454 PRIMARY KEY (`printername`)
1455 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1458 -- Table structure for table `printers_profile`
1461 DROP TABLE IF EXISTS `printers_profile`;
1462 CREATE TABLE `printers_profile` (
1463 `profile_id` int(4) NOT NULL auto_increment,
1464 `printer_name` varchar(40) NOT NULL default 'Default Printer',
1465 `template_id` int(4) NOT NULL default '0',
1466 `paper_bin` varchar(20) NOT NULL default 'Bypass',
1467 `offset_horz` float NOT NULL default '0',
1468 `offset_vert` float NOT NULL default '0',
1469 `creep_horz` float NOT NULL default '0',
1470 `creep_vert` float NOT NULL default '0',
1471 `units` char(20) NOT NULL default 'POINT',
1472 `creator` char(15) NOT NULL DEFAULT 'Labels',
1473 PRIMARY KEY (`profile_id`),
1474 UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
1475 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1478 -- Table structure for table `repeatable_holidays`
1481 DROP TABLE IF EXISTS `repeatable_holidays`;
1482 CREATE TABLE `repeatable_holidays` (
1483 `id` int(11) NOT NULL auto_increment,
1484 `branchcode` varchar(10) NOT NULL default '',
1485 `weekday` smallint(6) default NULL,
1486 `day` smallint(6) default NULL,
1487 `month` smallint(6) default NULL,
1488 `title` varchar(50) NOT NULL default '',
1489 `description` text NOT NULL,
1491 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1494 -- Table structure for table `reports_dictionary`
1497 DROP TABLE IF EXISTS `reports_dictionary`;
1498 CREATE TABLE reports_dictionary (
1499 `id` int(11) NOT NULL auto_increment,
1500 `name` varchar(255) default NULL,
1502 `date_created` datetime default NULL,
1503 `date_modified` datetime default NULL,
1505 `area` int(11) default NULL,
1507 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1510 -- Table structure for table `reserveconstraints`
1513 DROP TABLE IF EXISTS `reserveconstraints`;
1514 CREATE TABLE `reserveconstraints` (
1515 `borrowernumber` int(11) NOT NULL default 0,
1516 `reservedate` date default NULL,
1517 `biblionumber` int(11) NOT NULL default 0,
1518 `biblioitemnumber` int(11) default NULL,
1519 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1520 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1523 -- Table structure for table `reserves`
1526 DROP TABLE IF EXISTS `reserves`;
1527 CREATE TABLE `reserves` (
1528 `borrowernumber` int(11) NOT NULL default 0,
1529 `reservedate` date default NULL,
1530 `biblionumber` int(11) NOT NULL default 0,
1531 `constrainttype` varchar(1) default NULL,
1532 `branchcode` varchar(10) default NULL,
1533 `notificationdate` date default NULL,
1534 `reminderdate` date default NULL,
1535 `cancellationdate` date default NULL,
1536 `reservenotes` mediumtext,
1537 `priority` smallint(6) default NULL,
1538 `found` varchar(1) default NULL,
1539 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1540 `itemnumber` int(11) default NULL,
1541 `waitingdate` date default NULL,
1542 `expirationdate` DATE DEFAULT NULL,
1543 `lowestPriority` tinyint(1) NOT NULL,
1544 KEY `borrowernumber` (`borrowernumber`),
1545 KEY `biblionumber` (`biblionumber`),
1546 KEY `itemnumber` (`itemnumber`),
1547 KEY `branchcode` (`branchcode`),
1548 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1549 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1550 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1551 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1555 -- Table structure for table `reviews`
1558 DROP TABLE IF EXISTS `reviews`;
1559 CREATE TABLE `reviews` (
1560 `reviewid` int(11) NOT NULL auto_increment,
1561 `borrowernumber` int(11) default NULL,
1562 `biblionumber` int(11) default NULL,
1564 `approved` tinyint(4) default NULL,
1565 `datereviewed` datetime default NULL,
1566 PRIMARY KEY (`reviewid`)
1567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1570 -- Table structure for table `roadtype`
1573 DROP TABLE IF EXISTS `roadtype`;
1574 CREATE TABLE `roadtype` (
1575 `roadtypeid` int(11) NOT NULL auto_increment,
1576 `road_type` varchar(100) NOT NULL default '',
1577 PRIMARY KEY (`roadtypeid`)
1578 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1581 -- Table structure for table `saved_sql`
1584 DROP TABLE IF EXISTS `saved_sql`;
1585 CREATE TABLE saved_sql (
1586 `id` int(11) NOT NULL auto_increment,
1587 `borrowernumber` int(11) default NULL,
1588 `date_created` datetime default NULL,
1589 `last_modified` datetime default NULL,
1591 `last_run` datetime default NULL,
1592 `report_name` varchar(255) default NULL,
1593 `type` varchar(255) default NULL,
1596 KEY boridx (`borrowernumber`)
1597 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1601 -- Table structure for `saved_reports`
1604 DROP TABLE IF EXISTS `saved_reports`;
1605 CREATE TABLE saved_reports (
1606 `id` int(11) NOT NULL auto_increment,
1607 `report_id` int(11) default NULL,
1609 `date_run` datetime default NULL,
1611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1615 -- Table structure for table `search_history`
1618 DROP TABLE IF EXISTS `search_history`;
1619 CREATE TABLE IF NOT EXISTS `search_history` (
1620 `userid` int(11) NOT NULL,
1621 `sessionid` varchar(32) NOT NULL,
1622 `query_desc` varchar(255) NOT NULL,
1623 `query_cgi` varchar(255) NOT NULL,
1624 `total` int(11) NOT NULL,
1625 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1626 KEY `userid` (`userid`),
1627 KEY `sessionid` (`sessionid`)
1628 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results';
1632 -- Table structure for table `serial`
1635 DROP TABLE IF EXISTS `serial`;
1636 CREATE TABLE `serial` (
1637 `serialid` int(11) NOT NULL auto_increment,
1638 `biblionumber` varchar(100) NOT NULL default '',
1639 `subscriptionid` varchar(100) NOT NULL default '',
1640 `serialseq` varchar(100) NOT NULL default '',
1641 `status` tinyint(4) NOT NULL default 0,
1642 `planneddate` date default NULL,
1644 `publisheddate` date default NULL,
1645 `itemnumber` text default NULL,
1646 `claimdate` date default NULL,
1647 `routingnotes` text,
1648 PRIMARY KEY (`serialid`)
1649 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1652 -- Table structure for table `sessions`
1655 DROP TABLE IF EXISTS sessions;
1656 CREATE TABLE sessions (
1657 `id` varchar(32) NOT NULL,
1658 `a_session` text NOT NULL,
1660 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1663 -- Table structure for table `special_holidays`
1666 DROP TABLE IF EXISTS `special_holidays`;
1667 CREATE TABLE `special_holidays` (
1668 `id` int(11) NOT NULL auto_increment,
1669 `branchcode` varchar(10) NOT NULL default '',
1670 `day` smallint(6) NOT NULL default 0,
1671 `month` smallint(6) NOT NULL default 0,
1672 `year` smallint(6) NOT NULL default 0,
1673 `isexception` smallint(1) NOT NULL default 1,
1674 `title` varchar(50) NOT NULL default '',
1675 `description` text NOT NULL,
1677 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1680 -- Table structure for table `statistics`
1683 DROP TABLE IF EXISTS `statistics`;
1684 CREATE TABLE `statistics` (
1685 `datetime` datetime default NULL,
1686 `branch` varchar(10) default NULL,
1687 `proccode` varchar(4) default NULL,
1688 `value` double(16,4) default NULL,
1689 `type` varchar(16) default NULL,
1691 `usercode` varchar(10) default NULL,
1692 `itemnumber` int(11) default NULL,
1693 `itemtype` varchar(10) default NULL,
1694 `borrowernumber` int(11) default NULL,
1695 `associatedborrower` int(11) default NULL,
1696 KEY `timeidx` (`datetime`)
1697 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1700 -- Table structure for table `stopwords`
1703 DROP TABLE IF EXISTS `stopwords`;
1704 CREATE TABLE `stopwords` (
1705 `word` varchar(255) default NULL
1706 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1709 -- Table structure for table `subscription`
1712 DROP TABLE IF EXISTS `subscription`;
1713 CREATE TABLE `subscription` (
1714 `biblionumber` int(11) NOT NULL default 0,
1715 `subscriptionid` int(11) NOT NULL auto_increment,
1716 `librarian` varchar(100) default '',
1717 `startdate` date default NULL,
1718 `aqbooksellerid` int(11) default 0,
1719 `cost` int(11) default 0,
1720 `aqbudgetid` int(11) default 0,
1721 `weeklength` int(11) default 0,
1722 `monthlength` int(11) default 0,
1723 `numberlength` int(11) default 0,
1724 `periodicity` tinyint(4) default 0,
1725 `dow` varchar(100) default '',
1726 `numberingmethod` varchar(100) default '',
1728 `status` varchar(100) NOT NULL default '',
1729 `add1` int(11) default 0,
1730 `every1` int(11) default 0,
1731 `whenmorethan1` int(11) default 0,
1732 `setto1` int(11) default NULL,
1733 `lastvalue1` int(11) default NULL,
1734 `add2` int(11) default 0,
1735 `every2` int(11) default 0,
1736 `whenmorethan2` int(11) default 0,
1737 `setto2` int(11) default NULL,
1738 `lastvalue2` int(11) default NULL,
1739 `add3` int(11) default 0,
1740 `every3` int(11) default 0,
1741 `innerloop1` int(11) default 0,
1742 `innerloop2` int(11) default 0,
1743 `innerloop3` int(11) default 0,
1744 `whenmorethan3` int(11) default 0,
1745 `setto3` int(11) default NULL,
1746 `lastvalue3` int(11) default NULL,
1747 `issuesatonce` tinyint(3) NOT NULL default 1,
1748 `firstacquidate` date default NULL,
1749 `manualhistory` tinyint(1) NOT NULL default 0,
1750 `irregularity` text,
1751 `letter` varchar(20) default NULL,
1752 `numberpattern` tinyint(3) default 0,
1753 `distributedto` text,
1754 `internalnotes` longtext,
1756 `location` varchar(80) NULL default '',
1757 `branchcode` varchar(10) NOT NULL default '',
1758 `hemisphere` tinyint(3) default 0,
1759 `lastbranch` varchar(10),
1760 `serialsadditems` tinyint(1) NOT NULL default '0',
1761 `staffdisplaycount` VARCHAR(10) NULL,
1762 `opacdisplaycount` VARCHAR(10) NULL,
1763 `graceperiod` int(11) NOT NULL default '0',
1764 `enddate` date default NULL,
1765 PRIMARY KEY (`subscriptionid`)
1766 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1769 -- Table structure for table `subscriptionhistory`
1772 DROP TABLE IF EXISTS `subscriptionhistory`;
1773 CREATE TABLE `subscriptionhistory` (
1774 `biblionumber` int(11) NOT NULL default 0,
1775 `subscriptionid` int(11) NOT NULL default 0,
1776 `histstartdate` date default NULL,
1777 `histenddate` date default NULL,
1778 `missinglist` longtext NOT NULL,
1779 `recievedlist` longtext NOT NULL,
1780 `opacnote` varchar(150) NOT NULL default '',
1781 `librariannote` varchar(150) NOT NULL default '',
1782 PRIMARY KEY (`subscriptionid`),
1783 KEY `biblionumber` (`biblionumber`)
1784 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1787 -- Table structure for table `subscriptionroutinglist`
1790 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1791 CREATE TABLE `subscriptionroutinglist` (
1792 `routingid` int(11) NOT NULL auto_increment,
1793 `borrowernumber` int(11) default NULL,
1794 `ranking` int(11) default NULL,
1795 `subscriptionid` int(11) default NULL,
1796 PRIMARY KEY (`routingid`)
1797 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1800 -- Table structure for table `suggestions`
1803 DROP TABLE IF EXISTS `suggestions`;
1804 CREATE TABLE `suggestions` (
1805 `suggestionid` int(8) NOT NULL auto_increment,
1806 `suggestedby` int(11) NOT NULL default 0,
1807 `suggesteddate` date NOT NULL default 0,
1808 `managedby` int(11) default NULL,
1809 `manageddate` date default NULL,
1810 acceptedby INT(11) default NULL,
1811 accepteddate date default NULL,
1812 rejectedby INT(11) default NULL,
1813 rejecteddate date default NULL,
1814 `STATUS` varchar(10) NOT NULL default '',
1816 `author` varchar(80) default NULL,
1817 `title` varchar(80) default NULL,
1818 `copyrightdate` smallint(6) default NULL,
1819 `publishercode` varchar(255) default NULL,
1820 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1821 `volumedesc` varchar(255) default NULL,
1822 `publicationyear` smallint(6) default 0,
1823 `place` varchar(255) default NULL,
1824 `isbn` varchar(30) default NULL,
1825 `mailoverseeing` smallint(1) default 0,
1826 `biblionumber` int(11) default NULL,
1829 branchcode VARCHAR(10) default NULL,
1830 collectiontitle text default NULL,
1831 itemtype VARCHAR(30) default NULL,
1832 PRIMARY KEY (`suggestionid`),
1833 KEY `suggestedby` (`suggestedby`),
1834 KEY `managedby` (`managedby`)
1835 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1838 -- Table structure for table `systempreferences`
1841 DROP TABLE IF EXISTS `systempreferences`;
1842 CREATE TABLE `systempreferences` (
1843 `variable` varchar(50) NOT NULL default '',
1845 `options` mediumtext,
1847 `type` varchar(20) default NULL,
1848 PRIMARY KEY (`variable`)
1849 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1852 -- Table structure for table `tags`
1855 DROP TABLE IF EXISTS `tags`;
1856 CREATE TABLE `tags` (
1857 `entry` varchar(255) NOT NULL default '',
1858 `weight` bigint(20) NOT NULL default 0,
1859 PRIMARY KEY (`entry`)
1860 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1863 -- Table structure for table `tags_all`
1866 DROP TABLE IF EXISTS `tags_all`;
1867 CREATE TABLE `tags_all` (
1868 `tag_id` int(11) NOT NULL auto_increment,
1869 `borrowernumber` int(11) NOT NULL,
1870 `biblionumber` int(11) NOT NULL,
1871 `term` varchar(255) NOT NULL,
1872 `language` int(4) default NULL,
1873 `date_created` datetime NOT NULL,
1874 PRIMARY KEY (`tag_id`),
1875 KEY `tags_borrowers_fk_1` (`borrowernumber`),
1876 KEY `tags_biblionumber_fk_1` (`biblionumber`),
1877 CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`)
1878 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1879 CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1880 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1881 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1884 -- Table structure for table `tags_approval`
1887 DROP TABLE IF EXISTS `tags_approval`;
1888 CREATE TABLE `tags_approval` (
1889 `term` varchar(255) NOT NULL,
1890 `approved` int(1) NOT NULL default '0',
1891 `date_approved` datetime default NULL,
1892 `approved_by` int(11) default NULL,
1893 `weight_total` int(9) NOT NULL default '1',
1894 PRIMARY KEY (`term`),
1895 KEY `tags_approval_borrowers_fk_1` (`approved_by`),
1896 CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`)
1897 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1898 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1901 -- Table structure for table `tags_index`
1904 DROP TABLE IF EXISTS `tags_index`;
1905 CREATE TABLE `tags_index` (
1906 `term` varchar(255) NOT NULL,
1907 `biblionumber` int(11) NOT NULL,
1908 `weight` int(9) NOT NULL default '1',
1909 PRIMARY KEY (`term`,`biblionumber`),
1910 KEY `tags_index_biblionumber_fk_1` (`biblionumber`),
1911 CONSTRAINT `tags_index_term_fk_1` FOREIGN KEY (`term`)
1912 REFERENCES `tags_approval` (`term`) ON DELETE CASCADE ON UPDATE CASCADE,
1913 CONSTRAINT `tags_index_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1914 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1915 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1918 -- Table structure for table `userflags`
1921 DROP TABLE IF EXISTS `userflags`;
1922 CREATE TABLE `userflags` (
1923 `bit` int(11) NOT NULL default 0,
1924 `flag` varchar(30) default NULL,
1925 `flagdesc` varchar(255) default NULL,
1926 `defaulton` int(11) default NULL,
1928 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1931 -- Table structure for table `virtualshelves`
1934 DROP TABLE IF EXISTS `virtualshelves`;
1935 CREATE TABLE `virtualshelves` (
1936 `shelfnumber` int(11) NOT NULL auto_increment,
1937 `shelfname` varchar(255) default NULL,
1938 `owner` varchar(80) default NULL,
1939 `category` varchar(1) default NULL,
1940 `sortfield` varchar(16) default NULL,
1941 `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1942 PRIMARY KEY (`shelfnumber`)
1943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1946 -- Table structure for table `virtualshelfcontents`
1949 DROP TABLE IF EXISTS `virtualshelfcontents`;
1950 CREATE TABLE `virtualshelfcontents` (
1951 `shelfnumber` int(11) NOT NULL default 0,
1952 `biblionumber` int(11) NOT NULL default 0,
1953 `flags` int(11) default NULL,
1954 `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1955 KEY `shelfnumber` (`shelfnumber`),
1956 KEY `biblionumber` (`biblionumber`),
1957 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1958 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1959 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1962 -- Table structure for table `z3950servers`
1965 DROP TABLE IF EXISTS `z3950servers`;
1966 CREATE TABLE `z3950servers` (
1967 `host` varchar(255) default NULL,
1968 `port` int(11) default NULL,
1969 `db` varchar(255) default NULL,
1970 `userid` varchar(255) default NULL,
1971 `password` varchar(255) default NULL,
1973 `id` int(11) NOT NULL auto_increment,
1974 `checked` smallint(6) default NULL,
1975 `rank` int(11) default NULL,
1976 `syntax` varchar(80) default NULL,
1978 `position` enum('primary','secondary','') NOT NULL default 'primary',
1979 `type` enum('zed','opensearch') NOT NULL default 'zed',
1980 `encoding` text default NULL,
1981 `description` text NOT NULL,
1983 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1986 -- Table structure for table `zebraqueue`
1989 DROP TABLE IF EXISTS `zebraqueue`;
1990 CREATE TABLE `zebraqueue` (
1991 `id` int(11) NOT NULL auto_increment,
1992 `biblio_auth_number` bigint(20) unsigned NOT NULL default '0',
1993 `operation` char(20) NOT NULL default '',
1994 `server` char(20) NOT NULL default '',
1995 `done` int(11) NOT NULL default '0',
1996 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1998 KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
1999 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2001 DROP TABLE IF EXISTS `services_throttle`;
2002 CREATE TABLE `services_throttle` (
2003 `service_type` varchar(10) NOT NULL default '',
2004 `service_count` varchar(45) default NULL,
2005 PRIMARY KEY (`service_type`)
2006 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2008 -- http://www.w3.org/International/articles/language-tags/
2011 DROP TABLE IF EXISTS language_subtag_registry;
2012 CREATE TABLE language_subtag_registry (
2014 type varchar(25), -- language-script-region-variant-extension-privateuse
2015 description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
2017 id int(11) NOT NULL auto_increment,
2019 KEY `subtag` (`subtag`)
2020 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2022 -- TODO: add suppress_scripts
2023 -- this maps three letter codes defined in iso639.2 back to their
2024 -- two letter equivilents in rfc4646 (LOC maintains iso639+)
2025 DROP TABLE IF EXISTS language_rfc4646_to_iso639;
2026 CREATE TABLE language_rfc4646_to_iso639 (
2027 rfc4646_subtag varchar(25),
2028 iso639_2_code varchar(25),
2029 id int(11) NOT NULL auto_increment,
2031 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2032 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2034 DROP TABLE IF EXISTS language_descriptions;
2035 CREATE TABLE language_descriptions (
2039 description varchar(255),
2040 id int(11) NOT NULL auto_increment,
2042 KEY `lang` (`lang`),
2043 KEY `subtag_type_lang` (`subtag`, `type`, `lang`)
2044 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2046 -- bi-directional support, keyed by script subcode
2047 DROP TABLE IF EXISTS language_script_bidi;
2048 CREATE TABLE language_script_bidi (
2049 rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
2050 bidi varchar(3), -- rtl ltr
2051 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2052 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2054 -- TODO: need to map language subtags to script subtags for detection
2055 -- of bidi when script is not specified (like ar, he)
2056 DROP TABLE IF EXISTS language_script_mapping;
2057 CREATE TABLE language_script_mapping (
2058 language_subtag varchar(25),
2059 script_subtag varchar(25),
2060 KEY `language_subtag` (`language_subtag`)
2061 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2063 DROP TABLE IF EXISTS `permissions`;
2064 CREATE TABLE `permissions` (
2065 `module_bit` int(11) NOT NULL DEFAULT 0,
2066 `code` varchar(64) DEFAULT NULL,
2067 `description` varchar(255) DEFAULT NULL,
2068 PRIMARY KEY (`module_bit`, `code`),
2069 CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`)
2070 ON DELETE CASCADE ON UPDATE CASCADE
2071 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2073 DROP TABLE IF EXISTS `serialitems`;
2074 CREATE TABLE `serialitems` (
2075 `itemnumber` int(11) NOT NULL,
2076 `serialid` int(11) NOT NULL,
2077 UNIQUE KEY `serialitemsidx` (`itemnumber`),
2078 KEY `serialitems_sfk_1` (`serialid`),
2079 CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2080 CONSTRAINT serialitems_sfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE
2081 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2083 DROP TABLE IF EXISTS `user_permissions`;
2084 CREATE TABLE `user_permissions` (
2085 `borrowernumber` int(11) NOT NULL DEFAULT 0,
2086 `module_bit` int(11) NOT NULL DEFAULT 0,
2087 `code` varchar(64) DEFAULT NULL,
2088 CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
2089 ON DELETE CASCADE ON UPDATE CASCADE,
2090 CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`)
2091 ON DELETE CASCADE ON UPDATE CASCADE
2092 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2095 -- Table structure for table `tmp_holdsqueue`
2098 DROP TABLE IF EXISTS `tmp_holdsqueue`;
2099 CREATE TABLE `tmp_holdsqueue` (
2100 `biblionumber` int(11) default NULL,
2101 `itemnumber` int(11) default NULL,
2102 `barcode` varchar(20) default NULL,
2103 `surname` mediumtext NOT NULL,
2106 `borrowernumber` int(11) NOT NULL,
2107 `cardnumber` varchar(16) default NULL,
2108 `reservedate` date default NULL,
2110 `itemcallnumber` varchar(255) default NULL,
2111 `holdingbranch` varchar(10) default NULL,
2112 `pickbranch` varchar(10) default NULL,
2114 `item_level_request` tinyint(4) NOT NULL default 0
2115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2118 -- Table structure for table `message_queue`
2121 DROP TABLE IF EXISTS `message_queue`;
2122 CREATE TABLE `message_queue` (
2123 `message_id` int(11) NOT NULL auto_increment,
2124 `borrowernumber` int(11) default NULL,
2127 `metadata` text DEFAULT NULL,
2128 `letter_code` varchar(64) DEFAULT NULL,
2129 `message_transport_type` varchar(20) NOT NULL,
2130 `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2131 `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2132 `to_address` mediumtext,
2133 `from_address` mediumtext,
2134 `content_type` text,
2135 KEY `message_id` (`message_id`),
2136 KEY `borrowernumber` (`borrowernumber`),
2137 KEY `message_transport_type` (`message_transport_type`),
2138 CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2139 CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE RESTRICT ON UPDATE CASCADE
2140 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2143 -- Table structure for table `message_transport_types`
2146 DROP TABLE IF EXISTS `message_transport_types`;
2147 CREATE TABLE `message_transport_types` (
2148 `message_transport_type` varchar(20) NOT NULL,
2149 PRIMARY KEY (`message_transport_type`)
2150 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2153 -- Table structure for table `message_attributes`
2156 DROP TABLE IF EXISTS `message_attributes`;
2157 CREATE TABLE `message_attributes` (
2158 `message_attribute_id` int(11) NOT NULL auto_increment,
2159 `message_name` varchar(40) NOT NULL default '',
2160 `takes_days` tinyint(1) NOT NULL default '0',
2161 PRIMARY KEY (`message_attribute_id`),
2162 UNIQUE KEY `message_name` (`message_name`)
2163 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2166 -- Table structure for table `message_transports`
2169 DROP TABLE IF EXISTS `message_transports`;
2170 CREATE TABLE `message_transports` (
2171 `message_attribute_id` int(11) NOT NULL,
2172 `message_transport_type` varchar(20) NOT NULL,
2173 `is_digest` tinyint(1) NOT NULL default '0',
2174 `letter_module` varchar(20) NOT NULL default '',
2175 `letter_code` varchar(20) NOT NULL default '',
2176 PRIMARY KEY (`message_attribute_id`,`message_transport_type`,`is_digest`),
2177 KEY `message_transport_type` (`message_transport_type`),
2178 KEY `letter_module` (`letter_module`,`letter_code`),
2179 CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2180 CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
2181 CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`) REFERENCES `letter` (`module`, `code`) ON DELETE CASCADE ON UPDATE CASCADE
2182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2185 -- Table structure for table `borrower_message_preferences`
2188 DROP TABLE IF EXISTS `borrower_message_preferences`;
2189 CREATE TABLE `borrower_message_preferences` (
2190 `borrower_message_preference_id` int(11) NOT NULL auto_increment,
2191 `borrowernumber` int(11) default NULL,
2192 `categorycode` varchar(10) default NULL,
2193 `message_attribute_id` int(11) default '0',
2194 `days_in_advance` int(11) default '0',
2195 `wants_digest` tinyint(1) NOT NULL default '0',
2196 PRIMARY KEY (`borrower_message_preference_id`),
2197 KEY `borrowernumber` (`borrowernumber`),
2198 KEY `categorycode` (`categorycode`),
2199 KEY `message_attribute_id` (`message_attribute_id`),
2200 CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2201 CONSTRAINT `borrower_message_preferences_ibfk_2` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2202 CONSTRAINT `borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
2203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2206 -- Table structure for table `borrower_message_transport_preferences`
2209 DROP TABLE IF EXISTS `borrower_message_transport_preferences`;
2210 CREATE TABLE `borrower_message_transport_preferences` (
2211 `borrower_message_preference_id` int(11) NOT NULL default '0',
2212 `message_transport_type` varchar(20) NOT NULL default '0',
2213 PRIMARY KEY (`borrower_message_preference_id`,`message_transport_type`),
2214 KEY `message_transport_type` (`message_transport_type`),
2215 CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_preferences` (`borrower_message_preference_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2216 CONSTRAINT `borrower_message_transport_preferences_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE
2217 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2220 -- Table structure for the table branch_transfer_limits
2223 DROP TABLE IF EXISTS `branch_transfer_limits`;
2224 CREATE TABLE branch_transfer_limits (
2225 limitId int(8) NOT NULL auto_increment,
2226 toBranch varchar(10) NOT NULL,
2227 fromBranch varchar(10) NOT NULL,
2228 itemtype varchar(10) NULL,
2229 ccode varchar(10) NULL,
2230 PRIMARY KEY (limitId)
2231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2234 -- Table structure for table `item_circulation_alert_preferences`
2237 DROP TABLE IF EXISTS `item_circulation_alert_preferences`;
2238 CREATE TABLE `item_circulation_alert_preferences` (
2239 `id` int(11) NOT NULL auto_increment,
2240 `branchcode` varchar(10) NOT NULL,
2241 `categorycode` varchar(10) NOT NULL,
2242 `item_type` varchar(10) NOT NULL,
2243 `notification` varchar(16) NOT NULL,
2245 KEY `branchcode` (`branchcode`,`categorycode`,`item_type`, `notification`)
2246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2249 -- Table structure for table `messages`
2251 DROP TABLE IF EXISTS `messages`;
2252 CREATE TABLE `messages` (
2253 `message_id` int(11) NOT NULL auto_increment,
2254 `borrowernumber` int(11) NOT NULL,
2255 `branchcode` varchar(10) default NULL,
2256 `message_type` varchar(1) NOT NULL,
2257 `message` text NOT NULL,
2258 `message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
2259 PRIMARY KEY (`message_id`)
2260 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2263 -- Table structure for table `accountlines`
2266 DROP TABLE IF EXISTS `accountlines`;
2267 CREATE TABLE `accountlines` (
2268 `borrowernumber` int(11) NOT NULL default 0,
2269 `accountno` smallint(6) NOT NULL default 0,
2270 `itemnumber` int(11) default NULL,
2271 `date` date default NULL,
2272 `amount` decimal(28,6) default NULL,
2273 `description` mediumtext,
2274 `dispute` mediumtext,
2275 `accounttype` varchar(5) default NULL,
2276 `amountoutstanding` decimal(28,6) default NULL,
2277 `lastincrement` decimal(28,6) default NULL,
2278 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2279 `notify_id` int(11) NOT NULL default 0,
2280 `notify_level` int(2) NOT NULL default 0,
2281 KEY `acctsborridx` (`borrowernumber`),
2282 KEY `timeidx` (`timestamp`),
2283 KEY `itemnumber` (`itemnumber`),
2284 CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2285 CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2286 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2289 -- Table structure for table `accountoffsets`
2292 DROP TABLE IF EXISTS `accountoffsets`;
2293 CREATE TABLE `accountoffsets` (
2294 `borrowernumber` int(11) NOT NULL default 0,
2295 `accountno` smallint(6) NOT NULL default 0,
2296 `offsetaccount` smallint(6) NOT NULL default 0,
2297 `offsetamount` decimal(28,6) default NULL,
2298 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2299 CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2300 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2303 -- Table structure for table `action_logs`
2306 DROP TABLE IF EXISTS `action_logs`;
2307 CREATE TABLE `action_logs` (
2308 `action_id` int(11) NOT NULL auto_increment,
2309 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2310 `user` int(11) NOT NULL default 0,
2313 `object` int(11) default NULL,
2315 PRIMARY KEY (`action_id`),
2316 KEY (`timestamp`,`user`)
2317 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2320 -- Table structure for table `alert`
2323 DROP TABLE IF EXISTS `alert`;
2324 CREATE TABLE `alert` (
2325 `alertid` int(11) NOT NULL auto_increment,
2326 `borrowernumber` int(11) NOT NULL default 0,
2327 `type` varchar(10) NOT NULL default '',
2328 `externalid` varchar(20) NOT NULL default '',
2329 PRIMARY KEY (`alertid`),
2330 KEY `borrowernumber` (`borrowernumber`),
2331 KEY `type` (`type`,`externalid`)
2332 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2335 -- Table structure for table `aqbasketgroups`
2338 DROP TABLE IF EXISTS `aqbasketgroups`;
2339 CREATE TABLE `aqbasketgroups` (
2340 `id` int(11) NOT NULL auto_increment,
2341 `name` varchar(50) default NULL,
2342 `closed` tinyint(1) default NULL,
2343 `booksellerid` int(11) NOT NULL,
2345 KEY `booksellerid` (`booksellerid`),
2346 CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
2347 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2350 -- Table structure for table `aqbasket`
2353 DROP TABLE IF EXISTS `aqbasket`;
2354 CREATE TABLE `aqbasket` (
2355 `basketno` int(11) NOT NULL auto_increment,
2356 `basketname` varchar(50) default NULL,
2358 `booksellernote` mediumtext,
2359 `contractnumber` int(11),
2360 `creationdate` date default NULL,
2361 `closedate` date default NULL,
2362 `booksellerid` int(11) NOT NULL default 1,
2363 `authorisedby` varchar(10) default NULL,
2364 `booksellerinvoicenumber` mediumtext,
2365 `basketgroupid` int(11),
2366 PRIMARY KEY (`basketno`),
2367 KEY `booksellerid` (`booksellerid`),
2368 KEY `basketgroupid` (`basketgroupid`),
2369 KEY `contractnumber` (`contractnumber`),
2370 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2371 CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2372 CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE
2373 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2376 -- Table structure for table `aqbooksellers`
2379 DROP TABLE IF EXISTS `aqbooksellers`;
2380 CREATE TABLE `aqbooksellers` (
2381 `id` int(11) NOT NULL auto_increment,
2382 `name` mediumtext NOT NULL,
2383 `address1` mediumtext,
2384 `address2` mediumtext,
2385 `address3` mediumtext,
2386 `address4` mediumtext,
2387 `phone` varchar(30) default NULL,
2388 `accountnumber` mediumtext,
2389 `othersupplier` mediumtext,
2390 `currency` varchar(3) NOT NULL default '',
2391 `booksellerfax` mediumtext,
2393 `bookselleremail` mediumtext,
2394 `booksellerurl` mediumtext,
2395 `contact` varchar(100) default NULL,
2396 `postal` mediumtext,
2397 `url` varchar(255) default NULL,
2398 `contpos` varchar(100) default NULL,
2399 `contphone` varchar(100) default NULL,
2400 `contfax` varchar(100) default NULL,
2401 `contaltphone` varchar(100) default NULL,
2402 `contemail` varchar(100) default NULL,
2403 `contnotes` mediumtext,
2404 `active` tinyint(4) default NULL,
2405 `listprice` varchar(10) default NULL,
2406 `invoiceprice` varchar(10) default NULL,
2407 `gstreg` tinyint(4) default NULL,
2408 `listincgst` tinyint(4) default NULL,
2409 `invoiceincgst` tinyint(4) default NULL,
2410 `gstrate` decimal(6,4) default NULL,
2411 `discount` float(6,4) default NULL,
2412 `fax` varchar(50) default NULL,
2414 KEY `listprice` (`listprice`),
2415 KEY `invoiceprice` (`invoiceprice`),
2416 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2417 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2421 -- Table structure for table `aqbudgets`
2424 DROP TABLE IF EXISTS `aqbudgets`;
2425 CREATE TABLE `aqbudgets` (
2426 `budget_id` int(11) NOT NULL auto_increment,
2427 `budget_parent_id` int(11) default NULL,
2428 `budget_code` varchar(30) default NULL,
2429 `budget_name` varchar(80) default NULL,
2430 `budget_branchcode` varchar(10) default NULL,
2431 `budget_amount` decimal(28,6) NULL default '0.00',
2432 `budget_encumb` decimal(28,6) NULL default '0.00',
2433 `budget_expend` decimal(28,6) NULL default '0.00',
2434 `budget_notes` mediumtext,
2435 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2436 `budget_period_id` int(11) default NULL,
2437 `sort1_authcat` varchar(80) default NULL,
2438 `sort2_authcat` varchar(80) default NULL,
2439 `budget_owner_id` int(11) default NULL,
2440 `budget_permission` int(1) default '0',
2441 PRIMARY KEY (`budget_id`)
2442 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2446 -- Table structure for table `aqbudgetperiods`
2450 DROP TABLE IF EXISTS `aqbudgetperiods`;
2451 CREATE TABLE `aqbudgetperiods` (
2452 `budget_period_id` int(11) NOT NULL auto_increment,
2453 `budget_period_startdate` date NOT NULL,
2454 `budget_period_enddate` date NOT NULL,
2455 `budget_period_active` tinyint(1) default '0',
2456 `budget_period_description` mediumtext,
2457 `budget_period_total` decimal(28,6),
2458 `budget_period_locked` tinyint(1) default NULL,
2459 `sort1_authcat` varchar(10) default NULL,
2460 `sort2_authcat` varchar(10) default NULL,
2461 PRIMARY KEY (`budget_period_id`)
2462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2465 -- Table structure for table `aqbudgets_planning`
2468 DROP TABLE IF EXISTS `aqbudgets_planning`;
2469 CREATE TABLE `aqbudgets_planning` (
2470 `plan_id` int(11) NOT NULL auto_increment,
2471 `budget_id` int(11) NOT NULL,
2472 `budget_period_id` int(11) NOT NULL,
2473 `estimated_amount` decimal(28,6) default NULL,
2474 `authcat` varchar(30) NOT NULL,
2475 `authvalue` varchar(30) NOT NULL,
2476 `display` tinyint(1) DEFAULT 1,
2477 PRIMARY KEY (`plan_id`),
2478 CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2479 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2482 -- Table structure for table 'aqcontract'
2485 DROP TABLE IF EXISTS `aqcontract`;
2486 CREATE TABLE `aqcontract` (
2487 `contractnumber` int(11) NOT NULL auto_increment,
2488 `contractstartdate` date default NULL,
2489 `contractenddate` date default NULL,
2490 `contractname` varchar(50) default NULL,
2491 `contractdescription` mediumtext,
2492 `booksellerid` int(11) not NULL,
2493 PRIMARY KEY (`contractnumber`),
2494 CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2495 REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2496 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2499 -- Table structure for table `aqorderdelivery`
2502 DROP TABLE IF EXISTS `aqorderdelivery`;
2503 CREATE TABLE `aqorderdelivery` (
2504 `ordernumber` date default NULL,
2505 `deliverynumber` smallint(6) NOT NULL default 0,
2506 `deliverydate` varchar(18) default NULL,
2507 `qtydelivered` smallint(6) default NULL,
2508 `deliverycomments` mediumtext
2509 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2512 -- Table structure for table `aqorders`
2515 DROP TABLE IF EXISTS `aqorders`;
2516 CREATE TABLE `aqorders` (
2517 `ordernumber` int(11) NOT NULL auto_increment,
2518 `biblionumber` int(11) default NULL,
2519 `entrydate` date default NULL,
2520 `quantity` smallint(6) default NULL,
2521 `currency` varchar(3) default NULL,
2522 `listprice` decimal(28,6) default NULL,
2523 `totalamount` decimal(28,6) default NULL,
2524 `datereceived` date default NULL,
2525 `booksellerinvoicenumber` mediumtext,
2526 `freight` decimal(28,6) default NULL,
2527 `unitprice` decimal(28,6) default NULL,
2528 `quantityreceived` smallint(6) NOT NULL default 0,
2529 `cancelledby` varchar(10) default NULL,
2530 `datecancellationprinted` date default NULL,
2532 `supplierreference` mediumtext,
2533 `purchaseordernumber` mediumtext,
2534 `subscription` tinyint(1) default NULL,
2535 `serialid` varchar(30) default NULL,
2536 `basketno` int(11) default NULL,
2537 `biblioitemnumber` int(11) default NULL,
2538 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2539 `rrp` decimal(13,2) default NULL,
2540 `ecost` decimal(13,2) default NULL,
2541 `gst` decimal(13,2) default NULL,
2542 `budget_id` int(11) NOT NULL,
2543 `budgetgroup_id` int(11) NOT NULL,
2544 `budgetdate` date default NULL,
2545 `sort1` varchar(80) default NULL,
2546 `sort2` varchar(80) default NULL,
2547 `sort1_authcat` varchar(10) default NULL,
2548 `sort2_authcat` varchar(10) default NULL,
2549 `uncertainprice` tinyint(1),
2550 PRIMARY KEY (`ordernumber`),
2551 KEY `basketno` (`basketno`),
2552 KEY `biblionumber` (`biblionumber`),
2553 KEY `budget_id` (`budget_id`),
2554 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2555 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2556 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2560 -- Table structure for table `aqorders_items`
2563 DROP TABLE IF EXISTS `aqorders_items`;
2564 CREATE TABLE `aqorders_items` (
2565 `ordernumber` int(11) NOT NULL,
2566 `itemnumber` int(11) NOT NULL,
2567 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2568 PRIMARY KEY (`itemnumber`),
2569 KEY `ordernumber` (`ordernumber`)
2570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2573 -- Table structure for table `fieldmapping`
2576 DROP TABLE IF EXISTS `fieldmapping`;
2577 CREATE TABLE `fieldmapping` (
2578 `id` int(11) NOT NULL auto_increment,
2579 `field` varchar(255) NOT NULL,
2580 `frameworkcode` char(4) NOT NULL default '',
2581 `fieldcode` char(3) NOT NULL,
2582 `subfieldcode` char(1) NOT NULL,
2584 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2587 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2588 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2589 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2590 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2591 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2592 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2593 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2594 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;