Lines 2313-2319
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)
Link Here
|
2313 |
`shelfname` varchar(255) default NULL, -- name of the list |
2313 |
`shelfname` varchar(255) default NULL, -- name of the list |
2314 |
`owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |
2314 |
`owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |
2315 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
2315 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
2316 |
`sortfield` varchar(16) default NULL, -- the field this list is sorted on |
2316 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
2317 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2317 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2318 |
`created_on` TIMESTAMP NOT NULL, -- creation time |
2318 |
`created_on` TIMESTAMP NOT NULL, -- creation time |
2319 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
2319 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
2320 |
- |
|
|