-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
-- 
-- Serveur: guilhem.mp.sql.free.fr
-- Généré le : Mardi 27 Juin 2006 à 01:07
-- Version du serveur: 5.0.23
-- Version de PHP: 4.4.2
-- 
-- Base de données: `guilhem_mp`
-- 

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

-- 
-- Structure de la table `PWS_CATEGORIE`
-- 

DROP TABLE IF EXISTS `PWS_CATEGORIE`;
CREATE TABLE IF NOT EXISTS `PWS_CATEGORIE` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_CATEGORIE_DESCRIPTION`
-- 

DROP TABLE IF EXISTS `PWS_CATEGORIE_DESCRIPTION`;
CREATE TABLE IF NOT EXISTS `PWS_CATEGORIE_DESCRIPTION` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idCategorie` int(11) NOT NULL,
  `idLangue` int(11) NOT NULL,
  `name` tinytext collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_LANGUE`
-- 

DROP TABLE IF EXISTS `PWS_LANGUE`;
CREATE TABLE IF NOT EXISTS `PWS_LANGUE` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(3) collate latin1_general_ci NOT NULL,
  `longName` varchar(100) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_MP_VERSION`
-- 

DROP TABLE IF EXISTS `PWS_MP_VERSION`;
CREATE TABLE IF NOT EXISTS `PWS_MP_VERSION` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext collate latin1_general_ci NOT NULL,
  `isValidate` tinyint(4) NOT NULL default '0',
  `type` tinyint(4) NOT NULL,
  `idCategory` int(11) default NULL,
  `nbDonwload` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_CREATOR`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_CREATOR`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_CREATOR` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPlugin` int(11) NOT NULL,
  `idUser` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_DESCRIPTION`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_DESCRIPTION`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_DESCRIPTION` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPlugin` int(11) NOT NULL,
  `idLangue` int(11) NOT NULL,
  `name` tinytext collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  `webSite` tinytext collate latin1_general_ci,
  `forum` tinytext collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_SKIN_COMPATIBLE`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_SKIN_COMPATIBLE`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_SKIN_COMPATIBLE` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPluginVersion` int(11) NOT NULL,
  `idSkin` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_UPADTE`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_UPADTE`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_UPADTE` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPluginVersionBase` int(11) NOT NULL,
  `idPluginVersionLike` int(11) NOT NULL,
  `download` tinytext collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_VERSION`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_VERSION`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_VERSION` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPlugin` int(11) NOT NULL,
  `name` tinytext collate latin1_general_ci NOT NULL,
  `changelog` text collate latin1_general_ci NOT NULL,
  `download` tinytext collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_PLUGIN_VERSION_COMPATIBLE`
-- 

DROP TABLE IF EXISTS `PWS_PLUGIN_VERSION_COMPATIBLE`;
CREATE TABLE IF NOT EXISTS `PWS_PLUGIN_VERSION_COMPATIBLE` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idPluginVersion` int(11) NOT NULL,
  `idMPVersion` int(11) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_SKIN`
-- 

DROP TABLE IF EXISTS `PWS_SKIN`;
CREATE TABLE IF NOT EXISTS `PWS_SKIN` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` tinytext collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_SKIN_DESCRIPTION`
-- 

DROP TABLE IF EXISTS `PWS_SKIN_DESCRIPTION`;
CREATE TABLE IF NOT EXISTS `PWS_SKIN_DESCRIPTION` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idSkin` int(11) NOT NULL,
  `idLangue` int(11) NOT NULL,
  `name` tinytext collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  `webSite` tinytext collate latin1_general_ci NOT NULL,
  `forum` tinytext collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `PWS_USER`
-- 

DROP TABLE IF EXISTS `PWS_USER`;
CREATE TABLE IF NOT EXISTS `PWS_USER` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(100) collate latin1_general_ci NOT NULL,
  `password` varchar(100) collate latin1_general_ci NOT NULL,
  `mail` tinytext collate latin1_general_ci NOT NULL,
  `isModerator` tinyint(4) NOT NULL default '0',
  `isTraductor` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=106 ;