SNmkfGx9

1DROP TABLE IF EXISTS cache_form;
2DROP TABLE IF EXISTS menu_router;
3DROP TABLE IF EXISTS menu_links;
4DROP TABLE IF EXISTS menu_custom;
5
6CREATE TABLE IF NOT EXISTS `cache_location` (
7`cid` varchar(255) NOT NULL default '', 
8`data` longblob,
9`expire` int(11) NOT NULL default '0',
10`created` int(11) NOT NULL default '0',
11`headers` text,
12`serialized` smallint(6) NOT NULL default '0',
13PRIMARY KEY  (`cid`),
14KEY `expire` (`expire`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
17ALTER TABLE `cache_location` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';
18
19CREATE TABLE IF NOT EXISTS `cache_views` (
20`cid` varchar(255) NOT NULL default '', 
21`data` longblob,
22`expire` int(11) NOT NULL default '0',
23`created` int(11) NOT NULL default '0',
24`serialized` smallint(6) NOT NULL default '0',
25`headers` text,
26PRIMARY KEY  (`cid`),
27KEY `expire` (`expire`)
28) ENGINE=MyISAM DEFAULT CHARSET=utf8;
29
30ALTER TABLE `cache_views` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';
31
32# The following seem to potentially cause trouble...
33
34ALTER TABLE `cache` ADD COLUMN `serialized` smallint(6) NOT NULL default '0';
35
36ALTER TABLE `url_alias` ADD `language` varchar(12) NOT NULL;
37
38ALTER TABLE system ADD COLUMN info text NULL default NULL;