Mailing List Archive

Author: gbechis
Date: Mon Feb 12 16:22:44 2024
New Revision: 1915749

URL: http://svn.apache.org/viewvc?rev=1915749&view=rev
Log:
use new MySQL syntax
switch to InnoDB by default on userpref table as well

Modified:
spamassassin/trunk/sql/README
spamassassin/trunk/sql/README.awl
spamassassin/trunk/sql/userpref_mysql.sql

Modified: spamassassin/trunk/sql/README
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/README?rev=1915749&r1=1915748&r2=1915749&view=diff
==============================================================================
--- spamassassin/trunk/sql/README (original)
+++ spamassassin/trunk/sql/README Mon Feb 12 16:22:44 2024
@@ -130,7 +130,7 @@ CREATE TABLE userpref (
prefid int(11) NOT NULL auto_increment,
PRIMARY KEY (prefid),
INDEX (username)
-) TYPE=MyISAM;
+) ENGINE=InnoDB;

For PostgreSQL, use the following command:


Modified: spamassassin/trunk/sql/README.awl
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/README.awl?rev=1915749&r1=1915748&r2=1915749&view=diff
==============================================================================
--- spamassassin/trunk/sql/README.awl (original)
+++ spamassassin/trunk/sql/README.awl Mon Feb 12 16:22:44 2024
@@ -113,7 +113,7 @@ CREATE TABLE awl (
totscore float NOT NULL default '0',
signedby varchar(255) NOT NULL default '',
PRIMARY KEY (username,email,signedby,ip)
-) TYPE=MyISAM;
+) ENGINE=InnoDB;


For PostgreSQL, use the following:

Modified: spamassassin/trunk/sql/userpref_mysql.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/userpref_mysql.sql?rev=1915749&r1=1915748&r2=1915749&view=diff
==============================================================================
--- spamassassin/trunk/sql/userpref_mysql.sql (original)
+++ spamassassin/trunk/sql/userpref_mysql.sql Mon Feb 12 16:22:44 2024
@@ -5,4 +5,4 @@ CREATE TABLE userpref (
prefid int(11) NOT NULL auto_increment,
PRIMARY KEY (prefid),
KEY username (username)
-) TYPE=MyISAM;
+) ENGINE=InnoDB;