package com.moanoit.belote.db;
/**
* Classe de constantes pour la base de donnes.
* @author BDELBOS
*
*/
public final class ConstantesDataBase {
/**
* Nom de base de donnes.
*/
public static final String DATABASE_NAME = "belotte";
/**
* Table de staockage des quipes.
*/
public static final String TABLE_TEAMS = "teams";
/**
* table de stockage des parties.
*/
public static final String TABLE_MANCHES = "manches";
/**
* Table de stockage des prises.
*/
public static final String TABLE_PRISES = "prises";
/**
* Table de stockage des joueurs.
*/
public static final String TABLE_PLAYERS = "players";
/**
* Version de la base de donnes.
*/
public static final int DATABASE_VERSION = 1;
/**
* Chaine de cration de la table des quipes.
*/
public static final String TABLE_TEAMS_CREATE =
"create table teams ("
+ "_id integer primary key autoincrement, "
+ "name text not null, "
+ "player1 text not null, "
+ "player2 text not null);";
/**
* Chaine de cration de la table des parties.
*/
public static final String TABLE_MANCHES_CREATE =
"create table manches ("
+ "_id integer primary key autoincrement, "
+ "id_team1 interger, "
+ "id_team2 interger, " + "score1 integer, " + "score2 integer, "
+ "current boolean);";
/**
* Chaine de cration de la table des prises.
*/
public static final String TABLE_PRISES_CREATE =
"create table prises ("
+ "_id integer primary key autoincrement, "
+ "number integer not null, "
+ "party_id integer not null, "
+ "id_team1 interger, "
+ "id_team2 interger, "
+ "score1 integer not null, "
+ "score2 integer not null);";
/**
* Chaine de cration de la table des joueurs.
*/
public static final String TABLE_PLAYER_CREATE =
"create table players ("
+ "_id integer primary key autoincrement, "
+ "name text not null);";
/**
* Constructeur priv de la classe.
*/
private ConstantesDataBase() { }
}
|