Subversion Repositories Applications.gtt

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 ;