aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAlex AUVOLAT <alexis211@gmail.com>2013-08-10 17:18:25 +0200
committerAlex AUVOLAT <alexis211@gmail.com>2013-08-10 17:18:25 +0200
commitcf3188c5fd2b5c3c4010fb662bc3fac44c182afe (patch)
tree29eb897d1b289307838717a0ff737a459446c575
parent5435a0a45fdfa1bcceeb36f8531826ddc2bb3508 (diff)
downloadBits-cf3188c5fd2b5c3c4010fb662bc3fac44c182afe.tar.gz
Bits-cf3188c5fd2b5c3c4010fb662bc3fac44c182afe.zip
Oops.
-rw-r--r--schema.sql7
1 files 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;
-- --------------------------------------------------------