diff options
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 15 |
1 files changed, 15 insertions, 0 deletions
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' -- |