1 files changed, 37 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index 7ad8eeb..2058771 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 à 16:45
+-- Généré le : Sam 17 Septembre 2011 à 19:36
 -- Version du serveur: 5.5.15
 -- Version de PHP: 5.3.8
 
@@ -33,7 +33,41 @@ CREATE TABLE IF NOT EXISTS `account` (
   `priv` int(11) NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
   UNIQUE KEY `login` (`login`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
+
+-- --------------------------------------------------------
+
+--
+-- 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`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+
+-- --------------------------------------------------------
+
+--
+-- 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`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
 -- --------------------------------------------------------
 
@@ -65,4 +99,4 @@ CREATE TABLE IF NOT EXISTS `notes` (
   `public` tinyint(1) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `owner` (`owner`,`parent`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;