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 `accountlines`
22 DROP TABLE IF EXISTS `accountlines`;
23 CREATE TABLE `accountlines` (
24 `borrowernumber` int(11) NOT NULL default 0,
25 `accountno` smallint(6) NOT NULL default 0,
26 `itemnumber` int(11) default NULL,
27 `date` date default NULL,
28 `amount` decimal(28,6) default NULL,
29 `description` mediumtext,
31 `accounttype` varchar(5) default NULL,
32 `amountoutstanding` decimal(28,6) default NULL,
33 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
34 `notify_id` int(11) NOT NULL default 0,
35 `notify_level` int(2) NOT NULL default 0,
36 KEY `acctsborridx` (`borrowernumber`),
37 KEY `timeidx` (`timestamp`),
38 KEY `itemnumber` (`itemnumber`),
39 CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
40 CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44 -- Table structure for table `accountoffsets`
47 DROP TABLE IF EXISTS `accountoffsets`;
48 CREATE TABLE `accountoffsets` (
49 `borrowernumber` int(11) NOT NULL default 0,
50 `accountno` smallint(6) NOT NULL default 0,
51 `offsetaccount` smallint(6) NOT NULL default 0,
52 `offsetamount` decimal(28,6) default NULL,
53 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57 -- Table structure for table `action_logs`
60 DROP TABLE IF EXISTS `action_logs`;
61 CREATE TABLE `action_logs` (
62 `action_id` int(11) NOT NULL auto_increment,
63 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
64 `user` int(11) NOT NULL default 0,
67 `object` int(11) default NULL,
69 PRIMARY KEY (`action_id`),
70 KEY (`timestamp`,`user`)
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74 -- Table structure for table `alert`
77 DROP TABLE IF EXISTS `alert`;
78 CREATE TABLE `alert` (
79 `alertid` int(11) NOT NULL auto_increment,
80 `borrowernumber` int(11) NOT NULL default 0,
81 `type` varchar(10) NOT NULL default '',
82 `externalid` varchar(20) NOT NULL default '',
83 PRIMARY KEY (`alertid`),
84 KEY `borrowernumber` (`borrowernumber`),
85 KEY `type` (`type`,`externalid`)
86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
89 -- Table structure for table `aqbasket`
92 DROP TABLE IF EXISTS `aqbasket`;
93 CREATE TABLE `aqbasket` (
94 `basketno` int(11) NOT NULL auto_increment,
95 `creationdate` date default NULL,
96 `closedate` date default NULL,
97 `booksellerid` int(11) NOT NULL default 1,
98 `authorisedby` varchar(10) default NULL,
99 `booksellerinvoicenumber` mediumtext,
100 PRIMARY KEY (`basketno`),
101 KEY `booksellerid` (`booksellerid`),
102 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE
103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
106 -- Table structure for table `aqbookfund`
109 DROP TABLE IF EXISTS `aqbookfund`;
110 CREATE TABLE `aqbookfund` (
111 `bookfundid` varchar(10) NOT NULL default '',
112 `bookfundname` mediumtext,
113 `bookfundgroup` varchar(5) default NULL,
114 `branchcode` varchar(10) NOT NULL default '',
115 PRIMARY KEY (`bookfundid`,`branchcode`)
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119 -- Table structure for table `aqbooksellers`
122 DROP TABLE IF EXISTS `aqbooksellers`;
123 CREATE TABLE `aqbooksellers` (
124 `id` int(11) NOT NULL auto_increment,
126 `address1` mediumtext,
127 `address2` mediumtext,
128 `address3` mediumtext,
129 `address4` mediumtext,
130 `phone` varchar(30) default NULL,
131 `accountnumber` mediumtext,
132 `othersupplier` mediumtext,
133 `currency` varchar(3) NOT NULL default '',
134 `deliverydays` smallint(6) default NULL,
135 `followupdays` smallint(6) default NULL,
136 `followupscancel` smallint(6) default NULL,
137 `specialty` mediumtext,
138 `booksellerfax` mediumtext,
140 `bookselleremail` mediumtext,
141 `booksellerurl` mediumtext,
142 `contact` varchar(100) default NULL,
144 `url` varchar(255) default NULL,
145 `contpos` varchar(100) default NULL,
146 `contphone` varchar(100) default NULL,
147 `contfax` varchar(100) default NULL,
148 `contaltphone` varchar(100) default NULL,
149 `contemail` varchar(100) default NULL,
150 `contnotes` mediumtext,
151 `active` tinyint(4) default NULL,
152 `listprice` varchar(10) default NULL,
153 `invoiceprice` varchar(10) default NULL,
154 `gstreg` tinyint(4) default NULL,
155 `listincgst` tinyint(4) default NULL,
156 `invoiceincgst` tinyint(4) default NULL,
157 `discount` float(6,4) default NULL,
158 `fax` varchar(50) default NULL,
159 `nocalc` int(11) default NULL,
160 `invoicedisc` float(6,4) default NULL,
162 KEY `listprice` (`listprice`),
163 KEY `invoiceprice` (`invoiceprice`),
164 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
165 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
169 -- Table structure for table `aqbudget`
172 DROP TABLE IF EXISTS `aqbudget`;
173 CREATE TABLE `aqbudget` (
174 `bookfundid` varchar(10) NOT NULL default '',
175 `startdate` date NOT NULL default 0,
176 `enddate` date default NULL,
177 `budgetamount` decimal(13,2) default NULL,
178 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
179 `branchcode` varchar(10) default NULL,
180 PRIMARY KEY (`aqbudgetid`)
181 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
184 -- Table structure for table `aqorderbreakdown`
187 DROP TABLE IF EXISTS `aqorderbreakdown`;
188 CREATE TABLE `aqorderbreakdown` (
189 `ordernumber` int(11) default NULL,
190 `linenumber` int(11) default NULL,
191 `branchcode` varchar(10) default NULL,
192 `bookfundid` varchar(10) NOT NULL default '',
193 `allocation` smallint(6) default NULL,
194 KEY `ordernumber` (`ordernumber`),
195 KEY `bookfundid` (`bookfundid`),
196 CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
197 CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE
198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
201 -- Table structure for table `aqorderdelivery`
204 DROP TABLE IF EXISTS `aqorderdelivery`;
205 CREATE TABLE `aqorderdelivery` (
206 `ordernumber` date default NULL,
207 `deliverynumber` smallint(6) NOT NULL default 0,
208 `deliverydate` varchar(18) default NULL,
209 `qtydelivered` smallint(6) default NULL,
210 `deliverycomments` mediumtext
211 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
214 -- Table structure for table `aqorders`
217 DROP TABLE IF EXISTS `aqorders`;
218 CREATE TABLE `aqorders` (
219 `ordernumber` int(11) NOT NULL auto_increment,
220 `biblionumber` int(11) default NULL,
222 `entrydate` date default NULL,
223 `quantity` smallint(6) default NULL,
224 `currency` varchar(3) default NULL,
225 `listprice` decimal(28,6) default NULL,
226 `totalamount` decimal(28,6) default NULL,
227 `datereceived` date default NULL,
228 `booksellerinvoicenumber` mediumtext,
229 `freight` decimal(28,6) default NULL,
230 `unitprice` decimal(28,6) default NULL,
231 `quantityreceived` smallint(6) default NULL,
232 `cancelledby` varchar(10) default NULL,
233 `datecancellationprinted` date default NULL,
235 `supplierreference` mediumtext,
236 `purchaseordernumber` mediumtext,
237 `subscription` tinyint(1) default NULL,
238 `serialid` varchar(30) default NULL,
239 `basketno` int(11) default NULL,
240 `biblioitemnumber` int(11) default NULL,
241 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
242 `rrp` decimal(13,2) default NULL,
243 `ecost` decimal(13,2) default NULL,
244 `gst` decimal(13,2) default NULL,
245 `budgetdate` date default NULL,
246 `sort1` varchar(80) default NULL,
247 `sort2` varchar(80) default NULL,
248 PRIMARY KEY (`ordernumber`),
249 KEY `basketno` (`basketno`),
250 KEY `biblionumber` (`biblionumber`),
251 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
252 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL
253 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
256 -- Table structure for table `auth_header`
259 DROP TABLE IF EXISTS `auth_header`;
260 CREATE TABLE `auth_header` (
261 `authid` bigint(20) unsigned NOT NULL auto_increment,
262 `authtypecode` varchar(10) NOT NULL default '',
263 `datecreated` date default NULL,
264 `datemodified` date default NULL,
265 `origincode` varchar(20) default NULL,
266 `authtrees` mediumtext,
268 `linkid` bigint(20) default NULL,
269 `marcxml` longtext NOT NULL,
270 PRIMARY KEY (`authid`),
271 KEY `origincode` (`origincode`)
272 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
275 -- Table structure for table `auth_subfield_structure`
278 DROP TABLE IF EXISTS `auth_subfield_structure`;
279 CREATE TABLE `auth_subfield_structure` (
280 `authtypecode` varchar(10) NOT NULL default '',
281 `tagfield` varchar(3) NOT NULL default '',
282 `tagsubfield` varchar(1) NOT NULL default '',
283 `liblibrarian` varchar(255) NOT NULL default '',
284 `libopac` varchar(255) NOT NULL default '',
285 `repeatable` tinyint(4) NOT NULL default 0,
286 `mandatory` tinyint(4) NOT NULL default 0,
287 `tab` tinyint(1) default NULL,
288 `authorised_value` varchar(10) default NULL,
289 `value_builder` varchar(80) default NULL,
290 `seealso` varchar(255) default NULL,
291 `isurl` tinyint(1) default NULL,
292 `hidden` tinyint(3) NOT NULL default 0,
293 `linkid` tinyint(1) NOT NULL default 0,
294 `kohafield` varchar(45) NULL default '',
295 `frameworkcode` varchar(8) NOT NULL default '',
296 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
297 KEY `tab` (`authtypecode`,`tab`)
298 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301 -- Table structure for table `auth_tag_structure`
304 DROP TABLE IF EXISTS `auth_tag_structure`;
305 CREATE TABLE `auth_tag_structure` (
306 `authtypecode` varchar(10) NOT NULL default '',
307 `tagfield` varchar(3) NOT NULL default '',
308 `liblibrarian` varchar(255) NOT NULL default '',
309 `libopac` varchar(255) NOT NULL default '',
310 `repeatable` tinyint(4) NOT NULL default 0,
311 `mandatory` tinyint(4) NOT NULL default 0,
312 `authorised_value` varchar(10) default NULL,
313 PRIMARY KEY (`authtypecode`,`tagfield`),
314 CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
315 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
318 -- Table structure for table `auth_types`
321 DROP TABLE IF EXISTS `auth_types`;
322 CREATE TABLE `auth_types` (
323 `authtypecode` varchar(10) NOT NULL default '',
324 `authtypetext` varchar(255) NOT NULL default '',
325 `auth_tag_to_report` varchar(3) NOT NULL default '',
326 `summary` mediumtext NOT NULL,
327 PRIMARY KEY (`authtypecode`)
328 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
331 -- Table structure for table `authorised_values`
334 DROP TABLE IF EXISTS `authorised_values`;
335 CREATE TABLE `authorised_values` (
336 `id` int(11) NOT NULL auto_increment,
337 `category` varchar(10) NOT NULL default '',
338 `authorised_value` varchar(80) NOT NULL default '',
339 `lib` varchar(80) default NULL,
341 KEY `name` (`category`)
342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
345 -- Table structure for table `biblio`
348 DROP TABLE IF EXISTS `biblio`;
349 CREATE TABLE `biblio` (
350 `biblionumber` int(11) NOT NULL auto_increment,
351 `frameworkcode` varchar(4) NOT NULL default '',
354 `unititle` mediumtext,
356 `serial` tinyint(1) default NULL,
357 `seriestitle` mediumtext,
358 `copyrightdate` smallint(6) default NULL,
359 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
360 `datecreated` DATE NOT NULL,
361 `abstract` mediumtext,
362 PRIMARY KEY (`biblionumber`),
363 KEY `blbnoidx` (`biblionumber`)
364 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
367 -- Table structure for table `biblio_framework`
370 DROP TABLE IF EXISTS `biblio_framework`;
371 CREATE TABLE `biblio_framework` (
372 `frameworkcode` varchar(4) NOT NULL default '',
373 `frameworktext` varchar(255) NOT NULL default '',
374 PRIMARY KEY (`frameworkcode`)
375 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
378 -- Table structure for table `biblioitems`
381 DROP TABLE IF EXISTS `biblioitems`;
382 CREATE TABLE `biblioitems` (
383 `biblioitemnumber` int(11) NOT NULL auto_increment,
384 `biblionumber` int(11) NOT NULL default 0,
387 `itemtype` varchar(10) default NULL,
388 `isbn` varchar(14) default NULL,
389 `issn` varchar(9) default NULL,
390 `publicationyear` text,
391 `publishercode` varchar(255) default NULL,
392 `volumedate` date default NULL,
394 `collectiontitle` mediumtext default NULL,
395 `collectionissn` text default NULL,
396 `collectionvolume` mediumtext default NULL,
397 `editionstatement` text default NULL,
398 `editionresponsibility` text default NULL,
399 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
400 `illus` varchar(255) default NULL,
401 `pages` varchar(255) default NULL,
403 `size` varchar(255) default NULL,
404 `place` varchar(255) default NULL,
405 `lccn` varchar(25) default NULL,
407 `url` varchar(255) default NULL,
408 `cn_source` varchar(10) default NULL,
409 `cn_class` varchar(30) default NULL,
410 `cn_item` varchar(10) default NULL,
411 `cn_suffix` varchar(10) default NULL,
412 `cn_sort` varchar(30) default NULL,
413 `totalissues` int(10),
414 `marcxml` longtext NOT NULL,
415 PRIMARY KEY (`biblioitemnumber`),
416 KEY `bibinoidx` (`biblioitemnumber`),
417 KEY `bibnoidx` (`biblionumber`),
419 KEY `publishercode` (`publishercode`),
420 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
424 -- Table structure for table `borrowers`
427 DROP TABLE IF EXISTS `borrowers`;
428 CREATE TABLE `borrowers` (
429 `borrowernumber` int(11) NOT NULL auto_increment,
430 `cardnumber` varchar(16) default NULL,
431 `surname` mediumtext NOT NULL,
434 `othernames` mediumtext,
436 `streetnumber` varchar(10) default NULL,
437 `streettype` varchar(50) default NULL,
438 `address` mediumtext NOT NULL,
440 `city` mediumtext NOT NULL,
441 `zipcode` varchar(25) default NULL,
444 `mobile` varchar(50) default NULL,
448 `B_streetnumber` varchar(10) default NULL,
449 `B_streettype` varchar(50) default NULL,
450 `B_address` varchar(100) default NULL,
452 `B_zipcode` varchar(25) default NULL,
454 `B_phone` mediumtext,
455 `dateofbirth` date default NULL,
456 `branchcode` varchar(10) NOT NULL default '',
457 `categorycode` varchar(10) NOT NULL default '',
458 `dateenrolled` date default NULL,
459 `dateexpiry` date default NULL,
460 `gonenoaddress` tinyint(1) default NULL,
461 `lost` tinyint(1) default NULL,
462 `debarred` tinyint(1) default NULL,
463 `contactname` mediumtext,
464 `contactfirstname` text,
466 `guarantorid` int(11) default NULL,
467 `borrowernotes` mediumtext,
468 `relationship` varchar(100) default NULL,
469 `ethnicity` varchar(50) default NULL,
470 `ethnotes` varchar(255) default NULL,
471 `sex` varchar(1) default NULL,
472 `password` varchar(30) default NULL,
473 `flags` int(11) default NULL,
474 `userid` varchar(30) default NULL,
475 `opacnote` mediumtext,
476 `contactnote` varchar(255) default NULL,
477 `sort1` varchar(80) default NULL,
478 `sort2` varchar(80) default NULL,
479 UNIQUE KEY `cardnumber` (`cardnumber`),
480 PRIMARY KEY `borrowernumber` (`borrowernumber`),
481 KEY `categorycode` (`categorycode`),
482 KEY `branchcode` (`branchcode`),
483 KEY `userid` (`userid`),
484 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
485 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
486 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
489 -- Table structure for table `branchcategories`
492 DROP TABLE IF EXISTS `branchcategories`;
493 CREATE TABLE `branchcategories` (
494 `categorycode` varchar(10) NOT NULL default '',
495 `categoryname` varchar(32),
496 `codedescription` mediumtext,
497 `categorytype` varchar(16),
498 PRIMARY KEY (`categorycode`)
499 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
502 -- Table structure for table `branches`
505 DROP TABLE IF EXISTS `branches`;
506 CREATE TABLE `branches` (
507 `branchcode` varchar(10) NOT NULL default '',
508 `branchname` mediumtext NOT NULL,
509 `branchaddress1` mediumtext,
510 `branchaddress2` mediumtext,
511 `branchaddress3` mediumtext,
512 `branchphone` mediumtext,
513 `branchfax` mediumtext,
514 `branchemail` mediumtext,
515 `issuing` tinyint(4) default NULL,
516 `branchip` varchar(15) default NULL,
517 `branchprinter` varchar(100) default NULL,
518 UNIQUE KEY `branchcode` (`branchcode`)
519 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
522 -- Table structure for table `branchrelations`
525 DROP TABLE IF EXISTS `branchrelations`;
526 CREATE TABLE `branchrelations` (
527 `branchcode` varchar(10) NOT NULL default '',
528 `categorycode` varchar(10) NOT NULL default '',
529 PRIMARY KEY (`branchcode`,`categorycode`),
530 KEY `branchcode` (`branchcode`),
531 KEY `categorycode` (`categorycode`),
532 CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
533 CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
534 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
537 -- Table structure for table `branchtransfers`
540 DROP TABLE IF EXISTS `branchtransfers`;
541 CREATE TABLE `branchtransfers` (
542 `itemnumber` int(11) NOT NULL default 0,
543 `datesent` datetime default NULL,
544 `frombranch` varchar(10) NOT NULL default '',
545 `datearrived` datetime default NULL,
546 `tobranch` varchar(10) NOT NULL default '',
547 `comments` mediumtext,
548 KEY `frombranch` (`frombranch`),
549 KEY `tobranch` (`tobranch`),
550 KEY `itemnumber` (`itemnumber`),
551 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
552 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
553 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
554 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
558 -- Table structure for table `browser`
560 DROP TABLE IF EXISTS `browser`;
561 CREATE TABLE `browser` (
562 `level` int(11) NOT NULL,
563 `classification` varchar(20) NOT NULL,
564 `description` varchar(255) NOT NULL,
565 `number` bigint(20) NOT NULL,
566 `endnode` tinyint(4) NOT NULL
567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
570 -- Table structure for table `categories`
573 DROP TABLE IF EXISTS `categories`;
574 CREATE TABLE `categories` (
575 `categorycode` varchar(10) NOT NULL default '',
576 `description` mediumtext,
577 `enrolmentperiod` smallint(6) default NULL,
578 `upperagelimit` smallint(6) default NULL,
579 `dateofbirthrequired` tinyint(1) default NULL,
580 `finetype` varchar(30) default NULL,
581 `bulk` tinyint(1) default NULL,
582 `enrolmentfee` decimal(28,6) default NULL,
583 `overduenoticerequired` tinyint(1) default NULL,
584 `issuelimit` smallint(6) default NULL,
585 `reservefee` decimal(28,6) default NULL,
586 `category_type` varchar(1) NOT NULL default 'A',
587 PRIMARY KEY (`categorycode`),
588 UNIQUE KEY `categorycode` (`categorycode`)
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
592 -- Table structure for table `categorytable`
595 DROP TABLE IF EXISTS `categorytable`;
596 CREATE TABLE `categorytable` (
597 `categorycode` varchar(5) NOT NULL default '',
599 `itemtypecodes` text,
600 PRIMARY KEY (`categorycode`)
601 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
604 -- Table structure for table `cities`
607 DROP TABLE IF EXISTS `cities`;
608 CREATE TABLE `cities` (
609 `cityid` int(11) NOT NULL auto_increment,
610 `city_name` varchar(100) NOT NULL default '',
611 `city_zipcode` varchar(20) default NULL,
612 PRIMARY KEY (`cityid`)
613 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
616 -- Table structure for table `class_sort_rules`
619 DROP TABLE IF EXISTS `class_sort_rules`;
620 CREATE TABLE `class_sort_rules` (
621 `class_sort_rule` varchar(10) NOT NULL default '',
622 `description` mediumtext,
623 `sort_routine` varchar(30) NOT NULL default '',
624 PRIMARY KEY (`class_sort_rule`),
625 UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
626 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
629 -- Table structure for table `class_sources`
632 DROP TABLE IF EXISTS `class_sources`;
633 CREATE TABLE `class_sources` (
634 `cn_source` varchar(10) NOT NULL default '',
635 `description` mediumtext,
636 `used` tinyint(4) NOT NULL default 0,
637 `class_sort_rule` varchar(10) NOT NULL default '',
638 PRIMARY KEY (`cn_source`),
639 UNIQUE KEY `cn_source_idx` (`cn_source`),
640 KEY `used_idx` (`used`),
641 CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
642 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
645 -- Table structure for table `currency`
648 DROP TABLE IF EXISTS `currency`;
649 CREATE TABLE `currency` (
650 `currency` varchar(10) NOT NULL default '',
651 `rate` float(7,5) default NULL,
652 PRIMARY KEY (`currency`)
653 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
656 -- Table structure for table `deletedbiblio`
659 DROP TABLE IF EXISTS `deletedbiblio`;
660 CREATE TABLE `deletedbiblio` (
661 `biblionumber` int(11) NOT NULL default 0,
662 `frameworkcode` varchar(4) NOT NULL default '',
665 `unititle` mediumtext,
667 `serial` tinyint(1) default NULL,
668 `seriestitle` mediumtext,
669 `copyrightdate` smallint(6) default NULL,
670 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
671 `datecreated` DATE NOT NULL,
672 `abstract` mediumtext,
673 PRIMARY KEY (`biblionumber`),
674 KEY `blbnoidx` (`biblionumber`)
675 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
678 -- Table structure for table `deletedbiblioitems`
681 DROP TABLE IF EXISTS `deletedbiblioitems`;
682 CREATE TABLE `deletedbiblioitems` (
683 `biblioitemnumber` int(11) NOT NULL default 0,
684 `biblionumber` int(11) NOT NULL default 0,
687 `itemtype` varchar(10) default NULL,
688 `isbn` varchar(14) default NULL,
689 `issn` varchar(9) default NULL,
690 `publicationyear` text,
691 `publishercode` varchar(255) default NULL,
692 `volumedate` date default NULL,
694 `collectiontitle` mediumtext default NULL,
695 `collectionissn` text default NULL,
696 `collectionvolume` mediumtext default NULL,
697 `editionstatement` text default NULL,
698 `editionresponsibility` text default NULL,
699 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
700 `illus` varchar(255) default NULL,
701 `pages` varchar(255) default NULL,
703 `size` varchar(255) default NULL,
704 `place` varchar(255) default NULL,
705 `lccn` varchar(25) default NULL,
707 `url` varchar(255) default NULL,
708 `cn_source` varchar(10) default NULL,
709 `cn_class` varchar(30) default NULL,
710 `cn_item` varchar(10) default NULL,
711 `cn_suffix` varchar(10) default NULL,
712 `cn_sort` varchar(30) default NULL,
713 `totalissues` int(10),
714 `marcxml` longtext NOT NULL,
715 PRIMARY KEY (`biblioitemnumber`),
716 KEY `bibinoidx` (`biblioitemnumber`),
717 KEY `bibnoidx` (`biblionumber`),
719 KEY `publishercode` (`publishercode`)
720 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
723 -- Table structure for table `deletedborrowers`
726 DROP TABLE IF EXISTS `deletedborrowers`;
727 CREATE TABLE `deletedborrowers` (
728 `borrowernumber` int(11) NOT NULL default 0,
729 `cardnumber` varchar(9) NOT NULL default '',
730 `surname` mediumtext NOT NULL,
733 `othernames` mediumtext,
735 `streetnumber` varchar(10) default NULL,
736 `streettype` varchar(50) default NULL,
737 `address` mediumtext NOT NULL,
739 `city` mediumtext NOT NULL,
740 `zipcode` varchar(25) default NULL,
743 `mobile` varchar(50) default NULL,
747 `B_streetnumber` varchar(10) default NULL,
748 `B_streettype` varchar(50) default NULL,
749 `B_address` varchar(100) default NULL,
751 `B_zipcode` varchar(25) default NULL,
753 `B_phone` mediumtext,
754 `dateofbirth` date default NULL,
755 `branchcode` varchar(10) NOT NULL default '',
756 `categorycode` varchar(2) default NULL,
757 `dateenrolled` date default NULL,
758 `dateexpiry` date default NULL,
759 `gonenoaddress` tinyint(1) default NULL,
760 `lost` tinyint(1) default NULL,
761 `debarred` tinyint(1) default NULL,
762 `contactname` mediumtext,
763 `contactfirstname` text,
765 `guarantorid` int(11) default NULL,
766 `borrowernotes` mediumtext,
767 `relationship` varchar(100) default NULL,
768 `ethnicity` varchar(50) default NULL,
769 `ethnotes` varchar(255) default NULL,
770 `sex` varchar(1) default NULL,
771 `password` varchar(30) default NULL,
772 `flags` int(11) default NULL,
773 `userid` varchar(30) default NULL,
774 `opacnote` mediumtext,
775 `contactnote` varchar(255) default NULL,
776 `sort1` varchar(80) default NULL,
777 `sort2` varchar(80) default NULL,
778 KEY `borrowernumber` (`borrowernumber`),
779 KEY `cardnumber` (`cardnumber`)
780 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
783 -- Table structure for table `deleteditems`
786 DROP TABLE IF EXISTS `deleteditems`;
787 CREATE TABLE `deleteditems` (
788 `itemnumber` int(11) NOT NULL default 0,
789 `biblionumber` int(11) NOT NULL default 0,
790 `biblioitemnumber` int(11) NOT NULL default 0,
791 `barcode` varchar(20) default NULL,
792 `dateaccessioned` date default NULL,
793 `booksellerid` varchar(10) default NULL,
794 `homebranch` varchar(10) default NULL,
795 `price` decimal(8,2) default NULL,
796 `replacementprice` decimal(8,2) default NULL,
797 `replacementpricedate` date default NULL,
798 `datelastborrowed` date default NULL,
799 `datelastseen` date default NULL,
800 `stack` tinyint(1) default NULL,
801 `notforloan` tinyint(1) default NULL,
802 `damaged` tinyint(1) default NULL,
803 `itemlost` tinyint(1) default NULL,
804 `wthdrawn` tinyint(1) default NULL,
805 `itemcallnumber` varchar(30) default NULL,
806 `issues` smallint(6) default NULL,
807 `renewals` smallint(6) default NULL,
808 `reserves` smallint(6) default NULL,
809 `restricted` tinyint(1) default NULL,
810 `itemnotes` mediumtext,
811 `holdingbranch` varchar(10) default NULL,
812 `paidfor` mediumtext,
813 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
814 `location` varchar(80) default NULL,
815 `onloan` date default NULL,
816 `cn_source` varchar(10) default NULL,
817 `cn_sort` varchar(30) default NULL,
818 `ccode` varchar(10) default NULL,
819 `materials` varchar(10) default NULL,
820 `uri` varchar(255) default NULL,
822 PRIMARY KEY (`itemnumber`),
823 KEY `delitembarcodeidx` (`barcode`),
824 KEY `delitembinoidx` (`biblioitemnumber`),
825 KEY `delitembibnoidx` (`biblionumber`),
826 KEY `delhomebranch` (`homebranch`),
827 KEY `delholdingbranch` (`holdingbranch`)
828 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
831 -- Table structure for table `ethnicity`
834 DROP TABLE IF EXISTS `ethnicity`;
835 CREATE TABLE `ethnicity` (
836 `code` varchar(10) NOT NULL default '',
837 `name` varchar(255) default NULL,
839 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
842 -- Table structure for table `import_batches`
845 DROP TABLE IF EXISTS `import_batches`;
846 CREATE TABLE `import_batches` (
847 `import_batch_id` int(11) NOT NULL auto_increment,
848 `template_id` int(11) default NULL,
849 `branchcode` varchar(10) default NULL,
850 `num_biblios` int(11) NOT NULL default 0,
851 `num_items` int(11) NOT NULL default 0,
852 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
853 `overlay_action` enum('replace', 'create_new', 'use_template') NOT NULL default 'create_new',
854 `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging',
855 `batch_type` enum('batch', 'z3950') NOT NULL default 'batch',
856 `file_name` varchar(100),
857 `comments` mediumtext,
858 PRIMARY KEY (`import_batch_id`),
859 KEY `branchcode` (`branchcode`)
860 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
863 -- Table structure for table `import_records`
866 DROP TABLE IF EXISTS `import_records`;
867 CREATE TABLE `import_records` (
868 `import_record_id` int(11) NOT NULL auto_increment,
869 `import_batch_id` int(11) NOT NULL,
870 `branchcode` varchar(10) default NULL,
871 `record_sequence` int(11) NOT NULL default 0,
872 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
873 `import_date` DATE default NULL,
874 `marc` longblob NOT NULL,
875 `marcxml` longtext NOT NULL,
876 `marcxml_old` longtext NOT NULL,
877 `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio',
878 `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match',
879 `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted') NOT NULL default 'staged',
880 `import_error` mediumtext,
881 `encoding` varchar(40) NOT NULL default '',
882 `z3950random` varchar(40) default NULL,
883 PRIMARY KEY (`import_record_id`),
884 CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
885 REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
886 KEY `branchcode` (`branchcode`),
887 KEY `batch_sequence` (`import_batch_id`, `record_sequence`)
888 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
891 -- Table structure for `import_record_matches`
893 DROP TABLE IF EXISTS `import_record_matches`;
894 CREATE TABLE `import_record_matches` (
895 `import_record_id` int(11) NOT NULL,
896 `candidate_match_id` int(11) NOT NULL,
897 `score` int(11) NOT NULL default 0,
898 CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
899 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
900 KEY `record_score` (`import_record_id`, `score`)
901 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
904 -- Table structure for table `import_biblios`
907 DROP TABLE IF EXISTS `import_biblios`;
908 CREATE TABLE `import_biblios` (
909 `import_record_id` int(11) NOT NULL,
910 `matched_biblionumber` int(11) default NULL,
911 `control_number` varchar(25) default NULL,
912 `original_source` varchar(25) default NULL,
913 `title` varchar(128) default NULL,
914 `author` varchar(80) default NULL,
915 `isbn` varchar(14) default NULL,
916 `issn` varchar(9) default NULL,
917 `has_items` tinyint(1) NOT NULL default 0,
918 CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
919 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
920 KEY `matched_biblionumber` (`matched_biblionumber`),
921 KEY `title` (`title`),
923 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
926 -- Table structure for table `import_items`
929 DROP TABLE IF EXISTS `import_items`;
930 CREATE TABLE `import_items` (
931 `import_items_id` int(11) NOT NULL auto_increment,
932 `import_record_id` int(11) NOT NULL,
933 `itemnumber` int(11) default NULL,
934 `branchcode` varchar(10) default NULL,
935 `status` enum('error', 'staged', 'imported', 'reverted') NOT NULL default 'staged',
936 `marcxml` longtext NOT NULL,
937 `import_error` mediumtext,
938 PRIMARY KEY (`import_items_id`),
939 CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`)
940 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
941 KEY `itemnumber` (`itemnumber`),
942 KEY `branchcode` (`branchcode`)
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
946 -- Table structure for table `issues`
949 DROP TABLE IF EXISTS `issues`;
950 CREATE TABLE `issues` (
951 `borrowernumber` int(11) default NULL,
952 `itemnumber` int(11) default NULL,
953 `date_due` date default NULL,
954 `branchcode` varchar(10) default NULL,
955 `issuingbranch` varchar(18) default NULL,
956 `returndate` date default NULL,
957 `lastreneweddate` date default NULL,
958 `return` varchar(4) default NULL,
959 `renewals` tinyint(4) default NULL,
960 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
961 `issuedate` date default NULL,
962 KEY `issuesborridx` (`borrowernumber`),
963 KEY `issuesitemidx` (`itemnumber`),
964 KEY `bordate` (`borrowernumber`,`timestamp`),
965 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
966 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
967 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
970 -- Table structure for table `issuingrules`
973 DROP TABLE IF EXISTS `issuingrules`;
974 CREATE TABLE `issuingrules` (
975 `categorycode` varchar(10) NOT NULL default '',
976 `itemtype` varchar(10) NOT NULL default '',
977 `restrictedtype` tinyint(1) default NULL,
978 `rentaldiscount` decimal(28,6) default NULL,
979 `reservecharge` decimal(28,6) default NULL,
980 `fine` decimal(28,6) default NULL,
981 `firstremind` int(11) default NULL,
982 `chargeperiod` int(11) default NULL,
983 `accountsent` int(11) default NULL,
984 `chargename` varchar(100) default NULL,
985 `maxissueqty` int(4) default NULL,
986 `issuelength` int(4) default NULL,
987 `branchcode` varchar(10) NOT NULL default '',
988 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
989 KEY `categorycode` (`categorycode`),
990 KEY `itemtype` (`itemtype`)
991 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
994 -- Table structure for table `items`
997 DROP TABLE IF EXISTS `items`;
998 CREATE TABLE `items` (
999 `itemnumber` int(11) NOT NULL auto_increment,
1000 `biblionumber` int(11) NOT NULL default 0,
1001 `biblioitemnumber` int(11) NOT NULL default 0,
1002 `barcode` varchar(20) default NULL,
1003 `dateaccessioned` date default NULL,
1004 `booksellerid` varchar(10) default NULL,
1005 `homebranch` varchar(10) default NULL,
1006 `price` decimal(8,2) default NULL,
1007 `replacementprice` decimal(8,2) default NULL,
1008 `replacementpricedate` date default NULL,
1009 `datelastborrowed` date default NULL,
1010 `datelastseen` date default NULL,
1011 `stack` tinyint(1) default NULL,
1012 `notforloan` tinyint(1) default NULL,
1013 `damaged` tinyint(1) default NULL,
1014 `itemlost` tinyint(1) default NULL,
1015 `wthdrawn` tinyint(1) default NULL,
1016 `itemcallnumber` varchar(30) default NULL,
1017 `issues` smallint(6) default NULL,
1018 `renewals` smallint(6) default NULL,
1019 `reserves` smallint(6) default NULL,
1020 `restricted` tinyint(1) default NULL,
1021 `itemnotes` mediumtext,
1022 `holdingbranch` varchar(10) default NULL,
1023 `paidfor` mediumtext,
1024 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1025 `location` varchar(80) default NULL,
1026 `onloan` date default NULL,
1027 `cn_source` varchar(10) default NULL,
1028 `cn_sort` varchar(30) default NULL,
1029 `ccode` varchar(10) default NULL,
1030 `materials` varchar(10) default NULL,
1031 `uri` varchar(255) default NULL,
1032 `itype` varchar(10) default NULL,
1033 PRIMARY KEY (`itemnumber`),
1034 UNIQUE KEY `itembarcodeidx` (`barcode`),
1035 KEY `itembinoidx` (`biblioitemnumber`),
1036 KEY `itembibnoidx` (`biblionumber`),
1037 KEY `homebranch` (`homebranch`),
1038 KEY `holdingbranch` (`holdingbranch`),
1039 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1040 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1041 CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1042 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1045 -- Table structure for table `itemtypes`
1048 DROP TABLE IF EXISTS `itemtypes`;
1049 CREATE TABLE `itemtypes` (
1050 `itemtype` varchar(10) NOT NULL default '',
1051 `description` mediumtext,
1052 `renewalsallowed` smallint(6) default NULL,
1053 `rentalcharge` double(16,4) default NULL,
1054 `notforloan` smallint(6) default NULL,
1055 `imageurl` varchar(200) default NULL,
1057 PRIMARY KEY (`itemtype`),
1058 UNIQUE KEY `itemtype` (`itemtype`)
1059 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1062 -- Table structure for table `labels`
1065 DROP TABLE IF EXISTS `labels`;
1066 CREATE TABLE `labels` (
1067 `labelid` int(11) NOT NULL auto_increment,
1068 `batch_id` varchar(10) NOT NULL default 1,
1069 `itemnumber` varchar(100) NOT NULL default '',
1070 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1071 PRIMARY KEY (`labelid`)
1072 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1075 -- Table structure for table `labels_conf`
1078 DROP TABLE IF EXISTS `labels_conf`;
1079 CREATE TABLE `labels_conf` (
1080 `id` int(4) NOT NULL auto_increment,
1081 `barcodetype` char(100) default '',
1082 `title` int(1) default '0',
1083 `subtitle` int(1) default '0',
1084 `itemtype` int(1) default '0',
1085 `barcode` int(1) default '0',
1086 `dewey` int(1) default '0',
1087 `class` int(1) default NULL,
1088 `subclass` int(1) default '0',
1089 `itemcallnumber` int(1) default '0',
1090 `author` int(1) default '0',
1091 `issn` int(1) default '0',
1092 `isbn` int(1) default '0',
1093 `startlabel` int(2) NOT NULL default '1',
1094 `printingtype` char(32) default 'BAR',
1095 `layoutname` char(20) NOT NULL default 'TEST',
1096 `guidebox` int(1) default '0',
1097 `active` tinyint(1) default '1',
1098 `fonttype` char(10) collate utf8_unicode_ci default NULL,
1099 `ccode` char(4) collate utf8_unicode_ci default NULL,
1100 `callnum_split` int(1) default NULL,
1101 `text_justify` char(1) collate utf8_unicode_ci default NULL,
1103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1106 -- Table structure for table `labels_templates`
1109 DROP TABLE IF EXISTS `labels_templates`;
1110 CREATE TABLE `labels_templates` (
1111 `tmpl_id` int(4) NOT NULL auto_increment,
1112 `tmpl_code` char(100) default '',
1113 `tmpl_desc` char(100) default '',
1114 `page_width` float default '0',
1115 `page_height` float default '0',
1116 `label_width` float default '0',
1117 `label_height` float default '0',
1118 `topmargin` float default '0',
1119 `leftmargin` float default '0',
1120 `cols` int(2) default '0',
1121 `rows` int(2) default '0',
1122 `colgap` float default '0',
1123 `rowgap` float default '0',
1124 `active` int(1) default NULL,
1125 `units` char(20) default 'PX',
1126 `fontsize` int(4) NOT NULL default '3',
1127 PRIMARY KEY (`tmpl_id`)
1128 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1131 -- Table structure for table `letter`
1134 DROP TABLE IF EXISTS `letter`;
1135 CREATE TABLE `letter` (
1136 `module` varchar(20) NOT NULL default '',
1137 `code` varchar(20) NOT NULL default '',
1138 `name` varchar(100) NOT NULL default '',
1139 `title` varchar(200) NOT NULL default '',
1141 PRIMARY KEY (`module`,`code`)
1142 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1145 -- Table structure for table `marc_subfield_structure`
1148 DROP TABLE IF EXISTS `marc_subfield_structure`;
1149 CREATE TABLE `marc_subfield_structure` (
1150 `tagfield` varchar(3) NOT NULL default '',
1151 `tagsubfield` varchar(1) NOT NULL default '',
1152 `liblibrarian` varchar(255) NOT NULL default '',
1153 `libopac` varchar(255) NOT NULL default '',
1154 `repeatable` tinyint(4) NOT NULL default 0,
1155 `mandatory` tinyint(4) NOT NULL default 0,
1156 `kohafield` varchar(40) default NULL,
1157 `tab` tinyint(1) default NULL,
1158 `authorised_value` varchar(20) default NULL,
1159 `authtypecode` varchar(20) default NULL,
1160 `value_builder` varchar(80) default NULL,
1161 `isurl` tinyint(1) default NULL,
1162 `hidden` tinyint(1) default NULL,
1163 `frameworkcode` varchar(4) NOT NULL default '',
1164 `seealso` varchar(1100) default NULL,
1165 `link` varchar(80) default NULL,
1166 `defaultvalue` text default NULL,
1167 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1168 KEY `kohafield_2` (`kohafield`),
1169 KEY `tab` (`frameworkcode`,`tab`),
1170 KEY `kohafield` (`frameworkcode`,`kohafield`)
1171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1174 -- Table structure for table `marc_tag_structure`
1177 DROP TABLE IF EXISTS `marc_tag_structure`;
1178 CREATE TABLE `marc_tag_structure` (
1179 `tagfield` varchar(3) NOT NULL default '',
1180 `liblibrarian` varchar(255) NOT NULL default '',
1181 `libopac` varchar(255) NOT NULL default '',
1182 `repeatable` tinyint(4) NOT NULL default 0,
1183 `mandatory` tinyint(4) NOT NULL default 0,
1184 `authorised_value` varchar(10) default NULL,
1185 `frameworkcode` varchar(4) NOT NULL default '',
1186 PRIMARY KEY (`frameworkcode`,`tagfield`)
1187 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1190 -- Table structure for table `mediatypetable`
1193 DROP TABLE IF EXISTS `mediatypetable`;
1194 CREATE TABLE `mediatypetable` (
1195 `mediatypecode` varchar(5) NOT NULL default '',
1197 `itemtypecodes` text,
1198 PRIMARY KEY (`mediatypecode`)
1199 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1202 -- Table structure for table `notifys`
1205 DROP TABLE IF EXISTS `notifys`;
1206 CREATE TABLE `notifys` (
1207 `notify_id` int(11) NOT NULL default 0,
1208 `borrowernumber` int(11) NOT NULL default 0,
1209 `itemnumber` int(11) NOT NULL default 0,
1210 `notify_date` date default NULL,
1211 `notify_send_date` date default NULL,
1212 `notify_level` int(1) NOT NULL default 0,
1213 `method` varchar(20) NOT NULL default ''
1214 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1217 -- Table structure for table `nozebra`
1219 CREATE TABLE `nozebra` (
1220 `server` varchar(20) NOT NULL,
1221 `indexname` varchar(40) NOT NULL,
1222 `value` varchar(250) NOT NULL,
1223 `biblionumbers` longtext NOT NULL,
1224 KEY `indexname` (`server`,`indexname`),
1225 KEY `value` (`server`,`value`))
1226 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1229 -- Table structure for table `opac_news`
1232 DROP TABLE IF EXISTS `opac_news`;
1233 CREATE TABLE `opac_news` (
1234 `idnew` int(10) unsigned NOT NULL auto_increment,
1235 `title` varchar(250) NOT NULL default '',
1236 `new` text NOT NULL,
1237 `lang` varchar(4) NOT NULL default '',
1238 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1239 `expirationdate` date default NULL,
1240 `number` int(11) default NULL,
1241 PRIMARY KEY (`idnew`)
1242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1245 -- Table structure for table `overduerules`
1248 DROP TABLE IF EXISTS `overduerules`;
1249 CREATE TABLE `overduerules` (
1250 `branchcode` varchar(10) NOT NULL default '',
1251 `categorycode` varchar(2) NOT NULL default '',
1252 `delay1` int(4) default 0,
1253 `letter1` varchar(20) default NULL,
1254 `debarred1` varchar(1) default 0,
1255 `delay2` int(4) default 0,
1256 `debarred2` varchar(1) default 0,
1257 `letter2` varchar(20) default NULL,
1258 `delay3` int(4) default 0,
1259 `letter3` varchar(20) default NULL,
1260 `debarred3` int(1) default 0,
1261 PRIMARY KEY (`branchcode`,`categorycode`)
1262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1265 -- Table structure for table `printers`
1268 DROP TABLE IF EXISTS `printers`;
1269 CREATE TABLE `printers` (
1270 `printername` varchar(40) NOT NULL default '',
1271 `printqueue` varchar(20) default NULL,
1272 `printtype` varchar(20) default NULL,
1273 PRIMARY KEY (`printername`)
1274 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1277 -- Table structure for table `repeatable_holidays`
1280 DROP TABLE IF EXISTS `repeatable_holidays`;
1281 CREATE TABLE `repeatable_holidays` (
1282 `id` int(11) NOT NULL auto_increment,
1283 `branchcode` varchar(10) NOT NULL default '',
1284 `weekday` smallint(6) default NULL,
1285 `day` smallint(6) default NULL,
1286 `month` smallint(6) default NULL,
1287 `title` varchar(50) NOT NULL default '',
1288 `description` text NOT NULL,
1290 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1293 -- Table structure for table `reports_dictionary`
1296 DROP TABLE IF EXISTS `reports_dictionary`;
1297 CREATE TABLE reports_dictionary (
1298 `id` int(11) NOT NULL auto_increment,
1299 `name` varchar(255) default NULL,
1301 `date_created` datetime default NULL,
1302 `date_modified` datetime default NULL,
1304 `area` int(11) default NULL,
1306 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1309 -- Table structure for table `reserveconstraints`
1312 DROP TABLE IF EXISTS `reserveconstraints`;
1313 CREATE TABLE `reserveconstraints` (
1314 `borrowernumber` int(11) NOT NULL default 0,
1315 `reservedate` date default NULL,
1316 `biblionumber` int(11) NOT NULL default 0,
1317 `biblioitemnumber` int(11) default NULL,
1318 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1322 -- Table structure for table `reserves`
1325 DROP TABLE IF EXISTS `reserves`;
1326 CREATE TABLE `reserves` (
1327 `borrowernumber` int(11) NOT NULL default 0,
1328 `reservedate` date default NULL,
1329 `biblionumber` int(11) NOT NULL default 0,
1330 `constrainttype` varchar(1) default NULL,
1331 `branchcode` varchar(10) default NULL,
1332 `notificationdate` date default NULL,
1333 `reminderdate` date default NULL,
1334 `cancellationdate` date default NULL,
1335 `reservenotes` mediumtext,
1336 `priority` smallint(6) default NULL,
1337 `found` varchar(1) default NULL,
1338 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1339 `itemnumber` int(11) default NULL,
1340 `waitingdate` date default NULL,
1341 KEY `borrowernumber` (`borrowernumber`),
1342 KEY `biblionumber` (`biblionumber`),
1343 KEY `itemnumber` (`itemnumber`),
1344 KEY `branchcode` (`branchcode`),
1345 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1346 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1347 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1348 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1349 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1352 -- Table structure for table `reviews`
1355 DROP TABLE IF EXISTS `reviews`;
1356 CREATE TABLE `reviews` (
1357 `reviewid` int(11) NOT NULL auto_increment,
1358 `borrowernumber` int(11) default NULL,
1359 `biblionumber` int(11) default NULL,
1361 `approved` tinyint(4) default NULL,
1362 `datereviewed` datetime default NULL,
1363 PRIMARY KEY (`reviewid`)
1364 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1367 -- Table structure for table `roadtype`
1370 DROP TABLE IF EXISTS `roadtype`;
1371 CREATE TABLE `roadtype` (
1372 `roadtypeid` int(11) NOT NULL auto_increment,
1373 `road_type` varchar(100) NOT NULL default '',
1374 PRIMARY KEY (`roadtypeid`)
1375 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1378 -- Table structure for table `saved_sql`
1381 DROP TABLE IF EXISTS `saved_sql`;
1382 CREATE TABLE saved_sql (
1383 `id` int(11) NOT NULL auto_increment,
1384 `borrowernumber` int(11) default NULL,
1385 `date_created` datetime default NULL,
1386 `last_modified` datetime default NULL,
1388 `last_run` datetime default NULL,
1389 `report_name` varchar(255) default NULL,
1390 `type` varchar(255) default NULL,
1393 KEY boridx (`borrowernumber`)
1394 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1398 -- Table structure for `saved_reports`
1401 DROP TABLE IF EXISTS `saved_reports`;
1402 CREATE TABLE saved_reports (
1403 `id` int(11) NOT NULL auto_increment,
1404 `report_id` int(11) default NULL,
1406 `date_run` datetime default NULL,
1408 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1412 -- Table structure for table `serial`
1415 DROP TABLE IF EXISTS `serial`;
1416 CREATE TABLE `serial` (
1417 `serialid` int(11) NOT NULL auto_increment,
1418 `biblionumber` varchar(100) NOT NULL default '',
1419 `subscriptionid` varchar(100) NOT NULL default '',
1420 `serialseq` varchar(100) NOT NULL default '',
1421 `status` tinyint(4) NOT NULL default 0,
1422 `planneddate` date default NULL,
1424 `publisheddate` date default NULL,
1426 `claimdate` date default NULL,
1427 `routingnotes` text,
1428 PRIMARY KEY (`serialid`)
1429 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1432 -- Table structure for table `sessions`
1435 DROP TABLE IF EXISTS sessions;
1436 CREATE TABLE sessions (
1437 `id` varchar(32) NOT NULL,
1438 `a_session` text NOT NULL,
1440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1443 -- Table structure for table `special_holidays`
1446 DROP TABLE IF EXISTS `special_holidays`;
1447 CREATE TABLE `special_holidays` (
1448 `id` int(11) NOT NULL auto_increment,
1449 `branchcode` varchar(10) NOT NULL default '',
1450 `day` smallint(6) NOT NULL default 0,
1451 `month` smallint(6) NOT NULL default 0,
1452 `year` smallint(6) NOT NULL default 0,
1453 `isexception` smallint(1) NOT NULL default 1,
1454 `title` varchar(50) NOT NULL default '',
1455 `description` text NOT NULL,
1457 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1460 -- Table structure for table `statistics`
1463 DROP TABLE IF EXISTS `statistics`;
1464 CREATE TABLE `statistics` (
1465 `datetime` datetime default NULL,
1466 `branch` varchar(10) default NULL,
1467 `proccode` varchar(4) default NULL,
1468 `value` double(16,4) default NULL,
1469 `type` varchar(16) default NULL,
1471 `usercode` varchar(10) default NULL,
1472 `itemnumber` int(11) default NULL,
1473 `itemtype` varchar(10) default NULL,
1474 `borrowernumber` int(11) default NULL,
1475 `associatedborrower` int(11) default NULL,
1476 KEY `timeidx` (`datetime`)
1477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1480 -- Table structure for table `stopwords`
1483 DROP TABLE IF EXISTS `stopwords`;
1484 CREATE TABLE `stopwords` (
1485 `word` varchar(255) default NULL
1486 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1489 -- Table structure for table `subcategorytable`
1492 DROP TABLE IF EXISTS `subcategorytable`;
1493 CREATE TABLE `subcategorytable` (
1494 `subcategorycode` varchar(5) NOT NULL default '',
1496 `itemtypecodes` text,
1497 PRIMARY KEY (`subcategorycode`)
1498 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1501 -- Table structure for table `subscription`
1504 DROP TABLE IF EXISTS `subscription`;
1505 CREATE TABLE `subscription` (
1506 `biblionumber` int(11) NOT NULL default 0,
1507 `subscriptionid` int(11) NOT NULL auto_increment,
1508 `librarian` varchar(100) default '',
1509 `startdate` date default NULL,
1510 `aqbooksellerid` int(11) default 0,
1511 `cost` int(11) default 0,
1512 `aqbudgetid` int(11) default 0,
1513 `weeklength` tinyint(4) default 0,
1514 `monthlength` tinyint(4) default 0,
1515 `numberlength` tinyint(4) default 0,
1516 `periodicity` tinyint(4) default 0,
1517 `dow` varchar(100) default '',
1518 `numberingmethod` varchar(100) default '',
1520 `status` varchar(100) NOT NULL default '',
1521 `add1` int(11) default 0,
1522 `every1` int(11) default 0,
1523 `whenmorethan1` int(11) default 0,
1524 `setto1` int(11) default NULL,
1525 `lastvalue1` int(11) default NULL,
1526 `add2` int(11) default 0,
1527 `every2` int(11) default 0,
1528 `whenmorethan2` int(11) default 0,
1529 `setto2` int(11) default NULL,
1530 `lastvalue2` int(11) default NULL,
1531 `add3` int(11) default 0,
1532 `every3` int(11) default 0,
1533 `innerloop1` int(11) default 0,
1534 `innerloop2` int(11) default 0,
1535 `innerloop3` int(11) default 0,
1536 `whenmorethan3` int(11) default 0,
1537 `setto3` int(11) default NULL,
1538 `lastvalue3` int(11) default NULL,
1539 `issuesatonce` tinyint(3) NOT NULL default 1,
1540 `firstacquidate` date default NULL,
1541 `manualhistory` tinyint(1) NOT NULL default 0,
1542 `irregularity` text,
1543 `letter` varchar(20) default NULL,
1544 `numberpattern` tinyint(3) default 0,
1545 `distributedto` text,
1546 `internalnotes` longtext,
1548 `branchcode` varchar(10) NOT NULL default '',
1549 `hemisphere` tinyint(3) default 0,
1550 `lastbranch` varchar(10),
1551 PRIMARY KEY (`subscriptionid`)
1552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1555 -- Table structure for table `subscriptionhistory`
1558 DROP TABLE IF EXISTS `subscriptionhistory`;
1559 CREATE TABLE `subscriptionhistory` (
1560 `biblionumber` int(11) NOT NULL default 0,
1561 `subscriptionid` int(11) NOT NULL default 0,
1562 `histstartdate` date default NULL,
1563 `enddate` date default NULL,
1564 `missinglist` longtext NOT NULL,
1565 `recievedlist` longtext NOT NULL,
1566 `opacnote` varchar(150) NOT NULL default '',
1567 `librariannote` varchar(150) NOT NULL default '',
1568 PRIMARY KEY (`subscriptionid`),
1569 KEY `biblionumber` (`biblionumber`)
1570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1573 -- Table structure for table `subscriptionroutinglist`
1576 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1577 CREATE TABLE `subscriptionroutinglist` (
1578 `routingid` int(11) NOT NULL auto_increment,
1579 `borrowernumber` int(11) default NULL,
1580 `ranking` int(11) default NULL,
1581 `subscriptionid` int(11) default NULL,
1582 PRIMARY KEY (`routingid`)
1583 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1586 -- Table structure for table `suggestions`
1589 DROP TABLE IF EXISTS `suggestions`;
1590 CREATE TABLE `suggestions` (
1591 `suggestionid` int(8) NOT NULL auto_increment,
1592 `suggestedby` int(11) NOT NULL default 0,
1593 `managedby` int(11) default NULL,
1594 `STATUS` varchar(10) NOT NULL default '',
1596 `author` varchar(80) default NULL,
1597 `title` varchar(80) default NULL,
1598 `copyrightdate` smallint(6) default NULL,
1599 `publishercode` varchar(255) default NULL,
1600 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1601 `volumedesc` varchar(255) default NULL,
1602 `publicationyear` smallint(6) default 0,
1603 `place` varchar(255) default NULL,
1604 `isbn` varchar(10) default NULL,
1605 `mailoverseeing` smallint(1) default 0,
1606 `biblionumber` int(11) default NULL,
1608 PRIMARY KEY (`suggestionid`),
1609 KEY `suggestedby` (`suggestedby`),
1610 KEY `managedby` (`managedby`)
1611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1614 -- Table structure for table `systempreferences`
1617 DROP TABLE IF EXISTS `systempreferences`;
1618 CREATE TABLE `systempreferences` (
1619 `variable` varchar(50) NOT NULL default '',
1621 `options` mediumtext,
1623 `type` varchar(20) default NULL,
1624 PRIMARY KEY (`variable`)
1625 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1628 -- Table structure for table `tags`
1631 DROP TABLE IF EXISTS `tags`;
1632 CREATE TABLE `tags` (
1633 `entry` varchar(255) NOT NULL default '',
1634 `weight` bigint(20) NOT NULL default 0,
1635 PRIMARY KEY (`entry`)
1636 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1639 -- Table structure for table `userflags`
1642 DROP TABLE IF EXISTS `userflags`;
1643 CREATE TABLE `userflags` (
1644 `bit` int(11) NOT NULL default 0,
1645 `flag` varchar(30) default NULL,
1646 `flagdesc` varchar(255) default NULL,
1647 `defaulton` int(11) default NULL,
1649 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1652 -- Table structure for table `virtualshelves`
1655 DROP TABLE IF EXISTS `virtualshelves`;
1656 CREATE TABLE `virtualshelves` (
1657 `shelfnumber` int(11) NOT NULL auto_increment,
1658 `shelfname` varchar(255) default NULL,
1659 `owner` varchar(80) default NULL,
1660 `category` varchar(1) default NULL,
1661 PRIMARY KEY (`shelfnumber`)
1662 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1665 -- Table structure for table `virtualshelfcontents`
1668 DROP TABLE IF EXISTS `virtualshelfcontents`;
1669 CREATE TABLE `virtualshelfcontents` (
1670 `shelfnumber` int(11) NOT NULL default 0,
1671 `biblionumber` int(11) NOT NULL default 0,
1672 `flags` int(11) default NULL,
1673 `dateadded` timestamp NULL default NULL,
1674 KEY `shelfnumber` (`shelfnumber`),
1675 KEY `biblionumber` (`biblionumber`),
1676 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1677 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1678 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1681 -- Table structure for table `z3950servers`
1684 DROP TABLE IF EXISTS `z3950servers`;
1685 CREATE TABLE `z3950servers` (
1686 `host` varchar(255) default NULL,
1687 `port` int(11) default NULL,
1688 `db` varchar(255) default NULL,
1689 `userid` varchar(255) default NULL,
1690 `password` varchar(255) default NULL,
1692 `id` int(11) NOT NULL auto_increment,
1693 `checked` smallint(6) default NULL,
1694 `rank` int(11) default NULL,
1695 `syntax` varchar(80) default NULL,
1697 `position` enum('primary','secondary','') NOT NULL default 'primary',
1698 `type` enum('zed','opensearch') NOT NULL default 'zed',
1699 `description` text NOT NULL,
1701 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1704 -- Table structure for table `zebraqueue`
1707 CREATE TABLE `zebraqueue` (
1708 `id` int(11) NOT NULL auto_increment,
1709 `biblio_auth_number` int(11) NOT NULL default '0',
1710 `operation` char(20) NOT NULL default '',
1711 `server` char(20) NOT NULL default '',
1712 `done` int(11) NOT NULL default '0',
1713 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1715 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1717 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1718 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1719 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1720 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1721 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1722 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1723 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1724 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;