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 ; |