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`),
186 KEY `publishercode` (`publishercode`),
187 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
188 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
191 -- Table structure for table `borrowers`
194 DROP TABLE IF EXISTS `borrowers`;
195 CREATE TABLE `borrowers` (
196 `borrowernumber` int(11) NOT NULL auto_increment,
197 `cardnumber` varchar(16) default NULL,
198 `surname` mediumtext NOT NULL,
201 `othernames` mediumtext,
203 `streetnumber` varchar(10) default NULL,
204 `streettype` varchar(50) default NULL,
205 `address` mediumtext NOT NULL,
207 `city` mediumtext NOT NULL,
208 `zipcode` varchar(25) default NULL,
212 `mobile` varchar(50) default NULL,
216 `B_streetnumber` varchar(10) default NULL,
217 `B_streettype` varchar(50) default NULL,
218 `B_address` varchar(100) default NULL,
219 `B_address2` text default NULL,
221 `B_zipcode` varchar(25) default NULL,
224 `B_phone` mediumtext,
225 `dateofbirth` date default NULL,
226 `branchcode` varchar(10) NOT NULL default '',
227 `categorycode` varchar(10) NOT NULL default '',
228 `dateenrolled` date default NULL,
229 `dateexpiry` date default NULL,
230 `gonenoaddress` tinyint(1) default NULL,
231 `lost` tinyint(1) default NULL,
232 `debarred` tinyint(1) default NULL,
233 `contactname` mediumtext,
234 `contactfirstname` text,
236 `guarantorid` int(11) default NULL,
237 `borrowernotes` mediumtext,
238 `relationship` varchar(100) default NULL,
239 `ethnicity` varchar(50) default NULL,
240 `ethnotes` varchar(255) default NULL,
241 `sex` varchar(1) default NULL,
242 `password` varchar(30) default NULL,
243 `flags` int(11) default NULL,
244 `userid` varchar(30) default NULL,
245 `opacnote` mediumtext,
246 `contactnote` varchar(255) default NULL,
247 `sort1` varchar(80) default NULL,
248 `sort2` varchar(80) default NULL,
249 `altcontactfirstname` varchar(255) default NULL,
250 `altcontactsurname` varchar(255) default NULL,
251 `altcontactaddress1` varchar(255) default NULL,
252 `altcontactaddress2` varchar(255) default NULL,
253 `altcontactaddress3` varchar(255) default NULL,
254 `altcontactzipcode` varchar(50) default NULL,
255 `altcontactcountry` text default NULL,
256 `altcontactphone` varchar(50) default NULL,
257 `smsalertnumber` varchar(50) default NULL,
258 `privacy` integer(11) DEFAULT '1' NOT NULL,
259 UNIQUE KEY `cardnumber` (`cardnumber`),
260 PRIMARY KEY `borrowernumber` (`borrowernumber`),
261 KEY `categorycode` (`categorycode`),
262 KEY `branchcode` (`branchcode`),
263 KEY `userid` (`userid`),
264 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
265 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
269 -- Table structure for table `borrower_attribute_types`
272 DROP TABLE IF EXISTS `borrower_attribute_types`;
273 CREATE TABLE `borrower_attribute_types` (
274 `code` varchar(10) NOT NULL,
275 `description` varchar(255) NOT NULL,
276 `repeatable` tinyint(1) NOT NULL default 0,
277 `unique_id` tinyint(1) NOT NULL default 0,
278 `opac_display` tinyint(1) NOT NULL default 0,
279 `password_allowed` tinyint(1) NOT NULL default 0,
280 `staff_searchable` tinyint(1) NOT NULL default 0,
281 `authorised_value_category` varchar(10) default NULL,
283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
286 -- Table structure for table `borrower_attributes`
289 DROP TABLE IF EXISTS `borrower_attributes`;
290 CREATE TABLE `borrower_attributes` (
291 `borrowernumber` int(11) NOT NULL,
292 `code` varchar(10) NOT NULL,
293 `attribute` varchar(64) default NULL,
294 `password` varchar(64) default NULL,
295 KEY `borrowernumber` (`borrowernumber`),
296 KEY `code_attribute` (`code`, `attribute`),
297 CONSTRAINT `borrower_attributes_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
298 ON DELETE CASCADE ON UPDATE CASCADE,
299 CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`)
300 ON DELETE CASCADE ON UPDATE CASCADE
301 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
303 DROP TABLE IF EXISTS `branch_item_rules`;
304 CREATE TABLE `branch_item_rules` (
305 `branchcode` varchar(10) NOT NULL,
306 `itemtype` varchar(10) NOT NULL,
307 `holdallowed` tinyint(1) default NULL,
308 PRIMARY KEY (`itemtype`,`branchcode`),
309 KEY `branch_item_rules_ibfk_2` (`branchcode`),
310 CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
311 ON DELETE CASCADE ON UPDATE CASCADE,
312 CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
313 ON DELETE CASCADE ON UPDATE CASCADE
314 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
317 -- Table structure for table `branchcategories`
320 DROP TABLE IF EXISTS `branchcategories`;
321 CREATE TABLE `branchcategories` (
322 `categorycode` varchar(10) NOT NULL default '',
323 `categoryname` varchar(32),
324 `codedescription` mediumtext,
325 `categorytype` varchar(16),
326 PRIMARY KEY (`categorycode`)
327 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
330 -- Table structure for table `branches`
333 DROP TABLE IF EXISTS `branches`;
334 CREATE TABLE `branches` (
335 `branchcode` varchar(10) NOT NULL default '',
336 `branchname` mediumtext NOT NULL,
337 `branchaddress1` mediumtext,
338 `branchaddress2` mediumtext,
339 `branchaddress3` mediumtext,
340 `branchzip` varchar(25) default NULL,
341 `branchcity` mediumtext,
342 `branchcountry` text,
343 `branchphone` mediumtext,
344 `branchfax` mediumtext,
345 `branchemail` mediumtext,
346 `branchurl` mediumtext,
347 `issuing` tinyint(4) default NULL,
348 `branchip` varchar(15) default NULL,
349 `branchprinter` varchar(100) default NULL,
350 `branchnotes` mediumtext,
351 UNIQUE KEY `branchcode` (`branchcode`)
352 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
355 -- Table structure for table `branchrelations`
358 DROP TABLE IF EXISTS `branchrelations`;
359 CREATE TABLE `branchrelations` (
360 `branchcode` varchar(10) NOT NULL default '',
361 `categorycode` varchar(10) NOT NULL default '',
362 PRIMARY KEY (`branchcode`,`categorycode`),
363 KEY `branchcode` (`branchcode`),
364 KEY `categorycode` (`categorycode`),
365 CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
366 CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
367 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
370 -- Table structure for table `branchtransfers`
373 DROP TABLE IF EXISTS `branchtransfers`;
374 CREATE TABLE `branchtransfers` (
375 `itemnumber` int(11) NOT NULL default 0,
376 `datesent` datetime default NULL,
377 `frombranch` varchar(10) NOT NULL default '',
378 `datearrived` datetime default NULL,
379 `tobranch` varchar(10) NOT NULL default '',
380 `comments` mediumtext,
381 KEY `frombranch` (`frombranch`),
382 KEY `tobranch` (`tobranch`),
383 KEY `itemnumber` (`itemnumber`),
384 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
385 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
386 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
391 -- Table structure for table `browser`
393 DROP TABLE IF EXISTS `browser`;
394 CREATE TABLE `browser` (
395 `level` int(11) NOT NULL,
396 `classification` varchar(20) NOT NULL,
397 `description` varchar(255) NOT NULL,
398 `number` bigint(20) NOT NULL,
399 `endnode` tinyint(4) NOT NULL
400 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
403 -- Table structure for table `categories`
406 DROP TABLE IF EXISTS `categories`;
407 CREATE TABLE `categories` (
408 `categorycode` varchar(10) NOT NULL default '',
409 `description` mediumtext,
410 `enrolmentperiod` smallint(6) default NULL,
411 `enrolmentperioddate` DATE NULL DEFAULT NULL,
412 `upperagelimit` smallint(6) default NULL,
413 `dateofbirthrequired` tinyint(1) default NULL,
414 `finetype` varchar(30) default NULL,
415 `bulk` tinyint(1) default NULL,
416 `enrolmentfee` decimal(28,6) default NULL,
417 `overduenoticerequired` tinyint(1) default NULL,
418 `issuelimit` smallint(6) default NULL,
419 `reservefee` decimal(28,6) default NULL,
420 `category_type` varchar(1) NOT NULL default 'A',
421 PRIMARY KEY (`categorycode`),
422 UNIQUE KEY `categorycode` (`categorycode`)
423 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
426 -- Table: collections
428 CREATE TABLE collections (
429 colId integer(11) NOT NULL auto_increment,
430 colTitle varchar(100) NOT NULL DEFAULT '',
431 colDesc text NOT NULL,
432 colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.',
434 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
437 -- Table: collections_tracking
439 CREATE TABLE collections_tracking (
440 ctId integer(11) NOT NULL auto_increment,
441 colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
442 itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
444 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
447 -- Table structure for table `borrower_branch_circ_rules`
450 DROP TABLE IF EXISTS `branch_borrower_circ_rules`;
451 CREATE TABLE `branch_borrower_circ_rules` (
452 `branchcode` VARCHAR(10) NOT NULL,
453 `categorycode` VARCHAR(10) NOT NULL,
454 `maxissueqty` int(4) default NULL,
455 PRIMARY KEY (`categorycode`, `branchcode`),
456 CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
457 ON DELETE CASCADE ON UPDATE CASCADE,
458 CONSTRAINT `branch_borrower_circ_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
459 ON DELETE CASCADE ON UPDATE CASCADE
460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
463 -- Table structure for table `default_borrower_circ_rules`
466 DROP TABLE IF EXISTS `default_borrower_circ_rules`;
467 CREATE TABLE `default_borrower_circ_rules` (
468 `categorycode` VARCHAR(10) NOT NULL,
469 `maxissueqty` int(4) default NULL,
470 PRIMARY KEY (`categorycode`),
471 CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
472 ON DELETE CASCADE ON UPDATE CASCADE
473 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
476 -- Table structure for table `default_branch_circ_rules`
479 DROP TABLE IF EXISTS `default_branch_circ_rules`;
480 CREATE TABLE `default_branch_circ_rules` (
481 `branchcode` VARCHAR(10) NOT NULL,
482 `maxissueqty` int(4) default NULL,
483 `holdallowed` tinyint(1) default NULL,
484 PRIMARY KEY (`branchcode`),
485 CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
486 ON DELETE CASCADE ON UPDATE CASCADE
487 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
490 -- Table structure for table `default_branch_item_rules`
492 DROP TABLE IF EXISTS `default_branch_item_rules`;
493 CREATE TABLE `default_branch_item_rules` (
494 `itemtype` varchar(10) NOT NULL,
495 `holdallowed` tinyint(1) default NULL,
496 PRIMARY KEY (`itemtype`),
497 CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
498 ON DELETE CASCADE ON UPDATE CASCADE
499 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
502 -- Table structure for table `default_circ_rules`
505 DROP TABLE IF EXISTS `default_circ_rules`;
506 CREATE TABLE `default_circ_rules` (
507 `singleton` enum('singleton') NOT NULL default 'singleton',
508 `maxissueqty` int(4) default NULL,
509 `holdallowed` int(1) default NULL,
510 PRIMARY KEY (`singleton`)
511 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
514 -- Table structure for table `cities`
517 DROP TABLE IF EXISTS `cities`;
518 CREATE TABLE `cities` (
519 `cityid` int(11) NOT NULL auto_increment,
520 `city_name` varchar(100) NOT NULL default '',
521 `city_zipcode` varchar(20) default NULL,
522 PRIMARY KEY (`cityid`)
523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
526 -- Table structure for table `class_sort_rules`
529 DROP TABLE IF EXISTS `class_sort_rules`;
530 CREATE TABLE `class_sort_rules` (
531 `class_sort_rule` varchar(10) NOT NULL default '',
532 `description` mediumtext,
533 `sort_routine` varchar(30) NOT NULL default '',
534 PRIMARY KEY (`class_sort_rule`),
535 UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
536 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
539 -- Table structure for table `class_sources`
542 DROP TABLE IF EXISTS `class_sources`;
543 CREATE TABLE `class_sources` (
544 `cn_source` varchar(10) NOT NULL default '',
545 `description` mediumtext,
546 `used` tinyint(4) NOT NULL default 0,
547 `class_sort_rule` varchar(10) NOT NULL default '',
548 PRIMARY KEY (`cn_source`),
549 UNIQUE KEY `cn_source_idx` (`cn_source`),
550 KEY `used_idx` (`used`),
551 CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
555 -- Table structure for table `currency`
558 DROP TABLE IF EXISTS `currency`;
559 CREATE TABLE `currency` (
560 `currency` varchar(10) NOT NULL default '',
561 `symbol` varchar(5) default NULL,
562 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
563 `rate` float(7,5) default NULL,
564 `active` tinyint(1) default NULL,
565 PRIMARY KEY (`currency`)
566 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
569 -- Table structure for table `deletedbiblio`
572 DROP TABLE IF EXISTS `deletedbiblio`;
573 CREATE TABLE `deletedbiblio` (
574 `biblionumber` int(11) NOT NULL default 0,
575 `frameworkcode` varchar(4) NOT NULL default '',
578 `unititle` mediumtext,
580 `serial` tinyint(1) default NULL,
581 `seriestitle` mediumtext,
582 `copyrightdate` smallint(6) default NULL,
583 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
584 `datecreated` DATE NOT NULL,
585 `abstract` mediumtext,
586 PRIMARY KEY (`biblionumber`),
587 KEY `blbnoidx` (`biblionumber`)
588 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
591 -- Table structure for table `deletedbiblioitems`
594 DROP TABLE IF EXISTS `deletedbiblioitems`;
595 CREATE TABLE `deletedbiblioitems` (
596 `biblioitemnumber` int(11) NOT NULL default 0,
597 `biblionumber` int(11) NOT NULL default 0,
600 `itemtype` varchar(10) default NULL,
601 `isbn` varchar(30) default NULL,
602 `issn` varchar(9) default NULL,
603 `publicationyear` text,
604 `publishercode` varchar(255) default NULL,
605 `volumedate` date default NULL,
607 `collectiontitle` mediumtext default NULL,
608 `collectionissn` text default NULL,
609 `collectionvolume` mediumtext default NULL,
610 `editionstatement` text default NULL,
611 `editionresponsibility` text default NULL,
612 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
613 `illus` varchar(255) default NULL,
614 `pages` varchar(255) default NULL,
616 `size` varchar(255) default NULL,
617 `place` varchar(255) default NULL,
618 `lccn` varchar(25) default NULL,
620 `url` varchar(255) default NULL,
621 `cn_source` varchar(10) default NULL,
622 `cn_class` varchar(30) default NULL,
623 `cn_item` varchar(10) default NULL,
624 `cn_suffix` varchar(10) default NULL,
625 `cn_sort` varchar(30) default NULL,
626 `totalissues` int(10),
627 `marcxml` longtext NOT NULL,
628 PRIMARY KEY (`biblioitemnumber`),
629 KEY `bibinoidx` (`biblioitemnumber`),
630 KEY `bibnoidx` (`biblionumber`),
632 KEY `publishercode` (`publishercode`)
633 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
636 -- Table structure for table `deletedborrowers`
639 DROP TABLE IF EXISTS `deletedborrowers`;
640 CREATE TABLE `deletedborrowers` (
641 `borrowernumber` int(11) NOT NULL default 0,
642 `cardnumber` varchar(9) NOT NULL default '',
643 `surname` mediumtext NOT NULL,
646 `othernames` mediumtext,
648 `streetnumber` varchar(10) default NULL,
649 `streettype` varchar(50) default NULL,
650 `address` mediumtext NOT NULL,
652 `city` mediumtext NOT NULL,
653 `zipcode` varchar(25) default NULL,
657 `mobile` varchar(50) default NULL,
661 `B_streetnumber` varchar(10) default NULL,
662 `B_streettype` varchar(50) default NULL,
663 `B_address` varchar(100) default NULL,
664 `B_address2` text default NULL,
666 `B_zipcode` varchar(25) default NULL,
669 `B_phone` mediumtext,
670 `dateofbirth` date default NULL,
671 `branchcode` varchar(10) NOT NULL default '',
672 `categorycode` varchar(10) default NULL,
673 `dateenrolled` date default NULL,
674 `dateexpiry` date default NULL,
675 `gonenoaddress` tinyint(1) default NULL,
676 `lost` tinyint(1) default NULL,
677 `debarred` tinyint(1) default NULL,
678 `contactname` mediumtext,
679 `contactfirstname` text,
681 `guarantorid` int(11) default NULL,
682 `borrowernotes` mediumtext,
683 `relationship` varchar(100) default NULL,
684 `ethnicity` varchar(50) default NULL,
685 `ethnotes` varchar(255) default NULL,
686 `sex` varchar(1) default NULL,
687 `password` varchar(30) default NULL,
688 `flags` int(11) default NULL,
689 `userid` varchar(30) default NULL,
690 `opacnote` mediumtext,
691 `contactnote` varchar(255) default NULL,
692 `sort1` varchar(80) default NULL,
693 `sort2` varchar(80) default NULL,
694 `altcontactfirstname` varchar(255) default NULL,
695 `altcontactsurname` varchar(255) default NULL,
696 `altcontactaddress1` varchar(255) default NULL,
697 `altcontactaddress2` varchar(255) default NULL,
698 `altcontactaddress3` varchar(255) default NULL,
699 `altcontactzipcode` varchar(50) default NULL,
700 `altcontactcountry` text default NULL,
701 `altcontactphone` varchar(50) default NULL,
702 `smsalertnumber` varchar(50) default NULL,
703 KEY `borrowernumber` (`borrowernumber`),
704 KEY `cardnumber` (`cardnumber`)
705 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
708 -- Table structure for table `deleteditems`
711 DROP TABLE IF EXISTS `deleteditems`;
712 CREATE TABLE `deleteditems` (
713 `itemnumber` int(11) NOT NULL default 0,
714 `biblionumber` int(11) NOT NULL default 0,
715 `biblioitemnumber` int(11) NOT NULL default 0,
716 `barcode` varchar(20) default NULL,
717 `dateaccessioned` date default NULL,
718 `booksellerid` mediumtext default NULL,
719 `homebranch` varchar(10) default NULL,
720 `price` decimal(8,2) default NULL,
721 `replacementprice` decimal(8,2) default NULL,
722 `replacementpricedate` date default NULL,
723 `datelastborrowed` date default NULL,
724 `datelastseen` date default NULL,
725 `stack` tinyint(1) default NULL,
726 `notforloan` tinyint(1) NOT NULL default 0,
727 `damaged` tinyint(1) NOT NULL default 0,
728 `itemlost` tinyint(1) NOT NULL default 0,
729 `wthdrawn` tinyint(1) NOT NULL default 0,
730 `itemcallnumber` varchar(255) default NULL,
731 `issues` smallint(6) default NULL,
732 `renewals` smallint(6) default NULL,
733 `reserves` smallint(6) default NULL,
734 `restricted` tinyint(1) default NULL,
735 `itemnotes` mediumtext,
736 `holdingbranch` varchar(10) default NULL,
737 `paidfor` mediumtext,
738 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
739 `location` varchar(80) default NULL,
740 `permanent_location` varchar(80) default NULL,
741 `onloan` date default NULL,
742 `cn_source` varchar(10) default NULL,
743 `cn_sort` varchar(30) default NULL,
744 `ccode` varchar(10) default NULL,
745 `materials` varchar(10) default NULL,
746 `uri` varchar(255) default NULL,
747 `itype` varchar(10) default NULL,
748 `more_subfields_xml` longtext default NULL,
749 `enumchron` varchar(80) default NULL,
750 `copynumber` varchar(32) default NULL,
751 `stocknumber` varchar(32) default NULL,
753 PRIMARY KEY (`itemnumber`),
754 KEY `delitembarcodeidx` (`barcode`),
755 KEY `delitemstocknumberidx` (`stocknumber`),
756 KEY `delitembinoidx` (`biblioitemnumber`),
757 KEY `delitembibnoidx` (`biblionumber`),
758 KEY `delhomebranch` (`homebranch`),
759 KEY `delholdingbranch` (`holdingbranch`)
760 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
763 -- Table structure for table `ethnicity`
766 DROP TABLE IF EXISTS `ethnicity`;
767 CREATE TABLE `ethnicity` (
768 `code` varchar(10) NOT NULL default '',
769 `name` varchar(255) default NULL,
771 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
774 -- Table structure for table `export_format`
777 DROP TABLE IF EXISTS `export_format`;
778 CREATE TABLE `export_format` (
779 `export_format_id` int(11) NOT NULL auto_increment,
780 `profile` varchar(255) NOT NULL,
781 `description` mediumtext NOT NULL,
782 `marcfields` mediumtext NOT NULL,
783 `csv_separator` varchar(2) NOT NULL,
784 `field_separator` varchar(2) NOT NULL,
785 `subfield_separator` varchar(2) NOT NULL,
786 `encoding` varchar(255) NOT NULL,
787 PRIMARY KEY (`export_format_id`)
788 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export';
792 -- Table structure for table `hold_fill_targets`
795 DROP TABLE IF EXISTS `hold_fill_targets`;
796 CREATE TABLE hold_fill_targets (
797 `borrowernumber` int(11) NOT NULL,
798 `biblionumber` int(11) NOT NULL,
799 `itemnumber` int(11) NOT NULL,
800 `source_branchcode` varchar(10) default NULL,
801 `item_level_request` tinyint(4) NOT NULL default 0,
802 PRIMARY KEY `itemnumber` (`itemnumber`),
803 KEY `bib_branch` (`biblionumber`, `source_branchcode`),
804 CONSTRAINT `hold_fill_targets_ibfk_1` FOREIGN KEY (`borrowernumber`)
805 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
806 CONSTRAINT `hold_fill_targets_ibfk_2` FOREIGN KEY (`biblionumber`)
807 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
808 CONSTRAINT `hold_fill_targets_ibfk_3` FOREIGN KEY (`itemnumber`)
809 REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
810 CONSTRAINT `hold_fill_targets_ibfk_4` FOREIGN KEY (`source_branchcode`)
811 REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
812 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
815 -- Table structure for table `import_batches`
818 DROP TABLE IF EXISTS `import_batches`;
819 CREATE TABLE `import_batches` (
820 `import_batch_id` int(11) NOT NULL auto_increment,
821 `matcher_id` int(11) default NULL,
822 `template_id` int(11) default NULL,
823 `branchcode` varchar(10) default NULL,
824 `num_biblios` int(11) NOT NULL default 0,
825 `num_items` int(11) NOT NULL default 0,
826 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
827 `overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new',
828 `nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new',
829 `item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore') NOT NULL default 'always_add',
830 `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging',
831 `batch_type` enum('batch', 'z3950') NOT NULL default 'batch',
832 `file_name` varchar(100),
833 `comments` mediumtext,
834 PRIMARY KEY (`import_batch_id`),
835 KEY `branchcode` (`branchcode`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
839 -- Table structure for table `import_records`
842 DROP TABLE IF EXISTS `import_records`;
843 CREATE TABLE `import_records` (
844 `import_record_id` int(11) NOT NULL auto_increment,
845 `import_batch_id` int(11) NOT NULL,
846 `branchcode` varchar(10) default NULL,
847 `record_sequence` int(11) NOT NULL default 0,
848 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
849 `import_date` DATE default NULL,
850 `marc` longblob NOT NULL,
851 `marcxml` longtext NOT NULL,
852 `marcxml_old` longtext NOT NULL,
853 `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio',
854 `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match',
855 `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',
856 `import_error` mediumtext,
857 `encoding` varchar(40) NOT NULL default '',
858 `z3950random` varchar(40) default NULL,
859 PRIMARY KEY (`import_record_id`),
860 CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
861 REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
862 KEY `branchcode` (`branchcode`),
863 KEY `batch_sequence` (`import_batch_id`, `record_sequence`)
864 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
867 -- Table structure for `import_record_matches`
869 DROP TABLE IF EXISTS `import_record_matches`;
870 CREATE TABLE `import_record_matches` (
871 `import_record_id` int(11) NOT NULL,
872 `candidate_match_id` int(11) NOT NULL,
873 `score` int(11) NOT NULL default 0,
874 CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
875 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
876 KEY `record_score` (`import_record_id`, `score`)
877 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
880 -- Table structure for table `import_biblios`
883 DROP TABLE IF EXISTS `import_biblios`;
884 CREATE TABLE `import_biblios` (
885 `import_record_id` int(11) NOT NULL,
886 `matched_biblionumber` int(11) default NULL,
887 `control_number` varchar(25) default NULL,
888 `original_source` varchar(25) default NULL,
889 `title` varchar(128) default NULL,
890 `author` varchar(80) default NULL,
891 `isbn` varchar(30) default NULL,
892 `issn` varchar(9) default NULL,
893 `has_items` tinyint(1) NOT NULL default 0,
894 CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
895 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
896 KEY `matched_biblionumber` (`matched_biblionumber`),
897 KEY `title` (`title`),
899 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
902 -- Table structure for table `import_items`
905 DROP TABLE IF EXISTS `import_items`;
906 CREATE TABLE `import_items` (
907 `import_items_id` int(11) NOT NULL auto_increment,
908 `import_record_id` int(11) NOT NULL,
909 `itemnumber` int(11) default NULL,
910 `branchcode` varchar(10) default NULL,
911 `status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged',
912 `marcxml` longtext NOT NULL,
913 `import_error` mediumtext,
914 PRIMARY KEY (`import_items_id`),
915 CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`)
916 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
917 KEY `itemnumber` (`itemnumber`),
918 KEY `branchcode` (`branchcode`)
919 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
922 -- Table structure for table `issues`
925 DROP TABLE IF EXISTS `issues`;
926 CREATE TABLE `issues` (
927 `borrowernumber` int(11) default NULL,
928 `itemnumber` int(11) default NULL,
929 `date_due` date default NULL,
930 `branchcode` varchar(10) default NULL,
931 `issuingbranch` varchar(18) default NULL,
932 `returndate` date default NULL,
933 `lastreneweddate` date default NULL,
934 `return` varchar(4) default NULL,
935 `renewals` tinyint(4) default NULL,
936 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
937 `issuedate` date default NULL,
938 KEY `issuesborridx` (`borrowernumber`),
939 KEY `issuesitemidx` (`itemnumber`),
940 KEY `bordate` (`borrowernumber`,`timestamp`),
941 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
942 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
946 -- Table structure for table `issuingrules`
949 DROP TABLE IF EXISTS `issuingrules`;
950 CREATE TABLE `issuingrules` (
951 `categorycode` varchar(10) NOT NULL default '',
952 `itemtype` varchar(10) NOT NULL default '',
953 `restrictedtype` tinyint(1) default NULL,
954 `rentaldiscount` decimal(28,6) default NULL,
955 `reservecharge` decimal(28,6) default NULL,
956 `fine` decimal(28,6) default NULL,
957 `finedays` int(11) default NULL,
958 `firstremind` int(11) default NULL,
959 `chargeperiod` int(11) default NULL,
960 `accountsent` int(11) default NULL,
961 `chargename` varchar(100) default NULL,
962 `maxissueqty` int(4) default NULL,
963 `issuelength` int(4) default NULL,
964 `renewalsallowed` smallint(6) NOT NULL default "0",
965 `reservesallowed` smallint(6) NOT NULL default "0",
966 `branchcode` varchar(10) NOT NULL default '',
967 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
968 KEY `categorycode` (`categorycode`),
969 KEY `itemtype` (`itemtype`)
970 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
973 -- Table structure for table `items`
976 DROP TABLE IF EXISTS `items`;
977 CREATE TABLE `items` (
978 `itemnumber` int(11) NOT NULL auto_increment,
979 `biblionumber` int(11) NOT NULL default 0,
980 `biblioitemnumber` int(11) NOT NULL default 0,
981 `barcode` varchar(20) default NULL,
982 `dateaccessioned` date default NULL,
983 `booksellerid` mediumtext default NULL,
984 `homebranch` varchar(10) default NULL,
985 `price` decimal(8,2) default NULL,
986 `replacementprice` decimal(8,2) default NULL,
987 `replacementpricedate` date default NULL,
988 `datelastborrowed` date default NULL,
989 `datelastseen` date default NULL,
990 `stack` tinyint(1) default NULL,
991 `notforloan` tinyint(1) NOT NULL default 0,
992 `damaged` tinyint(1) NOT NULL default 0,
993 `itemlost` tinyint(1) NOT NULL default 0,
994 `wthdrawn` tinyint(1) NOT NULL default 0,
995 `itemcallnumber` varchar(255) default NULL,
996 `issues` smallint(6) default NULL,
997 `renewals` smallint(6) default NULL,
998 `reserves` smallint(6) default NULL,
999 `restricted` tinyint(1) default NULL,
1000 `itemnotes` mediumtext,
1001 `holdingbranch` varchar(10) default NULL,
1002 `paidfor` mediumtext,
1003 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1004 `location` varchar(80) default NULL,
1005 `permanent_location` varchar(80) default NULL,
1006 `onloan` date default NULL,
1007 `cn_source` varchar(10) default NULL,
1008 `cn_sort` varchar(30) default NULL,
1009 `ccode` varchar(10) default NULL,
1010 `materials` varchar(10) default NULL,
1011 `uri` varchar(255) default NULL,
1012 `itype` varchar(10) default NULL,
1013 `more_subfields_xml` longtext default NULL,
1014 `enumchron` varchar(80) default NULL,
1015 `copynumber` varchar(32) default NULL,
1016 `stocknumber` varchar(32) default NULL,
1017 PRIMARY KEY (`itemnumber`),
1018 UNIQUE KEY `itembarcodeidx` (`barcode`),
1019 UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
1020 KEY `itembinoidx` (`biblioitemnumber`),
1021 KEY `itembibnoidx` (`biblionumber`),
1022 KEY `homebranch` (`homebranch`),
1023 KEY `holdingbranch` (`holdingbranch`),
1024 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1025 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1026 CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1027 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1030 -- Table structure for table `itemtypes`
1033 DROP TABLE IF EXISTS `itemtypes`;
1034 CREATE TABLE `itemtypes` (
1035 `itemtype` varchar(10) NOT NULL default '',
1036 `description` mediumtext,
1037 `rentalcharge` double(16,4) default NULL,
1038 `notforloan` smallint(6) default NULL,
1039 `imageurl` varchar(200) default NULL,
1041 PRIMARY KEY (`itemtype`),
1042 UNIQUE KEY `itemtype` (`itemtype`)
1043 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1046 -- Table structure for table `creator_batches`
1049 DROP TABLE IF EXISTS `creator_batches`;
1050 SET @saved_cs_client = @@character_set_client;
1051 SET character_set_client = utf8;
1052 CREATE TABLE `creator_batches` (
1053 `label_id` int(11) NOT NULL AUTO_INCREMENT,
1054 `batch_id` int(10) NOT NULL DEFAULT '1',
1055 `item_number` int(11) DEFAULT NULL,
1056 `borrower_number` int(11) DEFAULT NULL,
1057 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1058 `branch_code` varchar(10) NOT NULL DEFAULT 'NB',
1059 `creator` char(15) NOT NULL DEFAULT 'Labels',
1060 PRIMARY KEY (`label_id`),
1061 KEY `branch_fk_constraint` (`branch_code`),
1062 KEY `item_fk_constraint` (`item_number`),
1063 KEY `borrower_fk_constraint` (`borrower_number`),
1064 CONSTRAINT `creator_batches_ibfk_1` FOREIGN KEY (`borrower_number`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1065 CONSTRAINT `creator_batches_ibfk_2` FOREIGN KEY (`branch_code`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE,
1066 CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE
1067 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1070 -- Table structure for table `creator_images`
1073 DROP TABLE IF EXISTS `creator_images`;
1074 SET @saved_cs_client = @@character_set_client;
1075 SET character_set_client = utf8;
1076 CREATE TABLE `creator_images` (
1077 `image_id` int(4) NOT NULL AUTO_INCREMENT,
1078 `imagefile` mediumblob,
1079 `image_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1080 PRIMARY KEY (`image_id`),
1081 UNIQUE KEY `image_name_index` (`image_name`)
1082 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1085 -- Table structure for table `creator_layouts`
1088 DROP TABLE IF EXISTS `creator_layouts`;
1089 SET @saved_cs_client = @@character_set_client;
1090 SET character_set_client = utf8;
1091 CREATE TABLE `creator_layouts` (
1092 `layout_id` int(4) NOT NULL AUTO_INCREMENT,
1093 `barcode_type` char(100) NOT NULL DEFAULT 'CODE39',
1094 `start_label` int(2) NOT NULL DEFAULT '1',
1095 `printing_type` char(32) NOT NULL DEFAULT 'BAR',
1096 `layout_name` char(20) NOT NULL DEFAULT 'DEFAULT',
1097 `guidebox` int(1) DEFAULT '0',
1098 `font` char(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TR',
1099 `font_size` int(4) NOT NULL DEFAULT '10',
1100 `units` char(20) NOT NULL DEFAULT 'POINT',
1101 `callnum_split` int(1) DEFAULT '0',
1102 `text_justify` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'L',
1103 `format_string` varchar(210) NOT NULL DEFAULT 'barcode',
1104 `layout_xml` text NOT NULL,
1105 `creator` char(15) NOT NULL DEFAULT 'Labels',
1106 PRIMARY KEY (`layout_id`)
1107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1110 -- Table structure for table `creator_templates`
1113 DROP TABLE IF EXISTS `creator_templates`;
1114 SET @saved_cs_client = @@character_set_client;
1115 SET character_set_client = utf8;
1116 CREATE TABLE `creator_templates` (
1117 `template_id` int(4) NOT NULL AUTO_INCREMENT,
1118 `profile_id` int(4) DEFAULT NULL,
1119 `template_code` char(100) NOT NULL DEFAULT 'DEFAULT TEMPLATE',
1120 `template_desc` char(100) NOT NULL DEFAULT 'Default description',
1121 `page_width` float NOT NULL DEFAULT '0',
1122 `page_height` float NOT NULL DEFAULT '0',
1123 `label_width` float NOT NULL DEFAULT '0',
1124 `label_height` float NOT NULL DEFAULT '0',
1125 `top_text_margin` float NOT NULL DEFAULT '0',
1126 `left_text_margin` float NOT NULL DEFAULT '0',
1127 `top_margin` float NOT NULL DEFAULT '0',
1128 `left_margin` float NOT NULL DEFAULT '0',
1129 `cols` int(2) NOT NULL DEFAULT '0',
1130 `rows` int(2) NOT NULL DEFAULT '0',
1131 `col_gap` float NOT NULL DEFAULT '0',
1132 `row_gap` float NOT NULL DEFAULT '0',
1133 `units` char(20) NOT NULL DEFAULT 'POINT',
1134 `creator` char(15) NOT NULL DEFAULT 'Labels',
1135 PRIMARY KEY (`template_id`),
1136 KEY `template_profile_fk_constraint` (`profile_id`)
1137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1140 -- Table structure for table `letter`
1143 DROP TABLE IF EXISTS `letter`;
1144 CREATE TABLE `letter` (
1145 `module` varchar(20) NOT NULL default '',
1146 `code` varchar(20) NOT NULL default '',
1147 `name` varchar(100) NOT NULL default '',
1148 `title` varchar(200) NOT NULL default '',
1150 PRIMARY KEY (`module`,`code`)
1151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1154 -- Table structure for table `marc_subfield_structure`
1157 DROP TABLE IF EXISTS `marc_subfield_structure`;
1158 CREATE TABLE `marc_subfield_structure` (
1159 `tagfield` varchar(3) NOT NULL default '',
1160 `tagsubfield` varchar(1) NOT NULL default '' COLLATE utf8_bin,
1161 `liblibrarian` varchar(255) NOT NULL default '',
1162 `libopac` varchar(255) NOT NULL default '',
1163 `repeatable` tinyint(4) NOT NULL default 0,
1164 `mandatory` tinyint(4) NOT NULL default 0,
1165 `kohafield` varchar(40) default NULL,
1166 `tab` tinyint(1) default NULL,
1167 `authorised_value` varchar(20) default NULL,
1168 `authtypecode` varchar(20) default NULL,
1169 `value_builder` varchar(80) default NULL,
1170 `isurl` tinyint(1) default NULL,
1171 `hidden` tinyint(1) default NULL,
1172 `frameworkcode` varchar(4) NOT NULL default '',
1173 `seealso` varchar(1100) default NULL,
1174 `link` varchar(80) default NULL,
1175 `defaultvalue` text default NULL,
1176 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1177 KEY `kohafield_2` (`kohafield`),
1178 KEY `tab` (`frameworkcode`,`tab`),
1179 KEY `kohafield` (`frameworkcode`,`kohafield`)
1180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1183 -- Table structure for table `marc_tag_structure`
1186 DROP TABLE IF EXISTS `marc_tag_structure`;
1187 CREATE TABLE `marc_tag_structure` (
1188 `tagfield` varchar(3) NOT NULL default '',
1189 `liblibrarian` varchar(255) NOT NULL default '',
1190 `libopac` varchar(255) NOT NULL default '',
1191 `repeatable` tinyint(4) NOT NULL default 0,
1192 `mandatory` tinyint(4) NOT NULL default 0,
1193 `authorised_value` varchar(10) default NULL,
1194 `frameworkcode` varchar(4) NOT NULL default '',
1195 PRIMARY KEY (`frameworkcode`,`tagfield`)
1196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1199 -- Table structure for table `marc_matchers`
1202 DROP TABLE IF EXISTS `marc_matchers`;
1203 CREATE TABLE `marc_matchers` (
1204 `matcher_id` int(11) NOT NULL auto_increment,
1205 `code` varchar(10) NOT NULL default '',
1206 `description` varchar(255) NOT NULL default '',
1207 `record_type` varchar(10) NOT NULL default 'biblio',
1208 `threshold` int(11) NOT NULL default 0,
1209 PRIMARY KEY (`matcher_id`),
1210 KEY `code` (`code`),
1211 KEY `record_type` (`record_type`)
1212 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1215 -- Table structure for table `matchpoints`
1217 DROP TABLE IF EXISTS `matchpoints`;
1218 CREATE TABLE `matchpoints` (
1219 `matcher_id` int(11) NOT NULL,
1220 `matchpoint_id` int(11) NOT NULL auto_increment,
1221 `search_index` varchar(30) NOT NULL default '',
1222 `score` int(11) NOT NULL default 0,
1223 PRIMARY KEY (`matchpoint_id`),
1224 CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1225 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
1226 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1230 -- Table structure for table `matchpoint_components`
1232 DROP TABLE IF EXISTS `matchpoint_components`;
1233 CREATE TABLE `matchpoint_components` (
1234 `matchpoint_id` int(11) NOT NULL,
1235 `matchpoint_component_id` int(11) NOT NULL auto_increment,
1236 sequence int(11) NOT NULL default 0,
1237 tag varchar(3) NOT NULL default '',
1238 subfields varchar(40) NOT NULL default '',
1239 offset int(4) NOT NULL default 0,
1240 length int(4) NOT NULL default 0,
1241 PRIMARY KEY (`matchpoint_component_id`),
1242 KEY `by_sequence` (`matchpoint_id`, `sequence`),
1243 CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
1244 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1245 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1248 -- Table structure for table `matcher_component_norms`
1250 DROP TABLE IF EXISTS `matchpoint_component_norms`;
1251 CREATE TABLE `matchpoint_component_norms` (
1252 `matchpoint_component_id` int(11) NOT NULL,
1253 `sequence` int(11) NOT NULL default 0,
1254 `norm_routine` varchar(50) NOT NULL default '',
1255 KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
1256 CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
1257 REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
1258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1261 -- Table structure for table `matcher_matchpoints`
1263 DROP TABLE IF EXISTS `matcher_matchpoints`;
1264 CREATE TABLE `matcher_matchpoints` (
1265 `matcher_id` int(11) NOT NULL,
1266 `matchpoint_id` int(11) NOT NULL,
1267 CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
1268 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1269 CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
1270 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1274 -- Table structure for table `matchchecks`
1276 DROP TABLE IF EXISTS `matchchecks`;
1277 CREATE TABLE `matchchecks` (
1278 `matcher_id` int(11) NOT NULL,
1279 `matchcheck_id` int(11) NOT NULL auto_increment,
1280 `source_matchpoint_id` int(11) NOT NULL,
1281 `target_matchpoint_id` int(11) NOT NULL,
1282 PRIMARY KEY (`matchcheck_id`),
1283 CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`)
1284 REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1285 CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`)
1286 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
1287 CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
1288 REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
1289 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1292 -- Table structure for table `notifys`
1295 DROP TABLE IF EXISTS `notifys`;
1296 CREATE TABLE `notifys` (
1297 `notify_id` int(11) NOT NULL default 0,
1298 `borrowernumber` int(11) NOT NULL default 0,
1299 `itemnumber` int(11) NOT NULL default 0,
1300 `notify_date` date default NULL,
1301 `notify_send_date` date default NULL,
1302 `notify_level` int(1) NOT NULL default 0,
1303 `method` varchar(20) NOT NULL default ''
1304 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1307 -- Table structure for table `nozebra`
1310 DROP TABLE IF EXISTS `nozebra`;
1311 CREATE TABLE `nozebra` (
1312 `server` varchar(20) NOT NULL,
1313 `indexname` varchar(40) NOT NULL,
1314 `value` varchar(250) NOT NULL,
1315 `biblionumbers` longtext NOT NULL,
1316 KEY `indexname` (`server`,`indexname`),
1317 KEY `value` (`server`,`value`))
1318 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1321 -- Table structure for table `old_issues`
1324 DROP TABLE IF EXISTS `old_issues`;
1325 CREATE TABLE `old_issues` (
1326 `borrowernumber` int(11) default NULL,
1327 `itemnumber` int(11) default NULL,
1328 `date_due` date default NULL,
1329 `branchcode` varchar(10) default NULL,
1330 `issuingbranch` varchar(18) default NULL,
1331 `returndate` date default NULL,
1332 `lastreneweddate` date default NULL,
1333 `return` varchar(4) default NULL,
1334 `renewals` tinyint(4) default NULL,
1335 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1336 `issuedate` date default NULL,
1337 KEY `old_issuesborridx` (`borrowernumber`),
1338 KEY `old_issuesitemidx` (`itemnumber`),
1339 KEY `old_bordate` (`borrowernumber`,`timestamp`),
1340 CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1341 ON DELETE SET NULL ON UPDATE SET NULL,
1342 CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1343 ON DELETE SET NULL ON UPDATE SET NULL
1344 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1347 -- Table structure for table `old_reserves`
1349 DROP TABLE IF EXISTS `old_reserves`;
1350 CREATE TABLE `old_reserves` (
1351 `borrowernumber` int(11) default NULL,
1352 `reservedate` date default NULL,
1353 `biblionumber` int(11) default NULL,
1354 `constrainttype` varchar(1) default NULL,
1355 `branchcode` varchar(10) default NULL,
1356 `notificationdate` date default NULL,
1357 `reminderdate` date default NULL,
1358 `cancellationdate` date default NULL,
1359 `reservenotes` mediumtext,
1360 `priority` smallint(6) default NULL,
1361 `found` varchar(1) default NULL,
1362 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1363 `itemnumber` int(11) default NULL,
1364 `waitingdate` date default NULL,
1365 `expirationdate` DATE DEFAULT NULL,
1366 `lowestPriority` tinyint(1) NOT NULL,
1367 KEY `old_reserves_borrowernumber` (`borrowernumber`),
1368 KEY `old_reserves_biblionumber` (`biblionumber`),
1369 KEY `old_reserves_itemnumber` (`itemnumber`),
1370 KEY `old_reserves_branchcode` (`branchcode`),
1371 CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
1372 ON DELETE SET NULL ON UPDATE SET NULL,
1373 CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`)
1374 ON DELETE SET NULL ON UPDATE SET NULL,
1375 CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
1376 ON DELETE SET NULL ON UPDATE SET NULL
1377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1380 -- Table structure for table `opac_news`
1383 DROP TABLE IF EXISTS `opac_news`;
1384 CREATE TABLE `opac_news` (
1385 `idnew` int(10) unsigned NOT NULL auto_increment,
1386 `title` varchar(250) NOT NULL default '',
1387 `new` text NOT NULL,
1388 `lang` varchar(25) NOT NULL default '',
1389 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1390 `expirationdate` date default NULL,
1391 `number` int(11) default NULL,
1392 PRIMARY KEY (`idnew`)
1393 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1396 -- Table structure for table `overduerules`
1399 DROP TABLE IF EXISTS `overduerules`;
1400 CREATE TABLE `overduerules` (
1401 `branchcode` varchar(10) NOT NULL default '',
1402 `categorycode` varchar(10) NOT NULL default '',
1403 `delay1` int(4) default 0,
1404 `letter1` varchar(20) default NULL,
1405 `debarred1` varchar(1) default 0,
1406 `delay2` int(4) default 0,
1407 `debarred2` varchar(1) default 0,
1408 `letter2` varchar(20) default NULL,
1409 `delay3` int(4) default 0,
1410 `letter3` varchar(20) default NULL,
1411 `debarred3` int(1) default 0,
1412 PRIMARY KEY (`branchcode`,`categorycode`)
1413 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1416 -- Table structure for table `patroncards`
1419 DROP TABLE IF EXISTS `patroncards`;
1420 CREATE TABLE `patroncards` (
1421 `cardid` int(11) NOT NULL auto_increment,
1422 `batch_id` varchar(10) NOT NULL default '1',
1423 `borrowernumber` int(11) NOT NULL,
1424 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1425 PRIMARY KEY (`cardid`),
1426 KEY `patroncards_ibfk_1` (`borrowernumber`),
1427 CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1431 -- Table structure for table `patronimage`
1434 DROP TABLE IF EXISTS `patronimage`;
1435 CREATE TABLE `patronimage` (
1436 `cardnumber` varchar(16) NOT NULL,
1437 `mimetype` varchar(15) NOT NULL,
1438 `imagefile` mediumblob NOT NULL,
1439 PRIMARY KEY (`cardnumber`),
1440 CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1441 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1444 -- Table structure for table `printers`
1447 DROP TABLE IF EXISTS `printers`;
1448 CREATE TABLE `printers` (
1449 `printername` varchar(40) NOT NULL default '',
1450 `printqueue` varchar(20) default NULL,
1451 `printtype` varchar(20) default NULL,
1452 PRIMARY KEY (`printername`)
1453 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1456 -- Table structure for table `printers_profile`
1459 DROP TABLE IF EXISTS `printers_profile`;
1460 CREATE TABLE `printers_profile` (
1461 `profile_id` int(4) NOT NULL auto_increment,
1462 `printer_name` varchar(40) NOT NULL default 'Default Printer',
1463 `template_id` int(4) NOT NULL default '0',
1464 `paper_bin` varchar(20) NOT NULL default 'Bypass',
1465 `offset_horz` float NOT NULL default '0',
1466 `offset_vert` float NOT NULL default '0',
1467 `creep_horz` float NOT NULL default '0',
1468 `creep_vert` float NOT NULL default '0',
1469 `units` char(20) NOT NULL default 'POINT',
1470 `creator` char(15) NOT NULL DEFAULT 'Labels',
1471 PRIMARY KEY (`profile_id`),
1472 UNIQUE KEY `printername` (`printer_name`,`template_id`,`paper_bin`,`creator`)
1473 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1476 -- Table structure for table `repeatable_holidays`
1479 DROP TABLE IF EXISTS `repeatable_holidays`;
1480 CREATE TABLE `repeatable_holidays` (
1481 `id` int(11) NOT NULL auto_increment,
1482 `branchcode` varchar(10) NOT NULL default '',
1483 `weekday` smallint(6) default NULL,
1484 `day` smallint(6) default NULL,
1485 `month` smallint(6) default NULL,
1486 `title` varchar(50) NOT NULL default '',
1487 `description` text NOT NULL,
1489 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1492 -- Table structure for table `reports_dictionary`
1495 DROP TABLE IF EXISTS `reports_dictionary`;
1496 CREATE TABLE reports_dictionary (
1497 `id` int(11) NOT NULL auto_increment,
1498 `name` varchar(255) default NULL,
1500 `date_created` datetime default NULL,
1501 `date_modified` datetime default NULL,
1503 `area` int(11) default NULL,
1505 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1508 -- Table structure for table `reserveconstraints`
1511 DROP TABLE IF EXISTS `reserveconstraints`;
1512 CREATE TABLE `reserveconstraints` (
1513 `borrowernumber` int(11) NOT NULL default 0,
1514 `reservedate` date default NULL,
1515 `biblionumber` int(11) NOT NULL default 0,
1516 `biblioitemnumber` int(11) default NULL,
1517 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1518 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1521 -- Table structure for table `reserves`
1524 DROP TABLE IF EXISTS `reserves`;
1525 CREATE TABLE `reserves` (
1526 `borrowernumber` int(11) NOT NULL default 0,
1527 `reservedate` date default NULL,
1528 `biblionumber` int(11) NOT NULL default 0,
1529 `constrainttype` varchar(1) default NULL,
1530 `branchcode` varchar(10) default NULL,
1531 `notificationdate` date default NULL,
1532 `reminderdate` date default NULL,
1533 `cancellationdate` date default NULL,
1534 `reservenotes` mediumtext,
1535 `priority` smallint(6) default NULL,
1536 `found` varchar(1) default NULL,
1537 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1538 `itemnumber` int(11) default NULL,
1539 `waitingdate` date default NULL,
1540 `expirationdate` DATE DEFAULT NULL,
1541 `lowestPriority` tinyint(1) NOT NULL,
1542 KEY `borrowernumber` (`borrowernumber`),
1543 KEY `biblionumber` (`biblionumber`),
1544 KEY `itemnumber` (`itemnumber`),
1545 KEY `branchcode` (`branchcode`),
1546 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1547 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1548 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1549 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1550 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1553 -- Table structure for table `reviews`
1556 DROP TABLE IF EXISTS `reviews`;
1557 CREATE TABLE `reviews` (
1558 `reviewid` int(11) NOT NULL auto_increment,
1559 `borrowernumber` int(11) default NULL,
1560 `biblionumber` int(11) default NULL,
1562 `approved` tinyint(4) default NULL,
1563 `datereviewed` datetime default NULL,
1564 PRIMARY KEY (`reviewid`)
1565 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1568 -- Table structure for table `roadtype`
1571 DROP TABLE IF EXISTS `roadtype`;
1572 CREATE TABLE `roadtype` (
1573 `roadtypeid` int(11) NOT NULL auto_increment,
1574 `road_type` varchar(100) NOT NULL default '',
1575 PRIMARY KEY (`roadtypeid`)
1576 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1579 -- Table structure for table `saved_sql`
1582 DROP TABLE IF EXISTS `saved_sql`;
1583 CREATE TABLE saved_sql (
1584 `id` int(11) NOT NULL auto_increment,
1585 `borrowernumber` int(11) default NULL,
1586 `date_created` datetime default NULL,
1587 `last_modified` datetime default NULL,
1589 `last_run` datetime default NULL,
1590 `report_name` varchar(255) default NULL,
1591 `type` varchar(255) default NULL,
1594 KEY boridx (`borrowernumber`)
1595 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1599 -- Table structure for `saved_reports`
1602 DROP TABLE IF EXISTS `saved_reports`;
1603 CREATE TABLE saved_reports (
1604 `id` int(11) NOT NULL auto_increment,
1605 `report_id` int(11) default NULL,
1607 `date_run` datetime default NULL,
1609 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1613 -- Table structure for table `search_history`
1616 DROP TABLE IF EXISTS `search_history`;
1617 CREATE TABLE IF NOT EXISTS `search_history` (
1618 `userid` int(11) NOT NULL,
1619 `sessionid` varchar(32) NOT NULL,
1620 `query_desc` varchar(255) NOT NULL,
1621 `query_cgi` varchar(255) NOT NULL,
1622 `total` int(11) NOT NULL,
1623 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1624 KEY `userid` (`userid`),
1625 KEY `sessionid` (`sessionid`)
1626 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results';
1630 -- Table structure for table `serial`
1633 DROP TABLE IF EXISTS `serial`;
1634 CREATE TABLE `serial` (
1635 `serialid` int(11) NOT NULL auto_increment,
1636 `biblionumber` varchar(100) NOT NULL default '',
1637 `subscriptionid` varchar(100) NOT NULL default '',
1638 `serialseq` varchar(100) NOT NULL default '',
1639 `status` tinyint(4) NOT NULL default 0,
1640 `planneddate` date default NULL,
1642 `publisheddate` date default NULL,
1643 `itemnumber` text default NULL,
1644 `claimdate` date default NULL,
1645 `routingnotes` text,
1646 PRIMARY KEY (`serialid`)
1647 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1650 -- Table structure for table `sessions`
1653 DROP TABLE IF EXISTS sessions;
1654 CREATE TABLE sessions (
1655 `id` varchar(32) NOT NULL,
1656 `a_session` text NOT NULL,
1658 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1661 -- Table structure for table `special_holidays`
1664 DROP TABLE IF EXISTS `special_holidays`;
1665 CREATE TABLE `special_holidays` (
1666 `id` int(11) NOT NULL auto_increment,
1667 `branchcode` varchar(10) NOT NULL default '',
1668 `day` smallint(6) NOT NULL default 0,
1669 `month` smallint(6) NOT NULL default 0,
1670 `year` smallint(6) NOT NULL default 0,
1671 `isexception` smallint(1) NOT NULL default 1,
1672 `title` varchar(50) NOT NULL default '',
1673 `description` text NOT NULL,
1675 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1678 -- Table structure for table `statistics`
1681 DROP TABLE IF EXISTS `statistics`;
1682 CREATE TABLE `statistics` (
1683 `datetime` datetime default NULL,
1684 `branch` varchar(10) default NULL,
1685 `proccode` varchar(4) default NULL,
1686 `value` double(16,4) default NULL,
1687 `type` varchar(16) default NULL,
1689 `usercode` varchar(10) default NULL,
1690 `itemnumber` int(11) default NULL,
1691 `itemtype` varchar(10) default NULL,
1692 `borrowernumber` int(11) default NULL,
1693 `associatedborrower` int(11) default NULL,
1694 KEY `timeidx` (`datetime`)
1695 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1698 -- Table structure for table `stopwords`
1701 DROP TABLE IF EXISTS `stopwords`;
1702 CREATE TABLE `stopwords` (
1703 `word` varchar(255) default NULL
1704 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1707 -- Table structure for table `subscription`
1710 DROP TABLE IF EXISTS `subscription`;
1711 CREATE TABLE `subscription` (
1712 `biblionumber` int(11) NOT NULL default 0,
1713 `subscriptionid` int(11) NOT NULL auto_increment,
1714 `librarian` varchar(100) default '',
1715 `startdate` date default NULL,
1716 `aqbooksellerid` int(11) default 0,
1717 `cost` int(11) default 0,
1718 `aqbudgetid` int(11) default 0,
1719 `weeklength` int(11) default 0,
1720 `monthlength` int(11) default 0,
1721 `numberlength` int(11) default 0,
1722 `periodicity` tinyint(4) default 0,
1723 `dow` varchar(100) default '',
1724 `numberingmethod` varchar(100) default '',
1726 `status` varchar(100) NOT NULL default '',
1727 `add1` int(11) default 0,
1728 `every1` int(11) default 0,
1729 `whenmorethan1` int(11) default 0,
1730 `setto1` int(11) default NULL,
1731 `lastvalue1` int(11) default NULL,
1732 `add2` int(11) default 0,
1733 `every2` int(11) default 0,
1734 `whenmorethan2` int(11) default 0,
1735 `setto2` int(11) default NULL,
1736 `lastvalue2` int(11) default NULL,
1737 `add3` int(11) default 0,
1738 `every3` int(11) default 0,
1739 `innerloop1` int(11) default 0,
1740 `innerloop2` int(11) default 0,
1741 `innerloop3` int(11) default 0,
1742 `whenmorethan3` int(11) default 0,
1743 `setto3` int(11) default NULL,
1744 `lastvalue3` int(11) default NULL,
1745 `issuesatonce` tinyint(3) NOT NULL default 1,
1746 `firstacquidate` date default NULL,
1747 `manualhistory` tinyint(1) NOT NULL default 0,
1748 `irregularity` text,
1749 `letter` varchar(20) default NULL,
1750 `numberpattern` tinyint(3) default 0,
1751 `distributedto` text,
1752 `internalnotes` longtext,
1754 `location` varchar(80) NULL default '',
1755 `branchcode` varchar(10) NOT NULL default '',
1756 `hemisphere` tinyint(3) default 0,
1757 `lastbranch` varchar(10),
1758 `serialsadditems` tinyint(1) NOT NULL default '0',
1759 `staffdisplaycount` VARCHAR(10) NULL,
1760 `opacdisplaycount` VARCHAR(10) NULL,
1761 `graceperiod` int(11) NOT NULL default '0',
1762 `enddate` date default NULL,
1763 PRIMARY KEY (`subscriptionid`)
1764 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1767 -- Table structure for table `subscriptionhistory`
1770 DROP TABLE IF EXISTS `subscriptionhistory`;
1771 CREATE TABLE `subscriptionhistory` (
1772 `biblionumber` int(11) NOT NULL default 0,
1773 `subscriptionid` int(11) NOT NULL default 0,
1774 `histstartdate` date default NULL,
1775 `histenddate` date default NULL,
1776 `missinglist` longtext NOT NULL,
1777 `recievedlist` longtext NOT NULL,
1778 `opacnote` varchar(150) NOT NULL default '',
1779 `librariannote` varchar(150) NOT NULL default '',
1780 PRIMARY KEY (`subscriptionid`),
1781 KEY `biblionumber` (`biblionumber`)
1782 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1785 -- Table structure for table `subscriptionroutinglist`
1788 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1789 CREATE TABLE `subscriptionroutinglist` (
1790 `routingid` int(11) NOT NULL auto_increment,
1791 `borrowernumber` int(11) default NULL,
1792 `ranking` int(11) default NULL,
1793 `subscriptionid` int(11) default NULL,
1794 PRIMARY KEY (`routingid`)
1795 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1798 -- Table structure for table `suggestions`
1801 DROP TABLE IF EXISTS `suggestions`;
1802 CREATE TABLE `suggestions` (
1803 `suggestionid` int(8) NOT NULL auto_increment,
1804 `suggestedby` int(11) NOT NULL default 0,
1805 `suggesteddate` date NOT NULL default 0,
1806 `managedby` int(11) default NULL,
1807 `manageddate` date default NULL,
1808 acceptedby INT(11) default NULL,
1809 accepteddate date default NULL,
1810 rejectedby INT(11) default NULL,
1811 rejecteddate date default NULL,
1812 `STATUS` varchar(10) NOT NULL default '',
1814 `author` varchar(80) default NULL,
1815 `title` varchar(80) default NULL,
1816 `copyrightdate` smallint(6) default NULL,
1817 `publishercode` varchar(255) default NULL,
1818 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1819 `volumedesc` varchar(255) default NULL,
1820 `publicationyear` smallint(6) default 0,
1821 `place` varchar(255) default NULL,
1822 `isbn` varchar(30) default NULL,
1823 `mailoverseeing` smallint(1) default 0,
1824 `biblionumber` int(11) default NULL,
1827 branchcode VARCHAR(10) default NULL,
1828 collectiontitle text default NULL,
1829 itemtype VARCHAR(30) default NULL,
1830 PRIMARY KEY (`suggestionid`),
1831 KEY `suggestedby` (`suggestedby`),
1832 KEY `managedby` (`managedby`)
1833 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1836 -- Table structure for table `systempreferences`
1839 DROP TABLE IF EXISTS `systempreferences`;
1840 CREATE TABLE `systempreferences` (
1841 `variable` varchar(50) NOT NULL default '',
1843 `options` mediumtext,
1845 `type` varchar(20) default NULL,
1846 PRIMARY KEY (`variable`)
1847 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1850 -- Table structure for table `tags`
1853 DROP TABLE IF EXISTS `tags`;
1854 CREATE TABLE `tags` (
1855 `entry` varchar(255) NOT NULL default '',
1856 `weight` bigint(20) NOT NULL default 0,
1857 PRIMARY KEY (`entry`)
1858 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1861 -- Table structure for table `tags_all`
1864 DROP TABLE IF EXISTS `tags_all`;
1865 CREATE TABLE `tags_all` (
1866 `tag_id` int(11) NOT NULL auto_increment,
1867 `borrowernumber` int(11) NOT NULL,
1868 `biblionumber` int(11) NOT NULL,
1869 `term` varchar(255) NOT NULL,
1870 `language` int(4) default NULL,
1871 `date_created` datetime NOT NULL,
1872 PRIMARY KEY (`tag_id`),
1873 KEY `tags_borrowers_fk_1` (`borrowernumber`),
1874 KEY `tags_biblionumber_fk_1` (`biblionumber`),
1875 CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`)
1876 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1877 CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1878 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1879 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1882 -- Table structure for table `tags_approval`
1885 DROP TABLE IF EXISTS `tags_approval`;
1886 CREATE TABLE `tags_approval` (
1887 `term` varchar(255) NOT NULL,
1888 `approved` int(1) NOT NULL default '0',
1889 `date_approved` datetime default NULL,
1890 `approved_by` int(11) default NULL,
1891 `weight_total` int(9) NOT NULL default '1',
1892 PRIMARY KEY (`term`),
1893 KEY `tags_approval_borrowers_fk_1` (`approved_by`),
1894 CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`)
1895 REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1896 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1899 -- Table structure for table `tags_index`
1902 DROP TABLE IF EXISTS `tags_index`;
1903 CREATE TABLE `tags_index` (
1904 `term` varchar(255) NOT NULL,
1905 `biblionumber` int(11) NOT NULL,
1906 `weight` int(9) NOT NULL default '1',
1907 PRIMARY KEY (`term`,`biblionumber`),
1908 KEY `tags_index_biblionumber_fk_1` (`biblionumber`),
1909 CONSTRAINT `tags_index_term_fk_1` FOREIGN KEY (`term`)
1910 REFERENCES `tags_approval` (`term`) ON DELETE CASCADE ON UPDATE CASCADE,
1911 CONSTRAINT `tags_index_biblionumber_fk_1` FOREIGN KEY (`biblionumber`)
1912 REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1913 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1916 -- Table structure for table `userflags`
1919 DROP TABLE IF EXISTS `userflags`;
1920 CREATE TABLE `userflags` (
1921 `bit` int(11) NOT NULL default 0,
1922 `flag` varchar(30) default NULL,
1923 `flagdesc` varchar(255) default NULL,
1924 `defaulton` int(11) default NULL,
1926 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1929 -- Table structure for table `virtualshelves`
1932 DROP TABLE IF EXISTS `virtualshelves`;
1933 CREATE TABLE `virtualshelves` (
1934 `shelfnumber` int(11) NOT NULL auto_increment,
1935 `shelfname` varchar(255) default NULL,
1936 `owner` varchar(80) default NULL,
1937 `category` varchar(1) default NULL,
1938 `sortfield` varchar(16) default NULL,
1939 `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1940 PRIMARY KEY (`shelfnumber`)
1941 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1944 -- Table structure for table `virtualshelfcontents`
1947 DROP TABLE IF EXISTS `virtualshelfcontents`;
1948 CREATE TABLE `virtualshelfcontents` (
1949 `shelfnumber` int(11) NOT NULL default 0,
1950 `biblionumber` int(11) NOT NULL default 0,
1951 `flags` int(11) default NULL,
1952 `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1953 KEY `shelfnumber` (`shelfnumber`),
1954 KEY `biblionumber` (`biblionumber`),
1955 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1956 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1957 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1960 -- Table structure for table `z3950servers`
1963 DROP TABLE IF EXISTS `z3950servers`;
1964 CREATE TABLE `z3950servers` (
1965 `host` varchar(255) default NULL,
1966 `port` int(11) default NULL,
1967 `db` varchar(255) default NULL,
1968 `userid` varchar(255) default NULL,
1969 `password` varchar(255) default NULL,
1971 `id` int(11) NOT NULL auto_increment,
1972 `checked` smallint(6) default NULL,
1973 `rank` int(11) default NULL,
1974 `syntax` varchar(80) default NULL,
1976 `position` enum('primary','secondary','') NOT NULL default 'primary',
1977 `type` enum('zed','opensearch') NOT NULL default 'zed',
1978 `encoding` text default NULL,
1979 `description` text NOT NULL,
1981 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1984 -- Table structure for table `zebraqueue`
1987 DROP TABLE IF EXISTS `zebraqueue`;
1988 CREATE TABLE `zebraqueue` (
1989 `id` int(11) NOT NULL auto_increment,
1990 `biblio_auth_number` bigint(20) unsigned NOT NULL default '0',
1991 `operation` char(20) NOT NULL default '',
1992 `server` char(20) NOT NULL default '',
1993 `done` int(11) NOT NULL default '0',
1994 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1996 KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
1997 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1999 DROP TABLE IF EXISTS `services_throttle`;
2000 CREATE TABLE `services_throttle` (
2001 `service_type` varchar(10) NOT NULL default '',
2002 `service_count` varchar(45) default NULL,
2003 PRIMARY KEY (`service_type`)
2004 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2006 -- http://www.w3.org/International/articles/language-tags/
2009 DROP TABLE IF EXISTS language_subtag_registry;
2010 CREATE TABLE language_subtag_registry (
2012 type varchar(25), -- language-script-region-variant-extension-privateuse
2013 description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
2015 id int(11) NOT NULL auto_increment,
2017 KEY `subtag` (`subtag`)
2018 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2020 -- TODO: add suppress_scripts
2021 -- this maps three letter codes defined in iso639.2 back to their
2022 -- two letter equivilents in rfc4646 (LOC maintains iso639+)
2023 DROP TABLE IF EXISTS language_rfc4646_to_iso639;
2024 CREATE TABLE language_rfc4646_to_iso639 (
2025 rfc4646_subtag varchar(25),
2026 iso639_2_code varchar(25),
2027 id int(11) NOT NULL auto_increment,
2029 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2030 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2032 DROP TABLE IF EXISTS language_descriptions;
2033 CREATE TABLE language_descriptions (
2037 description varchar(255),
2038 id int(11) NOT NULL auto_increment,
2040 KEY `lang` (`lang`),
2041 KEY `subtag_type_lang` (`subtag`, `type`, `lang`)
2042 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2044 -- bi-directional support, keyed by script subcode
2045 DROP TABLE IF EXISTS language_script_bidi;
2046 CREATE TABLE language_script_bidi (
2047 rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
2048 bidi varchar(3), -- rtl ltr
2049 KEY `rfc4646_subtag` (`rfc4646_subtag`)
2050 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2052 -- TODO: need to map language subtags to script subtags for detection
2053 -- of bidi when script is not specified (like ar, he)
2054 DROP TABLE IF EXISTS language_script_mapping;
2055 CREATE TABLE language_script_mapping (
2056 language_subtag varchar(25),
2057 script_subtag varchar(25),
2058 KEY `language_subtag` (`language_subtag`)
2059 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2061 DROP TABLE IF EXISTS `permissions`;
2062 CREATE TABLE `permissions` (
2063 `module_bit` int(11) NOT NULL DEFAULT 0,
2064 `code` varchar(64) DEFAULT NULL,
2065 `description` varchar(255) DEFAULT NULL,
2066 PRIMARY KEY (`module_bit`, `code`),
2067 CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `userflags` (`bit`)
2068 ON DELETE CASCADE ON UPDATE CASCADE
2069 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2071 DROP TABLE IF EXISTS `serialitems`;
2072 CREATE TABLE `serialitems` (
2073 `itemnumber` int(11) NOT NULL,
2074 `serialid` int(11) NOT NULL,
2075 UNIQUE KEY `serialitemsidx` (`itemnumber`),
2076 KEY `serialitems_sfk_1` (`serialid`),
2077 CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2078 CONSTRAINT serialitems_sfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE
2079 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2081 DROP TABLE IF EXISTS `user_permissions`;
2082 CREATE TABLE `user_permissions` (
2083 `borrowernumber` int(11) NOT NULL DEFAULT 0,
2084 `module_bit` int(11) NOT NULL DEFAULT 0,
2085 `code` varchar(64) DEFAULT NULL,
2086 CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
2087 ON DELETE CASCADE ON UPDATE CASCADE,
2088 CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY (`module_bit`, `code`) REFERENCES `permissions` (`module_bit`, `code`)
2089 ON DELETE CASCADE ON UPDATE CASCADE
2090 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2093 -- Table structure for table `tmp_holdsqueue`
2096 DROP TABLE IF EXISTS `tmp_holdsqueue`;
2097 CREATE TABLE `tmp_holdsqueue` (
2098 `biblionumber` int(11) default NULL,
2099 `itemnumber` int(11) default NULL,
2100 `barcode` varchar(20) default NULL,
2101 `surname` mediumtext NOT NULL,
2104 `borrowernumber` int(11) NOT NULL,
2105 `cardnumber` varchar(16) default NULL,
2106 `reservedate` date default NULL,
2108 `itemcallnumber` varchar(255) default NULL,
2109 `holdingbranch` varchar(10) default NULL,
2110 `pickbranch` varchar(10) default NULL,
2112 `item_level_request` tinyint(4) NOT NULL default 0
2113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2116 -- Table structure for table `message_queue`
2119 DROP TABLE IF EXISTS `message_queue`;
2120 CREATE TABLE `message_queue` (
2121 `message_id` int(11) NOT NULL auto_increment,
2122 `borrowernumber` int(11) default NULL,
2125 `metadata` text DEFAULT NULL,
2126 `letter_code` varchar(64) DEFAULT NULL,
2127 `message_transport_type` varchar(20) NOT NULL,
2128 `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2129 `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2130 `to_address` mediumtext,
2131 `from_address` mediumtext,
2132 `content_type` text,
2133 KEY `message_id` (`message_id`),
2134 KEY `borrowernumber` (`borrowernumber`),
2135 KEY `message_transport_type` (`message_transport_type`),
2136 CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2137 CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE RESTRICT ON UPDATE CASCADE
2138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2141 -- Table structure for table `message_transport_types`
2144 DROP TABLE IF EXISTS `message_transport_types`;
2145 CREATE TABLE `message_transport_types` (
2146 `message_transport_type` varchar(20) NOT NULL,
2147 PRIMARY KEY (`message_transport_type`)
2148 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2151 -- Table structure for table `message_attributes`
2154 DROP TABLE IF EXISTS `message_attributes`;
2155 CREATE TABLE `message_attributes` (
2156 `message_attribute_id` int(11) NOT NULL auto_increment,
2157 `message_name` varchar(20) NOT NULL default '',
2158 `takes_days` tinyint(1) NOT NULL default '0',
2159 PRIMARY KEY (`message_attribute_id`),
2160 UNIQUE KEY `message_name` (`message_name`)
2161 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2164 -- Table structure for table `message_transports`
2167 DROP TABLE IF EXISTS `message_transports`;
2168 CREATE TABLE `message_transports` (
2169 `message_attribute_id` int(11) NOT NULL,
2170 `message_transport_type` varchar(20) NOT NULL,
2171 `is_digest` tinyint(1) NOT NULL default '0',
2172 `letter_module` varchar(20) NOT NULL default '',
2173 `letter_code` varchar(20) NOT NULL default '',
2174 PRIMARY KEY (`message_attribute_id`,`message_transport_type`,`is_digest`),
2175 KEY `message_transport_type` (`message_transport_type`),
2176 KEY `letter_module` (`letter_module`,`letter_code`),
2177 CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2178 CONSTRAINT `message_transports_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
2179 CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`) REFERENCES `letter` (`module`, `code`) ON DELETE CASCADE ON UPDATE CASCADE
2180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2183 -- Table structure for table `borrower_message_preferences`
2186 DROP TABLE IF EXISTS `borrower_message_preferences`;
2187 CREATE TABLE `borrower_message_preferences` (
2188 `borrower_message_preference_id` int(11) NOT NULL auto_increment,
2189 `borrowernumber` int(11) default NULL,
2190 `categorycode` varchar(10) default NULL,
2191 `message_attribute_id` int(11) default '0',
2192 `days_in_advance` int(11) default '0',
2193 `wants_digest` tinyint(1) NOT NULL default '0',
2194 PRIMARY KEY (`borrower_message_preference_id`),
2195 KEY `borrowernumber` (`borrowernumber`),
2196 KEY `categorycode` (`categorycode`),
2197 KEY `message_attribute_id` (`message_attribute_id`),
2198 CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2199 CONSTRAINT `borrower_message_preferences_ibfk_2` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2200 CONSTRAINT `borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
2201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2204 -- Table structure for table `borrower_message_transport_preferences`
2207 DROP TABLE IF EXISTS `borrower_message_transport_preferences`;
2208 CREATE TABLE `borrower_message_transport_preferences` (
2209 `borrower_message_preference_id` int(11) NOT NULL default '0',
2210 `message_transport_type` varchar(20) NOT NULL default '0',
2211 PRIMARY KEY (`borrower_message_preference_id`,`message_transport_type`),
2212 KEY `message_transport_type` (`message_transport_type`),
2213 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,
2214 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
2215 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2218 -- Table structure for the table branch_transfer_limits
2221 DROP TABLE IF EXISTS `branch_transfer_limits`;
2222 CREATE TABLE branch_transfer_limits (
2223 limitId int(8) NOT NULL auto_increment,
2224 toBranch varchar(10) NOT NULL,
2225 fromBranch varchar(10) NOT NULL,
2226 itemtype varchar(10) NULL,
2227 ccode varchar(10) NULL,
2228 PRIMARY KEY (limitId)
2229 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2232 -- Table structure for table `item_circulation_alert_preferences`
2235 DROP TABLE IF EXISTS `item_circulation_alert_preferences`;
2236 CREATE TABLE `item_circulation_alert_preferences` (
2237 `id` int(11) NOT NULL auto_increment,
2238 `branchcode` varchar(10) NOT NULL,
2239 `categorycode` varchar(10) NOT NULL,
2240 `item_type` varchar(10) NOT NULL,
2241 `notification` varchar(16) NOT NULL,
2243 KEY `branchcode` (`branchcode`,`categorycode`,`item_type`, `notification`)
2244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2247 -- Table structure for table `messages`
2249 DROP TABLE IF EXISTS `messages`;
2250 CREATE TABLE `messages` (
2251 `message_id` int(11) NOT NULL auto_increment,
2252 `borrowernumber` int(11) NOT NULL,
2253 `branchcode` varchar(10) default NULL,
2254 `message_type` varchar(1) NOT NULL,
2255 `message` text NOT NULL,
2256 `message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
2257 PRIMARY KEY (`message_id`)
2258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2261 -- Table structure for table `accountlines`
2264 DROP TABLE IF EXISTS `accountlines`;
2265 CREATE TABLE `accountlines` (
2266 `borrowernumber` int(11) NOT NULL default 0,
2267 `accountno` smallint(6) NOT NULL default 0,
2268 `itemnumber` int(11) default NULL,
2269 `date` date default NULL,
2270 `amount` decimal(28,6) default NULL,
2271 `description` mediumtext,
2272 `dispute` mediumtext,
2273 `accounttype` varchar(5) default NULL,
2274 `amountoutstanding` decimal(28,6) default NULL,
2275 `lastincrement` decimal(28,6) default NULL,
2276 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2277 `notify_id` int(11) NOT NULL default 0,
2278 `notify_level` int(2) NOT NULL default 0,
2279 KEY `acctsborridx` (`borrowernumber`),
2280 KEY `timeidx` (`timestamp`),
2281 KEY `itemnumber` (`itemnumber`),
2282 CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2283 CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2284 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2287 -- Table structure for table `accountoffsets`
2290 DROP TABLE IF EXISTS `accountoffsets`;
2291 CREATE TABLE `accountoffsets` (
2292 `borrowernumber` int(11) NOT NULL default 0,
2293 `accountno` smallint(6) NOT NULL default 0,
2294 `offsetaccount` smallint(6) NOT NULL default 0,
2295 `offsetamount` decimal(28,6) default NULL,
2296 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2297 CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2298 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2301 -- Table structure for table `action_logs`
2304 DROP TABLE IF EXISTS `action_logs`;
2305 CREATE TABLE `action_logs` (
2306 `action_id` int(11) NOT NULL auto_increment,
2307 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2308 `user` int(11) NOT NULL default 0,
2311 `object` int(11) default NULL,
2313 PRIMARY KEY (`action_id`),
2314 KEY (`timestamp`,`user`)
2315 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2318 -- Table structure for table `alert`
2321 DROP TABLE IF EXISTS `alert`;
2322 CREATE TABLE `alert` (
2323 `alertid` int(11) NOT NULL auto_increment,
2324 `borrowernumber` int(11) NOT NULL default 0,
2325 `type` varchar(10) NOT NULL default '',
2326 `externalid` varchar(20) NOT NULL default '',
2327 PRIMARY KEY (`alertid`),
2328 KEY `borrowernumber` (`borrowernumber`),
2329 KEY `type` (`type`,`externalid`)
2330 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2333 -- Table structure for table `aqbasketgroups`
2336 DROP TABLE IF EXISTS `aqbasketgroups`;
2337 CREATE TABLE `aqbasketgroups` (
2338 `id` int(11) NOT NULL auto_increment,
2339 `name` varchar(50) default NULL,
2340 `closed` tinyint(1) default NULL,
2341 `booksellerid` int(11) NOT NULL,
2343 KEY `booksellerid` (`booksellerid`),
2344 CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
2345 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2348 -- Table structure for table `aqbasket`
2351 DROP TABLE IF EXISTS `aqbasket`;
2352 CREATE TABLE `aqbasket` (
2353 `basketno` int(11) NOT NULL auto_increment,
2354 `basketname` varchar(50) default NULL,
2356 `booksellernote` mediumtext,
2357 `contractnumber` int(11),
2358 `creationdate` date default NULL,
2359 `closedate` date default NULL,
2360 `booksellerid` int(11) NOT NULL default 1,
2361 `authorisedby` varchar(10) default NULL,
2362 `booksellerinvoicenumber` mediumtext,
2363 `basketgroupid` int(11),
2364 PRIMARY KEY (`basketno`),
2365 KEY `booksellerid` (`booksellerid`),
2366 KEY `basketgroupid` (`basketgroupid`),
2367 KEY `contractnumber` (`contractnumber`),
2368 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2369 CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2370 CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE
2371 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2374 -- Table structure for table `aqbooksellers`
2377 DROP TABLE IF EXISTS `aqbooksellers`;
2378 CREATE TABLE `aqbooksellers` (
2379 `id` int(11) NOT NULL auto_increment,
2380 `name` mediumtext NOT NULL,
2381 `address1` mediumtext,
2382 `address2` mediumtext,
2383 `address3` mediumtext,
2384 `address4` mediumtext,
2385 `phone` varchar(30) default NULL,
2386 `accountnumber` mediumtext,
2387 `othersupplier` mediumtext,
2388 `currency` varchar(3) NOT NULL default '',
2389 `booksellerfax` mediumtext,
2391 `bookselleremail` mediumtext,
2392 `booksellerurl` mediumtext,
2393 `contact` varchar(100) default NULL,
2394 `postal` mediumtext,
2395 `url` varchar(255) default NULL,
2396 `contpos` varchar(100) default NULL,
2397 `contphone` varchar(100) default NULL,
2398 `contfax` varchar(100) default NULL,
2399 `contaltphone` varchar(100) default NULL,
2400 `contemail` varchar(100) default NULL,
2401 `contnotes` mediumtext,
2402 `active` tinyint(4) default NULL,
2403 `listprice` varchar(10) default NULL,
2404 `invoiceprice` varchar(10) default NULL,
2405 `gstreg` tinyint(4) default NULL,
2406 `listincgst` tinyint(4) default NULL,
2407 `invoiceincgst` tinyint(4) default NULL,
2408 `gstrate` decimal(6,4) default NULL,
2409 `discount` float(6,4) default NULL,
2410 `fax` varchar(50) default NULL,
2412 KEY `listprice` (`listprice`),
2413 KEY `invoiceprice` (`invoiceprice`),
2414 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2415 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2416 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2419 -- Table structure for table `aqbudgets`
2422 DROP TABLE IF EXISTS `aqbudgets`;
2423 CREATE TABLE `aqbudgets` (
2424 `budget_id` int(11) NOT NULL auto_increment,
2425 `budget_parent_id` int(11) default NULL,
2426 `budget_code` varchar(30) default NULL,
2427 `budget_name` varchar(80) default NULL,
2428 `budget_branchcode` varchar(10) default NULL,
2429 `budget_amount` decimal(28,6) NULL default '0.00',
2430 `budget_encumb` decimal(28,6) NULL default '0.00',
2431 `budget_expend` decimal(28,6) NULL default '0.00',
2432 `budget_notes` mediumtext,
2433 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2434 `budget_period_id` int(11) default NULL,
2435 `sort1_authcat` varchar(80) default NULL,
2436 `sort2_authcat` varchar(80) default NULL,
2437 `budget_owner_id` int(11) default NULL,
2438 `budget_permission` int(1) default '0',
2439 PRIMARY KEY (`budget_id`)
2440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2444 -- Table structure for table `aqbudgetperiods`
2448 DROP TABLE IF EXISTS `aqbudgetperiods`;
2449 CREATE TABLE `aqbudgetperiods` (
2450 `budget_period_id` int(11) NOT NULL auto_increment,
2451 `budget_period_startdate` date NOT NULL,
2452 `budget_period_enddate` date NOT NULL,
2453 `budget_period_active` tinyint(1) default '0',
2454 `budget_period_description` mediumtext,
2455 `budget_period_total` decimal(28,6),
2456 `budget_period_locked` tinyint(1) default NULL,
2457 `sort1_authcat` varchar(10) default NULL,
2458 `sort2_authcat` varchar(10) default NULL,
2459 PRIMARY KEY (`budget_period_id`)
2460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2463 -- Table structure for table `aqbudgets_planning`
2466 DROP TABLE IF EXISTS `aqbudgets_planning`;
2467 CREATE TABLE `aqbudgets_planning` (
2468 `plan_id` int(11) NOT NULL auto_increment,
2469 `budget_id` int(11) NOT NULL,
2470 `budget_period_id` int(11) NOT NULL,
2471 `estimated_amount` decimal(28,6) default NULL,
2472 `authcat` varchar(30) NOT NULL,
2473 `authvalue` varchar(30) NOT NULL,
2474 `display` tinyint(1) DEFAULT 1,
2475 PRIMARY KEY (`plan_id`),
2476 CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2480 -- Table structure for table 'aqcontract'
2483 DROP TABLE IF EXISTS `aqcontract`;
2484 CREATE TABLE `aqcontract` (
2485 `contractnumber` int(11) NOT NULL auto_increment,
2486 `contractstartdate` date default NULL,
2487 `contractenddate` date default NULL,
2488 `contractname` varchar(50) default NULL,
2489 `contractdescription` mediumtext,
2490 `booksellerid` int(11) not NULL,
2491 PRIMARY KEY (`contractnumber`),
2492 CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2493 REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2494 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2497 -- Table structure for table `aqorderdelivery`
2500 DROP TABLE IF EXISTS `aqorderdelivery`;
2501 CREATE TABLE `aqorderdelivery` (
2502 `ordernumber` date default NULL,
2503 `deliverynumber` smallint(6) NOT NULL default 0,
2504 `deliverydate` varchar(18) default NULL,
2505 `qtydelivered` smallint(6) default NULL,
2506 `deliverycomments` mediumtext
2507 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2510 -- Table structure for table `aqorders`
2513 DROP TABLE IF EXISTS `aqorders`;
2514 CREATE TABLE `aqorders` (
2515 `ordernumber` int(11) NOT NULL auto_increment,
2516 `biblionumber` int(11) default NULL,
2517 `entrydate` date default NULL,
2518 `quantity` smallint(6) default NULL,
2519 `currency` varchar(3) default NULL,
2520 `listprice` decimal(28,6) default NULL,
2521 `totalamount` decimal(28,6) default NULL,
2522 `datereceived` date default NULL,
2523 `booksellerinvoicenumber` mediumtext,
2524 `freight` decimal(28,6) default NULL,
2525 `unitprice` decimal(28,6) default NULL,
2526 `quantityreceived` smallint(6) NOT NULL default 0,
2527 `cancelledby` varchar(10) default NULL,
2528 `datecancellationprinted` date default NULL,
2530 `supplierreference` mediumtext,
2531 `purchaseordernumber` mediumtext,
2532 `subscription` tinyint(1) default NULL,
2533 `serialid` varchar(30) default NULL,
2534 `basketno` int(11) default NULL,
2535 `biblioitemnumber` int(11) default NULL,
2536 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2537 `rrp` decimal(13,2) default NULL,
2538 `ecost` decimal(13,2) default NULL,
2539 `gst` decimal(13,2) default NULL,
2540 `budget_id` int(11) NOT NULL,
2541 `budgetgroup_id` int(11) NOT NULL,
2542 `budgetdate` date default NULL,
2543 `sort1` varchar(80) default NULL,
2544 `sort2` varchar(80) default NULL,
2545 `sort1_authcat` varchar(10) default NULL,
2546 `sort2_authcat` varchar(10) default NULL,
2547 `uncertainprice` tinyint(1),
2548 PRIMARY KEY (`ordernumber`),
2549 KEY `basketno` (`basketno`),
2550 KEY `biblionumber` (`biblionumber`),
2551 KEY `budget_id` (`budget_id`),
2552 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2553 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2554 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2558 -- Table structure for table `aqorders_items`
2561 DROP TABLE IF EXISTS `aqorders_items`;
2562 CREATE TABLE `aqorders_items` (
2563 `ordernumber` int(11) NOT NULL,
2564 `itemnumber` int(11) NOT NULL,
2565 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2566 PRIMARY KEY (`itemnumber`),
2567 KEY `ordernumber` (`ordernumber`)
2568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2571 -- Table structure for table `fieldmapping`
2574 DROP TABLE IF EXISTS `fieldmapping`;
2575 CREATE TABLE `fieldmapping` (
2576 `id` int(11) NOT NULL auto_increment,
2577 `field` varchar(255) NOT NULL,
2578 `frameworkcode` char(4) NOT NULL default '',
2579 `fieldcode` char(3) NOT NULL,
2580 `subfieldcode` char(1) NOT NULL,
2582 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2585 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2586 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2587 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2588 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2589 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2590 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2591 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2592 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;