Igor Gariev (gariev) wrote in changelog,
Igor Gariev
gariev
changelog

[livejournal] r17552: LJSUP-6780: table ratelog is full

Committer: gariev
LJSUP-6780: table ratelog is full
U   trunk/bin/upgrading/update-db-general.pl
Modified: trunk/bin/upgrading/update-db-general.pl
===================================================================
--- trunk/bin/upgrading/update-db-general.pl	2010-10-12 09:46:19 UTC (rev 17551)
+++ trunk/bin/upgrading/update-db-general.pl	2010-10-13 05:49:56 UTC (rev 17552)
@@ -1441,7 +1441,7 @@
 register_tablecreate("ratelist", <<'EOC');
 CREATE TABLE ratelist
 (
- rlid TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ rlid INT UNSIGNED NOT NULL AUTO_INCREMENT,
  name  varchar(50) not null,
  des varchar(255) not null,
  PRIMARY KEY (rlid),
@@ -4196,6 +4196,13 @@
                  "ADD accounts smallint(5) unsigned NOT NULL default '0'");
     }
 
+    if (column_type("ratelist", "rlid") =~ /tinyint/i) {
+        do_alter("ratelist",
+                 "ALTER TABLE ratelist " .
+                 "MODIFY rlid INT UNSIGNED NOT NULL AUTO_INCREMENT");
+    }
+
+
 });
 
 register_tablecreate("eventrates", <<'EOC'); # clustered

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