`accountno` smallint(6) NOT NULL default 0,
`offsetaccount` smallint(6) NOT NULL default 0,
`offsetamount` decimal(28,6) default NULL,
- `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
+ `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`contactnote` varchar(255) default NULL,
`sort1` varchar(80) default NULL,
`sort2` varchar(80) default NULL,
+ `altcontactfirstname` varchar(255) default NULL,
+ `altcontactsurname` varchar(255) default NULL,
+ `altcontactaddress1` varchar(255) default NULL,
+ `altcontactaddress2` varchar(255) default NULL,
+ `altcontactaddress3` varchar(255) default NULL,
+ `altcontactzipcode` varchar(50) default NULL,
+ `altcontactphone` varchar(50) default NULL,
UNIQUE KEY `cardnumber` (`cardnumber`),
PRIMARY KEY `borrowernumber` (`borrowernumber`),
KEY `categorycode` (`categorycode`),
DROP TABLE IF EXISTS `currency`;
CREATE TABLE `currency` (
`currency` varchar(10) NOT NULL default '',
+ `symbol` varchar(5) default NULL,
+ `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`rate` float(7,5) default NULL,
PRIMARY KEY (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`contactnote` varchar(255) default NULL,
`sort1` varchar(80) default NULL,
`sort2` varchar(80) default NULL,
+ `altcontactfirstname` varchar(255) default NULL,
+ `altcontactsurname` varchar(255) default NULL,
+ `altcontactaddress1` varchar(255) default NULL,
+ `altcontactaddress2` varchar(255) default NULL,
+ `altcontactaddress3` varchar(255) default NULL,
+ `altcontactzipcode` varchar(50) default NULL,
+ `altcontactphone` varchar(50) default NULL,
KEY `borrowernumber` (`borrowernumber`),
KEY `cardnumber` (`cardnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`biblioitemnumber` int(11) NOT NULL default 0,
`barcode` varchar(20) default NULL,
`dateaccessioned` date default NULL,
- `booksellerid` varchar(10) default NULL,
+ `booksellerid` mediumtext default NULL,
`homebranch` varchar(10) default NULL,
`price` decimal(8,2) default NULL,
`replacementprice` decimal(8,2) default NULL,
`datelastborrowed` date default NULL,
`datelastseen` date default NULL,
`stack` tinyint(1) default NULL,
- `notforloan` tinyint(1) default NULL,
- `damaged` tinyint(1) default NULL,
- `itemlost` tinyint(1) default NULL,
- `wthdrawn` tinyint(1) default NULL,
+ `notforloan` tinyint(1) NOT NULL default 0,
+ `damaged` tinyint(1) NOT NULL default 0,
+ `itemlost` tinyint(1) NOT NULL default 0,
+ `wthdrawn` tinyint(1) NOT NULL default 0,
`itemcallnumber` varchar(30) default NULL,
`issues` smallint(6) default NULL,
`renewals` smallint(6) default NULL,
`materials` varchar(10) default NULL,
`uri` varchar(255) default NULL,
`itype` varchar(10) default NULL,
+ `more_subfields_xml` longtext default NULL,
+ `enumchron` varchar(80) default NULL,
+ `copynumber` smallint(6) default NULL,
`marc` longblob,
PRIMARY KEY (`itemnumber`),
KEY `delitembarcodeidx` (`barcode`),
DROP TABLE IF EXISTS `import_batches`;
CREATE TABLE `import_batches` (
`import_batch_id` int(11) NOT NULL auto_increment,
+ `matcher_id` int(11) default NULL,
`template_id` int(11) default NULL,
`branchcode` varchar(10) default NULL,
`num_biblios` int(11) NOT NULL default 0,
`biblioitemnumber` int(11) NOT NULL default 0,
`barcode` varchar(20) default NULL,
`dateaccessioned` date default NULL,
- `booksellerid` varchar(10) default NULL,
+ `booksellerid` mediumtext default NULL,
`homebranch` varchar(10) default NULL,
`price` decimal(8,2) default NULL,
`replacementprice` decimal(8,2) default NULL,
`datelastborrowed` date default NULL,
`datelastseen` date default NULL,
`stack` tinyint(1) default NULL,
- `notforloan` tinyint(1) default NULL,
- `damaged` tinyint(1) default NULL,
- `itemlost` tinyint(1) default NULL,
- `wthdrawn` tinyint(1) default NULL,
+ `notforloan` tinyint(1) NOT NULL default 0,
+ `damaged` tinyint(1) NOT NULL default 0,
+ `itemlost` tinyint(1) NOT NULL default 0,
+ `wthdrawn` tinyint(1) NOT NULL default 0,
`itemcallnumber` varchar(30) default NULL,
`issues` smallint(6) default NULL,
`renewals` smallint(6) default NULL,
`materials` varchar(10) default NULL,
`uri` varchar(255) default NULL,
`itype` varchar(10) default NULL,
+ `more_subfields_xml` longtext default NULL,
+ `enumchron` varchar(80) default NULL,
+ `copynumber` smallint(6) default NULL,
PRIMARY KEY (`itemnumber`),
UNIQUE KEY `itembarcodeidx` (`barcode`),
KEY `itembinoidx` (`biblioitemnumber`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
+-- Table structure for table `labels_profile`
+--
+
+DROP TABLE IF EXISTS `labels_profile`;
+CREATE TABLE `labels_profile` (
+ `tmpl_id` int(4) NOT NULL,
+ `prof_id` int(4) NOT NULL,
+ UNIQUE KEY `tmpl_id` (`tmpl_id`),
+ UNIQUE KEY `prof_id` (`prof_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `labels_templates`
--
`active` int(1) default NULL,
`units` char(20) default 'PX',
`fontsize` int(4) NOT NULL default '3',
+ `font` char(10) NOT NULL default 'TR',
PRIMARY KEY (`tmpl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `marc_matchers`;
CREATE TABLE `marc_matchers` (
`matcher_id` int(11) NOT NULL auto_increment,
+ `code` varchar(10) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`record_type` varchar(10) NOT NULL default 'biblio',
`threshold` int(11) NOT NULL default 0,
- PRIMARY KEY (`matcher_id`)
+ PRIMARY KEY (`matcher_id`),
+ KEY `code` (`code`),
+ KEY `record_type` (`record_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`score` int(11) NOT NULL default 0,
PRIMARY KEY (`matchpoint_id`),
CONSTRAINT `matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
+ REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
offset int(4) NOT NULL default 0,
length int(4) NOT NULL default 0,
PRIMARY KEY (`matchpoint_component_id`),
+ KEY `by_sequence` (`matchpoint_id`, `sequence`),
CONSTRAINT `matchpoint_components_ifbk_1` FOREIGN KEY (`matchpoint_id`)
- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
+ REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`norm_routine` varchar(50) NOT NULL default '',
KEY `matchpoint_component_norms` (`matchpoint_component_id`, `sequence`),
CONSTRAINT `matchpoint_component_norms_ifbk_1` FOREIGN KEY (`matchpoint_component_id`)
- REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
+ REFERENCES `matchpoint_components` (`matchpoint_component_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`matcher_id` int(11) NOT NULL,
`matchpoint_id` int(11) NOT NULL,
CONSTRAINT `matcher_matchpoints_ifbk_1` FOREIGN KEY (`matcher_id`)
- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `matcher_matchpoints_ifbk_2` FOREIGN KEY (`matchpoint_id`)
- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
+ REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`target_matchpoint_id` int(11) NOT NULL,
PRIMARY KEY (`matchcheck_id`),
CONSTRAINT `matcher_matchchecks_ifbk_1` FOREIGN KEY (`matcher_id`)
- REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ REFERENCES `marc_matchers` (`matcher_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `matcher_matchchecks_ifbk_2` FOREIGN KEY (`source_matchpoint_id`)
- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `matcher_matchchecks_ifbk_3` FOREIGN KEY (`target_matchpoint_id`)
- REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
+ REFERENCES `matchpoints` (`matchpoint_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--
-- Table structure for table `nozebra`
--
+
DROP TABLE IF EXISTS `nozebra`;
CREATE TABLE `nozebra` (
`server` varchar(20) NOT NULL,
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
+-- Table structure for table `old_issues`
+--
+
+DROP TABLE IF EXISTS `old_issues`;
+CREATE TABLE `old_issues` (
+ `borrowernumber` int(11) default NULL,
+ `itemnumber` int(11) default NULL,
+ `date_due` date default NULL,
+ `branchcode` varchar(10) default NULL,
+ `issuingbranch` varchar(18) default NULL,
+ `returndate` date default NULL,
+ `lastreneweddate` date default NULL,
+ `return` varchar(4) default NULL,
+ `renewals` tinyint(4) default NULL,
+ `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ `issuedate` date default NULL,
+ KEY `old_issuesborridx` (`borrowernumber`),
+ KEY `old_issuesitemidx` (`itemnumber`),
+ KEY `old_bordate` (`borrowernumber`,`timestamp`),
+ CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
+ ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
+ ON DELETE SET NULL ON UPDATE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `old_reserves`
+--
+DROP TABLE IF EXISTS `old_reserves`;
+CREATE TABLE `old_reserves` (
+ `borrowernumber` int(11) default NULL,
+ `reservedate` date default NULL,
+ `biblionumber` int(11) default NULL,
+ `constrainttype` varchar(1) default NULL,
+ `branchcode` varchar(10) default NULL,
+ `notificationdate` date default NULL,
+ `reminderdate` date default NULL,
+ `cancellationdate` date default NULL,
+ `reservenotes` mediumtext,
+ `priority` smallint(6) default NULL,
+ `found` varchar(1) default NULL,
+ `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+ `itemnumber` int(11) default NULL,
+ `waitingdate` date default NULL,
+ KEY `old_reserves_borrowernumber` (`borrowernumber`),
+ KEY `old_reserves_biblionumber` (`biblionumber`),
+ KEY `old_reserves_itemnumber` (`itemnumber`),
+ KEY `old_reserves_branchcode` (`branchcode`),
+ CONSTRAINT `old_reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
+ ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `old_reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`)
+ ON DELETE SET NULL ON UPDATE SET NULL,
+ CONSTRAINT `old_reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`)
+ ON DELETE SET NULL ON UPDATE SET NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `opac_news`
--
`idnew` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`new` text NOT NULL,
- `lang` varchar(4) NOT NULL default '',
+ `lang` varchar(25) NOT NULL default '',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`expirationdate` date default NULL,
`number` int(11) default NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
+-- Table structure for table `patronimage`
+--
+
+DROP TABLE IF EXISTS `patronimage`;
+CREATE TABLE `patronimage` (
+ `cardnumber` varchar(16) NOT NULL,
+ `mimetype` varchar(15) NOT NULL,
+ `imagefile` mediumblob NOT NULL,
+ PRIMARY KEY (`cardnumber`),
+ CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `printers`
--
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
+-- Table structure for table `printers_profile`
+--
+
+DROP TABLE IF EXISTS `printers_profile`;
+CREATE TABLE `printers_profile` (
+ `prof_id` int(4) NOT NULL auto_increment,
+ `printername` varchar(40) NOT NULL,
+ `tmpl_id` int(4) NOT NULL,
+ `paper_bin` varchar(20) NOT NULL,
+ `offset_horz` float default NULL,
+ `offset_vert` float default NULL,
+ `creep_horz` float default NULL,
+ `creep_vert` float default NULL,
+ `unit` char(20) NOT NULL default 'POINT',
+ PRIMARY KEY (`prof_id`),
+ UNIQUE KEY `printername` (`printername`,`tmpl_id`,`paper_bin`),
+ CONSTRAINT `printers_profile_pnfk_1` FOREIGN KEY (`tmpl_id`) REFERENCES `labels_templates` (`tmpl_id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
-- Table structure for table `repeatable_holidays`
--
`planneddate` date default NULL,
`notes` text,
`publisheddate` date default NULL,
- `itemnumber` text,
+ `itemnumber` text default NULL,
`claimdate` date default NULL,
`routingnotes` text,
PRIMARY KEY (`serialid`)
--
DROP TABLE IF EXISTS `stopwords`;
-CREATE TABLE `stopwords` (
+ CREATE TABLE `stopwords` (
`word` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`aqbooksellerid` int(11) default 0,
`cost` int(11) default 0,
`aqbudgetid` int(11) default 0,
- `weeklength` tinyint(4) default 0,
- `monthlength` tinyint(4) default 0,
- `numberlength` tinyint(4) default 0,
+ `weeklength` int(11) default 0,
+ `monthlength` int(11) default 0,
+ `numberlength` int(11) default 0,
`periodicity` tinyint(4) default 0,
`dow` varchar(100) default '',
`numberingmethod` varchar(100) default '',
`shelfname` varchar(255) default NULL,
`owner` varchar(80) default NULL,
`category` varchar(1) default NULL,
+ `sortfield` varchar(16) default NULL,
PRIMARY KEY (`shelfnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`icon` text,
`position` enum('primary','secondary','') NOT NULL default 'primary',
`type` enum('zed','opensearch') NOT NULL default 'zed',
+ `encoding` text default NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`server` char(20) NOT NULL default '',
`done` int(11) NOT NULL default '0',
`time` timestamp NOT NULL default CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ KEY `zebraqueue_lookup` (`server`, `biblio_auth_number`, `operation`, `done`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS `services_throttle`;
+CREATE TABLE `services_throttle` (
+ `service_type` varchar(10) NOT NULL default '',
+ `service_count` varchar(45) default NULL,
+ PRIMARY KEY (`service_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- http://www.w3.org/International/articles/language-tags/
+
+-- RFC4646
+DROP TABLE IF EXISTS language_subtag_registry;
+CREATE TABLE language_subtag_registry (
+ subtag varchar(25),
+ type varchar(25), -- language-script-region-variant-extension-privateuse
+ description varchar(25), -- only one of the possible descriptions for ease of reference, see language_descriptions for the complete list
+ added date,
+ KEY `subtag` (`subtag`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- TODO: add suppress_scripts
+-- this maps three letter codes defined in iso639.2 back to their
+-- two letter equivilents in rfc4646 (LOC maintains iso639+)
+DROP TABLE IF EXISTS language_rfc4646_to_iso639;
+CREATE TABLE language_rfc4646_to_iso639 (
+ rfc4646_subtag varchar(25),
+ iso639_2_code varchar(25),
+ KEY `rfc4646_subtag` (`rfc4646_subtag`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS language_descriptions;
+CREATE TABLE language_descriptions (
+ subtag varchar(25),
+ type varchar(25),
+ lang varchar(25),
+ description varchar(255),
+ KEY `lang` (`lang`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- bi-directional support, keyed by script subcode
+DROP TABLE IF EXISTS language_script_bidi;
+CREATE TABLE language_script_bidi (
+ rfc4646_subtag varchar(25), -- script subtag, Arab, Hebr, etc.
+ bidi varchar(3), -- rtl ltr
+ KEY `rfc4646_subtag` (`rfc4646_subtag`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- TODO: need to map language subtags to script subtags for detection
+-- of bidi when script is not specified (like ar, he)
+DROP TABLE IF EXISTS language_script_mapping;
+CREATE TABLE language_script_mapping (
+ language_subtag varchar(25),
+ script_subtag varchar(25),
+ KEY `language_subtag` (`language_subtag`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+DROP TABLE IF EXISTS serialitems;
+CREATE TABLE serialitems (
+ serialid int(11) NOT NULL,
+ itemnumber int(11) NOT NULL,
+ UNIQUE KEY `serialididx` (`serialid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
projects / koha_fer / blobdiff