|
Lines 69-75
CREATE TABLE `auth_subfield_structure` (
Link Here
|
| 69 |
`linkid` tinyint(1) NOT NULL default 0, |
69 |
`linkid` tinyint(1) NOT NULL default 0, |
| 70 |
`kohafield` varchar(45) NULL default '', |
70 |
`kohafield` varchar(45) NULL default '', |
| 71 |
`frameworkcode` varchar(10) NOT NULL default '', |
71 |
`frameworkcode` varchar(10) NOT NULL default '', |
| 72 |
`defaultvalue` TEXT DEFAULT '', |
72 |
`defaultvalue` TEXT, |
| 73 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
73 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
| 74 |
KEY `tab` (`authtypecode`,`tab`), |
74 |
KEY `tab` (`authtypecode`,`tab`), |
| 75 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
75 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
|
Lines 2211-2217
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves)
Link Here
|
| 2211 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
2211 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
| 2212 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
2212 |
`sortfield` varchar(16) default 'title', -- the field this list is sorted on |
| 2213 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
2213 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
| 2214 |
`created_on` TIMESTAMP NOT NULL, -- creation time |
2214 |
`created_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- creation time |
| 2215 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
2215 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
| 2216 |
`allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself |
2216 |
`allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself |
| 2217 |
`allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added |
2217 |
`allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added |
| 2218 |
- |
|
|