Drupal database update
Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.
Reminder: don't forget to set the $access_check value at the top of update.php back to TRUE.
The following queries were executed
system module
Update #129
- ALTER TABLE {vocabulary} ADD tags tinyint(3) unsigned default '0' NOT NULL
Update #130
Update #131
- ALTER TABLE {boxes} DROP INDEX title
Update #132
Update #133
- CREATE TABLE {contact} (
subject varchar(255) NOT NULL default '',
recipients longtext NOT NULL default '',
reply longtext NOT NULL default ''
)
- ALTER TABLE {users} ADD login int(11) NOT NULL default '0'
Update #134
- ALTER TABLE {blocks} DROP types
Update #135
Update #136
- ALTER TABLE {users} CHANGE COLUMN changed access int(11) NOT NULL default '0'
- UPDATE {users} SET access = login WHERE login > created
- UPDATE {users} SET access = created WHERE access = 0
Update #137
- ALTER TABLE {locales_source} CHANGE location location varchar(255) NOT NULL default ''
Update #138
- INSERT INTO {url_alias} (src, dst) VALUES ('node/feed', 'rss.xml')
Update #139
- ALTER TABLE {accesslog} ADD timer int(10) unsigned NOT NULL default '0'
Update #140
- ALTER TABLE {url_alias} ADD INDEX (src)
Update #141
Update #142
Update #143
- ALTER TABLE {contact} CHANGE subject category VARCHAR(255) NOT NULL
- ALTER TABLE {contact} ADD PRIMARY KEY (category)
Update #144
- ALTER TABLE {node} CHANGE type type VARCHAR(32) NOT NULL
Update #145
- ALTER TABLE {blocks} CHANGE region region varchar(64) default 'left' NOT NULL
- ALTER TABLE {blocks} ADD theme varchar(255) NOT NULL default ''
- UPDATE {blocks} SET region = 'left' WHERE region = '0'
- UPDATE {blocks} SET region = 'right' WHERE region = '1'
Update #146
- CREATE TABLE {node_revisions}
SELECT nid, nid AS vid, uid, type, title, body, teaser, changed AS timestamp, format
FROM {node}
- ALTER TABLE {node_revisions} CHANGE nid nid int(10) unsigned NOT NULL default '0'
- ALTER TABLE {node_revisions} ADD log longtext
- ALTER TABLE {node} ADD vid int(10) unsigned NOT NULL default '0'
- ALTER TABLE {files} ADD vid int(10) unsigned NOT NULL default '0'
- ALTER TABLE {book} ADD vid int(10) unsigned NOT NULL default '0'
- ALTER TABLE {forum} ADD vid int(10) unsigned NOT NULL default '0'
- ALTER TABLE {book} DROP PRIMARY KEY
- ALTER TABLE {forum} DROP PRIMARY KEY
- ALTER TABLE {files} DROP PRIMARY KEY
- UPDATE {node} SET vid = nid
- UPDATE {forum} SET vid = nid
- UPDATE {book} SET vid = nid
- UPDATE {files} SET vid = nid
- ALTER TABLE {book} ADD PRIMARY KEY vid (vid)
- ALTER TABLE {forum} ADD PRIMARY KEY vid (vid)
- ALTER TABLE {node_revisions} ADD PRIMARY KEY vid (vid)
- ALTER TABLE {node_revisions} ADD KEY nid (nid)
- ALTER TABLE {node_revisions} ADD KEY uid (uid)
- CREATE TABLE {old_revisions} SELECT nid, type, revisions FROM {node} WHERE revisions != ''
- ALTER TABLE {book} ADD KEY nid (nid)
- ALTER TABLE {forum} ADD KEY nid (nid)
- ALTER TABLE {files} ADD KEY fid (fid)
- ALTER TABLE {files} ADD KEY vid (vid)
- INSERT INTO {sequences} (name, id) VALUES ('{node_revisions}_vid', 20)
- ALTER TABLE {book} DROP log
- ALTER TABLE {node} DROP teaser
- ALTER TABLE {node} DROP body
- ALTER TABLE {node} DROP format
- ALTER TABLE {node} DROP revisions
Update #147
- ALTER TABLE {node_revisions} DROP type
Update #148
- ALTER TABLE {accesslog} ADD sid varchar(32) NOT NULL default ''
Update #149
- ALTER TABLE {files} ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT ''
Update #150
- DELETE FROM {variable} WHERE name = 'node_cron_last'
- DELETE FROM {variable} WHERE name = 'minimum_word_size'
- DELETE FROM {variable} WHERE name = 'remove_short'
- DELETE FROM {node_counter} WHERE nid = 0
- DROP TABLE {search_index}
- DROP TABLE {search_total}
- CREATE TABLE {search_dataset} (
sid int(10) unsigned NOT NULL default '0',
type varchar(16) default NULL,
data longtext NOT NULL,
KEY sid_type (sid, type)
)
- CREATE TABLE {search_index} (
word varchar(50) NOT NULL default '',
sid int(10) unsigned NOT NULL default '0',
type varchar(16) default NULL,
fromsid int(10) unsigned NOT NULL default '0',
fromtype varchar(16) default NULL,
score float default NULL,
KEY sid_type (sid, type),
KEY from_sid_type (fromsid, fromtype),
KEY word (word)
)
- CREATE TABLE {search_total} (
word varchar(50) NOT NULL default '',
count float default NULL,
PRIMARY KEY word (word)
)
Update #151
- INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (39, 0, '', 'Primary links', '', 0, 115)
- INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (40, 0, '', 'Secondary links', '', 0, 115)
- UPDATE {system} SET status = 1 WHERE name = 'menu'
Update #152
Update #153
- ALTER TABLE {contact} DROP PRIMARY KEY
- ALTER TABLE {contact} ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment
- ALTER TABLE {contact} ADD UNIQUE KEY category (category)
Update #154
- ALTER TABLE {contact} ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0
- ALTER TABLE {contact} ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0
Update #155
Update #156
Update #157
- DELETE FROM {url_alias} WHERE src = 'node/feed' AND dst = 'rss.xml'
- INSERT INTO {url_alias} (src, dst) VALUES ('rss.xml', 'node/feed')
Update #158
- ALTER TABLE {old_revisions} ADD done tinyint(1) NOT NULL DEFAULT 0
- ALTER TABLE {old_revisions} ADD INDEX (done)
Update #159
- UPDATE {sequences} SET id = 21 WHERE name = '{node_revisions}_vid'
- ALTER TABLE {old_revisions} DROP done
Update #160
Update #161
Update #162
Update #163
- ALTER TABLE {cache} CHANGE data data LONGBLOB
Update #164
- CREATE TABLE {poll_votes} (
nid int(10) unsigned NOT NULL,
uid int(10) unsigned NOT NULL default 0,
hostname varchar(128) NOT NULL default '',
INDEX (nid),
INDEX (uid),
INDEX (hostname)
)
- ALTER TABLE {poll} DROP polled
Update #165
Update #166
- DROP TABLE {directory}
- CREATE TABLE {client} (
cid int(10) unsigned NOT NULL auto_increment,
link varchar(255) NOT NULL default '',
name varchar(128) NOT NULL default '',
mail varchar(128) NOT NULL default '',
slogan longtext NOT NULL,
mission longtext NOT NULL,
users int(10) NOT NULL default '0',
nodes int(10) NOT NULL default '0',
version varchar(35) NOT NULL default'',
created int(11) NOT NULL default '0',
changed int(11) NOT NULL default '0',
PRIMARY KEY (cid)
)
- CREATE TABLE {client_system} (
cid int(10) NOT NULL default '0',
name varchar(255) NOT NULL default '',
type varchar(255) NOT NULL default '',
PRIMARY KEY (cid,name)
)
Update #167
- ALTER TABLE {vocabulary_node_types} CHANGE type type varchar(32) NOT NULL default ''
Update #168
- ALTER TABLE {term_hierarchy} ADD PRIMARY KEY (tid, parent)
Update #169
- ALTER TABLE {accesslog} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {accesslog} CHANGE `title` `title` varbinary(255) DEFAULT ''
NULL, CHANGE `path` `path` varbinary(255) DEFAULT '' NULL, CHANGE `url`
`url` varbinary(255) DEFAULT '' NULL, CHANGE `hostname` `hostname`
varbinary(128) DEFAULT '' NULL, CHANGE `sid` `sid` varbinary(32)
DEFAULT '' NOT NULL
- ALTER TABLE {accesslog}
CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL,
CHANGE `path` `path` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL,
CHANGE `url` `url` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL,
CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT ''
NULL, CHANGE `sid` `sid` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT
NULL
- ALTER TABLE {aggregator_category} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {aggregator_category} CHANGE `title` `title` varbinary(255)
DEFAULT '' NOT NULL, CHANGE `description` `description` longblob
DEFAULT '' NOT NULL
- ALTER TABLE
{aggregator_category} CHANGE `title` `title` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext
CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {aggregator_category_feed} DEFAULT CHARACTER SET utf8
- ALTER TABLE {aggregator_category_item} DEFAULT CHARACTER SET utf8
- ALTER TABLE {aggregator_feed} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {aggregator_feed} CHANGE `title` `title` varbinary(255) DEFAULT
'' NOT NULL, CHANGE `url` `url` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE
`description` `description` longblob DEFAULT '' NOT NULL, CHANGE
`image` `image` longblob DEFAULT '' NOT NULL, CHANGE `etag` `etag`
varbinary(255) DEFAULT '' NOT NULL
- ALTER TABLE
{aggregator_feed} CHANGE `title` `title` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `url` `url` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description`
longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `image` `image`
longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `etag` `etag`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {aggregator_item} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {aggregator_item} CHANGE `title` `title` varbinary(255) DEFAULT
'' NOT NULL, CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `author` `author` varbinary(255) DEFAULT '' NOT NULL, CHANGE
`description` `description` longblob DEFAULT '' NOT NULL
- ALTER
TABLE {aggregator_item} CHANGE `title` `title` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `author` `author`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE
`description` `description` longtext CHARACTER SET utf8 DEFAULT '' NOT
NULL
- ALTER TABLE {authmap} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {authmap} CHANGE `authname` `authname` varbinary(128) DEFAULT ''
NOT NULL, CHANGE `module` `module` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {authmap} CHANGE `authname` `authname` varchar(128) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `module` `module` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {blocks} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {blocks} CHANGE `module` `module` varbinary(64) DEFAULT '' NOT
NULL, CHANGE `delta` `delta` varbinary(32) DEFAULT '0' NOT NULL, CHANGE
`region` `region` varbinary(64) DEFAULT 'left' NOT NULL, CHANGE `pages`
`pages` blob DEFAULT '' NOT NULL, CHANGE `theme` `theme` varbinary(255)
DEFAULT '' NOT NULL
- ALTER TABLE {blocks} CHANGE
`module` `module` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL,
CHANGE `delta` `delta` varchar(32) CHARACTER SET utf8 DEFAULT '0' NOT
NULL, CHANGE `region` `region` varchar(64) CHARACTER SET utf8 DEFAULT
'left' NOT NULL, CHANGE `pages` `pages` text CHARACTER SET utf8 DEFAULT
'' NOT NULL, CHANGE `theme` `theme` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL
- ALTER TABLE {book} DEFAULT CHARACTER SET utf8
- ALTER TABLE {boxes} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {boxes} CHANGE `title` `title` varbinary(64) DEFAULT '' NOT NULL,
CHANGE `body` `body` longblob DEFAULT '' NULL, CHANGE `info` `info`
varbinary(128) DEFAULT '' NOT NULL
- ALTER TABLE
{boxes} CHANGE `title` `title` varchar(64) CHARACTER SET utf8 DEFAULT
'' NOT NULL, CHANGE `body` `body` longtext CHARACTER SET utf8 DEFAULT
'' NULL, CHANGE `info` `info` varchar(128) CHARACTER SET utf8 DEFAULT
'' NOT NULL
- ALTER TABLE {cache} DEFAULT CHARACTER SET utf8
- ALTER TABLE {cache} CHANGE `cid` `cid` varbinary(255) DEFAULT '' NOT NULL, CHANGE `headers` `headers` blob DEFAULT '' NULL
- ALTER
TABLE {cache} CHANGE `cid` `cid` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `headers` `headers` text CHARACTER SET utf8
DEFAULT '' NULL
- ALTER TABLE {comments} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {comments} CHANGE `subject` `subject` varbinary(64) DEFAULT ''
NOT NULL, CHANGE `comment` `comment` longblob DEFAULT '' NOT NULL,
CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE
`thread` `thread` varbinary(255) DEFAULT '' NOT NULL, CHANGE `users`
`users` longblob DEFAULT '' NULL, CHANGE `name` `name` varbinary(60)
DEFAULT '' NULL, CHANGE `mail` `mail` varbinary(64) DEFAULT '' NULL,
CHANGE `homepage` `homepage` varbinary(255) DEFAULT '' NULL
- ALTER
TABLE {comments} CHANGE `subject` `subject` varchar(64) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `comment` `comment` longtext CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `thread` `thread`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `users`
`users` longtext CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `name`
`name` varchar(60) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `mail`
`mail` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE
`homepage` `homepage` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {contact} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {contact} CHANGE `category` `category` varbinary(255) DEFAULT ''
NOT NULL, CHANGE `recipients` `recipients` longblob DEFAULT '' NOT
NULL, CHANGE `reply` `reply` longblob DEFAULT '' NOT NULL
- ALTER
TABLE {contact} CHANGE `category` `category` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `recipients` `recipients` longtext
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `reply` `reply` longtext
CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {node_comment_statistics} DEFAULT CHARACTER SET utf8
- ALTER TABLE {node_comment_statistics} CHANGE `last_comment_name` `last_comment_name` varbinary(60) DEFAULT '' NULL
- ALTER
TABLE {node_comment_statistics} CHANGE `last_comment_name`
`last_comment_name` varchar(60) CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {client} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {client} CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `name` `name` varbinary(128) DEFAULT '' NOT NULL, CHANGE `mail`
`mail` varbinary(128) DEFAULT '' NOT NULL, CHANGE `slogan` `slogan`
longblob DEFAULT '' NOT NULL, CHANGE `mission` `mission` longblob
DEFAULT '' NOT NULL, CHANGE `version` `version` varbinary(35) DEFAULT
'' NOT NULL
- ALTER TABLE {client} CHANGE `link`
`link` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE
`name` `name` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL,
CHANGE `mail` `mail` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT
NULL, CHANGE `slogan` `slogan` longtext CHARACTER SET utf8 DEFAULT ''
NOT NULL, CHANGE `mission` `mission` longtext CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `version` `version` varchar(35) CHARACTER
SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {client_system} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {client_system} CHANGE `name` `name` varbinary(255) DEFAULT ''
NOT NULL, CHANGE `type` `type` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {client_system} CHANGE `name` `name` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {files} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {files} CHANGE `filename` `filename` varbinary(255) DEFAULT ''
NOT NULL, CHANGE `filepath` `filepath` varbinary(255) DEFAULT '' NOT
NULL, CHANGE `filemime` `filemime` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `description` `description` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {files} CHANGE `filename` `filename` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `filepath` `filepath` varchar(255)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `filemime` `filemime`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE
`description` `description` varchar(255) CHARACTER SET utf8 DEFAULT ''
NOT NULL
- ALTER TABLE {filter_formats} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {filter_formats} CHANGE `name` `name` varbinary(255) DEFAULT ''
NOT NULL, CHANGE `roles` `roles` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {filter_formats} CHANGE `name` `name` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `roles` `roles` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {filters} DEFAULT CHARACTER SET utf8
- ALTER TABLE {filters} CHANGE `module` `module` varbinary(64) DEFAULT '' NOT NULL
- ALTER TABLE {filters} CHANGE `module` `module` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {flood} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {flood} CHANGE `event` `event` varbinary(64) DEFAULT '' NOT NULL,
CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {flood} CHANGE `event` `event` varchar(64) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {forum} DEFAULT CHARACTER SET utf8
- ALTER TABLE {history} DEFAULT CHARACTER SET utf8
- ALTER TABLE {locales_meta} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {locales_meta} CHANGE `locale` `locale` varbinary(12) DEFAULT ''
NOT NULL, CHANGE `name` `name` varbinary(64) DEFAULT '' NOT NULL,
CHANGE `formula` `formula` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {locales_meta} CHANGE `locale` `locale` varchar(12) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `name` `name` varchar(64) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `formula` `formula` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {locales_source} DEFAULT CHARACTER SET utf8
- ALTER TABLE {locales_source} CHANGE `location` `location` varbinary(255) DEFAULT '' NOT NULL
- ALTER TABLE {locales_source} CHANGE `location` `location` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {locales_target} DEFAULT CHARACTER SET utf8
- ALTER TABLE {locales_target} CHANGE `locale` `locale` varbinary(12) DEFAULT '' NOT NULL
- ALTER TABLE {locales_target} CHANGE `locale` `locale` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {menu} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {menu} CHANGE `path` `path` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `title` `title` varbinary(255) DEFAULT '' NOT NULL, CHANGE
`description` `description` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {menu} CHANGE `path` `path` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `title` `title` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `description` `description`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {node} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {node} CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL,
CHANGE `title` `title` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {node} CHANGE `type` `type` varchar(32) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `title` `title` varchar(128) CHARACTER SET
utf8 DEFAULT '' NOT NULL
- ALTER TABLE {node_access} DEFAULT CHARACTER SET utf8
- ALTER TABLE {node_access} CHANGE `realm` `realm` varbinary(255) DEFAULT '' NOT NULL
- ALTER TABLE {node_access} CHANGE `realm` `realm` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {node_revisions} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {node_revisions} CHANGE `title` `title` varbinary(128) DEFAULT ''
NOT NULL, CHANGE `body` `body` longblob DEFAULT '' NOT NULL, CHANGE
`teaser` `teaser` longblob DEFAULT '' NOT NULL, CHANGE `log` `log`
longblob DEFAULT '' NULL
- ALTER TABLE
{node_revisions} CHANGE `title` `title` varchar(128) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `body` `body` longtext CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `teaser` `teaser` longtext CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `log` `log` longtext CHARACTER SET
utf8 DEFAULT '' NULL
- ALTER TABLE {profile_fields} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {profile_fields} CHANGE `title` `title` varbinary(255) DEFAULT ''
NULL, CHANGE `name` `name` varbinary(128) DEFAULT '' NULL, CHANGE
`explanation` `explanation` blob DEFAULT '' NULL, CHANGE `category`
`category` varbinary(255) DEFAULT '' NULL, CHANGE `page` `page`
varbinary(255) DEFAULT '' NULL, CHANGE `type` `type` varbinary(128)
DEFAULT '' NULL, CHANGE `options` `options` blob DEFAULT '' NULL
- ALTER
TABLE {profile_fields} CHANGE `title` `title` varchar(255) CHARACTER
SET utf8 DEFAULT '' NULL, CHANGE `name` `name` varchar(128) CHARACTER
SET utf8 DEFAULT '' NULL, CHANGE `explanation` `explanation` text
CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `category` `category`
varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `page` `page`
varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `type` `type`
varchar(128) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `options`
`options` text CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {profile_values} DEFAULT CHARACTER SET utf8
- ALTER TABLE {profile_values} CHANGE `value` `value` blob DEFAULT '' NULL
- ALTER TABLE {profile_values} CHANGE `value` `value` text CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {url_alias} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {url_alias} CHANGE `src` `src` varbinary(128) DEFAULT '' NOT
NULL, CHANGE `dst` `dst` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {url_alias} CHANGE `src` `src` varchar(128) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `dst` `dst` varchar(128) CHARACTER SET utf8
DEFAULT '' NOT NULL
- ALTER TABLE {permission} DEFAULT CHARACTER SET utf8
- ALTER TABLE {permission} CHANGE `perm` `perm` longblob DEFAULT '' NULL
- ALTER TABLE {permission} CHANGE `perm` `perm` longtext CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {poll} DEFAULT CHARACTER SET utf8
- ALTER TABLE {poll_votes} DEFAULT CHARACTER SET utf8
- ALTER TABLE {poll_votes} CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL
- ALTER TABLE {poll_votes} CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {poll_choices} DEFAULT CHARACTER SET utf8
- ALTER TABLE {poll_choices} CHANGE `chtext` `chtext` varbinary(128) DEFAULT '' NOT NULL
- ALTER TABLE {poll_choices} CHANGE `chtext` `chtext` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {role} DEFAULT CHARACTER SET utf8
- ALTER TABLE {role} CHANGE `name` `name` varbinary(32) DEFAULT '' NOT NULL
- ALTER TABLE {role} CHANGE `name` `name` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {search_dataset} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {search_dataset} CHANGE `type` `type` varbinary(16) DEFAULT ''
NULL, CHANGE `data` `data` longblob DEFAULT '' NOT NULL
- ALTER
TABLE {search_dataset} CHANGE `type` `type` varchar(16) CHARACTER SET
utf8 DEFAULT '' NULL, CHANGE `data` `data` longtext CHARACTER SET utf8
DEFAULT '' NOT NULL
- ALTER TABLE {search_index} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {search_index} CHANGE `word` `word` varbinary(50) DEFAULT '' NOT
NULL, CHANGE `type` `type` varbinary(16) DEFAULT '' NULL, CHANGE
`fromtype` `fromtype` varbinary(16) DEFAULT '' NULL
- ALTER
TABLE {search_index} CHANGE `word` `word` varchar(50) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(16) CHARACTER
SET utf8 DEFAULT '' NULL, CHANGE `fromtype` `fromtype` varchar(16)
CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {search_total} DEFAULT CHARACTER SET utf8
- ALTER TABLE {search_total} CHANGE `word` `word` varbinary(50) DEFAULT '' NOT NULL
- ALTER TABLE {search_total} CHANGE `word` `word` varchar(50) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {sessions} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {sessions} CHANGE `sid` `sid` varbinary(32) DEFAULT '' NOT NULL,
CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE
`session` `session` longblob DEFAULT '' NULL
- ALTER
TABLE {sessions} CHANGE `sid` `sid` varchar(32) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `session` `session`
longtext CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {sequences} DEFAULT CHARACTER SET utf8
- ALTER TABLE {sequences} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL
- ALTER TABLE {sequences} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {node_counter} DEFAULT CHARACTER SET utf8
- ALTER TABLE {system} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {system} CHANGE `filename` `filename` varbinary(255) DEFAULT ''
NOT NULL, CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL,
CHANGE `type` `type` varbinary(255) DEFAULT '' NOT NULL, CHANGE
`description` `description` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {system} CHANGE `filename` `filename` varchar(255) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `name` `name` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(255)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description`
`description` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {term_data} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {term_data} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT
NULL, CHANGE `description` `description` longblob DEFAULT '' NULL
- ALTER
TABLE {term_data} CHANGE `name` `name` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `description` `description` longtext
CHARACTER SET utf8 DEFAULT '' NULL
- ALTER TABLE {term_hierarchy} DEFAULT CHARACTER SET utf8
- ALTER TABLE {term_node} DEFAULT CHARACTER SET utf8
- ALTER TABLE {term_relation} DEFAULT CHARACTER SET utf8
- ALTER TABLE {term_synonym} DEFAULT CHARACTER SET utf8
- ALTER TABLE {term_synonym} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL
- ALTER TABLE {term_synonym} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {users} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {users} CHANGE `name` `name` varbinary(60) DEFAULT '' NOT NULL,
CHANGE `pass` `pass` varbinary(32) DEFAULT '' NOT NULL, CHANGE `mail`
`mail` varbinary(64) DEFAULT '' NULL, CHANGE `theme` `theme`
varbinary(255) DEFAULT '' NOT NULL, CHANGE `signature` `signature`
varbinary(255) DEFAULT '' NOT NULL, CHANGE `timezone` `timezone`
varbinary(8) DEFAULT '' NULL, CHANGE `language` `language`
varbinary(12) DEFAULT '' NOT NULL, CHANGE `picture` `picture`
varbinary(255) DEFAULT '' NOT NULL, CHANGE `init` `init` varbinary(64)
DEFAULT '' NULL, CHANGE `data` `data` longblob DEFAULT '' NULL
- ALTER
TABLE {users} CHANGE `name` `name` varchar(60) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `pass` `pass` varchar(32) CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `mail` `mail` varchar(64) CHARACTER
SET utf8 DEFAULT '' NULL, CHANGE `theme` `theme` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `signature` `signature`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `timezone`
`timezone` varchar(8) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE
`language` `language` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT
NULL, CHANGE `picture` `picture` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `init` `init` varchar(64) CHARACTER SET
utf8 DEFAULT '' NULL, CHANGE `data` `data` longtext CHARACTER SET utf8
DEFAULT '' NULL
- ALTER TABLE {users_roles} DEFAULT CHARACTER SET utf8
- ALTER TABLE {variable} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {variable} CHANGE `name` `name` varbinary(48) DEFAULT '' NOT
NULL, CHANGE `value` `value` longblob DEFAULT '' NOT NULL
- ALTER
TABLE {variable} CHANGE `name` `name` varchar(48) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `value` `value` longtext CHARACTER SET utf8
DEFAULT '' NOT NULL
- ALTER TABLE {vocabulary} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {vocabulary} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT
NULL, CHANGE `description` `description` longblob DEFAULT '' NULL,
CHANGE `help` `help` varbinary(255) DEFAULT '' NOT NULL, CHANGE
`module` `module` varbinary(255) DEFAULT '' NOT NULL
- ALTER
TABLE {vocabulary} CHANGE `name` `name` varchar(255) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `description` `description` longtext
CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `help` `help` varchar(255)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `module` `module`
varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {vocabulary_node_types} DEFAULT CHARACTER SET utf8
- ALTER TABLE {vocabulary_node_types} CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL
- ALTER TABLE {vocabulary_node_types} CHANGE `type` `type` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL
- ALTER TABLE {watchdog} DEFAULT CHARACTER SET utf8
- ALTER
TABLE {watchdog} CHANGE `type` `type` varbinary(16) DEFAULT '' NOT
NULL, CHANGE `message` `message` longblob DEFAULT '' NOT NULL, CHANGE
`link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE `location`
`location` varbinary(128) DEFAULT '' NOT NULL, CHANGE `hostname`
`hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE `referer`
`referer` varbinary(128) DEFAULT '' NOT NULL
- ALTER
TABLE {watchdog} CHANGE `type` `type` varchar(16) CHARACTER SET utf8
DEFAULT '' NOT NULL, CHANGE `message` `message` longtext CHARACTER SET
utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255) CHARACTER
SET utf8 DEFAULT '' NOT NULL, CHANGE `location` `location` varchar(128)
CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname`
varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `referer`
`referer` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
Update #170
Update #171
- DELETE FROM {users_roles} WHERE rid IN (1, 2)
Update #172
Update #173
- CREATE TABLE {files_backup} SELECT * FROM {files}
- DELETE FROM {files} WHERE fid = 0
- UPDATE {files} SET vid = nid WHERE vid = 0
- CREATE TABLE {files_tmp} SELECT * FROM {files}
- DROP TABLE {files}
- CREATE TABLE {file_revisions} (
fid int(10) unsigned NOT NULL default 0,
vid int(10) unsigned NOT NULL default 0,
description varchar(255) NOT NULL default '',
list tinyint(1) unsigned NOT NULL default 0,
PRIMARY KEY (fid, vid)
) /*!40100 DEFAULT CHARACTER SET utf8 */
- INSERT INTO {file_revisions} SELECT DISTINCT fid , vid, description, list FROM {files_tmp}
- 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,
PRIMARY KEY (fid)
) /*!40100 DEFAULT CHARACTER SET utf8 */
- INSERT INTO {files} SELECT DISTINCT fid, nid, filename, filepath, filemime, filesize FROM {files_tmp}
- DROP TABLE {files_tmp}
- DROP TABLE {files_backup}
Update #174
Update #175
Update #176
- ALTER TABLE {filter_formats} ADD UNIQUE (name)
Update #177
Update #178
Update #179