Lines 2269-2277
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)
Link Here
|
2269 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
2269 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
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_add` tinyint(1) default 0, -- permission for adding entries to list |
2272 |
`allow_change_from_owner` tinyint(1) default 1, -- can owner change contents? |
2273 |
`allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself |
2273 |
`allow_change_from_others` tinyint(1) default 0 -- can others change contents? |
2274 |
`allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added |
|
|
2275 |
PRIMARY KEY (`shelfnumber`), |
2274 |
PRIMARY KEY (`shelfnumber`), |
2276 |
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 |
2277 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2276 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2278 |
- |
|
|