Rev 10 | Blame | Last modification | View Log | RSS feed
DROP DATABASE IF EXISTS `gestion_v4`;
CREATE DATABASE `gestion_v4` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE `gestion_v4`.gestion_absence (
ga_id_abscence INTEGER(11) UNSIGNED NOT NULL,
ga_ce_absence_motif TINYINT(3) UNSIGNED NOT NULL,
ga_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
ga_date_debut DATE NOT NULL DEFAULT "0000-00-00",
ga_date_fin DATE NOT NULL DEFAULT "0000-00-00",
ga_date_envoi_lettre DATE NOT NULL DEFAULT "0000-00-00",
PRIMARY KEY(ga_id_abscence)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_absence_motif (
gam_id_absence_motif TINYINT(3) UNSIGNED NOT NULL,
gam_libelle VARCHAR(255) NOT NULL,
gam_mark_rtt BOOL NOT NULL,
gam_nbre_heure INT(11) NULL,
PRIMARY KEY(gam_id_absence_motif)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_frais_km (
gfk_id_frais_km INTEGER(11) UNSIGNED NOT NULL,
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
gfk_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
gfk_date DATE NOT NULL DEFAULT "0000-00-00",
gfk_nbre_km FLOAT NULL,
gfk_objet VARCHAR(255) NULL,
gfk_trajet VARCHAR(255) NULL,
gfk_montant_total FLOAT NOT NULL,
PRIMARY KEY(gfk_id_frais_km)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_frais_km_taux (
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
gfkt_taux FLOAT NOT NULL,
PRIMARY KEY(gfkt_id_frais_km_taux)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_note_frais (
gnf_id_note_frais INTEGER(11) UNSIGNED NOT NULL,
gnf_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
gnf_libelle VARCHAR(255) NOT NULL,
PRIMARY KEY(gnf_id_note_frais)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_note_frais_ligne (
gnfl_id_note_frais_ligne INTEGER(11) UNSIGNED NOT NULL,
gnfl_ce_note_frais INTEGER(11) UNSIGNED NOT NULL,
gnfl_date DATE NOT NULL DEFAULT "0000-00-00",
gnfl_montant_ht FLOAT NULL,
gnfl_taux_tva FLOAT NULL,
gnfl_montant_ttc FLOAT NOT NULL,
PRIMARY KEY(gnfl_id_note_frais_ligne)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_projet (
gp_id_projet INTEGER(11) UNSIGNED NOT NULL,
gp_ce_categorie INTEGER(11) UNSIGNED NOT NULL,
gp_nom_projet VARCHAR(255) NOT NULL,
gp_description TEXT NULL,
gp_date_debut DATE NULL,
gp_duree_prevue FLOAT NULL,
gp_avancement INTEGER(11) NULL,
PRIMARY KEY(gp_id_projet)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_projet_categorie (
gpc_id_categorie INTEGER(11) UNSIGNED NOT NULL,
gpc_libelle VARCHAR(255) NOT NULL,
PRIMARY KEY(gpc_id_categorie)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_projet_tache (
gpt_id_tache INTEGER(11) UNSIGNED NOT NULL,
gpt_ce_tache_precedente INTEGER(11) UNSIGNED NOT NULL,
gpt_ce_projet INTEGER(11) UNSIGNED NOT NULL,
gpt_libelle VARCHAR(255) NOT NULL,
gpt_description TEXT NULL,
gpt_date_debut DATE NULL,
gpt_duree_prevue INTEGER(11) UNSIGNED NULL,
gpt_avancement INTEGER(11) NULL,
PRIMARY KEY(gpt_id_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_travail_projet (
gtp_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
gtp_id_projet INTEGER(11) UNSIGNED NOT NULL,
gtp_id_date_travail DATE NOT NULL DEFAULT "0000-00-00",
gtp_duree FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY(gtp_id_utilisateur, gtp_id_projet, gtp_id_date_travail)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_travail_tache (
gtt_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
gtt_id_tache INTEGER(11) UNSIGNED NOT NULL,
gtt_id_date_travail DATE NOT NULL,
gtt_duree FLOAT NOT NULL DEFAULT 0,
PRIMARY KEY(gtt_id_utilisateur, gtt_id_tache, gtt_id_date_travail)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_utilisateur (
gu_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
gu_nom VARCHAR(100) NOT NULL,
gu_prenom VARCHAR(100) NOT NULL,
gu_password VARCHAR(32) NOT NULL,
gu_email VARCHAR(255) NOT NULL,
gu_telephone INTEGER(11) UNSIGNED NULL,
gu_adresse VARCHAR(255) NULL,
gu_code_postal INTEGER(11) UNSIGNED NULL,
gu_ville VARCHAR(50) NULL,
gu_quota_heures_supp FLOAT NULL,
gu_conges_payes FLOAT NULL,
gu_temps_de_travail FLOAT NULL,
gu_mark_admin BOOL NULL,
gu_mark_recapitulatif BOOL NULL,
gu_notes TEXT NULL,
PRIMARY KEY(gu_id_utilisateur)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_utilisateur_a_projet (
guap_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
guap_id_projet INTEGER(11) UNSIGNED NOT NULL,
PRIMARY KEY(guap_id_utilisateur, guap_id_projet)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
CREATE TABLE `gestion_v4`.gestion_utilisateur_statut (
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
gus_libelle VARCHAR(255) NOT NULL,
PRIMARY KEY(gus_id_utilisateur_statut)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;