Subversion Repositories Applications.gtt

Compare Revisions

Ignore whitespace Rev 10 → Rev 11

/trunk/documentation/gtt_v4.sql
1,5 → 1,5
DROP DATABASE IF EXISTS `gestion_v4`;
CREATE DATABASE `gestion_v4` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
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,
9,7 → 9,7
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_bin;
) 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,
17,7 → 17,7
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_bin;
) 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,
29,13 → 29,13
gfk_trajet VARCHAR(255) NULL,
gfk_montant_total FLOAT NOT NULL,
PRIMARY KEY(gfk_id_frais_km)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
) 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_bin;
) 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,
42,7 → 42,7
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_bin;
) 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,
52,7 → 52,7
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_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE `gestion_v4`.gestion_projet (
gp_id_projet INTEGER(11) UNSIGNED NOT NULL,
63,13 → 63,13
gp_duree_prevue FLOAT NULL,
gp_avancement INTEGER(11) NULL,
PRIMARY KEY(gp_id_projet)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
) 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_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE `gestion_v4`.gestion_projet_tache (
gpt_id_tache INTEGER(11) UNSIGNED NOT NULL,
81,7 → 81,7
gpt_duree_prevue INTEGER(11) UNSIGNED NULL,
gpt_avancement INTEGER(11) NULL,
PRIMARY KEY(gpt_id_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE `gestion_v4`.gestion_travail_projet (
gtp_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
89,7 → 89,7
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_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE `gestion_v4`.gestion_travail_tache (
gtt_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
97,7 → 97,7
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_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE `gestion_v4`.gestion_utilisateur (
gu_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
117,16 → 117,16
gu_mark_recapitulatif BOOL NULL,
gu_notes TEXT NULL,
PRIMARY KEY(gu_id_utilisateur)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
) 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_bin;
) 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_bin;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;