#
# Structure de la table `adjcrea`
#

DROP TABLE IF EXISTS adjcrea;
CREATE TABLE adjcrea (
  Nom varchar(20) NOT NULL default '',
  Nom1 varchar(20) NOT NULL default '',
  PRIMARY KEY  (Nom),
  UNIQUE KEY Nom (Nom),
  KEY Nom_2 (Nom)
) TYPE=MyISAM;

#
# Structure de la table `bugs`
#

DROP TABLE IF EXISTS bugs;
CREATE TABLE bugs (
  Id int(11) NOT NULL auto_increment,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Auteur varchar(50) NOT NULL default '',
  Titre text NOT NULL default '',
  Message text NOT NULL,
  Theme tinyint(4) NOT NULL default '0',
  IsTopic tinyint(4) NOT NULL default '0',
  RefTopic int(11) NOT NULL default '0',
  Vus int(11) NOT NULL default '0',
  Bloc tinyint(4) NOT NULL default '0',
  Up tinyint(4) NOT NULL default '0',
  Admin tinyint(4) NOT NULL default '0',
  UNIQUE KEY Id (Id)
) TYPE=MyISAM;



#
# Structure de la table `forumadmin`
#

DROP TABLE IF EXISTS forumadmin;
CREATE TABLE forumadmin (
  Id int(11) NOT NULL auto_increment,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Auteur varchar(50) NOT NULL default '',
  Titre text NOT NULL default '',
  Message text NOT NULL,
  IsTopic tinyint(4) NOT NULL default '0',
  RefTopic int(11) NOT NULL default '0',
  Vus int(11) NOT NULL default '0',
  Up TINYINT DEFAULT '0' not null, 
  Bloc TINYINT DEFAULT '0' not null,
  UNIQUE KEY Id (Id)
) TYPE=MyISAM;

#
# Structure de la table `connection`
#

DROP TABLE IF EXISTS connection;
CREATE TABLE connection (
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Sorcier varchar(20) NOT NULL default '',
  AdresseIP varchar(15) NOT NULL default '',
  Close tinyint(1) NOT NULL default '0',
  KEY Sorcier (Sorcier)
) TYPE=MyISAM;

#
# Structure de la table `creature`
#

DROP TABLE IF EXISTS creature;
CREATE TABLE creature (
  Id int(11) NOT NULL auto_increment,
  Nom varchar(50) NOT NULL default '',
  Couleur tinyint(4) NOT NULL default '0',
  Controleur varchar(20) NOT NULL default '',
  SorcierId int(11) NOT NULL default '0',
  `Force` int NOT NULL default '0',
  Endurance int NOT NULL default '0',
  Sacrifice tinyint(4) NOT NULL default '0',
  Statut tinyint(4) NOT NULL default '0',
  Etat tinyint(4) NOT NULL default '0',
  Morte tinyint(4) NOT NULL default '0',
  DateCreation datetime NOT NULL default '0000-00-00 00:00:00',
  DateEngage datetime NOT NULL default '0000-00-00 00:00:00',
  Cout int NOT NULL default '0',
  NbBoucliers tinyint(4) NOT NULL default '0',
  Capa0 tinyint(4) NOT NULL default '0',
  Capa1 tinyint(4) NOT NULL default '0',
  Capa2 tinyint(4) NOT NULL default '0',
  Capa3 tinyint(4) NOT NULL default '0',
  Capa4 tinyint(4) NOT NULL default '0',
  Capa5 tinyint(4) NOT NULL default '0',
  Capa6 tinyint(4) NOT NULL default '0',
  Capa7 tinyint(4) NOT NULL default '0',
  Capa8 tinyint(4) NOT NULL default '0',
  Capa9 tinyint(4) NOT NULL default '0',
  NeededXP int NOT NULL default '0',
  PRIMARY KEY  (Id),
  KEY Controleur (Controleur),
  KEY Etat (Etat),
  KEY Statut (Statut)
) TYPE=MyISAM;

#
# Structure de la table `faq`
#

DROP TABLE IF EXISTS faq;
CREATE TABLE faq (
  Id smallint(6) NOT NULL auto_increment,
  ThemeFAQ tinyint(4) NOT NULL default '0',
  Question text NOT NULL,
  Reponse text NOT NULL,
  Actif tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `forum`
#

DROP TABLE IF EXISTS forum;
CREATE TABLE forum (
  Id int(11) NOT NULL auto_increment,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Auteur varchar(50) NOT NULL default '',
  Titre text NOT NULL default '',
  Message text NOT NULL,
  Couleur tinyint(4) NOT NULL default '0',
  Numero tinyint(4) NOT NULL default '1',
  IsTopic tinyint(4) NOT NULL default '0',
  RefTopic int(11) NOT NULL default '-1',
  Modere  tinyint(2) NOT NULL default '0',  
  Vus int(11) NOT NULL default '0',
  Bloc tinyint(4) NOT NULL default '0',
  Up tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY forum_rt (RefTopic),
  KEY forum_r_it (Couleur,IsTopic),
  KEY Numero (Numero)
) TYPE=MyISAM;

#
# Structure de la table `historique`
#

DROP TABLE IF EXISTS historique;
CREATE TABLE historique (
  Saison tinyint(4) NOT NULL default '1',
  Nom char(50) NOT NULL default '',
  Puissance mediumint(9) NOT NULL default '30',
  Vie smallint(6) NOT NULL default '20',
  Couleur tinyint(4) NOT NULL default '0',
  Numero tinyint(4) NOT NULL default '0',
  NbTerrains bigint(21) default '0',
  NbCreatures bigint(21) default '0'
) TYPE=MyISAM;

#
# Structure de la table `journal`
#

DROP TABLE IF EXISTS journal;
CREATE TABLE journal (
  Id int(11) NOT NULL auto_increment,
  Auteur varchar(50) NOT NULL default '',
  Texte text NOT NULL,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Couleur tinyint(4) NOT NULL default '0',
  Numero tinyint(4) NOT NULL default '0',
  CouleurAtt tinyint(4) NOT NULL default '0',
  CouleurDef tinyint(4) NOT NULL default '0',
  NumeroAtt tinyint(4) NOT NULL default '0',
  NumeroDef tinyint(4) NOT NULL default '0',
  SorcierAtt varchar(50) NOT NULL default '',
  SorcierDef varchar(50) NOT NULL default '',
  Action tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `land`
#

DROP TABLE IF EXISTS land;
CREATE TABLE land (
  Id int(11) NOT NULL auto_increment,
  Controleur varchar(50) NOT NULL default '',
  Couleur tinyint(4) NOT NULL default '0',
  Etat tinyint(4) NOT NULL default '0',
  DateEngage datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `landstatus`
#

DROP TABLE IF EXISTS `landstatus`;
CREATE TABLE `landstatus` (
  `Id` int(11) NOT NULL auto_increment,
  `SorcierId` int(11) NOT NULL default '0',
  `CouleurSorcier` tinyint(4) NOT NULL default '0',
  `NbTerrains` int(4) NOT NULL default '0',
  `Etat` tinyint(4) NOT NULL default '0',
  `DateEngage` datetime NOT NULL default '0000-00-00 00:00:00',
  `Description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Id`)
) TYPE=MyISAM ;


#
# Structure de la table `lieucrea`
#

DROP TABLE IF EXISTS lieucrea;
CREATE TABLE lieucrea (
  Couleur tinyint(4) NOT NULL default '0',
  Nom varchar(20) NOT NULL default '',
  PRIMARY KEY  (Couleur,Nom),
  UNIQUE KEY Nom (Couleur,Nom),
  KEY Nom_2 (Couleur,Nom)
) TYPE=MyISAM;

#
# Structure de la table `message`
#

DROP TABLE IF EXISTS message;
CREATE TABLE message (
  Id int(4) NOT NULL auto_increment,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Expediteur varchar(30) NOT NULL default '',
  Couleur tinyint(4) NOT NULL default '0',
  Destinataire varchar(50) NOT NULL default '',
  Texte longtext NOT NULL,
  Lu tinyint(4) NOT NULL default '0',
  Modere tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  KEY Id (Id)
) TYPE=MyISAM;

#
# Structure de la table `news`
#

DROP TABLE IF EXISTS news;
CREATE TABLE news (
  Id int(11) NOT NULL auto_increment,
  Sorcier varchar(50) NOT NULL default '',
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  Texte blob NOT NULL,
  Lu tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  KEY Sorcier (Sorcier),
  KEY Lu (Lu)
) TYPE=MyISAM;

#
# Structure de la table `nomcrea`
#

DROP TABLE IF EXISTS nomcrea;
CREATE TABLE nomcrea (
  Nom varchar(20) NOT NULL default '',
  Couleur tinyint(4) NOT NULL default '0',
  Genre tinyint(4) NOT NULL default '0',
  KEY Nom_2 (Nom)
) TYPE=MyISAM;

#
# Structure de la table `projet`
#

DROP TABLE IF EXISTS projet;
CREATE TABLE projet (
  Id tinyint(4) NOT NULL auto_increment,
  Type varchar(15) NOT NULL default '',
  Modification varchar(250) NOT NULL default '',
  Details varchar(250) default NULL,
  Responsable varchar(50) default NULL,
  Date varchar(15) NOT NULL default '?',
  Etat varchar(15) NOT NULL default 'A faire',
  Commentaires varchar(250) default NULL,
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `relation`
#

DROP TABLE IF EXISTS relation;
CREATE TABLE relation (
  Id int(11) NOT NULL auto_increment,
  Couleur1 tinyint(4) NOT NULL default '0',
  Couleur2 tinyint(4) NOT NULL default '0',
  Numero1 tinyint(4) NOT NULL default '0',
  Numero2 tinyint(4) NOT NULL default '0',
  DateDebut datetime NOT NULL default '0000-00-00 00:00:00',
  DateFin datetime NOT NULL default '0000-00-00 00:00:00',
  Type tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  KEY Type (Type)
) TYPE=MyISAM;

#
# Structure de la table `royaume`
#

DROP TABLE IF EXISTS royaume;
CREATE TABLE royaume (
  Couleur tinyint(4) NOT NULL default '0',
  Numero tinyint(4) NOT NULL default '0',
  Nom text NOT NULL,
  Image varchar(255) NOT NULL default '',
  Message text NOT NULL,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  KEY Couleur (Couleur,Numero)
) TYPE=MyISAM;

#
# Structure de la table `sondage`
#

DROP TABLE IF EXISTS sondage;
CREATE TABLE sondage (
  Nom varchar(30) NOT NULL default '',
  Choix varchar(6) NOT NULL default '',
  PRIMARY KEY  (Nom),
  UNIQUE KEY Nom (Nom),
  KEY Id_2 (Nom)
) TYPE=MyISAM;

#
# Structure de la table `sondageold`
#

DROP TABLE IF EXISTS sondageold;
CREATE TABLE sondageold (
  Id tinyint(3) NOT NULL default '0',
  Question varchar(50) NOT NULL default '',
  Reponse varchar(50) NOT NULL default '',
  Nombre int(4) NOT NULL default '0',
  PRIMARY KEY  (Id,Reponse),
  UNIQUE KEY Nom (Id,Reponse),
  KEY Id_2 (Id,Reponse)
) TYPE=MyISAM;

#
# Structure de la table `sorcier`
#

DROP TABLE IF EXISTS sorcier;
CREATE TABLE sorcier (
  Id int(11) NOT NULL auto_increment PRIMARY KEY,
  Actif tinyint(1) NOT NULL default '1',
  Nom varchar(50) NOT NULL default '',
  NomReel varchar(50) NOT NULL default '',
  PrenomReel varchar(50) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  Login varchar(10) NOT NULL default '',
  Password varchar(10) NOT NULL default '',
  Activation tinyint(4) NOT NULL default '0',
  CodeActivation varchar(8) NOT NULL default '',
  Vie smallint(6) NOT NULL default '20',
  Puissance mediumint(9) NOT NULL default '30',
  PuissanceMax mediumint(9) NOT NULL default '0',
  Experience mediumint(9) NOT NULL default '0',
  ExperienceMax mediumint(9) NOT NULL default '0',
  Frags MEDIUMINT DEFAULT '0' NOT NULL,
  Deaths MEDIUMINT DEFAULT '0' NOT NULL,
  NbTerrains int(4) default '0',
  NbTerrainsAcq int(4) default '0',
  Couleur tinyint(4) NOT NULL default '0',
  Numero tinyint(4) NOT NULL default '0',
  DateInscription datetime NOT NULL default '0000-00-00 00:00:00',
  DateDebut datetime NOT NULL default '0000-00-00 00:00:00',
  DateRetour datetime NOT NULL default '0000-00-00 00:00:00',
  Immunise tinyint(4) NOT NULL default '1',
  Vote varchar(50) NOT NULL default '',
  EstRoi tinyint(4) NOT NULL default '0',
  DateForum datetime NOT NULL default '0000-00-00 00:00:00',
  DateBugs datetime NOT NULL default '0000-00-00 00:00:00',
  DateAmel datetime NOT NULL default '0000-00-00 00:00:00',
  DateRegl datetime NOT NULL default '0000-00-00 00:00:00',
  DateHume datetime NOT NULL default '0000-00-00 00:00:00',
  Avatar varchar(255) NOT NULL default '',
  AvatarStatus tinyint(4) NOT NULL default '0',
  AvatarX tinyint(4) NOT NULL default '0',
  AvatarY tinyint(4) NOT NULL default '0',
  Picture varchar(255) NOT NULL default '',
  PictureStatus tinyint(4) NOT NULL default '0',
  PictureX smallint(4) NOT NULL default '0',
  PictureY smallint(4) NOT NULL default '0',
  Admin tinyint(4) NOT NULL default '0',
  Mail tinyint(1) NOT NULL default '1',
  Button tinyint(1) NOT NULL default '0',
  Css varchar(20) NOT NULL default 'jeu.css', 
  Lang varchar(2) NOT NULL default 'fr', 
  UNIQUE KEY Nom (Nom,Login),
  KEY Puissance (Puissance),
  KEY Couleur (Couleur),
  KEY Numero (Numero),
  KEY Immunise (Immunise),
  KEY Immunise_2 (Immunise)
) TYPE=MyISAM;


#
# Structure de la table `sorts1`
#

DROP TABLE IF EXISTS sorts1;
CREATE TABLE sorts1 (
  Id int NOT NULL auto_increment,
  Controleur varchar(50) NOT NULL default '',
  SortId int NOT NULL default '0',
  SorcierCible varchar(50) NOT NULL default '',
  CreatureCible int(11) default NULL,
  NbCreaturesMin INT DEFAULT '0' NOT NULL,
  NbCreaturesMax INT DEFAULT '-1' NOT NULL,
  ForceTotaleMin INT DEFAULT '0' NOT NULL,
  ForceTotaleMax INT DEFAULT '-1' NOT NULL,
  DateCreation datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `sortseffet`
#

DROP TABLE IF EXISTS sortseffet;
CREATE TABLE sortseffet (
  Id int NOT NULL auto_increment,
  SortId int NOT NULL default '0',
  Declenchement int(4) NOT NULL default '0',
  EffetPHP varchar(100) NOT NULL default '',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `sortseffet1`
#

DROP TABLE IF EXISTS sortseffet1;
CREATE TABLE sortseffet1 (
  Id int NOT NULL auto_increment,
  Controleur char(50) NOT NULL default '',
  SortstempId int NOT NULL default '0',
  EffetId int NOT NULL default '0',
  CibleId int(11) default NULL,
  DateCreation datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `sortsnewui`
#

DROP TABLE IF EXISTS sortsnewui;
CREATE TABLE sortsnewui (
  Id int NOT NULL auto_increment,
  Actif tinyint(1) NOT NULL default '1',
  Nom varchar(50) NOT NULL default '',
  Value varchar(50) NOT NULL default '',
  Texte varchar(250) NOT NULL default '',
  Type tinyint(4) NOT NULL default '0',
  CibleSorcier tinyint(1) NOT NULL default '0',
  CibleCreature tinyint(1) NOT NULL default '0',
  CibleType varchar(4) NOT NULL default '',
  CiblePHP varchar(100) NOT NULL default '',
  Declenchement int(4) NOT NULL default '0',
  SortPHP varchar(100) NOT NULL default '',
  SortPHPcontre varchar(100) default NULL,
  CoutMin int NOT NULL default '0',
  CoutMax int NOT NULL default '0',
  CoutFixe int NOT NULL default '0',
  CoutRatioTerrains int NOT NULL default '0',
  CoutRatioParametre int NOT NULL default '0',
  CoutCommentaire varchar(250) NOT NULL default '',
  Bonus0 tinyint(4) NOT NULL default '100',
  Bonus1 tinyint(4) NOT NULL default '100',
  Bonus2 tinyint(4) NOT NULL default '100',
  Bonus3 tinyint(4) NOT NULL default '100',
  Bonus4 tinyint(4) NOT NULL default '100',
  VariableCostFactor int NOT NULL default '0',
  NeededXP int NOT NULL default '0',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `sortstemp`
#

DROP TABLE IF EXISTS sortstemp;
CREATE TABLE sortstemp (
  Id int NOT NULL auto_increment,
  Controleur varchar(50) NOT NULL default '',
  SortId int NOT NULL default '0',
  CibleId int(4) default NULL,
  Parametre mediumtext default NULL,
  DateCreation datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `statsorts`
#

DROP TABLE IF EXISTS statsorts;
CREATE TABLE statsorts (
  Nom varchar(50) NOT NULL default '',
  Couleur tinyint(4) NOT NULL default '0',
  Nombre int(6) NOT NULL default '0',
  PRIMARY KEY  (Nom,Couleur),
  UNIQUE KEY Id (Nom,Couleur),
  KEY Id_2 (Nom,Couleur)
) TYPE=MyISAM;

#
# Structure de la table `themefaq`
#

DROP TABLE IF EXISTS themefaq;
CREATE TABLE themefaq (
  Id tinyint(4) NOT NULL default '0',
  Nom varchar(50) NOT NULL default '',
  Description text NOT NULL,
  Actif tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `warnings`
#

DROP TABLE IF EXISTS warnings;
CREATE TABLE warnings (
  Id int(11) NOT NULL auto_increment,
  Type tinyint(4) NOT NULL default '0',
  Texte varchar(255) NOT NULL default '',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Structure de la table `warnings1`
#

DROP TABLE IF EXISTS warnings1;
CREATE TABLE warnings1 (
  Id int(11) NOT NULL auto_increment,
  Sorcier varchar(50) NOT NULL default '',
  Texte varchar(255) NOT NULL default '',
  DateCreation datetime NOT NULL default '0000-00-00 00:00:00',
  Type TINYINT DEFAULT '0' not null,
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Table structure for table 'moderation'
#

DROP TABLE IF EXISTS moderation;
CREATE TABLE moderation (
  Mot varchar(50) NOT NULL default '',
  PRIMARY KEY  (Mot),
  UNIQUE KEY Id (Mot),
  KEY Id_2 (Mot)
) TYPE=MyISAM;

#
# Structure de la table `statsroyaumes`
#

DROP TABLE IF EXISTS statsroyaumes;
CREATE TABLE statsroyaumes (
  Id int(10) NOT NULL auto_increment,
  logdate date default NULL,
  numero tinyint(4) NOT NULL default '0',
  couleur tinyint(4) NOT NULL default '0',
  royaume text,
  viemoy float(4,2) NOT NULL default '0.00',
  nbsorc tinyint(4) NOT NULL default '0',
  puissance int(10) NOT NULL default '0',
  experience int(10) NOT NULL default '0',
  nbcreas int(10) NOT NULL default '0',
  PRIMARY KEY (Id)
) TYPE=MyISAM;

#
# Structure de la table `logsadmindb`
#

DROP TABLE IF EXISTS logsadmindb;
CREATE TABLE logsadmindb (
  Id int(10) NOT NULL auto_increment,
  logdate date default NULL,
  what varchar(255) NOT NULL default '',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY (Id)
) TYPE=MyISAM;

#
# Structure de la table `ban`
#

DROP TABLE IF EXISTS `ban`;
CREATE TABLE `ban` (
  `Id` int(11) NOT NULL auto_increment,
  `Nom` varchar(20) NOT NULL default '',
  `NomReel` varchar(50) NOT NULL default '',
  `PrenomReel` varchar(50) NOT NULL default '',
  `Email` varchar(100) NOT NULL default '',
  `DateBanni` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `Email` (`Email`)
) TYPE=MyISAM;


#
# Structure de la table `proposition`
#

DROP TABLE IF EXISTS proposition;
CREATE TABLE proposition (
  Id int(11) NOT NULL auto_increment,
  Date datetime NOT NULL default '0000-00-00 00:00:00',
  SorcierId int(11) NOT NULL default 0,
  Type tinyint NOT NULL default 0,
  Mot varchar(20) NOT NULL default '',
  Mot1 varchar(20),
  Genre tinyint,
  Couleur tinyint NOT NULL default 0,
  Ok tinyint NOT NULL default 0,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY Mot (Mot,Type,Couleur)
) TYPE=MyISAM;

#
# Contenu de la table configuration
#


DROP TABLE IF EXISTS configuration;
CREATE TABLE configuration (
  id                int NOT NULL auto_increment,
  variable          VARCHAR (64) default NULL,
  value             VARCHAR (150) default NULL,
  scope             VARCHAR (64) default NULL,
  active            enum ('Y', 'N') default 'Y',
  comments          mediumtext default NULL,
  admin				tinyint(1) default '9',
  visible           enum ('Y', 'N') default 'N',
  PRIMARY KEY       (id),
  UNIQUE KEY        id (id),
  UNIQUE KEY        variable  (variable)
) TYPE=MyISAM;

#
# Contenu de la table manaPool
#

DROP TABLE IF EXISTS manaPool;
CREATE TABLE manaPool (
  id                int NOT NULL auto_increment,   # manaPool Id
  date			datetime NOT NULL default '0000-00-00 00:00:00',
  spellId           tinyint(4) NOT NULL default '',       # spell Id (from spells table)
  ownerId	        int NOT NULL default '-1',     # manaPool owner Id, can be wizard, realm, or group depending on 'ownerType'
  ownerType			enum ('wizard', 'realm', 'group') default 'wizard', # owner type of the manaPool...
  manaPool          smallint(6) NOT NULL default '0',     # level of mana in ManaPool
  spellCost         smallint(6) NOT NULL default '0',     # Current Spell cost to launch the spell
  counterManaPool   smallint(6) NOT NULL default '0',     # level of mana to counter the spell
  counterSpellCost  smallint(6) NOT NULL default '0',     # Current Spell cost to counter the spell
  counterThreshold  smallint(6) NOT NULL default '0',     # limit where it appears in manaPool list
  cibleId    		int NOT NULL default '-1',     # wizard, realm, group id target for the spell
  parameter         mediumtext default NULL,
  PRIMARY KEY  (id),
  KEY ownerId (ownerId),
  KEY cibleId (cibleId)
) TYPE=MyISAM;

#
# Contenu de la table spell
#


DROP TABLE IF EXISTS spells;
CREATE TABLE spells (
  Id int NOT NULL auto_increment,
  Actif tinyint(1) NOT NULL default '1',
  Nom varchar(50) NOT NULL default '',
  Value varchar(50) NOT NULL default '',
  Texte varchar(250) NOT NULL default '',
  Type tinyint(4) NOT NULL default '0',
  CibleSorcier tinyint(1) NOT NULL default '0',
  CibleCreature tinyint(1) NOT NULL default '0',
  CibleType varchar(4) NOT NULL default '',
  CiblePHP varchar(100) NOT NULL default '',
  Declenchement int(4) NOT NULL default '0',
  SortPHP varchar(100) NOT NULL default '',
  SortPHPcontre varchar(100) default NULL,
  Cout int NOT NULL default 1,
  NeededXP int NOT NULL default '0',
  PRIMARY KEY  (Id),
  UNIQUE KEY Id (Id),
  KEY Id_2 (Id)
) TYPE=MyISAM;

#
# Contenu de la table spellCount
#

DROP TABLE IF EXISTS spellCount;
CREATE TABLE spellCount (
  Id 		int NOT NULL auto_increment,
  wizardId 	int,
  spellId	tinyint(4),
  count		int,
  maxCount      int,
  PRIMARY KEY   (id),
  UNIQUE KEY    id (id)
) TYPE=MyISAM;


#
# Contenu de la table parties
#

DROP TABLE IF EXISTS parties;
CREATE TABLE parties (
  Id 		int NOT NULL auto_increment,
  Actif		tinyint(1) NOT NULL default 1,
  Nom 		varchar(100),
  Createur		varchar(100),
  Login		varchar(100),
  Password	varchar(100),
  Path		varchar(100) default 'jeu',
  DBHost	varchar(100),
  DBUser	varchar(100),
  DBPass	varchar(100),
  DBBase	varchar(100),
  DateDebut	datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY   (id),
  UNIQUE KEY    id (id)
) TYPE=MyISAM;


#
# Contenu de la table logadmins
#

DROP TABLE IF EXISTS logadmins;
CREATE TABLE logadmins (
  Id 		int NOT NULL auto_increment,
  AdminId	int NOT NULL default 1,
  Action 	varchar(255),
  DateAction	datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY   (Id),
  UNIQUE KEY    Id (Id)
) TYPE=MyISAM;


#
# Contenu de la table xpcreature
#

DROP TABLE IF EXISTS xpcreature;
CREATE TABLE xpcreature (
  Id int(11) NOT NULL auto_increment,
  Nom varchar(50) NOT NULL default '',
  `Force` int NOT NULL default '0',
  Endurance int NOT NULL default '0',
  Sacrifice tinyint(4) NOT NULL default '0',
  Statut tinyint(4) NOT NULL default '0',
  Cout tinyint(4) NOT NULL default '0',
  NbBoucliers tinyint(4) NOT NULL default '0',
  Capa0 tinyint(4) NOT NULL default '0',
  Capa1 tinyint(4) NOT NULL default '0',
  Capa2 tinyint(4) NOT NULL default '0',
  Capa3 tinyint(4) NOT NULL default '0',
  Capa4 tinyint(4) NOT NULL default '0',
  Capa5 tinyint(4) NOT NULL default '0',
  Capa6 tinyint(4) NOT NULL default '0',
  Capa7 tinyint(4) NOT NULL default '0',
  Capa8 tinyint(4) NOT NULL default '0',
  Capa9 tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

#
# Contenu de la table xpbonus
#

DROP TABLE IF EXISTS xpbonus;
CREATE TABLE xpbonus (
  Id 		int NOT NULL auto_increment,
  Bonus		enum ('PdV', 'Terrain', '+0/+1', '+1/+0', 'Creature', 'Sort'),
  XPmin 	int NOT NULL default 0,
  XPmax 	int NOT NULL default 0,
  XPstep 	int NOT NULL default 0,
  Parametre 	int NOT NULL default 1,
  PRIMARY KEY   (Id),
  UNIQUE KEY    Id (Id)
) TYPE=MyISAM;

#
# Contenu de la table configCouleur
#

DROP TABLE IF EXISTS configCouleur;
CREATE TABLE configCouleur (
  Id tinyint(4) NOT NULL default '0',
  Name varchar(10) NOT NULL default 'Noir',
  LogoPath varchar(50) NOT NULL DEFAULT 'images/logonoir2.gif',
  NomTerrain  varchar(20) NOT NULL default 'marais',
  NomTerrains varchar(20) NOT NULL default 'marais',
  BonusAtt tinyint(4) NOT NULL default '1',
  BonusDef tinyint(4) NOT NULL default '0',
  BonusMur tinyint(4) NOT NULL default '2',
  BonusBas tinyint(4) NOT NULL default '2',
  MaxTerrains int(11) NOT NULL default '99',
  CoutTerrain tinyint(4) NOT NULL default '3',
  TauxTerrain tinyint(4) NOT NULL default '17',
  TauxDesinvoc tinyint(4) NOT NULL default '50',
  UNIQUE KEY Id (Id)
) TYPE=MyISAM;


#
# Contenu de la table configCapacite
#

DROP TABLE IF EXISTS configCapacite;
CREATE TABLE configCapacite (
  Id tinyint(4) NOT NULL default '0',
  Name varchar(30) NOT NULL default 'Initiative',
  Abbrev varchar(10) NOT NULL default 'ini',
  LogoPath varchar(50) NOT NULL default 'images/logoinitiative.gif',
  Cout tinyint(4) NOT NULL default '3',
  UNIQUE KEY Id (Id)
) TYPE=MyISAM;

#
# Contenu de la table configCapaciteBonus
#

DROP TABLE IF EXISTS configCapaciteBonus;
CREATE TABLE configCapaciteBonus (
  Couleur varchar(20) NOT NULL default '',
  Capacite varchar(30) NOT NULL default '',
  Bonus tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

#
# Contenu de la table variableCosts
#

DROP TABLE IF EXISTS variablecosts;
CREATE TABLE variablecosts (
  Id 		int NOT NULL auto_increment,
  SortId 	int NOT NULL,
  PRIMARY KEY   (Id),
  UNIQUE KEY    Id (Id)
) TYPE=MyISAM;


#
# Structure de la table `echanges`
#

DROP TABLE IF EXISTS echanges;
CREATE TABLE echanges (
  Id		int NOT NULL auto_increment,
  Date		datetime NOT NULL default '0000-00-00 00:00:00',
  DonneurId	int(11) NOT NULL,
  ReceveurId	int(11) NOT NULL,
  Nombre	int NOT NULL default 0,
  PRIMARY KEY  (Id),
  UNIQUE KEY Ids (DonneurId,ReceveurId),
  KEY Ids_2 (DonneurId,ReceveurId)
) TYPE=MyISAM;