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=MyISAM AUTO_INCREMENT=12143 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` varchar(100) default '',
1082 `title` int(1) default 0,
1083 `itemtype` int(1) default 0,
1084 `barcode` int(1) default 0,
1085 `dewey` int(1) default 0,
1086 `class` int(1) default 0,
1087 `subclass` int(1) default 0,
1088 `itemcallnumber` int(1) default 0,
1089 `author` int(1) default 0,
1090 `issn` int(1) default 0,
1091 `isbn` int(1) default 0,
1092 `startlabel` int(2) NOT NULL default 1,
1093 `printingtype` varchar(32) default 'BAR',
1094 `layoutname` varchar(20) NOT NULL default 'TEST',
1095 `guidebox` int(1) default 0,
1096 `active` tinyint(1) default 1,
1097 `fonttype` varchar(10) default NULL,
1098 `subtitle` int(1) default NULL,
1100 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1103 -- Table structure for table `labels_templates`
1106 DROP TABLE IF EXISTS `labels_templates`;
1107 CREATE TABLE `labels_templates` (
1108 `tmpl_id` int(4) NOT NULL auto_increment,
1109 `tmpl_code` varchar(100) character set utf8 collate utf8_unicode_ci default '',
1110 `tmpl_desc` varchar(100) character set utf8 collate utf8_unicode_ci default '',
1111 `page_width` float default 0,
1112 `page_height` float default 0,
1113 `label_width` float default 0,
1114 `label_height` float default 0,
1115 `topmargin` float default 0,
1116 `leftmargin` float default 0,
1117 `cols` int(2) default 0,
1118 `rows` int(2) default 0,
1119 `colgap` float default 0,
1120 `rowgap` float default 0,
1121 `active` int(1) default NULL,
1122 `units` varchar(20) character set utf8 collate utf8_unicode_ci default 'PX',
1123 `fontsize` int(4) NOT NULL default 3,
1124 PRIMARY KEY (`tmpl_id`)
1125 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1128 -- Table structure for table `letter`
1131 DROP TABLE IF EXISTS `letter`;
1132 CREATE TABLE `letter` (
1133 `module` varchar(20) NOT NULL default '',
1134 `code` varchar(20) NOT NULL default '',
1135 `name` varchar(100) NOT NULL default '',
1136 `title` varchar(200) NOT NULL default '',
1138 PRIMARY KEY (`module`,`code`)
1139 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1142 -- Table structure for table `marc_subfield_structure`
1145 DROP TABLE IF EXISTS `marc_subfield_structure`;
1146 CREATE TABLE `marc_subfield_structure` (
1147 `tagfield` varchar(3) NOT NULL default '',
1148 `tagsubfield` varchar(1) NOT NULL default '',
1149 `liblibrarian` varchar(255) NOT NULL default '',
1150 `libopac` varchar(255) NOT NULL default '',
1151 `repeatable` tinyint(4) NOT NULL default 0,
1152 `mandatory` tinyint(4) NOT NULL default 0,
1153 `kohafield` varchar(40) default NULL,
1154 `tab` tinyint(1) default NULL,
1155 `authorised_value` varchar(10) default NULL,
1156 `authtypecode` varchar(10) default NULL,
1157 `value_builder` varchar(80) default NULL,
1158 `isurl` tinyint(1) default NULL,
1159 `hidden` tinyint(1) default NULL,
1160 `frameworkcode` varchar(4) NOT NULL default '',
1161 `seealso` varchar(255) default NULL,
1162 `link` varchar(80) default NULL,
1163 `defaultvalue` text default NULL,
1164 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1165 KEY `kohafield_2` (`kohafield`),
1166 KEY `tab` (`frameworkcode`,`tab`),
1167 KEY `kohafield` (`frameworkcode`,`kohafield`)
1168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1171 -- Table structure for table `marc_tag_structure`
1174 DROP TABLE IF EXISTS `marc_tag_structure`;
1175 CREATE TABLE `marc_tag_structure` (
1176 `tagfield` varchar(3) NOT NULL default '',
1177 `liblibrarian` varchar(255) NOT NULL default '',
1178 `libopac` varchar(255) NOT NULL default '',
1179 `repeatable` tinyint(4) NOT NULL default 0,
1180 `mandatory` tinyint(4) NOT NULL default 0,
1181 `authorised_value` varchar(10) default NULL,
1182 `frameworkcode` varchar(4) NOT NULL default '',
1183 PRIMARY KEY (`frameworkcode`,`tagfield`)
1184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1187 -- Table structure for table `mediatypetable`
1190 DROP TABLE IF EXISTS `mediatypetable`;
1191 CREATE TABLE `mediatypetable` (
1192 `mediatypecode` varchar(5) NOT NULL default '',
1194 `itemtypecodes` text,
1195 PRIMARY KEY (`mediatypecode`)
1196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1199 -- Table structure for table `notifys`
1202 DROP TABLE IF EXISTS `notifys`;
1203 CREATE TABLE `notifys` (
1204 `notify_id` int(11) NOT NULL default 0,
1205 `borrowernumber` int(11) NOT NULL default 0,
1206 `itemnumber` int(11) NOT NULL default 0,
1207 `notify_date` date default NULL,
1208 `notify_send_date` date default NULL,
1209 `notify_level` int(1) NOT NULL default 0,
1210 `method` varchar(20) NOT NULL default ''
1211 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1214 -- Table structure for table `nozebra`
1216 CREATE TABLE `nozebra` (
1217 `server` varchar(20) NOT NULL,
1218 `indexname` varchar(40) NOT NULL,
1219 `value` varchar(250) NOT NULL,
1220 `biblionumbers` longtext NOT NULL,
1221 KEY `indexname` (`server`,`indexname`),
1222 KEY `value` (`server`,`value`))
1223 ENGINE=InnoDB DEFAULT CHARSET=utf8;
1226 -- Table structure for table `opac_news`
1229 DROP TABLE IF EXISTS `opac_news`;
1230 CREATE TABLE `opac_news` (
1231 `idnew` int(10) unsigned NOT NULL auto_increment,
1232 `title` varchar(250) NOT NULL default '',
1233 `new` text NOT NULL,
1234 `lang` varchar(4) NOT NULL default '',
1235 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1236 `expirationdate` date default NULL,
1237 `number` int(11) default NULL,
1238 PRIMARY KEY (`idnew`)
1239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1242 -- Table structure for table `overduerules`
1245 DROP TABLE IF EXISTS `overduerules`;
1246 CREATE TABLE `overduerules` (
1247 `branchcode` varchar(10) NOT NULL default '',
1248 `categorycode` varchar(2) NOT NULL default '',
1249 `delay1` int(4) default 0,
1250 `letter1` varchar(20) default NULL,
1251 `debarred1` varchar(1) default 0,
1252 `delay2` int(4) default 0,
1253 `debarred2` varchar(1) default 0,
1254 `letter2` varchar(20) default NULL,
1255 `delay3` int(4) default 0,
1256 `letter3` varchar(20) default NULL,
1257 `debarred3` int(1) default 0,
1258 PRIMARY KEY (`branchcode`,`categorycode`)
1259 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1262 -- Table structure for table `printers`
1265 DROP TABLE IF EXISTS `printers`;
1266 CREATE TABLE `printers` (
1267 `printername` varchar(40) NOT NULL default '',
1268 `printqueue` varchar(20) default NULL,
1269 `printtype` varchar(20) default NULL,
1270 PRIMARY KEY (`printername`)
1271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1274 -- Table structure for table `repeatable_holidays`
1277 DROP TABLE IF EXISTS `repeatable_holidays`;
1278 CREATE TABLE `repeatable_holidays` (
1279 `id` int(11) NOT NULL auto_increment,
1280 `branchcode` varchar(10) NOT NULL default '',
1281 `weekday` smallint(6) default NULL,
1282 `day` smallint(6) default NULL,
1283 `month` smallint(6) default NULL,
1284 `title` varchar(50) NOT NULL default '',
1285 `description` text NOT NULL,
1287 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1290 -- Table structure for table `reports_dictionary`
1293 DROP TABLE IF EXISTS `reports_dictionary`;
1294 CREATE TABLE reports_dictionary (
1295 `id` int(11) NOT NULL auto_increment,
1296 `name` varchar(255) default NULL,
1298 `date_created` datetime default NULL,
1299 `date_modified` datetime default NULL,
1301 `area` int(11) default NULL,
1303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1306 -- Table structure for table `reserveconstraints`
1309 DROP TABLE IF EXISTS `reserveconstraints`;
1310 CREATE TABLE `reserveconstraints` (
1311 `borrowernumber` int(11) NOT NULL default 0,
1312 `reservedate` date default NULL,
1313 `biblionumber` int(11) NOT NULL default 0,
1314 `biblioitemnumber` int(11) default NULL,
1315 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1319 -- Table structure for table `reserves`
1322 DROP TABLE IF EXISTS `reserves`;
1323 CREATE TABLE `reserves` (
1324 `borrowernumber` int(11) NOT NULL default 0,
1325 `reservedate` date default NULL,
1326 `biblionumber` int(11) NOT NULL default 0,
1327 `constrainttype` varchar(1) default NULL,
1328 `branchcode` varchar(10) default NULL,
1329 `notificationdate` date default NULL,
1330 `reminderdate` date default NULL,
1331 `cancellationdate` date default NULL,
1332 `reservenotes` mediumtext,
1333 `priority` smallint(6) default NULL,
1334 `found` varchar(1) default NULL,
1335 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1336 `itemnumber` int(11) default NULL,
1337 `waitingdate` date default NULL,
1338 KEY `borrowernumber` (`borrowernumber`),
1339 KEY `biblionumber` (`biblionumber`),
1340 KEY `itemnumber` (`itemnumber`),
1341 KEY `branchcode` (`branchcode`),
1342 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1343 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1344 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1345 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
1346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1349 -- Table structure for table `reviews`
1352 DROP TABLE IF EXISTS `reviews`;
1353 CREATE TABLE `reviews` (
1354 `reviewid` int(11) NOT NULL auto_increment,
1355 `borrowernumber` int(11) default NULL,
1356 `biblionumber` int(11) default NULL,
1358 `approved` tinyint(4) default NULL,
1359 `datereviewed` datetime default NULL,
1360 PRIMARY KEY (`reviewid`)
1361 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1364 -- Table structure for table `roadtype`
1367 DROP TABLE IF EXISTS `roadtype`;
1368 CREATE TABLE `roadtype` (
1369 `roadtypeid` int(11) NOT NULL auto_increment,
1370 `road_type` varchar(100) NOT NULL default '',
1371 PRIMARY KEY (`roadtypeid`)
1372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1375 -- Table structure for table `saved_sql`
1378 DROP TABLE IF EXISTS `saved_sql`;
1379 CREATE TABLE saved_sql (
1380 `id` int(11) NOT NULL auto_increment,
1381 `borrowernumber` int(11) default NULL,
1382 `date_created` datetime default NULL,
1383 `last_modified` datetime default NULL,
1385 `last_run` datetime default NULL,
1386 `report_name` varchar(255) default NULL,
1387 `type` varchar(255) default NULL,
1390 KEY boridx (`borrowernumber`)
1391 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1395 -- Table structure for `saved_reports`
1398 DROP TABLE IF EXISTS `saved_reports`;
1399 CREATE TABLE saved_reports (
1400 `id` int(11) NOT NULL auto_increment,
1401 `report_id` int(11) default NULL,
1403 `date_run` datetime default NULL,
1405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1409 -- Table structure for table `serial`
1412 DROP TABLE IF EXISTS `serial`;
1413 CREATE TABLE `serial` (
1414 `serialid` int(11) NOT NULL auto_increment,
1415 `biblionumber` varchar(100) NOT NULL default '',
1416 `subscriptionid` varchar(100) NOT NULL default '',
1417 `serialseq` varchar(100) NOT NULL default '',
1418 `status` tinyint(4) NOT NULL default 0,
1419 `planneddate` date default NULL,
1421 `publisheddate` date default NULL,
1423 `claimdate` date default NULL,
1424 `routingnotes` text,
1425 PRIMARY KEY (`serialid`)
1426 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1429 -- Table structure for table `sessions`
1432 DROP TABLE IF EXISTS sessions;
1433 CREATE TABLE sessions (
1434 `id` varchar(32) NOT NULL,
1435 `a_session` text NOT NULL,
1437 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1440 -- Table structure for table `special_holidays`
1443 DROP TABLE IF EXISTS `special_holidays`;
1444 CREATE TABLE `special_holidays` (
1445 `id` int(11) NOT NULL auto_increment,
1446 `branchcode` varchar(10) NOT NULL default '',
1447 `day` smallint(6) NOT NULL default 0,
1448 `month` smallint(6) NOT NULL default 0,
1449 `year` smallint(6) NOT NULL default 0,
1450 `isexception` smallint(1) NOT NULL default 1,
1451 `title` varchar(50) NOT NULL default '',
1452 `description` text NOT NULL,
1454 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1457 -- Table structure for table `statistics`
1460 DROP TABLE IF EXISTS `statistics`;
1461 CREATE TABLE `statistics` (
1462 `datetime` datetime default NULL,
1463 `branch` varchar(10) default NULL,
1464 `proccode` varchar(4) default NULL,
1465 `value` double(16,4) default NULL,
1466 `type` varchar(16) default NULL,
1468 `usercode` varchar(10) default NULL,
1469 `itemnumber` int(11) default NULL,
1470 `itemtype` varchar(10) default NULL,
1471 `borrowernumber` int(11) default NULL,
1472 `associatedborrower` int(11) default NULL,
1473 KEY `timeidx` (`datetime`)
1474 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1477 -- Table structure for table `stopwords`
1480 DROP TABLE IF EXISTS `stopwords`;
1481 CREATE TABLE `stopwords` (
1482 `word` varchar(255) default NULL
1483 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1486 -- Table structure for table `subcategorytable`
1489 DROP TABLE IF EXISTS `subcategorytable`;
1490 CREATE TABLE `subcategorytable` (
1491 `subcategorycode` varchar(5) NOT NULL default '',
1493 `itemtypecodes` text,
1494 PRIMARY KEY (`subcategorycode`)
1495 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1498 -- Table structure for table `subscription`
1501 DROP TABLE IF EXISTS `subscription`;
1502 CREATE TABLE `subscription` (
1503 `biblionumber` int(11) NOT NULL default 0,
1504 `subscriptionid` int(11) NOT NULL auto_increment,
1505 `librarian` varchar(100) default '',
1506 `startdate` date default NULL,
1507 `aqbooksellerid` int(11) default 0,
1508 `cost` int(11) default 0,
1509 `aqbudgetid` int(11) default 0,
1510 `weeklength` tinyint(4) default 0,
1511 `monthlength` tinyint(4) default 0,
1512 `numberlength` tinyint(4) default 0,
1513 `periodicity` tinyint(4) default 0,
1514 `dow` varchar(100) default '',
1515 `numberingmethod` varchar(100) default '',
1517 `status` varchar(100) NOT NULL default '',
1518 `add1` int(11) default 0,
1519 `every1` int(11) default 0,
1520 `whenmorethan1` int(11) default 0,
1521 `setto1` int(11) default NULL,
1522 `lastvalue1` int(11) default NULL,
1523 `add2` int(11) default 0,
1524 `every2` int(11) default 0,
1525 `whenmorethan2` int(11) default 0,
1526 `setto2` int(11) default NULL,
1527 `lastvalue2` int(11) default NULL,
1528 `add3` int(11) default 0,
1529 `every3` int(11) default 0,
1530 `innerloop1` int(11) default 0,
1531 `innerloop2` int(11) default 0,
1532 `innerloop3` int(11) default 0,
1533 `whenmorethan3` int(11) default 0,
1534 `setto3` int(11) default NULL,
1535 `lastvalue3` int(11) default NULL,
1536 `issuesatonce` tinyint(3) NOT NULL default 1,
1537 `firstacquidate` date default NULL,
1538 `manualhistory` tinyint(1) NOT NULL default 0,
1539 `irregularity` text,
1540 `letter` varchar(20) default NULL,
1541 `numberpattern` tinyint(3) default 0,
1542 `distributedto` text,
1543 `internalnotes` longtext,
1545 `branchcode` varchar(10) NOT NULL default '',
1546 `hemisphere` tinyint(3) default 0,
1547 `lastbranch` varchar(10),
1548 PRIMARY KEY (`subscriptionid`)
1549 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1552 -- Table structure for table `subscriptionhistory`
1555 DROP TABLE IF EXISTS `subscriptionhistory`;
1556 CREATE TABLE `subscriptionhistory` (
1557 `biblionumber` int(11) NOT NULL default 0,
1558 `subscriptionid` int(11) NOT NULL default 0,
1559 `histstartdate` date default NULL,
1560 `enddate` date default NULL,
1561 `missinglist` longtext NOT NULL,
1562 `recievedlist` longtext NOT NULL,
1563 `opacnote` varchar(150) NOT NULL default '',
1564 `librariannote` varchar(150) NOT NULL default '',
1565 PRIMARY KEY (`subscriptionid`),
1566 KEY `biblionumber` (`biblionumber`)
1567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1570 -- Table structure for table `subscriptionroutinglist`
1573 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1574 CREATE TABLE `subscriptionroutinglist` (
1575 `routingid` int(11) NOT NULL auto_increment,
1576 `borrowernumber` int(11) default NULL,
1577 `ranking` int(11) default NULL,
1578 `subscriptionid` int(11) default NULL,
1579 PRIMARY KEY (`routingid`)
1580 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1583 -- Table structure for table `suggestions`
1586 DROP TABLE IF EXISTS `suggestions`;
1587 CREATE TABLE `suggestions` (
1588 `suggestionid` int(8) NOT NULL auto_increment,
1589 `suggestedby` int(11) NOT NULL default 0,
1590 `managedby` int(11) default NULL,
1591 `STATUS` varchar(10) NOT NULL default '',
1593 `author` varchar(80) default NULL,
1594 `title` varchar(80) default NULL,
1595 `copyrightdate` smallint(6) default NULL,
1596 `publishercode` varchar(255) default NULL,
1597 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1598 `volumedesc` varchar(255) default NULL,
1599 `publicationyear` smallint(6) default 0,
1600 `place` varchar(255) default NULL,
1601 `isbn` varchar(10) default NULL,
1602 `mailoverseeing` smallint(1) default 0,
1603 `biblionumber` int(11) default NULL,
1605 PRIMARY KEY (`suggestionid`),
1606 KEY `suggestedby` (`suggestedby`),
1607 KEY `managedby` (`managedby`)
1608 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1611 -- Table structure for table `systempreferences`
1614 DROP TABLE IF EXISTS `systempreferences`;
1615 CREATE TABLE `systempreferences` (
1616 `variable` varchar(50) NOT NULL default '',
1618 `options` mediumtext,
1620 `type` varchar(20) default NULL,
1621 PRIMARY KEY (`variable`)
1622 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1625 -- Table structure for table `tags`
1628 DROP TABLE IF EXISTS `tags`;
1629 CREATE TABLE `tags` (
1630 `entry` varchar(255) NOT NULL default '',
1631 `weight` bigint(20) NOT NULL default 0,
1632 PRIMARY KEY (`entry`)
1633 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1636 -- Table structure for table `userflags`
1639 DROP TABLE IF EXISTS `userflags`;
1640 CREATE TABLE `userflags` (
1641 `bit` int(11) NOT NULL default 0,
1642 `flag` varchar(30) default NULL,
1643 `flagdesc` varchar(255) default NULL,
1644 `defaulton` int(11) default NULL,
1646 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1649 -- Table structure for table `virtualshelves`
1652 DROP TABLE IF EXISTS `virtualshelves`;
1653 CREATE TABLE `virtualshelves` (
1654 `shelfnumber` int(11) NOT NULL auto_increment,
1655 `shelfname` varchar(255) default NULL,
1656 `owner` varchar(80) default NULL,
1657 `category` varchar(1) default NULL,
1658 PRIMARY KEY (`shelfnumber`)
1659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1662 -- Table structure for table `virtualshelfcontents`
1665 DROP TABLE IF EXISTS `virtualshelfcontents`;
1666 CREATE TABLE `virtualshelfcontents` (
1667 `shelfnumber` int(11) NOT NULL default 0,
1668 `biblionumber` int(11) NOT NULL default 0,
1669 `flags` int(11) default NULL,
1670 `dateadded` timestamp NULL default NULL,
1671 KEY `shelfnumber` (`shelfnumber`),
1672 KEY `biblionumber` (`biblionumber`),
1673 CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1674 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
1675 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1678 -- Table structure for table `z3950servers`
1681 DROP TABLE IF EXISTS `z3950servers`;
1682 CREATE TABLE `z3950servers` (
1683 `host` varchar(255) default NULL,
1684 `port` int(11) default NULL,
1685 `db` varchar(255) default NULL,
1686 `userid` varchar(255) default NULL,
1687 `password` varchar(255) default NULL,
1689 `id` int(11) NOT NULL auto_increment,
1690 `checked` smallint(6) default NULL,
1691 `rank` int(11) default NULL,
1692 `syntax` varchar(80) default NULL,
1694 `position` enum('primary','secondary','') NOT NULL default 'primary',
1695 `type` enum('zed','opensearch') NOT NULL default 'zed',
1696 `description` text NOT NULL,
1698 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1701 -- Table structure for table `zebraqueue`
1704 CREATE TABLE `zebraqueue` (
1705 `id` int(11) NOT NULL auto_increment,
1706 `biblio_auth_number` int(11) NOT NULL default '0',
1707 `operation` char(20) NOT NULL default '',
1708 `server` char(20) NOT NULL default '',
1709 `done` int(11) NOT NULL default '0',
1710 `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1712 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1714 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1715 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1716 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1717 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1718 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1719 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1720 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1721 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;