Lines 2269-2275
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)
Link Here
|
2269 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2269 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2270 |
`created_on` datetime NOT NULL, -- creation time |
2270 |
`created_on` datetime NOT NULL, -- creation time |
2271 |
`allow_change_from_owner` tinyint(1) default 1, -- can owner change contents? |
2271 |
`allow_change_from_owner` tinyint(1) default 1, -- can owner change contents? |
2272 |
`allow_change_from_others` tinyint(1) default 0 -- can others change contents? |
2272 |
`allow_change_from_others` tinyint(1) default 0, -- can others change contents? |
2273 |
PRIMARY KEY (`shelfnumber`), |
2273 |
PRIMARY KEY (`shelfnumber`), |
2274 |
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 |
2274 |
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 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2275 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2276 |
- |
|
|