`address` mediumtext NOT NULL,
`address2` text,
`city` mediumtext NOT NULL,
+ `state` text default NULL,
`zipcode` varchar(25) default NULL,
`country` text,
`email` mediumtext,
`B_address` varchar(100) default NULL,
`B_address2` text default NULL,
`B_city` mediumtext,
+ `B_state` text default NULL,
`B_zipcode` varchar(25) default NULL,
`B_country` text,
`B_email` text,
`altcontactaddress1` varchar(255) default NULL,
`altcontactaddress2` varchar(255) default NULL,
`altcontactaddress3` varchar(255) default NULL,
+ `altcontactstate` text default NULL,
`altcontactzipcode` varchar(50) default NULL,
`altcontactcountry` text default NULL,
`altcontactphone` varchar(50) default NULL,
`branchaddress3` mediumtext,
`branchzip` varchar(25) default NULL,
`branchcity` mediumtext,
+ `branchstate` mediumtext,
`branchcountry` text,
`branchphone` mediumtext,
`branchfax` mediumtext,
`overduenoticerequired` tinyint(1) default NULL,
`issuelimit` smallint(6) default NULL,
`reservefee` decimal(28,6) default NULL,
+ `hidelostitems` tinyint(1) NOT NULL default '0',
`category_type` varchar(1) NOT NULL default 'A',
PRIMARY KEY (`categorycode`),
UNIQUE KEY `categorycode` (`categorycode`)
--
-- Table: collections
--
+DROP TABLE IF EXISTS collections;
CREATE TABLE collections (
colId integer(11) NOT NULL auto_increment,
colTitle varchar(100) NOT NULL DEFAULT '',
--
-- Table: collections_tracking
--
+DROP TABLE IF EXISTS collections_tracking;
CREATE TABLE collections_tracking (
ctId integer(11) NOT NULL auto_increment,
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
CREATE TABLE `cities` (
`cityid` int(11) NOT NULL auto_increment,
`city_name` varchar(100) NOT NULL default '',
+ `city_state` VARCHAR( 100 ) NULL DEFAULT NULL,
+ `city_country` VARCHAR( 100 ) NULL DEFAULT NULL,
`city_zipcode` varchar(20) default NULL,
PRIMARY KEY (`cityid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`address` mediumtext NOT NULL,
`address2` text,
`city` mediumtext NOT NULL,
+ `state` text default NULL,
`zipcode` varchar(25) default NULL,
`country` text,
`email` mediumtext,
`B_address` varchar(100) default NULL,
`B_address2` text default NULL,
`B_city` mediumtext,
+ `B_state` text default NULL,
`B_zipcode` varchar(25) default NULL,
`B_country` text,
`B_email` text,
`altcontactaddress1` varchar(255) default NULL,
`altcontactaddress2` varchar(255) default NULL,
`altcontactaddress3` varchar(255) default NULL,
+ `altcontactstate` text default NULL,
`altcontactzipcode` varchar(50) default NULL,
`altcontactcountry` text default NULL,
`altcontactphone` varchar(50) default NULL,
DROP TABLE IF EXISTS `issues`;
CREATE TABLE `issues` (
- `borrowernumber` int(11) default NULL,
- `itemnumber` int(11) default NULL,
+ `borrowernumber` int(11),
+ `itemnumber` int(11),
`date_due` date default NULL,
`branchcode` varchar(10) default NULL,
`issuingbranch` varchar(18) default NULL,
`renewals` tinyint(4) default NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`issuedate` date default NULL,
+ PRIMARY KEY (`itemnumber`),
KEY `issuesborridx` (`borrowernumber`),
- KEY `issuesitemidx` (`itemnumber`),
KEY `bordate` (`borrowernumber`,`timestamp`),
- CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
- CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
+ CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,
+ CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
`chargename` varchar(100) default NULL,
`maxissueqty` int(4) default NULL,
`issuelength` int(4) default NULL,
+ `hardduedate` date default NULL,
+ `hardduedatecompare` tinyint NOT NULL default "0",
`renewalsallowed` smallint(6) NOT NULL default "0",
`reservesallowed` smallint(6) NOT NULL default "0",
`branchcode` varchar(10) NOT NULL default '',
`stocknumber` varchar(32) default NULL,
PRIMARY KEY (`itemnumber`),
UNIQUE KEY `itembarcodeidx` (`barcode`),
- UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
+ KEY `itemstocknumberidx` (`stocknumber`),
KEY `itembinoidx` (`biblioitemnumber`),
KEY `itembibnoidx` (`biblionumber`),
KEY `homebranch` (`homebranch`),
CREATE TABLE `overduerules` (
`branchcode` varchar(10) NOT NULL default '',
`categorycode` varchar(10) NOT NULL default '',
- `delay1` int(4) default 0,
+ `delay1` int(4) default NULL,
`letter1` varchar(20) default NULL,
`debarred1` varchar(1) default 0,
- `delay2` int(4) default 0,
+ `delay2` int(4) default NULL,
`debarred2` varchar(1) default 0,
`letter2` varchar(20) default NULL,
- `delay3` int(4) default 0,
+ `delay3` int(4) default NULL,
`letter3` varchar(20) default NULL,
`debarred3` int(1) default 0,
PRIMARY KEY (`branchcode`,`categorycode`)
`waitingdate` date default NULL,
`expirationdate` DATE DEFAULT NULL,
`lowestPriority` tinyint(1) NOT NULL,
+ KEY priorityfoundidx (priority,found),
KEY `borrowernumber` (`borrowernumber`),
KEY `biblionumber` (`biblionumber`),
KEY `itemnumber` (`itemnumber`),
UNIQUE KEY `serialitemsidx` (`itemnumber`),
KEY `serialitems_sfk_1` (`serialid`),
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT serialitems_sfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE
+ CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `user_permissions`;
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`notify_id` int(11) NOT NULL default 0,
`notify_level` int(2) NOT NULL default 0,
+ `note` text NULL default NULL,
+ `manager_id` int(11) NULL,
KEY `acctsborridx` (`borrowernumber`),
KEY `timeidx` (`timestamp`),
KEY `itemnumber` (`itemnumber`),
`closed` tinyint(1) default NULL,
`booksellerid` int(11) NOT NULL,
`deliveryplace` varchar(10) default NULL,
+ `freedeliveryplace` text default NULL,
`deliverycomment` varchar(255) default NULL,
`billingplace` varchar(10) default NULL,
PRIMARY KEY (`id`),