diff options
| author | Aleksander Machniak <alec@alec.pl> | 2012-08-06 10:32:37 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2012-08-06 10:32:37 +0200 |
| commit | 83121ece3348bfe09bb1026eace79a74a5ccf2c9 (patch) | |
| tree | 9f64f143b8a859db3930a649a404cdcc46434660 /SQL/mysql.initial.sql | |
| parent | a025cddbc5643d1e8c9d2bf733a101417213d91b (diff) | |
- Removed redundant cache.cache_id column (#1488528)
Diffstat (limited to 'SQL/mysql.initial.sql')
| -rw-r--r-- | SQL/mysql.initial.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index b0a7ee7a9..46fa2c3cf 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -36,12 +36,10 @@ CREATE TABLE `users` ( -- Table structure for table `cache` CREATE TABLE `cache` ( - `cache_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `user_id` int(10) UNSIGNED NOT NULL, `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL , `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `data` longtext NOT NULL, - `user_id` int(10) UNSIGNED NOT NULL, - PRIMARY KEY(`cache_id`), CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, INDEX `created_index` (`created`), |