1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| -- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Client: localhost:3306
-- Généré le: Lun 01 Août 2016 à 13:27
-- Version du serveur: 10.0.26-MariaDB
-- Version de PHP: 5.4.31
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: `weblobsd_test`
--
-- --------------------------------------------------------
--
-- Structure de la table `ressource`
--
CREATE TABLE IF NOT EXISTS `ressource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gold` decimal(11,0) unsigned DEFAULT NULL,
`cristal` decimal(11,0) unsigned DEFAULT NULL,
`titane` decimal(11,0) unsigned DEFAULT NULL,
`orinia` decimal(11,0) unsigned DEFAULT NULL,
`orinium` decimal(11,0) unsigned DEFAULT NULL,
`energie` decimal(11,0) unsigned DEFAULT NULL,
`organique` decimal(11,0) unsigned DEFAULT NULL,
`temps` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`id_planete` int(11) DEFAULT NULL,
`id_membre` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `ressource`
--
INSERT INTO `ressource` (`id`, `gold`, `cristal`, `titane`, `orinia`, `orinium`, `energie`, `organique`, `temps`, `id_planete`, `id_membre`) VALUES
(1, '1031', '8', '16', '0', '8', '3000', '40', '2016-08-01 11:25:47', 1, 1),
(2, '99999998975', '99999999389', '99999999453', '99999999154', '99999999999', '900', '99999999999', '2016-08-01 11:10:49', 2, 2),
(3, '91909402', '91902250', '153151950', '30626142', '61249500', '1000', '398121735', '2016-08-01 11:10:49', 3, 3),
(4, '145540', '13938', '16266', '5532', '0', '1000', '0', '2016-08-01 11:10:49', 4, 4);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Partager