wisest owl (wisest_owl) wrote in changelog,
wisest owl
wisest_owl
changelog

[livejournal] r17746: LJSUP-7052.

Committer: gprochaev
LJSUP-7052.

U   trunk/bin/upgrading/update-db-general.pl
Modified: trunk/bin/upgrading/update-db-general.pl
===================================================================
--- trunk/bin/upgrading/update-db-general.pl	2010-11-23 03:13:11 UTC (rev 17745)
+++ trunk/bin/upgrading/update-db-general.pl	2010-11-23 03:25:41 UTC (rev 17746)
@@ -4320,10 +4320,12 @@
                     ADD remove_after INT NOT NULL");
     }
 
-    unless (column_type("vertical2", "kw_id")) {
-        do_alter("ALTER TABLE vertical_keywords DROP PRIMARY KEY, DROP INDEX vert_id, DROP INDEX keyword, DROP journalid, DROP jitemid, DROP vert_id, DROP is_seo, ADD kw_id INT NOT NULL");
+    unless (column_type("vertical_keywords", "kw_id")) {
+        do_alter("vertical_keywords",
+            "ALTER TABLE vertical_keywords DROP PRIMARY KEY, DROP INDEX vert_id, DROP INDEX keyword, DROP journalid, DROP jitemid, DROP vert_id, DROP is_seo, ADD kw_id INT NOT NULL");
         do_sql("TRUNCATE vertical_keywords");
-        do_alter("ALTER TABLE vertical_keywords ADD PRIMARY KEY(kw_id), ADD UNIQUE(keyword), MODIFY kw_id INT NOT NULL AUTO_INCREMENT");
+        do_alter("vertical_keywords",
+            "ALTER TABLE vertical_keywords ADD PRIMARY KEY(kw_id), ADD UNIQUE(keyword), MODIFY kw_id INT NOT NULL AUTO_INCREMENT");
     }
 
 });

Tags: livejournal, pl, wisest-owl
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