Project Galaxy EW - PLANETE.SQL

-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Dim 12 Février 2017 à 19:31
-- Version du serveur: 10.0.28-MariaDB
-- Version de PHP: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `u218634216_bdd1`
--

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

--
-- Structure de la table `planete`
--
CREATE TABLE IF NOT EXISTS `systemes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coordonnee_aX` int(10) DEFAULT NULL,
  `coordonnee_bX` int(10) DEFAULT NULL,
  `coordonnee_cX` int(10) DEFAULT NULL,
  `coordonnee_dX` int(10) DEFAULT NULL,
  `coordonnee_aY` int(10) DEFAULT NULL,
  `coordonnee_bY` int(10) DEFAULT NULL,
  `coordonnee_cY` int(10) DEFAULT NULL,
  `coordonnee_dY` int(10) DEFAULT NULL,
  `pseudo_membre` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'aucun',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10001;


CREATE TABLE IF NOT EXISTS `planete` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom_planete` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coordonnee_x` int(10) DEFAULT NULL,
  `coordonnee_y` int(10) DEFAULT NULL,
  `num_systeme` int(10) DEFAULT NULL,
  `planete_mere` tinyint(10) DEFAULT NULL,
  `avatar_p` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_membre` int(11) DEFAULT NULL,
  `id_population` int(11) NOT NULL,
  `id_mine` int(11) NOT NULL,
  `id_batiment` int(11) NOT NULL,
  `id_defense` int(11) NOT NULL,
  `id_caserne` int(11) NOT NULL,
  `id_image_planete` int(10) NOT NULL,
  `coordonnee` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `cite_rare` int(11) DEFAULT NULL,
  `planete_occupe` int(11) NOT NULL,
  `pseudo_membre` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'aucun',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10001 ;