-- 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


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

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

--
-- Structure de la table `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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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 ;

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

--
-- Structure de la table `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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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;

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

--
-- Structure de la table `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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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`
--

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;

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

--
-- Structure de la table `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`
--

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`
--

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`
--

