Mercurial > hg > fapweb
changeset 355:4ced04d29858
Database format change.
| author | Matti Hamalainen <ccr@tnsp.org> |
|---|---|
| date | Tue, 03 Dec 2013 08:55:28 +0200 |
| parents | 1dd598221874 |
| children | 965d43fffdd2 |
| files | createdb.php |
| diffstat | 1 files changed, 5 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/createdb.php Mon Dec 02 11:23:08 2013 +0200 +++ b/createdb.php Tue Dec 03 08:55:28 2013 +0200 @@ -11,7 +11,7 @@ die(); } -$dbVersion = 6; +$dbVersion = 7; $dbMeta = array( "dbVersion" => array(VT_INT, $dbVersion, "Database version"), @@ -180,7 +180,7 @@ "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)", "displayListData" => "id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(128)", - "displayListSlides" => "id INTEGER PRIMARY KEY AUTOINCREMENT, list_id INT DEFAULT 0, slide_id INT DEFAULT 0", + "displayListSlides" => "id INTEGER PRIMARY KEY AUTOINCREMENT, list_id INT DEFAULT 0, slide_id INT DEFAULT 0, order_num INT DEFAULT 0", ); $siteDisplayVars = array( @@ -533,10 +533,10 @@ echo "Database at version ".$currVersion.", upgrading to ".$dbVersion."\n"; // Possibly bail out incompatible upgrades here if ($currVersion < 6) - { - // Table format change stExecSQL("DROP TABLE votes"); - } + + if ($currVersion < 7) + stExecSQL("DROP TABLE displayListSlides"); // Create tables if (!stCreateTables(TRUE))