`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,
--
-- 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;
--
`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`),