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 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
63 `user` int(11) NOT NULL default 0,
66 `object` int(11) default NULL,
68 PRIMARY KEY (`timestamp`,`user`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72 -- Table structure for table `alert`
75 DROP TABLE IF EXISTS `alert`;
76 CREATE TABLE `alert` (
77 `alertid` int(11) NOT NULL auto_increment,
78 `borrowernumber` int(11) NOT NULL default 0,
79 `type` varchar(10) NOT NULL default '',
80 `externalid` varchar(20) NOT NULL default '',
81 PRIMARY KEY (`alertid`),
82 KEY `borrowernumber` (`borrowernumber`),
83 KEY `type` (`type`,`externalid`)
84 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
87 -- Table structure for table `aqbasket`
90 DROP TABLE IF EXISTS `aqbasket`;
91 CREATE TABLE `aqbasket` (
92 `basketno` int(11) NOT NULL auto_increment,
93 `creationdate` date default NULL,
94 `closedate` date default NULL,
95 `booksellerid` int(11) NOT NULL default 1,
96 `authorisedby` varchar(10) default NULL,
97 `booksellerinvoicenumber` mediumtext,
98 PRIMARY KEY (`basketno`),
99 KEY `booksellerid` (`booksellerid`),
100 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE
101 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
104 -- Table structure for table `aqbookfund`
107 DROP TABLE IF EXISTS `aqbookfund`;
108 CREATE TABLE `aqbookfund` (
109 `bookfundid` varchar(10) NOT NULL default '',
110 `bookfundname` mediumtext,
111 `bookfundgroup` varchar(5) default NULL,
112 `branchcode` varchar(10) NOT NULL default '',
113 PRIMARY KEY (`bookfundid`,`branchcode`)
114 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
117 -- Table structure for table `aqbooksellers`
120 DROP TABLE IF EXISTS `aqbooksellers`;
121 CREATE TABLE `aqbooksellers` (
122 `id` int(11) NOT NULL auto_increment,
124 `address1` mediumtext,
125 `address2` mediumtext,
126 `address3` mediumtext,
127 `address4` mediumtext,
128 `phone` varchar(30) default NULL,
129 `accountnumber` mediumtext,
130 `othersupplier` mediumtext,
131 `currency` varchar(3) NOT NULL default '',
132 `deliverydays` smallint(6) default NULL,
133 `followupdays` smallint(6) default NULL,
134 `followupscancel` smallint(6) default NULL,
135 `specialty` mediumtext,
136 `booksellerfax` mediumtext,
138 `bookselleremail` mediumtext,
139 `booksellerurl` mediumtext,
140 `contact` varchar(100) default NULL,
142 `url` varchar(255) default NULL,
143 `contpos` varchar(100) default NULL,
144 `contphone` varchar(100) default NULL,
145 `contfax` varchar(100) default NULL,
146 `contaltphone` varchar(100) default NULL,
147 `contemail` varchar(100) default NULL,
148 `contnotes` mediumtext,
149 `active` tinyint(4) default NULL,
150 `listprice` varchar(10) default NULL,
151 `invoiceprice` varchar(10) default NULL,
152 `gstreg` tinyint(4) default NULL,
153 `listincgst` tinyint(4) default NULL,
154 `invoiceincgst` tinyint(4) default NULL,
155 `discount` float(6,4) default NULL,
156 `fax` varchar(50) default NULL,
157 `nocalc` int(11) default NULL,
158 `invoicedisc` float(6,4) default NULL,
160 KEY `listprice` (`listprice`),
161 KEY `invoiceprice` (`invoiceprice`),
162 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
163 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
164 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
167 -- Table structure for table `aqbudget`
170 DROP TABLE IF EXISTS `aqbudget`;
171 CREATE TABLE `aqbudget` (
172 `bookfundid` varchar(10) NOT NULL default '',
173 `startdate` date NOT NULL default 0,
174 `enddate` date default NULL,
175 `budgetamount` decimal(13,2) default NULL,
176 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
177 `branchcode` varchar(10) default NULL,
178 PRIMARY KEY (`aqbudgetid`)
179 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182 -- Table structure for table `aqorderbreakdown`
185 DROP TABLE IF EXISTS `aqorderbreakdown`;
186 CREATE TABLE `aqorderbreakdown` (
187 `ordernumber` int(11) default NULL,
188 `linenumber` int(11) default NULL,
189 `branchcode` varchar(10) default NULL,
190 `bookfundid` varchar(10) NOT NULL default '',
191 `allocation` smallint(6) default NULL,
192 KEY `ordernumber` (`ordernumber`),
193 KEY `bookfundid` (`bookfundid`),
194 CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
195 CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE
196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
199 -- Table structure for table `aqorderdelivery`
202 DROP TABLE IF EXISTS `aqorderdelivery`;
203 CREATE TABLE `aqorderdelivery` (
204 `ordernumber` date default NULL,
205 `deliverynumber` smallint(6) NOT NULL default 0,
206 `deliverydate` varchar(18) default NULL,
207 `qtydelivered` smallint(6) default NULL,
208 `deliverycomments` mediumtext
209 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
212 -- Table structure for table `aqorders`
215 DROP TABLE IF EXISTS `aqorders`;
216 CREATE TABLE `aqorders` (
217 `ordernumber` int(11) NOT NULL auto_increment,
218 `biblionumber` int(11) default NULL,
220 `entrydate` date default NULL,
221 `quantity` smallint(6) default NULL,
222 `currency` varchar(3) default NULL,
223 `listprice` decimal(28,6) default NULL,
224 `totalamount` decimal(28,6) default NULL,
225 `datereceived` date default NULL,
226 `booksellerinvoicenumber` mediumtext,
227 `freight` decimal(28,6) default NULL,
228 `unitprice` decimal(28,6) default NULL,
229 `quantityreceived` smallint(6) default NULL,
230 `cancelledby` varchar(10) default NULL,
231 `datecancellationprinted` date default NULL,
233 `supplierreference` mediumtext,
234 `purchaseordernumber` mediumtext,
235 `subscription` tinyint(1) default NULL,
236 `serialid` varchar(30) default NULL,
237 `basketno` int(11) default NULL,
238 `biblioitemnumber` int(11) default NULL,
239 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
240 `rrp` decimal(13,2) default NULL,
241 `ecost` decimal(13,2) default NULL,
242 `gst` decimal(13,2) default NULL,
243 `budgetdate` date default NULL,
244 `sort1` varchar(80) default NULL,
245 `sort2` varchar(80) default NULL,
246 PRIMARY KEY (`ordernumber`),
247 KEY `basketno` (`basketno`),
248 KEY `biblionumber` (`biblionumber`),
249 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
250 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL
251 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
254 -- Table structure for table `auth_header`
257 DROP TABLE IF EXISTS `auth_header`;
258 CREATE TABLE `auth_header` (
259 `authid` bigint(20) unsigned NOT NULL auto_increment,
260 `authtypecode` varchar(10) NOT NULL default '',
261 `datecreated` date default NULL,
262 `datemodified` date default NULL,
263 `origincode` varchar(20) default NULL,
264 `authtrees` mediumtext,
266 `linkid` bigint(20) default NULL,
267 `marcxml` longtext NOT NULL,
268 PRIMARY KEY (`authid`),
269 KEY `origincode` (`origincode`)
270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
273 -- Table structure for table `auth_subfield_structure`
276 DROP TABLE IF EXISTS `auth_subfield_structure`;
277 CREATE TABLE `auth_subfield_structure` (
278 `authtypecode` varchar(10) NOT NULL default '',
279 `tagfield` varchar(3) NOT NULL default '',
280 `tagsubfield` varchar(1) NOT NULL default '',
281 `liblibrarian` varchar(255) NOT NULL default '',
282 `libopac` varchar(255) NOT NULL default '',
283 `repeatable` tinyint(4) NOT NULL default 0,
284 `mandatory` tinyint(4) NOT NULL default 0,
285 `tab` tinyint(1) default NULL,
286 `authorised_value` varchar(10) default NULL,
287 `value_builder` varchar(80) default NULL,
288 `seealso` varchar(255) default NULL,
289 `isurl` tinyint(1) default NULL,
290 `hidden` tinyint(3) NOT NULL default 0,
291 `linkid` tinyint(1) NOT NULL default 0,
292 `kohafield` varchar(45) NULL default '',
293 `frameworkcode` varchar(8) NOT NULL default '',
294 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
295 KEY `tab` (`authtypecode`,`tab`)
296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
299 -- Table structure for table `auth_tag_structure`
302 DROP TABLE IF EXISTS `auth_tag_structure`;
303 CREATE TABLE `auth_tag_structure` (
304 `authtypecode` varchar(10) NOT NULL default '',
305 `tagfield` varchar(3) NOT NULL default '',
306 `liblibrarian` varchar(255) NOT NULL default '',
307 `libopac` varchar(255) NOT NULL default '',
308 `repeatable` tinyint(4) NOT NULL default 0,
309 `mandatory` tinyint(4) NOT NULL default 0,
310 `authorised_value` varchar(10) default NULL,
311 PRIMARY KEY (`authtypecode`,`tagfield`),
312 CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
313 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
316 -- Table structure for table `auth_types`
319 DROP TABLE IF EXISTS `auth_types`;
320 CREATE TABLE `auth_types` (
321 `authtypecode` varchar(10) NOT NULL default '',
322 `authtypetext` varchar(255) NOT NULL default '',
323 `auth_tag_to_report` varchar(3) NOT NULL default '',
324 `summary` mediumtext NOT NULL,
325 PRIMARY KEY (`authtypecode`)
326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
329 -- Table structure for table `authorised_values`
332 DROP TABLE IF EXISTS `authorised_values`;
333 CREATE TABLE `authorised_values` (
334 `id` int(11) NOT NULL auto_increment,
335 `category` varchar(10) NOT NULL default '',
336 `authorised_value` varchar(80) NOT NULL default '',
337 `lib` varchar(80) default NULL,
339 KEY `name` (`category`)
340 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
343 -- Table structure for table `biblio`
346 DROP TABLE IF EXISTS `biblio`;
347 CREATE TABLE `biblio` (
348 `biblionumber` int(11) NOT NULL default 0,
349 `frameworkcode` varchar(4) NOT NULL default '',
352 `unititle` mediumtext,
354 `serial` tinyint(1) default NULL,
355 `seriestitle` mediumtext,
356 `copyrightdate` smallint(6) default NULL,
357 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
358 `datecreated` DATE NOT NULL,
359 `abstract` mediumtext,
360 PRIMARY KEY (`biblionumber`),
361 KEY `blbnoidx` (`biblionumber`)
362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
365 -- Table structure for table `biblio_framework`
368 DROP TABLE IF EXISTS `biblio_framework`;
369 CREATE TABLE `biblio_framework` (
370 `frameworkcode` varchar(4) NOT NULL default '',
371 `frameworktext` varchar(255) NOT NULL default '',
372 PRIMARY KEY (`frameworkcode`)
373 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
376 -- Table structure for table `biblioitems`
379 DROP TABLE IF EXISTS `biblioitems`;
380 CREATE TABLE `biblioitems` (
381 `biblioitemnumber` int(11) NOT NULL default 0,
382 `biblionumber` int(11) NOT NULL default 0,
385 `itemtype` varchar(10) default NULL,
386 `isbn` varchar(14) default NULL,
387 `issn` varchar(9) default NULL,
388 `publicationyear` text,
389 `publishercode` varchar(255) default NULL,
390 `volumedate` date default NULL,
392 `collectiontitle` mediumtext default NULL,
393 `collectionissn` text default NULL,
394 `collectionvolume` mediumtext default NULL,
395 `editionstatement` text default NULL,
396 `editionresponsibility` text default NULL,
397 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
398 `illus` varchar(255) default NULL,
399 `pages` varchar(255) default NULL,
401 `size` varchar(255) default NULL,
402 `place` varchar(255) default NULL,
403 `lccn` varchar(25) default NULL,
405 `url` varchar(255) default NULL,
406 `cn_source` varchar(10) default NULL,
407 `cn_class` varchar(30) default NULL,
408 `cn_item` varchar(10) default NULL,
409 `cn_suffix` varchar(10) default NULL,
410 `cn_sort` varchar(30) default NULL,
411 `totalissues` int(10),
412 `marcxml` longtext NOT NULL,
413 PRIMARY KEY (`biblioitemnumber`),
414 KEY `bibinoidx` (`biblioitemnumber`),
415 KEY `bibnoidx` (`biblionumber`),
417 KEY `publishercode` (`publishercode`),
418 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
419 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
422 -- Table structure for table `borrowers`
425 DROP TABLE IF EXISTS `borrowers`;
426 CREATE TABLE `borrowers` (
427 `borrowernumber` int(11) NOT NULL auto_increment,
428 `cardnumber` varchar(16) default NULL,
429 `surname` mediumtext NOT NULL,
432 `othernames` mediumtext,
434 `streetnumber` varchar(10) default NULL,
435 `streettype` varchar(50) default NULL,
436 `address` mediumtext NOT NULL,
438 `city` mediumtext NOT NULL,
439 `zipcode` varchar(25) default NULL,
442 `mobile` varchar(50) default NULL,
446 `B_streetnumber` varchar(10) default NULL,
447 `B_streettype` varchar(50) default NULL,
448 `B_address` varchar(100) default NULL,
450 `B_zipcode` varchar(25) default NULL,
452 `B_phone` mediumtext,
453 `dateofbirth` date default NULL,
454 `branchcode` varchar(10) NOT NULL default '',
455 `categorycode` varchar(10) NOT NULL default '',
456 `dateenrolled` date default NULL,
457 `dateexpiry` date default NULL,
458 `gonenoaddress` tinyint(1) default NULL,
459 `lost` tinyint(1) default NULL,
460 `debarred` tinyint(1) default NULL,
461 `contactname` mediumtext,
462 `contactfirstname` text,
464 `guarantorid` int(11) default NULL,
465 `borrowernotes` mediumtext,
466 `relationship` varchar(100) default NULL,
467 `ethnicity` varchar(50) default NULL,
468 `ethnotes` varchar(255) default NULL,
469 `sex` varchar(1) default NULL,
470 `password` varchar(30) default NULL,
471 `flags` int(11) default NULL,
472 `userid` varchar(30) default NULL,
473 `opacnote` mediumtext,
474 `contactnote` varchar(255) default NULL,
475 `sort1` varchar(80) default NULL,
476 `sort2` varchar(80) default NULL,
477 UNIQUE KEY `cardnumber` (`cardnumber`),
478 KEY `borrowernumber` (`borrowernumber`),
479 KEY `categorycode` (`categorycode`),
480 KEY `branchcode` (`branchcode`),
481 KEY `userid` (`userid`),
482 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
483 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
484 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
487 -- Table structure for table `branchcategories`
490 DROP TABLE IF EXISTS `branchcategories`;
491 CREATE TABLE `branchcategories` (
492 `categorycode` varchar(10) NOT NULL default '',
493 `categoryname` varchar(32),
494 `codedescription` mediumtext,
495 `categorytype` varchar(16),
496 PRIMARY KEY (`categorycode`)
497 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
500 -- Table structure for table `branches`
503 DROP TABLE IF EXISTS `branches`;
504 CREATE TABLE `branches` (
505 `branchcode` varchar(10) NOT NULL default '',
506 `branchname` mediumtext NOT NULL,
507 `branchaddress1` mediumtext,
508 `branchaddress2` mediumtext,
509 `branchaddress3` mediumtext,
510 `branchphone` mediumtext,
511 `branchfax` mediumtext,
512 `branchemail` mediumtext,
513 `issuing` tinyint(4) default NULL,
514 `branchip` varchar(15) default NULL,
515 `branchprinter` varchar(100) default NULL,
516 UNIQUE KEY `branchcode` (`branchcode`)
517 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
520 -- Table structure for table `branchrelations`
523 DROP TABLE IF EXISTS `branchrelations`;
524 CREATE TABLE `branchrelations` (
525 `branchcode` varchar(10) NOT NULL default '',
526 `categorycode` varchar(10) NOT NULL default '',
527 PRIMARY KEY (`branchcode`,`categorycode`),
528 KEY `branchcode` (`branchcode`),
529 KEY `categorycode` (`categorycode`),
530 CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
531 CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
532 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
535 -- Table structure for table `branchtransfers`
538 DROP TABLE IF EXISTS `branchtransfers`;
539 CREATE TABLE `branchtransfers` (
540 `itemnumber` int(11) NOT NULL default 0,
541 `datesent` datetime default NULL,
542 `frombranch` varchar(10) NOT NULL default '',
543 `datearrived` datetime default NULL,
544 `tobranch` varchar(10) NOT NULL default '',
545 `comments` mediumtext,
546 KEY `frombranch` (`frombranch`),
547 KEY `tobranch` (`tobranch`),
548 KEY `itemnumber` (`itemnumber`),
549 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
550 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
551 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
556 -- Table structure for table `browser`
558 DROP TABLE IF EXISTS `browser`;
559 CREATE TABLE `browser` (
560 `level` int(11) NOT NULL,
561 `classification` varchar(20) NOT NULL,
562 `description` varchar(255) NOT NULL,
563 `number` bigint(20) NOT NULL,
564 `endnode` tinyint(4) NOT NULL
565 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
568 -- Table structure for table `categories`
571 DROP TABLE IF EXISTS `categories`;
572 CREATE TABLE `categories` (
573 `categorycode` varchar(10) NOT NULL default '',
574 `description` mediumtext,
575 `enrolmentperiod` smallint(6) default NULL,
576 `upperagelimit` smallint(6) default NULL,
577 `dateofbirthrequired` tinyint(1) default NULL,
578 `finetype` varchar(30) default NULL,
579 `bulk` tinyint(1) default NULL,
580 `enrolmentfee` decimal(28,6) default NULL,
581 `overduenoticerequired` tinyint(1) default NULL,
582 `issuelimit` smallint(6) default NULL,
583 `reservefee` decimal(28,6) default NULL,
584 `category_type` varchar(1) NOT NULL default 'A',
585 PRIMARY KEY (`categorycode`),
586 UNIQUE KEY `categorycode` (`categorycode`)
587 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
590 -- Table structure for table `categorytable`
593 DROP TABLE IF EXISTS `categorytable`;
594 CREATE TABLE `categorytable` (
595 `categorycode` varchar(5) NOT NULL default '',
597 `itemtypecodes` text,
598 PRIMARY KEY (`categorycode`)
599 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
602 -- Table structure for table `cities`
605 DROP TABLE IF EXISTS `cities`;
606 CREATE TABLE `cities` (
607 `cityid` int(11) NOT NULL auto_increment,
608 `city_name` varchar(100) NOT NULL default '',
609 `city_zipcode` varchar(20) default NULL,
610 PRIMARY KEY (`cityid`)
611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
614 -- Table structure for table `class_sort_rules`
617 DROP TABLE IF EXISTS `class_sort_rules`;
618 CREATE TABLE `class_sort_rules` (
619 `class_sort_rule` varchar(10) NOT NULL default '',
620 `description` mediumtext,
621 `sort_routine` varchar(30) NOT NULL default '',
622 PRIMARY KEY (`class_sort_rule`),
623 UNIQUE KEY `class_sort_rule_idx` (`class_sort_rule`)
624 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
627 -- Table structure for table `class_sources`
630 DROP TABLE IF EXISTS `class_sources`;
631 CREATE TABLE `class_sources` (
632 `cn_source` varchar(10) NOT NULL default '',
633 `description` mediumtext,
634 `used` tinyint(4) NOT NULL default 0,
635 `class_sort_rule` varchar(10) NOT NULL default '',
636 PRIMARY KEY (`cn_source`),
637 UNIQUE KEY `cn_source_idx` (`cn_source`),
638 KEY `used_idx` (`used`),
639 CONSTRAINT `class_source_ibfk_1` FOREIGN KEY (`class_sort_rule`) REFERENCES `class_sort_rules` (`class_sort_rule`)
640 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
643 -- Table structure for table `currency`
646 DROP TABLE IF EXISTS `currency`;
647 CREATE TABLE `currency` (
648 `currency` varchar(10) NOT NULL default '',
649 `rate` float(7,5) default NULL,
650 PRIMARY KEY (`currency`)
651 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
654 -- Table structure for table `deletedbiblio`
657 DROP TABLE IF EXISTS `deletedbiblio`;
658 CREATE TABLE `deletedbiblio` (
659 `biblionumber` int(11) NOT NULL default 0,
660 `frameworkcode` varchar(4) NOT NULL default '',
663 `unititle` mediumtext,
665 `serial` tinyint(1) default NULL,
666 `seriestitle` mediumtext,
667 `copyrightdate` smallint(6) default NULL,
668 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
669 `datecreated` DATE NOT NULL,
670 `abstract` mediumtext,
671 PRIMARY KEY (`biblionumber`),
672 KEY `blbnoidx` (`biblionumber`)
673 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
676 -- Table structure for table `deletedbiblioitems`
679 DROP TABLE IF EXISTS `deletedbiblioitems`;
680 CREATE TABLE `deletedbiblioitems` (
681 `biblioitemnumber` int(11) NOT NULL default 0,
682 `biblionumber` int(11) NOT NULL default 0,
685 `itemtype` varchar(10) default NULL,
686 `isbn` varchar(14) default NULL,
687 `issn` varchar(9) default NULL,
688 `publicationyear` text,
689 `publishercode` varchar(255) default NULL,
690 `volumedate` date default NULL,
692 `collectiontitle` mediumtext default NULL,
693 `collectionissn` text default NULL,
694 `collectionvolume` mediumtext default NULL,
695 `editionstatement` text default NULL,
696 `editionresponsibility` text default NULL,
697 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
698 `illus` varchar(255) default NULL,
699 `pages` varchar(255) default NULL,
701 `size` varchar(255) default NULL,
702 `place` varchar(255) default NULL,
703 `lccn` varchar(25) default NULL,
705 `url` varchar(255) default NULL,
706 `cn_source` varchar(10) default NULL,
707 `cn_class` varchar(30) default NULL,
708 `cn_item` varchar(10) default NULL,
709 `cn_suffix` varchar(10) default NULL,
710 `cn_sort` varchar(30) default NULL,
711 `totalissues` int(10),
712 `marcxml` longtext NOT NULL,
713 PRIMARY KEY (`biblioitemnumber`),
714 KEY `bibinoidx` (`biblioitemnumber`),
715 KEY `bibnoidx` (`biblionumber`),
717 KEY `publishercode` (`publishercode`)
718 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
721 -- Table structure for table `deletedborrowers`
724 DROP TABLE IF EXISTS `deletedborrowers`;
725 CREATE TABLE `deletedborrowers` (
726 `borrowernumber` int(11) NOT NULL default 0,
727 `cardnumber` varchar(9) NOT NULL default '',
728 `surname` mediumtext NOT NULL,
731 `othernames` mediumtext,
733 `streetnumber` varchar(10) default NULL,
734 `streettype` varchar(50) default NULL,
735 `address` mediumtext NOT NULL,
737 `city` mediumtext NOT NULL,
738 `zipcode` varchar(25) default NULL,
741 `mobile` varchar(50) default NULL,
745 `B_streetnumber` varchar(10) default NULL,
746 `B_streettype` varchar(50) default NULL,
747 `B_address` varchar(100) default NULL,
749 `B_zipcode` varchar(25) default NULL,
751 `B_phone` mediumtext,
752 `dateofbirth` date default NULL,
753 `branchcode` varchar(10) NOT NULL default '',
754 `categorycode` varchar(2) default NULL,
755 `dateenrolled` date default NULL,
756 `dateexpiry` date default NULL,
757 `gonenoaddress` tinyint(1) default NULL,
758 `lost` tinyint(1) default NULL,
759 `debarred` tinyint(1) default NULL,
760 `contactname` mediumtext,
761 `contactfirstname` text,
763 `guarantorid` int(11) default NULL,
764 `borrowernotes` mediumtext,
765 `relationship` varchar(100) default NULL,
766 `ethnicity` varchar(50) default NULL,
767 `ethnotes` varchar(255) default NULL,
768 `sex` varchar(1) default NULL,
769 `password` varchar(30) default NULL,
770 `flags` int(11) default NULL,
771 `userid` varchar(30) default NULL,
772 `opacnote` mediumtext,
773 `contactnote` varchar(255) default NULL,
774 `sort1` varchar(80) default NULL,
775 `sort2` varchar(80) default NULL,
776 KEY `borrowernumber` (`borrowernumber`),
777 KEY `cardnumber` (`cardnumber`)
778 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
781 -- Table structure for table `deleteditems`
784 DROP TABLE IF EXISTS `deleteditems`;
785 CREATE TABLE `deleteditems` (
786 `itemnumber` int(11) NOT NULL default 0,
787 `biblionumber` int(11) NOT NULL default 0,
788 `biblioitemnumber` int(11) NOT NULL default 0,
789 `barcode` varchar(20) default NULL,
790 `dateaccessioned` date default NULL,
791 `booksellerid` varchar(10) default NULL,
792 `homebranch` varchar(4) default NULL,
793 `price` decimal(8,2) default NULL,
794 `replacementprice` decimal(8,2) default NULL,
795 `replacementpricedate` date default NULL,
796 `datelastborrowed` date default NULL,
797 `datelastseen` date default NULL,
798 `stack` tinyint(1) default NULL,
799 `notforloan` tinyint(1) default NULL,
800 `damaged` tinyint(1) default NULL,
801 `itemlost` tinyint(1) default NULL,
802 `wthdrawn` tinyint(1) default NULL,
803 `itemcallnumber` varchar(30) default NULL,
804 `issues` smallint(6) default NULL,
805 `renewals` smallint(6) default NULL,
806 `reserves` smallint(6) default NULL,
807 `restricted` tinyint(1) default NULL,
808 `itemnotes` mediumtext,
809 `holdingbranch` varchar(10) default NULL,
810 `paidfor` mediumtext,
811 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
812 `location` varchar(80) default NULL,
813 `onloan` date default NULL,
814 `cn_source` varchar(10) default NULL,
815 `cn_sort` varchar(30) default NULL,
816 `ccode` varchar(10) default NULL,
817 `materials` varchar(10) default NULL,
818 `uri` varchar(255) default NULL,
820 PRIMARY KEY (`itemnumber`),
821 UNIQUE KEY `delitembarcodeidx` (`barcode`),
822 KEY `delitembinoidx` (`biblioitemnumber`),
823 KEY `delitembibnoidx` (`biblionumber`),
824 KEY `delhomebranch` (`homebranch`),
825 KEY `delholdingbranch` (`holdingbranch`)
826 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
829 -- Table structure for table `ethnicity`
832 DROP TABLE IF EXISTS `ethnicity`;
833 CREATE TABLE `ethnicity` (
834 `code` varchar(10) NOT NULL default '',
835 `name` varchar(255) default NULL,
837 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
840 -- Table structure for table `import_batches`
843 DROP TABLE IF EXISTS `import_batches`;
844 CREATE TABLE `import_batches` (
845 `import_batch_id` int(11) NOT NULL auto_increment,
846 `template_id` int(11) default NULL,
847 `branchcode` varchar(10) default NULL,
848 `num_biblios` int(11) NOT NULL default 0,
849 `num_items` int(11) NOT NULL default 0,
850 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
851 `overlay_action` enum('replace', 'create_new', 'use_template') NOT NULL default 'create_new',
852 `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging',
853 `batch_type` enum('batch', 'z3950') NOT NULL default 'batch',
854 `file_name` varchar(100),
855 `comments` mediumtext,
856 PRIMARY KEY (`import_batch_id`),
857 KEY `branchcode` (`branchcode`)
858 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
861 -- Table structure for table `import_records`
864 DROP TABLE IF EXISTS `import_records`;
865 CREATE TABLE `import_records` (
866 `import_record_id` int(11) NOT NULL auto_increment,
867 `import_batch_id` int(11) NOT NULL,
868 `branchcode` varchar(10) default NULL,
869 `record_sequence` int(11) NOT NULL default 0,
870 `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
871 `import_date` DATE default NULL,
872 `marc` longblob NOT NULL,
873 `marcxml` longtext NOT NULL,
874 `marcxml_old` longtext NOT NULL,
875 `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio',
876 `overlay_status` enum('no_match', 'auto_match', 'manual_match', 'match_applied') NOT NULL default 'no_match',
877 `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted') NOT NULL default 'staged',
878 `import_error` mediumtext,
879 `encoding` varchar(40) NOT NULL default '',
880 `z3950random` varchar(40) default NULL,
881 PRIMARY KEY (`import_record_id`),
882 CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
883 REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
884 KEY `branchcode` (`branchcode`),
885 KEY `batch_sequence` (`import_batch_id`, `record_sequence`)
886 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
889 -- Table structure for `import_record_matches`
891 DROP TABLE IF EXISTS `import_record_matches`;
892 CREATE TABLE `import_record_matches` (
893 `import_record_id` int(11) NOT NULL,
894 `candidate_match_id` int(11) NOT NULL,
895 `score` int(11) NOT NULL default 0,
896 CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
897 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
898 KEY `record_score` (`import_record_id`, `score`)
899 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
902 -- Table structure for table `import_biblios`
905 DROP TABLE IF EXISTS `import_biblios`;
906 CREATE TABLE `import_biblios` (
907 `import_record_id` int(11) NOT NULL,
908 `matched_biblionumber` int(11) default NULL,
909 `control_number` varchar(25) default NULL,
910 `original_source` varchar(25) default NULL,
911 `title` varchar(128) default NULL,
912 `author` varchar(80) default NULL,
913 `isbn` varchar(14) default NULL,
914 `issn` varchar(9) default NULL,
915 `has_items` tinyint(1) NOT NULL default 0,
916 CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
917 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
918 KEY `matched_biblionumber` (`matched_biblionumber`),
919 KEY `title` (`title`),
921 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
924 -- Table structure for table `import_items`
927 DROP TABLE IF EXISTS `import_items`;
928 CREATE TABLE `import_items` (
929 `import_items_id` int(11) NOT NULL auto_increment,
930 `import_record_id` int(11) NOT NULL,
931 `itemnumber` int(11) default NULL,
932 `branchcode` varchar(10) default NULL,
933 `status` enum('error', 'staged', 'imported', 'reverted') NOT NULL default 'staged',
934 `marcxml` longtext NOT NULL,
935 `import_error` mediumtext,
936 PRIMARY KEY (`import_items_id`),
937 CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`)
938 REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
939 KEY `itemnumber` (`itemnumber`),
940 KEY `branchcode` (`branchcode`)
941 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
944 -- Table structure for table `issues`
947 DROP TABLE IF EXISTS `issues`;
948 CREATE TABLE `issues` (
949 `borrowernumber` int(11) default NULL,
950 `itemnumber` int(11) default NULL,
951 `date_due` date default NULL,
952 `branchcode` varchar(10) default NULL,
953 `issuingbranch` varchar(18) default NULL,
954 `returndate` date default NULL,
955 `lastreneweddate` date default NULL,
956 `return` varchar(4) default NULL,
957 `renewals` tinyint(4) default NULL,
958 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
959 `issuedate` date default NULL,
960 KEY `issuesborridx` (`borrowernumber`),
961 KEY `issuesitemidx` (`itemnumber`),
962 KEY `bordate` (`borrowernumber`,`timestamp`),
963 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
964 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
965 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
968 -- Table structure for table `issuingrules`
971 DROP TABLE IF EXISTS `issuingrules`;
972 CREATE TABLE `issuingrules` (
973 `categorycode` varchar(10) NOT NULL default '',
974 `itemtype` varchar(10) NOT NULL default '',
975 `restrictedtype` tinyint(1) default NULL,
976 `rentaldiscount` decimal(28,6) default NULL,
977 `reservecharge` decimal(28,6) default NULL,
978 `fine` decimal(28,6) default NULL,
979 `firstremind` int(11) default NULL,
980 `chargeperiod` int(11) default NULL,
981 `accountsent` int(11) default NULL,
982 `chargename` varchar(100) default NULL,
983 `maxissueqty` int(4) default NULL,
984 `issuelength` int(4) default NULL,
985 `branchcode` varchar(10) NOT NULL default '',
986 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
987 KEY `categorycode` (`categorycode`),
988 KEY `itemtype` (`itemtype`)
989 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
992 -- Table structure for table `items`
995 DROP TABLE IF EXISTS `items`;
996 CREATE TABLE `items` (
997 `itemnumber` int(11) NOT NULL default 0,
998 `biblionumber` int(11) NOT NULL default 0,
999 `biblioitemnumber` int(11) NOT NULL default 0,
1000 `barcode` varchar(20) default NULL,
1001 `dateaccessioned` date default NULL,
1002 `booksellerid` varchar(10) default NULL,
1003 `homebranch` varchar(4) default NULL,
1004 `price` decimal(8,2) default NULL,
1005 `replacementprice` decimal(8,2) default NULL,
1006 `replacementpricedate` date default NULL,
1007 `datelastborrowed` date default NULL,
1008 `datelastseen` date default NULL,
1009 `stack` tinyint(1) default NULL,
1010 `notforloan` tinyint(1) default NULL,
1011 `damaged` tinyint(1) default NULL,
1012 `itemlost` tinyint(1) default NULL,
1013 `wthdrawn` tinyint(1) default NULL,
1014 `itemcallnumber` varchar(30) default NULL,
1015 `issues` smallint(6) default NULL,
1016 `renewals` smallint(6) default NULL,
1017 `reserves` smallint(6) default NULL,
1018 `restricted` tinyint(1) default NULL,
1019 `itemnotes` mediumtext,
1020 `holdingbranch` varchar(10) default NULL,
1021 `paidfor` mediumtext,
1022 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1023 `location` varchar(80) default NULL,
1024 `onloan` date default NULL,
1025 `cn_source` varchar(10) default NULL,
1026 `cn_sort` varchar(30) default NULL,
1027 `ccode` varchar(10) default NULL,
1028 `materials` varchar(10) default NULL,
1029 `uri` varchar(255) default NULL,
1030 PRIMARY KEY (`itemnumber`),
1031 UNIQUE KEY `itembarcodeidx` (`barcode`),
1032 KEY `itembinoidx` (`biblioitemnumber`),
1033 KEY `itembibnoidx` (`biblionumber`),
1034 KEY `homebranch` (`homebranch`),
1035 KEY `holdingbranch` (`holdingbranch`),
1036 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1037 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1038 CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE
1039 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1042 -- Table structure for table `itemtypes`
1045 DROP TABLE IF EXISTS `itemtypes`;
1046 CREATE TABLE `itemtypes` (
1047 `itemtype` varchar(10) NOT NULL default '',
1048 `description` mediumtext,
1049 `renewalsallowed` smallint(6) default NULL,
1050 `rentalcharge` double(16,4) default NULL,
1051 `notforloan` smallint(6) default NULL,
1052 `imageurl` varchar(200) default NULL,
1054 PRIMARY KEY (`itemtype`),
1055 UNIQUE KEY `itemtype` (`itemtype`)
1056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1059 -- Table structure for table `labels`
1062 DROP TABLE IF EXISTS `labels`;
1063 CREATE TABLE `labels` (
1064 `labelid` int(11) NOT NULL auto_increment,
1065 `batch_id` varchar(10) NOT NULL default 1,
1066 `itemnumber` varchar(100) NOT NULL default '',
1067 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1068 PRIMARY KEY (`labelid`)
1069 ) ENGINE=MyISAM AUTO_INCREMENT=12143 DEFAULT CHARSET=utf8;
1072 -- Table structure for table `labels_conf`
1075 DROP TABLE IF EXISTS `labels_conf`;
1076 CREATE TABLE `labels_conf` (
1077 `id` int(4) NOT NULL auto_increment,
1078 `barcodetype` varchar(100) default '',
1079 `title` int(1) default 0,
1080 `itemtype` int(1) default 0,
1081 `barcode` int(1) default 0,
1082 `dewey` int(1) default 0,
1083 `class` int(1) default 0,
1084 `subclass` int(1) default 0,
1085 `itemcallnumber` int(1) default 0,
1086 `author` int(1) default 0,
1087 `issn` int(1) default 0,
1088 `isbn` int(1) default 0,
1089 `startlabel` int(2) NOT NULL default 1,
1090 `printingtype` varchar(32) default 'BAR',
1091 `layoutname` varchar(20) NOT NULL default 'TEST',
1092 `guidebox` int(1) default 0,
1093 `active` tinyint(1) default 1,
1094 `fonttype` varchar(10) default NULL,
1095 `subtitle` int(1) default NULL,
1097 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1100 -- Table structure for table `labels_templates`
1103 DROP TABLE IF EXISTS `labels_templates`;
1104 CREATE TABLE `labels_templates` (
1105 `tmpl_id` int(4) NOT NULL auto_increment,
1106 `tmpl_code` varchar(100) character set utf8 collate utf8_unicode_ci default '',
1107 `tmpl_desc` varchar(100) character set utf8 collate utf8_unicode_ci default '',
1108 `page_width` float default 0,
1109 `page_height` float default 0,
1110 `label_width` float default 0,
1111 `label_height` float default 0,
1112 `topmargin` float default 0,
1113 `leftmargin` float default 0,
1114 `cols` int(2) default 0,
1115 `rows` int(2) default 0,
1116 `colgap` float default 0,
1117 `rowgap` float default 0,
1118 `active` int(1) default NULL,
1119 `units` varchar(20) character set utf8 collate utf8_unicode_ci default 'PX',
1120 `fontsize` int(4) NOT NULL default 3,
1121 PRIMARY KEY (`tmpl_id`)
1122 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1125 -- Table structure for table `letter`
1128 DROP TABLE IF EXISTS `letter`;
1129 CREATE TABLE `letter` (
1130 `module` varchar(20) NOT NULL default '',
1131 `code` varchar(20) NOT NULL default '',
1132 `name` varchar(100) NOT NULL default '',
1133 `title` varchar(200) NOT NULL default '',
1135 PRIMARY KEY (`module`,`code`)
1136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1139 -- Table structure for table `marc_subfield_structure`
1142 DROP TABLE IF EXISTS `marc_subfield_structure`;
1143 CREATE TABLE `marc_subfield_structure` (
1144 `tagfield` varchar(3) NOT NULL default '',
1145 `tagsubfield` varchar(1) NOT NULL default '',
1146 `liblibrarian` varchar(255) NOT NULL default '',
1147 `libopac` varchar(255) NOT NULL default '',
1148 `repeatable` tinyint(4) NOT NULL default 0,
1149 `mandatory` tinyint(4) NOT NULL default 0,
1150 `kohafield` varchar(40) default NULL,
1151 `tab` tinyint(1) default NULL,
1152 `authorised_value` varchar(10) default NULL,
1153 `authtypecode` varchar(10) default NULL,
1154 `value_builder` varchar(80) default NULL,
1155 `isurl` tinyint(1) default NULL,
1156 `hidden` tinyint(1) default NULL,
1157 `frameworkcode` varchar(4) NOT NULL default '',
1158 `seealso` varchar(255) default NULL,
1159 `link` varchar(80) default NULL,
1160 `defaultvalue` text default NULL,
1161 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1162 KEY `kohafield_2` (`kohafield`),
1163 KEY `tab` (`frameworkcode`,`tab`),
1164 KEY `kohafield` (`frameworkcode`,`kohafield`)
1165 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1168 -- Table structure for table `marc_tag_structure`
1171 DROP TABLE IF EXISTS `marc_tag_structure`;
1172 CREATE TABLE `marc_tag_structure` (
1173 `tagfield` varchar(3) NOT NULL default '',
1174 `liblibrarian` varchar(255) NOT NULL default '',
1175 `libopac` varchar(255) NOT NULL default '',
1176 `repeatable` tinyint(4) NOT NULL default 0,
1177 `mandatory` tinyint(4) NOT NULL default 0,
1178 `authorised_value` varchar(10) default NULL,
1179 `frameworkcode` varchar(4) NOT NULL default '',
1180 PRIMARY KEY (`frameworkcode`,`tagfield`)
1181 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1184 -- Table structure for table `mediatypetable`
1187 DROP TABLE IF EXISTS `mediatypetable`;
1188 CREATE TABLE `mediatypetable` (
1189 `mediatypecode` varchar(5) NOT NULL default '',
1191 `itemtypecodes` text,
1192 PRIMARY KEY (`mediatypecode`)
1193 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1196 -- Table structure for table `notifys`
1199 DROP TABLE IF EXISTS `notifys`;
1200 CREATE TABLE `notifys` (
1201 `notify_id` int(11) NOT NULL default 0,
1202 `borrowernumber` int(11) NOT NULL default 0,
1203 `itemnumber` int(11) NOT NULL default 0,
1204 `notify_date` date default NULL,
1205 `notify_send_date` date default NULL,
1206 `notify_level` int(1) NOT NULL default 0,
1207 `method` varchar(20) NOT NULL default ''
1208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1211 -- Table structure for table `nozebra`
1213 CREATE TABLE `nozebra` (
1214 `server` varchar(20) NOT NULL,
1215 `indexname` varchar(40) NOT NULL,
1216 `value` varchar(250) NOT NULL,
1217 `biblionumbers` longtext NOT NULL,
1218 KEY `indexname` (`server`,`indexname`),
1219 KEY `value` (`server`,`value`))
1220 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1223 -- Table structure for table `opac_news`
1226 DROP TABLE IF EXISTS `opac_news`;
1227 CREATE TABLE `opac_news` (
1228 `idnew` int(10) unsigned NOT NULL auto_increment,
1229 `title` varchar(250) NOT NULL default '',
1230 `new` text NOT NULL,
1231 `lang` varchar(4) NOT NULL default '',
1232 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1233 `expirationdate` date default NULL,
1234 `number` int(11) default NULL,
1235 PRIMARY KEY (`idnew`)
1236 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1239 -- Table structure for table `overduerules`
1242 DROP TABLE IF EXISTS `overduerules`;
1243 CREATE TABLE `overduerules` (
1244 `branchcode` varchar(10) NOT NULL default '',
1245 `categorycode` varchar(2) NOT NULL default '',
1246 `delay1` int(4) default 0,
1247 `letter1` varchar(20) default NULL,
1248 `debarred1` varchar(1) default 0,
1249 `delay2` int(4) default 0,
1250 `debarred2` varchar(1) default 0,
1251 `letter2` varchar(20) default NULL,
1252 `delay3` int(4) default 0,
1253 `letter3` varchar(20) default NULL,
1254 `debarred3` int(1) default 0,
1255 PRIMARY KEY (`branchcode`,`categorycode`)
1256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1259 -- Table structure for table `printers`
1262 DROP TABLE IF EXISTS `printers`;
1263 CREATE TABLE `printers` (
1264 `printername` varchar(40) NOT NULL default '',
1265 `printqueue` varchar(20) default NULL,
1266 `printtype` varchar(20) default NULL,
1267 PRIMARY KEY (`printername`)
1268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1271 -- Table structure for table `repeatable_holidays`
1274 DROP TABLE IF EXISTS `repeatable_holidays`;
1275 CREATE TABLE `repeatable_holidays` (
1276 `id` int(11) NOT NULL auto_increment,
1277 `branchcode` varchar(10) NOT NULL default '',
1278 `weekday` smallint(6) default NULL,
1279 `day` smallint(6) default NULL,
1280 `month` smallint(6) default NULL,
1281 `title` varchar(50) NOT NULL default '',
1282 `description` text NOT NULL,
1284 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1287 -- Table structure for table `reserveconstraints`
1290 DROP TABLE IF EXISTS `reserveconstraints`;
1291 CREATE TABLE `reserveconstraints` (
1292 `borrowernumber` int(11) NOT NULL default 0,
1293 `reservedate` date default NULL,
1294 `biblionumber` int(11) NOT NULL default 0,
1295 `biblioitemnumber` int(11) default NULL,
1296 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1297 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1300 -- Table structure for table `reserves`
1303 DROP TABLE IF EXISTS `reserves`;
1304 CREATE TABLE `reserves` (
1305 `borrowernumber` int(11) NOT NULL default 0,
1306 `reservedate` date default NULL,
1307 `biblionumber` int(11) NOT NULL default 0,
1308 `constrainttype` varchar(1) default NULL,
1309 `branchcode` varchar(10) default NULL,
1310 `notificationdate` date default NULL,
1311 `reminderdate` date default NULL,
1312 `cancellationdate` date default NULL,
1313 `reservenotes` mediumtext,
1314 `priority` smallint(6) default NULL,
1315 `found` varchar(1) default NULL,
1316 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1317 `itemnumber` int(11) default NULL,
1318 `waitingdate` date default NULL,
1319 KEY `borrowernumber` (`borrowernumber`),
1320 KEY `biblionumber` (`biblionumber`),
1321 KEY `itemnumber` (`itemnumber`),
1322 KEY `branchcode` (`branchcode`),
1323 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1324 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1325 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1326 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1327 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1330 -- Table structure for table `reviews`
1333 DROP TABLE IF EXISTS `reviews`;
1334 CREATE TABLE `reviews` (
1335 `reviewid` int(11) NOT NULL auto_increment,
1336 `borrowernumber` int(11) default NULL,
1337 `biblionumber` int(11) default NULL,
1339 `approved` tinyint(4) default NULL,
1340 `datereviewed` datetime default NULL,
1341 PRIMARY KEY (`reviewid`)
1342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1345 -- Table structure for table `roadtype`
1348 DROP TABLE IF EXISTS `roadtype`;
1349 CREATE TABLE `roadtype` (
1350 `roadtypeid` int(11) NOT NULL auto_increment,
1351 `road_type` varchar(100) NOT NULL default '',
1352 PRIMARY KEY (`roadtypeid`)
1353 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1356 -- Table structure for table `saved_sql`
1359 DROP TABLE IF EXISTS `saved_sql`;
1360 CREATE TABLE saved_sql (
1361 `id` int(11) NOT NULL auto_increment,
1362 `borrowernumber` int(11) default NULL,
1363 `date_created` datetime default NULL,
1364 `last_modified` datetime default NULL,
1366 `last_run` datetime default NULL,
1367 `report_name` varchar(255) default NULL,
1368 `type` varchar(255) default NULL,
1371 KEY boridx (`borrowernumber`)
1372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1376 -- Table structure for `saved_reports`
1379 DROP TABLE IF EXISTS `saved_reports`;
1380 CREATE TABLE saved_reports (
1381 `id` int(11) NOT NULL auto_increment,
1382 `report_id` int(11) default NULL,
1384 `date_run` datetime default NULL,
1386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1390 -- Table structure for table `serial`
1393 DROP TABLE IF EXISTS `serial`;
1394 CREATE TABLE `serial` (
1395 `serialid` int(11) NOT NULL auto_increment,
1396 `biblionumber` varchar(100) NOT NULL default '',
1397 `subscriptionid` varchar(100) NOT NULL default '',
1398 `serialseq` varchar(100) NOT NULL default '',
1399 `status` tinyint(4) NOT NULL default 0,
1400 `planneddate` date default NULL,
1402 `publisheddate` date default NULL,
1404 `claimdate` date default NULL,
1405 `routingnotes` text,
1406 PRIMARY KEY (`serialid`)
1407 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1410 -- Table structure for table `sessions`
1413 DROP TABLE IF EXISTS sessions;
1414 CREATE TABLE sessions (
1415 `id` varchar(32) NOT NULL,
1416 `a_session` text NOT NULL,
1418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1421 -- Table structure for table `special_holidays`
1424 DROP TABLE IF EXISTS `special_holidays`;
1425 CREATE TABLE `special_holidays` (
1426 `id` int(11) NOT NULL auto_increment,
1427 `branchcode` varchar(10) NOT NULL default '',
1428 `day` smallint(6) NOT NULL default 0,
1429 `month` smallint(6) NOT NULL default 0,
1430 `year` smallint(6) NOT NULL default 0,
1431 `isexception` smallint(1) NOT NULL default 1,
1432 `title` varchar(50) NOT NULL default '',
1433 `description` text NOT NULL,
1435 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1438 -- Table structure for table `statistics`
1441 DROP TABLE IF EXISTS `statistics`;
1442 CREATE TABLE `statistics` (
1443 `datetime` datetime default NULL,
1444 `branch` varchar(10) default NULL,
1445 `proccode` varchar(4) default NULL,
1446 `value` double(16,4) default NULL,
1447 `type` varchar(16) default NULL,
1449 `usercode` varchar(10) default NULL,
1450 `itemnumber` int(11) default NULL,
1451 `itemtype` varchar(10) default NULL,
1452 `borrowernumber` int(11) default NULL,
1453 `associatedborrower` int(11) default NULL,
1454 KEY `timeidx` (`datetime`)
1455 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1458 -- Table structure for table `stopwords`
1461 DROP TABLE IF EXISTS `stopwords`;
1462 CREATE TABLE `stopwords` (
1463 `word` varchar(255) default NULL
1464 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1467 -- Table structure for table `subcategorytable`
1470 DROP TABLE IF EXISTS `subcategorytable`;
1471 CREATE TABLE `subcategorytable` (
1472 `subcategorycode` varchar(5) NOT NULL default '',
1474 `itemtypecodes` text,
1475 PRIMARY KEY (`subcategorycode`)
1476 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1479 -- Table structure for table `subscription`
1482 DROP TABLE IF EXISTS `subscription`;
1483 CREATE TABLE `subscription` (
1484 `biblionumber` int(11) NOT NULL default 0,
1485 `subscriptionid` int(11) NOT NULL auto_increment,
1486 `librarian` varchar(100) default '',
1487 `startdate` date default NULL,
1488 `aqbooksellerid` int(11) default 0,
1489 `cost` int(11) default 0,
1490 `aqbudgetid` int(11) default 0,
1491 `weeklength` tinyint(4) default 0,
1492 `monthlength` tinyint(4) default 0,
1493 `numberlength` tinyint(4) default 0,
1494 `periodicity` tinyint(4) default 0,
1495 `dow` varchar(100) default '',
1496 `numberingmethod` varchar(100) default '',
1498 `status` varchar(100) NOT NULL default '',
1499 `add1` int(11) default 0,
1500 `every1` int(11) default 0,
1501 `whenmorethan1` int(11) default 0,
1502 `setto1` int(11) default NULL,
1503 `lastvalue1` int(11) default NULL,
1504 `add2` int(11) default 0,
1505 `every2` int(11) default 0,
1506 `whenmorethan2` int(11) default 0,
1507 `setto2` int(11) default NULL,
1508 `lastvalue2` int(11) default NULL,
1509 `add3` int(11) default 0,
1510 `every3` int(11) default 0,
1511 `innerloop1` int(11) default 0,
1512 `innerloop2` int(11) default 0,
1513 `innerloop3` int(11) default 0,
1514 `whenmorethan3` int(11) default 0,
1515 `setto3` int(11) default NULL,
1516 `lastvalue3` int(11) default NULL,
1517 `issuesatonce` tinyint(3) NOT NULL default 1,
1518 `firstacquidate` date default NULL,
1519 `manualhistory` tinyint(1) NOT NULL default 0,
1520 `irregularity` text,
1521 `letter` varchar(20) default NULL,
1522 `numberpattern` tinyint(3) default 0,
1523 `distributedto` text,
1524 `internalnotes` longtext,
1526 `branchcode` varchar(10) NOT NULL default '',
1527 `hemisphere` tinyint(3) default 0,
1528 `lastbranch` varchar(4),
1529 PRIMARY KEY (`subscriptionid`)
1530 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1533 -- Table structure for table `subscriptionhistory`
1536 DROP TABLE IF EXISTS `subscriptionhistory`;
1537 CREATE TABLE `subscriptionhistory` (
1538 `biblionumber` int(11) NOT NULL default 0,
1539 `subscriptionid` int(11) NOT NULL default 0,
1540 `histstartdate` date default NULL,
1541 `enddate` date default NULL,
1542 `missinglist` longtext NOT NULL,
1543 `recievedlist` longtext NOT NULL,
1544 `opacnote` varchar(150) NOT NULL default '',
1545 `librariannote` varchar(150) NOT NULL default '',
1546 PRIMARY KEY (`subscriptionid`),
1547 KEY `biblionumber` (`biblionumber`)
1548 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1551 -- Table structure for table `subscriptionroutinglist`
1554 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1555 CREATE TABLE `subscriptionroutinglist` (
1556 `routingid` int(11) NOT NULL auto_increment,
1557 `borrowernumber` int(11) default NULL,
1558 `ranking` int(11) default NULL,
1559 `subscriptionid` int(11) default NULL,
1560 PRIMARY KEY (`routingid`)
1561 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1564 -- Table structure for table `suggestions`
1567 DROP TABLE IF EXISTS `suggestions`;
1568 CREATE TABLE `suggestions` (
1569 `suggestionid` int(8) NOT NULL auto_increment,
1570 `suggestedby` int(11) NOT NULL default 0,
1571 `managedby` int(11) default NULL,
1572 `STATUS` varchar(10) NOT NULL default '',
1574 `author` varchar(80) default NULL,
1575 `title` varchar(80) default NULL,
1576 `copyrightdate` smallint(6) default NULL,
1577 `publishercode` varchar(255) default NULL,
1578 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1579 `volumedesc` varchar(255) default NULL,
1580 `publicationyear` smallint(6) default 0,
1581 `place` varchar(255) default NULL,
1582 `isbn` varchar(10) default NULL,
1583 `mailoverseeing` smallint(1) default 0,
1584 `biblionumber` int(11) default NULL,
1586 PRIMARY KEY (`suggestionid`),
1587 KEY `suggestedby` (`suggestedby`),
1588 KEY `managedby` (`managedby`)
1589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1592 -- Table structure for table `systempreferences`
1595 DROP TABLE IF EXISTS `systempreferences`;
1596 CREATE TABLE `systempreferences` (
1597 `variable` varchar(50) NOT NULL default '',
1599 `options` mediumtext,
1601 `type` varchar(20) default NULL,
1602 PRIMARY KEY (`variable`)
1603 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1606 -- Table structure for table `tags`
1609 DROP TABLE IF EXISTS `tags`;
1610 CREATE TABLE `tags` (
1611 `entry` varchar(255) NOT NULL default '',
1612 `weight` bigint(20) NOT NULL default 0,
1613 PRIMARY KEY (`entry`)
1614 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1617 -- Table structure for table `userflags`
1620 DROP TABLE IF EXISTS `userflags`;
1621 CREATE TABLE `userflags` (
1622 `bit` int(11) NOT NULL default 0,
1623 `flag` varchar(30) default NULL,
1624 `flagdesc` varchar(255) default NULL,
1625 `defaulton` int(11) default NULL,
1627 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1630 -- Table structure for table `virtualshelves`
1633 DROP TABLE IF EXISTS `virtualshelves`;
1634 CREATE TABLE `virtualshelves` (
1635 `shelfnumber` int(11) NOT NULL auto_increment,
1636 `shelfname` varchar(255) default NULL,
1637 `owner` varchar(80) default NULL,
1638 `category` varchar(1) default NULL,
1639 PRIMARY KEY (`shelfnumber`)
1640 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1643 -- Table structure for table `virtualshelfcontents`
1646 DROP TABLE IF EXISTS `virtualshelfcontents`;
1647 CREATE TABLE `virtualshelfcontents` (
1648 `shelfnumber` int(11) NOT NULL default 0,
1649 `biblionumber` int(11) NOT NULL default 0,
1650 `flags` int(11) default NULL,
1651 `dateadded` timestamp NULL default NULL,
1652 KEY `shelfnumber` (`shelfnumber`),
1653 KEY `biblionumber` (`biblionumber`),
1654 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1655 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1656 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1659 -- Table structure for table `z3950servers`
1662 DROP TABLE IF EXISTS `z3950servers`;
1663 CREATE TABLE `z3950servers` (
1664 `host` varchar(255) default NULL,
1665 `port` int(11) default NULL,
1666 `db` varchar(255) default NULL,
1667 `userid` varchar(255) default NULL,
1668 `password` varchar(255) default NULL,
1670 `id` int(11) NOT NULL auto_increment,
1671 `checked` smallint(6) default NULL,
1672 `rank` int(11) default NULL,
1673 `syntax` varchar(80) default NULL,
1675 `position` enum('primary','secondary','') NOT NULL default 'primary',
1676 `type` enum('zed','opensearch') NOT NULL default 'zed',
1677 `description` text NOT NULL,
1679 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1682 -- Table structure for table `zebraqueue`
1685 DROP TABLE IF EXISTS `zebraqueue`;
1686 CREATE TABLE `zebraqueue` (
1687 `id` int(11) NOT NULL auto_increment,
1688 `biblio_auth_number` int(11) NOT NULL default 0,
1689 `operation` varchar(20) NOT NULL default '',
1690 `server` varchar(20) NOT NULL default '',
1692 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1694 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1695 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1696 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1697 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1698 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1699 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1700 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1701 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;