Mercurial > hg > fapweb

changeset 420:e9f6e242c4b9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Define some more SQL field lengths.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 05 Dec 2013 19:10:52 +0200
parents 206a18bc603a
children 606a8ab61d0f
files createdb.php msite.inc.php
diffstat 2 files changed, 5 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/createdb.php	Thu Dec 05 18:54:09 2013 +0200
+++ b/createdb.php	Thu Dec 05 19:10:52 2013 +0200
@@ -178,8 +178,8 @@
   "votes" => "id INTEGER PRIMARY KEY AUTOINCREMENT, entry_id INT DEFAULT NULL, key_id INT DEFAULT NULL, value INT DEFAULT 0",
 
   "displayVars" => "key VARCHAR(32) PRIMARY KEY, vtype INT, vstr VARCHAR(128), vtext TEXT, vint INT, desc VARCHAR(128)",
-  "displaySlides" => "id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(128), text VARCHAR(4096)",
-  "rotationListData" => "id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(128)",
+  "displaySlides" => "id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(".SET_LEN_DISP_SLIDE_TITLE."), text VARCHAR(".SET_LEN_DISP_SLIDE_TEXT.")",
+  "rotationListData" => "id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(".SET_LEN_ROT_LIST_NAME.")",
   "rotationListSlides" => "id INTEGER PRIMARY KEY AUTOINCREMENT, list_id INT DEFAULT 0, slide_id INT DEFAULT 0, order_num INT DEFAULT 0",
 );
 
--- a/msite.inc.php	Thu Dec 05 18:54:09 2013 +0200
+++ b/msite.inc.php	Thu Dec 05 19:10:52 2013 +0200
@@ -31,6 +31,9 @@
 define("SET_LEN_ENTRY_FILENAME", 256);
 define("SET_LEN_ENTRY_INFO", 256);
 
+define("SET_LEN_DISP_SLIDE_TITLE", 128);
+define("SET_LEN_DISP_SLIDE_TEXT", 4096);
+define("SET_LEN_ROT_LIST_NAME", 128);
 
 //
 // Different voting modes