Newer
Older
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
variable_set($menus[$loop]['menu_var'], 0);
}
else {
variable_set($menus[$loop]['menu_var'], $menus[$loop]['pid']);
}
variable_del($menus[$loop]['toggle_var']);
unset($ts[$menus[$loop]['toggle_var']]);
variable_del($menus[$loop]['links_var']);
unset($ts[$menus[$loop]['links_var']]);
variable_del($menus[$loop]['more_var']);
unset($ts[$menus[$loop]['more_var']]);
}
if (is_array($ts)) {
variable_set('theme_settings', $ts);
}
$ret[] = update_sql("UPDATE {system} SET status = 1 WHERE name = 'menu'");
return $ret;
}
function system_update_152() {
$ret = array();
// Postgresql only update
switch ($GLOBALS['db_type']) {
case 'pgsql':
$ret[] = update_sql("ALTER TABLE {forum} RENAME shadow TO shadow_old");
break;
case 'mysql':
case 'mysqli':
break;
}
return $ret;
}
function system_update_153(){
$ret = array();
switch ($GLOBALS['db_type']) {
case 'pgsql':
$ret[] = update_sql("ALTER TABLE {contact} DROP CONSTRAINT {contact}_pkey");
$ret[] = update_sql("CREATE SEQUENCE {contact}_cid_seq");
db_add_column($ret, 'contact', 'cid', 'int', array('not null' => TRUE, 'default' => "nextval('{contact}_cid_seq')"));
$ret[] = update_sql("ALTER TABLE {contact} ADD PRIMARY KEY (cid)");
$ret[] = update_sql("ALTER TABLE {contact} ADD CONSTRAINT {contact}_category_key UNIQUE (category)");
break;
case 'mysql':
case 'mysqli':
$ret[] = update_sql("ALTER TABLE {contact} DROP PRIMARY KEY");
$ret[] = update_sql("ALTER TABLE {contact} ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment");
$ret[] = update_sql("ALTER TABLE {contact} ADD UNIQUE KEY category (category)");
break;
}
return $ret;
}
function system_update_154() {
$ret = array();
switch ($GLOBALS['db_type']) {
case 'pgsql':
db_add_column($ret, 'contact', 'weight', 'smallint', array('not null' => TRUE, 'default' => 0));
db_add_column($ret, 'contact', 'selected', 'smallint', array('not null' => TRUE, 'default' => 0));
break;
case 'mysql':
case 'mysqli':
$ret[] = update_sql("ALTER TABLE {contact} ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0");
$ret[] = update_sql("ALTER TABLE {contact} ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0");
break;
}
return $ret;
}
function system_update_155() {
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
$ret = array();
// Postgresql only update
switch ($GLOBALS['db_type']) {
case 'pgsql':
$ret[] = update_sql("DROP TABLE {cache}");
$ret[] = update_sql("CREATE TABLE {cache} (
cid varchar(255) NOT NULL default '',
data bytea default '',
expire integer NOT NULL default '0',
created integer NOT NULL default '0',
headers text default '',
PRIMARY KEY (cid)
)");
$ret[] = update_sql("CREATE INDEX {cache}_expire_idx ON {cache}(expire)");
break;
case 'mysql':
case 'mysqli':
break;
}
return $ret;
}
function system_update_156() {
$ret = array();
$ret[] = update_sql("DELETE FROM {cache}");
system_themes();

Dries Buytaert
committed
function system_update_157() {
$ret = array();
$ret[] = update_sql("DELETE FROM {url_alias} WHERE src = 'node/feed' AND dst = 'rss.xml'");
$ret[] = update_sql("INSERT INTO {url_alias} (src, dst) VALUES ('rss.xml', 'node/feed')");