make message id columns larger

diff --git a/schema/bse.sql b/schema/bse.sql
index 5c866e09026c6776d422933a0e9a29d81ab27a8f..5e59fc853f63446731370de8c1d4031bbee18056 100644 (file)
--- a/schema/bse.sql
+++ b/schema/bse.sql
@@ -1028,7 +1028,7 @@ create table bse_msg_base (
   -- "bse/userreg/" "Member services"
   -- id, formatting, params are limited to ascii text
   -- description unicode
-  id varchar(40) not null primary key,
+  id varchar(80) not null primary key,
 
   -- a semi-long description of the message, including any parameters
   description text not null,
@@ -1060,7 +1060,7 @@ create table bse_msg_base (
 -- for the same message might be loaded from different data sets
 create table bse_msg_defaults (
   -- message identifier
-  id varchar(40) not null,
+  id varchar(80) not null,
 
   -- language code for this message
   -- empty as the fallback
@@ -1078,7 +1078,7 @@ create table bse_msg_defaults (
 -- admin managed message base, should never be loaded from data
 create table bse_msg_managed (
   -- message identifier
-  id varchar(40) not null,
+  id varchar(80) not null,
 
   -- language code
   -- empty as the fallback

diff --git a/site/util/mysql.str b/site/util/mysql.str
index f0f1f11cc90641b42defd614317e10875a13c3ef..495e90216911fa1def5186fa339d8e6a182278f1 100644 (file)
--- a/site/util/mysql.str
+++ b/site/util/mysql.str
@@ -190,20 +190,20 @@ Column admin_notes;text;NO;NULL;
 Column disabled;int(11);NO;0;
 Index PRIMARY;1;[id]
 Table bse_msg_base
-Column id;varchar(40);NO;NULL;
+Column id;varchar(80);NO;NULL;
 Column description;text;NO;NULL;
 Column formatting;varchar(5);NO;none;
 Column params;varchar(40);NO;;
 Column multiline;int(11);NO;0;
 Index PRIMARY;1;[id]
 Table bse_msg_defaults
-Column id;varchar(40);NO;NULL;
+Column id;varchar(80);NO;NULL;
 Column language_code;varchar(10);NO;;
 Column priority;int(11);NO;0;
 Column message;text;NO;NULL;
 Index PRIMARY;1;[id;language_code;priority]
 Table bse_msg_managed
-Column id;varchar(40);NO;NULL;
+Column id;varchar(80);NO;NULL;
 Column language_code;varchar(10);NO;;
 Column message;text;NO;NULL;
 Index PRIMARY;1;[id;language_code]