# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1382849181 -7200
# Node ID dffededcdd92d2ab8c6154aa6bdf5c0819f8b265
# Parent  8db98399bb38e66f94ab08756c2f7cff48da7a6b
Add info field to entries.

diff -r 8db98399bb38 -r dffededcdd92 createdb.php
--- a/createdb.php	Sun Oct 27 06:45:37 2013 +0200
+++ b/createdb.php	Sun Oct 27 06:46:21 2013 +0200
@@ -136,7 +136,7 @@
   "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",
   "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, show_id INT DEFAULT 0, name VARCHAR(64), author VARCHAR(64), compo_id INT DEFAULT NULL, filename VARCHAR(256) DEFAULT NULL",
+  "entries" => "id INTEGER PRIMARY KEY AUTOINCREMENT, show_id INT DEFAULT 0, name VARCHAR(64), author VARCHAR(64), compo_id INT DEFAULT NULL, filename VARCHAR(256) DEFAULT NULL, info VARCHAR(256) DEFAULT NULL",
 
   "attendees" => "id INTEGER PRIMARY KEY AUTOINCREMENT, regtime INT, name VARCHAR(64), groups VARCHAR(64), oneliner VARCHAR(64), email VARCHAR(80), key_id INT DEFAULT NULL",
 
@@ -203,15 +203,17 @@
     "%s,%s,1,1",
     array("Graphics", "Anything in standard resolutions."),
     array("Protracker music", "Standard 4-channel Protracker MOD music."),
+    array("4k intro", "4k intro competition"),
   ),
   
   "entries" => array(
-    "name,author,compo_id,filename",
-    "%s,%s,%d,%s",
-    array("my dong", "visualice/hjb", 1, "juice.lbm"),
-    array("kondom", "ccr/TNSP", 1, "kondom.lbm"),
-    array("penis song", "reed/flt", 2, "penis.mod"),
-    array("jenkka", "aegis", 2, "jenkka.mod"),
+    "name,author,compo_id,filename,info",
+    "%s,%s,%d,%s,%s",
+    array("Donkey Dong", "electric/extend", 1, "donkey.lbm", "amigaaaah!"),
+    array("Your kondom", "ccr/TNSP", 1, "kondom.lbm", "oh my god, it's full of cocks!"),
+    array("Penis song", "reed/flt", 2, "penis.mod", "laulu rakkaudelle"),
+    array("jenkka", "aegis", 2, "jenkka.mod", ""),
+    array("Fungiform 2", "mfx", 3, "mfx-fungiform2.lzh"),
   ),
   
   "displaySlides" => array(