changelog_bot (changelog_bot) wrote in changelog,
changelog_bot
changelog_bot
changelog

[livejournal] r23351: LJSUP-14246: rename table

Committer: tnurutdinov
LJSUP-14246: rename table
U   trunk/bin/maint/clean_caches.pl
U   trunk/bin/upgrading/update-db-general.pl
Modified: trunk/bin/maint/clean_caches.pl
===================================================================
--- trunk/bin/maint/clean_caches.pl	2012-11-23 11:51:21 UTC (rev 23350)
+++ trunk/bin/maint/clean_caches.pl	2012-11-23 12:16:03 UTC (rev 23351)
@@ -19,7 +19,7 @@
 
     print "-I- Cleaning commenturl.\n";
     $dbh->do("DELETE FROM commenturls WHERE timecreate < UNIX_TIMESTAMP() - 86400*30 LIMIT 50000");
-    $dbh->do("DELETE FROM commenturls2 WHERE timecreate < UNIX_TIMESTAMP() - 86400*30 LIMIT 50000");
+    $dbh->do("DELETE FROM commenturlsext WHERE timecreate < UNIX_TIMESTAMP() - 86400*30 LIMIT 50000");
 
     print "-I- Cleaning syslog table.\n";
     $dbh->do("DELETE FROM syslog WHERE log_time < UNIX_TIMESTAMP() - 86400 * 30 * 2");  ## 2 months

Modified: trunk/bin/upgrading/update-db-general.pl
===================================================================
--- trunk/bin/upgrading/update-db-general.pl	2012-11-23 11:51:21 UTC (rev 23350)
+++ trunk/bin/upgrading/update-db-general.pl	2012-11-23 12:16:03 UTC (rev 23351)
@@ -347,8 +347,8 @@
 )
 EOC
 
-register_tablecreate('commenturls2', <<'EOC');
-CREATE TABLE `commenturls2` (
+register_tablecreate('commenturlsext', <<'EOC');
+CREATE TABLE `commenturlsext` (
   `posterid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
   `journalid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
   `jtalkid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
@@ -3526,6 +3526,7 @@
 register_tabledrop("events");
 register_tabledrop("randomuserset");
 register_tabledrop("antispam");
+register_tabledrop("commenturls2");
 
 ### changes
 

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