Lines 482-488
CREATE TABLE collections (
Link Here
|
482 |
colDesc text NOT NULL, |
482 |
colDesc text NOT NULL, |
483 |
colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.', |
483 |
colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.', |
484 |
PRIMARY KEY (colId) |
484 |
PRIMARY KEY (colId) |
485 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
485 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
486 |
|
486 |
|
487 |
-- |
487 |
-- |
488 |
-- Table: collections_tracking |
488 |
-- Table: collections_tracking |
Lines 493-499
CREATE TABLE collections_tracking (
Link Here
|
493 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
493 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
494 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
494 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
495 |
PRIMARY KEY (collections_tracking_id) |
495 |
PRIMARY KEY (collections_tracking_id) |
496 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
496 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
497 |
|
497 |
|
498 |
-- |
498 |
-- |
499 |
-- Table structure for table `courses` |
499 |
-- Table structure for table `courses` |
Lines 957-963
CREATE TABLE `export_format` (
Link Here
|
957 |
`encoding` varchar(255) NOT NULL, |
957 |
`encoding` varchar(255) NOT NULL, |
958 |
`type` varchar(255) DEFAULT 'marc', |
958 |
`type` varchar(255) DEFAULT 'marc', |
959 |
PRIMARY KEY (`export_format_id`) |
959 |
PRIMARY KEY (`export_format_id`) |
960 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export'; |
960 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export'; |
961 |
|
961 |
|
962 |
|
962 |
|
963 |
-- |
963 |
-- |
Lines 1917-1923
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
1917 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1917 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1918 |
KEY `userid` (`userid`), |
1918 |
KEY `userid` (`userid`), |
1919 |
KEY `sessionid` (`sessionid`) |
1919 |
KEY `sessionid` (`sessionid`) |
1920 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results'; |
1920 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results'; |
1921 |
|
1921 |
|
1922 |
|
1922 |
|
1923 |
-- |
1923 |
-- |
Lines 2982-2988
CREATE TABLE `aqcontract` (
Link Here
|
2982 |
PRIMARY KEY (`contractnumber`), |
2982 |
PRIMARY KEY (`contractnumber`), |
2983 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
2983 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
2984 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
2984 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
2985 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
2985 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
2986 |
|
2986 |
|
2987 |
-- |
2987 |
-- |
2988 |
-- Table structure for table `aqorders` |
2988 |
-- Table structure for table `aqorders` |
2989 |
- |
|
|