1 2 3 4 5 6 7 8
| private static final String CREATE_BDD = "CREATE TABLE " + TABLE_JOUEURS + " ("
+ COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_NOM + " TEXT NOT NULL, "
+ COL_PRENOM + " TEXT NOT NULL,"+COL_AGE+" TEXT NOT NULL,"+COL_EQUIPE+" TEXT NOT NULL);" +
"CREATE TABLE " + TABLE_MATCH + " ("
+ COL_IDMATCH + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_ZONE1 + " INTEGER NOT NULL, "
+ COL_ZONE2 + " INTEGER NOT NULL, "+COL_ZONE3 + " INTEGER NOT NULL, "+COL_ZONE4 + " INTEGER NOT NULL, "+COL_ZONE5 + " INTEGER NOT NULL, "
+COL_ZONE6 + " INTEGER NOT NULL, "+COL_ZONE7 + " INTEGER NOT NULL, "+COL_ZONE8 + " INTEGER NOT NULL, "+COL_ZONE9 + " INTEGER NOT NULL, "+COL_ZONE10 + " INTEGER NOT NULL,"
+COL_ZONE11 + " INTEGER NOT NULL,"+COL_ZONE12 + " INTEGER NOT NULL,"+COL_BATT + " INTEGER NOT NULL,"+COL_IDJOUEUR + " INTEGER NOT NULL"+COL_ADVERSAIRE + " TEXT NOT NULL);"; |
Partager