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