diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-09-27 15:54:39 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-09-27 15:54:39 +0000 |
| commit | 53bdeae273d4dae319f3e01ce8894e961456fa6f (patch) | |
| tree | bc908156a7f7fbf5e8523723fb5db46ffffa6491 /database | |
| parent | f592a5a60b200b62c5c3c82a75d07f7f36ea3906 (diff) | |
| download | brdo-53bdeae273d4dae319f3e01ce8894e961456fa6f.tar.gz brdo-53bdeae273d4dae319f3e01ce8894e961456fa6f.tar.bz2 | |
- Modified patch #30775 by timcn, Souvent22, m3avrck: give file uploads descriptions.
(Modified the form a bit.)
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 1 | ||||
| -rw-r--r-- | database/database.pgsql | 1 | ||||
| -rw-r--r-- | database/updates.inc | 19 |
3 files changed, 20 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index bd8af2646..eea199a22 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -247,6 +247,7 @@ CREATE TABLE files ( nid int(10) unsigned NOT NULL default '0', vid int(10) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', + description 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', diff --git a/database/database.pgsql b/database/database.pgsql index 140e0cbc0..c3cf8738d 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -242,6 +242,7 @@ CREATE TABLE files ( fid SERIAL, nid integer NOT NULL default '0', vid integer NOT NULL default '0', + description varchar(255) NOT NULL default '', filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', diff --git a/database/updates.inc b/database/updates.inc index 1cde1f4bd..988cb3a6f 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -65,7 +65,8 @@ $sql_updates = array( "2005-08-15" => "update_145", "2005-08-25" => "update_146", "2005-09-07" => "update_147", - "2005-09-18" => "update_148" + "2005-09-18" => "update_148", + "2005-09-27" => "update_149" ); function update_110() { @@ -829,6 +830,22 @@ function update_148() { return $ret; } +function update_149() { + $ret = array(); + + switch ($GLOBALS['db_type']) { + case 'pgsql': + case 'mysql': + case 'mysqli': + $ret[] = update_sql("ALTER TABLE {files} ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT ''"); + break; + default: + break; + } + + return $ret; +} + function update_sql($sql) { $edit = $_POST["edit"]; $result = db_query($sql); |