3 -- Host: localhost Database: koha
4 -- ------------------------------------------------------
5 -- Server version 4.1.15-nt
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 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17 -- Table structure for table `accountlines`
20 DROP TABLE IF EXISTS `accountlines`;
21 CREATE TABLE `accountlines` (
22 `borrowernumber` int(11) NOT NULL default '0',
23 `accountno` smallint(6) NOT NULL default '0',
24 `itemnumber` int(11) default NULL,
25 `date` date default NULL,
26 `amount` decimal(28,6) default NULL,
27 `description` text character set utf8,
28 `dispute` text character set utf8,
29 `accounttype` varchar(5) character set utf8 default NULL,
30 `amountoutstanding` decimal(28,6) default NULL,
31 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
32 `offset` int(10) unsigned default NULL,
33 `accountid` bigint(20) unsigned NOT NULL auto_increment,
34 PRIMARY KEY (`accountid`),
35 KEY `acctsborridx` (`borrowernumber`),
36 KEY `offset` (`offset`),
37 KEY `acct` (`accountno`)
38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
41 -- Table structure for table `accountoffsets`
44 DROP TABLE IF EXISTS `accountoffsets`;
45 CREATE TABLE `accountoffsets` (
46 `borrowernumber` int(11) NOT NULL default '0',
47 `accountno` smallint(6) NOT NULL default '0',
48 `offsetaccount` smallint(6) NOT NULL default '0',
49 `offsetamount` decimal(28,6) default NULL,
50 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
54 -- Table structure for table `action_logs`
57 DROP TABLE IF EXISTS `action_logs`;
58 CREATE TABLE `action_logs` (
59 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
60 `user` varchar(45) NOT NULL default '',
61 `module` varchar(45) NOT NULL default '',
62 `action` varchar(45) NOT NULL default '',
63 `object` varchar(45) NOT NULL default '',
65 `id` int(10) unsigned NOT NULL auto_increment,
67 KEY `time` (`timestamp`),
68 KEY `action` (`action`)
69 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
72 -- Table structure for table `alert`
75 DROP TABLE IF EXISTS `alert`;
76 CREATE TABLE `alert` (
77 `alertid` int(11) NOT NULL auto_increment,
78 `borrowernumber` int(11) NOT NULL default '0',
79 `type` varchar(10) NOT NULL default '',
80 `externalid` varchar(20) NOT NULL default '',
81 PRIMARY KEY (`alertid`),
82 KEY `borrowernumber` (`borrowernumber`),
83 KEY `type` (`type`,`externalid`)
84 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
87 -- Table structure for table `aqbasket`
90 DROP TABLE IF EXISTS `aqbasket`;
91 CREATE TABLE `aqbasket` (
92 `basketno` int(11) NOT NULL auto_increment,
93 `creationdate` date default NULL,
94 `closedate` date default NULL,
95 `booksellerid` varchar(10) default NULL,
96 `authorisedby` varchar(10) default NULL,
97 `booksellerinvoicenumber` text,
98 PRIMARY KEY (`basketno`)
99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
102 -- Table structure for table `aqbookfund`
105 DROP TABLE IF EXISTS `aqbookfund`;
106 CREATE TABLE `aqbookfund` (
107 `bookfundid` varchar(5) NOT NULL default '''''',
109 `bookfundgroup` varchar(5) default NULL,
110 `branchcode` varchar(4) default NULL,
111 PRIMARY KEY (`bookfundid`)
112 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
115 -- Table structure for table `aqbooksellers`
118 DROP TABLE IF EXISTS `aqbooksellers`;
119 CREATE TABLE `aqbooksellers` (
120 `id` int(11) default NULL,
126 `phone` varchar(30) default NULL,
127 `accountnumber` text,
128 `othersupplier` text,
129 `currency` varchar(3) NOT NULL default '',
130 `deliverydays` smallint(6) default NULL,
131 `followupdays` smallint(6) default NULL,
132 `followupscancel` smallint(6) default NULL,
134 `booksellerfax` text,
136 `bookselleremail` text,
137 `booksellerurl` text,
138 `contact` varchar(100) default NULL,
140 `url` varchar(255) default NULL,
141 `contpos` varchar(100) default NULL,
142 `contphone` varchar(100) default NULL,
143 `contfax` varchar(100) default NULL,
144 `contaltphone` varchar(100) default NULL,
145 `contemail` varchar(100) default NULL,
147 `active` tinyint(4) default NULL,
148 `listprice` varchar(5) default NULL,
149 `invoiceprice` varchar(5) default NULL,
150 `gstreg` tinyint(4) default NULL,
151 `listincgst` tinyint(4) default NULL,
152 `invoiceincgst` tinyint(4) default NULL,
153 `discount` decimal(3,2) default NULL,
154 `fax` varchar(50) default NULL,
155 `nocalc` int(11) default NULL,
156 `invoicedisc` decimal(3,2) default NULL
157 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
160 -- Table structure for table `aqbudget`
163 DROP TABLE IF EXISTS `aqbudget`;
164 CREATE TABLE `aqbudget` (
165 `bookfundid` varchar(5) NOT NULL default '',
166 `startdate` date NOT NULL default '0000-00-00',
167 `enddate` date default NULL,
168 `budgetamount` decimal(13,2) default NULL,
169 `aqbudgetid` tinyint(4) NOT NULL auto_increment,
170 `branchcode` varchar(4) default NULL,
171 PRIMARY KEY (`aqbudgetid`)
172 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
175 -- Table structure for table `aqorderbreakdown`
178 DROP TABLE IF EXISTS `aqorderbreakdown`;
179 CREATE TABLE `aqorderbreakdown` (
180 `ordernumber` int(11) NOT NULL default '0',
181 `linenumber` int(11) default NULL,
182 `branchcode` char(4) default NULL,
183 `bookfundid` char(5) NOT NULL default '',
184 `allocation` smallint(6) default NULL,
185 PRIMARY KEY (`ordernumber`)
186 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
189 -- Table structure for table `aqorderdelivery`
192 DROP TABLE IF EXISTS `aqorderdelivery`;
193 CREATE TABLE `aqorderdelivery` (
194 `ordernumber` date NOT NULL default '0000-00-00',
195 `deliverynumber` smallint(6) NOT NULL default '0',
196 `deliverydate` varchar(18) default NULL,
197 `qtydelivered` smallint(6) default NULL,
198 `deliverycomments` text,
199 KEY `ordernumber` (`ordernumber`)
200 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
203 -- Table structure for table `aqorders`
206 DROP TABLE IF EXISTS `aqorders`;
207 CREATE TABLE `aqorders` (
208 `ordernumber` int(11) NOT NULL auto_increment,
209 `biblionumber` int(11) default NULL,
211 `entrydate` date default NULL,
212 `quantity` smallint(6) default NULL,
213 `currency` varchar(3) default NULL,
214 `listprice` decimal(28,2) default NULL,
215 `totalamount` decimal(28,2) default NULL,
216 `datereceived` date default NULL,
217 `booksellerinvoicenumber` text,
218 `freight` decimal(28,2) default NULL,
219 `unitprice` decimal(28,2) default NULL,
220 `quantityreceived` smallint(6) default NULL,
221 `cancelledby` varchar(10) default NULL,
222 `datecancellationprinted` date default NULL,
224 `supplierreference` text,
225 `purchaseordernumber` text,
226 `subscription` tinyint(1) default NULL,
227 `serialid` varchar(30) default NULL,
228 `basketno` int(11) default NULL,
229 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
230 `rrp` decimal(13,2) default NULL,
231 `ecost` decimal(13,2) default NULL,
232 `gst` decimal(13,2) default NULL,
233 `budgetdate` date default NULL,
234 `sort1` varchar(80) default NULL,
235 `sort2` varchar(80) default NULL,
236 `discount` decimal(3,2) NOT NULL default '0.00',
237 PRIMARY KEY (`ordernumber`)
238 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
241 -- Table structure for table `attempted_contacts`
244 DROP TABLE IF EXISTS `attempted_contacts`;
245 CREATE TABLE `attempted_contacts` (
246 `borrowernumber` int(11) default NULL,
247 `method` varchar(50) default NULL,
248 `address` varchar(255) default NULL,
249 `result` int(11) default NULL,
251 `date` datetime default NULL,
252 KEY `borrowernumber` (`borrowernumber`)
253 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
256 -- Table structure for table `auth_header`
259 DROP TABLE IF EXISTS `auth_header`;
260 CREATE TABLE `auth_header` (
261 `authid` bigint(20) unsigned NOT NULL default '0',
262 `authtypecode` varchar(10) NOT NULL default '',
263 `datecreated` date NOT NULL default '0000-00-00',
264 `marc` blob NOT NULL,
265 `marcxml` text NOT NULL,
266 PRIMARY KEY (`authid`),
267 KEY `authority` (`authtypecode`)
268 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
271 -- Table structure for table `auth_subfield_structure`
274 DROP TABLE IF EXISTS `auth_subfield_structure`;
275 CREATE TABLE `auth_subfield_structure` (
276 `authtypecode` varchar(10) NOT NULL default '',
277 `tagfield` varchar(3) NOT NULL default '',
278 `tagsubfield` char(1) NOT NULL default '',
279 `liblibrarian` varchar(255) NOT NULL default '',
280 `libopac` varchar(255) NOT NULL default '',
281 `repeatable` tinyint(4) NOT NULL default '0',
282 `mandatory` tinyint(4) NOT NULL default '0',
283 `tab` tinyint(1) default NULL,
284 `authorised_value` varchar(10) default NULL,
285 `value_builder` varchar(80) default NULL,
286 `seealso` varchar(255) default NULL,
287 `hidden` tinyint(3) unsigned zerofill NOT NULL default '000',
288 `isurl` tinyint(1) unsigned default NULL,
289 `kohafield` varchar(45) NOT NULL default '',
290 `link` tinyint(1) unsigned NOT NULL default '0',
291 PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`),
292 KEY `tab` (`authtypecode`,`tab`)
293 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
296 -- Table structure for table `auth_tag_structure`
299 DROP TABLE IF EXISTS `auth_tag_structure`;
300 CREATE TABLE `auth_tag_structure` (
301 `authtypecode` char(10) NOT NULL default '',
302 `tagfield` char(3) NOT NULL default '',
303 `liblibrarian` char(255) NOT NULL default '',
304 `libopac` char(255) NOT NULL default '',
305 `repeatable` tinyint(4) NOT NULL default '0',
306 `mandatory` tinyint(4) NOT NULL default '0',
307 `authorised_value` char(10) default NULL,
308 PRIMARY KEY (`authtypecode`,`tagfield`)
309 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
312 -- Table structure for table `auth_types`
315 DROP TABLE IF EXISTS `auth_types`;
316 CREATE TABLE `auth_types` (
317 `authtypecode` varchar(10) NOT NULL default '',
318 `authtypetext` varchar(255) NOT NULL default '',
319 `auth_tag_to_report` varchar(3) NOT NULL default '',
320 `summary` text NOT NULL,
321 PRIMARY KEY (`authtypecode`)
322 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
325 -- Table structure for table `authorised_values`
328 DROP TABLE IF EXISTS `authorised_values`;
329 CREATE TABLE `authorised_values` (
330 `id` int(11) NOT NULL auto_increment,
331 `category` char(10) NOT NULL default '',
332 `authorised_value` char(80) NOT NULL default '',
333 `lib` char(80) default NULL,
335 KEY `name` (`category`)
336 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
339 -- Table structure for table `biblio`
342 DROP TABLE IF EXISTS `biblio`;
343 CREATE TABLE `biblio` (
344 `biblionumber` int(11) NOT NULL default '0',
346 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
347 `frameworkcode` varchar(45) default '',
348 `itemtype` varchar(45) default NULL,
349 `marcxml` text NOT NULL,
350 `title` varchar(255) default NULL,
351 `author` varchar(255) default NULL,
352 `isbn` varchar(15) default NULL,
353 `issn` varchar(15) default NULL,
354 PRIMARY KEY (`biblionumber`),
356 KEY `author` (`author`),
357 KEY `title` (`title`),
358 KEY `itemtype` (`itemtype`),
360 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
363 -- Table structure for table `biblios_framework`
366 DROP TABLE IF EXISTS `biblios_framework`;
367 CREATE TABLE `biblios_framework` (
368 `frameworkcode` char(4) NOT NULL default '',
369 `frameworktext` char(255) NOT NULL default '',
370 PRIMARY KEY (`frameworkcode`)
371 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
374 -- Table structure for table `biblios_subfield_structure`
377 DROP TABLE IF EXISTS `biblios_subfield_structure`;
378 CREATE TABLE `biblios_subfield_structure` (
379 `tagfield` varchar(3) NOT NULL default '',
380 `tagsubfield` char(1) NOT NULL default '',
381 `liblibrarian` varchar(255) NOT NULL default '',
382 `libopac` varchar(255) NOT NULL default '',
383 `repeatable` tinyint(4) NOT NULL default '0',
384 `mandatory` tinyint(4) NOT NULL default '0',
385 `tab` tinyint(1) default NULL,
386 `authorised_value` varchar(10) default NULL,
387 `authtypecode` varchar(10) default NULL,
388 `value_builder` varchar(80) default NULL,
389 `isurl` tinyint(1) default NULL,
390 `hidden` tinyint(3) unsigned zerofill default NULL,
391 `frameworkcode` varchar(4) NOT NULL default '',
393 `link` varchar(80) default NULL,
394 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
395 KEY `tab` (`frameworkcode`,`tab`)
396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
399 -- Table structure for table `biblios_tag_structure`
402 DROP TABLE IF EXISTS `biblios_tag_structure`;
403 CREATE TABLE `biblios_tag_structure` (
404 `tagfield` char(3) NOT NULL default '',
405 `liblibrarian` char(255) NOT NULL default '',
406 `libopac` char(255) NOT NULL default '',
407 `repeatable` tinyint(4) NOT NULL default '0',
408 `mandatory` tinyint(4) NOT NULL default '0',
409 `authorised_value` char(10) default NULL,
410 `frameworkcode` char(4) NOT NULL default '',
411 PRIMARY KEY (`frameworkcode`,`tagfield`)
412 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
415 -- Table structure for table `bookshelf`
418 DROP TABLE IF EXISTS `bookshelf`;
419 CREATE TABLE `bookshelf` (
420 `shelfnumber` int(11) NOT NULL auto_increment,
421 `shelfname` char(255) default NULL,
422 `owner` char(80) default NULL,
423 `category` char(1) default NULL,
424 PRIMARY KEY (`shelfnumber`)
425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
428 -- Table structure for table `bookshelves_careers`
431 DROP TABLE IF EXISTS `bookshelves_careers`;
432 CREATE TABLE `bookshelves_careers` (
433 `shelfnumber` int(11) NOT NULL default '0',
434 `id_career` mediumint(9) NOT NULL default '0',
435 PRIMARY KEY (`shelfnumber`,`id_career`)
436 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
439 -- Table structure for table `borexp`
442 DROP TABLE IF EXISTS `borexp`;
443 CREATE TABLE `borexp` (
444 `borrowernumber` int(11) default NULL,
445 `newexp` date default NULL,
446 KEY `borrowernumber` (`borrowernumber`)
447 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
450 -- Table structure for table `borrowers`
453 DROP TABLE IF EXISTS `borrowers`;
454 CREATE TABLE `borrowers` (
455 `borrowernumber` int(11) NOT NULL auto_increment,
456 `cardnumber` varchar(16) NOT NULL default '',
457 `surname` text NOT NULL,
458 `firstname` text NOT NULL,
461 `initials` text NOT NULL,
462 `streetaddress` text NOT NULL,
464 `city` text NOT NULL,
465 `phone` text NOT NULL,
468 `textmessaging` text,
469 `altstreetaddress` text,
473 `dateofbirth` date default NULL,
474 `branchcode` varchar(4) NOT NULL default '',
475 `categorycode` varchar(2) default NULL,
476 `dateenrolled` date default NULL,
477 `gonenoaddress` tinyint(1) default NULL,
478 `lost` tinyint(1) default NULL,
479 `debarred` tinyint(1) default NULL,
480 `studentnumber` text,
483 `borrowernotes` text,
484 `guarantor` int(11) default NULL,
485 `area` varchar(2) default NULL,
486 `ethnicity` varchar(50) default NULL,
487 `ethnotes` varchar(255) default NULL,
488 `sex` char(1) default NULL,
489 `expiry` date default NULL,
490 `altnotes` varchar(255) default NULL,
491 `altrelationship` varchar(100) default NULL,
493 `phoneday` varchar(50) default NULL,
494 `preferredcont` char(1) default NULL,
495 `physstreet` varchar(100) default NULL,
496 `password` varchar(30) default NULL,
497 `flags` int(11) default NULL,
498 `userid` varchar(30) default NULL,
499 `homezipcode` varchar(25) default NULL,
500 `zipcode` varchar(25) default NULL,
501 `sort1` varchar(80) default NULL,
502 `sort2` varchar(80) default NULL,
503 UNIQUE KEY `cardnumber` (`cardnumber`),
504 KEY `borrowernumber` (`borrowernumber`),
505 FULLTEXT KEY `namesearch` (`surname`,`firstname`,`othernames`)
506 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
509 -- Table structure for table `borrowers_to_borrowers`
512 DROP TABLE IF EXISTS `borrowers_to_borrowers`;
513 CREATE TABLE `borrowers_to_borrowers` (
514 `borrower1` int(11) default NULL,
515 `borrower2` int(11) default NULL
516 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
519 -- Table structure for table `branchcategories`
522 DROP TABLE IF EXISTS `branchcategories`;
523 CREATE TABLE `branchcategories` (
524 `categorycode` varchar(4) NOT NULL default '',
526 `codedescription` text,
527 PRIMARY KEY (`categorycode`)
528 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
531 -- Table structure for table `branches`
534 DROP TABLE IF EXISTS `branches`;
535 CREATE TABLE `branches` (
536 `branchcode` varchar(4) NOT NULL default '',
537 `branchname` text NOT NULL,
538 `branchaddress1` text,
539 `branchaddress2` text,
540 `branchaddress3` text,
544 `issuing` tinyint(4) default NULL,
545 UNIQUE KEY `branchcode` (`branchcode`)
546 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
549 -- Table structure for table `branchrelations`
552 DROP TABLE IF EXISTS `branchrelations`;
553 CREATE TABLE `branchrelations` (
554 `branchcode` varchar(4) default NULL,
555 `categorycode` varchar(4) default NULL,
556 KEY `branchcode` (`branchcode`)
557 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
560 -- Table structure for table `branchtransfers`
563 DROP TABLE IF EXISTS `branchtransfers`;
564 CREATE TABLE `branchtransfers` (
565 `itemnumber` int(11) NOT NULL default '0',
566 `datesent` datetime default NULL,
567 `frombranch` varchar(4) default NULL,
568 `datearrived` datetime default NULL,
569 `tobranch` varchar(4) default NULL,
571 KEY `itemnumber` (`itemnumber`),
572 KEY `branch` (`frombranch`)
573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
576 -- Table structure for table `careers`
579 DROP TABLE IF EXISTS `careers`;
580 CREATE TABLE `careers` (
581 `id_career` mediumint(9) NOT NULL auto_increment,
582 `id_institution` smallint(6) NOT NULL default '0',
583 `career_name` varchar(50) NOT NULL default '',
584 PRIMARY KEY (`id_career`),
585 KEY `id_institution` (`id_institution`)
586 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
589 -- Table structure for table `categories`
592 DROP TABLE IF EXISTS `categories`;
593 CREATE TABLE `categories` (
594 `categorycode` varchar(2) NOT NULL default '',
596 `enrolmentperiod` smallint(6) default NULL,
597 `upperagelimit` smallint(6) default NULL,
598 `dateofbirthrequired` tinyint(1) default NULL,
599 `finetype` varchar(30) default NULL,
600 `bulk` tinyint(1) default NULL,
601 `enrolmentfee` decimal(28,6) default NULL,
602 `overduenoticerequired` tinyint(1) default NULL,
603 `issuelimit` smallint(6) default NULL,
604 `reservefee` decimal(28,2) default NULL,
605 `canmakepublicshelves` tinyint(4) default NULL,
606 `allowrenewsfromopac` tinyint(4) default NULL,
607 `addRequestToShelves` tinyint(4) default NULL,
608 `category_type` varchar(45) NOT NULL default '',
609 UNIQUE KEY `categorycode` (`categorycode`)
610 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
613 -- Table structure for table `categorytable`
616 DROP TABLE IF EXISTS `categorytable`;
617 CREATE TABLE `categorytable` (
618 `categorycode` varchar(5) NOT NULL default '',
620 `itemtypecodes` text,
621 PRIMARY KEY (`categorycode`)
622 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
625 -- Table structure for table `cities`
628 DROP TABLE IF EXISTS `cities`;
629 CREATE TABLE `cities` (
630 `cityid` int(11) NOT NULL auto_increment,
631 `city_name` char(100) NOT NULL default '',
632 `city_zipcode` char(20) default NULL,
633 PRIMARY KEY (`cityid`)
634 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
637 -- Table structure for table `currency`
640 DROP TABLE IF EXISTS `currency`;
641 CREATE TABLE `currency` (
642 `currency` varchar(10) default NULL,
643 `rate` float(7,5) default NULL
644 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
647 -- Table structure for table `deletedbiblio`
650 DROP TABLE IF EXISTS `deletedbiblio`;
651 CREATE TABLE `deletedbiblio` (
652 `biblionumber` int(10) unsigned NOT NULL auto_increment,
654 `itemtype` varchar(45) default NULL,
655 `frameworkcode` varchar(45) default NULL,
656 `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
658 `title` varchar(245) default NULL,
659 `author` varchar(245) default NULL,
660 `isbn` varchar(45) default NULL,
661 `issn` varchar(45) default NULL,
662 PRIMARY KEY (`biblionumber`)
663 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
666 -- Table structure for table `deletedborrowers`
669 DROP TABLE IF EXISTS `deletedborrowers`;
670 CREATE TABLE `deletedborrowers` (
671 `borrowernumber` int(11) NOT NULL default '0',
672 `cardnumber` varchar(9) default NULL,
673 `surname` text NOT NULL,
678 `streetaddress` text,
684 `altstreetaddress` text,
688 `dateofbirth` date default NULL,
689 `branchcode` varchar(4) default NULL,
690 `categorycode` varchar(2) default NULL,
691 `dateenrolled` date default NULL,
692 `gonenoaddress` tinyint(1) default NULL,
693 `lost` tinyint(1) default NULL,
694 `debarred` tinyint(1) default NULL,
695 `studentnumber` text,
698 `borrowernotes` text,
699 `guarantor` int(11) default NULL,
700 `area` varchar(2) default NULL,
701 `ethnicity` varchar(50) default NULL,
702 `ethnotes` varchar(255) default NULL,
703 `sex` char(1) default NULL,
704 `expiry` date default NULL,
705 `altnotes` varchar(255) default NULL,
706 `altrelationship` varchar(100) default NULL,
708 `phoneday` varchar(50) default NULL,
709 `preferredcont` varchar(100) default NULL,
710 `physstreet` varchar(100) default NULL,
711 KEY `borrowernumber` (`borrowernumber`),
712 KEY `cardnumber` (`cardnumber`)
713 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
716 -- Table structure for table `deleteditems`
719 DROP TABLE IF EXISTS `deleteditems`;
720 CREATE TABLE `deleteditems` (
721 `itemnumber` int(11) NOT NULL default '0',
722 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
724 `biblionumber` varchar(45) default NULL,
725 `barcode` varchar(45) default NULL,
727 PRIMARY KEY (`itemnumber`)
728 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
731 -- Table structure for table `dictionary`
734 DROP TABLE IF EXISTS `dictionary`;
735 CREATE TABLE `dictionary` (
736 `english` varchar(80) NOT NULL default '',
737 `turkish` varchar(80) NOT NULL default '',
738 KEY `english` (`english`),
739 KEY `turkish` (`turkish`)
740 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
743 -- Table structure for table `educational_institutions`
746 DROP TABLE IF EXISTS `educational_institutions`;
747 CREATE TABLE `educational_institutions` (
748 `id_institution` smallint(6) NOT NULL auto_increment,
749 `institution_name` varchar(50) NOT NULL default '',
750 PRIMARY KEY (`id_institution`)
751 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
754 -- Table structure for table `ethnicity`
757 DROP TABLE IF EXISTS `ethnicity`;
758 CREATE TABLE `ethnicity` (
759 `code` varchar(10) NOT NULL default '',
760 `name` varchar(255) default NULL,
762 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
765 -- Table structure for table `holdings_subfield_structure`
768 DROP TABLE IF EXISTS `holdings_subfield_structure`;
769 CREATE TABLE `holdings_subfield_structure` (
770 `tagfield` varchar(3) NOT NULL default '',
771 `tagsubfield` char(1) NOT NULL default '',
772 `liblibrarian` varchar(255) NOT NULL default '',
773 `libopac` varchar(255) NOT NULL default '',
774 `repeatable` tinyint(4) NOT NULL default '0',
775 `mandatory` tinyint(4) NOT NULL default '0',
776 `tab` tinyint(1) default NULL,
777 `authorised_value` varchar(10) default NULL,
778 `authtypecode` varchar(10) default NULL,
779 `value_builder` varchar(80) default NULL,
780 `isurl` tinyint(1) default NULL,
781 `hidden` tinyint(3) unsigned zerofill default NULL,
782 `frameworkcode` varchar(4) NOT NULL default '',
784 `link` varchar(80) default NULL,
785 PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
786 KEY `tab` (`frameworkcode`,`tab`)
787 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
790 -- Table structure for table `holdings_tag_structure`
793 DROP TABLE IF EXISTS `holdings_tag_structure`;
794 CREATE TABLE `holdings_tag_structure` (
795 `tagfield` char(3) NOT NULL default '',
796 `liblibrarian` char(255) NOT NULL default '',
797 `libopac` char(255) NOT NULL default '',
798 `repeatable` tinyint(4) NOT NULL default '0',
799 `mandatory` tinyint(4) NOT NULL default '0',
800 `authorised_value` char(10) default NULL,
801 `frameworkcode` char(4) NOT NULL default '',
802 PRIMARY KEY (`frameworkcode`,`tagfield`)
803 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
806 -- Table structure for table `issues`
809 DROP TABLE IF EXISTS `issues`;
810 CREATE TABLE `issues` (
811 `issid` int(11) NOT NULL auto_increment,
812 `borrowernumber` int(11) NOT NULL default '0',
813 `itemnumber` int(11) NOT NULL default '0',
814 `date_due` date default NULL,
815 `branchcode` char(4) default NULL,
816 `issuingbranch` char(18) default NULL,
817 `returndate` date default NULL,
818 `lastreneweddate` date default NULL,
819 `return` char(4) default NULL,
820 `renewals` tinyint(4) default NULL,
821 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
822 `issue_date` date default NULL,
823 PRIMARY KEY (`issid`),
824 KEY `issuesborridx` (`borrowernumber`),
825 KEY `issuesitemidx` (`itemnumber`),
826 KEY `bordate` (`borrowernumber`,`timestamp`),
827 KEY `duedate` (`date_due`)
828 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
831 -- Table structure for table `issuingrules`
834 DROP TABLE IF EXISTS `issuingrules`;
835 CREATE TABLE `issuingrules` (
836 `categorycode` varchar(2) NOT NULL default '',
837 `itemtype` varchar(4) NOT NULL default '',
838 `restrictedtype` tinyint(1) default NULL,
839 `rentaldiscount` decimal(28,6) default NULL,
840 `reservecharge` decimal(28,6) default NULL,
841 `fine` decimal(28,6) default NULL,
842 `firstremind` int(11) default NULL,
843 `chargeperiod` int(11) default NULL,
844 `accountsent` int(11) default NULL,
845 `chargename` varchar(100) default NULL,
846 `maxissueqty` int(4) default NULL,
847 `issuelength` int(4) default NULL,
848 `branchcode` varchar(4) NOT NULL default '',
849 `discount` int(10) unsigned NOT NULL default '0',
850 PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`)
851 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
854 -- Table structure for table `items`
857 DROP TABLE IF EXISTS `items`;
858 CREATE TABLE `items` (
859 `itemnumber` int(11) NOT NULL default '0',
860 `biblionumber` int(11) NOT NULL default '0',
861 `barcode` varchar(20) default NULL,
862 `marc` blob NOT NULL,
863 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
864 `marcxml` text NOT NULL,
865 PRIMARY KEY (`itemnumber`),
866 UNIQUE KEY `itembarcodeidx` USING BTREE (`barcode`),
867 KEY `itembibnoidx` (`biblionumber`),
868 KEY `timestamp` (`timestamp`)
869 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
872 -- Table structure for table `itemtypes`
875 DROP TABLE IF EXISTS `itemtypes`;
876 CREATE TABLE `itemtypes` (
877 `itemtype` varchar(4) NOT NULL default '',
879 `renewalsallowed` smallint(6) default NULL,
880 `rentalcharge` double(16,4) default NULL,
881 `notforloan` smallint(6) default NULL,
882 `imageurl` varchar(200) default NULL,
883 UNIQUE KEY `itemtype` (`itemtype`)
884 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
887 -- Table structure for table `koha_attr`
890 DROP TABLE IF EXISTS `koha_attr`;
891 CREATE TABLE `koha_attr` (
892 `kohafield` varchar(45) NOT NULL default '',
893 `id` int(10) unsigned NOT NULL auto_increment,
894 `attr` varchar(45) NOT NULL default '',
895 `label` varchar(100) NOT NULL default '',
896 `sorts` tinyint(1) unsigned NOT NULL default '0',
897 `recordtype` varchar(45) NOT NULL default '',
898 `opacshow` tinyint(1) unsigned zerofill NOT NULL default '0',
899 `tagfield` varchar(3) default NULL,
900 `tagsubfield` char(1) default NULL,
901 `intrashow` tinyint(1) unsigned zerofill NOT NULL default '0',
902 `extraattr` varchar(245) NOT NULL default '',
903 `facets_label` varchar(45) NOT NULL default '',
905 KEY `marctokoha` USING BTREE (`kohafield`)
906 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
909 -- Table structure for table `letter`
912 DROP TABLE IF EXISTS `letter`;
913 CREATE TABLE `letter` (
914 `module` varchar(20) NOT NULL default '',
915 `code` varchar(20) NOT NULL default '',
916 `name` varchar(100) NOT NULL default '',
917 `title` varchar(200) NOT NULL default '',
919 PRIMARY KEY (`module`,`code`)
920 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
923 -- Table structure for table `marc_breeding`
926 DROP TABLE IF EXISTS `marc_breeding`;
927 CREATE TABLE `marc_breeding` (
928 `id` bigint(20) NOT NULL auto_increment,
929 `file` varchar(80) NOT NULL default '',
930 `isbn` varchar(10) NOT NULL default '',
931 `title` varchar(128) default NULL,
932 `author` varchar(80) default NULL,
933 `marc` blob NOT NULL,
934 `encoding` varchar(40) NOT NULL default '''''',
935 `z3950random` varchar(40) default NULL,
936 `classification` varchar(45) default '',
937 `subclass` varchar(45) default '',
939 KEY `title` (`title`),
941 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
944 -- Table structure for table `mediatypetable`
947 DROP TABLE IF EXISTS `mediatypetable`;
948 CREATE TABLE `mediatypetable` (
949 `mediatypecode` varchar(5) NOT NULL default '',
951 `itemtypecodes` text,
952 PRIMARY KEY (`mediatypecode`)
953 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
956 -- Table structure for table `opac_electronic`
959 DROP TABLE IF EXISTS `opac_electronic`;
960 CREATE TABLE `opac_electronic` (
961 `idelectronic` int(4) NOT NULL auto_increment,
962 `title` varchar(250) NOT NULL default '',
964 `lang` varchar(4) NOT NULL default '',
965 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
966 `image` varchar(250) default NULL,
967 `href` varchar(250) default NULL,
968 `section` varchar(45) NOT NULL default '',
969 PRIMARY KEY (`idelectronic`)
970 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
973 -- Table structure for table `opac_news`
976 DROP TABLE IF EXISTS `opac_news`;
977 CREATE TABLE `opac_news` (
978 `idnew` int(10) unsigned NOT NULL auto_increment,
979 `title` varchar(250) NOT NULL default '',
981 `lang` varchar(4) NOT NULL default '',
982 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
983 PRIMARY KEY (`idnew`)
984 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
987 -- Table structure for table `overduerules`
990 DROP TABLE IF EXISTS `overduerules`;
991 CREATE TABLE `overduerules` (
992 `branchcode` varchar(255) NOT NULL default '',
993 `categorycode` varchar(2) NOT NULL default '',
994 `delay1` int(4) default '0',
995 `letter1` varchar(20) default NULL,
996 `debarred1` char(1) default '0',
997 `delay2` int(4) default '0',
998 `debarred2` char(1) default '0',
999 `letter2` varchar(20) default NULL,
1000 `delay3` int(4) default '0',
1001 `letter3` varchar(20) default NULL,
1002 `debarred3` int(1) default '0',
1003 PRIMARY KEY (`branchcode`,`categorycode`)
1004 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1007 -- Table structure for table `phrase_log`
1010 DROP TABLE IF EXISTS `phrase_log`;
1011 CREATE TABLE `phrase_log` (
1012 `phr_phrase` varchar(100) NOT NULL default '',
1013 `phr_resultcount` int(11) NOT NULL default '0',
1014 `phr_ip` varchar(30) NOT NULL default '',
1015 `user` varchar(45) default NULL,
1016 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1017 `actual` text NOT NULL,
1018 KEY `phr_ip` (`phr_ip`)
1019 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1022 -- Table structure for table `printers`
1025 DROP TABLE IF EXISTS `printers`;
1026 CREATE TABLE `printers` (
1027 `printername` char(40) NOT NULL default '''''',
1028 `printqueue` char(20) default NULL,
1029 `printtype` char(20) default NULL,
1030 PRIMARY KEY (`printername`)
1031 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1034 -- Table structure for table `repeatable_holidays`
1037 DROP TABLE IF EXISTS `repeatable_holidays`;
1038 CREATE TABLE `repeatable_holidays` (
1039 `id` int(11) NOT NULL auto_increment,
1040 `branchcode` varchar(4) NOT NULL default '',
1041 `weekday` smallint(6) default NULL,
1042 `day` smallint(6) default NULL,
1043 `month` smallint(6) default NULL,
1044 `title` varchar(50) NOT NULL default '',
1045 `description` text NOT NULL,
1047 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1050 -- Table structure for table `reserveconstraints`
1053 DROP TABLE IF EXISTS `reserveconstraints`;
1054 CREATE TABLE `reserveconstraints` (
1055 `borrowernumber` int(11) NOT NULL default '0',
1056 `reservedate` date NOT NULL default '0000-00-00',
1057 `biblionumber` int(11) NOT NULL default '0',
1058 `biblioitemnumber` int(11) default NULL,
1059 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1060 KEY `borrowernumber` (`borrowernumber`)
1061 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1064 -- Table structure for table `reserveissue`
1067 DROP TABLE IF EXISTS `reserveissue`;
1068 CREATE TABLE `reserveissue` (
1069 `resid` int(10) unsigned NOT NULL auto_increment,
1070 `borrowernumber` int(10) unsigned NOT NULL default '0',
1071 `itemnumber` int(10) unsigned NOT NULL default '0',
1072 `restime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1073 `rettime` datetime default NULL,
1074 `duetime` datetime NOT NULL default '0000-00-00 00:00:00',
1075 PRIMARY KEY (`resid`)
1076 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1079 -- Table structure for table `reserves`
1082 DROP TABLE IF EXISTS `reserves`;
1083 CREATE TABLE `reserves` (
1084 `borrowernumber` int(11) NOT NULL default '0',
1085 `reservedate` date NOT NULL default '0000-00-00',
1086 `biblionumber` int(11) NOT NULL default '0',
1087 `constrainttype` char(1) default NULL,
1088 `branchcode` varchar(4) default NULL,
1089 `notificationdate` date default NULL,
1090 `reminderdate` date default NULL,
1091 `cancellationdate` date default NULL,
1092 `reservenotes` text,
1093 `priority` smallint(6) default NULL,
1094 `found` char(1) default NULL,
1095 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1096 `itemnumber` int(11) default NULL,
1097 `reservefrom` date NOT NULL default '0000-00-00',
1098 `reserveto` date NOT NULL default '0000-00-00',
1099 `registeredby` varchar(45) NOT NULL default '',
1100 `reserveid` int(10) unsigned NOT NULL auto_increment,
1101 PRIMARY KEY (`reserveid`),
1102 KEY `borrowernumber` (`borrowernumber`)
1103 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1106 -- Table structure for table `reviews`
1109 DROP TABLE IF EXISTS `reviews`;
1110 CREATE TABLE `reviews` (
1111 `reviewid` int(11) NOT NULL auto_increment,
1112 `borrowernumber` int(11) default NULL,
1113 `biblionumber` int(11) default NULL,
1115 `approved` tinyint(4) default NULL,
1116 `datereviewed` datetime default NULL,
1117 PRIMARY KEY (`reviewid`)
1118 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1121 -- Table structure for table `roadtype`
1124 DROP TABLE IF EXISTS `roadtype`;
1125 CREATE TABLE `roadtype` (
1126 `roadtypeid` int(11) NOT NULL auto_increment,
1127 `road_type` char(100) NOT NULL default '',
1128 PRIMARY KEY (`roadtypeid`)
1129 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1132 -- Table structure for table `serial`
1135 DROP TABLE IF EXISTS `serial`;
1136 CREATE TABLE `serial` (
1137 `serialid` int(11) NOT NULL auto_increment,
1138 `biblionumber` varchar(100) NOT NULL default '',
1139 `subscriptionid` varchar(100) NOT NULL default '',
1140 `serialseq` varchar(100) NOT NULL default '',
1141 `status` tinyint(4) NOT NULL default '0',
1142 `planneddate` date NOT NULL default '0000-00-00',
1143 `notes` text NOT NULL,
1144 `publisheddate` date NOT NULL default '0000-00-00',
1145 `routingnotes` text NOT NULL,
1146 `itemnumber` int(10) unsigned NOT NULL default '0',
1147 PRIMARY KEY (`serialid`)
1148 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1151 -- Table structure for table `sessions`
1154 DROP TABLE IF EXISTS `sessions`;
1155 CREATE TABLE `sessions` (
1156 `sessionID` varchar(255) NOT NULL default '',
1157 `userid` varchar(255) default NULL,
1158 `ip` varchar(16) default NULL,
1159 `lasttime` int(11) default NULL,
1160 PRIMARY KEY (`sessionID`)
1161 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1164 -- Table structure for table `shelf_requests`
1167 DROP TABLE IF EXISTS `shelf_requests`;
1168 CREATE TABLE `shelf_requests` (
1169 `idrequest` int(11) NOT NULL auto_increment,
1170 `shelfnumber` int(11) NOT NULL default '0',
1171 `request_name` varchar(50) NOT NULL default '',
1172 `request_type` varchar(50) NOT NULL default '',
1173 `status` varchar(50) NOT NULL default '',
1174 `request_date` date NOT NULL default '0000-00-00',
1175 `coments` varchar(250) NOT NULL default '',
1176 PRIMARY KEY (`idrequest`)
1177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1180 -- Table structure for table `shelfcontents`
1183 DROP TABLE IF EXISTS `shelfcontents`;
1184 CREATE TABLE `shelfcontents` (
1185 `shelfnumber` int(11) NOT NULL default '0',
1186 `itemnumber` int(11) NOT NULL default '0',
1187 `flags` int(11) default NULL,
1188 `biblionumber` varchar(20) NOT NULL default '',
1189 KEY `shelfnumber` (`shelfnumber`)
1190 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1193 -- Table structure for table `special_holidays`
1196 DROP TABLE IF EXISTS `special_holidays`;
1197 CREATE TABLE `special_holidays` (
1198 `id` int(11) NOT NULL auto_increment,
1199 `branchcode` varchar(4) NOT NULL default '',
1200 `day` smallint(6) NOT NULL default '0',
1201 `month` smallint(6) NOT NULL default '0',
1202 `year` smallint(6) NOT NULL default '0',
1203 `isexception` smallint(1) NOT NULL default '1',
1204 `title` varchar(50) NOT NULL default '',
1205 `description` text NOT NULL,
1207 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1210 -- Table structure for table `statistics`
1213 DROP TABLE IF EXISTS `statistics`;
1214 CREATE TABLE `statistics` (
1215 `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
1216 `branch` varchar(4) default NULL,
1217 `proccode` varchar(4) default NULL,
1218 `value` double(16,4) default NULL,
1219 `type` varchar(16) default NULL,
1221 `usercode` varchar(10) default NULL,
1222 `itemnumber` int(11) default NULL,
1223 `itemtype` varchar(4) default NULL,
1224 `borrowernumber` int(11) default NULL,
1225 KEY `timeidx` (`datetime`),
1226 KEY `itemnumber` (`itemnumber`)
1227 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1230 -- Table structure for table `subcategorytable`
1233 DROP TABLE IF EXISTS `subcategorytable`;
1234 CREATE TABLE `subcategorytable` (
1235 `subcategorycode` varchar(5) NOT NULL default '',
1237 `itemtypecodes` text,
1238 PRIMARY KEY (`subcategorycode`)
1239 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1242 -- Table structure for table `subscription`
1245 DROP TABLE IF EXISTS `subscription`;
1246 CREATE TABLE `subscription` (
1247 `biblionumber` int(11) NOT NULL default '0',
1248 `subscriptionid` int(11) NOT NULL auto_increment,
1249 `librarian` varchar(100) default '',
1250 `startdate` date default '0000-00-00',
1251 `aqbooksellerid` int(11) default '0',
1252 `cost` int(11) default '0',
1253 `aqbudgetid` int(11) default '0',
1254 `weeklength` tinyint(4) default '0',
1255 `monthlength` tinyint(4) default '0',
1256 `numberlength` tinyint(4) default '0',
1257 `periodicity` tinyint(4) default '0',
1258 `dow` varchar(100) default '',
1259 `numberingmethod` varchar(100) default '',
1261 `status` varchar(100) NOT NULL default '',
1262 `add1` int(11) default '0',
1263 `every1` int(11) default '0',
1264 `whenmorethan1` int(11) default '0',
1265 `setto1` int(11) default NULL,
1266 `lastvalue1` int(11) default NULL,
1267 `add2` int(11) default '0',
1268 `every2` int(11) default '0',
1269 `whenmorethan2` int(11) default '0',
1270 `setto2` int(11) default NULL,
1271 `lastvalue2` int(11) default NULL,
1272 `add3` int(11) default '0',
1273 `every3` int(11) default '0',
1274 `innerloop1` int(11) default '0',
1275 `innerloop2` int(11) default '0',
1276 `innerloop3` int(11) default '0',
1277 `whenmorethan3` int(11) default '0',
1278 `setto3` int(11) default NULL,
1279 `lastvalue3` int(11) default NULL,
1280 `irregularity` varchar(45) default NULL,
1281 `hemisphere` varchar(45) default NULL,
1282 `numberpattern` varchar(45) default NULL,
1283 `callnumber` varchar(245) default NULL,
1284 `distributedto` text,
1285 `letter` varchar(20) default NULL,
1286 `publisheddate` date default NULL,
1287 PRIMARY KEY (`subscriptionid`)
1288 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1291 -- Table structure for table `subscriptionhistory`
1294 DROP TABLE IF EXISTS `subscriptionhistory`;
1295 CREATE TABLE `subscriptionhistory` (
1296 `biblionumber` int(11) NOT NULL default '0',
1297 `subscriptionid` int(11) NOT NULL default '0',
1298 `histstartdate` date NOT NULL default '0000-00-00',
1299 `enddate` date default '0000-00-00',
1300 `missinglist` longtext NOT NULL,
1301 `receivedlist` longtext NOT NULL,
1302 `opacnote` varchar(150) NOT NULL default '',
1303 `librariannote` varchar(150) NOT NULL default '',
1304 `lastbranch` varchar(45) default NULL,
1305 PRIMARY KEY (`subscriptionid`),
1306 KEY `biblionumber` (`biblionumber`)
1307 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1310 -- Table structure for table `subscriptionroutinglist`
1313 DROP TABLE IF EXISTS `subscriptionroutinglist`;
1314 CREATE TABLE `subscriptionroutinglist` (
1315 `routingid` int(10) unsigned NOT NULL auto_increment,
1316 `subscriptionid` int(10) unsigned NOT NULL default '0',
1317 `borrowernumber` int(10) unsigned NOT NULL default '0',
1318 `ranking` int(10) unsigned NOT NULL default '0',
1319 PRIMARY KEY (`routingid`),
1320 KEY `subscriptionid` (`subscriptionid`)
1321 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1324 -- Table structure for table `suggestions`
1327 DROP TABLE IF EXISTS `suggestions`;
1328 CREATE TABLE `suggestions` (
1329 `suggestionid` int(8) NOT NULL auto_increment,
1330 `suggestedby` int(11) NOT NULL default '0',
1331 `managedby` int(11) default NULL,
1332 `STATUS` varchar(10) NOT NULL default '',
1334 `author` varchar(80) default NULL,
1335 `title` varchar(80) default NULL,
1336 `copyrightdate` smallint(6) default NULL,
1337 `publishercode` varchar(255) default NULL,
1338 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1339 `volumedesc` varchar(255) default NULL,
1340 `publicationyear` smallint(6) default '0',
1341 `place` varchar(255) default NULL,
1342 `isbn` varchar(10) default NULL,
1343 `mailoverseeing` smallint(1) default '0',
1344 `biblionumber` int(11) default NULL,
1345 `branchcode` varchar(45) default NULL,
1346 PRIMARY KEY (`suggestionid`),
1347 KEY `suggestedby` (`suggestedby`),
1348 KEY `managedby` (`managedby`)
1349 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1352 -- Table structure for table `systempreferences`
1355 DROP TABLE IF EXISTS `systempreferences`;
1356 CREATE TABLE `systempreferences` (
1357 `variable` varchar(50) NOT NULL default '',
1360 `explanation` varchar(80) default NULL,
1361 `type` varchar(20) default NULL,
1362 PRIMARY KEY (`variable`)
1363 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1366 -- Table structure for table `userflags`
1369 DROP TABLE IF EXISTS `userflags`;
1370 CREATE TABLE `userflags` (
1371 `bit` int(11) NOT NULL default '0',
1372 `flag` char(30) default NULL,
1373 `flagdesc` char(255) default NULL,
1374 `defaulton` int(11) default NULL,
1376 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1379 -- Table structure for table `users`
1382 DROP TABLE IF EXISTS `users`;
1383 CREATE TABLE `users` (
1384 `usercode` varchar(10) default NULL,
1387 `level` smallint(6) default NULL,
1388 UNIQUE KEY `usercode` (`usercode`)
1389 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1392 -- Table structure for table `z3950servers`
1395 DROP TABLE IF EXISTS `z3950servers`;
1396 CREATE TABLE `z3950servers` (
1397 `host` varchar(255) default NULL,
1398 `port` int(11) default NULL,
1399 `db` varchar(255) default NULL,
1400 `userid` varchar(255) default NULL,
1401 `password` varchar(255) default NULL,
1403 `id` int(11) NOT NULL auto_increment,
1404 `checked` smallint(6) default NULL,
1405 `rank` int(11) default NULL,
1406 `syntax` varchar(80) default NULL,
1408 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1411 -- Table structure for table `zebraqueue`
1414 DROP TABLE IF EXISTS `zebraqueue`;
1415 CREATE TABLE `zebraqueue` (
1416 `id` int(10) unsigned NOT NULL auto_increment,
1417 `biblio_auth_number` varchar(20) NOT NULL default '',
1418 `server` varchar(45) NOT NULL default '',
1419 `operation` varchar(45) NOT NULL default '',
1421 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1423 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1424 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1425 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1426 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1427 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1428 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1429 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;