Mercurial > hg > fapweb

changeset 505:f66aa0cdb666

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename some SQL table schema types (s/INTEGER/INT/)
author Matti Hamalainen <ccr@tnsp.org>
date Sat, 07 Dec 2013 19:35:32 +0200
parents a491865e0684
children d29166d97b46
files createdb.php
diffstat 1 files changed, 24 insertions(+), 24 deletions(-) [+]
line wrap: on
line diff
--- a/createdb.php	Sat Dec 07 19:35:01 2013 +0200
+++ b/createdb.php	Sat Dec 07 19:35:32 2013 +0200
@@ -166,10 +166,10 @@
   //
   "dbmeta" => array(
     array("key"          , "VARCHAR(32)", "PRIMARY KEY"),
-    array("vtype"        , "INTEGER"),
+    array("vtype"        , "INT"),
     array("vstr"         , "VARCHAR(128)"),
     array("vtext"        , "TEXT"),
-    array("vint"         , "INTEGER"),
+    array("vint"         , "INT"),
     array("desc"         , "VARCHAR(128)"),
   ),
 
@@ -178,64 +178,64 @@
   //
   "settings" => array(
     array("key"          , "VARCHAR(32)", "PRIMARY KEY"),
-    array("vtype"        , "INTEGER"),
+    array("vtype"        , "INT"),
     array("vstr"         , "VARCHAR(128)"),
     array("vtext"        , "TEXT"),
-    array("vint"         , "INTEGER"),
+    array("vint"         , "INT"),
     array("desc"         , "VARCHAR(128)"),
   ),
 
   "news" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
-    array("utime"        , "INTEGER"),
+    array("utime"        , "INT"),
     array("title"        , "VARCHAR(".SET_LEN_NEWS_TITLE.")"),
     array("text"         , "VARCHAR(".SET_LEN_NEWS_TEXT.")"),
     array("author"       , "VARCHAR(".SET_LEN_NEWS_AUTHOR.")"),
-    array("persist"      , "INTEGER", "DEFAULT 0"),
+    array("persist"      , "INT", "DEFAULT 0"),
   ),
 
   "compos" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
     array("name"         , "VARCHAR(".SET_LEN_COMPO_NAME.")"),
     array("description"  , "VARCHAR(".SET_LEN_COMPO_DESC.")"),
-    array("visible"      , "INTEGER", "DEFAULT 0"),
-    array("voting"       , "INTEGER", "DEFAULT 0"),
-    array("showAuthors"  , "INTEGER", "DEFAULT 0"),
-    array("type"         , "INTEGER", "DEFAULT 0"),
+    array("visible"      , "INT", "DEFAULT 0"),
+    array("voting"       , "INT", "DEFAULT 0"),
+    array("showAuthors"  , "INT", "DEFAULT 0"),
+    array("type"         , "INT", "DEFAULT 0"),
   ),
   
   "entries" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
-    array("show_id"      , "INTEGER", "DEFAULT 0"),
+    array("show_id"      , "INT", "DEFAULT 0"),
     array("name"         , "VARCHAR(".SET_LEN_ENTRY_NAME.")"),
     array("author"       , "VARCHAR(".SET_LEN_ENTRY_AUTHOR.")"),
-    array("compo_id"     , "INTEGER", "DEFAULT 0"),
+    array("compo_id"     , "INT", "DEFAULT 0"),
     array("filename"     , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"),
     array("info"         , "VARCHAR(".SET_LEN_ENTRY_INFO.")", "DEFAULT NULL"),
-    array("flags"        , "INTEGER", "DEFAULT 0"),
+    array("flags"        , "INT", "DEFAULT 0"),
   ),
 
   "attendees" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
-    array("regtime"      , "INTEGER"),
+    array("regtime"      , "INT"),
     array("name"         , "VARCHAR(".SET_LEN_USERNAME.")"),
     array("groups"       , "VARCHAR(".SET_LEN_GROUPS.")"),
     array("oneliner"     , "VARCHAR(".SET_LEN_ONELINER.")"),
     array("email"        , "VARCHAR(".SET_LEN_EMAIL.")"),
-    array("key_id"       , "INTEGER", "DEFAULT NULL"),
+    array("key_id"       , "INT", "DEFAULT NULL"),
   ),
 
   "votekeys" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
     array("key"          , "VARCHAR(".SET_LEN_VOTEKEY.")"),
-    array("active"       , "INTEGER", "DEFAULT 0"),
+    array("active"       , "INT", "DEFAULT 0"),
   ),
 
   "votes" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
-    array("entry_id"     , "INTEGER", "DEFAULT NULL"),
-    array("key_id"       , "INTEGER", "DEFAULT 0"),
-    array("value"        , "INTEGER", "DEFAULT 0"),
+    array("entry_id"     , "INT", "DEFAULT NULL"),
+    array("key_id"       , "INT", "DEFAULT 0"),
+    array("value"        , "INT", "DEFAULT 0"),
   ),
 
   //
@@ -243,10 +243,10 @@
   //
   "displayVars" => array(
     array("key"          , "VARCHAR(32)", "PRIMARY KEY"),
-    array("vtype"        , "INTEGER"),
+    array("vtype"        , "INT"),
     array("vstr"         , "VARCHAR(128)"),
     array("vtext"        , "TEXT"),
-    array("vint"         , "INTEGER"),
+    array("vint"         , "INT"),
     array("desc"         , "VARCHAR(128)"),
   ),
 
@@ -263,9 +263,9 @@
   
   "rotationListSlides" => array(
     array("id"           , "INTEGER", "PRIMARY KEY AUTOINCREMENT"),
-    array("list_id"      , "INTEGER", "DEFAULT 0"),
-    array("slide_id"     , "INTEGER", "DEFAULT 0"),
-    array("order_num"    , "INTEGER", "DEFAULT 0"),
+    array("list_id"      , "INT", "DEFAULT 0"),
+    array("slide_id"     , "INT", "DEFAULT 0"),
+    array("order_num"    , "INT", "DEFAULT 0"),
   ),
 );