You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@spamassassin.apache.org by gb...@apache.org on 2021/05/30 09:45:17 UTC

svn commit: r1890323 - /spamassassin/trunk/sql/decodeshorturl_mysql.sql

Author: gbechis
Date: Sun May 30 09:45:17 2021
New Revision: 1890323

URL: http://svn.apache.org/viewvc?rev=1890323&view=rev
Log:
fix sql syntax

Modified:
    spamassassin/trunk/sql/decodeshorturl_mysql.sql

Modified: spamassassin/trunk/sql/decodeshorturl_mysql.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/decodeshorturl_mysql.sql?rev=1890323&r1=1890322&r2=1890323&view=diff
==============================================================================
--- spamassassin/trunk/sql/decodeshorturl_mysql.sql (original)
+++ spamassassin/trunk/sql/decodeshorturl_mysql.sql Sun May 30 09:45:17 2021
@@ -6,5 +6,5 @@ CREATE TABLE `short_url_cache`
   `modified` INT(11) NOT NULL ,
   PRIMARY KEY (`short_url`)
 ) ENGINE = InnoDB;
-ALTER TABLE `spam_bayes`.`short_url_cache` ADD INDEX `short_url_by_modified` (`short_url`, `modified`);
-ALTER TABLE `spam_bayes`.`short_url_cache` ADD INDEX `short_url_modified` (`modified`);
+ALTER TABLE `short_url_cache` ADD INDEX `short_url_by_modified` (`short_url`, `modified`);
+ALTER TABLE `short_url_cache` ADD INDEX `short_url_modified` (`modified`);