View | Details | Raw Unified | Return to bug 13534
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_13534.sql (+6 lines)
Line 0 Link Here
1
ALTER TABLE tags_all MODIFY COLUMN borrowernumber INT(11);
2
ALTER TABLE tags_all drop FOREIGN KEY tags_borrowers_fk_1;
3
ALTER TABLE tags_all ADD CONSTRAINT `tags_borrowers_fk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
4
5
ALTER TABLE tags_approval DROP FOREIGN KEY tags_approval_borrowers_fk_1;
6
ALTER TABLE tags_approval ADD CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
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
- 

Return to bug 13534