-- # ***** BEGIN LICENSE BLOCK *****
-- #
-- # This file is part of CodingTeam.
-- # CodingTeam is the legal property of Erwan Briand <xbright2005@gmail.com>
-- # Copyright (c) 2007 Erwan Briand
-- #
-- # This program is free software; you can redistribute it and/or modify
-- # it under the terms of the GNU General Public License version 2 as
-- # published by the Free Software Foundation
-- #
-- # This program is distributed in the hope that it will be useful,
-- # but WITHOUT ANY WARRANTY; without even the implied warranty of
-- # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- # GNU General Public License for more details.
-- #
-- # You should have received a copy of the GNU General Public License
-- # along with this program; if not, write to the Free Software
-- # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
-- #
-- # ***** END LICENSE BLOCK *****

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Dimanche 17 Juin 2007 à 19:46
-- Version du serveur: 5.0.38
-- Version de PHP: 5.2.1
-- 
-- Base de données: `codingteambd1`
-- 

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

-- 
-- Structure de la table `BHIST_ct2_upload`
-- 

CREATE TABLE `BHIST_ct2_upload` (
  `fichier` text NOT NULL,
  `pseudo` text NOT NULL,
  `ip` text NOT NULL,
  `heure` text NOT NULL,
  `date` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `compteur_membre`
-- 

CREATE TABLE `compteur_membre` (
  `pseudo` text NOT NULL,
  `temps` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `compteur_visite`
-- 

CREATE TABLE `compteur_visite` (
  `compteur` double NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `time` int(9) NOT NULL default '0',
  `duree` int(9) NOT NULL default '0',
  `ip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ip`),
  KEY `compteur` (`compteur`,`date`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_jabber_fortunes`
-- 

CREATE TABLE `ct2_jabber_fortunes` (
  `id` int(11) NOT NULL auto_increment,
  `date` text NOT NULL,
  `texte` text NOT NULL,
  `jid` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Structure de la table `ct2_member_mail_pref`
-- 

CREATE TABLE `ct2_member_mail_pref` (
  `member` int(11) NOT NULL,
  `affiche` text NOT NULL,
  `wiki_creator` text NOT NULL,
  `wiki_admin` text NOT NULL,
  `bugs_creator` text NOT NULL,
  `bugs_admin` text NOT NULL,
  `forum` text NOT NULL,
  `newsletter` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os`
-- 

CREATE TABLE `ct2_os` (
  `id` int(11) NOT NULL auto_increment,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  `auteur` text NOT NULL,
  `titre` text NOT NULL,
  `adresse` text NOT NULL,
  `type` text NOT NULL,
  `traduction` text NOT NULL,
  `license` text NOT NULL,
  `langage` text NOT NULL,
  `operating` text NOT NULL,
  `logo` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=16 ;

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

-- 
-- Structure de la table `ct2_os_actu`
-- 

CREATE TABLE `ct2_os_actu` (
  `id` int(11) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `auteur` text NOT NULL,
  `texte` text NOT NULL,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  `projet` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Structure de la table `ct2_os_bin`
-- 

CREATE TABLE `ct2_os_bin` (
  `id` int(11) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `version` text NOT NULL,
  `description` text NOT NULL,
  `file` text NOT NULL,
  `projet` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

-- 
-- Structure de la table `ct2_os_bug`
-- 

CREATE TABLE `ct2_os_bug` (
  `id` int(11) NOT NULL auto_increment,
  `projet` int(11) NOT NULL default '0',
  `date` text NOT NULL,
  `auteur` text NOT NULL,
  `titre` text NOT NULL,
  `message` text NOT NULL,
  `tag` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

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

-- 
-- Structure de la table `ct2_os_bug_closed`
-- 

CREATE TABLE `ct2_os_bug_closed` (
  `idbug` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_bug_reply`
-- 

CREATE TABLE `ct2_os_bug_reply` (
  `id` int(11) NOT NULL auto_increment,
  `idrep` int(11) NOT NULL default '0',
  `date` text NOT NULL,
  `auteur` text NOT NULL,
  `titre` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=9 ;

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

-- 
-- Structure de la table `ct2_os_com`
-- 

CREATE TABLE `ct2_os_com` (
  `id` int(11) NOT NULL auto_increment,
  `projet` int(11) NOT NULL default '0',
  `titre` text NOT NULL,
  `auteur` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

-- 
-- Structure de la table `ct2_os_etat`
-- 

CREATE TABLE `ct2_os_etat` (
  `idprojet` int(11) NOT NULL,
  `etat` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_nb`
-- 

CREATE TABLE `ct2_os_nb` (
  `projet` int(11) NOT NULL default '0',
  `fichier` text NOT NULL,
  `nb` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_screen`
-- 

CREATE TABLE `ct2_os_screen` (
  `id` int(11) NOT NULL auto_increment,
  `text` text NOT NULL,
  `img` text NOT NULL,
  `projet` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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

-- 
-- Structure de la table `ct2_os_svn`
-- 

CREATE TABLE `ct2_os_svn` (
  `idprojet` int(11) NOT NULL,
  `texte` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_team`
-- 

CREATE TABLE `ct2_os_team` (
  `id` int(11) NOT NULL auto_increment,
  `idprojet` text NOT NULL,
  `pseudo` text NOT NULL,
  `rang` text NOT NULL,
  `admin` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

-- 
-- Structure de la table `ct2_os_todo`
-- 

CREATE TABLE `ct2_os_todo` (
  `id` int(11) NOT NULL auto_increment,
  `projet` int(11) NOT NULL default '0',
  `etat` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

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

-- 
-- Structure de la table `ct2_os_todo_v`
-- 

CREATE TABLE `ct2_os_todo_v` (
  `id` int(11) NOT NULL default '0',
  `version` text NOT NULL,
  `projet` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_trad`
-- 

CREATE TABLE `ct2_os_trad` (
  `id` int(11) NOT NULL auto_increment,
  `projet` int(11) NOT NULL,
  `texte` text NOT NULL,
  `lang` text NOT NULL,
  `auteur` text NOT NULL,
  `idtexteprojet` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `ct2_os_trad_prop`
-- 

CREATE TABLE `ct2_os_trad_prop` (
  `id` int(11) NOT NULL auto_increment,
  `idtexte` int(11) NOT NULL,
  `texte` text NOT NULL,
  `auteur` text NOT NULL,
  `idprojet` int(11) NOT NULL,
  `lang` text NOT NULL,
  `cause` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Structure de la table `ct2_os_trad_state`
-- 

CREATE TABLE `ct2_os_trad_state` (
  `idprojet` int(11) NOT NULL,
  `state` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_trad_tem`
-- 

CREATE TABLE `ct2_os_trad_tem` (
  `idprojet` int(11) NOT NULL,
  `template` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `ct2_os_wiki`
-- 

CREATE TABLE `ct2_os_wiki` (
  `id` int(11) NOT NULL auto_increment,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  `texte` text NOT NULL,
  `nompage` text NOT NULL,
  `auteur` text NOT NULL,
  `projet` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

-- 
-- Structure de la table `ct2_os_wiki_lock`
-- 

CREATE TABLE `ct2_os_wiki_lock` (
  `idpage` int(11) NOT NULL,
  `idprojet` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Structure de la table `forum_commentaire`
-- 

CREATE TABLE `forum_commentaire` (
  `id` int(11) NOT NULL auto_increment,
  `sujet` int(11) NOT NULL default '0',
  `auteur` text NOT NULL,
  `message` text NOT NULL,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=7 ;

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

-- 
-- Structure de la table `forum_sujet`
-- 

CREATE TABLE `forum_sujet` (
  `id` int(11) NOT NULL auto_increment,
  `titre` text NOT NULL,
  `auteur` text NOT NULL,
  `message` text NOT NULL,
  `cat` text NOT NULL,
  `type` text NOT NULL,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=7 ;

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

-- 
-- Structure de la table `member`
-- 

CREATE TABLE `member` (
  `id` int(11) NOT NULL auto_increment,
  `pseudo` text NOT NULL,
  `passe` text NOT NULL,
  `prenom` text NOT NULL,
  `nom` text NOT NULL,
  `heureins` text NOT NULL,
  `dateins` text NOT NULL,
  `email` text NOT NULL,
  `jid` text NOT NULL,
  `url` text NOT NULL,
  `avatar` text NOT NULL,
  `signature` text NOT NULL,
  `description` text NOT NULL,
  `sexe` text NOT NULL,
  `ville` text NOT NULL,
  `pays` text NOT NULL,
  `niveau` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=6 ;

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

-- 
-- Structure de la table `member_mess`
-- 

CREATE TABLE `member_mess` (
  `id` int(11) NOT NULL auto_increment,
  `destinataire` text NOT NULL,
  `auteur` text NOT NULL,
  `date` text NOT NULL,
  `heure` text NOT NULL,
  `message` text NOT NULL,
  `sujet` text NOT NULL,
  `open` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

-- 
-- Structure de la table `pastebin`
-- 

CREATE TABLE `pastebin` (
  `pid` int(11) NOT NULL auto_increment,
  `poster` varchar(16) default NULL,
  `posted` datetime default NULL,
  `code` text,
  `parent_pid` int(11) default '0',
  `format` varchar(16) default NULL,
  `codefmt` mediumtext,
  `codecss` text,
  `domain` varchar(255) default '',
  `expires` datetime default NULL,
  `expiry_flag` enum('d','m','f') NOT NULL default 'm',
  PRIMARY KEY  (`pid`),
  KEY `domain` (`domain`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
