You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spamassassin.apache.org by he...@apache.org on 2020/04/10 07:51:52 UTC
svn commit: r1876348 - in /spamassassin: branches/3.4/sql/userpref_mysql.sql branches/3.4/sql/userpref_pg.sql trunk/sql/userpref_mysql.sql trunk/sql/userpref_pg.sql

Author: hege
Date: Fri Apr 10 07:51:51 2020
New Revision: 1876348

URL: http://svn.apache.org/viewvc?rev=1876348&view=rev
Log:
Bug 7803 - SQL schema of userpref table, value too short

Modified:
    spamassassin/branches/3.4/sql/userpref_mysql.sql
    spamassassin/branches/3.4/sql/userpref_pg.sql
    spamassassin/trunk/sql/userpref_mysql.sql
    spamassassin/trunk/sql/userpref_pg.sql

Modified: spamassassin/branches/3.4/sql/userpref_mysql.sql
URL: http://svn.apache.org/viewvc/spamassassin/branches/3.4/sql/userpref_mysql.sql?rev=1876348&r1=1876347&r2=1876348&view=diff
==============================================================================
--- spamassassin/branches/3.4/sql/userpref_mysql.sql (original)
+++ spamassassin/branches/3.4/sql/userpref_mysql.sql Fri Apr 10 07:51:51 2020
@@ -1,7 +1,7 @@
 CREATE TABLE userpref (
   username varchar(100) NOT NULL default '',
   preference varchar(50) NOT NULL default '',
-  value varchar(100) NOT NULL default '',
+  value varchar(255) NOT NULL default '',
   prefid int(11) NOT NULL auto_increment,
   PRIMARY KEY  (prefid),
   KEY username (username)

Modified: spamassassin/branches/3.4/sql/userpref_pg.sql
URL: http://svn.apache.org/viewvc/spamassassin/branches/3.4/sql/userpref_pg.sql?rev=1876348&r1=1876347&r2=1876348&view=diff
==============================================================================
--- spamassassin/branches/3.4/sql/userpref_pg.sql (original)
+++ spamassassin/branches/3.4/sql/userpref_pg.sql Fri Apr 10 07:51:51 2020
@@ -2,6 +2,6 @@ CREATE TABLE userpref (
   prefid bigserial NOT NULL unique primary key,
   username varchar(100) NOT NULL,
   preference varchar(50) NOT NULL,
-  value varchar(100) NOT NULL
+  value varchar(255) NOT NULL
 );
 CREATE INDEX userpref_username_idx ON userpref(username);

Modified: spamassassin/trunk/sql/userpref_mysql.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/userpref_mysql.sql?rev=1876348&r1=1876347&r2=1876348&view=diff
==============================================================================
--- spamassassin/trunk/sql/userpref_mysql.sql (original)
+++ spamassassin/trunk/sql/userpref_mysql.sql Fri Apr 10 07:51:51 2020
@@ -1,7 +1,7 @@
 CREATE TABLE userpref (
   username varchar(100) NOT NULL default '',
   preference varchar(50) NOT NULL default '',
-  value varchar(100) NOT NULL default '',
+  value varchar(255) NOT NULL default '',
   prefid int(11) NOT NULL auto_increment,
   PRIMARY KEY  (prefid),
   KEY username (username)

Modified: spamassassin/trunk/sql/userpref_pg.sql
URL: http://svn.apache.org/viewvc/spamassassin/trunk/sql/userpref_pg.sql?rev=1876348&r1=1876347&r2=1876348&view=diff
==============================================================================
--- spamassassin/trunk/sql/userpref_pg.sql (original)
+++ spamassassin/trunk/sql/userpref_pg.sql Fri Apr 10 07:51:51 2020
@@ -2,6 +2,6 @@ CREATE TABLE userpref (
   prefid bigserial NOT NULL unique primary key,
   username varchar(100) NOT NULL,
   preference varchar(50) NOT NULL,
-  value varchar(100) NOT NULL
+  value varchar(255) NOT NULL
 );
 CREATE INDEX userpref_username_idx ON userpref(username);