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
| CREATE TABLE "Evenements" (
"ID" INTEGER PRIMARY KEY NOT NULL,
"LotofootID" INTEGER NOT NULL,
"Annee" INTEGER NOT NULL,
"Numero" INTEGER NOT NULL,
"DateModification" DATETIME,
"EtatMaj" INTEGER,
"NbMatchs" INTEGER,
"DebutValidation" DATETIME,
"FinValidation" DATETIME,
"ResultatsPublies" BOOL NOT NULL,
"RapportsPublies" BOOL NOT NULL,
"DateLimitePaiement" DATETIME,
"NiveauPremierRang" INTEGER,
UNIQUE ("LotofootID", "Annee", "Numero")
);
CREATE TABLE "Evenements_Matchs" (
"EvenementID" INTEGER NOT NULL,
"NumMatch" INTEGER NOT NULL,
"Equipe1" VARCHAR,
"Equipe2" VARCHAR,
"Cote1" REAL,
"CoteN" REAL,
"Cote2" REAL,
"Resultat" INTEGER,
PRIMARY KEY("EvenementID", "NumMatch"),
FOREIGN KEY("EvenementID") REFERENCES "Evenements"("ID")
); |
Partager