# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1382011308 -10800
# Node ID c70c2650f790b7fab84fcc257c7a4fedc3ec6d1f
# Parent  63a6caf59e5c7a7e09f0815c339070b8219c200d
Cosmetics.

diff -r 63a6caf59e5c -r c70c2650f790 createdb.php
--- a/createdb.php	Thu Oct 17 15:01:20 2013 +0300
+++ b/createdb.php	Thu Oct 17 15:01:48 2013 +0300
@@ -159,12 +159,15 @@
 );
 
 $sqlTables = array(
+  "settings" => "key VARCHAR(32) PRIMARY KEY, vtype INT, vstr VARCHAR(128), vtext TEXT, vint INT, desc VARCHAR(128)",
   "news" => "id INTEGER PRIMARY KEY AUTOINCREMENT, utime INT, title VARCHAR(128), text VARCHAR(4096), author VARCHAR(64), persist INT DEFAULT 0",
-  "attendees" => "id INTEGER PRIMARY KEY AUTOINCREMENT, regtime INT, name VARCHAR(64), groups VARCHAR(64), oneliner VARCHAR(64), email VARCHAR(80), key VARCHAR(64), active INT DEFAULT 0",
   "compos" => "id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(128), description VARCHAR(4096), visible INT DEFAULT 0, voting INT DEFAULT 0, showAuthors INT DEFAULT 0",
   "entries" => "id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(64), author VARCHAR(64), compo_id INT DEFAULT NULL, filename VARCHAR(256) DEFAULT NULL",
+
+  "attendees" => "id INTEGER PRIMARY KEY AUTOINCREMENT, regtime INT, name VARCHAR(64), groups VARCHAR(64), oneliner VARCHAR(64), email VARCHAR(80)",
+  "votekeys" => "id INTEGER PRIMARY KEY AUTOINCREMENT, attendee_id INT, key VARCHAR(64), active INT DEFAULT 0",
+
   "votes" => "id INTEGER PRIMARY KEY AUTOINCREMENT, entry_id INT DEFAULT NULL, voter_id INT DEFAULT NULL, value INT DEFAULT 0",
-  "settings" => "key VARCHAR(32) PRIMARY KEY, vtype INT, vstr VARCHAR(128), vtext TEXT, vint INT, desc VARCHAR(128)",
 );