3 -- Host: localhost Database: rel3_edit
4 -- ------------------------------------------------------
5 -- Server version 5.0.32-Debian_3-log
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 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
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 */;
18 -- Koha Database Structure
23 -- Turning off foreign key checks for import speed.
24 -- If you edit this file, run it with foreign key checks ON before committing!
27 -- SET AUTOCOMMIT = 0;
28 -- SET FOREIGN_KEY_CHECKS=0;
31 -- Table structure for table `accountlines`
34 DROP TABLE IF EXISTS `accountlines`;
35 CREATE TABLE `accountlines` (
36 `borrowernumber` int(11) NOT NULL default '0',
37 `accountno` smallint(6) NOT NULL default '0',
38 `itemnumber` int(11) default NULL,
39 `date` date default NULL,
40 `amount` decimal(28,6) default NULL,
43 `accounttype` varchar(5) default NULL,
44 `amountoutstanding` decimal(28,6) default NULL,
45 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
46 `notify_id` int(11) NOT NULL default '0',
47 `notify_level` int(2) NOT NULL default '0',
48 KEY `acctsborridx` (`borrowernumber`),
49 KEY `timeidx` (`timestamp`),
50 KEY `itemnumber` (`itemnumber`),
51 CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
52 CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56 -- Table structure for table `accountoffsets`
59 DROP TABLE IF EXISTS `accountoffsets`;
60 CREATE TABLE `accountoffsets` (
61 `borrowernumber` int(11) NOT NULL default '0',
62 `accountno` smallint(6) NOT NULL default '0',
63 `offsetaccount` smallint(6) NOT NULL default '0',
64 `offsetamount` decimal(28,6) default NULL,
65 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
66 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69 -- Table structure for table `action_logs`
72 DROP TABLE IF EXISTS `action_logs`;
73 CREATE TABLE `action_logs` (
74 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
75 `user` int(11) NOT NULL default '0',
78 `object` int(11) default '0',
80 PRIMARY KEY (`timestamp`,`user`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84 -- Table structure for table `alert`
87 DROP TABLE IF EXISTS `alert`;
88 CREATE TABLE `alert` (
89 `alertid` int(11) NOT NULL auto_increment,
90 `borrowernumber` int(11) NOT NULL default '0',
91 `type` varchar(10) NOT NULL default '',
92 `externalid` varchar(20) NOT NULL default '',
93 PRIMARY KEY (`alertid`),
94 KEY `borrowernumber` (`borrowernumber`),
95 KEY `type` (`type`,`externalid`)
96 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99 -- Table structure for table `aqbasket`
102 DROP TABLE IF EXISTS `aqbasket`;
103 CREATE TABLE `aqbasket` (
104 `basketno` int(11) NOT NULL auto_increment,
105 `creationdate` date default NULL,
106 `closedate` date default NULL,
107 `booksellerid` int(11) NOT NULL default '1',
108 `authorisedby` varchar(10) default NULL,
109 `booksellerinvoicenumber` text,
110 PRIMARY KEY (`basketno`),
111 KEY `booksellerid` (`booksellerid`),
112 CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE
113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
116 -- Table structure for table `aqbookfund`
119 DROP TABLE IF EXISTS `aqbookfund`;
120 CREATE TABLE `aqbookfund` (
121 `bookfundid` varchar(5) NOT NULL default '''''',
123 `bookfundgroup` varchar(5) default NULL,
124 `branchcode` varchar(4) NOT NULL default '',
125 PRIMARY KEY (`bookfundid`,`branchcode`)
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129 -- Table structure for table `aqbooksellers`
132 DROP TABLE IF EXISTS `aqbooksellers`;
133 CREATE TABLE `aqbooksellers` (
134 `id` int(11) NOT NULL default '0',
140 `phone` varchar(30) default NULL,
141 `accountnumber` text,
142 `othersupplier` text,
143 `currency` varchar(3) NOT NULL default '',
144 `deliverydays` smallint(6) default NULL,
145 `followupdays` smallint(6) default NULL,
146 `followupscancel` smallint(6) default NULL,
148 `booksellerfax` text,
150 `bookselleremail` text,
151 `booksellerurl` text,
152 `contact` varchar(100) default NULL,
154 `url` varchar(255) default NULL,
155 `contpos` varchar(100) default NULL,
156 `contphone` varchar(100) default NULL,
157 `contfax` varchar(100) default NULL,
158 `contaltphone` varchar(100) default NULL,
159 `contemail` varchar(100) default NULL,
161 `active` tinyint(4) default NULL,
162 `listprice` varchar(10) default '',
163 `invoiceprice` varchar(10) default '',
164 `gstreg` tinyint(4) default NULL,
165 `listincgst` tinyint(4) default NULL,
166 `invoiceincgst` tinyint(4) default NULL,
167 `discount` float(6,4) default NULL,
168 `fax` varchar(50) default NULL,
169 `nocalc` int(11) default NULL,
170 `invoicedisc` float(6,4) default NULL,
172 KEY `listprice` (`listprice`),
173 KEY `invoiceprice` (`invoiceprice`),
174 CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
175 CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179 -- Table structure for table `aqbudget`
182 DROP TABLE IF EXISTS `aqbudget`;
183 CREATE TABLE `aqbudget` (
184 `bookfundid` varchar(5) NOT NULL default '',
185 `startdate` date NOT NULL default '0000-00-00',
186 `enddate` date default NULL,
187 `budgetamount` decimal(13,2) default NULL,
188 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
189 `branchcode` varchar(4) NOT NULL default '',
190 PRIMARY KEY (`aqbudgetid`,`branchcode`)
191 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
194 -- Table structure for table `aqorderbreakdown`
197 DROP TABLE IF EXISTS `aqorderbreakdown`;
198 CREATE TABLE `aqorderbreakdown` (
199 `ordernumber` int(11) default NULL,
200 `linenumber` int(11) default NULL,
201 `branchcode` char(4) default NULL,
202 `bookfundid` char(5) NOT NULL default '',
203 `allocation` smallint(6) default NULL,
204 KEY `ordernumber` (`ordernumber`),
205 KEY `bookfundid` (`bookfundid`),
206 CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE,
207 CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
211 -- Table structure for table `aqorderdelivery`
214 DROP TABLE IF EXISTS `aqorderdelivery`;
215 CREATE TABLE `aqorderdelivery` (
216 `ordernumber` date NOT NULL default '0000-00-00',
217 `deliverynumber` smallint(6) NOT NULL default '0',
218 `deliverydate` varchar(18) default NULL,
219 `qtydelivered` smallint(6) default NULL,
220 `deliverycomments` text
221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
224 -- Table structure for table `aqorders`
227 DROP TABLE IF EXISTS `aqorders`;
228 CREATE TABLE `aqorders` (
229 `ordernumber` int(11) NOT NULL auto_increment,
230 `biblionumber` int(11) default NULL,
232 `entrydate` date default NULL,
233 `quantity` smallint(6) default NULL,
234 `currency` varchar(3) default NULL,
235 `listprice` decimal(28,6) default NULL,
236 `totalamount` decimal(28,6) default NULL,
237 `datereceived` date default NULL,
238 `booksellerinvoicenumber` text,
239 `freight` decimal(28,6) default NULL,
240 `unitprice` decimal(28,6) default NULL,
241 `quantityreceived` smallint(6) default NULL,
242 `cancelledby` varchar(10) default NULL,
243 `datecancellationprinted` date default NULL,
245 `supplierreference` text,
246 `purchaseordernumber` text,
247 `subscription` tinyint(1) default NULL,
248 `serialid` varchar(30) default NULL,
249 `basketno` int(11) default NULL,
250 `biblioitemnumber` int(11) default NULL,
251 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
252 `rrp` decimal(13,2) default NULL,
253 `ecost` decimal(13,2) default NULL,
254 `gst` decimal(13,2) default NULL,
255 `budgetdate` date default NULL,
256 `sort1` varchar(80) default NULL,
257 `sort2` varchar(80) default NULL,
258 PRIMARY KEY (`ordernumber`),
259 KEY `basketno` (`basketno`),
260 KEY `biblionumber` (`biblionumber`),
261 CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL,
262 CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE
263 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
266 -- Table structure for table `auth_header`
269 DROP TABLE IF EXISTS `auth_header`;
270 CREATE TABLE `auth_header` (
271 `authid` bigint(20) unsigned NOT NULL auto_increment,
272 `authtypecode` varchar(10) NOT NULL default '',
273 `datecreated` date NOT NULL default '0000-00-00',
274 `datemodified` date default NULL,
275 `origincode` varchar(20) default NULL,
277 `linkid` bigint(20) default NULL,
279 `marcxml` text NOT NULL,
280 PRIMARY KEY (`authid`),
281 KEY `origincode` (`origincode`)
282 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
285 -- Table structure for table `auth_subfield_structure`
288 DROP TABLE IF EXISTS `auth_subfield_structure`;
289 CREATE TABLE `auth_subfield_structure` (
290 `authtypecode` varchar(10) NOT NULL default '',
291 `tagfield` varchar(3) NOT NULL default '',
292 `tagsubfield` char(1) NOT NULL default '',
293 `liblibrarian` varchar(255) NOT NULL default '',
294 `libopac` varchar(255) NOT NULL default '',
295 `repeatable` tinyint(4) NOT NULL default '0',
296 `mandatory` tinyint(4) NOT NULL default '0',
297 `tab` tinyint(1) default NULL,
298 `authorised_value` varchar(10) default NULL,
299 `value_builder` varchar(80) default NULL,
300 `seealso` varchar(255) default NULL,
301 `hidden` tinyint(1) unsigned NOT NULL default '0',
302 `isurl` tinyint(1) unsigned NOT NULL default '0',
303 `link` varchar(80) default NULL,
304 `frameworkcode` varchar(8) NOT NULL default '',
305 `kohafield` varchar(40) default NULL,
306 `linkid` tinyint(1) NOT NULL default '0',
307 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
308 KEY `tab` (`authtypecode`,`tab`)
309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
312 -- Table structure for table `auth_subfield_table`
315 DROP TABLE IF EXISTS `auth_subfield_table`;
316 CREATE TABLE `auth_subfield_table` (
317 `subfieldid` bigint(20) unsigned NOT NULL auto_increment,
318 `authid` bigint(20) unsigned NOT NULL default '0',
319 `tag` varchar(3) NOT NULL default '',
320 `tagorder` tinyint(4) NOT NULL default '1',
321 `tag_indicator` varchar(2) NOT NULL default '',
322 `subfieldcode` char(1) NOT NULL default '',
323 `subfieldorder` tinyint(4) NOT NULL default '1',
324 `subfieldvalue` varchar(255) default NULL,
325 PRIMARY KEY (`subfieldid`),
326 KEY `authid` (`authid`),
328 KEY `subfieldcode` (`subfieldcode`),
329 KEY `subfieldvalue` (`subfieldvalue`)
330 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
333 -- Table structure for table `auth_tag_structure`
336 DROP TABLE IF EXISTS `auth_tag_structure`;
337 CREATE TABLE `auth_tag_structure` (
338 `authtypecode` char(10) NOT NULL default '',
339 `tagfield` char(3) NOT NULL default '',
340 `liblibrarian` char(255) NOT NULL default '',
341 `libopac` char(255) NOT NULL default '',
342 `repeatable` tinyint(4) NOT NULL default '0',
343 `mandatory` tinyint(4) NOT NULL default '0',
344 `authorised_value` char(10) default NULL,
345 PRIMARY KEY (`authtypecode`,`tagfield`),
346 CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
347 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
350 -- Table structure for table `auth_types`
353 DROP TABLE IF EXISTS `auth_types`;
354 CREATE TABLE `auth_types` (
355 `authtypecode` varchar(10) NOT NULL default '',
356 `authtypetext` varchar(255) NOT NULL default '',
357 `auth_tag_to_report` varchar(3) NOT NULL default '',
358 `summary` text NOT NULL,
359 PRIMARY KEY (`authtypecode`)
360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
363 -- Table structure for table `auth_word`
366 DROP TABLE IF EXISTS `auth_word`;
367 CREATE TABLE `auth_word` (
368 `authid` bigint(20) NOT NULL default '0',
369 `tagsubfield` varchar(4) NOT NULL default '',
370 `tagorder` tinyint(4) NOT NULL default '1',
371 `subfieldorder` tinyint(4) NOT NULL default '1',
372 `word` varchar(255) NOT NULL default '',
373 `sndx_word` varchar(255) NOT NULL default '',
374 KEY `authid` (`authid`),
375 KEY `marc_search` (`tagsubfield`,`word`),
377 KEY `sndx_word` (`sndx_word`)
378 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
381 -- Table structure for table `authorised_values`
384 DROP TABLE IF EXISTS `authorised_values`;
385 CREATE TABLE `authorised_values` (
386 `id` int(11) NOT NULL auto_increment,
387 `category` char(10) NOT NULL default '',
388 `authorised_value` char(80) NOT NULL default '',
389 `lib` char(80) default NULL,
391 KEY `name` (`category`)
392 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
395 -- Table structure for table `biblio`
398 DROP TABLE IF EXISTS `biblio`;
399 CREATE TABLE `biblio` (
400 `biblionumber` int(11) NOT NULL default '0',
405 `serial` tinyint(1) default NULL,
407 `copyrightdate` smallint(6) default NULL,
408 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
410 `frameworkcode` varchar(4) default NULL,
411 PRIMARY KEY (`biblionumber`),
412 KEY `blbnoidx` (`biblionumber`)
413 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
416 -- Table structure for table `biblio_framework`
419 DROP TABLE IF EXISTS `biblio_framework`;
420 CREATE TABLE `biblio_framework` (
421 `frameworkcode` char(4) NOT NULL default '',
422 `frameworktext` char(255) NOT NULL default '',
423 PRIMARY KEY (`frameworkcode`)
424 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
427 -- Table structure for table `biblioanalysis`
430 DROP TABLE IF EXISTS `biblioanalysis`;
431 CREATE TABLE `biblioanalysis` (
432 `analyticaltitle` text,
433 `biblionumber` int(11) NOT NULL default '0',
434 `analyticalauthor` text
435 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
438 -- Table structure for table `biblioitems`
441 DROP TABLE IF EXISTS `biblioitems`;
442 CREATE TABLE `biblioitems` (
443 `biblioitemnumber` int(11) NOT NULL default '0',
444 `biblionumber` int(11) NOT NULL default '0',
447 `classification` varchar(25) default NULL,
448 `itemtype` varchar(10) default NULL,
449 `isbn` varchar(14) default NULL,
450 `issn` varchar(9) default NULL,
451 `dewey` varchar(30) default '',
452 `subclass` varchar(3) default NULL,
453 `publicationyear` smallint(6) default NULL,
454 `publishercode` varchar(255) default NULL,
455 `volumedate` date default NULL,
456 `volumeddesc` varchar(255) default NULL,
457 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
458 `illus` varchar(255) default NULL,
459 `pages` varchar(255) default NULL,
461 `size` varchar(255) default NULL,
462 `place` varchar(255) default NULL,
463 `lccn` varchar(25) default NULL,
465 `url` varchar(255) default NULL,
467 `lcsort` varchar(25) default NULL,
468 `ccode` varchar(4) default '',
469 PRIMARY KEY (`biblioitemnumber`),
470 KEY `bibinoidx` (`biblioitemnumber`),
471 KEY `bibnoidx` (`biblionumber`),
472 KEY `itemtype` (`itemtype`),
474 KEY `publishercode` (`publishercode`),
475 CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
476 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
480 -- Table structure for table `bookshelf`
483 DROP TABLE IF EXISTS `bookshelf`;
484 CREATE TABLE `bookshelf` (
485 `shelfnumber` int(11) NOT NULL auto_increment,
486 `shelfname` char(255) default NULL,
487 `owner` char(80) default NULL,
488 `category` char(1) default NULL,
489 PRIMARY KEY (`shelfnumber`)
490 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
493 -- Table structure for table `borexp`
496 DROP TABLE IF EXISTS `borexp`;
497 CREATE TABLE `borexp` (
498 `borrowernumber` int(11) default NULL,
499 `newexp` date default NULL
500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
503 -- Table structure for table `borrowers`
506 DROP TABLE IF EXISTS `borrowers`;
507 CREATE TABLE `borrowers` (
508 `borrowernumber` int(11) NOT NULL auto_increment,
509 `cardnumber` varchar(16) NOT NULL default '',
510 `surname` text NOT NULL,
515 `streetnumber` varchar(10) default NULL,
516 `streettype` varchar(50) default NULL,
517 `address` text NOT NULL,
519 `city` text NOT NULL,
520 `zipcode` varchar(25) default NULL,
523 `mobile` varchar(50) default NULL,
525 `B_streetnumber` varchar(10) default NULL,
526 `B_streettype` varchar(50) default NULL,
529 `B_address` varchar(100) default NULL,
531 `B_zipcode` varchar(25) default NULL,
534 `dateofbirth` date default NULL,
535 `branchcode` varchar(10) NOT NULL default '',
536 `categorycode` varchar(10) NOT NULL default '',
537 `dateenrolled` date default NULL,
538 `dateexpiry` date default NULL,
539 `gonenoaddress` tinyint(1) default NULL,
540 `lost` tinyint(1) default NULL,
541 `debarred` tinyint(1) default NULL,
543 `contactfirstname` text,
545 `guarantorid` int(11) default NULL,
546 `borrowernotes` text,
547 `relationship` varchar(100) default NULL,
548 `ethnicity` varchar(50) default NULL,
549 `ethnotes` varchar(255) default NULL,
550 `sex` char(1) default NULL,
551 `password` varchar(30) default NULL,
552 `flags` int(11) default NULL,
553 `userid` varchar(30) default NULL,
555 `contactnote` varchar(255) default NULL,
556 `sort1` varchar(80) default NULL,
557 `sort2` varchar(80) default NULL,
558 `textmessaging` varchar(30) default NULL,
559 `homezipcode` varchar(25) default NULL,
560 UNIQUE KEY `cardnumber` (`cardnumber`),
561 KEY `borrowernumber` (`borrowernumber`),
562 KEY `categorycode` (`categorycode`),
563 KEY `branchcode` (`branchcode`),
564 CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
565 CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
566 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
569 -- Table structure for table `borrowers_to_borrowers`
572 DROP TABLE IF EXISTS `borrowers_to_borrowers`;
573 CREATE TABLE `borrowers_to_borrowers` (
574 `borrower1` int(11) default NULL,
575 `borrower2` int(11) default NULL
576 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
579 -- Table structure for table `branchcategories`
582 DROP TABLE IF EXISTS `branchcategories`;
583 CREATE TABLE `branchcategories` (
584 `categorycode` varchar(4) NOT NULL default '',
586 `codedescription` text,
587 PRIMARY KEY (`categorycode`)
588 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
591 -- Table structure for table `branches`
594 DROP TABLE IF EXISTS `branches`;
595 CREATE TABLE `branches` (
596 `branchcode` varchar(10) NOT NULL default '',
597 `branchname` text NOT NULL,
598 `branchaddress1` text,
599 `branchaddress2` text,
600 `branchaddress3` text,
604 `issuing` tinyint(4) default NULL,
605 `branchip` varchar(15) default '',
606 `branchprinter` varchar(100) default '',
607 UNIQUE KEY `branchcode` (`branchcode`)
608 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
611 -- Table structure for table `branchrelations`
614 DROP TABLE IF EXISTS `branchrelations`;
615 CREATE TABLE `branchrelations` (
616 `branchcode` varchar(4) default NULL,
617 `categorycode` varchar(4) default NULL
618 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
621 -- Table structure for table `branchtransfers`
624 DROP TABLE IF EXISTS `branchtransfers`;
625 CREATE TABLE `branchtransfers` (
626 `itemnumber` int(11) NOT NULL default '0',
627 `datesent` datetime default NULL,
628 `frombranch` varchar(10) NOT NULL default '',
629 `datearrived` datetime default NULL,
630 `tobranch` varchar(10) NOT NULL default '',
632 KEY `frombranch` (`frombranch`),
633 KEY `tobranch` (`tobranch`),
634 KEY `itemnumber` (`itemnumber`),
635 CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
636 CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
637 CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
641 -- Table structure for table `catalogueentry`
644 DROP TABLE IF EXISTS `catalogueentry`;
645 CREATE TABLE `catalogueentry` (
646 `catalogueentry` text NOT NULL,
647 `entrytype` varchar(2) default NULL,
651 `biblionumber` int(11) default NULL
652 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
655 -- Table structure for table `categories`
658 DROP TABLE IF EXISTS `categories`;
659 CREATE TABLE `categories` (
660 `categorycode` varchar(10) NOT NULL default '',
662 `enrolmentperiod` smallint(6) default NULL,
663 `upperagelimit` smallint(6) default NULL,
664 `dateofbirthrequired` tinyint(1) default NULL,
665 `finetype` varchar(30) default NULL,
666 `bulk` tinyint(1) default NULL,
667 `enrolmentfee` decimal(28,6) default NULL,
668 `overduenoticerequired` tinyint(1) default NULL,
669 `issuelimit` smallint(6) default NULL,
670 `reservefee` decimal(28,6) default NULL,
671 `category_type` char(1) NOT NULL default 'A',
672 PRIMARY KEY (`categorycode`),
673 UNIQUE KEY `categorycode` (`categorycode`)
674 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
677 -- Table structure for table `categorytable`
680 DROP TABLE IF EXISTS `categorytable`;
681 CREATE TABLE `categorytable` (
682 `categorycode` varchar(5) NOT NULL default '',
684 `itemtypecodes` text,
685 PRIMARY KEY (`categorycode`)
686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
689 -- Table structure for table `charges`
692 DROP TABLE IF EXISTS `charges`;
693 CREATE TABLE `charges` (
694 `charge_id` varchar(5) NOT NULL default '',
695 `description` text NOT NULL,
696 `amount` decimal(28,6) NOT NULL default '0.000000',
697 `min` int(4) NOT NULL default '0',
698 `max` int(4) NOT NULL default '0',
699 `level` int(1) NOT NULL default '0',
700 PRIMARY KEY (`charge_id`)
701 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
704 -- Table structure for table `cities`
707 DROP TABLE IF EXISTS `cities`;
708 CREATE TABLE `cities` (
709 `cityid` int(11) NOT NULL auto_increment,
710 `city_name` char(100) NOT NULL default '',
711 `city_zipcode` char(20) default NULL,
712 PRIMARY KEY (`cityid`)
713 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
716 -- Table structure for table `currency`
719 DROP TABLE IF EXISTS `currency`;
720 CREATE TABLE `currency` (
721 `currency` varchar(10) NOT NULL default '',
722 `rate` float(7,5) default NULL,
723 PRIMARY KEY (`currency`)
724 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
727 -- Table structure for table `deletedbiblio`
730 DROP TABLE IF EXISTS `deletedbiblio`;
731 CREATE TABLE `deletedbiblio` (
732 `biblionumber` int(11) NOT NULL default '0',
737 `serial` tinyint(1) default NULL,
739 `copyrightdate` smallint(6) default NULL,
740 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
743 `frameworkcode` varchar(4) default NULL,
744 PRIMARY KEY (`biblionumber`),
745 KEY `blbnoidx` (`biblionumber`)
746 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
749 -- Table structure for table `deletedbiblioitems`
752 DROP TABLE IF EXISTS `deletedbiblioitems`;
753 CREATE TABLE `deletedbiblioitems` (
754 `biblioitemnumber` int(11) NOT NULL default '0',
755 `biblionumber` int(11) NOT NULL default '0',
758 `classification` varchar(25) default NULL,
759 `itemtype` varchar(10) default NULL,
760 `isbn` varchar(14) default NULL,
761 `issn` varchar(9) default NULL,
762 `dewey` double(8,6) default NULL,
763 `subclass` varchar(3) default NULL,
764 `publicationyear` smallint(6) default NULL,
765 `publishercode` varchar(255) default NULL,
766 `volumedate` date default NULL,
767 `volumeddesc` varchar(255) default NULL,
768 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
769 `illus` varchar(255) default NULL,
770 `pages` varchar(255) default NULL,
772 `size` varchar(255) default NULL,
773 `lccn` varchar(25) default NULL,
775 `url` varchar(255) default NULL,
776 `place` varchar(255) default NULL,
778 `lcsort` varchar(25) default NULL,
779 `ccode` varchar(4) default NULL,
780 PRIMARY KEY (`biblioitemnumber`),
781 KEY `bibinoidx` (`biblioitemnumber`),
782 KEY `bibnoidx` (`biblionumber`)
783 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
786 -- Table structure for table `deletedborrowers`
789 DROP TABLE IF EXISTS `deletedborrowers`;
790 CREATE TABLE `deletedborrowers` (
791 `borrowernumber` int(11) NOT NULL default '0',
792 `cardnumber` varchar(9) NOT NULL default '',
793 `surname` text NOT NULL,
798 `streetnumber` varchar(10) default NULL,
799 `streettype` varchar(50) default NULL,
800 `address` text NOT NULL,
802 `city` text NOT NULL,
803 `zipcode` varchar(25) default NULL,
806 `mobile` varchar(50) default NULL,
808 `B_streetnumber` varchar(10) default NULL,
809 `B_streettype` varchar(50) default NULL,
812 `B_address` varchar(100) default NULL,
814 `B_zipcode` varchar(25) default NULL,
817 `dateofbirth` date default NULL,
818 `branchcode` varchar(4) NOT NULL default '',
819 `categorycode` varchar(10) default NULL,
820 `dateenrolled` date default NULL,
821 `dateexpiry` date default NULL,
822 `gonenoaddress` tinyint(1) default NULL,
823 `lost` tinyint(1) default NULL,
824 `debarred` tinyint(1) default NULL,
826 `contactfirstname` text,
828 `guarantorid` int(11) default NULL,
829 `borrowernotes` text,
830 `relationship` varchar(100) default NULL,
831 `ethnicity` varchar(50) default NULL,
832 `ethnotes` varchar(255) default NULL,
833 `sex` char(1) default NULL,
834 `password` varchar(30) default NULL,
835 `flags` int(11) default NULL,
836 `userid` varchar(30) default NULL,
838 `contactnote` varchar(255) default NULL,
839 `sort1` varchar(80) default NULL,
840 `sort2` varchar(80) default NULL,
841 `textmessaging` varchar(30) default NULL,
842 `homezipcode` varchar(25) default NULL,
843 KEY `borrowernumber` (`borrowernumber`),
844 KEY `cardnumber` (`cardnumber`),
845 KEY `categorycode` (`categorycode`),
846 KEY `branchcode` (`branchcode`)
847 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
850 -- Table structure for table `deleteditems`
853 DROP TABLE IF EXISTS `deleteditems`;
854 CREATE TABLE `deleteditems` (
855 `itemnumber` int(11) NOT NULL default '0',
856 `biblionumber` int(11) NOT NULL default '0',
857 `multivolumepart` varchar(30) default NULL,
858 `biblioitemnumber` int(11) NOT NULL default '0',
859 `barcode` varchar(9) NOT NULL default '',
860 `dateaccessioned` date default NULL,
861 `booksellerid` varchar(10) default NULL,
862 `homebranch` varchar(4) default NULL,
863 `price` decimal(28,6) default NULL,
864 `replacementprice` decimal(28,6) default NULL,
865 `replacementpricedate` date default NULL,
866 `datelastborrowed` date default NULL,
867 `datelastseen` date default NULL,
868 `multivolume` tinyint(1) default NULL,
869 `stack` tinyint(1) default NULL,
870 `notforloan` tinyint(1) default NULL,
871 `itemlost` tinyint(1) default NULL,
872 `wthdrawn` tinyint(1) default NULL,
873 `bulk` varchar(30) default NULL,
874 `issues` smallint(6) default NULL,
875 `renewals` smallint(6) default NULL,
876 `reserves` smallint(6) default NULL,
877 `restricted` tinyint(1) default NULL,
878 `binding` decimal(28,6) default NULL,
880 `holdingbranch` varchar(4) default NULL,
881 `interim` tinyint(1) default NULL,
882 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
885 `location` varchar(80) default NULL,
886 `itemcallnumber` varchar(30) default NULL,
887 `onloan` date default NULL,
888 `Cutterextra` varchar(45) default NULL,
889 `issue_date` date default '0000-00-00',
890 `itype` varchar(10) default NULL,
891 PRIMARY KEY (`itemnumber`),
892 UNIQUE KEY `barcode` (`barcode`),
893 KEY `itembarcodeidx` (`barcode`),
894 KEY `itembinoidx` (`biblioitemnumber`),
895 KEY `itembibnoidx` (`biblionumber`)
896 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
899 -- Table structure for table `ethnicity`
902 DROP TABLE IF EXISTS `ethnicity`;
903 CREATE TABLE `ethnicity` (
904 `code` varchar(10) NOT NULL default '',
905 `name` varchar(255) default NULL,
907 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
910 -- Table structure for table `issues`
913 DROP TABLE IF EXISTS `issues`;
914 CREATE TABLE `issues` (
915 `borrowernumber` int(11) default '0',
916 `itemnumber` int(11) default '0',
917 `date_due` date default NULL,
918 `branchcode` varchar(10) default '',
919 `issuingbranch` varchar(18) default NULL,
920 `issuedate` date NOT NULL default '0000-00-00',
921 `returndate` date default NULL,
922 `lastreneweddate` date default NULL,
923 `return` varchar(4) default NULL,
924 `renewals` tinyint(4) default NULL,
925 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
926 KEY `issuesborridx` (`borrowernumber`),
927 KEY `issuesitemidx` (`itemnumber`),
928 KEY `bordate` (`borrowernumber`,`timestamp`),
929 CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
930 CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL
931 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
934 -- Table structure for table `issuingrules`
937 DROP TABLE IF EXISTS `issuingrules`;
938 CREATE TABLE `issuingrules` (
939 `categorycode` varchar(10) NOT NULL default '',
940 `itemtype` varchar(10) NOT NULL default '',
941 `restrictedtype` tinyint(1) default NULL,
942 `rentaldiscount` decimal(28,6) default NULL,
943 `reservecharge` decimal(28,6) default NULL,
944 `fine` decimal(28,6) default NULL,
945 `firstremind` int(11) default NULL,
946 `chargeperiod` int(11) default NULL,
947 `accountsent` int(11) default NULL,
948 `chargename` varchar(100) default NULL,
949 `maxissueqty` int(4) default NULL,
950 `issuelength` int(4) default NULL,
951 `branchcode` varchar(4) NOT NULL default '',
952 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
953 KEY `categorycode` (`categorycode`),
954 KEY `itemtype` (`itemtype`),
955 CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
956 CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
957 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
960 -- Table structure for table `items`
963 DROP TABLE IF EXISTS `items`;
964 CREATE TABLE `items` (
965 `itemnumber` int(11) NOT NULL default '0',
966 `biblionumber` int(11) NOT NULL default '0',
967 `multivolumepart` varchar(30) default NULL,
968 `biblioitemnumber` int(11) NOT NULL default '0',
969 `barcode` varchar(20) default NULL,
970 `dateaccessioned` date default NULL,
971 `booksellerid` varchar(10) default NULL,
972 `homebranch` varchar(4) default NULL,
973 `price` decimal(8,2) default NULL,
974 `replacementprice` decimal(8,2) default NULL,
975 `replacementpricedate` date default NULL,
976 `datelastborrowed` date default NULL,
977 `datelastseen` date default NULL,
978 `multivolume` tinyint(1) default NULL,
979 `stack` tinyint(1) default NULL,
980 `notforloan` tinyint(1) default '0',
981 `itemlost` tinyint(1) default NULL,
982 `wthdrawn` tinyint(1) default NULL,
983 `itemcallnumber` varchar(30) default NULL,
984 `issues` smallint(6) default NULL,
985 `renewals` smallint(6) default NULL,
986 `reserves` smallint(6) default NULL,
987 `restricted` tinyint(1) default NULL,
988 `binding` decimal(28,6) default NULL,
990 `holdingbranch` varchar(10) default '',
992 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
993 `location` varchar(80) default NULL,
994 `onloan` date default NULL,
995 `Cutterextra` varchar(45) default NULL,
996 `issue_date` date default '0000-00-00',
997 `itype` varchar(10) default '',
998 PRIMARY KEY (`itemnumber`),
999 KEY `itembarcodeidx` (`barcode`),
1000 KEY `itembinoidx` (`biblioitemnumber`),
1001 KEY `itembibnoidx` (`biblionumber`),
1002 KEY `homebranch` (`homebranch`),
1003 KEY `holdingbranch` (`holdingbranch`),
1004 CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE,
1005 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1006 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1009 -- Table structure for table `itemsprices`
1012 DROP TABLE IF EXISTS `itemsprices`;
1013 CREATE TABLE `itemsprices` (
1014 `itemnumber` int(11) default NULL,
1015 `price1` decimal(28,6) default NULL,
1016 `price2` decimal(28,6) default NULL
1017 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1020 -- Table structure for table `itemtypes`
1023 DROP TABLE IF EXISTS `itemtypes`;
1024 CREATE TABLE `itemtypes` (
1025 `itemtype` varchar(10) NOT NULL default '',
1027 `renewalsallowed` smallint(6) default NULL,
1028 `rentalcharge` double(16,4) default NULL,
1029 `notforloan` smallint(6) default '0',
1030 `imageurl` varchar(200) default NULL,
1032 PRIMARY KEY (`itemtype`),
1033 UNIQUE KEY `itemtype` (`itemtype`)
1034 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1037 -- Table structure for table `labels`
1040 DROP TABLE IF EXISTS `labels`;
1041 CREATE TABLE `labels` (
1042 `labelid` int(11) NOT NULL auto_increment,
1043 `itemnumber` varchar(100) NOT NULL default '',
1044 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1045 PRIMARY KEY (`labelid`)
1046 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1049 -- Table structure for table `labels_conf`
1052 DROP TABLE IF EXISTS `labels_conf`;
1053 CREATE TABLE `labels_conf` (
1054 `id` int(4) NOT NULL auto_increment,
1055 `barcodetype` char(100) default '',
1056 `title` tinyint(1) default '0',
1057 `isbn` tinyint(1) default '0',
1058 `itemtype` tinyint(1) default '0',
1059 `barcode` tinyint(1) default '0',
1060 `dewey` tinyint(1) default '0',
1061 `class` tinyint(1) default '0',
1062 `author` tinyint(1) default '0',
1063 `papertype` char(100) default '',
1064 `startrow` int(2) default NULL,
1066 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1069 -- Table structure for table `letter`
1072 DROP TABLE IF EXISTS `letter`;
1073 CREATE TABLE `letter` (
1074 `module` varchar(20) NOT NULL default '',
1075 `code` varchar(20) NOT NULL default '',
1076 `name` varchar(100) NOT NULL default '',
1077 `title` varchar(200) NOT NULL default '',
1079 PRIMARY KEY (`module`,`code`)
1080 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1083 -- Table structure for table `marc_biblio`
1086 DROP TABLE IF EXISTS `marc_biblio`;
1087 CREATE TABLE `marc_biblio` (
1088 `bibid` bigint(20) unsigned NOT NULL auto_increment,
1089 `biblionumber` int(11) NOT NULL default '0',
1090 `datecreated` date NOT NULL default '0000-00-00',
1091 `datemodified` date default NULL,
1092 `origincode` char(20) default NULL,
1093 `frameworkcode` char(4) NOT NULL default '',
1094 PRIMARY KEY (`bibid`),
1095 KEY `origincode` (`origincode`),
1096 KEY `biblionumber` (`biblionumber`)
1097 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1100 -- Table structure for table `marc_blob_subfield`
1103 DROP TABLE IF EXISTS `marc_blob_subfield`;
1104 CREATE TABLE `marc_blob_subfield` (
1105 `blobidlink` bigint(20) NOT NULL auto_increment,
1106 `subfieldvalue` longtext NOT NULL,
1107 PRIMARY KEY (`blobidlink`)
1108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1111 -- Table structure for table `marc_breeding`
1114 DROP TABLE IF EXISTS `marc_breeding`;
1115 CREATE TABLE `marc_breeding` (
1116 `id` bigint(20) NOT NULL auto_increment,
1117 `file` varchar(80) NOT NULL default '',
1118 `isbn` varchar(10) NOT NULL default '',
1119 `title` varchar(128) default NULL,
1120 `author` varchar(80) default NULL,
1121 `marc` text NOT NULL,
1122 `encoding` varchar(40) NOT NULL default '',
1123 `z3950random` varchar(40) default NULL,
1125 KEY `title` (`title`),
1127 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1130 -- Table structure for table `marc_subfield_structure`
1133 DROP TABLE IF EXISTS `marc_subfield_structure`;
1134 CREATE TABLE `marc_subfield_structure` (
1135 `tagfield` varchar(3) NOT NULL default '',
1136 `tagsubfield` char(1) NOT NULL default '',
1137 `liblibrarian` varchar(255) NOT NULL default '',
1138 `libopac` varchar(255) NOT NULL default '',
1139 `repeatable` tinyint(4) NOT NULL default '0',
1140 `mandatory` tinyint(4) NOT NULL default '0',
1141 `kohafield` varchar(40) default NULL,
1142 `tab` tinyint(1) default NULL,
1143 `authorised_value` varchar(10) default NULL,
1144 `authtypecode` varchar(10) default NULL,
1145 `value_builder` varchar(80) default NULL,
1146 `isurl` tinyint(1) default NULL,
1147 `hidden` tinyint(1) default NULL,
1148 `frameworkcode` varchar(4) NOT NULL default '',
1149 `seealso` varchar(255) default NULL,
1150 `link` varchar(80) default NULL,
1151 `defaultvalue` text,
1152 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1153 KEY `tab` (`frameworkcode`,`tab`),
1154 KEY `kohafield` (`frameworkcode`,`kohafield`)
1155 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1158 -- Table structure for table `marc_subfield_table`
1161 DROP TABLE IF EXISTS `marc_subfield_table`;
1162 CREATE TABLE `marc_subfield_table` (
1163 `subfieldid` bigint(20) unsigned NOT NULL auto_increment,
1164 `bibid` bigint(20) unsigned NOT NULL default '0',
1165 `tag` varchar(3) NOT NULL default '',
1166 `tagorder` int(11) NOT NULL default '1',
1167 `tag_indicator` varchar(2) NOT NULL default '',
1168 `subfieldcode` char(1) NOT NULL default '',
1169 `subfieldorder` tinyint(4) NOT NULL default '1',
1170 `subfieldvalue` varchar(255) default NULL,
1171 `valuebloblink` bigint(20) default NULL,
1172 PRIMARY KEY (`subfieldid`),
1173 KEY `bibid` (`bibid`),
1175 KEY `tag_indicator` (`tag_indicator`),
1176 KEY `subfieldorder` (`subfieldorder`),
1177 KEY `subfieldcode` (`subfieldcode`),
1178 KEY `subfieldvalue` (`subfieldvalue`),
1179 KEY `tagorder` (`tagorder`)
1180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1183 -- Table structure for table `marc_tag_structure`
1186 DROP TABLE IF EXISTS `marc_tag_structure`;
1187 CREATE TABLE `marc_tag_structure` (
1188 `tagfield` char(3) NOT NULL default '',
1189 `liblibrarian` char(255) NOT NULL default '',
1190 `libopac` char(255) NOT NULL default '',
1191 `repeatable` tinyint(4) NOT NULL default '0',
1192 `mandatory` tinyint(4) NOT NULL default '0',
1193 `authorised_value` char(10) default NULL,
1194 `frameworkcode` char(4) NOT NULL default '',
1195 PRIMARY KEY (`frameworkcode`,`tagfield`)
1196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1199 -- Table structure for table `marc_word`
1202 DROP TABLE IF EXISTS `marc_word`;
1203 CREATE TABLE `marc_word` (
1204 `bibid` bigint(20) NOT NULL default '0',
1205 `tagsubfield` varchar(4) NOT NULL default '',
1206 `tagorder` tinyint(4) NOT NULL default '1',
1207 `subfieldorder` tinyint(4) NOT NULL default '1',
1208 `word` varchar(255) NOT NULL default '',
1209 `sndx_word` varchar(255) NOT NULL default '',
1210 KEY `bibid` (`bibid`),
1211 KEY `tagorder` (`tagorder`),
1212 KEY `subfieldorder` (`subfieldorder`),
1213 KEY `word` (`word`),
1214 KEY `sndx_word` (`sndx_word`),
1215 KEY `Search_Marc` (`tagsubfield`,`word`)
1216 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1219 -- Table structure for table `marcrecorddone`
1222 DROP TABLE IF EXISTS `marcrecorddone`;
1223 CREATE TABLE `marcrecorddone` (
1224 `isbn` char(40) default NULL,
1225 `issn` char(40) default NULL,
1226 `lccn` char(40) default NULL,
1227 `controlnumber` char(40) default NULL
1228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1231 -- Table structure for table `mediatypetable`
1234 DROP TABLE IF EXISTS `mediatypetable`;
1235 CREATE TABLE `mediatypetable` (
1236 `mediatypecode` varchar(5) NOT NULL default '',
1238 `itemtypecodes` text,
1239 PRIMARY KEY (`mediatypecode`)
1240 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1243 -- Table structure for table `notifys`
1246 DROP TABLE IF EXISTS `notifys`;
1247 CREATE TABLE `notifys` (
1248 `notify_id` int(11) NOT NULL default '0',
1249 `borrowernumber` int(11) NOT NULL default '0',
1250 `itemnumber` int(11) NOT NULL default '0',
1251 `notify_date` date NOT NULL default '0000-00-00',
1252 `notify_send_date` date default NULL,
1253 `notify_level` int(1) NOT NULL default '0',
1254 `method` varchar(20) NOT NULL default ''
1255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1258 -- Table structure for table `opac_news`
1261 DROP TABLE IF EXISTS `opac_news`;
1262 CREATE TABLE `opac_news` (
1263 `idnew` int(10) unsigned NOT NULL auto_increment,
1264 `title` varchar(250) NOT NULL default '',
1265 `new` text NOT NULL,
1266 `lang` varchar(4) NOT NULL default '',
1267 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1268 `expirationdate` date default NULL,
1269 `number` int(11) default '0',
1270 PRIMARY KEY (`idnew`)
1271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1274 -- Table structure for table `overduerules`
1277 DROP TABLE IF EXISTS `overduerules`;
1278 CREATE TABLE `overduerules` (
1279 `branchcode` varchar(255) NOT NULL default '',
1280 `categorycode` varchar(10) NOT NULL default '',
1281 `delay1` int(4) default '0',
1282 `letter1` varchar(20) default NULL,
1283 `debarred1` char(1) default '0',
1284 `delay2` int(4) default '0',
1285 `debarred2` char(1) default '0',
1286 `letter2` varchar(20) default NULL,
1287 `delay3` int(4) default '0',
1288 `letter3` varchar(20) default NULL,
1289 `debarred3` int(1) default '0',
1290 PRIMARY KEY (`branchcode`,`categorycode`)
1291 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1294 -- Table structure for table `phrase_log`
1297 DROP TABLE IF EXISTS `phrase_log`;
1298 CREATE TABLE `phrase_log` (
1299 `phr_phrase` varchar(100) NOT NULL default '',
1300 `phr_resultcount` int(11) NOT NULL default '0',
1301 `phr_ip` varchar(30) NOT NULL default '',
1302 `user` varchar(45) default NULL,
1303 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1304 `actual` text NOT NULL,
1305 KEY `phr_ip` (`phr_ip`)
1306 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1309 -- Table structure for table `printers`
1312 DROP TABLE IF EXISTS `printers`;
1313 CREATE TABLE `printers` (
1314 `printername` char(40) NOT NULL default '''''',
1315 `printqueue` char(20) default NULL,
1316 `printtype` char(20) default NULL,
1317 PRIMARY KEY (`printername`)
1318 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1321 -- Table structure for table `repeatable_holidays`
1324 DROP TABLE IF EXISTS `repeatable_holidays`;
1325 CREATE TABLE `repeatable_holidays` (
1326 `id` int(11) NOT NULL auto_increment,
1327 `branchcode` varchar(4) NOT NULL default '',
1328 `weekday` smallint(6) default NULL,
1329 `day` smallint(6) default NULL,
1330 `month` smallint(6) default NULL,
1331 `title` varchar(50) NOT NULL default '',
1332 `description` text NOT NULL,
1334 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1337 -- Table structure for table `reserveconstraints`
1340 DROP TABLE IF EXISTS `reserveconstraints`;
1341 CREATE TABLE `reserveconstraints` (
1342 `borrowernumber` int(11) NOT NULL default '0',
1343 `reservedate` date NOT NULL default '0000-00-00',
1344 `biblionumber` int(11) NOT NULL default '0',
1345 `biblioitemnumber` int(11) default NULL,
1346 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1347 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1350 -- Table structure for table `reserves`
1353 DROP TABLE IF EXISTS `reserves`;
1354 CREATE TABLE `reserves` (
1355 `borrowernumber` int(11) NOT NULL default '0',
1356 `reservedate` date NOT NULL default '0000-00-00',
1357 `biblionumber` int(11) NOT NULL default '0',
1358 `constrainttype` char(1) default NULL,
1359 `branchcode` varchar(4) default NULL,
1360 `notificationdate` date default NULL,
1361 `reminderdate` date default NULL,
1362 `cancellationdate` date default NULL,
1363 `reservenotes` text,
1364 `priority` smallint(6) default NULL,
1365 `found` char(1) default NULL,
1366 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1367 `itemnumber` int(11) default NULL,
1368 `waitingdate` date default '0000-00-00',
1369 KEY `borrowernumber` (`borrowernumber`),
1370 KEY `biblionumber` (`biblionumber`),
1371 KEY `itemnumber` (`itemnumber`),
1372 KEY `branchcode` (`branchcode`),
1373 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1374 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1375 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1376 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1380 -- Table structure for table `reviews`
1383 DROP TABLE IF EXISTS `reviews`;
1384 CREATE TABLE `reviews` (
1385 `reviewid` int(11) NOT NULL auto_increment,
1386 `borrowernumber` int(11) default NULL,
1387 `biblionumber` int(11) default NULL,
1389 `approved` tinyint(4) default NULL,
1390 `datereviewed` datetime default NULL,
1391 PRIMARY KEY (`reviewid`)
1392 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1395 -- Table structure for table `roadtype`
1398 DROP TABLE IF EXISTS `roadtype`;
1399 CREATE TABLE `roadtype` (
1400 `roadtypeid` int(11) NOT NULL auto_increment,
1401 `road_type` char(100) NOT NULL default '',
1402 PRIMARY KEY (`roadtypeid`)
1403 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1406 -- Table structure for table `serial`
1409 DROP TABLE IF EXISTS `serial`;
1410 CREATE TABLE `serial` (
1411 `serialid` int(11) NOT NULL auto_increment,
1412 `biblionumber` varchar(100) NOT NULL default '',
1413 `subscriptionid` varchar(100) NOT NULL default '',
1414 `serialseq` varchar(100) NOT NULL default '',
1415 `status` tinyint(4) NOT NULL default '0',
1416 `planneddate` date NOT NULL default '0000-00-00',
1419 `routingnotes` text,
1420 `publisheddate` date default NULL,
1421 `claimdate` date default '0000-00-00',
1422 PRIMARY KEY (`serialid`)
1423 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1426 -- Table structure for table `sessionqueries`
1429 DROP TABLE IF EXISTS `sessionqueries`;
1430 CREATE TABLE `sessionqueries` (
1431 `sessionID` varchar(255) NOT NULL default '',
1432 `userid` varchar(100) NOT NULL default '',
1433 `ip` varchar(18) NOT NULL default '',
1435 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1438 -- Table structure for table `sessions`
1441 DROP TABLE IF EXISTS `sessions`;
1442 CREATE TABLE `sessions` (
1443 `sessionID` varchar(255) NOT NULL default '',
1444 `userid` varchar(255) default NULL,
1445 `ip` varchar(16) default NULL,
1446 `lasttime` int(11) default NULL,
1447 PRIMARY KEY (`sessionID`)
1448 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1451 -- Table structure for table `shelfcontents`
1454 DROP TABLE IF EXISTS `shelfcontents`;
1455 CREATE TABLE `shelfcontents` (
1456 `shelfnumber` int(11) NOT NULL default '0',
1457 `itemnumber` int(11) NOT NULL default '0',
1458 `flags` int(11) default NULL,
1459 `dateadded` timestamp NULL default NULL,
1460 KEY `shelfnumber` (`shelfnumber`),
1461 KEY `itemnumber` (`itemnumber`),
1462 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1463 CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1464 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1467 -- Table structure for table `special_holidays`
1470 DROP TABLE IF EXISTS `special_holidays`;
1471 CREATE TABLE `special_holidays` (
1472 `id` int(11) NOT NULL auto_increment,
1473 `branchcode` varchar(4) NOT NULL default '',
1474 `day` smallint(6) NOT NULL default '0',
1475 `month` smallint(6) NOT NULL default '0',
1476 `year` smallint(6) NOT NULL default '0',
1477 `isexception` smallint(1) NOT NULL default '1',
1478 `title` varchar(50) NOT NULL default '',
1479 `description` text NOT NULL,
1481 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1484 -- Table structure for table `statistics`
1487 DROP TABLE IF EXISTS `statistics`;
1488 CREATE TABLE `statistics` (
1489 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
1490 `branch` varchar(4) default NULL,
1491 `proccode` varchar(4) default NULL,
1492 `value` double(16,4) default NULL,
1493 `type` varchar(16) default NULL,
1495 `usercode` varchar(10) default NULL,
1496 `itemnumber` int(11) default NULL,
1497 `itemtype` varchar(10) default NULL,
1498 `borrowernumber` int(11) default NULL,
1499 `associatedborrower` int(11) default NULL,
1500 KEY `timeidx` (`datetime`)
1501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1504 -- Table structure for table `stopwords`
1507 DROP TABLE IF EXISTS `stopwords`;
1508 CREATE TABLE `stopwords` (
1509 `word` varchar(255) default NULL
1510 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1513 -- Table structure for table `subcategorytable`
1516 DROP TABLE IF EXISTS `subcategorytable`;
1517 CREATE TABLE `subcategorytable` (
1518 `subcategorycode` varchar(5) NOT NULL default '',
1520 `itemtypecodes` text,
1521 PRIMARY KEY (`subcategorycode`)
1522 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1525 -- Table structure for table `subscription`
1528 DROP TABLE IF EXISTS `subscription`;
1529 CREATE TABLE `subscription` (
1530 `biblionumber` int(11) NOT NULL default '0',
1531 `manualhistory` tinyint(1) NOT NULL default '0',
1532 `subscriptionid` int(11) NOT NULL auto_increment,
1533 `librarian` varchar(100) default '',
1534 `startdate` date default '0000-00-00',
1535 `aqbooksellerid` int(11) default '0',
1536 `cost` int(11) default '0',
1537 `aqbudgetid` int(11) default '0',
1538 `weeklength` tinyint(4) default '0',
1539 `monthlength` tinyint(4) default '0',
1540 `numberlength` tinyint(4) default '0',
1541 `periodicity` tinyint(4) default '0',
1542 `dow` varchar(100) default '',
1543 `numberingmethod` varchar(100) default '',
1545 `status` varchar(100) NOT NULL default '',
1546 `add1` int(11) default '0',
1547 `every1` int(11) default '0',
1548 `whenmorethan1` int(11) default '0',
1549 `setto1` int(11) default NULL,
1550 `lastvalue1` int(11) default NULL,
1551 `add2` int(11) default '0',
1552 `every2` int(11) default '0',
1553 `whenmorethan2` int(11) default '0',
1554 `setto2` int(11) default NULL,
1555 `lastvalue2` int(11) default NULL,
1556 `add3` int(11) default '0',
1557 `every3` int(11) default '0',
1558 `innerloop1` int(11) default '0',
1559 `innerloop2` int(11) default '0',
1560 `innerloop3` int(11) default '0',
1561 `whenmorethan3` int(11) default '0',
1562 `setto3` int(11) default NULL,
1563 `lastvalue3` int(11) default NULL,
1564 `issuesatonce` tinyint(3) NOT NULL default '1',
1565 `firstacquidate` date NOT NULL default '0000-00-00',
1566 `irregularity` text,
1567 `letter` varchar(20) default NULL,
1568 `numberpattern` tinyint(3) default '0',
1569 `distributedto` text,
1571 `hemisphere` tinyint(3) default '0',
1572 `branchcode` varchar(12) NOT NULL default '''''',
1573 `internalnotes` longtext,
1574 PRIMARY KEY (`subscriptionid`)
1575 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1578 -- Table structure for table `subscriptionhistory`
1581 DROP TABLE IF EXISTS `subscriptionhistory`;
1582 CREATE TABLE `subscriptionhistory` (
1583 `biblionumber` int(11) NOT NULL default '0',
1584 `subscriptionid` int(11) NOT NULL default '0',
1585 `histstartdate` date NOT NULL default '0000-00-00',
1586 `enddate` date default '0000-00-00',
1587 `missinglist` longtext NOT NULL,
1588 `recievedlist` longtext NOT NULL,
1589 `opacnote` varchar(150) NOT NULL default '',
1590 `librariannote` varchar(150) NOT NULL default '',
1591 PRIMARY KEY (`subscriptionid`),
1592 KEY `biblionumber` (`biblionumber`)
1593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1596 -- Table structure for table `subscriptionroutinglist`
1599 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1600 CREATE TABLE `subscriptionroutinglist` (
1601 `routingid` int(11) NOT NULL auto_increment,
1602 `borrowernumber` int(11) default NULL,
1603 `ranking` int(11) default NULL,
1604 `subscriptionid` int(11) default NULL,
1605 PRIMARY KEY (`routingid`)
1606 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1609 -- Table structure for table `suggestions`
1612 DROP TABLE IF EXISTS `suggestions`;
1613 CREATE TABLE `suggestions` (
1614 `suggestionid` int(8) NOT NULL auto_increment,
1615 `suggestedby` int(11) NOT NULL default '0',
1616 `managedby` int(11) default NULL,
1617 `STATUS` varchar(10) NOT NULL default '',
1619 `author` varchar(80) default NULL,
1620 `title` varchar(80) default NULL,
1621 `copyrightdate` smallint(6) default NULL,
1622 `publishercode` varchar(255) default NULL,
1623 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1624 `volumedesc` varchar(255) default NULL,
1625 `publicationyear` smallint(6) default '0',
1626 `place` varchar(255) default NULL,
1627 `isbn` varchar(10) default NULL,
1628 `mailoverseeing` smallint(1) default '0',
1629 `biblionumber` int(11) default NULL,
1631 PRIMARY KEY (`suggestionid`),
1632 KEY `suggestedby` (`suggestedby`),
1633 KEY `managedby` (`managedby`)
1634 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1637 -- Table structure for table `systempreferences`
1640 DROP TABLE IF EXISTS `systempreferences`;
1641 CREATE TABLE `systempreferences` (
1642 `variable` varchar(50) NOT NULL default '',
1646 `type` varchar(20) default NULL,
1647 PRIMARY KEY (`variable`)
1648 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1651 -- Table structure for table `tags`
1654 DROP TABLE IF EXISTS `tags`;
1655 CREATE TABLE `tags` (
1656 `entry` varchar(255) NOT NULL default '',
1657 `weight` bigint(20) NOT NULL default '0',
1658 PRIMARY KEY (`entry`)
1659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1662 -- Table structure for table `uploadedmarc`
1665 DROP TABLE IF EXISTS `uploadedmarc`;
1666 CREATE TABLE `uploadedmarc` (
1667 `id` int(11) NOT NULL auto_increment,
1669 `hidden` smallint(6) default NULL,
1670 `name` varchar(255) default NULL,
1672 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1675 -- Table structure for table `userflags`
1678 DROP TABLE IF EXISTS `userflags`;
1679 CREATE TABLE `userflags` (
1680 `bit` int(11) NOT NULL default '0',
1681 `flag` char(30) default NULL,
1682 `flagdesc` char(255) default NULL,
1683 `defaulton` int(11) default NULL
1684 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1687 -- Table structure for table `users`
1690 DROP TABLE IF EXISTS `users`;
1691 CREATE TABLE `users` (
1692 `usercode` varchar(10) default NULL,
1695 `level` smallint(6) default NULL
1696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1699 -- Table structure for table `websites`
1702 DROP TABLE IF EXISTS `websites`;
1703 CREATE TABLE `websites` (
1704 `websitenumber` int(11) NOT NULL auto_increment,
1705 `biblionumber` int(11) NOT NULL default '0',
1708 `url` varchar(255) default NULL,
1709 PRIMARY KEY (`websitenumber`)
1710 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1713 -- Table structure for table `z3950queue`
1716 DROP TABLE IF EXISTS `z3950queue`;
1717 CREATE TABLE `z3950queue` (
1718 `id` int(11) NOT NULL auto_increment,
1720 `type` varchar(10) default NULL,
1721 `startdate` int(11) default NULL,
1722 `enddate` int(11) default NULL,
1723 `done` smallint(6) default NULL,
1725 `numrecords` int(11) default NULL,
1727 `identifier` varchar(30) default NULL,
1729 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1732 -- Table structure for table `z3950results`
1735 DROP TABLE IF EXISTS `z3950results`;
1736 CREATE TABLE `z3950results` (
1737 `id` int(11) NOT NULL auto_increment,
1738 `queryid` int(11) default NULL,
1739 `server` varchar(255) default NULL,
1740 `startdate` int(11) default NULL,
1741 `enddate` int(11) default NULL,
1743 `numrecords` int(11) default NULL,
1744 `numdownloaded` int(11) default NULL,
1745 `highestseen` int(11) default NULL,
1746 `active` smallint(6) default NULL,
1748 UNIQUE KEY `query_server` (`queryid`,`server`)
1749 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1752 -- Table structure for table `z3950servers`
1755 DROP TABLE IF EXISTS `z3950servers`;
1756 CREATE TABLE `z3950servers` (
1757 `host` varchar(255) default NULL,
1758 `port` int(11) default NULL,
1759 `db` varchar(255) default NULL,
1760 `userid` varchar(255) default NULL,
1761 `password` varchar(255) default NULL,
1763 `description` text NOT NULL,
1764 `id` int(11) NOT NULL auto_increment,
1765 `checked` smallint(6) default NULL,
1766 `rank` int(11) default NULL,
1767 `syntax` varchar(80) default NULL,
1768 `position` enum('primary','secondary','') NOT NULL default 'primary',
1770 `type` enum('zed','opensearch') NOT NULL default 'zed',
1772 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1775 -- Table structure for table `zebraqueue`
1778 DROP TABLE IF EXISTS `zebraqueue`;
1779 CREATE TABLE `zebraqueue` (
1780 `id` int(11) NOT NULL auto_increment,
1781 `biblio_auth_number` int(11) NOT NULL default '0',
1782 `operation` char(20) NOT NULL default '',
1783 `server` char(20) NOT NULL default '',
1785 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1788 -- SET FOREIGN_KEY_CHECKS = 1;
1790 -- SET AUTOCOMMIT = 1;
1792 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1793 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1794 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1795 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1796 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1797 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1798 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1799 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1801 -- Dump completed on 2007-03-12 16:24:34