Mercurial > hg > rc2

comparison SQL/mysql/2016112200.sql @ 8:bf99236cc5cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to recover from upgrade fail
author Charlie Root
date Sat, 29 Dec 2018 07:07:34 -0500
parents
children
comparison
equal deleted inserted replaced
7:65fd7d441cf1 8:bf99236cc5cd
1 ALTER TABLE `dictionary` ADD COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; -- redundant, for compat. with Galera Cluster
2
3 DROP TABLE `cache`;
4 DROP TABLE `cache_shared`;
5
6 CREATE TABLE `cache` (
7 `user_id` int(10) UNSIGNED NOT NULL,
8 `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL,
9 `expires` datetime DEFAULT NULL,
10 `data` longtext NOT NULL,
11 PRIMARY KEY (`user_id`, `cache_key`),
12 CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`)
13 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
14 INDEX `expires_index` (`expires`)
15 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
16
17
18 CREATE TABLE `cache_shared` (
19 `cache_key` varchar(255) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL,
20 `expires` datetime DEFAULT NULL,
21 `data` longtext NOT NULL,
22 PRIMARY KEY (`cache_key`),
23 INDEX `expires_index` (`expires`)
24 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;