diff options
author | piernov <piernov@piernov.org> | 2013-03-07 00:08:36 +0100 |
---|---|---|
committer | piernov <piernov@piernov.org> | 2013-03-07 00:08:36 +0100 |
commit | 7fac0f20beffe1a1b99351893add73d5eef33f2c (patch) | |
tree | 162c2ff1b2aa0709c2de26d0399106b1a5368708 /RuDynFrame.sql | |
download | RuDynFrame-7fac0f20beffe1a1b99351893add73d5eef33f2c.tar.gz RuDynFrame-7fac0f20beffe1a1b99351893add73d5eef33f2c.tar.bz2 RuDynFrame-7fac0f20beffe1a1b99351893add73d5eef33f2c.tar.xz RuDynFrame-7fac0f20beffe1a1b99351893add73d5eef33f2c.zip |
Diffstat (limited to 'RuDynFrame.sql')
-rwxr-xr-x | RuDynFrame.sql | 29 |
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; |