From 78b052a6af5fc7c87c807821bfc9267f8007ed7b Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 17 Aug 2004 21:35:26 +0000
Subject: - The upload (filehandler) module has landed!

---
 database/database.mysql | 15 +++++++++++++++
 database/database.pgsql | 15 +++++++++++++++
 database/updates.inc    | 18 +++++++++++++++++-
 3 files changed, 47 insertions(+), 1 deletion(-)

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index 75f1b51c5..f5c3cc967 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -207,6 +207,21 @@ CREATE TABLE directory (
   PRIMARY KEY  (link)
 ) TYPE=MyISAM;
 
+--
+-- Table structure for table 'files'
+--
+
+CREATE TABLE files (
+  fid int(10) unsigned NOT NULL default '0',
+  nid int(10) unsigned NOT NULL default '0',
+  filename varchar(255) NOT NULL default '',
+  filepath varchar(255) NOT NULL default '',
+  filemime varchar(255) NOT NULL default '',
+  filesize int(10) unsigned NOT NULL default '0',
+  list tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY  (fid)
+) TYPE=MyISAM;
+
 --
 -- Table structure for table 'filter_formats'
 --
diff --git a/database/database.pgsql b/database/database.pgsql
index 8092f0d87..e1103013f 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -208,6 +208,21 @@ CREATE TABLE directory (
   PRIMARY KEY  (link)
 );
 
+--
+-- Table structure for table 'files'
+--
+
+CREATE TABLE files (
+  fid int(10) unsigned NOT NULL default '0',
+  nid int(10) unsigned NOT NULL default '0',
+  filename varchar(255) NOT NULL default '',
+  filepath varchar(255) NOT NULL default '',
+  filemime varchar(255) NOT NULL default '',
+  filesize int(10) unsigned NOT NULL default '0',
+  list tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY  (fid)
+);
+
 --
 -- Table structure for table 'filters'
 --
diff --git a/database/updates.inc b/database/updates.inc
index 799e57f4d..47344f261 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -73,7 +73,8 @@ $sql_updates = array(
   "2004-08-09" => "update_99",
   "2004-08-10" => "update_100",
   "2004-08-11" => "update_101",
-  "2004-08-12" => "update_102"
+  "2004-08-12" => "update_102",
+  "2004-08-17" => "update_103"
 );
 
 function update_32() {
@@ -1506,6 +1507,21 @@ function update_102() {
   return array(update_sql("INSERT INTO {system} (filename, name, type, description, status, throttle, bootstrap) VALUES ('modules/legacy.module', 'legacy', 'module', '', 1, 0, 0)"));
 }
 
+function update_103() {
+  $ret = array();
+  $ret[] = update_sql("CREATE TABLE files (
+    fid int(10) unsigned NOT NULL default '0',
+    nid int(10) unsigned NOT NULL default '0',
+    filename varchar(255) NOT NULL default '',
+    filepath varchar(255) NOT NULL default '',
+    filemime varchar(255) NOT NULL default '',
+    filesize int(10) unsigned NOT NULL default '0',
+    list tinyint(1) unsigned NOT NULL default '0',
+    PRIMARY KEY  (fid)
+  )");
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);
-- 
cgit v1.2.3