diff options
author | Dries Buytaert <dries@buytaert.net> | 2004-08-17 21:35:26 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2004-08-17 21:35:26 +0000 |
commit | 78b052a6af5fc7c87c807821bfc9267f8007ed7b (patch) | |
tree | adbe5a0b21e963f49faff62f7214a1b0147ae6ad /database | |
parent | eeb2b17b7b932152ff951ef9b82f4f5003907242 (diff) | |
download | brdo-78b052a6af5fc7c87c807821bfc9267f8007ed7b.tar.gz brdo-78b052a6af5fc7c87c807821bfc9267f8007ed7b.tar.bz2 |
- The upload (filehandler) module has landed!
Diffstat (limited to 'database')
-rw-r--r-- | database/database.mysql | 15 | ||||
-rw-r--r-- | database/database.pgsql | 15 | ||||
-rw-r--r-- | database/updates.inc | 18 |
3 files changed, 47 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index 75f1b51c5..f5c3cc967 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -208,6 +208,21 @@ CREATE TABLE directory ( ) 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 @@ -209,6 +209,21 @@ CREATE TABLE directory ( ); -- +-- 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); |