diff options
author | Alex AUVOLAT <alexis211@gmail.com> | 2013-08-12 21:17:29 +0200 |
---|---|---|
committer | Alex AUVOLAT <alexis211@gmail.com> | 2013-08-12 21:17:29 +0200 |
commit | 8c24f8d84c338de8320596c5a9b8da72c2541080 (patch) | |
tree | 304af41ab28375dde5cd21aadaa7ed7d76a4f14e /schema.sql | |
parent | fac8f09c3bf40aaea5513c696af562cd9f728ea6 (diff) | |
download | Bits-8c24f8d84c338de8320596c5a9b8da72c2541080.tar.gz Bits-8c24f8d84c338de8320596c5a9b8da72c2541080.zip |
Small presentation changes.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 13 |
1 files changed, 7 insertions, 6 deletions
@@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Client: localhost --- Généré le: Sam 10 Août 2013 à 15:18 +-- Généré le: Lun 12 Août 2013 à 18:25 -- Version du serveur: 5.5.32-MariaDB-log -- Version de PHP: 5.4.17 @@ -85,6 +85,7 @@ CREATE TABLE IF NOT EXISTS `batch_study` ( `batch` int(11) NOT NULL, `last_review` int(11) NOT NULL, `notes_json` text NOT NULL, + `before_last_review` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `batch_user` (`user`,`batch`), KEY `user_idx` (`user`), @@ -157,7 +158,7 @@ CREATE TABLE IF NOT EXISTS `cards` ( UNIQUE KEY `unique_name` (`deck`,`name`), UNIQUE KEY `unique_number` (`deck`,`number`), KEY `deck_idx` (`deck`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -173,7 +174,7 @@ CREATE TABLE IF NOT EXISTS `card_study` ( `next_review` date NOT NULL, PRIMARY KEY (`id`), KEY `deck_study` (`deck_study`,`card`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -190,7 +191,7 @@ CREATE TABLE IF NOT EXISTS `decks` ( PRIMARY KEY (`id`), UNIQUE KEY `unique_name` (`owner`,`name`), KEY `owner_idx` (`owner`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -209,7 +210,7 @@ CREATE TABLE IF NOT EXISTS `deck_study` ( UNIQUE KEY `unique_user_deck` (`user`,`deck`), KEY `user_idx` (`user`), KEY `deck_idx` (`deck`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- @@ -297,7 +298,7 @@ CREATE TABLE IF NOT EXISTS `notes` ( `public` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `owner` (`owner`,`parent`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |