Lines 2285-2291
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)
Link Here
|
2285 |
`shelfname` varchar(255) default NULL, -- name of the list |
2285 |
`shelfname` varchar(255) default NULL, -- name of the list |
2286 |
`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) |
2286 |
`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) |
2287 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
2287 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
2288 |
`sortfield` varchar(16) default NULL, -- the field this list is sorted on |
2288 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
2289 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2289 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2290 |
`created_on` TIMESTAMP NOT NULL, -- creation time |
2290 |
`created_on` TIMESTAMP NOT NULL, -- creation time |
2291 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
2291 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
2292 |
- |
|
|