sunnyman's (sunnyman) wrote in changelog,
sunnyman's
sunnyman
changelog

[ljcom] r11374: LJSUP-10937: selfpromo table index (type...

Committer: vtroitsky
LJSUP-10937: selfpromo table index (type, promoid) added
U   trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2012-01-31 10:07:51 UTC (rev 11373)
+++ trunk/bin/upgrading/update-db-local.pl	2012-01-31 10:21:51 UTC (rev 11374)
@@ -2282,6 +2282,12 @@
         );
     }
 
+    unless (index_name('selfpromo', "INDEX:type-promoid")) {
+        do_alter("selfpromo",
+            "ALTER TABLE selfpromo ADD INDEX `type_promoid_index` (`type`, `promoid`)"
+        );
+    }
+
     unless (column_type("userapps", "userhead")) {
         do_alter("userapps", qq{
             ALTER TABLE userapps

Tags: ljcom, pl, sunnyman, vtroitsky
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments