Mercurial > hg > rc1

comparison SQL/mysql/2016112200.sql @ 0:1e000243b222

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:50:29 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:1e000243b222
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 */;