summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorNicolas BERNSTEIN <alexis211@gmail.com>2012-04-13 19:17:17 +0200
committerNicolas BERNSTEIN <alexis211@gmail.com>2012-04-13 19:17:17 +0200
commita535a9e7e017629178b45acc2e96e1d674a0d6fc (patch)
treeb983c468aa37422bb58ff560b91eed067ca1a96e /schema.sql
parentccff9ce8d8a2818699ce4e20a310986fc95ea022 (diff)
downloadBits-a535a9e7e017629178b45acc2e96e1d674a0d6fc.tar.gz
Bits-a535a9e7e017629178b45acc2e96e1d674a0d6fc.zip
Added : ATOM feed for blog ; abilty to comment posts.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql24
1 files changed, 21 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index f91acb2..1c858f2 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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`
--