diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 5 | ||||
| -rw-r--r-- | database/updates.inc | 16 |
2 files changed, 18 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index b1e926325..884aa8b35 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -121,9 +121,10 @@ CREATE TABLE blocks ( status tinyint(2) DEFAULT '0' NOT NULL, weight tinyint(1) DEFAULT '0' NOT NULL, region tinyint(1) DEFAULT '0' NOT NULL, - path varchar(255) DEFAULT '' NOT NULL, custom tinyint(2) DEFAULT '0' NOT NULL, - throttle tinyint(1) DEFAULT '0' NOT NULL + throttle tinyint(1) DEFAULT '0' NOT NULL, + visibility tinyint(1) DEFAULT '0' NOT NULL, + pages text NOT NULL ) TYPE=MyISAM; -- diff --git a/database/updates.inc b/database/updates.inc index 894b825b0..444487244 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -86,7 +86,7 @@ $sql_updates = array( "2004-09-17" => "update_107", "2004-10-16" => "update_108", "2004-10-18" => "update_109", - "2004-10-28: first update since Drupal 4.5.0 release" => "update_110" + "2004-10-31: first update since Drupal 4.5.0 release" => "update_110" ); function update_32() { @@ -1927,6 +1927,10 @@ function update_110() { // TODO: needs PGSQL version if ($GLOBALS['db_type'] == 'mysql') { + /* + ** Search + */ + $ret[] = update_sql('DROP TABLE {search_index}'); $ret[] = update_sql("CREATE TABLE {search_index} ( word varchar(50) NOT NULL default '', @@ -1946,8 +1950,18 @@ function update_110() { ) TYPE=MyISAM"); $ret[] = update_sql("DELETE FROM {variable} WHERE name = 'node_cron_last'"); + + /* + ** Blocks + */ + + $ret[] = update_sql('ALTER TABLE {blocks} DROP path'); + $ret[] = update_sql('ALTER TABLE {blocks} ADD visibility tinyint(1) NOT NULL'); + $ret[] = update_sql('ALTER TABLE {blocks} ADD pages text NOT NULL'); } + $ret[] = update_sql('UPDATE {blocks} SET status = 1, custom = 2 WHERE status = 0 AND custom = 1'); + return $ret; } |