diff dbdefs.inc.php @ 846:e0c9bf182bb7

More work, another database change :S
author Matti Hamalainen <ccr@tnsp.org>
date Tue, 25 Nov 2014 23:54:38 +0200
parents 044ee3aa32e3
children d0b6daedd21c
line wrap: on
line diff
--- a/dbdefs.inc.php	Tue Nov 25 23:49:41 2014 +0200
+++ b/dbdefs.inc.php	Tue Nov 25 23:54:38 2014 +0200
@@ -1,6 +1,6 @@
 <?
 
-$dbVersion = 25;
+$dbVersion = 26;
 
 //
 // Site settings and defaults we put in
@@ -284,8 +284,8 @@
     array("notes"        , "VARCHAR(".SET_LEN_ENTRY_NOTES.")", "DEFAULT NULL"),
     array("flags"        , "INT", "DEFAULT 0"),
     array("evalue"       , "INT", "DEFAULT 0"),
-    array("file_id"      , "INT", "DEFAULT 0"), // currently default file from "files" table
-    array("preview_id"   , "INT", "DEFAULT 0"), // currently default preview from "files" table
+    array("file_id"      , "INT", "DEFAULT 0"), // uploaded file id from "files" table
+    array("preview_id"   , "INT", "DEFAULT 0"), // uploaded preview file id from "files" table
     array("preview_type" , "INT", "DEFAULT 0"), // see EPREV_*, overrides compo's general type if != 0
     array("utime"        , "INT", "DEFAULT 0"),
     array("owner_id"     , "INT", "DEFAULT 0"), // 0 = admin, otherwise votekey id
@@ -293,13 +293,12 @@
 
   "files" => array(
     array("id"           , "INTEGER", "PRIMARY KEY", "AUTOINCREMENT"),
-    array("orig_filename", "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"), // original uploaded filename
     array("filename"     , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"), // stored filename
+    array("origname"     , "VARCHAR(".SET_LEN_ENTRY_FILENAME.")", "DEFAULT NULL"), // original uploaded filename
     array("filetype"     , "VARCHAR(32)", "DEFAULT NULL"), // type of the file, if any, as key from $fileTypeData
     array("filesize"     , "INT", "DEFAULT 0"), // uploaded size
     array("entry_id"     , "INT", "DEFAULT 0"), // belongs to this entry (0 = none)
     array("uploader_id"  , "INT", "DEFAULT 0"), // 0 = admin, otherwise votekey id
-    array("deleted"      , "INT", "DEFAULT 0"), // 0 = ok, 1 = to be deleted (don't show in filelists)
     array("utime"        , "INT", "DEFAULT 0"),
   ),