diff options
author | Nicolas BERNSTEIN <alexis211@gmail.com> | 2012-04-13 19:17:17 +0200 |
---|---|---|
committer | Nicolas BERNSTEIN <alexis211@gmail.com> | 2012-04-13 19:17:17 +0200 |
commit | a535a9e7e017629178b45acc2e96e1d674a0d6fc (patch) | |
tree | b983c468aa37422bb58ff560b91eed067ca1a96e /schema.sql | |
parent | ccff9ce8d8a2818699ce4e20a310986fc95ea022 (diff) | |
download | Bits-a535a9e7e017629178b45acc2e96e1d674a0d6fc.tar.gz Bits-a535a9e7e017629178b45acc2e96e1d674a0d6fc.zip |
Added : ATOM feed for blog ; abilty to comment posts.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 24 |
1 files changed, 21 insertions, 3 deletions
@@ -1,10 +1,10 @@ -- phpMyAdmin SQL Dump --- version 3.4.10.1 +-- version 3.5.0 -- http://www.phpmyadmin.net -- -- Client: localhost --- Généré le : Dim 18 Mars 2012 à 13:58 --- Version du serveur: 5.5.21 +-- Généré le: Ven 13 Avril 2012 à 19:07 +-- Version du serveur: 5.5.22-log -- Version de PHP: 5.3.10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; @@ -92,6 +92,24 @@ CREATE TABLE IF NOT EXISTS `batch_study` ( -- -------------------------------------------------------- -- +-- Structure de la table `blog_comments` +-- + +CREATE TABLE IF NOT EXISTS `blog_comments` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `post` int(11) NOT NULL, + `owner` int(11) NOT NULL, + `text` text NOT NULL, + `text_html` text NOT NULL, + `date` datetime NOT NULL, + PRIMARY KEY (`id`), + KEY `post` (`post`), + KEY `owner` (`owner`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; + +-- -------------------------------------------------------- + +-- -- Structure de la table `blog_posts` -- |