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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
1.
--
2.
-- Structure de la table `batiment`
3.
--
4.
5.
CREATE TABLE `batiment` (
6.
`id` int(11) NOT NULL AUTO_INCREMENT,
7.
`batiment` varchar(255) NOT NULL,
8.
`niveau` int(11) NOT NULL,
9.
`usure` int(11) NOT NULL,
10.
`idjoueur` int(11) NOT NULL,
11.
`timestamp` bigint(20) NOT NULL,
12.
`timestampexe` bigint(20) NOT NULL,
13.
PRIMARY KEY (`id`)
14.
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=261 ;
#
--
#
-- Structure de la table `niveau`
#
--
#
#
CREATE TABLE `niveau` (
#
`id` int(11) NOT NULL AUTO_INCREMENT,
#
`nom` varchar(255) NOT NULL,
#
`niveau` varchar(255) NOT NULL,
#
`usure` bigint(255) NOT NULL,
#
`argent` bigint(255) NOT NULL,
#
`nourriture` varchar(255) NOT NULL,
#
`population` varchar(255) NOT NULL,
#
`electriciter` varchar(255) NOT NULL,
#
`metal` varchar(255) NOT NULL,
#
`bois` varchar(255) NOT NULL,
#
`cristal` varchar(255) NOT NULL,
#
`time` varchar(255) NOT NULL,
#
`fonction` varchar(255) NOT NULL,
#
`type` varchar(255) NOT NULL,
#
PRIMARY KEY (`id`)
#
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 |
Partager