diff options
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`), |