|
Lines 502-508
CREATE TABLE collections (
Link Here
|
| 502 |
colDesc text NOT NULL, |
502 |
colDesc text NOT NULL, |
| 503 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
503 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
| 504 |
PRIMARY KEY (colId) |
504 |
PRIMARY KEY (colId) |
| 505 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
505 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 506 |
|
506 |
|
| 507 |
-- |
507 |
-- |
| 508 |
-- Constraints for table `collections` |
508 |
-- Constraints for table `collections` |
|
Lines 519-525
CREATE TABLE collections_tracking (
Link Here
|
| 519 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
519 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
| 520 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
520 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
| 521 |
PRIMARY KEY (collections_tracking_id) |
521 |
PRIMARY KEY (collections_tracking_id) |
| 522 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
522 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 523 |
|
523 |
|
| 524 |
-- |
524 |
-- |
| 525 |
-- Table structure for table `courses` |
525 |
-- Table structure for table `courses` |
|
Lines 983-989
CREATE TABLE `export_format` (
Link Here
|
| 983 |
`encoding` varchar(255) NOT NULL, |
983 |
`encoding` varchar(255) NOT NULL, |
| 984 |
`type` varchar(255) DEFAULT 'marc', |
984 |
`type` varchar(255) DEFAULT 'marc', |
| 985 |
PRIMARY KEY (`export_format_id`) |
985 |
PRIMARY KEY (`export_format_id`) |
| 986 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export'; |
986 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export'; |
| 987 |
|
987 |
|
| 988 |
|
988 |
|
| 989 |
-- |
989 |
-- |
|
Lines 1948-1954
CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history
Link Here
|
| 1948 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
1948 |
`time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run |
| 1949 |
KEY `userid` (`userid`), |
1949 |
KEY `userid` (`userid`), |
| 1950 |
KEY `sessionid` (`sessionid`) |
1950 |
KEY `sessionid` (`sessionid`) |
| 1951 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results'; |
1951 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results'; |
| 1952 |
|
1952 |
|
| 1953 |
|
1953 |
|
| 1954 |
-- |
1954 |
-- |
|
Lines 3031-3037
CREATE TABLE `aqcontract` (
Link Here
|
| 3031 |
PRIMARY KEY (`contractnumber`), |
3031 |
PRIMARY KEY (`contractnumber`), |
| 3032 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
3032 |
CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`) |
| 3033 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
3033 |
REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3034 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
3034 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; |
| 3035 |
|
3035 |
|
| 3036 |
-- |
3036 |
-- |
| 3037 |
-- Table structure for table `aqorders` |
3037 |
-- Table structure for table `aqorders` |
| 3038 |
- |
|
|