-- phpMyAdmin SQL Dump
-- version 2.11.7.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 05 Janvier 2009 à 18:52
-- Version du serveur: 5.0.41
-- Version de PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `pal`
--

-- --------------------------------------------------------

--
-- Structure de la TABLE `category`
--

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL auto_increment,
  `status_id` int(11) NOT NULL,
  `category_url` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `creation_date` datetime default '1970-01-01 00:00:00',
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Contenu de la TABLE `category`
--

INSERT INTO `category` VALUES(1, 1, 'articles', 'Articles', '2008-11-21 18:09:56', NULL);

-- --------------------------------------------------------

--
-- Structure de la TABLE `comment`
--

CREATE TABLE `comment` (
  `comment_id` bigint(20) NOT NULL auto_increment,
  `blog_id` varchar(20) NOT NULL,
  `content_id` bigint(20) default NULL,
  `author` varchar(125) NOT NULL,
  `email` varchar(80) NOT NULL,
  `website` varchar(255) NOT NULL,
  `creation_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `modification_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `ip` varchar(32) NOT NULL,
  `content` longtext NOT NULL,
  `language` varchar(4) NOT NULL,
  `publication_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `timezone` varchar(128) NOT NULL,
  `status_id` int(4) default '0',
  PRIMARY KEY  (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Contenu de la TABLE `comment`
--

--
-- Structure de la table `lang`
--

CREATE TABLE `lang` (
  `lang_id` varchar(2) NOT NULL,
  `language` varchar(25) NOT NULL,
  `creation_date` datetime NOT NULL,
  `version` varchar(5) NOT NULL,
  PRIMARY KEY  (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `lang`
--

INSERT INTO `lang` (`lang_id`, `language`, `creation_date`, `version`) VALUES ('en', 'English', NOW(), '0.1');

-- --------------------------------------------------------

--
-- Structure de la TABLE `link`
--

CREATE TABLE `link` (
  `link_id` bigint(20) NOT NULL auto_increment,
  `blog_id` varchar(32) collate utf8_bin NOT NULL,
  `link_url` varchar(255) collate utf8_bin NOT NULL,
  `link_title` varchar(255) collate utf8_bin NOT NULL,
  `link_description` varchar(255) collate utf8_bin default NULL,
  `link_lang` varchar(5) collate utf8_bin default NULL,
  `link_position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=13 ;

--
-- Contenu de la TABLE `link`
--

INSERT INTO `link` VALUES(12, 'default', 'http://pouvoir-choisir.org/logiciel-libre/', 'Blog Poupoul2', NULL, 'fr', 0);

-- --------------------------------------------------------

--
-- Structure de la TABLE `ping`
--

CREATE TABLE `ping` (
  `ping_id` bigint(20) NOT NULL,
  `ping_url` varchar(255) NOT NULL,
  `creation_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `content_id` bigint(20) NOT NULL,
  PRIMARY KEY  (`ping_id`),
  KEY `content_id` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `ping`
--


-- --------------------------------------------------------

--
-- Structure de la TABLE `post`
--

CREATE TABLE `post` (
  `content_id` bigint(20) NOT NULL auto_increment,
  `blog_id` varchar(20) NOT NULL,
  `parent_id` bigint(20) default NULL,
  `user_id` varchar(20) NOT NULL,
  `creation_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `modification_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `ip` varchar(32) NOT NULL,
  `category_id` int(11) NOT NULL,
  `tag_id` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `extract` longtext,
  `content` longtext NOT NULL,
  `description` longtext,
  `status_id` int(11) NOT NULL,
  `language` varchar(4) NOT NULL,
  `publication_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `selected` tinyint(4) default '0',
  `vote_allowed` tinyint(2) NOT NULL,
  `comment_allowed` tinyint(2) NOT NULL,
  `ping_allowed` tinyint(2) NOT NULL,
  `timezone` varchar(128) NOT NULL,
  `password` varchar(32) default NULL,
  `view` bigint(20) default '0',
  `lifetime` int(4) default '0',
  PRIMARY KEY  (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Contenu de la TABLE `post`
--


-- --------------------------------------------------------

--
-- Structure de la TABLE `rss`
--

CREATE TABLE `rss` (
  `rss_id` bigint(20) NOT NULL auto_increment,
  `blog_id` varchar(32) collate utf8_bin NOT NULL,
  `rss_url` varchar(255) collate utf8_bin NOT NULL,
  `rss_title` varchar(255) collate utf8_bin NOT NULL,
  `rss_description` varchar(255) collate utf8_bin default NULL,
  `rss_lang` varchar(5) collate utf8_bin default NULL,
  `rss_position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`rss_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;

--
-- Contenu de la TABLE `rss`
--

INSERT INTO `rss` VALUES(1, 'default', 'index.php?rss/atom/post', 'Fils des billets', NULL, 'fr', 1);
INSERT INTO `rss` VALUES(3, 'default', 'index.php?rss/atom/comment', 'Fils des commentaires', NULL, 'fr', 0);

-- --------------------------------------------------------

--
-- Structure de la TABLE `settings`
--

CREATE TABLE `settings` (
  `setting_id` varchar(50) NOT NULL,
  `blog_id` varchar(20) default NULL,
  `setting_type` varchar(20) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  `setting_description` varchar(255) NOT NULL,
  `category` varchar(30) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY  (`setting_id`),
  KEY `blog_id` (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `settings`
--

INSERT INTO `settings` VALUES('theme', NULL, 'foundation', 'pal', 'Nom du thème utiliser pour l''affichage graphique du journal', 'interface', 'string');
INSERT INTO `settings` VALUES('lang', NULL, 'foundation', 'fr', 'Langue utilisée par défault pour l''interface utilisateur du journal', 'interface', 'list::language::LanguageGui');
INSERT INTO `settings` VALUES('charset', NULL, 'foundation', 'UTF-8', 'Encodage des caractères utilisé pour le journal', 'interface', 'string');
INSERT INTO `settings` VALUES('date_pattern', NULL, 'foundation', '%A %d %B %Y', 'Format d''affichage de la date pour les contenus du journal', 'interface', 'string');
INSERT INTO `settings` VALUES('time_pattern', 'NULL', 'foundation', '%H:%M', 'Format d''affichage de l''heure pour les contenus du journal', 'interface', 'string');
INSERT INTO `settings` VALUES('copyright', NULL, 'foundation', 'Pizza aux lentilles', 'Texte d''information de copyright affiché en bas des pages du journal', 'interface', 'string');
INSERT INTO `settings` VALUES('comment_allowed', NULL, 'foundation', 'true', 'Autoriser les commentaires sur les billets ?', 'post', 'boolean');
INSERT INTO `settings` VALUES('post_per_page', NULL, 'foundation', '10', 'Nombre de billet affichés par page', 'post', 'integer');
INSERT INTO `settings` VALUES('title', '', 'foundation', 'Mon premier blog', 'Titre du journal utilisé par les moteurs d''indéxation', 'metadata', 'string');
INSERT INTO `settings` VALUES('description', NULL, 'foundation', 'Nouvel outil blog Open Source', 'Description du blog utilisée par les moteurs d''indéxation', 'metadata', 'string');
INSERT INTO `settings` VALUES('author', NULL, 'foundation', '', 'Auteur du journal utilisé par les moteurs d''indéxation', 'metadata', 'string');
INSERT INTO `settings` VALUES('vote_allowed', NULL, 'foundation', 'true', 'Les votes sur les contenus sont-ils autorisés ?', 'post', 'boolean');
INSERT INTO `settings` VALUES('url_pattern', NULL, 'foundation', '{Y}/{m}/{d}/{id}/{t}', 'Format d''URL du blog', 'foundation', 'string');
INSERT INTO `settings` VALUES('lang_folder', NULL, 'foundation', 'language/', 'Répertoire des fichiers de langue', 'foundation', 'string');
INSERT INTO `settings` VALUES('theme_folder', NULL, 'foundation', 'themes/', 'Répertoire des thèmes graphiques', 'foundation', 'string');
INSERT INTO `settings` VALUES('date', NULL, 'foundation', '2008-11-20T12:12:33 01:00', 'Date de la création du blog', 'metadata', 'string');
INSERT INTO `settings` VALUES('blog', NULL, 'foundation', 'default', 'Identifiant du blog', 'foundation', 'string');
INSERT INTO `settings` VALUES('default_post_status', NULL, 'foundation', '1', 'Status des billets par défaut', 'post', 'list::post::statusGui');
INSERT INTO `settings` VALUES('wysiwyg', NULL, 'foundation', 'fckeditor/', 'Répertoire de l''éditeur de contenu', 'foundation', 'string');
INSERT INTO `settings` VALUES('comment', NULL, 'foundation', 'true', 'Afficher le nombre de commentaires dans le cartouche des billets ?', 'legend', 'boolean');
INSERT INTO `settings` VALUES('trackback', NULL, 'foundation', 'false', 'Afficher le nombre de rétroliens dans le cartouche des billets ?', 'legend', 'boolean');
INSERT INTO `settings` VALUES('view', NULL, 'foundation', 'true', 'Afficher le nombre de lectures dans le cartouche des billets ?', 'legend', 'boolean');
INSERT INTO `settings` VALUES('vote', NULL, 'foundation', 'true', 'Afficher le nombre de votes dans le cartouche des billets ?', 'legend', 'boolean');
INSERT INTO `settings` VALUES('default_category', NULL, 'foundation', '1', 'Catégorie par défaut des billets', 'post', 'list::category::categoryGui');
INSERT INTO `settings` VALUES('post_selected', NULL, 'foundation', 'true', 'Sélectionner les billets par défaut ?', 'post', 'boolean');
INSERT INTO `settings` VALUES('trackback_allowed', NULL, 'foundation', 'true', 'Accepter les rétroliens par défaut ?', 'post', 'boolean');
INSERT INTO `settings` VALUES('default_comment_status', NULL, 'foundation', '3', 'Status des commentaires par défaut', 'post', 'list::comment::statusGui');
INSERT INTO `settings` VALUES('gravatar_service', NULL, 'foundation', 'true', 'Utiliser le service Gravatar pour l''affichage des avatars', 'post', 'boolean');
INSERT INTO `settings` VALUES('default_user_status', NULL, 'foundation', '2', 'Status des utilisateurs par défaut', 'foundation', 'list::user::statusGui');
INSERT INTO `settings` VALUES('default_usergroup', NULL, 'foundation', '1', 'Groupe utilisateur par défaut', 'foundation', 'list::usergroup::usergroupGui');
INSERT INTO `settings` VALUES('timezone', '', 'foundation', 'Europe/Paris', 'Timezone du blog', 'foundation', 'string');
INSERT INTO `settings` VALUES('default_usergroup_status', NULL, 'foundation', '99', 'Status des groupes utilisateur par défaut', 'foundation', 'list::usergroup::statusGui');

-- --------------------------------------------------------

--
-- Structure de la TABLE `status`
--

CREATE TABLE `status` (
  `status_id` tinyint(4) NOT NULL,
  `status` varchar(20) default NULL,
  `creation_date` datetime default '1970-01-01 00:00:00',
  `description` varchar(255) default NULL,
  `type_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `status`
--

INSERT INTO `status` VALUES(1, 'brouillon', '2008-11-21 11:51:33', 'edit-mini.png', 'post');
INSERT INTO `status` VALUES(10, 'publié', '2008-11-21 11:52:35', 'check-on.png', 'post');
INSERT INTO `status` VALUES(2, 'programmé', '2008-11-21 11:51:51', 'scheduled.png', 'post');
INSERT INTO `status` VALUES(99, 'non publié', '2008-11-21 11:52:16', 'check-wrn.png', 'post');
INSERT INTO `status` VALUES(1, 'indésirable', '2008-11-23 14:56:44', 'spam.png', 'comment');
INSERT INTO `status` VALUES(10, 'publié', '2008-11-21 11:52:35', 'check-on.png', 'comment');
INSERT INTO `status` VALUES(99, 'hors ligne', '2008-11-21 11:51:51', 'check-wrn.png', 'comment');
INSERT INTO `status` VALUES(3, 'en attente', '2008-11-21 11:52:16', 'scheduled.png', 'comment');
INSERT INTO `status` VALUES(99, 'bloqué', '2008-11-23 14:56:44', 'check-off.png', 'user');
INSERT INTO `status` VALUES(10, 'actif', '2008-11-21 11:52:35', 'check-on.png', 'user');
INSERT INTO `status` VALUES(2, 'en attente', '2008-11-21 11:52:16', 'check-wrn.png', 'user');
INSERT INTO `status` VALUES(99, 'inactif', '2008-12-15 21:03:46', 'check-off.png', 'tag');
INSERT INTO `status` VALUES(1, 'actif', '2008-12-15 21:04:18', 'check-on.png', 'tag');
INSERT INTO `status` VALUES(99, 'inactif', '2008-12-15 21:03:46', 'check-off.png', 'category');
INSERT INTO `status` VALUES(1, 'actif', '2008-12-15 21:04:18', 'check-on.png', 'category');
INSERT INTO `status` VALUES(99, 'supprimé', '2008-12-23 09:15:42', 'check-off.png', 'widget');
INSERT INTO `status` VALUES(10, 'installé', '2008-12-23 09:15:42', 'check-on.png', 'widget');
INSERT INTO `status` VALUES(1, 'désinstallé', '2008-12-23 09:57:27', 'check-wrn.png', 'widget');
INSERT INTO `status` VALUES(99, 'supprimé', '2008-12-15 21:03:46', 'check-off.png', 'usergroup');
INSERT INTO `status` VALUES(1, 'actif', '2008-12-15 21:04:18', 'check-on.png', 'usergroup');

-- --------------------------------------------------------

--
-- Structure de la TABLE `tag`
--

CREATE TABLE `tag` (
  `tag_id` int(11) NOT NULL auto_increment,
  `tag_url` varchar(50) NOT NULL,
  `tag` varchar(50) NOT NULL,
  `creation_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `status_id` int(11) NOT NULL,
  PRIMARY KEY  (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Contenu de la TABLE `tag`
--

INSERT INTO `tag` VALUES(2, 'logiciels_libres', 'Logiciels libres', '2008-11-14 17:40:37', 1);

-- --------------------------------------------------------

--
-- Structure de la TABLE `user`
--

CREATE TABLE `user` (
  `user_id` varchar(20) NOT NULL,
  `username` varchar(32) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `pseudo` varchar(32) NOT NULL,
  `email` varchar(255) NOT NULL,
  `creation_date` datetime default '1970-01-01 00:00:00',
  `modification_date` datetime default '1970-01-01 00:00:00',
  `password` varchar(32) NOT NULL,
  `user_ip` varchar(15) NOT NULL,
  `group_id` int(11) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `post_status` tinyint(4) NOT NULL,
  `blog_id` varchar(20) NOT NULL,
  `description` varchar(255) default NULL,
  `language` varchar(4) NOT NULL,
  `timezone` varchar(128) NOT NULL,
  `avatar` varchar(255) default NULL,
  `url` varchar(255) NOT NULL,
  `level` int(11) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Structure de la TABLE `usergroup`
--

CREATE TABLE `usergroup` (
  `usergroup_id` int(11) NOT NULL auto_increment,
  `blog_id` varchar(50) NOT NULL,
  `usergroup` varchar(50) NOT NULL,
  `creation_date` datetime NOT NULL,
  `status_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY  (`usergroup_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1032 ;

--
-- Contenu de la TABLE `usergroup`
--

INSERT INTO `usergroup` VALUES(1, 'default', 'Rédacteur', '2008-12-26 11:04:43', 99, '');
INSERT INTO `usergroup` VALUES(999, 'default', 'Administrateur', '2008-12-26 11:04:55', 1, '');

-- --------------------------------------------------------

--
-- Structure de la TABLE `version`
--

CREATE TABLE `version` (
  `application` varchar(25) NOT NULL,
  `module` varchar(50) NOT NULL,
  `version` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `version`
--

INSERT INTO `version` VALUES('Pizza aux lentilles', 'foundation', '1.0 beta');

-- --------------------------------------------------------

--
-- Structure de la TABLE `vote`
--

CREATE TABLE `vote` (
  `content_id` bigint(20) NOT NULL default '0',
  `user_ip` varchar(15) NOT NULL,
  `creation_date` datetime NOT NULL default '1970-01-01 00:00:00',
  `value` varchar(5) NOT NULL,
  KEY `content_id` (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `vote`
--


-- --------------------------------------------------------

--
-- Structure de la TABLE `widget`
--

CREATE TABLE `widget` (
  `widget_id` varchar(30) NOT NULL,
  `version` varchar(5) NOT NULL,
  `status_id` tinyint(4) NOT NULL,
  `widget_caption` varchar(30) NOT NULL,
  `widget_table` varchar(30) NOT NULL,
  `widget_description` text NOT NULL,
  `widget_position` tinyint(4) NOT NULL,
  PRIMARY KEY  (`widget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la TABLE `widget`
--

INSERT INTO `widget` VALUES('selectedPost', '0.1', 1, 'A retenir', '', 'Module permettant d''afficher le titre des billets sélectionnés pour un accès direct depuis la page d''accueil.', 0);
INSERT INTO `widget` VALUES('links', '0.1', 99, 'Liens', '', '', 0);
INSERT INTO `widget` VALUES('timezone', '0.1', 10, 'Horloges', 'widget_timezone', '', 0);
INSERT INTO `widget` VALUES('tags', '0.1', 10, 'Tags', '', '', 0);
INSERT INTO `widget` VALUES('category', '0.1', 10, 'Catégories', '', '', 0);
INSERT INTO `widget` VALUES('search', '0.1', 10, 'Moteur de recherche', '', '', 0);
INSERT INTO `widget` VALUES('latestPost', '0.1', 10, 'Derniers billets', '', '', 0);
INSERT INTO `widget` VALUES('rss', '0.1', 10, 'Fils rss', '', '', 0);
INSERT INTO `widget` VALUES('latestComment', '0.1', 10, 'Derniers commentaires', '', '', 0);

-- --------------------------------------------------------

--
-- Structure de la table `widget_timezone`
--

CREATE TABLE `widget_timezone` (
  `timezone_id` int(11) NOT NULL auto_increment,
  `timezone_title` varchar(30) NOT NULL,
  `timezone` varchar(30) NOT NULL,
  `timezone_pattern` varchar(20) NOT NULL,
  PRIMARY KEY  (`timezone_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

--
-- Contenu de la table `widget_timezone`
--

INSERT INTO `widget_timezone` VALUES(25, 'Perth', 'Australia/Perth', '');
INSERT INTO `widget_timezone` VALUES(24, 'Paris', 'Europe/Paris', '');
INSERT INTO `widget_timezone` VALUES(23, 'Melbourne', 'Australia/Melbourne', '');