From cf3188c5fd2b5c3c4010fb662bc3fac44c182afe Mon Sep 17 00:00:00 2001 From: Alex AUVOLAT Date: Sat, 10 Aug 2013 17:18:25 +0200 Subject: Oops. --- schema.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/schema.sql b/schema.sql index 022f193..e98f1d4 100644 --- a/schema.sql +++ b/schema.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Client: localhost --- Généré le: Sam 10 Août 2013 à 14:13 +-- Généré le: Sam 10 Août 2013 à 15:18 -- Version du serveur: 5.5.32-MariaDB-log -- Version de PHP: 5.4.17 @@ -86,8 +86,9 @@ CREATE TABLE IF NOT EXISTS `batch_study` ( `last_review` int(11) NOT NULL, `notes_json` text NOT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `batch` (`batch`), - KEY `user_idx` (`user`) + UNIQUE KEY `batch_user` (`user`,`batch`), + KEY `user_idx` (`user`), + KEY `batch` (`batch`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- cgit v1.2.3