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