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

--
-- Structure de la table `repro_list`
--

CREATE TABLE IF NOT EXISTS `repro_list` (
  `repro_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `repro_name` varchar(100) NOT NULL,
  `repro_url` varchar(255) NOT NULL,
  `repro_state` set('active','standby','delete') NOT NULL,
  PRIMARY KEY (`repro_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Contenu de la table `repro_list`
--

INSERT INTO `repro_list` (`repro_id`, `repro_name`, `repro_url`, `repro_state`) VALUES
(1, 'localhost', 'http://localhost/cms/index.php/repro/', 'active'),
(2, 'NK.org', 'http://www.nuked-klan.org/repro/', 'delete');

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

--
-- Structure de la table `repro_pack`
--

CREATE TABLE IF NOT EXISTS `repro_pack` (
  `pack_id` varchar(32) NOT NULL,
  `pack_name` varchar(100) NOT NULL,
  `pack_author` int(11) NOT NULL,
  `pack_desc` text NOT NULL,
  `pack_cost` int(11) NOT NULL DEFAULT '0',
  `pack_lang` varchar(10) NOT NULL DEFAULT 'fr-FR',
  `pack_certified` set('yes','no') NOT NULL DEFAULT 'no',
  `pack_header` text NOT NULL,
  `pack_file` varchar(30) NOT NULL,
  `pack_filename` varchar(30) NOT NULL,
  `pack_state` set('deprecate','update','active','wait') NOT NULL DEFAULT 'wait',
  `pack_updtfrom` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`pack_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `repro_pack`
--


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

--
-- Structure de la table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `settings`
--

INSERT INTO `settings` (`name`, `value`) VALUES
('def_mod', 'mod_news'),
('gzoutput', 'false'),
('themedir', 'themes'),
('themepath', '/cms/themes/'),
('theme', 'bluewater'),
('sitepath', '/cms/index.php/');

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

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `registred` enum('yes','no') NOT NULL DEFAULT 'yes',
  `active` enum('yes','no') NOT NULL DEFAULT 'yes',
  `pseudo` varchar(100) NOT NULL,
  `pseudo_clean` varchar(100) NOT NULL,
  `mail` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `user`
--

INSERT INTO `user` (`user_id`, `registred`, `active`, `pseudo`, `pseudo_clean`, `mail`) VALUES
(0, 'no', 'yes', 'Invité', 'invité', ''),
(4, 'yes', 'yes', 'Bontiv', 'bontiv', 'prog.bontiv@gmail.com'),
(5, 'yes', 'yes', 'bidule', 'bidule', 'bidule@ramounigue.fr');

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

--
-- Structure de la table `user_access`
--

CREATE TABLE IF NOT EXISTS `user_access` (
  `access_id` int(11) NOT NULL AUTO_INCREMENT,
  `access` tinytext NOT NULL,
  `flags` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `owner_type` enum('user','group') NOT NULL,
  PRIMARY KEY (`access_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `user_access`
--

INSERT INTO `user_access` (`access_id`, `access`, `flags`, `owner_id`, `owner_type`) VALUES
(1, '/', 7, 4, 'user');

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

--
-- Structure de la table `user_auth`
--

CREATE TABLE IF NOT EXISTS `user_auth` (
  `user_id` int(11) NOT NULL,
  `user_login` varchar(100) NOT NULL,
  `user_pass` varchar(34) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `user_auth`
--

INSERT INTO `user_auth` (`user_id`, `user_login`, `user_pass`) VALUES
(4, 'bontiv', '#ffc8203a1074514bef6aa0afe34b260d5'),
(5, 'bidule', '#8e00779ca0c5f037bf2617649dd924f89');

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

--
-- Structure de la table `user_group`
--

CREATE TABLE IF NOT EXISTS `user_group` (
  `affiliate_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_i-- phpMyAdmin SQL Dump
-- version 3.3.10deb1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 02 Mai 2011 à 23:46
-- Version du serveur: 5.1.54
-- Version de PHP: 5.3.5-1ubuntu7.1

SET SQL_MODE="NO_AUTO_V