Creation des bases :



-- Structure de la table `jeuweb_karuba_parties`

CREATE TABLE `jeuweb_karuba_parties` (
  `id` int(11) NOT NULL,
  `nom` text NOT NULL,
  `pioche` text NOT NULL,
  `statut` int(11) NOT NULL DEFAULT '0',
  `tresor1` text NOT NULL,
  `tresor2` text NOT NULL,
  `tresor3` text NOT NULL,
  `tresor4` text NOT NULL,
  `wait` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `jeuweb_karuba_parties`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `jeuweb_karuba_parties`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;



-- Structure de la table `jeuweb_karuba_joueurs`

CREATE TABLE `jeuweb_karuba_joueurs` (
  `id` int(11) NOT NULL,
  `nom` text NOT NULL,
  `partie_id` int(11) NOT NULL,
  `plateau` text NOT NULL,
  `statut` int(11) NOT NULL DEFAULT '0',
  `tresor1` int(11) NOT NULL DEFAULT '0',
  `tresor2` int(11) NOT NULL DEFAULT '0',
  `tresor3` int(11) NOT NULL DEFAULT '0',
  `tresor4` int(11) NOT NULL DEFAULT '0',
  `pepite_diamant` int(11) NOT NULL DEFAULT '0',
  `pepite_or` int(11) NOT NULL DEFAULT '0',
  `dernier_coup` text NOT NULL,
  `position_meeple1` int(11) NOT NULL DEFAULT '0',
  `position_temple1` int(11) NOT NULL DEFAULT '0',
  `position_meeple2` int(11) NOT NULL DEFAULT '0',
  `position_temple2` int(11) NOT NULL DEFAULT '0',
  `position_meeple3` int(11) NOT NULL DEFAULT '0',
  `position_temple3` int(11) NOT NULL DEFAULT '0',
  `position_meeple4` int(11) NOT NULL DEFAULT '0',
  `position_temple4` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `jeuweb_karuba_joueurs`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `jeuweb_karuba_joueurs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;



COMMIT;