1 # Patch for upgrade from 2.2beta to 2.2RC/final
3 ALTER TABLE `0_tag_associations` DROP COLUMN `id`;
4 ALTER TABLE `0_tag_associations` ADD UNIQUE KEY(`record_id`,`tag_id`);
6 DROP TABLE IF EXISTS `0_useronline` ;
8 CREATE TABLE `0_useronline` (
9 `id` int(11) NOT NULL AUTO_INCREMENT ,
10 `timestamp` int(15) NOT NULL default '0',
11 `ip` varchar(40) NOT NULL default '',
12 `file` varchar(100) NOT NULL default '',
13 PRIMARY KEY `id` (`id`) ,
15 ) TYPE=MYISAM AUTO_INCREMENT=1;