make body a longtext to avoid clipping on huge bodies

diff --git a/schema/bse.sql b/schema/bse.sql
index f27e963eed572237685fbc9fdb8fcab4bdbbcc75..bbfdaa797262d6716b1b111354c84330d688fb16 100644 (file)
--- a/schema/bse.sql
+++ b/schema/bse.sql
@@ -12,7 +12,7 @@ CREATE TABLE article (
   displayOrder integer not NULL default 0,
   title varchar(255) DEFAULT '' NOT NULL,
   titleImage varchar(64) not null,
-  body text NOT NULL,
+  body longtext NOT NULL,
 
   -- thumbnail image
   thumbImage varchar(64) not null default '',

diff --git a/site/util/mysql.str b/site/util/mysql.str
index 2a8b2f07d1a85c542f6f779b1f74f547489f8b12..e567cf7a9282a3cd67175a93b3e24d1f7517eb2e 100644 (file)
--- a/site/util/mysql.str
+++ b/site/util/mysql.str
@@ -34,7 +34,7 @@ Column parentid;int(11);NO;0;
 Column displayOrder;int(11);NO;0;
 Column title;varchar(255);NO;;
 Column titleImage;varchar(64);NO;NULL;
-Column body;text;NO;NULL;
+Column body;longtext;NO;NULL;
 Column thumbImage;varchar(64);NO;;
 Column thumbWidth;int(11);NO;NULL;
 Column thumbHeight;int(11);NO;NULL;
@@ -522,7 +522,7 @@ Index PRIMARY;1;[id]
 Table sessions
 Column id;char(32);NO;NULL;
 Column a_session;blob;YES;NULL;
-Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;
+Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
 Index PRIMARY;1;[id]
 Table site_users
 Column id;int(11);NO;NULL;auto_increment