View | Details | Raw Unified | Return to bug 16664
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 16664