summaryrefslogtreecommitdiffstats
path: root/RuDynFrame.sql
diff options
context:
space:
mode:
Diffstat (limited to 'RuDynFrame.sql')
-rwxr-xr-xRuDynFrame.sql29
1 files changed, 29 insertions, 0 deletions
diff --git a/RuDynFrame.sql b/RuDynFrame.sql
new file mode 100755
index 0000000..512c598
--- /dev/null
+++ b/RuDynFrame.sql
@@ -0,0 +1,29 @@
+CREATE TABLE IF NOT EXISTS `commentaires` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `id_page` int(11) NOT NULL,
+ `auteur` varchar(64) NOT NULL,
+ `email` varchar(128) DEFAULT NULL,
+ `texte` text NOT NULL,
+ `date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
+
+CREATE TABLE IF NOT EXISTS `en_attente` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `id_page` int(11) NOT NULL,
+ `auteur` varchar(64) NOT NULL,
+ `email` varchar(128) DEFAULT NULL,
+ `texte` text NOT NULL,
+ `date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
+
+CREATE TABLE IF NOT EXISTS `pages` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `titre` varchar(128) NOT NULL,
+ `entree` varchar(24) NOT NULL,
+ `sous_menu` int(11) NOT NULL DEFAULT '0',
+ `contenu` text NOT NULL,
+ `derniere_maj` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;