Mercurial > hg > fapweb

changeset 822:fc555d954b99

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add preview_id to entries and the new files table for stored files.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 24 Nov 2014 22:43:22 +0200
parents f27dccdde8ef
children debad9461b00
files dbdefs.inc.php
diffstat 1 files changed, 12 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/dbdefs.inc.php	Mon Nov 24 22:42:17 2014 +0200
+++ b/dbdefs.inc.php	Mon Nov 24 22:43:22 2014 +0200
@@ -285,10 +285,22 @@
     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("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
   ),
+
+  "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("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"),
   ),
 
   "attendees" => array(