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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2270-2276 CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) Link Here
2270
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2270
  `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified
2271
  `created_on` datetime NOT NULL, -- creation time
2271
  `created_on` datetime NOT NULL, -- creation time
2272
  `allow_change_from_owner` tinyint(1) default 1, -- can owner change contents?
2272
  `allow_change_from_owner` tinyint(1) default 1, -- can owner change contents?
2273
  `allow_change_from_others` tinyint(1) default 0 -- can others change contents?
2273
  `allow_change_from_others` tinyint(1) default 0, -- can others change contents?
2274
  PRIMARY KEY  (`shelfnumber`),
2274
  PRIMARY KEY  (`shelfnumber`),
2275
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2275
  CONSTRAINT `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL -- no cascaded delete, please see HandleDelBorrower in Members.pm
2276
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2276
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2277
- 

Return to bug 18228