summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql15
1 files changed, 15 insertions, 0 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'
--