1 files changed, 0 insertions, 159 deletions
diff --git a/schema.sql b/schema.sql
index 0efc1d5..228f7a8 100644
--- a/schema.sql
+++ b/schema.sql
@@ -40,61 +40,6 @@ CREATE TABLE IF NOT EXISTS `account` (
 -- --------------------------------------------------------
 
 --
--- Structure de la table `batches`
---
-
-CREATE TABLE IF NOT EXISTS `batches` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `list` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `model` text NOT NULL,
-  `contents` text NOT NULL,
-  `json_data` text NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `unique_name` (`list`,`name`),
-  KEY `list` (`list`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `batch_review`
---
-
-CREATE TABLE IF NOT EXISTS `batch_review` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `user` int(11) NOT NULL,
-  `batch` int(11) NOT NULL,
-  `results` text NOT NULL,
-  `score` int(11) NOT NULL,
-  `date` date NOT NULL,
-  PRIMARY KEY (`id`),
-  KEY `batch` (`batch`),
-  KEY `user_idx` (`user`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `batch_study`
---
-
-CREATE TABLE IF NOT EXISTS `batch_study` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `user` int(11) NOT NULL,
-  `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`),
-  KEY `batch` (`batch`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
 -- Structure de la table `blog_comments`
 --
 
@@ -144,77 +89,6 @@ CREATE TABLE IF NOT EXISTS `blog_tags` (
 -- --------------------------------------------------------
 
 --
--- Structure de la table `cards`
---
-
-CREATE TABLE IF NOT EXISTS `cards` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `deck` int(11) NOT NULL,
-  `number` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `text_md` text NOT NULL,
-  `text_html` text NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `unique_name` (`deck`,`name`),
-  UNIQUE KEY `unique_number` (`deck`,`number`),
-  KEY `deck_idx` (`deck`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- 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;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `decks`
---
-
-CREATE TABLE IF NOT EXISTS `decks` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `owner` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `comment_md` text NOT NULL,
-  `comment_html` text NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `unique_name` (`owner`,`name`),
-  KEY `owner_idx` (`owner`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- 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;
-
--- --------------------------------------------------------
-
---
 -- Structure de la table `files`
 --
 
@@ -252,39 +126,6 @@ CREATE TABLE IF NOT EXISTS `folders` (
 -- --------------------------------------------------------
 
 --
--- Structure de la table `lists`
---
-
-CREATE TABLE IF NOT EXISTS `lists` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `owner` int(11) NOT NULL,
-  `name` varchar(255) NOT NULL,
-  `comment_md` text NOT NULL,
-  `comment_html` text NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `unique_name` (`owner`,`name`),
-  KEY `owner` (`owner`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Structure de la table `list_study`
---
-
-CREATE TABLE IF NOT EXISTS `list_study` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `user` int(11) NOT NULL,
-  `list` int(11) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `unique_user_list` (`user`,`list`),
-  KEY `user` (`user`),
-  KEY `list_idx` (`list`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
 -- Structure de la table `notes`
 --