Mercurial > hg > fapweb
changeset 420:e9f6e242c4b9
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