Browse code
Passage en MySQL
schardon authored on 01/05/2020 17:19:57
Showing 1 changed files
| 1 | 1 |
new file mode 100644 |
| ... | ... |
@@ -0,0 +1,61 @@ |
| 1 |
+Creation des bases : |
|
| 2 |
+ |
|
| 3 |
+ |
|
| 4 |
+ |
|
| 5 |
+-- Structure de la table `jeuweb_karuba_parties` |
|
| 6 |
+ |
|
| 7 |
+CREATE TABLE `jeuweb_karuba_parties` ( |
|
| 8 |
+ `id` int(11) NOT NULL, |
|
| 9 |
+ `nom` text NOT NULL, |
|
| 10 |
+ `pioche` text NOT NULL, |
|
| 11 |
+ `statut` int(11) NOT NULL DEFAULT '0', |
|
| 12 |
+ `tresor1` text NOT NULL, |
|
| 13 |
+ `tresor2` text NOT NULL, |
|
| 14 |
+ `tresor3` text NOT NULL, |
|
| 15 |
+ `tresor4` text NOT NULL, |
|
| 16 |
+ `wait` int(11) NOT NULL DEFAULT '0' |
|
| 17 |
+) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
|
| 18 |
+ |
|
| 19 |
+ALTER TABLE `jeuweb_karuba_parties` |
|
| 20 |
+ ADD PRIMARY KEY (`id`); |
|
| 21 |
+ |
|
| 22 |
+ALTER TABLE `jeuweb_karuba_parties` |
|
| 23 |
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; |
|
| 24 |
+ |
|
| 25 |
+ |
|
| 26 |
+ |
|
| 27 |
+-- Structure de la table `jeuweb_karuba_joueurs` |
|
| 28 |
+ |
|
| 29 |
+CREATE TABLE `jeuweb_karuba_joueurs` ( |
|
| 30 |
+ `id` int(11) NOT NULL, |
|
| 31 |
+ `nom` text NOT NULL, |
|
| 32 |
+ `partie_id` int(11) NOT NULL, |
|
| 33 |
+ `plateau` text NOT NULL, |
|
| 34 |
+ `statut` int(11) NOT NULL DEFAULT '0', |
|
| 35 |
+ `tresor1` int(11) NOT NULL DEFAULT '0', |
|
| 36 |
+ `tresor2` int(11) NOT NULL DEFAULT '0', |
|
| 37 |
+ `tresor3` int(11) NOT NULL DEFAULT '0', |
|
| 38 |
+ `tresor4` int(11) NOT NULL DEFAULT '0', |
|
| 39 |
+ `pepite_diamant` int(11) NOT NULL DEFAULT '0', |
|
| 40 |
+ `pepite_or` int(11) NOT NULL DEFAULT '0', |
|
| 41 |
+ `dernier_coup` text NOT NULL, |
|
| 42 |
+ `position_meeple1` int(11) NOT NULL DEFAULT '0', |
|
| 43 |
+ `position_temple1` int(11) NOT NULL DEFAULT '0', |
|
| 44 |
+ `position_meeple2` int(11) NOT NULL DEFAULT '0', |
|
| 45 |
+ `position_temple2` int(11) NOT NULL DEFAULT '0', |
|
| 46 |
+ `position_meeple3` int(11) NOT NULL DEFAULT '0', |
|
| 47 |
+ `position_temple3` int(11) NOT NULL DEFAULT '0', |
|
| 48 |
+ `position_meeple4` int(11) NOT NULL DEFAULT '0', |
|
| 49 |
+ `position_temple4` int(11) NOT NULL DEFAULT '0' |
|
| 50 |
+) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
|
| 51 |
+ |
|
| 52 |
+ALTER TABLE `jeuweb_karuba_joueurs` |
|
| 53 |
+ ADD PRIMARY KEY (`id`); |
|
| 54 |
+ |
|
| 55 |
+ALTER TABLE `jeuweb_karuba_joueurs` |
|
| 56 |
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; |
|
| 57 |
+ |
|
| 58 |
+ |
|
| 59 |
+ |
|
| 60 |
+COMMIT; |
|
| 61 |
+ |