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 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1152 KEY `tab` (`frameworkcode`,`tab`),
1153 KEY `kohafield` (`frameworkcode`,`kohafield`)
1154 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1157 -- Table structure for table `marc_subfield_table`
1160 DROP TABLE IF EXISTS `marc_subfield_table`;
1161 CREATE TABLE `marc_subfield_table` (
1162 `subfieldid` bigint(20) unsigned NOT NULL auto_increment,
1163 `bibid` bigint(20) unsigned NOT NULL default '0',
1164 `tag` varchar(3) NOT NULL default '',
1165 `tagorder` int(11) NOT NULL default '1',
1166 `tag_indicator` varchar(2) NOT NULL default '',
1167 `subfieldcode` char(1) NOT NULL default '',
1168 `subfieldorder` tinyint(4) NOT NULL default '1',
1169 `subfieldvalue` varchar(255) default NULL,
1170 `valuebloblink` bigint(20) default NULL,
1171 PRIMARY KEY (`subfieldid`),
1172 KEY `bibid` (`bibid`),
1174 KEY `tag_indicator` (`tag_indicator`),
1175 KEY `subfieldorder` (`subfieldorder`),
1176 KEY `subfieldcode` (`subfieldcode`),
1177 KEY `subfieldvalue` (`subfieldvalue`),
1178 KEY `tagorder` (`tagorder`)
1179 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1182 -- Table structure for table `marc_tag_structure`
1185 DROP TABLE IF EXISTS `marc_tag_structure`;
1186 CREATE TABLE `marc_tag_structure` (
1187 `tagfield` char(3) NOT NULL default '',
1188 `liblibrarian` char(255) NOT NULL default '',
1189 `libopac` char(255) NOT NULL default '',
1190 `repeatable` tinyint(4) NOT NULL default '0',
1191 `mandatory` tinyint(4) NOT NULL default '0',
1192 `authorised_value` char(10) default NULL,
1193 `frameworkcode` char(4) NOT NULL default '',
1194 PRIMARY KEY (`frameworkcode`,`tagfield`)
1195 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1198 -- Table structure for table `marc_word`
1201 DROP TABLE IF EXISTS `marc_word`;
1202 CREATE TABLE `marc_word` (
1203 `bibid` bigint(20) NOT NULL default '0',
1204 `tagsubfield` varchar(4) NOT NULL default '',
1205 `tagorder` tinyint(4) NOT NULL default '1',
1206 `subfieldorder` tinyint(4) NOT NULL default '1',
1207 `word` varchar(255) NOT NULL default '',
1208 `sndx_word` varchar(255) NOT NULL default '',
1209 KEY `bibid` (`bibid`),
1210 KEY `tagorder` (`tagorder`),
1211 KEY `subfieldorder` (`subfieldorder`),
1212 KEY `word` (`word`),
1213 KEY `sndx_word` (`sndx_word`),
1214 KEY `Search_Marc` (`tagsubfield`,`word`)
1215 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1218 -- Table structure for table `marcrecorddone`
1221 DROP TABLE IF EXISTS `marcrecorddone`;
1222 CREATE TABLE `marcrecorddone` (
1223 `isbn` char(40) default NULL,
1224 `issn` char(40) default NULL,
1225 `lccn` char(40) default NULL,
1226 `controlnumber` char(40) default NULL
1227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1230 -- Table structure for table `mediatypetable`
1233 DROP TABLE IF EXISTS `mediatypetable`;
1234 CREATE TABLE `mediatypetable` (
1235 `mediatypecode` varchar(5) NOT NULL default '',
1237 `itemtypecodes` text,
1238 PRIMARY KEY (`mediatypecode`)
1239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1242 -- Table structure for table `notifys`
1245 DROP TABLE IF EXISTS `notifys`;
1246 CREATE TABLE `notifys` (
1247 `notify_id` int(11) NOT NULL default '0',
1248 `borrowernumber` int(11) NOT NULL default '0',
1249 `itemnumber` int(11) NOT NULL default '0',
1250 `notify_date` date NOT NULL default '0000-00-00',
1251 `notify_send_date` date default NULL,
1252 `notify_level` int(1) NOT NULL default '0',
1253 `method` varchar(20) NOT NULL default ''
1254 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1257 -- Table structure for table `opac_news`
1260 DROP TABLE IF EXISTS `opac_news`;
1261 CREATE TABLE `opac_news` (
1262 `idnew` int(10) unsigned NOT NULL auto_increment,
1263 `title` varchar(250) NOT NULL default '',
1264 `new` text NOT NULL,
1265 `lang` varchar(4) NOT NULL default '',
1266 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
1267 `expirationdate` date default NULL,
1268 `number` int(11) default '0',
1269 PRIMARY KEY (`idnew`)
1270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1273 -- Table structure for table `overduerules`
1276 DROP TABLE IF EXISTS `overduerules`;
1277 CREATE TABLE `overduerules` (
1278 `branchcode` varchar(255) NOT NULL default '',
1279 `categorycode` varchar(10) NOT NULL default '',
1280 `delay1` int(4) default '0',
1281 `letter1` varchar(20) default NULL,
1282 `debarred1` char(1) default '0',
1283 `delay2` int(4) default '0',
1284 `debarred2` char(1) default '0',
1285 `letter2` varchar(20) default NULL,
1286 `delay3` int(4) default '0',
1287 `letter3` varchar(20) default NULL,
1288 `debarred3` int(1) default '0',
1289 PRIMARY KEY (`branchcode`,`categorycode`)
1290 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1293 -- Table structure for table `phrase_log`
1296 DROP TABLE IF EXISTS `phrase_log`;
1297 CREATE TABLE `phrase_log` (
1298 `phr_phrase` varchar(100) NOT NULL default '',
1299 `phr_resultcount` int(11) NOT NULL default '0',
1300 `phr_ip` varchar(30) NOT NULL default '',
1301 `user` varchar(45) default NULL,
1302 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1303 `actual` text NOT NULL,
1304 KEY `phr_ip` (`phr_ip`)
1305 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1308 -- Table structure for table `printers`
1311 DROP TABLE IF EXISTS `printers`;
1312 CREATE TABLE `printers` (
1313 `printername` char(40) NOT NULL default '''''',
1314 `printqueue` char(20) default NULL,
1315 `printtype` char(20) default NULL,
1316 PRIMARY KEY (`printername`)
1317 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1320 -- Table structure for table `repeatable_holidays`
1323 DROP TABLE IF EXISTS `repeatable_holidays`;
1324 CREATE TABLE `repeatable_holidays` (
1325 `id` int(11) NOT NULL auto_increment,
1326 `branchcode` varchar(4) NOT NULL default '',
1327 `weekday` smallint(6) default NULL,
1328 `day` smallint(6) default NULL,
1329 `month` smallint(6) default NULL,
1330 `title` varchar(50) NOT NULL default '',
1331 `description` text NOT NULL,
1333 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1336 -- Table structure for table `reserveconstraints`
1339 DROP TABLE IF EXISTS `reserveconstraints`;
1340 CREATE TABLE `reserveconstraints` (
1341 `borrowernumber` int(11) NOT NULL default '0',
1342 `reservedate` date NOT NULL default '0000-00-00',
1343 `biblionumber` int(11) NOT NULL default '0',
1344 `biblioitemnumber` int(11) default NULL,
1345 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1349 -- Table structure for table `reserves`
1352 DROP TABLE IF EXISTS `reserves`;
1353 CREATE TABLE `reserves` (
1354 `borrowernumber` int(11) NOT NULL default '0',
1355 `reservedate` date NOT NULL default '0000-00-00',
1356 `biblionumber` int(11) NOT NULL default '0',
1357 `constrainttype` char(1) default NULL,
1358 `branchcode` varchar(4) default NULL,
1359 `notificationdate` date default NULL,
1360 `reminderdate` date default NULL,
1361 `cancellationdate` date default NULL,
1362 `reservenotes` text,
1363 `priority` smallint(6) default NULL,
1364 `found` char(1) default NULL,
1365 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1366 `itemnumber` int(11) default NULL,
1367 `waitingdate` date default '0000-00-00',
1368 KEY `borrowernumber` (`borrowernumber`),
1369 KEY `biblionumber` (`biblionumber`),
1370 KEY `itemnumber` (`itemnumber`),
1371 KEY `branchcode` (`branchcode`),
1372 CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
1373 CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1374 CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1375 CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1376 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1379 -- Table structure for table `reviews`
1382 DROP TABLE IF EXISTS `reviews`;
1383 CREATE TABLE `reviews` (
1384 `reviewid` int(11) NOT NULL auto_increment,
1385 `borrowernumber` int(11) default NULL,
1386 `biblionumber` int(11) default NULL,
1388 `approved` tinyint(4) default NULL,
1389 `datereviewed` datetime default NULL,
1390 PRIMARY KEY (`reviewid`)
1391 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1394 -- Table structure for table `roadtype`
1397 DROP TABLE IF EXISTS `roadtype`;
1398 CREATE TABLE `roadtype` (
1399 `roadtypeid` int(11) NOT NULL auto_increment,
1400 `road_type` char(100) NOT NULL default '',
1401 PRIMARY KEY (`roadtypeid`)
1402 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1405 -- Table structure for table `serial`
1408 DROP TABLE IF EXISTS `serial`;
1409 CREATE TABLE `serial` (
1410 `serialid` int(11) NOT NULL auto_increment,
1411 `biblionumber` varchar(100) NOT NULL default '',
1412 `subscriptionid` varchar(100) NOT NULL default '',
1413 `serialseq` varchar(100) NOT NULL default '',
1414 `status` tinyint(4) NOT NULL default '0',
1415 `planneddate` date NOT NULL default '0000-00-00',
1418 `routingnotes` text,
1419 `publisheddate` date default NULL,
1420 `claimdate` date default '0000-00-00',
1421 PRIMARY KEY (`serialid`)
1422 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1425 -- Table structure for table `sessionqueries`
1428 DROP TABLE IF EXISTS `sessionqueries`;
1429 CREATE TABLE `sessionqueries` (
1430 `sessionID` varchar(255) NOT NULL default '',
1431 `userid` varchar(100) NOT NULL default '',
1432 `ip` varchar(18) NOT NULL default '',
1434 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1437 -- Table structure for table `sessions`
1440 DROP TABLE IF EXISTS `sessions`;
1441 CREATE TABLE `sessions` (
1442 `sessionID` varchar(255) NOT NULL default '',
1443 `userid` varchar(255) default NULL,
1444 `ip` varchar(16) default NULL,
1445 `lasttime` int(11) default NULL,
1446 PRIMARY KEY (`sessionID`)
1447 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1450 -- Table structure for table `shelfcontents`
1453 DROP TABLE IF EXISTS `shelfcontents`;
1454 CREATE TABLE `shelfcontents` (
1455 `shelfnumber` int(11) NOT NULL default '0',
1456 `itemnumber` int(11) NOT NULL default '0',
1457 `flags` int(11) default NULL,
1458 `dateadded` timestamp NULL default NULL,
1459 KEY `shelfnumber` (`shelfnumber`),
1460 KEY `itemnumber` (`itemnumber`),
1461 CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
1462 CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE
1463 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1466 -- Table structure for table `special_holidays`
1469 DROP TABLE IF EXISTS `special_holidays`;
1470 CREATE TABLE `special_holidays` (
1471 `id` int(11) NOT NULL auto_increment,
1472 `branchcode` varchar(4) NOT NULL default '',
1473 `day` smallint(6) NOT NULL default '0',
1474 `month` smallint(6) NOT NULL default '0',
1475 `year` smallint(6) NOT NULL default '0',
1476 `isexception` smallint(1) NOT NULL default '1',
1477 `title` varchar(50) NOT NULL default '',
1478 `description` text NOT NULL,
1480 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1483 -- Table structure for table `statistics`
1486 DROP TABLE IF EXISTS `statistics`;
1487 CREATE TABLE `statistics` (
1488 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
1489 `branch` varchar(4) default NULL,
1490 `proccode` varchar(4) default NULL,
1491 `value` double(16,4) default NULL,
1492 `type` varchar(16) default NULL,
1494 `usercode` varchar(10) default NULL,
1495 `itemnumber` int(11) default NULL,
1496 `itemtype` varchar(10) default NULL,
1497 `borrowernumber` int(11) default NULL,
1498 `associatedborrower` int(11) default NULL,
1499 KEY `timeidx` (`datetime`)
1500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1503 -- Table structure for table `stopwords`
1506 DROP TABLE IF EXISTS `stopwords`;
1507 CREATE TABLE `stopwords` (
1508 `word` varchar(255) default NULL
1509 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1512 -- Table structure for table `subcategorytable`
1515 DROP TABLE IF EXISTS `subcategorytable`;
1516 CREATE TABLE `subcategorytable` (
1517 `subcategorycode` varchar(5) NOT NULL default '',
1519 `itemtypecodes` text,
1520 PRIMARY KEY (`subcategorycode`)
1521 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1524 -- Table structure for table `subscription`
1527 DROP TABLE IF EXISTS `subscription`;
1528 CREATE TABLE `subscription` (
1529 `biblionumber` int(11) NOT NULL default '0',
1530 `manualhistory` tinyint(1) NOT NULL default '0',
1531 `subscriptionid` int(11) NOT NULL auto_increment,
1532 `librarian` varchar(100) default '',
1533 `startdate` date default '0000-00-00',
1534 `aqbooksellerid` int(11) default '0',
1535 `cost` int(11) default '0',
1536 `aqbudgetid` int(11) default '0',
1537 `weeklength` tinyint(4) default '0',
1538 `monthlength` tinyint(4) default '0',
1539 `numberlength` tinyint(4) default '0',
1540 `periodicity` tinyint(4) default '0',
1541 `dow` varchar(100) default '',
1542 `numberingmethod` varchar(100) default '',
1544 `status` varchar(100) NOT NULL default '',
1545 `add1` int(11) default '0',
1546 `every1` int(11) default '0',
1547 `whenmorethan1` int(11) default '0',
1548 `setto1` int(11) default NULL,
1549 `lastvalue1` int(11) default NULL,
1550 `add2` int(11) default '0',
1551 `every2` int(11) default '0',
1552 `whenmorethan2` int(11) default '0',
1553 `setto2` int(11) default NULL,
1554 `lastvalue2` int(11) default NULL,
1555 `add3` int(11) default '0',
1556 `every3` int(11) default '0',
1557 `innerloop1` int(11) default '0',
1558 `innerloop2` int(11) default '0',
1559 `innerloop3` int(11) default '0',
1560 `whenmorethan3` int(11) default '0',
1561 `setto3` int(11) default NULL,
1562 `lastvalue3` int(11) default NULL,
1563 `issuesatonce` tinyint(3) NOT NULL default '1',
1564 `firstacquidate` date NOT NULL default '0000-00-00',
1565 `irregularity` text,
1566 `letter` varchar(20) default NULL,
1567 `numberpattern` tinyint(3) default '0',
1568 `distributedto` text,
1570 `hemisphere` tinyint(3) default '0',
1571 `branchcode` varchar(12) NOT NULL default '''''',
1572 `internalnotes` longtext,
1573 PRIMARY KEY (`subscriptionid`)
1574 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1577 -- Table structure for table `subscriptionhistory`
1580 DROP TABLE IF EXISTS `subscriptionhistory`;
1581 CREATE TABLE `subscriptionhistory` (
1582 `biblionumber` int(11) NOT NULL default '0',
1583 `subscriptionid` int(11) NOT NULL default '0',
1584 `histstartdate` date NOT NULL default '0000-00-00',
1585 `enddate` date default '0000-00-00',
1586 `missinglist` longtext NOT NULL,
1587 `recievedlist` longtext NOT NULL,
1588 `opacnote` varchar(150) NOT NULL default '',
1589 `librariannote` varchar(150) NOT NULL default '',
1590 PRIMARY KEY (`subscriptionid`),
1591 KEY `biblionumber` (`biblionumber`)
1592 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1595 -- Table structure for table `subscriptionroutinglist`
1598 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1599 CREATE TABLE `subscriptionroutinglist` (
1600 `routingid` int(11) NOT NULL auto_increment,
1601 `borrowernumber` int(11) default NULL,
1602 `ranking` int(11) default NULL,
1603 `subscriptionid` int(11) default NULL,
1604 PRIMARY KEY (`routingid`)
1605 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1608 -- Table structure for table `suggestions`
1611 DROP TABLE IF EXISTS `suggestions`;
1612 CREATE TABLE `suggestions` (
1613 `suggestionid` int(8) NOT NULL auto_increment,
1614 `suggestedby` int(11) NOT NULL default '0',
1615 `managedby` int(11) default NULL,
1616 `STATUS` varchar(10) NOT NULL default '',
1618 `author` varchar(80) default NULL,
1619 `title` varchar(80) default NULL,
1620 `copyrightdate` smallint(6) default NULL,
1621 `publishercode` varchar(255) default NULL,
1622 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1623 `volumedesc` varchar(255) default NULL,
1624 `publicationyear` smallint(6) default '0',
1625 `place` varchar(255) default NULL,
1626 `isbn` varchar(10) default NULL,
1627 `mailoverseeing` smallint(1) default '0',
1628 `biblionumber` int(11) default NULL,
1630 PRIMARY KEY (`suggestionid`),
1631 KEY `suggestedby` (`suggestedby`),
1632 KEY `managedby` (`managedby`)
1633 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1636 -- Table structure for table `systempreferences`
1639 DROP TABLE IF EXISTS `systempreferences`;
1640 CREATE TABLE `systempreferences` (
1641 `variable` varchar(50) NOT NULL default '',
1645 `type` varchar(20) default NULL,
1646 PRIMARY KEY (`variable`)
1647 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1650 -- Table structure for table `tags`
1653 DROP TABLE IF EXISTS `tags`;
1654 CREATE TABLE `tags` (
1655 `entry` varchar(255) NOT NULL default '',
1656 `weight` bigint(20) NOT NULL default '0',
1657 PRIMARY KEY (`entry`)
1658 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1661 -- Table structure for table `uploadedmarc`
1664 DROP TABLE IF EXISTS `uploadedmarc`;
1665 CREATE TABLE `uploadedmarc` (
1666 `id` int(11) NOT NULL auto_increment,
1668 `hidden` smallint(6) default NULL,
1669 `name` varchar(255) default NULL,
1671 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1674 -- Table structure for table `userflags`
1677 DROP TABLE IF EXISTS `userflags`;
1678 CREATE TABLE `userflags` (
1679 `bit` int(11) NOT NULL default '0',
1680 `flag` char(30) default NULL,
1681 `flagdesc` char(255) default NULL,
1682 `defaulton` int(11) default NULL
1683 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1686 -- Table structure for table `users`
1689 DROP TABLE IF EXISTS `users`;
1690 CREATE TABLE `users` (
1691 `usercode` varchar(10) default NULL,
1694 `level` smallint(6) default NULL
1695 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1698 -- Table structure for table `websites`
1701 DROP TABLE IF EXISTS `websites`;
1702 CREATE TABLE `websites` (
1703 `websitenumber` int(11) NOT NULL auto_increment,
1704 `biblionumber` int(11) NOT NULL default '0',
1707 `url` varchar(255) default NULL,
1708 PRIMARY KEY (`websitenumber`)
1709 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1712 -- Table structure for table `z3950queue`
1715 DROP TABLE IF EXISTS `z3950queue`;
1716 CREATE TABLE `z3950queue` (
1717 `id` int(11) NOT NULL auto_increment,
1719 `type` varchar(10) default NULL,
1720 `startdate` int(11) default NULL,
1721 `enddate` int(11) default NULL,
1722 `done` smallint(6) default NULL,
1724 `numrecords` int(11) default NULL,
1726 `identifier` varchar(30) default NULL,
1728 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1731 -- Table structure for table `z3950results`
1734 DROP TABLE IF EXISTS `z3950results`;
1735 CREATE TABLE `z3950results` (
1736 `id` int(11) NOT NULL auto_increment,
1737 `queryid` int(11) default NULL,
1738 `server` varchar(255) default NULL,
1739 `startdate` int(11) default NULL,
1740 `enddate` int(11) default NULL,
1742 `numrecords` int(11) default NULL,
1743 `numdownloaded` int(11) default NULL,
1744 `highestseen` int(11) default NULL,
1745 `active` smallint(6) default NULL,
1747 UNIQUE KEY `query_server` (`queryid`,`server`)
1748 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1751 -- Table structure for table `z3950servers`
1754 DROP TABLE IF EXISTS `z3950servers`;
1755 CREATE TABLE `z3950servers` (
1756 `host` varchar(255) default NULL,
1757 `port` int(11) default NULL,
1758 `db` varchar(255) default NULL,
1759 `userid` varchar(255) default NULL,
1760 `password` varchar(255) default NULL,
1762 `description` text NOT NULL,
1763 `id` int(11) NOT NULL auto_increment,
1764 `checked` smallint(6) default NULL,
1765 `rank` int(11) default NULL,
1766 `syntax` varchar(80) default NULL,
1767 `position` enum('primary','secondary','') NOT NULL default 'primary',
1769 `type` enum('zed','opensearch') NOT NULL default 'zed',
1771 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1774 -- Table structure for table `zebraqueue`
1777 DROP TABLE IF EXISTS `zebraqueue`;
1778 CREATE TABLE `zebraqueue` (
1779 `id` int(11) NOT NULL auto_increment,
1780 `biblio_auth_number` int(11) NOT NULL default '0',
1781 `operation` char(20) NOT NULL default '',
1782 `server` char(20) NOT NULL default '',
1784 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1787 -- SET FOREIGN_KEY_CHECKS = 1;
1789 -- SET AUTOCOMMIT = 1;
1791 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1792 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1793 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1794 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1795 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1796 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1797 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1798 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1800 -- Dump completed on 2007-03-12 16:24:34