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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111 -- Table structure for table `biblio`
114 DROP TABLE IF EXISTS `biblio`;
115 CREATE TABLE `biblio` (
116 `biblionumber` int(11) NOT NULL auto_increment,
117 `frameworkcode` varchar(4) NOT NULL default '',
120 `unititle` mediumtext,
122 `serial` tinyint(1) default NULL,
123 `seriestitle` mediumtext,
124 `copyrightdate` smallint(6) default NULL,
125 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
126 `datecreated` DATE NOT NULL,
127 `abstract` mediumtext,
128 PRIMARY KEY (`biblionumber`),
129 KEY `blbnoidx` (`biblionumber`)
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
133 -- Table structure for table `biblio_framework`
136 DROP TABLE IF EXISTS `biblio_framework`;
137 CREATE TABLE `biblio_framework` (
138 `frameworkcode` varchar(4) NOT NULL default '',
139 `frameworktext` varchar(255) NOT NULL default '',
140 PRIMARY KEY (`frameworkcode`)
141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144 -- Table structure for table `biblioitems`
147 DROP TABLE IF EXISTS `biblioitems`;
148 CREATE TABLE `biblioitems` (
149 `biblioitemnumber` int(11) NOT NULL auto_increment,
150 `biblionumber` int(11) NOT NULL default 0,
153 `itemtype` varchar(10) default NULL,
154 `isbn` varchar(30) default NULL,
155 `issn` varchar(9) default NULL,
156 `publicationyear` text,
157 `publishercode` varchar(255) default NULL,
158 `volumedate` date default NULL,
160 `collectiontitle` mediumtext default NULL,
161 `collectionissn` text default NULL,
162 `collectionvolume` mediumtext default NULL,
163 `editionstatement` text default NULL,
164 `editionresponsibility` text default NULL,
165 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
166 `illus` varchar(255) default NULL,
167 `pages` varchar(255) default NULL,
169 `size` varchar(255) default NULL,
170 `place` varchar(255) default NULL,
171 `lccn` varchar(25) default NULL,
173 `url` varchar(255) default NULL,
174 `cn_source` varchar(10) default NULL,
175 `cn_class` varchar(30) default NULL,
176 `cn_item` varchar(10) default NULL,
177 `cn_suffix` varchar(10) default NULL,
178 `cn_sort` varchar(30) default NULL,
179 `totalissues` int(10),
180 `marcxml` longtext NOT NULL,
181 PRIMARY KEY (`biblioitemnumber`),
182 KEY `bibinoidx` (`biblioitemnumber`),
183 KEY `bibnoidx` (`biblionumber`),
185 KEY `publishercode` (`publishercode`),
186 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
187 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
190 -- Table structure for table `borrowers`
193 DROP TABLE IF EXISTS `borrowers`;
194 CREATE TABLE `borrowers` (
195 `borrowernumber` int(11) NOT NULL auto_increment,
196 `cardnumber` varchar(16) default NULL,
197 `surname` mediumtext NOT NULL,
200 `othernames` mediumtext,
202 `streetnumber` varchar(10) default NULL,
203 `streettype` varchar(50) default NULL,
204 `address` mediumtext NOT NULL,
206 `city` mediumtext NOT NULL,
207 `zipcode` varchar(25) default NULL,
211 `mobile` varchar(50) default NULL,
215 `B_streetnumber` varchar(10) default NULL,
216 `B_streettype` varchar(50) default NULL,
217 `B_address` varchar(100) default NULL,
218 `B_address2` text default NULL,
220 `B_zipcode` varchar(25) default NULL,
223 `B_phone` mediumtext,
224 `dateofbirth` date default NULL,
225 `branchcode` varchar(10) NOT NULL default '',
226 `categorycode` varchar(10) NOT NULL default '',
227 `dateenrolled` date default NULL,
228 `dateexpiry` date default NULL,
229 `gonenoaddress` tinyint(1) default NULL,
230 `lost` tinyint(1) default NULL,
231 `debarred` tinyint(1) default NULL,
232 `contactname` mediumtext,
233 `contactfirstname` text,
235 `guarantorid` int(11) default NULL,
236 `borrowernotes` mediumtext,
237 `relationship` varchar(100) default NULL,
238 `ethnicity` varchar(50) default NULL,
239 `ethnotes` varchar(255) default NULL,
240 `sex` varchar(1) default NULL,
241 `password` varchar(30) default NULL,
242 `flags` int(11) default NULL,
243 `userid` varchar(30) default NULL,
244 `opacnote` mediumtext,
245 `contactnote` varchar(255) default NULL,
246 `sort1` varchar(80) default NULL,
247 `sort2` varchar(80) default NULL,
248 `altcontactfirstname` varchar(255) default NULL,
249 `altcontactsurname` varchar(255) default NULL,
250 `altcontactaddress1` varchar(255) default NULL,
251 `altcontactaddress2` varchar(255) default NULL,
252 `altcontactaddress3` varchar(255) default NULL,
253 `altcontactzipcode` varchar(50) default NULL,
254 `altcontactcountry` text default NULL,
255 `altcontactphone` varchar(50) default NULL,
256 `smsalertnumber` varchar(50) default NULL,
257 UNIQUE KEY `cardnumber` (`cardnumber`),
258 PRIMARY KEY `borrowernumber` (`borrowernumber`),
259 KEY `categorycode` (`categorycode`),
260 KEY `branchcode` (`branchcode`),
261 KEY `userid` (`userid`),
262 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
263 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
264 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
267 -- Table structure for table `borrower_attribute_types`
270 DROP TABLE IF EXISTS `borrower_attribute_types`;
271 CREATE TABLE `borrower_attribute_types` (
272 `code` varchar(10) NOT NULL,
273 `description` varchar(255) NOT NULL,
274 `repeatable` tinyint(1) NOT NULL default 0,
275 `unique_id` tinyint(1) NOT NULL default 0,
276 `opac_display` tinyint(1) NOT NULL default 0,
277 `password_allowed` tinyint(1) NOT NULL default 0,
278 `staff_searchable` tinyint(1) NOT NULL default 0,
279 `authorised_value_category` varchar(10) default NULL,
281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
284 -- Table structure for table `borrower_attributes`
287 DROP TABLE IF EXISTS `borrower_attributes`;
288 CREATE TABLE `borrower_attributes` (
289 `borrowernumber` int(11) NOT NULL,
290 `code` varchar(10) NOT NULL,
291 `attribute` varchar(64) default NULL,
292 `password` varchar(64) default NULL,
293 KEY `borrowernumber` (`borrowernumber`),
294 KEY `code_attribute` (`code`, `attribute`),
295 CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
296 ON DELETE CASCADE ON UPDATE CASCADE,
297 CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`)
298 ON DELETE CASCADE ON UPDATE CASCADE
299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301 DROP TABLE IF EXISTS `branch_item_rules`;
302 CREATE TABLE `branch_item_rules` (
303 `branchcode` varchar(10) NOT NULL,
304 `itemtype` varchar(10) NOT NULL,
305 `holdallowed` tinyint(1) default NULL,
306 PRIMARY KEY (`itemtype`,`branchcode`),
307 KEY `branch_item_rules_ibfk_2` (`branchcode`),
308 CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
309 ON DELETE CASCADE ON UPDATE CASCADE,
310 CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
311 ON DELETE CASCADE ON UPDATE CASCADE
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
315 -- Table structure for table `branchcategories`
318 DROP TABLE IF EXISTS `branchcategories`;
319 CREATE TABLE `branchcategories` (
320 `categorycode` varchar(10) NOT NULL default '',
321 `categoryname` varchar(32),
322 `codedescription` mediumtext,
323 `categorytype` varchar(16),
324 PRIMARY KEY (`categorycode`)
325 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
328 -- Table structure for table `branches`
331 DROP TABLE IF EXISTS `branches`;
332 CREATE TABLE `branches` (
333 `branchcode` varchar(10) NOT NULL default '',
334 `branchname` mediumtext NOT NULL,
335 `branchaddress1` mediumtext,
336 `branchaddress2` mediumtext,
337 `branchaddress3` mediumtext,
338 `branchzip` varchar(25) default NULL,
339 `branchcity` mediumtext,
340 `branchcountry` text,
341 `branchphone` mediumtext,
342 `branchfax` mediumtext,
343 `branchemail` mediumtext,
344 `branchurl` mediumtext,
345 `issuing` tinyint(4) default NULL,
346 `branchip` varchar(15) default NULL,
347 `branchprinter` varchar(100) default NULL,
348 `branchnotes` mediumtext,
349 UNIQUE KEY `branchcode` (`branchcode`)
350 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
353 -- Table structure for table `branchrelations`
356 DROP TABLE IF EXISTS `branchrelations`;
357 CREATE TABLE `branchrelations` (
358 `branchcode` varchar(10) NOT NULL default '',
359 `categorycode` varchar(10) NOT NULL default '',
360 PRIMARY KEY (`branchcode`,`categorycode`),
361 KEY `branchcode` (`branchcode`),
362 KEY `categorycode` (`categorycode`),
363 CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
364 CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
365 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
368 -- Table structure for table `branchtransfers`
371 DROP TABLE IF EXISTS `branchtransfers`;
372 CREATE TABLE `branchtransfers` (
373 `itemnumber` int(11) NOT NULL default 0,
374 `datesent` datetime default NULL,
375 `frombranch` varchar(10) NOT NULL default '',
376 `datearrived` datetime default NULL,
377 `tobranch` varchar(10) NOT NULL default '',
378 `comments` mediumtext,
379 KEY `frombranch` (`frombranch`),
380 KEY `tobranch` (`tobranch`),
381 KEY `itemnumber` (`itemnumber`),
382 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
383 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
384 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
385 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
389 -- Table structure for table `browser`
391 DROP TABLE IF EXISTS `browser`;
392 CREATE TABLE `browser` (
393 `level` int(11) NOT NULL,
394 `classification` varchar(20) NOT NULL,
395 `description` varchar(255) NOT NULL,
396 `number` bigint(20) NOT NULL,
397 `endnode` tinyint(4) NOT NULL
398 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
401 -- Table structure for table `categories`
404 DROP TABLE IF EXISTS `categories`;
405 CREATE TABLE `categories` (
406 `categorycode` varchar(10) NOT NULL default '',
407 `description` mediumtext,
408 `enrolmentperiod` smallint(6) default NULL,
409 `enrolmentperioddate` DATE NULL DEFAULT NULL,
410 `upperagelimit` smallint(6) default NULL,
411 `dateofbirthrequired` tinyint(1) default NULL,
412 `finetype` varchar(30) default NULL,
413 `bulk` tinyint(1) default NULL,
414 `enrolmentfee` decimal(28,6) default NULL,
415 `overduenoticerequired` tinyint(1) default NULL,
416 `issuelimit` smallint(6) default NULL,
417 `reservefee` decimal(28,6) default NULL,
418 `category_type` varchar(1) NOT NULL default 'A',
419 PRIMARY KEY (`categorycode`),
420 UNIQUE KEY `categorycode` (`categorycode`)
421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
424 -- Table: collections
426 CREATE TABLE collections (
427 colId integer(11) NOT NULL auto_increment,
428 colTitle varchar(100) NOT NULL DEFAULT '',
429 colDesc text NOT NULL,
430 colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.',
432 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
435 -- Table: collections_tracking
437 CREATE TABLE collections_tracking (
438 ctId integer(11) NOT NULL auto_increment,
439 colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
440 itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
442 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
445 -- Table structure for table `borrower_branch_circ_rules`
448 DROP TABLE IF EXISTS `branch_borrower_circ_rules`;
449 CREATE TABLE `branch_borrower_circ_rules` (
450 `branchcode` VARCHAR(10) NOT NULL,
451 `categorycode` VARCHAR(10) NOT NULL,
452 `maxissueqty` int(4) default NULL,
453 PRIMARY KEY (`categorycode`, `branchcode`),
454 CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
455 ON DELETE CASCADE ON UPDATE CASCADE,
456 CONSTRAINT `branch_borrower_circ_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
457 ON DELETE CASCADE ON UPDATE CASCADE
458 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
461 -- Table structure for table `default_borrower_circ_rules`
464 DROP TABLE IF EXISTS `default_borrower_circ_rules`;
465 CREATE TABLE `default_borrower_circ_rules` (
466 `categorycode` VARCHAR(10) NOT NULL,
467 `maxissueqty` int(4) default NULL,
468 PRIMARY KEY (`categorycode`),
469 CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
470 ON DELETE CASCADE ON UPDATE CASCADE
471 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
474 -- Table structure for table `default_branch_circ_rules`
477 DROP TABLE IF EXISTS `default_branch_circ_rules`;
478 CREATE TABLE `default_branch_circ_rules` (
479 `branchcode` VARCHAR(10) NOT NULL,
480 `maxissueqty` int(4) default NULL,
481 `holdallowed` tinyint(1) default NULL,
482 PRIMARY KEY (`branchcode`),
483 CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
484 ON DELETE CASCADE ON UPDATE CASCADE
485 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
488 -- Table structure for table `default_branch_item_rules`
490 DROP TABLE IF EXISTS `default_branch_item_rules`;
491 CREATE TABLE `default_branch_item_rules` (
492 `itemtype` varchar(10) NOT NULL,
493 `holdallowed` tinyint(1) default NULL,
494 PRIMARY KEY (`itemtype`),
495 CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
496 ON DELETE CASCADE ON UPDATE CASCADE
497 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
500 -- Table structure for table `default_circ_rules`
503 DROP TABLE IF EXISTS `default_circ_rules`;
504 CREATE TABLE `default_circ_rules` (
505 `singleton` enum('singleton') NOT NULL default 'singleton',
506 `maxissueqty` int(4) default NULL,
507 `holdallowed` int(1) default NULL,
508 PRIMARY KEY (`singleton`)
509 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
512 -- Table structure for table `cities`
515 DROP TABLE IF EXISTS `cities`;
516 CREATE TABLE `cities` (
517 `cityid` int(11) NOT NULL auto_increment,
518 `city_name` varchar(100) NOT NULL default '',
519 `city_zipcode` varchar(20) default NULL,
520 PRIMARY KEY (`cityid`)
521 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
524 -- Table structure for table `class_sort_rules`
527 DROP TABLE IF EXISTS `class_sort_rules`;
528 CREATE TABLE `class_sort_rules` (
529 `class_sort_rule` varchar(10) NOT NULL default '',
530 `description` mediumtext,
531 `sort_routine` varchar(30) NOT NULL default '',
532 PRIMARY KEY (`class_sort_rule`),
533 UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
534 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
537 -- Table structure for table `class_sources`
540 DROP TABLE IF EXISTS `class_sources`;
541 CREATE TABLE `class_sources` (
542 `cn_source` varchar(10) NOT NULL default '',
543 `description` mediumtext,
544 `used` tinyint(4) NOT NULL default 0,
545 `class_sort_rule` varchar(10) NOT NULL default '',
546 PRIMARY KEY (`cn_source`),
547 UNIQUE KEY `cn_source_idx` (`cn_source`),
548 KEY `used_idx` (`used`),
549 CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
550 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
553 -- Table structure for table `currency`
556 DROP TABLE IF EXISTS `currency`;
557 CREATE TABLE `currency` (
558 `currency` varchar(10) NOT NULL default '',
559 `symbol` varchar(5) default NULL,
560 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
561 `rate` float(7,5) default NULL,
562 `active` tinyint(1) default NULL,
563 PRIMARY KEY (`currency`)
564 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
567 -- Table structure for table `deletedbiblio`
570 DROP TABLE IF EXISTS `deletedbiblio`;
571 CREATE TABLE `deletedbiblio` (
572 `biblionumber` int(11) NOT NULL default 0,
573 `frameworkcode` varchar(4) NOT NULL default '',
576 `unititle` mediumtext,
578 `serial` tinyint(1) default NULL,
579 `seriestitle` mediumtext,
580 `copyrightdate` smallint(6) default NULL,
581 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
582 `datecreated` DATE NOT NULL,
583 `abstract` mediumtext,
584 PRIMARY KEY (`biblionumber`),
585 KEY `blbnoidx` (`biblionumber`)
586 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
589 -- Table structure for table `deletedbiblioitems`
592 DROP TABLE IF EXISTS `deletedbiblioitems`;
593 CREATE TABLE `deletedbiblioitems` (
594 `biblioitemnumber` int(11) NOT NULL default 0,
595 `biblionumber` int(11) NOT NULL default 0,
598 `itemtype` varchar(10) default NULL,
599 `isbn` varchar(30) default NULL,
600 `issn` varchar(9) default NULL,
601 `publicationyear` text,
602 `publishercode` varchar(255) default NULL,
603 `volumedate` date default NULL,
605 `collectiontitle` mediumtext default NULL,
606 `collectionissn` text default NULL,
607 `collectionvolume` mediumtext default NULL,
608 `editionstatement` text default NULL,
609 `editionresponsibility` text default NULL,
610 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
611 `illus` varchar(255) default NULL,
612 `pages` varchar(255) default NULL,
614 `size` varchar(255) default NULL,
615 `place` varchar(255) default NULL,
616 `lccn` varchar(25) default NULL,
618 `url` varchar(255) default NULL,
619 `cn_source` varchar(10) default NULL,
620 `cn_class` varchar(30) default NULL,
621 `cn_item` varchar(10) default NULL,
622 `cn_suffix` varchar(10) default NULL,
623 `cn_sort` varchar(30) default NULL,
624 `totalissues` int(10),
625 `marcxml` longtext NOT NULL,
626 PRIMARY KEY (`biblioitemnumber`),
627 KEY `bibinoidx` (`biblioitemnumber`),
628 KEY `bibnoidx` (`biblionumber`),
630 KEY `publishercode` (`publishercode`)
631 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
634 -- Table structure for table `deletedborrowers`
637 DROP TABLE IF EXISTS `deletedborrowers`;
638 CREATE TABLE `deletedborrowers` (
639 `borrowernumber` int(11) NOT NULL default 0,
640 `cardnumber` varchar(9) NOT NULL default '',
641 `surname` mediumtext NOT NULL,
644 `othernames` mediumtext,
646 `streetnumber` varchar(10) default NULL,
647 `streettype` varchar(50) default NULL,
648 `address` mediumtext NOT NULL,
650 `city` mediumtext NOT NULL,
651 `zipcode` varchar(25) default NULL,
655 `mobile` varchar(50) default NULL,
659 `B_streetnumber` varchar(10) default NULL,
660 `B_streettype` varchar(50) default NULL,
661 `B_address` varchar(100) default NULL,
662 `B_address2` text default NULL,
664 `B_zipcode` varchar(25) default NULL,
667 `B_phone` mediumtext,
668 `dateofbirth` date default NULL,
669 `branchcode` varchar(10) NOT NULL default '',
670 `categorycode` varchar(10) default NULL,
671 `dateenrolled` date default NULL,
672 `dateexpiry` date default NULL,
673 `gonenoaddress` tinyint(1) default NULL,
674 `lost` tinyint(1) default NULL,
675 `debarred` tinyint(1) default NULL,
676 `contactname` mediumtext,
677 `contactfirstname` text,
679 `guarantorid` int(11) default NULL,
680 `borrowernotes` mediumtext,
681 `relationship` varchar(100) default NULL,
682 `ethnicity` varchar(50) default NULL,
683 `ethnotes` varchar(255) default NULL,
684 `sex` varchar(1) default NULL,
685 `password` varchar(30) default NULL,
686 `flags` int(11) default NULL,
687 `userid` varchar(30) default NULL,
688 `opacnote` mediumtext,
689 `contactnote` varchar(255) default NULL,
690 `sort1` varchar(80) default NULL,
691 `sort2` varchar(80) default NULL,
692 `altcontactfirstname` varchar(255) default NULL,
693 `altcontactsurname` varchar(255) default NULL,
694 `altcontactaddress1` varchar(255) default NULL,
695 `altcontactaddress2` varchar(255) default NULL,
696 `altcontactaddress3` varchar(255) default NULL,
697 `altcontactzipcode` varchar(50) default NULL,
698 `altcontactcountry` text default NULL,
699 `altcontactphone` varchar(50) default NULL,
700 `smsalertnumber` varchar(50) default NULL,
701 KEY `borrowernumber` (`borrowernumber`),
702 KEY `cardnumber` (`cardnumber`)
703 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
706 -- Table structure for table `deleteditems`
709 DROP TABLE IF EXISTS `deleteditems`;
710 CREATE TABLE `deleteditems` (
711 `itemnumber` int(11) NOT NULL default 0,
712 `biblionumber` int(11) NOT NULL default 0,
713 `biblioitemnumber` int(11) NOT NULL default 0,
714 `barcode` varchar(20) default NULL,
715 `dateaccessioned` date default NULL,
716 `booksellerid` mediumtext default NULL,
717 `homebranch` varchar(10) default NULL,
718 `price` decimal(8,2) default NULL,
719 `replacementprice` decimal(8,2) default NULL,
720 `replacementpricedate` date default NULL,
721 `datelastborrowed` date default NULL,
722 `datelastseen` date default NULL,
723 `stack` tinyint(1) default NULL,
724 `notforloan` tinyint(1) NOT NULL default 0,
725 `damaged` tinyint(1) NOT NULL default 0,
726 `itemlost` tinyint(1) NOT NULL default 0,
727 `wthdrawn` tinyint(1) NOT NULL default 0,
728 `itemcallnumber` varchar(255) default NULL,
729 `issues` smallint(6) default NULL,
730 `renewals` smallint(6) default NULL,
731 `reserves` smallint(6) default NULL,
732 `restricted` tinyint(1) default NULL,
733 `itemnotes` mediumtext,
734 `holdingbranch` varchar(10) default NULL,
735 `paidfor` mediumtext,
736 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
737 `location` varchar(80) default NULL,
738 `permanent_location` varchar(80) default NULL,
739 `onloan` date default NULL,
740 `cn_source` varchar(10) default NULL,
741 `cn_sort` varchar(30) default NULL,
742 `ccode` varchar(10) default NULL,
743 `materials` varchar(10) default NULL,
744 `uri` varchar(255) default NULL,
745 `itype` varchar(10) default NULL,
746 `more_subfields_xml` longtext default NULL,
747 `enumchron` varchar(80) default NULL,
748 `copynumber` varchar(32) default NULL,
749 `stocknumber` varchar(32) default NULL,
751 PRIMARY KEY (`itemnumber`),
752 KEY `delitembarcodeidx` (`barcode`),
753 KEY `delitemstocknumberidx` (`stocknumber`),
754 KEY `delitembinoidx` (`biblioitemnumber`),
755 KEY `delitembibnoidx` (`biblionumber`),
756 KEY `delhomebranch` (`homebranch`),
757 KEY `delholdingbranch` (`holdingbranch`)
758 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
761 -- Table structure for table `ethnicity`
764 DROP TABLE IF EXISTS `ethnicity`;
765 CREATE TABLE `ethnicity` (
766 `code` varchar(10) NOT NULL default '',
767 `name` varchar(255) default NULL,
769 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
772 -- Table structure for table `export_format`
775 DROP TABLE IF EXISTS `export_format`;
776 CREATE TABLE `export_format` (
777 `export_format_id` int(11) NOT NULL auto_increment,
778 `profile` varchar(255) NOT NULL,
779 `description` mediumtext NOT NULL,
780 `marcfields` mediumtext NOT NULL,
781 `csv_separator` varchar(2) NOT NULL,
782 `field_separator` varchar(2) NOT NULL,
783 `subfield_separator` varchar(2) NOT NULL,
784 `encoding` varchar(255) NOT NULL,
785 PRIMARY KEY (`export_format_id`)
786 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export';
790 -- Table structure for table `hold_fill_targets`
793 DROP TABLE IF EXISTS `hold_fill_targets`;
794 CREATE TABLE hold_fill_targets (
795 `borrowernumber` int(11) NOT NULL,
796 `biblionumber` int(11) NOT NULL,
797 `itemnumber` int(11) NOT NULL,
798 `source_branchcode` varchar(10) default NULL,
799 `item_level_request` tinyint(4) NOT NULL default 0,
800 PRIMARY KEY `itemnumber` (`itemnumber`),
801 KEY `bib_branch` (`biblionumber`, `source_branchcode`),
802 CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`)
803 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
804 CONSTRAINT `hold_fill_targets_ibfk_2` FOREIGN KEY (`biblionumber`)
805 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
806 CONSTRAINT `hold_fill_targets_ibfk_3` FOREIGN KEY (`itemnumber`)
807 REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
808 CONSTRAINT `hold_fill_targets_ibfk_4` FOREIGN KEY (`source_branchcode`)
809 REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
810 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
813 -- Table structure for table `import_batches`
816 DROP TABLE IF EXISTS `import_batches`;
817 CREATE TABLE `import_batches` (
818 `import_batch_id` int(11) NOT NULL auto_increment,
819 `matcher_id` int(11) default NULL,
820 `template_id` int(11) default NULL,
821 `branchcode` varchar(10) default NULL,
822 `num_biblios` int(11) NOT NULL default 0,
823 `num_items` int(11) NOT NULL default 0,
824 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
825 `overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new',
826 `nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new',
827 `item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore') NOT NULL default 'always_add',
828 `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging',
829 `batch_type` enum('batch', 'z3950') NOT NULL default 'batch',
830 `file_name` varchar(100),
831 `comments` mediumtext,
832 PRIMARY KEY (`import_batch_id`),
833 KEY `branchcode` (`branchcode`)
834 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
837 -- Table structure for table `import_records`
840 DROP TABLE IF EXISTS `import_records`;
841 CREATE TABLE `import_records` (
842 `import_record_id` int(11) NOT NULL auto_increment,
843 `import_batch_id` int(11) NOT NULL,
844 `branchcode` varchar(10) default NULL,
845 `record_sequence` int(11) NOT NULL default 0,
846 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
847 `import_date` DATE default NULL,
848 `marc` longblob NOT NULL,
849 `marcxml` longtext NOT NULL,
850 `marcxml_old` longtext NOT NULL,
851 `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio',
852 `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match',
853 `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',
854 `import_error` mediumtext,
855 `encoding` varchar(40) NOT NULL default '',
856 `z3950random` varchar(40) default NULL,
857 PRIMARY KEY (`import_record_id`),
858 CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
859 REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
860 KEY `branchcode` (`branchcode`),
861 KEY `batch_sequence` (`import_batch_id`, `record_sequence`)
862 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
865 -- Table structure for `import_record_matches`
867 DROP TABLE IF EXISTS `import_record_matches`;
868 CREATE TABLE `import_record_matches` (
869 `import_record_id` int(11) NOT NULL,
870 `candidate_match_id` int(11) NOT NULL,
871 `score` int(11) NOT NULL default 0,
872 CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
873 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
874 KEY `record_score` (`import_record_id`, `score`)
875 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
878 -- Table structure for table `import_biblios`
881 DROP TABLE IF EXISTS `import_biblios`;
882 CREATE TABLE `import_biblios` (
883 `import_record_id` int(11) NOT NULL,
884 `matched_biblionumber` int(11) default NULL,
885 `control_number` varchar(25) default NULL,
886 `original_source` varchar(25) default NULL,
887 `title` varchar(128) default NULL,
888 `author` varchar(80) default NULL,
889 `isbn` varchar(30) default NULL,
890 `issn` varchar(9) default NULL,
891 `has_items` tinyint(1) NOT NULL default 0,
892 CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
893 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
894 KEY `matched_biblionumber` (`matched_biblionumber`),
895 KEY `title` (`title`),
897 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
900 -- Table structure for table `import_items`
903 DROP TABLE IF EXISTS `import_items`;
904 CREATE TABLE `import_items` (
905 `import_items_id` int(11) NOT NULL auto_increment,
906 `import_record_id` int(11) NOT NULL,
907 `itemnumber` int(11) default NULL,
908 `branchcode` varchar(10) default NULL,
909 `status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged',
910 `marcxml` longtext NOT NULL,
911 `import_error` mediumtext,
912 PRIMARY KEY (`import_items_id`),
913 CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`)
914 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
915 KEY `itemnumber` (`itemnumber`),
916 KEY `branchcode` (`branchcode`)
917 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
920 -- Table structure for table `issues`
923 DROP TABLE IF EXISTS `issues`;
924 CREATE TABLE `issues` (
925 `borrowernumber` int(11) default NULL,
926 `itemnumber` int(11) default NULL,
927 `date_due` date default NULL,
928 `branchcode` varchar(10) default NULL,
929 `issuingbranch` varchar(18) default NULL,
930 `returndate` date default NULL,
931 `lastreneweddate` date default NULL,
932 `return` varchar(4) default NULL,
933 `renewals` tinyint(4) default NULL,
934 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
935 `issuedate` date default NULL,
936 KEY `issuesborridx` (`borrowernumber`),
937 KEY `issuesitemidx` (`itemnumber`),
938 KEY `bordate` (`borrowernumber`,`timestamp`),
939 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
940 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
941 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
944 -- Table structure for table `issuingrules`
947 DROP TABLE IF EXISTS `issuingrules`;
948 CREATE TABLE `issuingrules` (
949 `categorycode` varchar(10) NOT NULL default '',
950 `itemtype` varchar(10) NOT NULL default '',
951 `restrictedtype` tinyint(1) default NULL,
952 `rentaldiscount` decimal(28,6) default NULL,
953 `reservecharge` decimal(28,6) default NULL,
954 `fine` decimal(28,6) default NULL,
955 `finedays` int(11) default NULL,
956 `firstremind` int(11) default NULL,
957 `chargeperiod` int(11) default NULL,
958 `accountsent` int(11) default NULL,
959 `chargename` varchar(100) default NULL,
960 `maxissueqty` int(4) default NULL,
961 `issuelength` int(4) default NULL,
962 `renewalsallowed` smallint(6) NOT NULL default "0",
963 `reservesallowed` smallint(6) NOT NULL default "0",
964 `branchcode` varchar(10) NOT NULL default '',
965 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
966 KEY `categorycode` (`categorycode`),
967 KEY `itemtype` (`itemtype`)
968 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
971 -- Table structure for table `items`
974 DROP TABLE IF EXISTS `items`;
975 CREATE TABLE `items` (
976 `itemnumber` int(11) NOT NULL auto_increment,
977 `biblionumber` int(11) NOT NULL default 0,
978 `biblioitemnumber` int(11) NOT NULL default 0,
979 `barcode` varchar(20) default NULL,
980 `dateaccessioned` date default NULL,
981 `booksellerid` mediumtext default NULL,
982 `homebranch` varchar(10) default NULL,
983 `price` decimal(8,2) default NULL,
984 `replacementprice` decimal(8,2) default NULL,
985 `replacementpricedate` date default NULL,
986 `datelastborrowed` date default NULL,
987 `datelastseen` date default NULL,
988 `stack` tinyint(1) default NULL,
989 `notforloan` tinyint(1) NOT NULL default 0,
990 `damaged` tinyint(1) NOT NULL default 0,
991 `itemlost` tinyint(1) NOT NULL default 0,
992 `wthdrawn` tinyint(1) NOT NULL default 0,
993 `itemcallnumber` varchar(255) default NULL,
994 `issues` smallint(6) default NULL,
995 `renewals` smallint(6) default NULL,
996 `reserves` smallint(6) default NULL,
997 `restricted` tinyint(1) default NULL,
998 `itemnotes` mediumtext,
999 `holdingbranch` varchar(10) default NULL,
1000 `paidfor` mediumtext,
1001 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1002 `location` varchar(80) default NULL,
1003 `permanent_location` varchar(80) default NULL,
1004 `onloan` date default NULL,
1005 `cn_source` varchar(10) default NULL,
1006 `cn_sort` varchar(30) default NULL,
1007 `ccode` varchar(10) default NULL,
1008 `materials` varchar(10) default NULL,
1009 `uri` varchar(255) default NULL,
1010 `itype` varchar(10) default NULL,
1011 `more_subfields_xml` longtext default NULL,
1012 `enumchron` varchar(80) default NULL,
1013 `copynumber` varchar(32) default NULL,
1014 `stocknumber` varchar(32) default NULL,
1015 PRIMARY KEY (`itemnumber`),
1016 UNIQUE KEY `itembarcodeidx` (`barcode`),
1017 UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
1018 KEY `itembinoidx` (`biblioitemnumber`),
1019 KEY `itembibnoidx` (`biblionumber`),
1020 KEY `homebranch` (`homebranch`),
1021 KEY `holdingbranch` (`holdingbranch`),
1022 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1023 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1024 CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1025 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1028 -- Table structure for table `itemtypes`
1031 DROP TABLE IF EXISTS `itemtypes`;
1032 CREATE TABLE `itemtypes` (
1033 `itemtype` varchar(10) NOT NULL default '',
1034 `description` mediumtext,
1035 `rentalcharge` double(16,4) default NULL,
1036 `notforloan` smallint(6) default NULL,
1037 `imageurl` varchar(200) default NULL,
1039 PRIMARY KEY (`itemtype`),
1040 UNIQUE KEY `itemtype` (`itemtype`)
1041 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1044 -- Table structure for table `creator_batches`
1047 DROP TABLE IF EXISTS `creator_batches`;
1048 SET @saved_cs_client = @@character_set_client;
1049 SET character_set_client = utf8;
1050 CREATE TABLE `creator_batches` (
1051 `label_id` int(11) NOT NULL AUTO_INCREMENT,
1052 `batch_id` int(10) NOT NULL DEFAULT '1',
1053 `item_number` int(11) DEFAULT NULL,
1054 `borrower_number` int(11) DEFAULT NULL,
1055 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1056 `branch_code` varchar(10) NOT NULL DEFAULT 'NB',
1057 `creator` char(15) NOT NULL DEFAULT 'Labels',
1058 PRIMARY KEY (`label_id`),
1059 KEY `branch_fk_constraint` (`branch_code`),
1060 KEY `item_fk_constraint` (`item_number`),
1061 KEY `borrower_fk_constraint` (`borrower_number`),
1062 CONSTRAINT `creator_batches_ibfk_1` FOREIGN KEY (`borrower_number`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1063 CONSTRAINT `creator_batches_ibfk_2` FOREIGN KEY (`branch_code`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE,
1064 CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE
1065 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1068 -- Table structure for table `creator_images`
1071 DROP TABLE IF EXISTS `creator_images`;
1072 SET @saved_cs_client = @@character_set_client;
1073 SET character_set_client = utf8;
1074 CREATE TABLE `creator_images` (
1075 `image_id` int(4) NOT NULL AUTO_INCREMENT,
1076 `imagefile` mediumblob,
1077 `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1078 PRIMARY KEY (`image_id`),
1079 UNIQUE KEY `image_name_index` (`image_name`)
1080 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1083 -- Table structure for table `creator_layouts`
1086 DROP TABLE IF EXISTS `creator_layouts`;
1087 SET @saved_cs_client = @@character_set_client;
1088 SET character_set_client = utf8;
1089 CREATE TABLE `creator_layouts` (
1090 `layout_id` int(4) NOT NULL AUTO_INCREMENT,
1091 `barcode_type` char(100) NOT NULL DEFAULT 'CODE39',
1092 `start_label` int(2) NOT NULL DEFAULT '1',
1093 `printing_type` char(32) NOT NULL DEFAULT 'BAR',
1094 `layout_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1095 `guidebox` int(1) DEFAULT '0',
1096 `font` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TR',
1097 `font_size` int(4) NOT NULL DEFAULT '10',
1098 `units` char(20) NOT NULL DEFAULT 'POINT',
1099 `callnum_split` int(1) DEFAULT '0',
1100 `text_justify` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'L',
1101 `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
1102 `layout_xml` text NOT NULL,
1103 `creator` char(15) NOT NULL DEFAULT 'Labels',
1104 PRIMARY KEY (`layout_id`)
1105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1108 -- Table structure for table `creator_templates`
1111 DROP TABLE IF EXISTS `creator_templates`;
1112 SET @saved_cs_client = @@character_set_client;
1113 SET character_set_client = utf8;
1114 CREATE TABLE `creator_templates` (
1115 `template_id` int(4) NOT NULL AUTO_INCREMENT,
1116 `profile_id` int(4) DEFAULT NULL,
1117 `template_code` char(100) NOT NULL DEFAULT 'DEFAULT TEMPLATE',
1118 `template_desc` char(100) NOT NULL DEFAULT 'Default description',
1119 `page_width` float NOT NULL DEFAULT '0',
1120 `page_height` float NOT NULL DEFAULT '0',
1121 `label_width` float NOT NULL DEFAULT '0',
1122 `label_height` float NOT NULL DEFAULT '0',
1123 `top_text_margin` float NOT NULL DEFAULT '0',
1124 `left_text_margin` float NOT NULL DEFAULT '0',
1125 `top_margin` float NOT NULL DEFAULT '0',
1126 `left_margin` float NOT NULL DEFAULT '0',
1127 `cols` int(2) NOT NULL DEFAULT '0',
1128 `rows` int(2) NOT NULL DEFAULT '0',
1129 `col_gap` float NOT NULL DEFAULT '0',
1130 `row_gap` float NOT NULL DEFAULT '0',
1131 `units` char(20) NOT NULL DEFAULT 'POINT',
1132 `creator` char(15) NOT NULL DEFAULT 'Labels',
1133 PRIMARY KEY (`template_id`),
1134 KEY `template_profile_fk_constraint` (`profile_id`)
1135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1138 -- Table structure for table `letter`
1141 DROP TABLE IF EXISTS `letter`;
1142 CREATE TABLE `letter` (
1143 `module` varchar(20) NOT NULL default '',
1144 `code` varchar(20) NOT NULL default '',
1145 `name` varchar(100) NOT NULL default '',
1146 `title` varchar(200) NOT NULL default '',
1148 PRIMARY KEY (`module`,`code`)
1149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1152 -- Table structure for table `marc_subfield_structure`
1155 DROP TABLE IF EXISTS `marc_subfield_structure`;
1156 CREATE TABLE `marc_subfield_structure` (
1157 `tagfield` varchar(3) NOT NULL default '',
1158 `tagsubfield` varchar(1) NOT NULL default '' COLLATE utf8_bin,
1159 `liblibrarian` varchar(255) NOT NULL default '',
1160 `libopac` varchar(255) NOT NULL default '',
1161 `repeatable` tinyint(4) NOT NULL default 0,
1162 `mandatory` tinyint(4) NOT NULL default 0,
1163 `kohafield` varchar(40) default NULL,
1164 `tab` tinyint(1) default NULL,
1165 `authorised_value` varchar(20) default NULL,
1166 `authtypecode` varchar(20) default NULL,
1167 `value_builder` varchar(80) default NULL,
1168 `isurl` tinyint(1) default NULL,
1169 `hidden` tinyint(1) default NULL,
1170 `frameworkcode` varchar(4) NOT NULL default '',
1171 `seealso` varchar(1100) default NULL,
1172 `link` varchar(80) default NULL,
1173 `defaultvalue` text default NULL,
1174 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1175 KEY `kohafield_2` (`kohafield`),
1176 KEY `tab` (`frameworkcode`,`tab`),
1177 KEY `kohafield` (`frameworkcode`,`kohafield`)
1178 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1181 -- Table structure for table `marc_tag_structure`
1184 DROP TABLE IF EXISTS `marc_tag_structure`;
1185 CREATE TABLE `marc_tag_structure` (
1186 `tagfield` varchar(3) NOT NULL default '',
1187 `liblibrarian` varchar(255) NOT NULL default '',
1188 `libopac` varchar(255) NOT NULL default '',
1189 `repeatable` tinyint(4) NOT NULL default 0,
1190 `mandatory` tinyint(4) NOT NULL default 0,
1191 `authorised_value` varchar(10) default NULL,
1192 `frameworkcode` varchar(4) NOT NULL default '',
1193 PRIMARY KEY (`frameworkcode`,`tagfield`)
1194 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1197 -- Table structure for table `marc_matchers`
1200 DROP TABLE IF EXISTS `marc_matchers`;
1201 CREATE TABLE `marc_matchers` (
1202 `matcher_id` int(11) NOT NULL auto_increment,
1203 `code` varchar(10) NOT NULL default '',
1204 `description` varchar(255) NOT NULL default '',
1205 `record_type` varchar(10) NOT NULL default 'biblio',
1206 `threshold` int(11) NOT NULL default 0,
1207 PRIMARY KEY (`matcher_id`),
1208 KEY `code` (`code`),
1209 KEY `record_type` (`record_type`)
1210 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1213 -- Table structure for table `matchpoints`
1215 DROP TABLE IF EXISTS `matchpoints`;
1216 CREATE TABLE `matchpoints` (
1217 `matcher_id` int(11) NOT NULL,
1218 `matchpoint_id` int(11) NOT NULL auto_increment,
1219 `search_index` varchar(30) NOT NULL default '',
1220 `score` int(11) NOT NULL default 0,
1221 PRIMARY KEY (`matchpoint_id`),
1222 CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1223 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
1224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1228 -- Table structure for table `matchpoint_components`
1230 DROP TABLE IF EXISTS `matchpoint_components`;
1231 CREATE TABLE `matchpoint_components` (
1232 `matchpoint_id` int(11) NOT NULL,
1233 `matchpoint_component_id` int(11) NOT NULL auto_increment,
1234 sequence int(11) NOT NULL default 0,
1235 tag varchar(3) NOT NULL default '',
1236 subfields varchar(40) NOT NULL default '',
1237 offset int(4) NOT NULL default 0,
1238 length int(4) NOT NULL default 0,
1239 PRIMARY KEY (`matchpoint_component_id`),
1240 KEY `by_sequence` (`matchpoint_id`, `sequence`),
1241 CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
1242 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1243 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1246 -- Table structure for table `matcher_component_norms`
1248 DROP TABLE IF EXISTS `matchpoint_component_norms`;
1249 CREATE TABLE `matchpoint_component_norms` (
1250 `matchpoint_component_id` int(11) NOT NULL,
1251 `sequence` int(11) NOT NULL default 0,
1252 `norm_routine` varchar(50) NOT NULL default '',
1253 KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
1254 CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
1255 REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
1256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1259 -- Table structure for table `matcher_matchpoints`
1261 DROP TABLE IF EXISTS `matcher_matchpoints`;
1262 CREATE TABLE `matcher_matchpoints` (
1263 `matcher_id` int(11) NOT NULL,
1264 `matchpoint_id` int(11) NOT NULL,
1265 CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1266 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1267 CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
1268 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1269 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1272 -- Table structure for table `matchchecks`
1274 DROP TABLE IF EXISTS `matchchecks`;
1275 CREATE TABLE `matchchecks` (
1276 `matcher_id` int(11) NOT NULL,
1277 `matchcheck_id` int(11) NOT NULL auto_increment,
1278 `source_matchpoint_id` int(11) NOT NULL,
1279 `target_matchpoint_id` int(11) NOT NULL,
1280 PRIMARY KEY (`matchcheck_id`),
1281 CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`)
1282 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1283 CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`)
1284 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1285 CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
1286 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1287 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1290 -- Table structure for table `notifys`
1293 DROP TABLE IF EXISTS `notifys`;
1294 CREATE TABLE `notifys` (
1295 `notify_id` int(11) NOT NULL default 0,
1296 `borrowernumber` int(11) NOT NULL default 0,
1297 `itemnumber` int(11) NOT NULL default 0,
1298 `notify_date` date default NULL,
1299 `notify_send_date` date default NULL,
1300 `notify_level` int(1) NOT NULL default 0,
1301 `method` varchar(20) NOT NULL default ''
1302 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1305 -- Table structure for table `nozebra`
1308 DROP TABLE IF EXISTS `nozebra`;
1309 CREATE TABLE `nozebra` (
1310 `server` varchar(20) NOT NULL,
1311 `indexname` varchar(40) NOT NULL,
1312 `value` varchar(250) NOT NULL,
1313 `biblionumbers` longtext NOT NULL,
1314 KEY `indexname` (`server`,`indexname`),
1315 KEY `value` (`server`,`value`))
1316 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1319 -- Table structure for table `old_issues`
1322 DROP TABLE IF EXISTS `old_issues`;
1323 CREATE TABLE `old_issues` (
1324 `borrowernumber` int(11) default NULL,
1325 `itemnumber` int(11) default NULL,
1326 `date_due` date default NULL,
1327 `branchcode` varchar(10) default NULL,
1328 `issuingbranch` varchar(18) default NULL,
1329 `returndate` date default NULL,
1330 `lastreneweddate` date default NULL,
1331 `return` varchar(4) default NULL,
1332 `renewals` tinyint(4) default NULL,
1333 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1334 `issuedate` date default NULL,
1335 KEY `old_issuesborridx` (`borrowernumber`),
1336 KEY `old_issuesitemidx` (`itemnumber`),
1337 KEY `old_bordate` (`borrowernumber`,`timestamp`),
1338 CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1339 ON DELETE SET NULL ON UPDATE SET NULL,
1340 CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1341 ON DELETE SET NULL ON UPDATE SET NULL
1342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1345 -- Table structure for table `old_reserves`
1347 DROP TABLE IF EXISTS `old_reserves`;
1348 CREATE TABLE `old_reserves` (
1349 `borrowernumber` int(11) default NULL,
1350 `reservedate` date default NULL,
1351 `biblionumber` int(11) default NULL,
1352 `constrainttype` varchar(1) default NULL,
1353 `branchcode` varchar(10) default NULL,
1354 `notificationdate` date default NULL,
1355 `reminderdate` date default NULL,
1356 `cancellationdate` date default NULL,
1357 `reservenotes` mediumtext,
1358 `priority` smallint(6) default NULL,
1359 `found` varchar(1) default NULL,
1360 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1361 `itemnumber` int(11) default NULL,
1362 `waitingdate` date default NULL,
1363 `expirationdate` DATE DEFAULT NULL,
1364 `lowestPriority` tinyint(1) NOT NULL,
1365 KEY `old_reserves_borrowernumber` (`borrowernumber`),
1366 KEY `old_reserves_biblionumber` (`biblionumber`),
1367 KEY `old_reserves_itemnumber` (`itemnumber`),
1368 KEY `old_reserves_branchcode` (`branchcode`),
1369 CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1370 ON DELETE SET NULL ON UPDATE SET NULL,
1371 CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`)
1372 ON DELETE SET NULL ON UPDATE SET NULL,
1373 CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1374 ON DELETE SET NULL ON UPDATE SET NULL
1375 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1378 -- Table structure for table `opac_news`
1381 DROP TABLE IF EXISTS `opac_news`;
1382 CREATE TABLE `opac_news` (
1383 `idnew` int(10) unsigned NOT NULL auto_increment,
1384 `title` varchar(250) NOT NULL default '',
1385 `new` text NOT NULL,
1386 `lang` varchar(25) NOT NULL default '',
1387 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1388 `expirationdate` date default NULL,
1389 `number` int(11) default NULL,
1390 PRIMARY KEY (`idnew`)
1391 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1394 -- Table structure for table `overduerules`
1397 DROP TABLE IF EXISTS `overduerules`;
1398 CREATE TABLE `overduerules` (
1399 `branchcode` varchar(10) NOT NULL default '',
1400 `categorycode` varchar(10) NOT NULL default '',
1401 `delay1` int(4) default 0,
1402 `letter1` varchar(20) default NULL,
1403 `debarred1` varchar(1) default 0,
1404 `delay2` int(4) default 0,
1405 `debarred2` varchar(1) default 0,
1406 `letter2` varchar(20) default NULL,
1407 `delay3` int(4) default 0,
1408 `letter3` varchar(20) default NULL,
1409 `debarred3` int(1) default 0,
1410 PRIMARY KEY (`branchcode`,`categorycode`)
1411 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1414 -- Table structure for table `patroncards`
1417 DROP TABLE IF EXISTS `patroncards`;
1418 CREATE TABLE `patroncards` (
1419 `cardid` int(11) NOT NULL auto_increment,
1420 `batch_id` varchar(10) NOT NULL default '1',
1421 `borrowernumber` int(11) NOT NULL,
1422 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1423 PRIMARY KEY (`cardid`),
1424 KEY `patroncards_ibfk_1` (`borrowernumber`),
1425 CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1426 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1429 -- Table structure for table `patronimage`
1432 DROP TABLE IF EXISTS `patronimage`;
1433 CREATE TABLE `patronimage` (
1434 `cardnumber` varchar(16) NOT NULL,
1435 `mimetype` varchar(15) NOT NULL,
1436 `imagefile` mediumblob NOT NULL,
1437 PRIMARY KEY (`cardnumber`),
1438 CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1439 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1442 -- Table structure for table `printers`
1445 DROP TABLE IF EXISTS `printers`;
1446 CREATE TABLE `printers` (
1447 `printername` varchar(40) NOT NULL default '',
1448 `printqueue` varchar(20) default NULL,
1449 `printtype` varchar(20) default NULL,
1450 PRIMARY KEY (`printername`)
1451 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1454 -- Table structure for table `printers_profile`
1457 DROP TABLE IF EXISTS `printers_profile`;
1458 CREATE TABLE `printers_profile` (
1459 `profile_id` int(4) NOT NULL auto_increment,
1460 `printer_name` varchar(40) NOT NULL default 'Default Printer',
1461 `template_id` int(4) NOT NULL default '0',
1462 `paper_bin` varchar(20) NOT NULL default 'Bypass',
1463 `offset_horz` float NOT NULL default '0',
1464 `offset_vert` float NOT NULL default '0',
1465 `creep_horz` float NOT NULL default '0',
1466 `creep_vert` float NOT NULL default '0',
1467 `units` char(20) NOT NULL default 'POINT',
1468 `creator` char(15) NOT NULL DEFAULT 'Labels',
1469 PRIMARY KEY (`profile_id`),
1470 UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
1471 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1474 -- Table structure for table `repeatable_holidays`
1477 DROP TABLE IF EXISTS `repeatable_holidays`;
1478 CREATE TABLE `repeatable_holidays` (
1479 `id` int(11) NOT NULL auto_increment,
1480 `branchcode` varchar(10) NOT NULL default '',
1481 `weekday` smallint(6) default NULL,
1482 `day` smallint(6) default NULL,
1483 `month` smallint(6) default NULL,
1484 `title` varchar(50) NOT NULL default '',
1485 `description` text NOT NULL,
1487 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1490 -- Table structure for table `reports_dictionary`
1493 DROP TABLE IF EXISTS `reports_dictionary`;
1494 CREATE TABLE reports_dictionary (
1495 `id` int(11) NOT NULL auto_increment,
1496 `name` varchar(255) default NULL,
1498 `date_created` datetime default NULL,
1499 `date_modified` datetime default NULL,
1501 `area` int(11) default NULL,
1503 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1506 -- Table structure for table `reserveconstraints`
1509 DROP TABLE IF EXISTS `reserveconstraints`;
1510 CREATE TABLE `reserveconstraints` (
1511 `borrowernumber` int(11) NOT NULL default 0,
1512 `reservedate` date default NULL,
1513 `biblionumber` int(11) NOT NULL default 0,
1514 `biblioitemnumber` int(11) default NULL,
1515 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1516 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1519 -- Table structure for table `reserves`
1522 DROP TABLE IF EXISTS `reserves`;
1523 CREATE TABLE `reserves` (
1524 `borrowernumber` int(11) NOT NULL default 0,
1525 `reservedate` date default NULL,
1526 `biblionumber` int(11) NOT NULL default 0,
1527 `constrainttype` varchar(1) default NULL,
1528 `branchcode` varchar(10) default NULL,
1529 `notificationdate` date default NULL,
1530 `reminderdate` date default NULL,
1531 `cancellationdate` date default NULL,
1532 `reservenotes` mediumtext,
1533 `priority` smallint(6) default NULL,
1534 `found` varchar(1) default NULL,
1535 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1536 `itemnumber` int(11) default NULL,
1537 `waitingdate` date default NULL,
1538 `expirationdate` DATE DEFAULT NULL,
1539 `lowestPriority` tinyint(1) NOT NULL,
1540 KEY `borrowernumber` (`borrowernumber`),
1541 KEY `biblionumber` (`biblionumber`),
1542 KEY `itemnumber` (`itemnumber`),
1543 KEY `branchcode` (`branchcode`),
1544 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1545 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1546 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1547 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1548 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1551 -- Table structure for table `reviews`
1554 DROP TABLE IF EXISTS `reviews`;
1555 CREATE TABLE `reviews` (
1556 `reviewid` int(11) NOT NULL auto_increment,
1557 `borrowernumber` int(11) default NULL,
1558 `biblionumber` int(11) default NULL,
1560 `approved` tinyint(4) default NULL,
1561 `datereviewed` datetime default NULL,
1562 PRIMARY KEY (`reviewid`)
1563 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1566 -- Table structure for table `roadtype`
1569 DROP TABLE IF EXISTS `roadtype`;
1570 CREATE TABLE `roadtype` (
1571 `roadtypeid` int(11) NOT NULL auto_increment,
1572 `road_type` varchar(100) NOT NULL default '',
1573 PRIMARY KEY (`roadtypeid`)
1574 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1577 -- Table structure for table `saved_sql`
1580 DROP TABLE IF EXISTS `saved_sql`;
1581 CREATE TABLE saved_sql (
1582 `id` int(11) NOT NULL auto_increment,
1583 `borrowernumber` int(11) default NULL,
1584 `date_created` datetime default NULL,
1585 `last_modified` datetime default NULL,
1587 `last_run` datetime default NULL,
1588 `report_name` varchar(255) default NULL,
1589 `type` varchar(255) default NULL,
1592 KEY boridx (`borrowernumber`)
1593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1597 -- Table structure for `saved_reports`
1600 DROP TABLE IF EXISTS `saved_reports`;
1601 CREATE TABLE saved_reports (
1602 `id` int(11) NOT NULL auto_increment,
1603 `report_id` int(11) default NULL,
1605 `date_run` datetime default NULL,
1607 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1611 -- Table structure for table `search_history`
1614 DROP TABLE IF EXISTS `search_history`;
1615 CREATE TABLE IF NOT EXISTS `search_history` (
1616 `userid` int(11) NOT NULL,
1617 `sessionid` varchar(32) NOT NULL,
1618 `query_desc` varchar(255) NOT NULL,
1619 `query_cgi` varchar(255) NOT NULL,
1620 `total` int(11) NOT NULL,
1621 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1622 KEY `userid` (`userid`),
1623 KEY `sessionid` (`sessionid`)
1624 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results';
1628 -- Table structure for table `serial`
1631 DROP TABLE IF EXISTS `serial`;
1632 CREATE TABLE `serial` (
1633 `serialid` int(11) NOT NULL auto_increment,
1634 `biblionumber` varchar(100) NOT NULL default '',
1635 `subscriptionid` varchar(100) NOT NULL default '',
1636 `serialseq` varchar(100) NOT NULL default '',
1637 `status` tinyint(4) NOT NULL default 0,
1638 `planneddate` date default NULL,
1640 `publisheddate` date default NULL,
1641 `itemnumber` text default NULL,
1642 `claimdate` date default NULL,
1643 `routingnotes` text,
1644 PRIMARY KEY (`serialid`)
1645 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1648 -- Table structure for table `sessions`
1651 DROP TABLE IF EXISTS sessions;
1652 CREATE TABLE sessions (
1653 `id` varchar(32) NOT NULL,
1654 `a_session` text NOT NULL,
1656 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1659 -- Table structure for table `special_holidays`
1662 DROP TABLE IF EXISTS `special_holidays`;
1663 CREATE TABLE `special_holidays` (
1664 `id` int(11) NOT NULL auto_increment,
1665 `branchcode` varchar(10) NOT NULL default '',
1666 `day` smallint(6) NOT NULL default 0,
1667 `month` smallint(6) NOT NULL default 0,
1668 `year` smallint(6) NOT NULL default 0,
1669 `isexception` smallint(1) NOT NULL default 1,
1670 `title` varchar(50) NOT NULL default '',
1671 `description` text NOT NULL,
1673 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1676 -- Table structure for table `statistics`
1679 DROP TABLE IF EXISTS `statistics`;
1680 CREATE TABLE `statistics` (
1681 `datetime` datetime default NULL,
1682 `branch` varchar(10) default NULL,
1683 `proccode` varchar(4) default NULL,
1684 `value` double(16,4) default NULL,
1685 `type` varchar(16) default NULL,
1687 `usercode` varchar(10) default NULL,
1688 `itemnumber` int(11) default NULL,
1689 `itemtype` varchar(10) default NULL,
1690 `borrowernumber` int(11) default NULL,
1691 `associatedborrower` int(11) default NULL,
1692 KEY `timeidx` (`datetime`)
1693 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1696 -- Table structure for table `stopwords`
1699 DROP TABLE IF EXISTS `stopwords`;
1700 CREATE TABLE `stopwords` (
1701 `word` varchar(255) default NULL
1702 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1705 -- Table structure for table `subscription`
1708 DROP TABLE IF EXISTS `subscription`;
1709 CREATE TABLE `subscription` (
1710 `biblionumber` int(11) NOT NULL default 0,
1711 `subscriptionid` int(11) NOT NULL auto_increment,
1712 `librarian` varchar(100) default '',
1713 `startdate` date default NULL,
1714 `aqbooksellerid` int(11) default 0,
1715 `cost` int(11) default 0,
1716 `aqbudgetid` int(11) default 0,
1717 `weeklength` int(11) default 0,
1718 `monthlength` int(11) default 0,
1719 `numberlength` int(11) default 0,
1720 `periodicity` tinyint(4) default 0,
1721 `dow` varchar(100) default '',
1722 `numberingmethod` varchar(100) default '',
1724 `status` varchar(100) NOT NULL default '',
1725 `add1` int(11) default 0,
1726 `every1` int(11) default 0,
1727 `whenmorethan1` int(11) default 0,
1728 `setto1` int(11) default NULL,
1729 `lastvalue1` int(11) default NULL,
1730 `add2` int(11) default 0,
1731 `every2` int(11) default 0,
1732 `whenmorethan2` int(11) default 0,
1733 `setto2` int(11) default NULL,
1734 `lastvalue2` int(11) default NULL,
1735 `add3` int(11) default 0,
1736 `every3` int(11) default 0,
1737 `innerloop1` int(11) default 0,
1738 `innerloop2` int(11) default 0,
1739 `innerloop3` int(11) default 0,
1740 `whenmorethan3` int(11) default 0,
1741 `setto3` int(11) default NULL,
1742 `lastvalue3` int(11) default NULL,
1743 `issuesatonce` tinyint(3) NOT NULL default 1,
1744 `firstacquidate` date default NULL,
1745 `manualhistory` tinyint(1) NOT NULL default 0,
1746 `irregularity` text,
1747 `letter` varchar(20) default NULL,
1748 `numberpattern` tinyint(3) default 0,
1749 `distributedto` text,
1750 `internalnotes` longtext,
1752 `location` varchar(80) NULL default '',
1753 `branchcode` varchar(10) NOT NULL default '',
1754 `hemisphere` tinyint(3) default 0,
1755 `lastbranch` varchar(10),
1756 `serialsadditems` tinyint(1) NOT NULL default '0',
1757 `staffdisplaycount` VARCHAR(10) NULL,
1758 `opacdisplaycount` VARCHAR(10) NULL,
1759 `graceperiod` int(11) NOT NULL default '0',
1760 `enddate` date default NULL,
1761 PRIMARY KEY (`subscriptionid`)
1762 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1765 -- Table structure for table `subscriptionhistory`
1768 DROP TABLE IF EXISTS `subscriptionhistory`;
1769 CREATE TABLE `subscriptionhistory` (
1770 `biblionumber` int(11) NOT NULL default 0,
1771 `subscriptionid` int(11) NOT NULL default 0,
1772 `histstartdate` date default NULL,
1773 `histenddate` date default NULL,
1774 `missinglist` longtext NOT NULL,
1775 `recievedlist` longtext NOT NULL,
1776 `opacnote` varchar(150) NOT NULL default '',
1777 `librariannote` varchar(150) NOT NULL default '',
1778 PRIMARY KEY (`subscriptionid`),
1779 KEY `biblionumber` (`biblionumber`)
1780 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1783 -- Table structure for table `subscriptionroutinglist`
1786 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1787 CREATE TABLE `subscriptionroutinglist` (
1788 `routingid` int(11) NOT NULL auto_increment,
1789 `borrowernumber` int(11) default NULL,
1790 `ranking` int(11) default NULL,
1791 `subscriptionid` int(11) default NULL,
1792 PRIMARY KEY (`routingid`)
1793 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1796 -- Table structure for table `suggestions`
1799 DROP TABLE IF EXISTS `suggestions`;
1800 CREATE TABLE `suggestions` (
1801 `suggestionid` int(8) NOT NULL auto_increment,
1802 `suggestedby` int(11) NOT NULL default 0,
1803 `suggesteddate` date NOT NULL default 0,
1804 `managedby` int(11) default NULL,
1805 `manageddate` date default NULL,
1806 acceptedby INT(11) default NULL,
1807 accepteddate date default NULL,
1808 rejectedby INT(11) default NULL,
1809 rejecteddate date default NULL,
1810 `STATUS` varchar(10) NOT NULL default '',
1812 `author` varchar(80) default NULL,
1813 `title` varchar(80) default NULL,
1814 `copyrightdate` smallint(6) default NULL,
1815 `publishercode` varchar(255) default NULL,
1816 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1817 `volumedesc` varchar(255) default NULL,
1818 `publicationyear` smallint(6) default 0,
1819 `place` varchar(255) default NULL,
1820 `isbn` varchar(30) default NULL,
1821 `mailoverseeing` smallint(1) default 0,
1822 `biblionumber` int(11) default NULL,
1825 branchcode VARCHAR(10) default NULL,
1826 collectiontitle text default NULL,
1827 itemtype VARCHAR(30) default NULL,
1828 PRIMARY KEY (`suggestionid`),
1829 KEY `suggestedby` (`suggestedby`),
1830 KEY `managedby` (`managedby`)
1831 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1834 -- Table structure for table `systempreferences`
1837 DROP TABLE IF EXISTS `systempreferences`;
1838 CREATE TABLE `systempreferences` (
1839 `variable` varchar(50) NOT NULL default '',
1841 `options` mediumtext,
1843 `type` varchar(20) default NULL,
1844 PRIMARY KEY (`variable`)
1845 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1848 -- Table structure for table `tags`
1851 DROP TABLE IF EXISTS `tags`;
1852 CREATE TABLE `tags` (
1853 `entry` varchar(255) NOT NULL default '',
1854 `weight` bigint(20) NOT NULL default 0,
1855 PRIMARY KEY (`entry`)
1856 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1859 -- Table structure for table `tags_all`
1862 DROP TABLE IF EXISTS `tags_all`;
1863 CREATE TABLE `tags_all` (
1864 `tag_id` int(11) NOT NULL auto_increment,
1865 `borrowernumber` int(11) NOT NULL,
1866 `biblionumber` int(11) NOT NULL,
1867 `term` varchar(255) NOT NULL,
1868 `language` int(4) default NULL,
1869 `date_created` datetime NOT NULL,
1870 PRIMARY KEY (`tag_id`),
1871 KEY `tags_borrowers_fk_1` (`borrowernumber`),
1872 KEY `tags_biblionumber_fk_1` (`biblionumber`),
1873 CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`)
1874 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1875 CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1876 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1877 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1880 -- Table structure for table `tags_approval`
1883 DROP TABLE IF EXISTS `tags_approval`;
1884 CREATE TABLE `tags_approval` (
1885 `term` varchar(255) NOT NULL,
1886 `approved` int(1) NOT NULL default '0',
1887 `date_approved` datetime default NULL,
1888 `approved_by` int(11) default NULL,
1889 `weight_total` int(9) NOT NULL default '1',
1890 PRIMARY KEY (`term`),
1891 KEY `tags_approval_borrowers_fk_1` (`approved_by`),
1892 CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`)
1893 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1894 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1897 -- Table structure for table `tags_index`
1900 DROP TABLE IF EXISTS `tags_index`;
1901 CREATE TABLE `tags_index` (
1902 `term` varchar(255) NOT NULL,
1903 `biblionumber` int(11) NOT NULL,
1904 `weight` int(9) NOT NULL default '1',
1905 PRIMARY KEY (`term`,`biblionumber`),
1906 KEY `tags_index_biblionumber_fk_1` (`biblionumber`),
1907 CONSTRAINT `tags_index_term_fk_1` FOREIGN KEY (`term`)
1908 REFERENCES `tags_approval` (`term`) ON DELETE CASCADE ON UPDATE CASCADE,
1909 CONSTRAINT `tags_index_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1910 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1911 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1914 -- Table structure for table `userflags`
1917 DROP TABLE IF EXISTS `userflags`;
1918 CREATE TABLE `userflags` (
1919 `bit` int(11) NOT NULL default 0,
1920 `flag` varchar(30) default NULL,
1921 `flagdesc` varchar(255) default NULL,
1922 `defaulton` int(11) default NULL,
1924 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1927 -- Table structure for table `virtualshelves`
1930 DROP TABLE IF EXISTS `virtualshelves`;
1931 CREATE TABLE `virtualshelves` (
1932 `shelfnumber` int(11) NOT NULL auto_increment,
1933 `shelfname` varchar(255) default NULL,
1934 `owner` varchar(80) default NULL,
1935 `category` varchar(1) default NULL,
1936 `sortfield` varchar(16) default NULL,
1937 `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1938 PRIMARY KEY (`shelfnumber`)
1939 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1942 -- Table structure for table `virtualshelfcontents`
1945 DROP TABLE IF EXISTS `virtualshelfcontents`;
1946 CREATE TABLE `virtualshelfcontents` (
1947 `shelfnumber` int(11) NOT NULL default 0,
1948 `biblionumber` int(11) NOT NULL default 0,
1949 `flags` int(11) default NULL,
1950 `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1951 KEY `shelfnumber` (`shelfnumber`),
1952 KEY `biblionumber` (`biblionumber`),
1953 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1954 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1955 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1958 -- Table structure for table `z3950servers`
1961 DROP TABLE IF EXISTS `z3950servers`;
1962 CREATE TABLE `z3950servers` (
1963 `host` varchar(255) default NULL,
1964 `port` int(11) default NULL,
1965 `db` varchar(255) default NULL,
1966 `userid` varchar(255) default NULL,
1967 `password` varchar(255) default NULL,
1969 `id` int(11) NOT NULL auto_increment,
1970 `checked` smallint(6) default NULL,
1971 `rank` int(11) default NULL,
1972 `syntax` varchar(80) default NULL,
1974 `position` enum('primary','secondary','') NOT NULL default 'primary',
1975 `type` enum('zed','opensearch') NOT NULL default 'zed',
1976 `encoding` text default NULL,
1977 `description` text NOT NULL,
1979 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1982 -- Table structure for table `zebraqueue`
1985 DROP TABLE IF EXISTS `zebraqueue`;
1986 CREATE TABLE `zebraqueue` (
1987 `id` int(11) NOT NULL auto_increment,
1988 `biblio_auth_number` bigint(20) unsigned NOT NULL default '0',
1989 `operation` char(20) NOT NULL default '',
1990 `server` char(20) NOT NULL default '',
1991 `done` int(11) NOT NULL default '0',
1992 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1994 KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
1995 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1997 DROP TABLE IF EXISTS `services_throttle`;
1998 CREATE TABLE `services_throttle` (
1999 `service_type` varchar(10) NOT NULL default '',
2000 `service_count` varchar(45) default NULL,
2001 PRIMARY KEY (`service_type`)
2002 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2004 -- http://www.w3.org/International/articles/language-tags/
2007 DROP TABLE IF EXISTS language_subtag_registry;
2008 CREATE TABLE language_subtag_registry (
2010 type varchar(25), -- language-script-region-variant-extension-privateuse
2011 description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
2013 id int(11) NOT NULL auto_increment,
2015 KEY `subtag` (`subtag`)
2016 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018 -- TODO: add suppress_scripts
2019 -- this maps three letter codes defined in iso639.2 back to their
2020 -- two letter equivilents in rfc4646 (LOC maintains iso639+)
2021 DROP TABLE IF EXISTS language_rfc4646_to_iso639;
2022 CREATE TABLE language_rfc4646_to_iso639 (
2023 rfc4646_subtag varchar(25),
2024 iso639_2_code varchar(25),
2025 id int(11) NOT NULL auto_increment,
2027 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2028 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2030 DROP TABLE IF EXISTS language_descriptions;
2031 CREATE TABLE language_descriptions (
2035 description varchar(255),
2036 id int(11) NOT NULL auto_increment,
2038 KEY `lang` (`lang`),
2039 KEY `subtag_type_lang` (`subtag`, `type`, `lang`)
2040 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2042 -- bi-directional support, keyed by script subcode
2043 DROP TABLE IF EXISTS language_script_bidi;
2044 CREATE TABLE language_script_bidi (
2045 rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
2046 bidi varchar(3), -- rtl ltr
2047 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2048 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2050 -- TODO: need to map language subtags to script subtags for detection
2051 -- of bidi when script is not specified (like ar, he)
2052 DROP TABLE IF EXISTS language_script_mapping;
2053 CREATE TABLE language_script_mapping (
2054 language_subtag varchar(25),
2055 script_subtag varchar(25),
2056 KEY `language_subtag` (`language_subtag`)
2057 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2059 DROP TABLE IF EXISTS `permissions`;
2060 CREATE TABLE `permissions` (
2061 `module_bit` int(11) NOT NULL DEFAULT 0,
2062 `code` varchar(64) DEFAULT NULL,
2063 `description` varchar(255) DEFAULT NULL,
2064 PRIMARY KEY (`module_bit`, `code`),
2065 CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`)
2066 ON DELETE CASCADE ON UPDATE CASCADE
2067 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2069 DROP TABLE IF EXISTS `serialitems`;
2070 CREATE TABLE `serialitems` (
2071 `itemnumber` int(11) NOT NULL,
2072 `serialid` int(11) NOT NULL,
2073 UNIQUE KEY `serialitemsidx` (`itemnumber`),
2074 KEY `serialitems_sfk_1` (`serialid`),
2075 CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE
2076 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2078 DROP TABLE IF EXISTS `user_permissions`;
2079 CREATE TABLE `user_permissions` (
2080 `borrowernumber` int(11) NOT NULL DEFAULT 0,
2081 `module_bit` int(11) NOT NULL DEFAULT 0,
2082 `code` varchar(64) DEFAULT NULL,
2083 CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
2084 ON DELETE CASCADE ON UPDATE CASCADE,
2085 CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`)
2086 ON DELETE CASCADE ON UPDATE CASCADE
2087 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2090 -- Table structure for table `tmp_holdsqueue`
2093 DROP TABLE IF EXISTS `tmp_holdsqueue`;
2094 CREATE TABLE `tmp_holdsqueue` (
2095 `biblionumber` int(11) default NULL,
2096 `itemnumber` int(11) default NULL,
2097 `barcode` varchar(20) default NULL,
2098 `surname` mediumtext NOT NULL,
2101 `borrowernumber` int(11) NOT NULL,
2102 `cardnumber` varchar(16) default NULL,
2103 `reservedate` date default NULL,
2105 `itemcallnumber` varchar(255) default NULL,
2106 `holdingbranch` varchar(10) default NULL,
2107 `pickbranch` varchar(10) default NULL,
2109 `item_level_request` tinyint(4) NOT NULL default 0
2110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2113 -- Table structure for table `message_queue`
2116 DROP TABLE IF EXISTS `message_queue`;
2117 CREATE TABLE `message_queue` (
2118 `message_id` int(11) NOT NULL auto_increment,
2119 `borrowernumber` int(11) default NULL,
2122 `metadata` text DEFAULT NULL,
2123 `letter_code` varchar(64) DEFAULT NULL,
2124 `message_transport_type` varchar(20) NOT NULL,
2125 `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2126 `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2127 `to_address` mediumtext,
2128 `from_address` mediumtext,
2129 `content_type` text,
2130 KEY `message_id` (`message_id`),
2131 KEY `borrowernumber` (`borrowernumber`),
2132 KEY `message_transport_type` (`message_transport_type`),
2133 CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2134 CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE RESTRICT ON UPDATE CASCADE
2135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2138 -- Table structure for table `message_transport_types`
2141 DROP TABLE IF EXISTS `message_transport_types`;
2142 CREATE TABLE `message_transport_types` (
2143 `message_transport_type` varchar(20) NOT NULL,
2144 PRIMARY KEY (`message_transport_type`)
2145 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2148 -- Table structure for table `message_attributes`
2151 DROP TABLE IF EXISTS `message_attributes`;
2152 CREATE TABLE `message_attributes` (
2153 `message_attribute_id` int(11) NOT NULL auto_increment,
2154 `message_name` varchar(20) NOT NULL default '',
2155 `takes_days` tinyint(1) NOT NULL default '0',
2156 PRIMARY KEY (`message_attribute_id`),
2157 UNIQUE KEY `message_name` (`message_name`)
2158 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2161 -- Table structure for table `message_transports`
2164 DROP TABLE IF EXISTS `message_transports`;
2165 CREATE TABLE `message_transports` (
2166 `message_attribute_id` int(11) NOT NULL,
2167 `message_transport_type` varchar(20) NOT NULL,
2168 `is_digest` tinyint(1) NOT NULL default '0',
2169 `letter_module` varchar(20) NOT NULL default '',
2170 `letter_code` varchar(20) NOT NULL default '',
2171 PRIMARY KEY (`message_attribute_id`,`message_transport_type`,`is_digest`),
2172 KEY `message_transport_type` (`message_transport_type`),
2173 KEY `letter_module` (`letter_module`,`letter_code`),
2174 CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2175 CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
2176 CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`) REFERENCES `letter` (`module`, `code`) ON DELETE CASCADE ON UPDATE CASCADE
2177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2180 -- Table structure for table `borrower_message_preferences`
2183 DROP TABLE IF EXISTS `borrower_message_preferences`;
2184 CREATE TABLE `borrower_message_preferences` (
2185 `borrower_message_preference_id` int(11) NOT NULL auto_increment,
2186 `borrowernumber` int(11) default NULL,
2187 `categorycode` varchar(10) default NULL,
2188 `message_attribute_id` int(11) default '0',
2189 `days_in_advance` int(11) default '0',
2190 `wants_digest` tinyint(1) NOT NULL default '0',
2191 PRIMARY KEY (`borrower_message_preference_id`),
2192 KEY `borrowernumber` (`borrowernumber`),
2193 KEY `categorycode` (`categorycode`),
2194 KEY `message_attribute_id` (`message_attribute_id`),
2195 CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2196 CONSTRAINT `borrower_message_preferences_ibfk_2` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2197 CONSTRAINT `borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
2198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2201 -- Table structure for table `borrower_message_transport_preferences`
2204 DROP TABLE IF EXISTS `borrower_message_transport_preferences`;
2205 CREATE TABLE `borrower_message_transport_preferences` (
2206 `borrower_message_preference_id` int(11) NOT NULL default '0',
2207 `message_transport_type` varchar(20) NOT NULL default '0',
2208 PRIMARY KEY (`borrower_message_preference_id`,`message_transport_type`),
2209 KEY `message_transport_type` (`message_transport_type`),
2210 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,
2211 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
2212 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2215 -- Table structure for the table branch_transfer_limits
2218 DROP TABLE IF EXISTS `branch_transfer_limits`;
2219 CREATE TABLE branch_transfer_limits (
2220 limitId int(8) NOT NULL auto_increment,
2221 toBranch varchar(10) NOT NULL,
2222 fromBranch varchar(10) NOT NULL,
2223 itemtype varchar(10) NULL,
2224 ccode varchar(10) NULL,
2225 PRIMARY KEY (limitId)
2226 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2229 -- Table structure for table `item_circulation_alert_preferences`
2232 DROP TABLE IF EXISTS `item_circulation_alert_preferences`;
2233 CREATE TABLE `item_circulation_alert_preferences` (
2234 `id` int(11) NOT NULL auto_increment,
2235 `branchcode` varchar(10) NOT NULL,
2236 `categorycode` varchar(10) NOT NULL,
2237 `item_type` varchar(10) NOT NULL,
2238 `notification` varchar(16) NOT NULL,
2240 KEY `branchcode` (`branchcode`,`categorycode`,`item_type`, `notification`)
2241 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2244 -- Table structure for table `messages`
2246 DROP TABLE IF EXISTS `messages`;
2247 CREATE TABLE `messages` (
2248 `message_id` int(11) NOT NULL auto_increment,
2249 `borrowernumber` int(11) NOT NULL,
2250 `branchcode` varchar(10) default NULL,
2251 `message_type` varchar(1) NOT NULL,
2252 `message` text NOT NULL,
2253 `message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
2254 PRIMARY KEY (`message_id`)
2255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2258 -- Table structure for table `accountlines`
2261 DROP TABLE IF EXISTS `accountlines`;
2262 CREATE TABLE `accountlines` (
2263 `borrowernumber` int(11) NOT NULL default 0,
2264 `accountno` smallint(6) NOT NULL default 0,
2265 `itemnumber` int(11) default NULL,
2266 `date` date default NULL,
2267 `amount` decimal(28,6) default NULL,
2268 `description` mediumtext,
2269 `dispute` mediumtext,
2270 `accounttype` varchar(5) default NULL,
2271 `amountoutstanding` decimal(28,6) default NULL,
2272 `lastincrement` decimal(28,6) default NULL,
2273 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2274 `notify_id` int(11) NOT NULL default 0,
2275 `notify_level` int(2) NOT NULL default 0,
2276 KEY `acctsborridx` (`borrowernumber`),
2277 KEY `timeidx` (`timestamp`),
2278 KEY `itemnumber` (`itemnumber`),
2279 CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2280 CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2284 -- Table structure for table `accountoffsets`
2287 DROP TABLE IF EXISTS `accountoffsets`;
2288 CREATE TABLE `accountoffsets` (
2289 `borrowernumber` int(11) NOT NULL default 0,
2290 `accountno` smallint(6) NOT NULL default 0,
2291 `offsetaccount` smallint(6) NOT NULL default 0,
2292 `offsetamount` decimal(28,6) default NULL,
2293 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2294 CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2298 -- Table structure for table `action_logs`
2301 DROP TABLE IF EXISTS `action_logs`;
2302 CREATE TABLE `action_logs` (
2303 `action_id` int(11) NOT NULL auto_increment,
2304 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2305 `user` int(11) NOT NULL default 0,
2308 `object` int(11) default NULL,
2310 PRIMARY KEY (`action_id`),
2311 KEY (`timestamp`,`user`)
2312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2315 -- Table structure for table `alert`
2318 DROP TABLE IF EXISTS `alert`;
2319 CREATE TABLE `alert` (
2320 `alertid` int(11) NOT NULL auto_increment,
2321 `borrowernumber` int(11) NOT NULL default 0,
2322 `type` varchar(10) NOT NULL default '',
2323 `externalid` varchar(20) NOT NULL default '',
2324 PRIMARY KEY (`alertid`),
2325 KEY `borrowernumber` (`borrowernumber`),
2326 KEY `type` (`type`,`externalid`)
2327 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2330 -- Table structure for table `aqbasketgroups`
2333 DROP TABLE IF EXISTS `aqbasketgroups`;
2334 CREATE TABLE `aqbasketgroups` (
2335 `id` int(11) NOT NULL auto_increment,
2336 `name` varchar(50) default NULL,
2337 `closed` tinyint(1) default NULL,
2338 `booksellerid` int(11) NOT NULL,
2340 KEY `booksellerid` (`booksellerid`),
2341 CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
2342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2345 -- Table structure for table `aqbasket`
2348 DROP TABLE IF EXISTS `aqbasket`;
2349 CREATE TABLE `aqbasket` (
2350 `basketno` int(11) NOT NULL auto_increment,
2351 `basketname` varchar(50) default NULL,
2353 `booksellernote` mediumtext,
2354 `contractnumber` int(11),
2355 `creationdate` date default NULL,
2356 `closedate` date default NULL,
2357 `booksellerid` int(11) NOT NULL default 1,
2358 `authorisedby` varchar(10) default NULL,
2359 `booksellerinvoicenumber` mediumtext,
2360 `basketgroupid` int(11),
2361 PRIMARY KEY (`basketno`),
2362 KEY `booksellerid` (`booksellerid`),
2363 KEY `basketgroupid` (`basketgroupid`),
2364 KEY `contractnumber` (`contractnumber`),
2365 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2366 CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2367 CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE
2368 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2371 -- Table structure for table `aqbooksellers`
2374 DROP TABLE IF EXISTS `aqbooksellers`;
2375 CREATE TABLE `aqbooksellers` (
2376 `id` int(11) NOT NULL auto_increment,
2377 `name` mediumtext NOT NULL,
2378 `address1` mediumtext,
2379 `address2` mediumtext,
2380 `address3` mediumtext,
2381 `address4` mediumtext,
2382 `phone` varchar(30) default NULL,
2383 `accountnumber` mediumtext,
2384 `othersupplier` mediumtext,
2385 `currency` varchar(3) NOT NULL default '',
2386 `booksellerfax` mediumtext,
2388 `bookselleremail` mediumtext,
2389 `booksellerurl` mediumtext,
2390 `contact` varchar(100) default NULL,
2391 `postal` mediumtext,
2392 `url` varchar(255) default NULL,
2393 `contpos` varchar(100) default NULL,
2394 `contphone` varchar(100) default NULL,
2395 `contfax` varchar(100) default NULL,
2396 `contaltphone` varchar(100) default NULL,
2397 `contemail` varchar(100) default NULL,
2398 `contnotes` mediumtext,
2399 `active` tinyint(4) default NULL,
2400 `listprice` varchar(10) default NULL,
2401 `invoiceprice` varchar(10) default NULL,
2402 `gstreg` tinyint(4) default NULL,
2403 `listincgst` tinyint(4) default NULL,
2404 `invoiceincgst` tinyint(4) default NULL,
2405 `gstrate` decimal(6,4) default NULL,
2406 `discount` float(6,4) default NULL,
2407 `fax` varchar(50) default NULL,
2409 KEY `listprice` (`listprice`),
2410 KEY `invoiceprice` (`invoiceprice`),
2411 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2412 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2413 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2416 -- Table structure for table `aqbudgets`
2419 DROP TABLE IF EXISTS `aqbudgets`;
2420 CREATE TABLE `aqbudgets` (
2421 `budget_id` int(11) NOT NULL auto_increment,
2422 `budget_parent_id` int(11) default NULL,
2423 `budget_code` varchar(30) default NULL,
2424 `budget_name` varchar(80) default NULL,
2425 `budget_branchcode` varchar(10) default NULL,
2426 `budget_amount` decimal(28,6) NULL default '0.00',
2427 `budget_encumb` decimal(28,6) NULL default '0.00',
2428 `budget_expend` decimal(28,6) NULL default '0.00',
2429 `budget_notes` mediumtext,
2430 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2431 `budget_period_id` int(11) default NULL,
2432 `sort1_authcat` varchar(80) default NULL,
2433 `sort2_authcat` varchar(80) default NULL,
2434 `budget_owner_id` int(11) default NULL,
2435 `budget_permission` int(1) default '0',
2436 PRIMARY KEY (`budget_id`)
2437 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2441 -- Table structure for table `aqbudgetperiods`
2445 DROP TABLE IF EXISTS `aqbudgetperiods`;
2446 CREATE TABLE `aqbudgetperiods` (
2447 `budget_period_id` int(11) NOT NULL auto_increment,
2448 `budget_period_startdate` date NOT NULL,
2449 `budget_period_enddate` date NOT NULL,
2450 `budget_period_active` tinyint(1) default '0',
2451 `budget_period_description` mediumtext,
2452 `budget_period_total` decimal(28,6),
2453 `budget_period_locked` tinyint(1) default NULL,
2454 `sort1_authcat` varchar(10) default NULL,
2455 `sort2_authcat` varchar(10) default NULL,
2456 PRIMARY KEY (`budget_period_id`)
2457 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2460 -- Table structure for table `aqbudgets_planning`
2463 DROP TABLE IF EXISTS `aqbudgets_planning`;
2464 CREATE TABLE `aqbudgets_planning` (
2465 `plan_id` int(11) NOT NULL auto_increment,
2466 `budget_id` int(11) NOT NULL,
2467 `budget_period_id` int(11) NOT NULL,
2468 `estimated_amount` decimal(28,6) default NULL,
2469 `authcat` varchar(30) NOT NULL,
2470 `authvalue` varchar(30) NOT NULL,
2471 `display` tinyint(1) DEFAULT 1,
2472 PRIMARY KEY (`plan_id`),
2473 CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2474 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2477 -- Table structure for table 'aqcontract'
2480 DROP TABLE IF EXISTS `aqcontract`;
2481 CREATE TABLE `aqcontract` (
2482 `contractnumber` int(11) NOT NULL auto_increment,
2483 `contractstartdate` date default NULL,
2484 `contractenddate` date default NULL,
2485 `contractname` varchar(50) default NULL,
2486 `contractdescription` mediumtext,
2487 `booksellerid` int(11) not NULL,
2488 PRIMARY KEY (`contractnumber`),
2489 CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2490 REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2491 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2494 -- Table structure for table `aqorderdelivery`
2497 DROP TABLE IF EXISTS `aqorderdelivery`;
2498 CREATE TABLE `aqorderdelivery` (
2499 `ordernumber` date default NULL,
2500 `deliverynumber` smallint(6) NOT NULL default 0,
2501 `deliverydate` varchar(18) default NULL,
2502 `qtydelivered` smallint(6) default NULL,
2503 `deliverycomments` mediumtext
2504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2507 -- Table structure for table `aqorders`
2510 DROP TABLE IF EXISTS `aqorders`;
2511 CREATE TABLE `aqorders` (
2512 `ordernumber` int(11) NOT NULL auto_increment,
2513 `biblionumber` int(11) default NULL,
2514 `entrydate` date default NULL,
2515 `quantity` smallint(6) default NULL,
2516 `currency` varchar(3) default NULL,
2517 `listprice` decimal(28,6) default NULL,
2518 `totalamount` decimal(28,6) default NULL,
2519 `datereceived` date default NULL,
2520 `booksellerinvoicenumber` mediumtext,
2521 `freight` decimal(28,6) default NULL,
2522 `unitprice` decimal(28,6) default NULL,
2523 `quantityreceived` smallint(6) NOT NULL default 0,
2524 `cancelledby` varchar(10) default NULL,
2525 `datecancellationprinted` date default NULL,
2527 `supplierreference` mediumtext,
2528 `purchaseordernumber` mediumtext,
2529 `subscription` tinyint(1) default NULL,
2530 `serialid` varchar(30) default NULL,
2531 `basketno` int(11) default NULL,
2532 `biblioitemnumber` int(11) default NULL,
2533 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2534 `rrp` decimal(13,2) default NULL,
2535 `ecost` decimal(13,2) default NULL,
2536 `gst` decimal(13,2) default NULL,
2537 `budget_id` int(11) NOT NULL,
2538 `budgetgroup_id` int(11) NOT NULL,
2539 `budgetdate` date default NULL,
2540 `sort1` varchar(80) default NULL,
2541 `sort2` varchar(80) default NULL,
2542 `sort1_authcat` varchar(10) default NULL,
2543 `sort2_authcat` varchar(10) default NULL,
2544 `uncertainprice` tinyint(1),
2545 PRIMARY KEY (`ordernumber`),
2546 KEY `basketno` (`basketno`),
2547 KEY `biblionumber` (`biblionumber`),
2548 KEY `budget_id` (`budget_id`),
2549 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2550 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2551 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2555 -- Table structure for table `aqorders_items`
2558 DROP TABLE IF EXISTS `aqorders_items`;
2559 CREATE TABLE `aqorders_items` (
2560 `ordernumber` int(11) NOT NULL,
2561 `itemnumber` int(11) NOT NULL,
2562 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2563 PRIMARY KEY (`itemnumber`),
2564 KEY `ordernumber` (`ordernumber`)
2565 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2568 -- Table structure for table `fieldmapping`
2571 DROP TABLE IF EXISTS `fieldmapping`;
2572 CREATE TABLE `fieldmapping` (
2573 `id` int(11) NOT NULL auto_increment,
2574 `field` varchar(255) NOT NULL,
2575 `frameworkcode` char(4) NOT NULL default '',
2576 `fieldcode` char(3) NOT NULL,
2577 `subfieldcode` char(1) NOT NULL,
2579 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2582 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2583 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2584 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2585 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2586 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2587 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2588 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2589 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;