Lines 2242-2248
CREATE TABLE `tags` (
Link Here
|
2242 |
DROP TABLE IF EXISTS `tags_all`; |
2242 |
DROP TABLE IF EXISTS `tags_all`; |
2243 |
CREATE TABLE `tags_all` ( -- all of the tags |
2243 |
CREATE TABLE `tags_all` ( -- all of the tags |
2244 |
`tag_id` int(11) NOT NULL auto_increment, -- unique id and primary key |
2244 |
`tag_id` int(11) NOT NULL auto_increment, -- unique id and primary key |
2245 |
`borrowernumber` int(11) NOT NULL, -- the patron who added the tag (borrowers.borrowernumber) |
2245 |
`borrowernumber` int(11) DEFAULT NULL, -- the patron who added the tag (borrowers.borrowernumber) |
2246 |
`biblionumber` int(11) NOT NULL, -- the bib record this tag was left on (biblio.biblionumber) |
2246 |
`biblionumber` int(11) NOT NULL, -- the bib record this tag was left on (biblio.biblionumber) |
2247 |
`term` varchar(255) NOT NULL, -- the tag |
2247 |
`term` varchar(255) NOT NULL, -- the tag |
2248 |
`language` int(4) default NULL, -- the language the tag was left in |
2248 |
`language` int(4) default NULL, -- the language the tag was left in |
Lines 2251-2257
CREATE TABLE `tags_all` ( -- all of the tags
Link Here
|
2251 |
KEY `tags_borrowers_fk_1` (`borrowernumber`), |
2251 |
KEY `tags_borrowers_fk_1` (`borrowernumber`), |
2252 |
KEY `tags_biblionumber_fk_1` (`biblionumber`), |
2252 |
KEY `tags_biblionumber_fk_1` (`biblionumber`), |
2253 |
CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`) |
2253 |
CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`) |
2254 |
REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2254 |
REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2255 |
CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`) |
2255 |
CONSTRAINT `tags_biblionumber_fk_1` FOREIGN KEY (`biblionumber`) |
2256 |
REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2256 |
REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2257 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2257 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
Lines 2270-2276
CREATE TABLE `tags_approval` ( -- approved tags
Link Here
|
2270 |
PRIMARY KEY (`term`), |
2270 |
PRIMARY KEY (`term`), |
2271 |
KEY `tags_approval_borrowers_fk_1` (`approved_by`), |
2271 |
KEY `tags_approval_borrowers_fk_1` (`approved_by`), |
2272 |
CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) |
2272 |
CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) |
2273 |
REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2273 |
REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
2274 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2274 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2275 |
|
2275 |
|
2276 |
-- |
2276 |
-- |
2277 |
- |
|
|