Index: branches/rsr.v5.1.1/web/install/dist/sql/champs_content.txt
===================================================================
--- branches/rsr.v5.1.dev/web/install/dist/sql/champs_content.txt	(revision 1)
+++ 	(revision )
@@ -1,3 +1,0 @@
-[site_name]
-[email_admin]
-[pun_url]
Index: branches/rsr.v5.1.1/web/install/dist/sql/content.sql
===================================================================
--- branches/rsr.v5.1.dev/web/install/dist/sql/content.sql	(revision 1)
+++ branches/rsr.v5.1.1/web/install/dist/sql/content.sql	(revision 4)
@@ -11,5 +11,5 @@
 (143, 'news', 'accueil_droite_bas', 'Les autres news', 'news.php', '', 186, '2009-09-01 19:57:51', 186, '2010-08-05 01:48:55', '2009-09-06 17:16:52', 1, 2),
 (152, 'forum_interne', 'interne_gauche', 'Forum', 'accueil_forum.php', '<p>Ce bloc affiche les 7 derniers messages du forum.</p>', 186, '2009-09-06 19:46:30', 186, '2011-11-12 15:52:34', '2009-09-06 19:48:57', 0, 4),
-(149, '', 'accueil_footer', 'Bloc en bas de la page d''accueil', '', '<p>Plus de docs sur <a href="http://wiki.rsr.free.fr/wiki">le wiki</a>.</p>\r\n<ul>\r\n</ul>\r\n<p>Pour les questions, les retours (...) vous &ecirc;tes invit&eacute;s &agrave; venir en parler sur le <a href="http://www.revolutionsoundrecords.org/punbb">forum de l''association Revolution Sound Records</a>.</p>', 186, '2009-09-06 16:41:15', 186, '2011-11-12 22:36:42', '2009-09-06 19:07:34', 1, 6),
+(149, '', 'accueil_footer', 'Bloc en bas de la page d''accueil', '', '<p>Plus de docs sur <a href="http://www.revolutionsoundrecords.org/trac">le trac</a>.</p>\r\n<ul>\r\n</ul>\r\n<p>Pour les questions, les retours (...) vous &ecirc;tes invit&eacute;s &agrave; venir en parler sur le <a href="http://www.revolutionsoundrecords.org/punbb">forum de l''association Revolution Sound Records</a>.</p>', 186, '2009-09-06 16:41:15', 186, '2011-11-12 22:36:42', '2009-09-06 19:07:34', 1, 6),
 (128, 'administration', NULL, 'Administration', 'admin.php', '', 186, '2009-08-10 10:27:12', 186, '2009-09-06 00:13:40', '2009-09-06 00:13:40', 1, 4),
 (155, '', 'interne_gauche', 'News', 'menu_news.php', '<p>Affiche les 2 derni&egrave;res news et un menu pour acc&eacute;der aux autres news.</p>', 186, '2010-01-15 22:39:32', 186, '2011-11-12 16:10:38', NULL, 1, 1),
@@ -88,5 +88,4 @@
 INSERT INTO `[prefix]contenus` (`id`, `nom`, `categorie`, `titre`, `description`, `contenu`, `auteur_creation`, `date_creation`, `auteur_modification`, `date_modification`, `date_publication`, `public`, `ordre`) VALUES
 (919, '', 1, 'Nouvelle installation', '', '<p>Bienvenue sur votre installation de rsr v.5.</p>\r\n<p>Pensez &agrave; effacer le dossier <strong>install</strong></p>\r\n<p>&nbsp;</p>\r\n<p>Bonnes publications !</p>', 186, '2011-09-04 15:03:09', 186, '2011-11-12 22:07:24', '2011-09-04 00:00:00', 1, NULL);
-
 # --
 INSERT INTO `[prefix]formats` (`id`, `nom`, `content_type`) VALUES
@@ -120,12 +119,12 @@
 # --
 INSERT INTO `[prefix]pun_config` (`conf_name`, `conf_value`) VALUES
-('o_cur_version', '1.2.10'),
+('o_cur_version', '1.4.7'),
 ('o_cur_version_fr', '1.2.10'),
 ('o_board_title', 'Forums'),
 ('o_board_desc', NULL),
-('o_server_timezone', '0'),
+('o_default_timezone', '0'),
 ('o_time_format', 'H:i:s'),
 ('o_date_format', 'd-m-Y'),
-('o_timeout_visit', '600'),
+('o_timeout_visit', '1800'),
 ('o_timeout_online', '300'),
 ('o_redirect_delay', '1'),
@@ -163,5 +162,5 @@
 ('o_admin_email', '[email_admin]'),
 ('o_webmaster_email', '[email_admin]'),
-('o_subscriptions', '1'),
+('o_topic_subscriptions', '1'),
 ('o_smtp_host', NULL),
 ('o_smtp_user', NULL),
@@ -177,8 +176,5 @@
 ('o_maintenance', '0'),
 ('o_maintenance_message', 'Les forums sont temporairement fermÃ©s pour des raisons de maintenance. Nous vous prions de bien vouloir nous excuser pour cette gÃšne. Veuillez essayer Ã  nouveau d''ici quelques minutes.<br />\n<br />\nRevolution Sound Records'),
-('p_mod_edit_users', '1'),
-('p_mod_rename_users', '0'),
-('p_mod_change_passwords', '0'),
-('p_mod_ban_users', '0'),
+('o_forum_subscriptions', '1'),
 ('p_message_bbcode', '1'),
 ('p_message_img_tag', '1'),
@@ -192,5 +188,16 @@
 ('p_allow_banned_email', '1'),
 ('p_allow_dupe_email', '0'),
-('p_force_guest_email', '1');
+('p_force_guest_email', '1'),
+('o_database_revision', '15'),
+('o_searchindex_revision', '2'),
+('o_parser_revision', '2'),
+('o_default_email_setting', '1'),
+('o_topic_views', '1'),
+('o_signatures', '1'),
+('o_smtp_ssl', '0'),
+('o_default_dst', '0'),
+('o_quote_depth', '3'),
+('o_feed_type', '2'),
+('o_feed_ttl', '0');
 # --
 INSERT INTO `[prefix]pun_forum_perms` (`group_id`, `forum_id`, `read_forum`, `post_replies`, `post_topics`) VALUES
@@ -220,14 +227,14 @@
 (6, 80, 0, 0, 0);
 # --
-INSERT INTO `[prefix]pun_groups` (`g_id`, `g_title`, `g_user_title`, `g_read_board`, `g_post_replies`, `g_post_topics`, `g_post_polls`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_edit_subjects_interval`, `g_post_flood`, `g_search_flood`) VALUES
-(1, 'Admin', 'Admin', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
-(2, 'ModÃ©rateurs', 'ModÃ©rateur', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),
-(3, 'Touriste', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0),
-(4, 'Membres', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30),
-(5, 'Artiste', 'Artiste', 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 10, 10),
-(6, '100 eme Membre', '100 eme Membre', 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30);
-# --
-INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`) VALUES
-(1, '192.168.10.13', 1321118546, 0);
+INSERT INTO `[prefix]pun_groups` (`g_id`, `g_title`, `g_user_title`, `g_moderator`, `g_mod_edit_users`, `g_mod_rename_users`, `g_mod_change_passwords`, `g_mod_ban_users`, `g_read_board`, `g_view_users`, `g_post_replies`, `g_post_topics`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_send_email`, `g_post_flood`, `g_search_flood`, `g_email_flood`, `g_report_flood`) VALUES
+(1, 'Admin', 'Admin', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(2, 'ModÃ©rateurs', 'ModÃ©rateur', 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(3, 'Touriste', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0),
+(4, 'Membres', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60),
+(5, 'Artiste', 'Artiste', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 10, 10, 60, 60),
+(6, '100 eme Membre', '100 eme Membre', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60);
+# --
+INSERT INTO `[prefix]pun_online` (`user_id`, `ident`, `logged`, `idle`, `last_post`, `last_search`) VALUES
+(1, '192.168.10.13', 1321306351, 0, NULL, NULL);
 # --
 INSERT INTO `[prefix]pun_ranks` (`id`, `rank`, `min_posts`) VALUES
@@ -254,5 +261,5 @@
 (87, 'terminator.png', ':terminator:', 0);
 # --
-INSERT INTO `[prefix]pun_users` (`id`, `group_id`, `username`, `password`, `email`, `title`, `realname`, `url`, `jabber`, `icq`, `msn`, `aim`, `yahoo`, `location`, `use_avatar`, `signature`, `disp_topics`, `disp_posts`, `email_setting`, `save_pass`, `notify_with_post`, `show_smilies`, `show_img`, `show_img_sig`, `show_avatars`, `show_sig`, `timezone`, `language`, `style`, `num_posts`, `last_post`, `registered`, `registration_ip`, `last_visit`, `admin_note`, `activate_string`, `activate_key`) VALUES
-(186, 1, 'admin', '90f1b3c6cf62b05606b215265803f553e22bc657', '[email_admin]', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0, 'French', 'Rsr', 1382, 1321043538, 1156702867, '82.243.194.97', 1321118443, NULL, NULL, NULL),
-(1, 3, 'InvitÃ©', 'InvitÃ©', 'InvitÃ©', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 1, 1, 0, 1, 1, 1, 1, 1, 0, 'English', 'Oxygen', 0, NULL, 0, '0.0.0.0', 0, NULL, NULL, NULL);
+INSERT INTO `[prefix]pun_users` (`id`, `group_id`, `username`, `password`, `email`, `title`, `realname`, `url`, `jabber`, `icq`, `msn`, `aim`, `yahoo`, `location`, `signature`, `disp_topics`, `disp_posts`, `email_setting`, `notify_with_post`, `auto_notify`, `show_smilies`, `show_img`, `show_img_sig`, `show_avatars`, `show_sig`, `timezone`, `dst`, `date_format`, `time_format`, `language`, `style`, `num_posts`, `last_post`, `last_search`, `last_email_sent`, `last_report_sent`, `registered`, `registration_ip`, `last_visit`, `admin_note`, `activate_string`, `activate_key`) VALUES
+(186, 1, 'admin', '90f1b3c6cf62b05606b215265803f553e22bc657', '[email_admin]', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'French', 'Rsr', 1382, 1321043538, NULL, NULL, NULL, 1156702867, '82.243.194.97', 1321305012, NULL, NULL, NULL),
+(1, 3, 'InvitÃ©', 'InvitÃ©', 'InvitÃ©', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'English', 'Oxygen', 0, NULL, NULL, NULL, NULL, 0, '0.0.0.0', 0, NULL, NULL, NULL);
Index: branches/rsr.v5.1.1/web/install/dist/sql/raz.sql
===================================================================
--- branches/rsr.v5.1.dev/web/install/dist/sql/raz.sql	(revision 1)
+++ branches/rsr.v5.1.1/web/install/dist/sql/raz.sql	(revision 4)
@@ -27,5 +27,5 @@
 DROP TABLE IF EXISTS `[prefix]playlists`;
 # --
-DROP TABLE IF EXISTS `[prefix]playlis[prefix]download`;
+DROP TABLE IF EXISTS `[prefix]playlist_download`;
 # --
 DROP TABLE IF EXISTS `[prefix]pun_bans`;
@@ -40,4 +40,6 @@
 # --
 DROP TABLE IF EXISTS `[prefix]pun_forum_perms`;
+# --
+DROP TABLE IF EXISTS `[prefix]pun_forum_subscriptions`;
 # --
 DROP TABLE IF EXISTS `[prefix]pun_groups`;
@@ -59,7 +61,7 @@
 DROP TABLE IF EXISTS `[prefix]pun_smilies`;
 # --
-DROP TABLE IF EXISTS `[prefix]pun_subscriptions`;
+DROP TABLE IF EXISTS `[prefix]pun_topics`;
 # --
-DROP TABLE IF EXISTS `[prefix]pun_topics`;
+DROP TABLE IF EXISTS `[prefix]pun_topic_subscriptions`;
 # --
 DROP TABLE IF EXISTS `[prefix]pun_users`;
Index: branches/rsr.v5.1.1/web/install/dist/sql/rsr.v5.all.sql
===================================================================
--- branches/rsr.v5.1.1/web/install/dist/sql/rsr.v5.all.sql	(revision 4)
+++ branches/rsr.v5.1.1/web/install/dist/sql/rsr.v5.all.sql	(revision 4)
@@ -0,0 +1,1165 @@
+-- phpMyAdmin SQL Dump
+-- version 3.2.2.1deb1
+-- http://www.phpmyadmin.net
+--
+-- Serveur: localhost
+-- GÃ©nÃ©rÃ© le : Lun 14 Novembre 2011 Ã  22:36
+-- Version du serveur: 5.1.37
+-- Version de PHP: 5.2.10-2ubuntu6.10
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Base de donnÃ©es: `rsr_v5`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_albums`
+--
+
+DROP TABLE IF EXISTS `rsrv5_albums`;
+CREATE TABLE `rsrv5_albums` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id_artiste` int(11) NOT NULL,
+  `titre` varchar(255) DEFAULT NULL,
+  `image` varchar(255) NOT NULL,
+  `description` text,
+  `url` varchar(255) DEFAULT NULL,
+  `format` int(11) DEFAULT NULL,
+  `taille` int(11) DEFAULT NULL,
+  `date_creation` date DEFAULT NULL,
+  `date_publication` date DEFAULT NULL,
+  `compteur` int(11) NOT NULL DEFAULT '0',
+  `actif` tinyint(4) NOT NULL DEFAULT '1',
+  `ordre` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_albums`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_artistes`
+--
+
+DROP TABLE IF EXISTS `rsrv5_artistes`;
+CREATE TABLE `rsrv5_artistes` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(255) DEFAULT NULL,
+  `presentation` text,
+  `style` varchar(255) DEFAULT NULL,
+  `image` varchar(255) DEFAULT NULL,
+  `pays` varchar(255) DEFAULT NULL,
+  `site` varchar(255) DEFAULT NULL,
+  `email_contact` varchar(255) DEFAULT NULL,
+  `hide_email` tinyint(4) NOT NULL DEFAULT '1',
+  `contact_form` tinyint(4) NOT NULL DEFAULT '1',
+  `identifiant_paypal` varchar(255) DEFAULT NULL,
+  `lien_boutique` varchar(255) DEFAULT NULL,
+  `pun_forum` int(11) DEFAULT NULL,
+  `pun_user` int(11) DEFAULT NULL,
+  `compteur` int(11) NOT NULL DEFAULT '0',
+  `lien_facebook` varchar(255) DEFAULT NULL,
+  `lien_flickr` varchar(255) DEFAULT NULL,
+  `lien_twitter` varchar(255) DEFAULT NULL,
+  `lien_youtube` varchar(255) DEFAULT NULL,
+  `dossier_personnel` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_artistes`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_artistes_admins`
+--
+
+DROP TABLE IF EXISTS `rsrv5_artistes_admins`;
+CREATE TABLE `rsrv5_artistes_admins` (
+  `id_artiste` int(11) NOT NULL,
+  `pun_user` int(11) NOT NULL,
+  PRIMARY KEY (`id_artiste`,`pun_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_artistes_admins`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_boxes`
+--
+
+DROP TABLE IF EXISTS `rsrv5_boxes`;
+CREATE TABLE `rsrv5_boxes` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(64) DEFAULT NULL,
+  `emplacement` varchar(255) DEFAULT NULL,
+  `titre` varchar(255) DEFAULT NULL,
+  `fichier` varchar(255) DEFAULT NULL,
+  `contenu` text,
+  `auteur_creation` int(11) DEFAULT NULL,
+  `date_creation` datetime DEFAULT NULL,
+  `auteur_modification` int(11) DEFAULT NULL,
+  `date_modification` datetime DEFAULT NULL,
+  `date_publication` datetime DEFAULT NULL,
+  `public` tinyint(4) DEFAULT NULL,
+  `ordre` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;
+
+--
+-- Contenu de la table `rsrv5_boxes`
+--
+
+INSERT INTO `rsrv5_boxes` (`id`, `nom`, `emplacement`, `titre`, `fichier`, `contenu`, `auteur_creation`, `date_creation`, `auteur_modification`, `date_modification`, `date_publication`, `public`, `ordre`) VALUES
+(141, 'navigation', NULL, '', 'navigation.php', '<p>Affiche le menu principal dans l''ent&ecirc;te du site.</p>\r\n<p>Les &eacute;l&eacute;ments du menu sont &eacute;ditables dans l''administration du site, menu :</p>\r\n<p><strong>Contenus</strong> &gt; <strong>menus</strong></p>', 186, '2009-08-30 21:48:09', 186, '2011-11-12 16:14:42', '2009-09-05 23:35:21', 1, 0),
+(150, 'accueil_forum', 'accueil_gauche', 'Forum : derniers messages', 'accueil_forum.php', '<p>Ce bloc affiche des liens vers les 7 derniers messages du forum.</p>', 186, '2009-09-06 19:08:59', 186, '2011-11-12 15:56:53', '2009-09-06 19:10:21', 1, 3),
+(127, 'spotlight', 'accueil_gauche', 'Spotlight', 'spotlight.php', '<p>Ce bloc affiche le dernier spotlight, &eacute;dit&eacute; dans l''administration :</p>\r\n<p><strong>La redaction</strong> &gt; <strong>spotlights</strong></p>', 186, '2009-08-10 10:26:40', 186, '2011-11-12 16:05:10', '2009-09-06 17:16:40', 0, 2),
+(126, 'playlists_accueil', 'accueil_petite_gauche', 'Playlists', 'playlists.php', '', 186, '2009-08-09 23:15:00', 186, '2010-08-05 01:48:25', '2009-09-06 19:45:23', 1, 1),
+(142, 'edito', 'accueil_gauche', 'Edito', 'edito.php', '<p>Affiche le dernier &eacute;dito.</p>\r\n<p>Pour l''&eacute;dition des &eacute;ditos, menu :</p>\r\n<p><strong>La redaction</strong> &gt; <strong>&eacute;ditos</strong></p>', 186, '2009-09-01 19:49:18', 186, '2011-11-12 16:12:08', '2009-09-06 17:16:14', 1, 1),
+(151, 'playlists_interne', 'interne_gauche', 'Playlists', 'playlists.php', '', 186, '2009-09-06 19:45:02', 186, '2010-08-05 01:48:15', '2009-09-06 19:45:58', 1, 2),
+(124, 'identification', NULL, '', 'login.php', '', 186, '2009-08-09 22:16:57', 186, '2009-09-05 23:39:50', '2009-09-05 23:39:50', 1, 1),
+(130, 'nous_y_etions', 'accueil_petite_droite', 'Nous y Ã©tions', 'nous_y_etions.php', '<p>Ce bloc affiche un lien vers un sujet au hasard pris dans une section du forum. RSR utilise ce bloc pour faire un lien vers son forum des &eacute;v&eacute;nements pass&eacute;s.</p>\r\n<p>Avant d''utiliser ce bloc, modifiez le fichier <strong>data/modules/data_forum.php</strong> pour y renseigner l''identifiant du forum li&eacute; (variable <em>$forum_id</em>, ligne. 37).</p>\r\n<p>pour trouver l''identifiant d''un forum, rendez-vous avec votre navigateur sur le forum en question et regardez son URL, qui devrait se terminer par :</p>\r\n<p><em>viewforum.php?id=<strong>XX</strong></em></p>\r\n<p><em><strong>XX</strong></em> : identifiant du forum &agrave; modifier dans <strong>data/modules/data_forum.php</strong></p>', 186, '2009-08-10 11:49:58', 186, '2011-11-12 17:07:52', '2009-09-06 19:07:21', 0, 2),
+(140, 'artistes_au_hasard', 'accueil_droite_haut', 'Artistes au hasard', 'artistes_au_hasard.php', '', 186, '2009-08-30 21:44:32', 186, '2011-11-12 15:25:33', '2009-09-06 17:16:26', 0, 1),
+(143, 'news', 'accueil_droite_bas', 'Les autres news', 'news.php', '', 186, '2009-09-01 19:57:51', 186, '2010-08-05 01:48:55', '2009-09-06 17:16:52', 1, 2),
+(152, 'forum_interne', 'interne_gauche', 'Forum', 'accueil_forum.php', '<p>Ce bloc affiche les 7 derniers messages du forum.</p>', 186, '2009-09-06 19:46:30', 186, '2011-11-12 15:52:34', '2009-09-06 19:48:57', 0, 4),
+(149, '', 'accueil_footer', 'Bloc en bas de la page d''accueil', '', '<p>Plus de docs sur <a href="http://www.revolutionsoundrecords.org/trac">le trac</a>.</p>\r\n<ul>\r\n</ul>\r\n<p>Pour les questions, les retours (...) vous &ecirc;tes invit&eacute;s &agrave; venir en parler sur le <a href="http://www.revolutionsoundrecords.org/punbb">forum de l''association Revolution Sound Records</a>.</p>', 186, '2009-09-06 16:41:15', 186, '2011-11-12 22:36:42', '2009-09-06 19:07:34', 1, 6),
+(128, 'administration', NULL, 'Administration', 'admin.php', '', 186, '2009-08-10 10:27:12', 186, '2009-09-06 00:13:40', '2009-09-06 00:13:40', 1, 4),
+(155, '', 'interne_gauche', 'News', 'menu_news.php', '<p>Affiche les 2 derni&egrave;res news et un menu pour acc&eacute;der aux autres news.</p>', 186, '2010-01-15 22:39:32', 186, '2011-11-12 16:10:38', NULL, 1, 1),
+(156, 'last_news', 'accueil_droite_bas', 'News', 'last_news.php', '<p>Ce bloc affiche une news au hazard parmis les 5 derni&egrave;res.</p>', 186, '2010-04-06 15:58:29', 186, '2011-11-12 16:07:40', NULL, 1, 1),
+(157, 'last_albums', 'interne_gauche', 'Album au hasard', 'last_albums.php', '<p>Ce bloc affiche un album au hazard.</p>', 186, '2010-04-06 17:19:27', 186, '2011-11-12 15:56:10', NULL, 1, 3),
+(158, '', 'accueil_droite_bas', 'Soutenir notre action', 'soutenir.php', '<p>Ce bloc affiche un bouton de don PayPal et, &eacute;ventuellement, un lien vers une boutique de vente en ligne.</p>\r\n<p>Avant d''utiliser ce bloc, rendez-vous dans l''administration du site, menu :</p>\r\n<p><strong>G&eacute;n&eacute;ral</strong> &gt; <strong>dons et achats</strong></p>\r\n<p>Pour y renseigner votre identifiant s&eacute;curis&eacute; PayPal et/ou le lien vers la boutique en ligne.</p>', 3, '2010-08-03 13:05:44', 186, '2011-11-12 15:54:58', NULL, 0, 3),
+(159, '', 'accueil_droite_haut', 'Administrer le site', '', '<p>Les blocs affich&eacute;s sur cette page sont des exemples d''utilisation.</p>\r\n<p>Identifiez-vous avec votre compte admin et suivez le lien <a title="administration du site" href="index.php?e=set_config">admin</a> pour vous rendre dans l''administration du site et commencer &agrave; &eacute;diter les blocs, les contenus, les comptes artistes...</p>\r\n<p>&nbsp;</p>', 186, '2010-08-04 13:54:50', 186, '2011-11-12 22:17:47', NULL, 1, 0),
+(161, '', 'accueil_gauche', 'En images', 'flickr.php', '<p>Ce bloc affiche 4 images prises au hazard sur un compte Flickr.</p>\r\n<p>Avant d''utiliser ce bloc, modifiez le fichier</p>\r\n<p><strong>boxes/flickr.php</strong></p>\r\n<p>du template pour y indiquer vos informations de connexion sur l''API Flickr.</p>', 186, '2010-08-05 15:19:23', 186, '2011-11-12 15:50:41', NULL, 0, 4);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_categories`
+--
+
+DROP TABLE IF EXISTS `rsrv5_categories`;
+CREATE TABLE `rsrv5_categories` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(64) DEFAULT NULL,
+  `titre` varchar(255) DEFAULT NULL,
+  `icone` varchar(255) DEFAULT NULL,
+  `description` text,
+  `contenu` text,
+  `ordre` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
+
+--
+-- Contenu de la table `rsrv5_categories`
+--
+
+INSERT INTO `rsrv5_categories` (`id`, `nom`, `titre`, `icone`, `description`, `contenu`, `ordre`) VALUES
+(4, 'artistes', NULL, NULL, NULL, NULL, 0),
+(5, 'presentation', NULL, NULL, NULL, NULL, 0),
+(7, 'menus', NULL, NULL, NULL, NULL, 0),
+(22, 'Nav', 'menu top', NULL, NULL, '', 0),
+(30, '', 'Accueil', NULL, NULL, 'index.php?e=edito', 0),
+(29, '', 'Forum', NULL, NULL, 'punbb', 2),
+(33, '', 'Le son', NULL, NULL, '', 1),
+(38, '', 'Les artistes', NULL, NULL, 'index.php?e=artistes', 1),
+(40, '', 'Rechercher...', NULL, NULL, 'index.php?e=rechercher', 2),
+(63, '74', NULL, NULL, NULL, '', 0),
+(1, 'editos', 'Editos', NULL, NULL, NULL, 0),
+(2, 'news', NULL, NULL, NULL, NULL, 0),
+(0, 'root', NULL, NULL, NULL, NULL, 0),
+(6, 'news', NULL, NULL, NULL, NULL, 0),
+(3, 'spotlights', 'Spotlights', NULL, NULL, NULL, 0),
+(79, 'boxes', NULL, NULL, NULL, NULL, 0),
+(80, 'accueil_left', 'accueil - colonne de gauche', NULL, NULL, NULL, 0),
+(81, 'accueil_right', 'accueil - colonne de droite', NULL, NULL, NULL, 0),
+(82, '64', NULL, NULL, NULL, '', 0),
+(83, 'pages', NULL, NULL, NULL, NULL, 0),
+(85, 'links', NULL, NULL, NULL, NULL, 0),
+(93, 'interne_left', 'pages internes - colonne de gauche', NULL, NULL, NULL, 0),
+(94, 'accueil_small_left', 'accueil - petite colonne gauche', NULL, NULL, NULL, 0),
+(95, 'accueil_small_right', 'accueil - petite colonne droite', NULL, NULL, NULL, 0),
+(99, '54', NULL, NULL, NULL, '', 0),
+(100, '3', NULL, NULL, NULL, '', 0),
+(101, '73', NULL, NULL, NULL, '', 0),
+(102, '34', NULL, NULL, NULL, '', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_categories_tree`
+--
+
+DROP TABLE IF EXISTS `rsrv5_categories_tree`;
+CREATE TABLE `rsrv5_categories_tree` (
+  `parent` int(11) NOT NULL,
+  `child` int(11) NOT NULL,
+  PRIMARY KEY (`parent`,`child`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_categories_tree`
+--
+
+INSERT INTO `rsrv5_categories_tree` (`parent`, `child`) VALUES
+(0, 1),
+(0, 2),
+(0, 3),
+(0, 4),
+(0, 7),
+(0, 79),
+(0, 83),
+(0, 85),
+(4, 5),
+(4, 6),
+(6, 82),
+(6, 99),
+(6, 100),
+(6, 101),
+(6, 102),
+(7, 22),
+(22, 29),
+(22, 30),
+(22, 33),
+(33, 38),
+(33, 40),
+(79, 80),
+(79, 81),
+(79, 93),
+(79, 94),
+(79, 95);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_concerts`
+--
+
+DROP TABLE IF EXISTS `rsrv5_concerts`;
+CREATE TABLE `rsrv5_concerts` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id_artiste` int(11) DEFAULT NULL,
+  `nom` varchar(255) DEFAULT NULL,
+  `date` datetime DEFAULT NULL,
+  `lieu` varchar(255) DEFAULT NULL,
+  `paf` int(11) DEFAULT NULL,
+  `description` text,
+  `pun_forum` int(11) DEFAULT NULL,
+  `affiche` varchar(255) DEFAULT NULL,
+  `flyer` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_concerts`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_configuration`
+--
+
+DROP TABLE IF EXISTS `rsrv5_configuration`;
+CREATE TABLE `rsrv5_configuration` (
+  `key` varchar(255) NOT NULL,
+  `value` text NOT NULL,
+  PRIMARY KEY (`key`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_configuration`
+--
+
+INSERT INTO `rsrv5_configuration` (`key`, `value`) VALUES
+('site_name', 'rsr - v.5.1.1'),
+('email_contact', 'admin@domain.tld'),
+('out', 'app/out/dist/'),
+('max_list', '10'),
+('identifiant_paypal', ''),
+('lien_boutique', '');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_contenus`
+--
+
+DROP TABLE IF EXISTS `rsrv5_contenus`;
+CREATE TABLE `rsrv5_contenus` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(64) DEFAULT NULL,
+  `categorie` int(11) DEFAULT NULL,
+  `titre` varchar(255) DEFAULT NULL,
+  `description` text,
+  `contenu` text,
+  `auteur_creation` int(11) DEFAULT NULL,
+  `date_creation` datetime DEFAULT NULL,
+  `auteur_modification` int(11) DEFAULT NULL,
+  `date_modification` datetime DEFAULT NULL,
+  `date_publication` datetime DEFAULT NULL,
+  `public` tinyint(4) DEFAULT NULL,
+  `ordre` int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=935 ;
+
+--
+-- Contenu de la table `rsrv5_contenus`
+--
+
+INSERT INTO `rsrv5_contenus` (`id`, `nom`, `categorie`, `titre`, `description`, `contenu`, `auteur_creation`, `date_creation`, `auteur_modification`, `date_modification`, `date_publication`, `public`, `ordre`) VALUES
+(919, '', 1, 'Nouvelle installation', '', '<p>Bienvenue sur votre installation de rsr v.5.</p>\r\n<p>Pensez &agrave; effacer le dossier <strong>install</strong></p>\r\n<p>&nbsp;</p>\r\n<p>Bonnes publications !</p>', 186, '2011-09-04 15:03:09', 186, '2011-11-12 22:07:24', '2011-09-04 00:00:00', 1, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_downloads`
+--
+
+DROP TABLE IF EXISTS `rsrv5_downloads`;
+CREATE TABLE `rsrv5_downloads` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id_artiste` int(11) DEFAULT NULL,
+  `id_album` int(11) DEFAULT NULL,
+  `id_licence` int(11) DEFAULT NULL,
+  `nom` varchar(255) DEFAULT NULL,
+  `date_creation` date DEFAULT NULL,
+  `style` varchar(255) DEFAULT NULL,
+  `description` text,
+  `ordre` int(11) DEFAULT NULL,
+  `actif` tinyint(4) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_downloads`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_download_urls`
+--
+
+DROP TABLE IF EXISTS `rsrv5_download_urls`;
+CREATE TABLE `rsrv5_download_urls` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id_download` int(11) DEFAULT NULL,
+  `id_format` int(11) DEFAULT NULL,
+  `qualite` int(11) DEFAULT NULL,
+  `url` varchar(255) DEFAULT NULL,
+  `taille` int(11) DEFAULT NULL,
+  `date_publication` date DEFAULT NULL,
+  `compteur` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_download_urls`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_formats`
+--
+
+DROP TABLE IF EXISTS `rsrv5_formats`;
+CREATE TABLE `rsrv5_formats` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(32) DEFAULT NULL,
+  `content_type` varchar(64) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+--
+-- Contenu de la table `rsrv5_formats`
+--
+
+INSERT INTO `rsrv5_formats` (`id`, `nom`, `content_type`) VALUES
+(1, 'ogg', 'audio/ogg'),
+(2, 'mp3', 'audio/mpeg'),
+(3, 'rar', 'application/x-rar-compressed'),
+(4, 'zip', 'application/x-zip'),
+(5, 'jpg', 'image/jpeg'),
+(6, 'pdf', 'application/pdf'),
+(7, 'avi', 'video/avi'),
+(8, 'gz', 'application/x-gzip'),
+(9, 'wav', 'audio/wav');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_licences`
+--
+
+DROP TABLE IF EXISTS `rsrv5_licences`;
+CREATE TABLE `rsrv5_licences` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `nom` varchar(255) NOT NULL DEFAULT '',
+  `lien` varchar(255) NOT NULL DEFAULT '',
+  `icone` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
+
+--
+-- Contenu de la table `rsrv5_licences`
+--
+
+INSERT INTO `rsrv5_licences` (`id`, `nom`, `lien`, `icone`) VALUES
+(1, 'Creative Commons by-nc-nd 2.0', 'http://creativecommons.org/licenses/by-nc-nd/2.0/', 'icons/licences/cc.by.nc.nd.png'),
+(2, 'Creative Commons by-nc-nd 2.5', 'http://creativecommons.org/licenses/by-nc-nd/2.5/', 'icons/licences/cc.by.nc.nd.png'),
+(3, 'Creative Commons by-nc-sa 2.0', 'http://creativecommons.org/licenses/by-nc-sa/2.0/', 'icons/licences/cc.by.nc.sa.png'),
+(4, 'Creative Commons by-nc-sa 2.5', 'http://creativecommons.org/licenses/by-nc-sa/2.5/', 'icons/licences/cc.by.nc.sa.png'),
+(5, 'Creative Commons by-nc 2.0', 'http://creativecommons.org/licenses/by-nc/2.0/', 'icons/licences/cc.by.nc.png'),
+(6, 'Creative Commons by-nc 2.5', 'http://creativecommons.org/licenses/by-nc/2.5/', 'icons/licences/cc.by.nc.png'),
+(7, 'Creative Commons by-nd 2.0', 'http://creativecommons.org/licenses/by-nd/2.0/', 'icons/licences/cc.by.nd.png'),
+(8, 'Creative Commons by-nd 2.5', 'http://creativecommons.org/licenses/by-nd/2.5/', 'icons/licences/cc.by.nd.png'),
+(9, 'Creative Commons by-sa 2.0', 'http://creativecommons.org/licenses/by-sa/2.0/', 'icons/licences/cc.by.sa.png'),
+(10, 'Creative Commons by-sa 2.5', 'http://creativecommons.org/licenses/by-sa/2.5/', 'icons/licences/cc.by.sa.png'),
+(11, 'Creative Commons by 2.0', 'http://creativecommons.org/licenses/by/2.0/', 'icons/licences/cc.by.png'),
+(12, 'Creative Commons by 2.5', 'http://creativecommons.org/licenses/by/2.5/', 'icons/licences/cc.by.png'),
+(13, 'Licence Art Libre', 'http://artlibre.org/licence/lal/', ''),
+(14, 'Licence C Reaction', 'http://morne.free.fr/Necktar7/creactionfr.htm', ''),
+(15, 'Domaine Public', '', ''),
+(16, 'Licence GNU GPL (GNUArt)', 'http://gnuart.org/francais/gnugpl.html', '');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_playlists`
+--
+
+DROP TABLE IF EXISTS `rsrv5_playlists`;
+CREATE TABLE `rsrv5_playlists` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `pun_user` int(11) NOT NULL,
+  `titre` varchar(255) NOT NULL,
+  `description` text NOT NULL,
+  `creation` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_playlists`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_playlist_download`
+--
+
+DROP TABLE IF EXISTS `rsrv5_playlist_download`;
+CREATE TABLE `rsrv5_playlist_download` (
+  `id` int(11) NOT NULL,
+  `id_download` int(11) NOT NULL,
+  PRIMARY KEY (`id`,`id_download`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_playlist_download`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_bans`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_bans`;
+CREATE TABLE `rsrv5_pun_bans` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `username` varchar(200) DEFAULT NULL,
+  `ip` varchar(255) DEFAULT NULL,
+  `email` varchar(80) DEFAULT NULL,
+  `message` varchar(255) DEFAULT NULL,
+  `expire` int(10) unsigned DEFAULT NULL,
+  `ban_creator` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `rsrv5_pun_bans_username_idx` (`username`(25))
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+--
+-- Contenu de la table `rsrv5_pun_bans`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_categories`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_categories`;
+CREATE TABLE `rsrv5_pun_categories` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `cat_name` varchar(80) NOT NULL DEFAULT 'New Category',
+  `disp_position` int(10) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
+
+--
+-- Contenu de la table `rsrv5_pun_categories`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_censoring`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_censoring`;
+CREATE TABLE `rsrv5_pun_censoring` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `search_for` varchar(60) NOT NULL DEFAULT '',
+  `replace_with` varchar(60) NOT NULL DEFAULT '',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_pun_censoring`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_config`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_config`;
+CREATE TABLE `rsrv5_pun_config` (
+  `conf_name` varchar(255) NOT NULL DEFAULT '',
+  `conf_value` text,
+  PRIMARY KEY (`conf_name`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_config`
+--
+
+INSERT INTO `rsrv5_pun_config` (`conf_name`, `conf_value`) VALUES
+('o_cur_version', '1.4.7'),
+('o_cur_version_fr', '1.2.10'),
+('o_board_title', 'Forums'),
+('o_board_desc', NULL),
+('o_default_timezone', '0'),
+('o_time_format', 'H:i:s'),
+('o_date_format', 'd-m-Y'),
+('o_timeout_visit', '1800'),
+('o_timeout_online', '300'),
+('o_redirect_delay', '1'),
+('o_show_version', '1'),
+('o_show_user_info', '1'),
+('o_show_post_count', '1'),
+('o_smilies', '1'),
+('o_smilies_sig', '0'),
+('o_make_links', '1'),
+('o_default_lang', 'French'),
+('o_default_style', 'Rsr'),
+('o_default_user_group', '4'),
+('o_topic_review', '15'),
+('o_disp_topics_default', '30'),
+('o_disp_posts_default', '25'),
+('o_indent_num_spaces', '4'),
+('o_quickpost', '1'),
+('o_users_online', '1'),
+('o_censoring', '0'),
+('o_ranks', '1'),
+('o_show_dot', '0'),
+('o_quickjump', '1'),
+('o_gzip', '0'),
+('o_additional_navlinks', NULL),
+('o_report_method', '2'),
+('o_regs_report', '1'),
+('o_mailing_list', 'admin@domain.tld'),
+('o_avatars', '1'),
+('o_avatars_dir', 'img/avatars'),
+('o_avatars_width', '128'),
+('o_avatars_height', '128'),
+('o_avatars_size', '25000'),
+('o_search_all_forums', '1'),
+('o_base_url', 'http://rsr.v5.dev/punbb'),
+('o_admin_email', 'admin@domain.tld'),
+('o_webmaster_email', 'admin@domain.tld'),
+('o_topic_subscriptions', '1'),
+('o_smtp_host', NULL),
+('o_smtp_user', NULL),
+('o_smtp_pass', NULL),
+('o_regs_allow', '1'),
+('o_regs_verify', '0'),
+('o_announcement', '0'),
+('o_announcement_message', 'Saisissez votre annonce ici.'),
+('o_regs_captchabox', '1'),
+('o_guest_post_captchabox', '0'),
+('o_rules', '0'),
+('o_rules_message', 'Saisissez vos rÃšgles d''utilisation ici.'),
+('o_maintenance', '0'),
+('o_maintenance_message', 'Les forums sont temporairement fermÃ©s pour des raisons de maintenance. Nous vous prions de bien vouloir nous excuser pour cette gÃšne. Veuillez essayer Ã  nouveau d''ici quelques minutes.<br />\n<br />\nRevolution Sound Records'),
+('o_forum_subscriptions', '1'),
+('p_message_bbcode', '1'),
+('p_message_img_tag', '1'),
+('p_message_all_caps', '1'),
+('p_subject_all_caps', '0'),
+('p_sig_all_caps', '0'),
+('p_sig_bbcode', '1'),
+('p_sig_img_tag', '1'),
+('p_sig_length', '400'),
+('p_sig_lines', '4'),
+('p_allow_banned_email', '1'),
+('p_allow_dupe_email', '0'),
+('p_force_guest_email', '1'),
+('o_database_revision', '15'),
+('o_searchindex_revision', '2'),
+('o_parser_revision', '2'),
+('o_default_email_setting', '1'),
+('o_topic_views', '1'),
+('o_signatures', '1'),
+('o_smtp_ssl', '0'),
+('o_default_dst', '0'),
+('o_quote_depth', '3'),
+('o_feed_type', '2'),
+('o_feed_ttl', '0');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_forums`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_forums`;
+CREATE TABLE `rsrv5_pun_forums` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `forum_name` varchar(80) NOT NULL DEFAULT 'New forum',
+  `forum_desc` text,
+  `redirect_url` varchar(100) DEFAULT NULL,
+  `moderators` text,
+  `num_topics` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `num_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `last_post` int(10) unsigned DEFAULT NULL,
+  `last_post_id` int(10) unsigned DEFAULT NULL,
+  `last_poster` varchar(200) DEFAULT NULL,
+  `sort_by` tinyint(1) NOT NULL DEFAULT '0',
+  `disp_position` int(10) NOT NULL DEFAULT '0',
+  `cat_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
+
+--
+-- Contenu de la table `rsrv5_pun_forums`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_forum_perms`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_forum_perms`;
+CREATE TABLE `rsrv5_pun_forum_perms` (
+  `group_id` int(10) NOT NULL DEFAULT '0',
+  `forum_id` int(10) NOT NULL DEFAULT '0',
+  `read_forum` tinyint(1) NOT NULL DEFAULT '1',
+  `post_replies` tinyint(1) NOT NULL DEFAULT '1',
+  `post_topics` tinyint(1) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`group_id`,`forum_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_forum_perms`
+--
+
+INSERT INTO `rsrv5_pun_forum_perms` (`group_id`, `forum_id`, `read_forum`, `post_replies`, `post_topics`) VALUES
+(3, 48, 0, 0, 0),
+(4, 48, 0, 0, 0),
+(5, 48, 0, 0, 0),
+(6, 48, 0, 0, 0),
+(3, 75, 0, 0, 0),
+(4, 75, 0, 0, 0),
+(5, 75, 0, 0, 0),
+(6, 75, 0, 0, 0),
+(3, 77, 0, 0, 0),
+(4, 77, 0, 0, 0),
+(5, 77, 0, 0, 0),
+(6, 77, 0, 0, 0),
+(3, 78, 0, 0, 0),
+(4, 78, 0, 0, 0),
+(5, 78, 0, 0, 0),
+(6, 78, 0, 0, 0),
+(3, 79, 0, 0, 0),
+(4, 79, 0, 0, 0),
+(5, 79, 0, 0, 0),
+(6, 79, 0, 0, 0),
+(3, 80, 0, 0, 0),
+(4, 80, 0, 0, 0),
+(5, 80, 0, 0, 0),
+(6, 80, 0, 0, 0);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_forum_subscriptions`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_forum_subscriptions`;
+CREATE TABLE `rsrv5_pun_forum_subscriptions` (
+  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`user_id`,`forum_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_forum_subscriptions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_groups`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_groups`;
+CREATE TABLE `rsrv5_pun_groups` (
+  `g_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `g_title` varchar(50) NOT NULL DEFAULT '',
+  `g_user_title` varchar(50) DEFAULT NULL,
+  `g_moderator` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',
+  `g_read_board` tinyint(1) NOT NULL DEFAULT '1',
+  `g_view_users` tinyint(1) NOT NULL DEFAULT '1',
+  `g_post_replies` tinyint(1) NOT NULL DEFAULT '1',
+  `g_post_topics` tinyint(1) NOT NULL DEFAULT '1',
+  `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',
+  `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',
+  `g_delete_topics` tinyint(1) NOT NULL DEFAULT '1',
+  `g_set_title` tinyint(1) NOT NULL DEFAULT '1',
+  `g_search` tinyint(1) NOT NULL DEFAULT '1',
+  `g_search_users` tinyint(1) NOT NULL DEFAULT '1',
+  `g_send_email` tinyint(1) NOT NULL DEFAULT '1',
+  `g_post_flood` smallint(6) NOT NULL DEFAULT '30',
+  `g_search_flood` smallint(6) NOT NULL DEFAULT '30',
+  `g_email_flood` smallint(6) NOT NULL DEFAULT '60',
+  `g_report_flood` smallint(6) NOT NULL DEFAULT '60',
+  PRIMARY KEY (`g_id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
+
+--
+-- Contenu de la table `rsrv5_pun_groups`
+--
+
+INSERT INTO `rsrv5_pun_groups` (`g_id`, `g_title`, `g_user_title`, `g_moderator`, `g_mod_edit_users`, `g_mod_rename_users`, `g_mod_change_passwords`, `g_mod_ban_users`, `g_read_board`, `g_view_users`, `g_post_replies`, `g_post_topics`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_send_email`, `g_post_flood`, `g_search_flood`, `g_email_flood`, `g_report_flood`) VALUES
+(1, 'Admin', 'Admin', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(2, 'ModÃ©rateurs', 'ModÃ©rateur', 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0),
+(3, 'Touriste', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0),
+(4, 'Membres', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60),
+(5, 'Artiste', 'Artiste', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 10, 10, 60, 60),
+(6, '100 eme Membre', '100 eme Membre', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60, 60);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_online`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_online`;
+CREATE TABLE `rsrv5_pun_online` (
+  `user_id` int(10) unsigned NOT NULL DEFAULT '1',
+  `ident` varchar(200) NOT NULL DEFAULT '',
+  `logged` int(10) unsigned NOT NULL DEFAULT '0',
+  `idle` tinyint(1) NOT NULL DEFAULT '0',
+  `last_post` int(10) unsigned DEFAULT NULL,
+  `last_search` int(10) unsigned DEFAULT NULL,
+  UNIQUE KEY `rsrv5_pun_online_user_id_ident_idx` (`user_id`,`ident`(25)),
+  KEY `pun_online_user_id_idx` (`user_id`),
+  KEY `rsrv5_pun_online_ident_idx` (`ident`(25)),
+  KEY `rsrv5_pun_online_logged_idx` (`logged`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_online`
+--
+
+INSERT INTO `rsrv5_pun_online` (`user_id`, `ident`, `logged`, `idle`, `last_post`, `last_search`) VALUES
+(1, '192.168.10.13', 1321306351, 0, NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_posts`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_posts`;
+CREATE TABLE `rsrv5_pun_posts` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `poster` varchar(200) NOT NULL DEFAULT '',
+  `poster_id` int(10) unsigned NOT NULL DEFAULT '1',
+  `poster_ip` varchar(39) DEFAULT NULL,
+  `poster_email` varchar(80) DEFAULT NULL,
+  `message` mediumtext,
+  `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',
+  `posted` int(10) unsigned NOT NULL DEFAULT '0',
+  `edited` int(10) unsigned DEFAULT NULL,
+  `edited_by` varchar(200) DEFAULT NULL,
+  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `pun_posts_topic_id_idx` (`topic_id`),
+  KEY `pun_posts_multi_idx` (`poster_id`,`topic_id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21233 ;
+
+--
+-- Contenu de la table `rsrv5_pun_posts`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_ranks`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_ranks`;
+CREATE TABLE `rsrv5_pun_ranks` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `rank` varchar(50) NOT NULL DEFAULT '',
+  `min_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+--
+-- Contenu de la table `rsrv5_pun_ranks`
+--
+
+INSERT INTO `rsrv5_pun_ranks` (`id`, `rank`, `min_posts`) VALUES
+(1, 'Apprenti posteur', 0),
+(3, 'Posteur', 100),
+(4, 'Posteur chef', 200),
+(5, 'Serial posteur', 300),
+(7, 'Les doigts greffÃ©s au clavier', 1000);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_reports`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_reports`;
+CREATE TABLE `rsrv5_pun_reports` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `post_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `reported_by` int(10) unsigned NOT NULL DEFAULT '0',
+  `created` int(10) unsigned NOT NULL DEFAULT '0',
+  `message` text NOT NULL,
+  `zapped` int(10) unsigned DEFAULT NULL,
+  `zapped_by` int(10) unsigned DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `pun_reports_zapped_idx` (`zapped`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+
+--
+-- Contenu de la table `rsrv5_pun_reports`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_search_cache`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_search_cache`;
+CREATE TABLE `rsrv5_pun_search_cache` (
+  `id` int(10) unsigned NOT NULL DEFAULT '0',
+  `ident` varchar(200) NOT NULL DEFAULT '',
+  `search_data` mediumtext,
+  PRIMARY KEY (`id`),
+  KEY `pun_search_cache_ident_idx` (`ident`(8))
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_search_cache`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_search_matches`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_search_matches`;
+CREATE TABLE `rsrv5_pun_search_matches` (
+  `post_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `subject_match` tinyint(1) NOT NULL DEFAULT '0',
+  KEY `pun_search_matches_word_id_idx` (`word_id`),
+  KEY `pun_search_matches_post_id_idx` (`post_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_search_matches`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_search_words`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_search_words`;
+CREATE TABLE `rsrv5_pun_search_words` (
+  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
+  `word` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
+  PRIMARY KEY (`word`),
+  KEY `pun_search_words_id_idx` (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_pun_search_words`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_smilies`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_smilies`;
+CREATE TABLE `rsrv5_pun_smilies` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `image` varchar(60) NOT NULL DEFAULT '',
+  `text` varchar(60) NOT NULL DEFAULT '',
+  `disp_position` int(10) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;
+
+--
+-- Contenu de la table `rsrv5_pun_smilies`
+--
+
+INSERT INTO `rsrv5_pun_smilies` (`id`, `image`, `text`, `disp_position`) VALUES
+(45, 'canon.gif', ':top:', 0),
+(10, 'big_smile.png', ':D', 0),
+(11, 'cool.png', ':cool:', 0),
+(21, 'hmm.png', ':/', 0),
+(24, 'mad.png', ':mad2:', 0),
+(25, 'neutral.png', ':|', 0),
+(26, 'roll.png', ':roll:', 0),
+(29, 'sad.png', ':(', 3),
+(31, 'smile.png', ':)', 4),
+(33, 'tongue.png', ':p', 6),
+(35, 'wink.png', ';)', 7),
+(37, 'yikes.png', ':d', 0),
+(56, 'whaouh6na.gif', 'whaou', 0),
+(87, 'terminator.png', ':terminator:', 0);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_topics`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_topics`;
+CREATE TABLE `rsrv5_pun_topics` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `poster` varchar(200) NOT NULL DEFAULT '',
+  `subject` varchar(255) NOT NULL DEFAULT '',
+  `posted` int(10) unsigned NOT NULL DEFAULT '0',
+  `first_post_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `last_post` int(10) unsigned NOT NULL DEFAULT '0',
+  `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `last_poster` varchar(200) DEFAULT NULL,
+  `num_views` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `num_replies` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `closed` tinyint(1) NOT NULL DEFAULT '0',
+  `sticky` tinyint(1) NOT NULL DEFAULT '0',
+  `moved_to` int(10) unsigned DEFAULT NULL,
+  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `pun_topics_forum_id_idx` (`forum_id`),
+  KEY `pun_topics_moved_to_idx` (`moved_to`),
+  KEY `rsrv5_pun_topics_last_post_idx` (`last_post`),
+  KEY `rsrv5_pun_topics_first_post_id_idx` (`first_post_id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2441 ;
+
+--
+-- Contenu de la table `rsrv5_pun_topics`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_topic_subscriptions`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_topic_subscriptions`;
+CREATE TABLE `rsrv5_pun_topic_subscriptions` (
+  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`user_id`,`topic_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_pun_topic_subscriptions`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_pun_users`
+--
+
+DROP TABLE IF EXISTS `rsrv5_pun_users`;
+CREATE TABLE `rsrv5_pun_users` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `group_id` int(10) unsigned NOT NULL DEFAULT '4',
+  `username` varchar(200) NOT NULL DEFAULT '',
+  `password` varchar(40) NOT NULL DEFAULT '',
+  `email` varchar(80) NOT NULL DEFAULT '',
+  `title` varchar(50) DEFAULT NULL,
+  `realname` varchar(40) DEFAULT NULL,
+  `url` varchar(100) DEFAULT NULL,
+  `jabber` varchar(80) DEFAULT NULL,
+  `icq` varchar(12) DEFAULT NULL,
+  `msn` varchar(80) DEFAULT NULL,
+  `aim` varchar(30) DEFAULT NULL,
+  `yahoo` varchar(30) DEFAULT NULL,
+  `location` varchar(30) DEFAULT NULL,
+  `signature` text,
+  `disp_topics` tinyint(3) unsigned DEFAULT NULL,
+  `disp_posts` tinyint(3) unsigned DEFAULT NULL,
+  `email_setting` tinyint(1) NOT NULL DEFAULT '1',
+  `notify_with_post` tinyint(1) NOT NULL DEFAULT '0',
+  `auto_notify` tinyint(1) NOT NULL DEFAULT '0',
+  `show_smilies` tinyint(1) NOT NULL DEFAULT '1',
+  `show_img` tinyint(1) NOT NULL DEFAULT '1',
+  `show_img_sig` tinyint(1) NOT NULL DEFAULT '1',
+  `show_avatars` tinyint(1) NOT NULL DEFAULT '1',
+  `show_sig` tinyint(1) NOT NULL DEFAULT '1',
+  `timezone` float NOT NULL DEFAULT '0',
+  `dst` tinyint(1) NOT NULL DEFAULT '0',
+  `date_format` tinyint(1) NOT NULL DEFAULT '0',
+  `time_format` tinyint(1) NOT NULL DEFAULT '0',
+  `language` varchar(25) NOT NULL DEFAULT 'English',
+  `style` varchar(25) NOT NULL DEFAULT 'Oxygen',
+  `num_posts` int(10) unsigned NOT NULL DEFAULT '0',
+  `last_post` int(10) unsigned DEFAULT NULL,
+  `last_search` int(10) unsigned DEFAULT NULL,
+  `last_email_sent` int(10) unsigned DEFAULT NULL,
+  `last_report_sent` int(10) unsigned DEFAULT NULL,
+  `registered` int(10) unsigned NOT NULL DEFAULT '0',
+  `registration_ip` varchar(39) NOT NULL DEFAULT '0.0.0.0',
+  `last_visit` int(10) unsigned NOT NULL DEFAULT '0',
+  `admin_note` varchar(30) DEFAULT NULL,
+  `activate_string` varchar(80) DEFAULT NULL,
+  `activate_key` varchar(8) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `rsrv5_pun_users_username_idx` (`username`(25)),
+  KEY `pun_users_registered_idx` (`registered`),
+  KEY `pun_users_username_idx` (`username`(8))
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1559 ;
+
+--
+-- Contenu de la table `rsrv5_pun_users`
+--
+
+INSERT INTO `rsrv5_pun_users` (`id`, `group_id`, `username`, `password`, `email`, `title`, `realname`, `url`, `jabber`, `icq`, `msn`, `aim`, `yahoo`, `location`, `signature`, `disp_topics`, `disp_posts`, `email_setting`, `notify_with_post`, `auto_notify`, `show_smilies`, `show_img`, `show_img_sig`, `show_avatars`, `show_sig`, `timezone`, `dst`, `date_format`, `time_format`, `language`, `style`, `num_posts`, `last_post`, `last_search`, `last_email_sent`, `last_report_sent`, `registered`, `registration_ip`, `last_visit`, `admin_note`, `activate_string`, `activate_key`) VALUES
+(186, 1, 'admin', '90f1b3c6cf62b05606b215265803f553e22bc657', 'admin@domain.tld', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'French', 'Rsr', 1382, 1321043538, NULL, NULL, NULL, 1156702867, '82.243.194.97', 1321305012, NULL, NULL, NULL),
+(1, 3, 'InvitÃ©', 'InvitÃ©', 'InvitÃ©', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 'English', 'Oxygen', 0, NULL, NULL, NULL, NULL, 0, '0.0.0.0', 0, NULL, NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_super_admins`
+--
+
+DROP TABLE IF EXISTS `rsrv5_super_admins`;
+CREATE TABLE `rsrv5_super_admins` (
+  `id_pun_user` int(11) NOT NULL,
+  PRIMARY KEY (`id_pun_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `rsrv5_super_admins`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_thumbs`
+--
+
+DROP TABLE IF EXISTS `rsrv5_thumbs`;
+CREATE TABLE `rsrv5_thumbs` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `src` varchar(255) NOT NULL DEFAULT '',
+  `src_width` int(11) NOT NULL DEFAULT '0',
+  `src_height` int(11) NOT NULL DEFAULT '0',
+  `max_width` int(11) NOT NULL DEFAULT '0',
+  `max_height` int(11) NOT NULL DEFAULT '0',
+  `thumb_file` varchar(255) NOT NULL,
+  `thumb_width` int(11) NOT NULL DEFAULT '0',
+  `thumb_height` int(11) NOT NULL DEFAULT '0',
+  `creation_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_thumbs`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `rsrv5_videos`
+--
+
+DROP TABLE IF EXISTS `rsrv5_videos`;
+CREATE TABLE `rsrv5_videos` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `id_artiste` int(11) DEFAULT NULL,
+  `titre` varchar(255) DEFAULT NULL,
+  `description` text,
+  `url` varchar(255) DEFAULT NULL,
+  `id_licence` int(11) DEFAULT NULL,
+  `date_creation` date DEFAULT NULL,
+  `date_publication` date DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Contenu de la table `rsrv5_videos`
+--
+
Index: branches/rsr.v5.1.1/web/install/dist/sql/tables.sql
===================================================================
--- branches/rsr.v5.1.dev/web/install/dist/sql/tables.sql	(revision 1)
+++ branches/rsr.v5.1.1/web/install/dist/sql/tables.sql	(revision 4)
@@ -1,3 +1,3 @@
-CREATE TABLE IF NOT EXISTS `[prefix]albums` (
+CREATE TABLE `[prefix]albums` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_artiste` int(11) NOT NULL,
@@ -16,5 +16,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]artistes` (
+CREATE TABLE `[prefix]artistes` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(255) DEFAULT NULL,
@@ -40,5 +40,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]artistes_admins` (
+CREATE TABLE `[prefix]artistes_admins` (
   `id_artiste` int(11) NOT NULL,
   `pun_user` int(11) NOT NULL,
@@ -46,5 +46,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]boxes` (
+CREATE TABLE `[prefix]boxes` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(64) DEFAULT NULL,
@@ -63,5 +63,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]categories` (
+CREATE TABLE `[prefix]categories` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(64) DEFAULT NULL,
@@ -74,5 +74,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]categories_tree` (
+CREATE TABLE `[prefix]categories_tree` (
   `parent` int(11) NOT NULL,
   `child` int(11) NOT NULL,
@@ -80,5 +80,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]concerts` (
+CREATE TABLE `[prefix]concerts` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_artiste` int(11) DEFAULT NULL,
@@ -94,5 +94,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]configuration` (
+CREATE TABLE `[prefix]configuration` (
   `key` varchar(255) NOT NULL,
   `value` text NOT NULL,
@@ -100,5 +100,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]contenus` (
+CREATE TABLE `[prefix]contenus` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(64) DEFAULT NULL,
@@ -117,5 +117,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=935 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]downloads` (
+CREATE TABLE `[prefix]downloads` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_artiste` int(11) DEFAULT NULL,
@@ -131,5 +131,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]download_urls` (
+CREATE TABLE `[prefix]download_urls` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_download` int(11) DEFAULT NULL,
@@ -143,5 +143,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]formats` (
+CREATE TABLE `[prefix]formats` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(32) DEFAULT NULL,
@@ -150,5 +150,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]licences` (
+CREATE TABLE `[prefix]licences` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `nom` varchar(255) NOT NULL DEFAULT '',
@@ -158,5 +158,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]playlists` (
+CREATE TABLE `[prefix]playlists` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `pun_user` int(11) NOT NULL,
@@ -167,5 +167,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]playlist_download` (
+CREATE TABLE `[prefix]playlist_download` (
   `id` int(11) NOT NULL,
   `id_download` int(11) NOT NULL,
@@ -173,15 +173,17 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_bans` (
+CREATE TABLE `[prefix]pun_bans` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `username` varchar(200) DEFAULT NULL,
   `ip` varchar(255) DEFAULT NULL,
-  `email` varchar(50) DEFAULT NULL,
+  `email` varchar(80) DEFAULT NULL,
   `message` varchar(255) DEFAULT NULL,
   `expire` int(10) unsigned DEFAULT NULL,
-  PRIMARY KEY (`id`)
+  `ban_creator` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `[prefix]pun_bans_username_idx` (`username`(25))
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_categories` (
+CREATE TABLE `[prefix]pun_categories` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `cat_name` varchar(80) NOT NULL DEFAULT 'New Category',
@@ -190,5 +192,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_censoring` (
+CREATE TABLE `[prefix]pun_censoring` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `search_for` varchar(60) NOT NULL DEFAULT '',
@@ -197,5 +199,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_config` (
+CREATE TABLE `[prefix]pun_config` (
   `conf_name` varchar(255) NOT NULL DEFAULT '',
   `conf_value` text,
@@ -203,5 +205,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_forums` (
+CREATE TABLE `[prefix]pun_forums` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `forum_name` varchar(80) NOT NULL DEFAULT 'New forum',
@@ -220,5 +222,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_forum_perms` (
+CREATE TABLE `[prefix]pun_forum_perms` (
   `group_id` int(10) NOT NULL DEFAULT '0',
   `forum_id` int(10) NOT NULL DEFAULT '0',
@@ -229,12 +231,23 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_groups` (
+CREATE TABLE `[prefix]pun_forum_subscriptions` (
+  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `forum_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`user_id`,`forum_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+# --
+CREATE TABLE `[prefix]pun_groups` (
   `g_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `g_title` varchar(50) NOT NULL DEFAULT '',
   `g_user_title` varchar(50) DEFAULT NULL,
+  `g_moderator` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',
+  `g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',
   `g_read_board` tinyint(1) NOT NULL DEFAULT '1',
+  `g_view_users` tinyint(1) NOT NULL DEFAULT '1',
   `g_post_replies` tinyint(1) NOT NULL DEFAULT '1',
   `g_post_topics` tinyint(1) NOT NULL DEFAULT '1',
-  `g_post_polls` tinyint(1) NOT NULL DEFAULT '1',
   `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',
   `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',
@@ -243,25 +256,32 @@
   `g_search` tinyint(1) NOT NULL DEFAULT '1',
   `g_search_users` tinyint(1) NOT NULL DEFAULT '1',
-  `g_edit_subjects_interval` smallint(6) NOT NULL DEFAULT '300',
+  `g_send_email` tinyint(1) NOT NULL DEFAULT '1',
   `g_post_flood` smallint(6) NOT NULL DEFAULT '30',
   `g_search_flood` smallint(6) NOT NULL DEFAULT '30',
+  `g_email_flood` smallint(6) NOT NULL DEFAULT '60',
+  `g_report_flood` smallint(6) NOT NULL DEFAULT '60',
   PRIMARY KEY (`g_id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_online` (
+CREATE TABLE `[prefix]pun_online` (
   `user_id` int(10) unsigned NOT NULL DEFAULT '1',
   `ident` varchar(200) NOT NULL DEFAULT '',
   `logged` int(10) unsigned NOT NULL DEFAULT '0',
   `idle` tinyint(1) NOT NULL DEFAULT '0',
-  KEY `pun_online_user_id_idx` (`user_id`)
-) ENGINE=MEMORY DEFAULT CHARSET=utf8;
-# --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_posts` (
+  `last_post` int(10) unsigned DEFAULT NULL,
+  `last_search` int(10) unsigned DEFAULT NULL,
+  UNIQUE KEY `[prefix]pun_online_user_id_ident_idx` (`user_id`,`ident`(25)),
+  KEY `pun_online_user_id_idx` (`user_id`),
+  KEY `[prefix]pun_online_ident_idx` (`ident`(25)),
+  KEY `[prefix]pun_online_logged_idx` (`logged`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+# --
+CREATE TABLE `[prefix]pun_posts` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `poster` varchar(200) NOT NULL DEFAULT '',
   `poster_id` int(10) unsigned NOT NULL DEFAULT '1',
-  `poster_ip` varchar(15) DEFAULT NULL,
-  `poster_email` varchar(50) DEFAULT NULL,
-  `message` text NOT NULL,
+  `poster_ip` varchar(39) DEFAULT NULL,
+  `poster_email` varchar(80) DEFAULT NULL,
+  `message` mediumtext,
   `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',
   `posted` int(10) unsigned NOT NULL DEFAULT '0',
@@ -274,5 +294,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21233 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_ranks` (
+CREATE TABLE `[prefix]pun_ranks` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `rank` varchar(50) NOT NULL DEFAULT '',
@@ -281,5 +301,5 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_reports` (
+CREATE TABLE `[prefix]pun_reports` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `post_id` int(10) unsigned NOT NULL DEFAULT '0',
@@ -295,13 +315,13 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_search_cache` (
+CREATE TABLE `[prefix]pun_search_cache` (
   `id` int(10) unsigned NOT NULL DEFAULT '0',
   `ident` varchar(200) NOT NULL DEFAULT '',
-  `search_data` text NOT NULL,
+  `search_data` mediumtext,
   PRIMARY KEY (`id`),
   KEY `pun_search_cache_ident_idx` (`ident`(8))
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_search_matches` (
+CREATE TABLE `[prefix]pun_search_matches` (
   `post_id` int(10) unsigned NOT NULL DEFAULT '0',
   `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -311,5 +331,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_search_words` (
+CREATE TABLE `[prefix]pun_search_words` (
   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   `word` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
@@ -318,5 +338,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_smilies` (
+CREATE TABLE `[prefix]pun_smilies` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `image` varchar(60) NOT NULL DEFAULT '',
@@ -326,15 +346,10 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_subscriptions` (
-  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
-  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`user_id`,`topic_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-# --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_topics` (
+CREATE TABLE `[prefix]pun_topics` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `poster` varchar(200) NOT NULL DEFAULT '',
   `subject` varchar(255) NOT NULL DEFAULT '',
   `posted` int(10) unsigned NOT NULL DEFAULT '0',
+  `first_post_id` int(10) unsigned NOT NULL DEFAULT '0',
   `last_post` int(10) unsigned NOT NULL DEFAULT '0',
   `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',
@@ -348,29 +363,36 @@
   PRIMARY KEY (`id`),
   KEY `pun_topics_forum_id_idx` (`forum_id`),
-  KEY `pun_topics_moved_to_idx` (`moved_to`)
+  KEY `pun_topics_moved_to_idx` (`moved_to`),
+  KEY `[prefix]pun_topics_last_post_idx` (`last_post`),
+  KEY `[prefix]pun_topics_first_post_id_idx` (`first_post_id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2441 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]pun_users` (
+CREATE TABLE `[prefix]pun_topic_subscriptions` (
+  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`user_id`,`topic_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+# --
+CREATE TABLE `[prefix]pun_users` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `group_id` int(10) unsigned NOT NULL DEFAULT '4',
   `username` varchar(200) NOT NULL DEFAULT '',
   `password` varchar(40) NOT NULL DEFAULT '',
-  `email` varchar(50) NOT NULL DEFAULT '',
+  `email` varchar(80) NOT NULL DEFAULT '',
   `title` varchar(50) DEFAULT NULL,
   `realname` varchar(40) DEFAULT NULL,
   `url` varchar(100) DEFAULT NULL,
-  `jabber` varchar(75) DEFAULT NULL,
+  `jabber` varchar(80) DEFAULT NULL,
   `icq` varchar(12) DEFAULT NULL,
-  `msn` varchar(50) DEFAULT NULL,
+  `msn` varchar(80) DEFAULT NULL,
   `aim` varchar(30) DEFAULT NULL,
   `yahoo` varchar(30) DEFAULT NULL,
   `location` varchar(30) DEFAULT NULL,
-  `use_avatar` tinyint(1) NOT NULL DEFAULT '0',
   `signature` text,
   `disp_topics` tinyint(3) unsigned DEFAULT NULL,
   `disp_posts` tinyint(3) unsigned DEFAULT NULL,
   `email_setting` tinyint(1) NOT NULL DEFAULT '1',
-  `save_pass` tinyint(1) NOT NULL DEFAULT '1',
   `notify_with_post` tinyint(1) NOT NULL DEFAULT '0',
+  `auto_notify` tinyint(1) NOT NULL DEFAULT '0',
   `show_smilies` tinyint(1) NOT NULL DEFAULT '1',
   `show_img` tinyint(1) NOT NULL DEFAULT '1',
@@ -379,25 +401,32 @@
   `show_sig` tinyint(1) NOT NULL DEFAULT '1',
   `timezone` float NOT NULL DEFAULT '0',
+  `dst` tinyint(1) NOT NULL DEFAULT '0',
+  `date_format` tinyint(1) NOT NULL DEFAULT '0',
+  `time_format` tinyint(1) NOT NULL DEFAULT '0',
   `language` varchar(25) NOT NULL DEFAULT 'English',
   `style` varchar(25) NOT NULL DEFAULT 'Oxygen',
   `num_posts` int(10) unsigned NOT NULL DEFAULT '0',
   `last_post` int(10) unsigned DEFAULT NULL,
+  `last_search` int(10) unsigned DEFAULT NULL,
+  `last_email_sent` int(10) unsigned DEFAULT NULL,
+  `last_report_sent` int(10) unsigned DEFAULT NULL,
   `registered` int(10) unsigned NOT NULL DEFAULT '0',
-  `registration_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
+  `registration_ip` varchar(39) NOT NULL DEFAULT '0.0.0.0',
   `last_visit` int(10) unsigned NOT NULL DEFAULT '0',
   `admin_note` varchar(30) DEFAULT NULL,
-  `activate_string` varchar(50) DEFAULT NULL,
+  `activate_string` varchar(80) DEFAULT NULL,
   `activate_key` varchar(8) DEFAULT NULL,
   PRIMARY KEY (`id`),
+  UNIQUE KEY `[prefix]_pun_users_username_idx` (`username`(25)),
   KEY `pun_users_registered_idx` (`registered`),
   KEY `pun_users_username_idx` (`username`(8))
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1559 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]super_admins` (
+CREATE TABLE `[prefix]super_admins` (
   `id_pun_user` int(11) NOT NULL,
   PRIMARY KEY (`id_pun_user`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]thumbs` (
+CREATE TABLE `[prefix]thumbs` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `src` varchar(255) NOT NULL DEFAULT '',
@@ -413,5 +442,5 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 # --
-CREATE TABLE IF NOT EXISTS `[prefix]videos` (
+CREATE TABLE `[prefix]videos` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `id_artiste` int(11) DEFAULT NULL,
