|
Viewing File sql/upgrade.fdsql of 0.00.0a
|
1: -- FreeDESK SQL Upgrade Script -- PurplePixie Systems/David Cutting 2: -- 3: -- SHOW TABLES 4: -- Table: customer 5: -- DESCRIBE `customer` 6: ALTER TABLE `%%$%%customer` CHANGE `customerid` `customerid` bigint(20) unsigned NOT NULL auto_increment; 7: ALTER TABLE `%%$%%customer` ADD `customerid` bigint(20) unsigned NOT NULL auto_increment; 8: ALTER TABLE `%%$%%customer` ADD PRIMARY KEY( `customerid` ); 9: ALTER TABLE `%%$%%customer` CHANGE `firstname` `firstname` varchar(254) NOT NULL; 10: ALTER TABLE `%%$%%customer` ADD `firstname` varchar(254) NOT NULL; 11: ALTER TABLE `%%$%%customer` CHANGE `lastname` `lastname` varchar(254) NOT NULL; 12: ALTER TABLE `%%$%%customer` ADD `lastname` varchar(254) NOT NULL; 13: ALTER TABLE `%%$%%customer` CHANGE `email` `email` varchar(254) NOT NULL; 14: ALTER TABLE `%%$%%customer` ADD `email` varchar(254) NOT NULL; 15: -- 16: -- Table: permgroup 17: -- DESCRIBE `permgroup` 18: ALTER TABLE `%%$%%permgroup` CHANGE `permgroupid` `permgroupid` bigint(20) unsigned NOT NULL auto_increment; 19: ALTER TABLE `%%$%%permgroup` ADD `permgroupid` bigint(20) unsigned NOT NULL auto_increment; 20: ALTER TABLE `%%$%%permgroup` ADD PRIMARY KEY( `permgroupid` ); 21: ALTER TABLE `%%$%%permgroup` CHANGE `groupname` `groupname` varchar(254) NOT NULL; 22: ALTER TABLE `%%$%%permgroup` ADD `groupname` varchar(254) NOT NULL; 23: -- 24: -- Table: permissions 25: -- DESCRIBE `permissions` 26: ALTER TABLE `%%$%%permissions` CHANGE `permissionid` `permissionid` bigint(20) NOT NULL auto_increment; 27: ALTER TABLE `%%$%%permissions` ADD `permissionid` bigint(20) NOT NULL auto_increment; 28: ALTER TABLE `%%$%%permissions` ADD PRIMARY KEY( `permissionid` ); 29: ALTER TABLE `%%$%%permissions` CHANGE `permissiontype` `permissiontype` varchar(16) NOT NULL; 30: ALTER TABLE `%%$%%permissions` ADD `permissiontype` varchar(16) NOT NULL; 31: CREATE INDEX `permissiontype` ON `permissions` ( `permissiontype` ); 32: ALTER TABLE `%%$%%permissions` CHANGE `permission` `permission` varchar(254) NOT NULL; 33: ALTER TABLE `%%$%%permissions` ADD `permission` varchar(254) NOT NULL; 34: ALTER TABLE `%%$%%permissions` CHANGE `usergroupid` `usergroupid` varchar(254) NOT NULL; 35: ALTER TABLE `%%$%%permissions` ADD `usergroupid` varchar(254) NOT NULL; 36: ALTER TABLE `%%$%%permissions` CHANGE `allowed` `allowed` tinyint(4) NOT NULL; 37: ALTER TABLE `%%$%%permissions` ADD `allowed` tinyint(4) NOT NULL; 38: -- 39: -- Table: plugins 40: -- DESCRIBE `plugins` 41: ALTER TABLE `%%$%%plugins` CHANGE `pluginid` `pluginid` bigint(20) NOT NULL auto_increment; 42: ALTER TABLE `%%$%%plugins` ADD `pluginid` bigint(20) NOT NULL auto_increment; 43: ALTER TABLE `%%$%%plugins` ADD PRIMARY KEY( `pluginid` ); 44: ALTER TABLE `%%$%%plugins` CHANGE `plugin` `plugin` varchar(254) NOT NULL; 45: ALTER TABLE `%%$%%plugins` ADD `plugin` varchar(254) NOT NULL; 46: ALTER TABLE `%%$%%plugins` CHANGE `active` `active` int(11) NOT NULL DEFAULT '0'; 47: ALTER TABLE `%%$%%plugins` ADD `active` int(11) NOT NULL DEFAULT '0'; 48: CREATE INDEX `active` ON `plugins` ( `active` ); 49: -- 50: -- Table: request 51: -- DESCRIBE `request` 52: ALTER TABLE `%%$%%request` CHANGE `requestid` `requestid` bigint(20) NOT NULL auto_increment; 53: ALTER TABLE `%%$%%request` ADD `requestid` bigint(20) NOT NULL auto_increment; 54: ALTER TABLE `%%$%%request` ADD PRIMARY KEY( `requestid` ); 55: ALTER TABLE `%%$%%request` CHANGE `customer` `customer` bigint(20) NOT NULL; 56: ALTER TABLE `%%$%%request` ADD `customer` bigint(20) NOT NULL; 57: CREATE INDEX `customer` ON `request` ( `customer` ); 58: ALTER TABLE `%%$%%request` CHANGE `assignteam` `assignteam` bigint(20) NOT NULL; 59: ALTER TABLE `%%$%%request` ADD `assignteam` bigint(20) NOT NULL; 60: ALTER TABLE `%%$%%request` CHANGE `assignuser` `assignuser` varchar(254) NOT NULL; 61: ALTER TABLE `%%$%%request` ADD `assignuser` varchar(254) NOT NULL; 62: ALTER TABLE `%%$%%request` CHANGE `class` `class` int(11) NOT NULL; 63: ALTER TABLE `%%$%%request` ADD `class` int(11) NOT NULL; 64: ALTER TABLE `%%$%%request` CHANGE `openeddt` `openeddt` datetime NOT NULL; 65: ALTER TABLE `%%$%%request` ADD `openeddt` datetime NOT NULL; 66: ALTER TABLE `%%$%%request` CHANGE `status` `status` int(11) NOT NULL; 67: ALTER TABLE `%%$%%request` ADD `status` int(11) NOT NULL; 68: -- 69: -- Table: requestclass 70: -- DESCRIBE `requestclass` 71: ALTER TABLE `%%$%%requestclass` CHANGE `classid` `classid` int(10) unsigned NOT NULL auto_increment; 72: ALTER TABLE `%%$%%requestclass` ADD `classid` int(10) unsigned NOT NULL auto_increment; 73: ALTER TABLE `%%$%%requestclass` ADD PRIMARY KEY( `classid` ); 74: ALTER TABLE `%%$%%requestclass` CHANGE `classname` `classname` varchar(254) NOT NULL; 75: ALTER TABLE `%%$%%requestclass` ADD `classname` varchar(254) NOT NULL; 76: ALTER TABLE `%%$%%requestclass` CHANGE `classclass` `classclass` varchar(254) NOT NULL; 77: ALTER TABLE `%%$%%requestclass` ADD `classclass` varchar(254) NOT NULL; 78: -- 79: -- Table: session 80: -- DESCRIBE `session` 81: ALTER TABLE `%%$%%session` CHANGE `session_id` `session_id` varchar(254) NOT NULL; 82: ALTER TABLE `%%$%%session` ADD `session_id` varchar(254) NOT NULL; 83: ALTER TABLE `%%$%%session` ADD PRIMARY KEY( `session_id` ); 84: ALTER TABLE `%%$%%session` CHANGE `username` `username` varchar(254) NOT NULL; 85: ALTER TABLE `%%$%%session` ADD `username` varchar(254) NOT NULL; 86: ALTER TABLE `%%$%%session` CHANGE `sessiontype` `sessiontype` int(11) NOT NULL DEFAULT '-1'; 87: ALTER TABLE `%%$%%session` ADD `sessiontype` int(11) NOT NULL DEFAULT '-1'; 88: ALTER TABLE `%%$%%session` CHANGE `created_dt` `created_dt` datetime NOT NULL; 89: ALTER TABLE `%%$%%session` ADD `created_dt` datetime NOT NULL; 90: ALTER TABLE `%%$%%session` CHANGE `updated_dt` `updated_dt` datetime NOT NULL; 91: ALTER TABLE `%%$%%session` ADD `updated_dt` datetime NOT NULL; 92: ALTER TABLE `%%$%%session` CHANGE `expires_dt` `expires_dt` datetime NOT NULL; 93: ALTER TABLE `%%$%%session` ADD `expires_dt` datetime NOT NULL; 94: ALTER TABLE `%%$%%session` CHANGE `realname` `realname` varchar(254) NOT NULL; 95: ALTER TABLE `%%$%%session` ADD `realname` varchar(254) NOT NULL; 96: -- 97: -- Table: status 98: -- DESCRIBE `status` 99: ALTER TABLE `%%$%%status` CHANGE `status` `status` int(11) NOT NULL; 100: ALTER TABLE `%%$%%status` ADD `status` int(11) NOT NULL; 101: ALTER TABLE `%%$%%status` ADD PRIMARY KEY( `status` ); 102: ALTER TABLE `%%$%%status` CHANGE `description` `description` varchar(254) NOT NULL; 103: ALTER TABLE `%%$%%status` ADD `description` varchar(254) NOT NULL; 104: -- 105: -- Table: sysconfig 106: -- DESCRIBE `sysconfig` 107: ALTER TABLE `%%$%%sysconfig` CHANGE `sc_option` `sc_option` varchar(254) NOT NULL; 108: ALTER TABLE `%%$%%sysconfig` ADD `sc_option` varchar(254) NOT NULL; 109: ALTER TABLE `%%$%%sysconfig` ADD PRIMARY KEY( `sc_option` ); 110: ALTER TABLE `%%$%%sysconfig` CHANGE `sc_value` `sc_value` varchar(254) NOT NULL; 111: ALTER TABLE `%%$%%sysconfig` ADD `sc_value` varchar(254) NOT NULL; 112: -- 113: -- Table: syslog 114: -- DESCRIBE `syslog` 115: ALTER TABLE `%%$%%syslog` CHANGE `event_id` `event_id` bigint(20) unsigned NOT NULL auto_increment; 116: ALTER TABLE `%%$%%syslog` ADD `event_id` bigint(20) unsigned NOT NULL auto_increment; 117: ALTER TABLE `%%$%%syslog` ADD PRIMARY KEY( `event_id` ); 118: ALTER TABLE `%%$%%syslog` CHANGE `event_dt` `event_dt` datetime NOT NULL; 119: ALTER TABLE `%%$%%syslog` ADD `event_dt` datetime NOT NULL; 120: ALTER TABLE `%%$%%syslog` CHANGE `event` `event` varchar(254) NOT NULL; 121: ALTER TABLE `%%$%%syslog` ADD `event` varchar(254) NOT NULL; 122: ALTER TABLE `%%$%%syslog` CHANGE `event_class` `event_class` varchar(128) NOT NULL; 123: ALTER TABLE `%%$%%syslog` ADD `event_class` varchar(128) NOT NULL; 124: ALTER TABLE `%%$%%syslog` CHANGE `event_type` `event_type` varchar(128) NOT NULL; 125: ALTER TABLE `%%$%%syslog` ADD `event_type` varchar(128) NOT NULL; 126: ALTER TABLE `%%$%%syslog` CHANGE `event_level` `event_level` int(11) NOT NULL; 127: ALTER TABLE `%%$%%syslog` ADD `event_level` int(11) NOT NULL; 128: -- 129: -- Table: team 130: -- DESCRIBE `team` 131: ALTER TABLE `%%$%%team` CHANGE `teamid` `teamid` bigint(20) unsigned NOT NULL auto_increment; 132: ALTER TABLE `%%$%%team` ADD `teamid` bigint(20) unsigned NOT NULL auto_increment; 133: ALTER TABLE `%%$%%team` ADD PRIMARY KEY( `teamid` ); 134: ALTER TABLE `%%$%%team` CHANGE `teamname` `teamname` varchar(254) NOT NULL; 135: ALTER TABLE `%%$%%team` ADD `teamname` varchar(254) NOT NULL; 136: -- 137: -- Table: teamuserlink 138: -- DESCRIBE `teamuserlink` 139: ALTER TABLE `%%$%%teamuserlink` CHANGE `linkid` `linkid` bigint(20) unsigned NOT NULL auto_increment; 140: ALTER TABLE `%%$%%teamuserlink` ADD `linkid` bigint(20) unsigned NOT NULL auto_increment; 141: ALTER TABLE `%%$%%teamuserlink` ADD PRIMARY KEY( `linkid` ); 142: ALTER TABLE `%%$%%teamuserlink` CHANGE `teamid` `teamid` bigint(20) unsigned NOT NULL; 143: ALTER TABLE `%%$%%teamuserlink` ADD `teamid` bigint(20) unsigned NOT NULL; 144: CREATE INDEX `teamid` ON `teamuserlink` ( `teamid` ); 145: ALTER TABLE `%%$%%teamuserlink` CHANGE `username` `username` varchar(254) NOT NULL; 146: ALTER TABLE `%%$%%teamuserlink` ADD `username` varchar(254) NOT NULL; 147: -- 148: -- Table: update 149: -- DESCRIBE `update` 150: ALTER TABLE `%%$%%update` CHANGE `updateid` `updateid` bigint(20) unsigned NOT NULL auto_increment; 151: ALTER TABLE `%%$%%update` ADD `updateid` bigint(20) unsigned NOT NULL auto_increment; 152: ALTER TABLE `%%$%%update` ADD PRIMARY KEY( `updateid` ); 153: ALTER TABLE `%%$%%update` CHANGE `requestid` `requestid` bigint(20) unsigned NOT NULL; 154: ALTER TABLE `%%$%%update` ADD `requestid` bigint(20) unsigned NOT NULL; 155: CREATE INDEX `requestid` ON `update` ( `requestid` ); 156: ALTER TABLE `%%$%%update` CHANGE `update` `update` text NOT NULL; 157: ALTER TABLE `%%$%%update` ADD `update` text NOT NULL; 158: ALTER TABLE `%%$%%update` CHANGE `public` `public` tinyint(4) NOT NULL; 159: ALTER TABLE `%%$%%update` ADD `public` tinyint(4) NOT NULL; 160: ALTER TABLE `%%$%%update` CHANGE `updateby` `updateby` varchar(254) NOT NULL; 161: ALTER TABLE `%%$%%update` ADD `updateby` varchar(254) NOT NULL; 162: ALTER TABLE `%%$%%update` CHANGE `updatedt` `updatedt` datetime NOT NULL; 163: ALTER TABLE `%%$%%update` ADD `updatedt` datetime NOT NULL; 164: -- 165: -- Table: user 166: -- DESCRIBE `user` 167: ALTER TABLE `%%$%%user` CHANGE `username` `username` varchar(254) NOT NULL; 168: ALTER TABLE `%%$%%user` ADD `username` varchar(254) NOT NULL; 169: ALTER TABLE `%%$%%user` ADD PRIMARY KEY( `username` ); 170: ALTER TABLE `%%$%%user` CHANGE `password` `password` varchar(254) NOT NULL; 171: ALTER TABLE `%%$%%user` ADD `password` varchar(254) NOT NULL; 172: ALTER TABLE `%%$%%user` CHANGE `realname` `realname` varchar(254) NOT NULL; 173: ALTER TABLE `%%$%%user` ADD `realname` varchar(254) NOT NULL; 174: ALTER TABLE `%%$%%user` CHANGE `email` `email` varchar(254) NOT NULL; 175: ALTER TABLE `%%$%%user` ADD `email` varchar(254) NOT NULL; 176: ALTER TABLE `%%$%%user` CHANGE `permgroup` `permgroup` bigint(20) unsigned NOT NULL; 177: ALTER TABLE `%%$%%user` ADD `permgroup` bigint(20) unsigned NOT NULL; 178: ALTER TABLE `%%$%%user` CHANGE `authtype` `authtype` varchar(254) NOT NULL; 179: ALTER TABLE `%%$%%user` ADD `authtype` varchar(254) NOT NULL; 180: ALTER TABLE `%%$%%user` CHANGE `sparefield0` `sparefield0` varchar(254) NOT NULL; 181: ALTER TABLE `%%$%%user` ADD `sparefield0` varchar(254) NOT NULL; 182: ALTER TABLE `%%$%%user` CHANGE `sparefield1` `sparefield1` varchar(254) NOT NULL; 183: ALTER TABLE `%%$%%user` ADD `sparefield1` varchar(254) NOT NULL; 184: ALTER TABLE `%%$%%user` CHANGE `sparefield2` `sparefield2` varchar(254) NOT NULL; 185: ALTER TABLE `%%$%%user` ADD `sparefield2` varchar(254) NOT NULL; 186: ALTER TABLE `%%$%%user` CHANGE `sparefield3` `sparefield3` varchar(254) NOT NULL; 187: ALTER TABLE `%%$%%user` ADD `sparefield3` varchar(254) NOT NULL; 188: ALTER TABLE `%%$%%user` CHANGE `sparefield4` `sparefield4` varchar(254) NOT NULL; 189: ALTER TABLE `%%$%%user` ADD `sparefield4` varchar(254) NOT NULL; 190: ALTER TABLE `%%$%%user` CHANGE `sparefield5` `sparefield5` varchar(254) NOT NULL; 191: ALTER TABLE `%%$%%user` ADD `sparefield5` varchar(254) NOT NULL; 192: ALTER TABLE `%%$%%user` CHANGE `sparefield6` `sparefield6` varchar(254) NOT NULL; 193: ALTER TABLE `%%$%%user` ADD `sparefield6` varchar(254) NOT NULL; 194: ALTER TABLE `%%$%%user` CHANGE `sparefield7` `sparefield7` varchar(254) NOT NULL; 195: ALTER TABLE `%%$%%user` ADD `sparefield7` varchar(254) NOT NULL; 196: ALTER TABLE `%%$%%user` CHANGE `sparefield8` `sparefield8` varchar(254) NOT NULL; 197: ALTER TABLE `%%$%%user` ADD `sparefield8` varchar(254) NOT NULL; 198: ALTER TABLE `%%$%%user` CHANGE `sparefield9` `sparefield9` varchar(254) NOT NULL; 199: ALTER TABLE `%%$%%user` ADD `sparefield9` varchar(254) NOT NULL; 200: -- 201: