Committer: amyshkin
LJSUP-9430: Additional development of data fileU trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl =================================================================== --- trunk/bin/upgrading/update-db-local.pl 2011-08-09 14:22:54 UTC (rev 10825) +++ trunk/bin/upgrading/update-db-local.pl 2011-08-10 03:30:48 UTC (rev 10826) @@ -1925,6 +1925,18 @@ "ALTER TABLE journal_spotlight DROP COLUMN img_url"); } + if ( index_name("sg_invites", "UNIQUE:time") eq 'PRIMARY' ) { + do_alter( + "sg_invites", + "ALTER TABLE sg_invites " . + "DROP PRIMARY KEY, " . + "ADD INDEX `time_idx` (`time`), " . + "ADD `posted` INT(3), " . + "ADD INDEX `posted_idx` (`posted`)" + + ); + } + unless (index_name("journal_spotlight", "UNIQUE:userid-domain") || index_name("journal_spotlight", "UNIQUE:spotid") eq 'PRIMARY') {