summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorNicolas BERNSTEIN <alexis211@gmail.com>2011-09-18 12:07:29 +0200
committerNicolas BERNSTEIN <alexis211@gmail.com>2011-09-18 12:07:29 +0200
commita565e649898c629874ef812a13806b1c384f68e4 (patch)
treeafc03ed12ec7e82ce17bcfff5ba76440ff43eb97 /schema.sql
parent8d9321225140a3db0b72796d4d0236d6cacfeb8a (diff)
downloadBits-a565e649898c629874ef812a13806b1c384f68e4.tar.gz
Bits-a565e649898c629874ef812a13806b1c384f68e4.zip
Added study program. Yay!
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql47
1 files changed, 42 insertions, 5 deletions
diff --git a/schema.sql b/schema.sql
index 2058771..d93fa1c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Client: localhost
--- Généré le : Sam 17 Septembre 2011 à 19:36
+-- Généré le : Dim 18 Septembre 2011 à 12:06
-- Version du serveur: 5.5.15
-- Version de PHP: 5.3.8
@@ -50,8 +50,25 @@ CREATE TABLE IF NOT EXISTS `cards` (
`text_html` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_name` (`deck`,`name`),
- UNIQUE KEY `unique_number` (`deck`,`number`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+ UNIQUE KEY `unique_number` (`deck`,`number`),
+ KEY `deck_idx` (`deck`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `card_study`
+--
+
+CREATE TABLE IF NOT EXISTS `card_study` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `deck_study` int(11) NOT NULL,
+ `card` int(11) NOT NULL,
+ `level` int(11) NOT NULL,
+ `next_review` date NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `deck_study` (`deck_study`,`card`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
@@ -66,12 +83,32 @@ CREATE TABLE IF NOT EXISTS `decks` (
`comment_md` text NOT NULL,
`comment_html` text NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `unique_name` (`owner`,`name`)
+ UNIQUE KEY `unique_name` (`owner`,`name`),
+ KEY `owner_idx` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
+-- Structure de la table `deck_study`
+--
+
+CREATE TABLE IF NOT EXISTS `deck_study` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `user` int(11) NOT NULL,
+ `deck` int(11) NOT NULL,
+ `last_card` int(11) NOT NULL DEFAULT '0',
+ `learn_rate` int(11) NOT NULL DEFAULT '10',
+ `need_check` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `unique_user_deck` (`user`,`deck`),
+ KEY `user_idx` (`user`),
+ KEY `deck_idx` (`deck`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+-- --------------------------------------------------------
+
+--
-- Structure de la table `images`
--
@@ -81,7 +118,7 @@ CREATE TABLE IF NOT EXISTS `images` (
`extension` varchar(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `owner` (`owner`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------