DROP TABLE `cache_shared`;

ALTER TABLE `cache` DROP INDEX `expires_index`;
ALTER TABLE `cache_index` DROP INDEX `expires_index`;
ALTER TABLE `cache_thread` DROP INDEX `expires_index`;
ALTER TABLE `cache_messages` DROP INDEX `expires_index`;

ALTER TABLE `cache` DROP `expires`;
ALTER TABLE `cache_index` DROP `expires`;
ALTER TABLE `cache_thread` DROP `expires`;
ALTER TABLE `cache_messages` DROP `expires`;

ALTER TABLE `cache_index` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
ALTER TABLE `cache_thread` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
ALTER TABLE `cache_messages` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
ALTER TABLE `cache` ADD INDEX `created_index` (`created`);

