Drupal

The following queries were executed

system module

Update #6000

• ALTER TABLE {boxes} CHANGE COLUMN bid bid int NOT NULL
• REPLACE INTO {sequences} VALUES ('{boxes}_bid', 0)

Update #6001

• ALTER TABLE {term_node} ADD `vid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {term_node} DROP PRIMARY KEY
• ALTER TABLE {term_node} ADD PRIMARY KEY (vid, tid, nid)
• ALTER TABLE {term_node} ADD INDEX vid (vid)

Update #6002

• ALTER TABLE {variable} DROP PRIMARY KEY
• ALTER TABLE {variable} CHANGE name `name` VARCHAR(128) NOT NULL DEFAULT ''
• ALTER TABLE {variable} ADD PRIMARY KEY (name)

Update #6003

• ALTER TABLE {comments} ADD KEY status (status)

Update #6004

• No queries

Update #6005

• ALTER TABLE {url_alias} ADD language varchar(12) NOT NULL default ''
• ALTER TABLE {url_alias} DROP INDEX dst
• ALTER TABLE {url_alias} ADD UNIQUE dst_language (dst, language)

Update #6006

• ALTER TABLE {node_counter} DROP INDEX daycount
• ALTER TABLE {node_counter} DROP INDEX totalcount
• ALTER TABLE {node_counter} DROP INDEX timestamp

Update #6007

• UPDATE {watchdog} SET severity = 5 WHERE severity = 0
• UPDATE {watchdog} SET severity = 4 WHERE severity = 1
• UPDATE {watchdog} SET severity = 3 WHERE severity = 2

Update #6008

• UPDATE {system} SET owner = description
• ALTER TABLE {system} DROP description

Update #6009

• DELETE FROM {filter_formats} WHERE format = 2
• DELETE FROM {filters} WHERE format = 2
• UPDATE {system} SET status = 1 WHERE name = 'php' AND type = 'module'
• INSERT INTO {filter_formats} (name, roles, cache) VALUES ('PHP code', '', 0)
• UPDATE {filters} SET delta = 0, module = 'php' WHERE module = 'filter' AND delta = 1
• UPDATE {filters} SET delta = 1 WHERE module = 'filter' AND delta = 2
• UPDATE {filters} SET delta = 2 WHERE module = 'filter' AND delta = 3

Update #6010

• ALTER TABLE {watchdog} ADD `variables` MEDIUMTEXT DEFAULT NULL
• UPDATE {watchdog} SET variables = '%s' (N;)
• ALTER TABLE {watchdog} CHANGE variables `variables` MEDIUMTEXT NOT NULL

Update #6011

• ALTER TABLE {node} ADD language varchar(12) NOT NULL default ''

Update #6012

• No queries

Update #6013

• No queries

Update #6014

• No queries

Update #6015

• CREATE TABLE {cache_form} ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, serialized int(1) NOT NULL default '0', PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6016

• ALTER TABLE {node} DROP PRIMARY KEY
• ALTER TABLE {node} ADD PRIMARY KEY (nid)
• ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid)
• ALTER TABLE {blocks} ADD bid int NOT NULL AUTO_INCREMENT PRIMARY KEY
• ALTER TABLE {filters} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY
• ALTER TABLE {flood} ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY
• ALTER TABLE {permission} ADD pid int NOT NULL AUTO_INCREMENT PRIMARY KEY
• ALTER TABLE {term_relation} ADD trid int NOT NULL AUTO_INCREMENT PRIMARY KEY
• ALTER TABLE {term_synonym} ADD tsid int NOT NULL AUTO_INCREMENT PRIMARY KEY

Update #6017

• No queries

Update #6018

• No queries

Update #6019

• ALTER TABLE {aggregator_feed} DROP KEY link
• ALTER TABLE {aggregator_feed} ADD UNIQUE KEY url (url)
• ALTER TABLE {boxes} CHANGE format `format` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {comments} CHANGE format `format` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {comments} DROP INDEX lid
• ALTER TABLE {comments} ADD INDEX nid (nid)
• ALTER TABLE {cache} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {cache_filter} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {cache_page} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {cache_form} CHANGE serialized `serialized` SMALLINT NOT NULL DEFAULT 0
• ALTER TABLE {files} CHANGE fid `fid` INT unsigned NOT NULL auto_increment
• SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'
• ALTER TABLE {users} CHANGE uid `uid` INT unsigned NOT NULL auto_increment
• ALTER TABLE {node_revisions} CHANGE vid `vid` INT unsigned NOT NULL auto_increment
• ALTER TABLE {boxes} CHANGE bid `bid` INT NOT NULL auto_increment
• ALTER TABLE {batch} CHANGE bid `bid` INT unsigned NOT NULL auto_increment

Update #6020

• CREATE TABLE {menu_router} ( `path` VARCHAR(255) NOT NULL DEFAULT '', `load_functions` VARCHAR(255) NOT NULL DEFAULT '', `to_arg_functions` VARCHAR(255) NOT NULL DEFAULT '', `access_callback` VARCHAR(255) NOT NULL DEFAULT '', `access_arguments` TEXT DEFAULT NULL, `page_callback` VARCHAR(255) NOT NULL DEFAULT '', `page_arguments` TEXT DEFAULT NULL, `fit` INT NOT NULL DEFAULT 0, `number_parts` SMALLINT NOT NULL DEFAULT 0, `tab_parent` VARCHAR(255) NOT NULL DEFAULT '', `tab_root` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `title_callback` VARCHAR(255) NOT NULL DEFAULT '', `title_arguments` VARCHAR(255) NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 0, `block_callback` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `position` VARCHAR(255) NOT NULL DEFAULT '', `weight` INT NOT NULL DEFAULT 0, `file` MEDIUMTEXT DEFAULT NULL, PRIMARY KEY (path), INDEX fit (fit), INDEX tab_parent (tab_parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
• CREATE TABLE {menu_links} ( `menu_name` VARCHAR(64) NOT NULL DEFAULT '', `mlid` INT unsigned NOT NULL auto_increment, `plid` INT unsigned NOT NULL DEFAULT 0, `link_path` VARCHAR(255) NOT NULL DEFAULT '', `router_path` VARCHAR(255) NOT NULL DEFAULT '', `link_title` VARCHAR(255) NOT NULL DEFAULT '', `options` TEXT DEFAULT NULL, `module` VARCHAR(255) NOT NULL DEFAULT 'system', `hidden` SMALLINT NOT NULL DEFAULT 0, `external` SMALLINT NOT NULL DEFAULT 0, `has_children` SMALLINT NOT NULL DEFAULT 0, `expanded` SMALLINT NOT NULL DEFAULT 0, `weight` INT NOT NULL DEFAULT 0, `depth` SMALLINT NOT NULL DEFAULT 0, `customized` SMALLINT NOT NULL DEFAULT 0, `p1` INT unsigned NOT NULL DEFAULT 0, `p2` INT unsigned NOT NULL DEFAULT 0, `p3` INT unsigned NOT NULL DEFAULT 0, `p4` INT unsigned NOT NULL DEFAULT 0, `p5` INT unsigned NOT NULL DEFAULT 0, `p6` INT unsigned NOT NULL DEFAULT 0, `p7` INT unsigned NOT NULL DEFAULT 0, `p8` INT unsigned NOT NULL DEFAULT 0, `p9` INT unsigned NOT NULL DEFAULT 0, `updated` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (mlid), INDEX path_menu (link_path(128), menu_name), INDEX menu_plid_expand_child (menu_name, plid, expanded, has_children), INDEX menu_parents (menu_name, p1, p2, p3, p4, p5, p6, p7, p8, p9), INDEX router_path (router_path(128)) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6021

• CREATE TABLE {menu_custom} ( `menu_name` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT DEFAULT NULL, PRIMARY KEY (menu_name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6022

• ALTER TABLE {files} DROP INDEX nid
• ALTER TABLE {files} CHANGE nid `uid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {files} ADD `status` INT NOT NULL DEFAULT 0
• ALTER TABLE {files} ADD `timestamp` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {files} ADD INDEX uid (uid)
• ALTER TABLE {files} ADD INDEX status (status)
• ALTER TABLE {files} ADD INDEX timestamp (timestamp)
• ALTER TABLE {file_revisions} DROP INDEX vid
• ALTER TABLE {file_revisions} RENAME TO {upload}
• ALTER TABLE {upload} ADD `nid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {upload} ADD INDEX nid (nid)
• ALTER TABLE {upload} ADD INDEX vid (vid)
• UPDATE {files} f JOIN {node} n ON f.uid = n.nid SET f.uid = n.uid
• UPDATE {upload} u JOIN {node_revisions} r ON u.vid = r.vid SET u.nid = r.nid

Update #6023

• ALTER TABLE {node} DROP KEY nid_vid
• ALTER TABLE {node} DROP KEY vid
• ALTER TABLE {node} CHANGE vid `vid` INT unsigned DEFAULT 0
• ALTER TABLE {node} ADD UNIQUE KEY nid_vid (nid, vid)
• ALTER TABLE {node} ADD UNIQUE KEY vid (vid)
• ALTER TABLE {node_revisions} DROP INDEX nid
• ALTER TABLE {node_revisions} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {node_revisions} ADD INDEX nid (nid)

Update #6024

• ALTER TABLE {node} ADD `tnid` INT unsigned NOT NULL DEFAULT 0
• ALTER TABLE {node} ADD `translate` INT NOT NULL DEFAULT 0
• ALTER TABLE {node} ADD INDEX tnid (tnid)
• ALTER TABLE {node} ADD INDEX translate (translate)

Update #6025

• ALTER TABLE {node} DROP INDEX node_title_type
• ALTER TABLE {node} CHANGE title `title` VARCHAR(255) NOT NULL DEFAULT ''
• ALTER TABLE {node} ADD INDEX node_title_type (title, type(4))
• ALTER TABLE {node_revisions} CHANGE title `title` VARCHAR(255) NOT NULL DEFAULT ''

Update #6026

• CREATE TABLE {cache_update} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6027

• ALTER TABLE {blocks} ADD `cache` TINYINT NOT NULL DEFAULT 0
• CREATE TABLE {cache_block} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6028

• CREATE TABLE {cache_node} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6029

• No queries

comment module

Update #6001

• ALTER TABLE {comments} DROP score
• ALTER TABLE {comments} DROP users