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 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
|
DROP DATABASE IF EXISTS `ca`;
CREATE DATABASE `ca` DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
USE `ca`;
-- ----------------------------
-- Table structure for `t_cartes`
-- ----------------------------
DROP TABLE IF EXISTS `t_cartes`;
CREATE TABLE `t_cartes` (
`RefCarte` int(11) NOT NULL AUTO_INCREMENT,
`Nom` varchar(80) NOT NULL,
`Largeur` smallint(2) NOT NULL,
`Hauteur` smallint(2) NOT NULL,
PRIMARY KEY (`RefCarte`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_cartes
-- ----------------------------
INSERT INTO `t_cartes` VALUES ('1', 'CarteA', '50', '70');
-- ----------------------------
-- Table structure for `t_participants`
-- ----------------------------
DROP TABLE IF EXISTS `t_participants`;
CREATE TABLE `t_participants` (
`CodeID` int(10) NOT NULL,
`Nom` varchar(32) NOT NULL,
`Prenom` varchar(32) NOT NULL,
`Email` varchar(64) NOT NULL,
`Status` varchar(3) CHARACTER SET armscii8 NOT NULL,
`Camps` int(10) NOT NULL,
`RefNavLeader` int(10) NOT NULL,
PRIMARY KEY (`CodeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_participants
-- ----------------------------
-- ----------------------------
-- Table structure for `t_partie`
-- ----------------------------
DROP TABLE IF EXISTS `t_partie`;
CREATE TABLE `t_partie` (
`SitInitiale` tinyint(1) NOT NULL DEFAULT '0',
`RefNavire` int(10) NOT NULL,
`IndexListe` smallint(2) unsigned NOT NULL DEFAULT '0',
`CodeGroupe` int(10) unsigned DEFAULT '1',
`QualiteEquipage` tinyint(1) unsigned NOT NULL DEFAULT '2',
`Greement1` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Greement2` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Greement3` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Greement4` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Coque1` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Coque2` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Coque3` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Coque4` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Sec1` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ActSec1` tinyint(1) NOT NULL DEFAULT '0',
`S1LibreDans` tinyint(1) DEFAULT NULL,
`Sec2` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ActSec2` tinyint(1) NOT NULL,
`S2LibreDans` tinyint(1) DEFAULT NULL,
`Sec3` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ActSec3` tinyint(1) NOT NULL,
`S3LibreDans` tinyint(1) DEFAULT NULL,
`Sec4` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ActSec4` tinyint(1) NOT NULL,
`S4LibreDans` tinyint(1) DEFAULT NULL,
`SecM` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ActSecM` tinyint(1) NOT NULL,
`SMLibreDans` tinyint(1) DEFAULT NULL,
`GunDismBa` tinyint(1) unsigned NOT NULL DEFAULT '0',
`GunDismTr` tinyint(1) unsigned NOT NULL DEFAULT '0',
`BrdBaMasquee` tinyint(1) NOT NULL DEFAULT '0',
`BrdTrMasquee` tinyint(1) NOT NULL DEFAULT '0',
`BrdInitBa` tinyint(1) NOT NULL DEFAULT '1',
`BrdInitTr` tinyint(1) NOT NULL DEFAULT '1',
`PosX` smallint(2) NOT NULL,
`PosY` smallint(2) NOT NULL,
`Cap` tinyint(1) NOT NULL,
`OrdresMvtExec` varchar(32) NOT NULL,
`EtatVoilure` tinyint(1) NOT NULL DEFAULT '1',
`EstCapture` tinyint(1) NOT NULL DEFAULT '0',
`NouvCode` smallint(2) NOT NULL DEFAULT '0',
`VaExploser` tinyint(1) NOT NULL DEFAULT '0',
`VaCouler` tinyint(1) NOT NULL DEFAULT '0',
`SeRend` tinyint(1) NOT NULL DEFAULT '0',
`Detruit` tinyint(1) NOT NULL DEFAULT '0',
`Fatigue` tinyint(1) NOT NULL DEFAULT '0',
`QualEquipPrise` tinyint(1) NOT NULL DEFAULT '0',
`NbEquipPrise` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`SitInitiale`,`RefNavire`),
INDEX `indGroupe` (`CodeGroupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Partager