Some handy SQL queries to make the move from Drupal 5 to Drupal 6 go better

drupal_to_6.sql

DROP TABLE IF EXISTS cache_form;
DROP TABLE IF EXISTS menu_router;
DROP TABLE IF EXISTS menu_links;
DROP TABLE IF EXISTS menu_custom;

CREATE TABLE IF NOT EXISTS `cache_location` (
`cid` varchar(255) NOT NULL default '', 
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
`serialized` smallint(6) NOT NULL default '0',
PRIMARY KEY  (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `cache_location` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';

CREATE TABLE IF NOT EXISTS `cache_views` (
`cid` varchar(255) NOT NULL default '', 
`data` longblob,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`serialized` smallint(6) NOT NULL default '0',
`headers` text,
PRIMARY KEY  (`cid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `cache_views` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';

# The following seem to potentially cause trouble...

ALTER TABLE `cache` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';

ALTER TABLE `url_alias` ADD `language` varchar(12) NOT NULL;

ALTER TABLE system ADD COLUMN info text NULL default NULL;