/*****************************************************************************
 * create-table.sql - Script de creation de table 
 * JKP <jkp@laposte.net> Copyright (C) 2010
 *
 * This program is released under the GNU General Public Licence.
	This file is part of Hydrix.

    Hydrix is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Hydrix 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 Hydrix.  If not, see <http://www.gnu.org/licenses/>.

 *
 * Original source: http://hydrix.antisocial.be
 * See that site for documentation.
 ******************************************************************************
 */

CREATE TABLE citation_table 
(id INT not null AUTO_INCREMENT, citation VARCHAR (175) not null , PRIMARY KEY (id))
CREATE TABLE ecole_table 
(id INT not null AUTO_INCREMENT, ecole VARCHAR (100) not null ,  PRIMARY KEY (id))
CREATE TABLE entreprise_table 
(id INT not null AUTO_INCREMENT, entreprise VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE film_table 
(id INT not null AUTO_INCREMENT, film VARCHAR (75) not null , PRIMARY KEY (id))
CREATE TABLE livre_table 
(id INT not null AUTO_INCREMENT, livre VARCHAR (100) not null ,  PRIMARY KEY (id))
CREATE TABLE loisir_table 
(id INT not null AUTO_INCREMENT, loisir VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE maternelle_table 
(id INT not null AUTO_INCREMENT, maternelle VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE musique_table 
(id INT not null AUTO_INCREMENT, musique VARCHAR (100) not null ,  PRIMARY KEY (id))
CREATE TABLE nom_table 
(id INT not null AUTO_INCREMENT, nom VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE parti_table 
(id INT not null AUTO_INCREMENT, parti VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE prenom_table 
(id INT not null AUTO_INCREMENT, prenom VARCHAR (50) not null , sexe BOOL,  PRIMARY KEY (id))
CREATE TABLE pseudo_table 
(id INT not null AUTO_INCREMENT, pseudo VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE religion_table 
(id INT not null AUTO_INCREMENT, religion VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE rue_table 
(id INT not null AUTO_INCREMENT, rue VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE television_table 
(id INT not null AUTO_INCREMENT, television VARCHAR (50) not null ,  PRIMARY KEY (id))
CREATE TABLE ville_table 
(id INT not null AUTO_INCREMENT, ville VARCHAR (50) not null ,  PRIMARY KEY (id))