diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 3 | ||||
| -rw-r--r-- | database/database.pgsql | 4 | ||||
| -rw-r--r-- | database/updates.inc | 11 |
3 files changed, 15 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 3a02be088..2b7bdc131 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -126,7 +126,8 @@ CREATE TABLE blocks ( custom tinyint(2) DEFAULT '0' NOT NULL, throttle tinyint(1) DEFAULT '0' NOT NULL, visibility tinyint(1) DEFAULT '0' NOT NULL, - pages text NOT NULL + pages text NOT NULL, + types text NOT NULL ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index d2d807f24..de167cd41 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -55,7 +55,9 @@ CREATE TABLE blocks ( region smallint NOT NULL default '0', path varchar(255) NOT NULL default '', custom smallint NOT NULL default '0', - throttle smallint NOT NULL default '0' + throttle smallint NOT NULL default '0', + pages text default '', + types text default '' ); -- diff --git a/database/updates.inc b/database/updates.inc index 34272a0a9..fdcde4c61 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -97,7 +97,8 @@ $sql_updates = array( "2005-01-19" => "update_118", "2005-01-20" => "update_119", "2005-01-25" => "update_120", - "2005-01-26" => "update_121" + "2005-01-26" => "update_121", + "2005-01-27" => "update_122" ); function update_32() { @@ -2169,6 +2170,14 @@ function update_121() { return $ret; } +function update_122() { + + $ret = array(); + $ret[] = update_sql("ALTER TABLE {blocks} ADD type text"); + return $ret; + +} + function update_sql($sql) { $edit = $_POST["edit"]; $result = db_query($sql); |