From 7fac0f20beffe1a1b99351893add73d5eef33f2c Mon Sep 17 00:00:00 2001
From: piernov <piernov@piernov.org>
Date: Thu, 7 Mar 2013 00:08:36 +0100
Subject: Importation initiale du projet

---
 RuDynFrame.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100755 RuDynFrame.sql

(limited to 'RuDynFrame.sql')

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;
-- 
cgit v1.2.3-70-g09d2

