diff options
| author | Alex AUVOLAT <alexis211@gmail.com> | 2013-08-10 17:18:25 +0200 |
|---|---|---|
| committer | Alex AUVOLAT <alexis211@gmail.com> | 2013-08-10 17:18:25 +0200 |
| commit | cf3188c5fd2b5c3c4010fb662bc3fac44c182afe (patch) | |
| tree | 29eb897d1b289307838717a0ff737a459446c575 | |
| parent | 5435a0a45fdfa1bcceeb36f8531826ddc2bb3508 (diff) | |
| download | Bits-cf3188c5fd2b5c3c4010fb662bc3fac44c182afe.tar.gz Bits-cf3188c5fd2b5c3c4010fb662bc3fac44c182afe.zip | |
Oops.
| -rw-r--r-- | schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
@@ -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; -- -------------------------------------------------------- |