10 |
jpm |
1 |
DROP DATABASE IF EXISTS `gestion_v4`;
|
|
|
2 |
CREATE DATABASE `gestion_v4` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
|
|
|
3 |
|
|
|
4 |
CREATE TABLE `gestion_v4`.gestion_absence (
|
|
|
5 |
ga_id_abscence INTEGER(11) UNSIGNED NOT NULL,
|
|
|
6 |
ga_ce_absence_motif TINYINT(3) UNSIGNED NOT NULL,
|
|
|
7 |
ga_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
8 |
ga_date_debut DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
9 |
ga_date_fin DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
10 |
ga_date_envoi_lettre DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
11 |
PRIMARY KEY(ga_id_abscence)
|
|
|
12 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
13 |
|
|
|
14 |
CREATE TABLE `gestion_v4`.gestion_absence_motif (
|
|
|
15 |
gam_id_absence_motif TINYINT(3) UNSIGNED NOT NULL,
|
|
|
16 |
gam_libelle VARCHAR(255) NOT NULL,
|
|
|
17 |
gam_mark_rtt BOOL NOT NULL,
|
|
|
18 |
gam_nbre_heure INT(11) NULL,
|
|
|
19 |
PRIMARY KEY(gam_id_absence_motif)
|
|
|
20 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
21 |
|
|
|
22 |
CREATE TABLE `gestion_v4`.gestion_frais_km (
|
|
|
23 |
gfk_id_frais_km INTEGER(11) UNSIGNED NOT NULL,
|
|
|
24 |
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
|
|
|
25 |
gfk_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
26 |
gfk_date DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
27 |
gfk_nbre_km FLOAT NULL,
|
|
|
28 |
gfk_objet VARCHAR(255) NULL,
|
|
|
29 |
gfk_trajet VARCHAR(255) NULL,
|
|
|
30 |
gfk_montant_total FLOAT NOT NULL,
|
|
|
31 |
PRIMARY KEY(gfk_id_frais_km)
|
|
|
32 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
33 |
|
|
|
34 |
CREATE TABLE `gestion_v4`.gestion_frais_km_taux (
|
|
|
35 |
gfkt_id_frais_km_taux INTEGER(11) UNSIGNED NOT NULL,
|
|
|
36 |
gfkt_taux FLOAT NOT NULL,
|
|
|
37 |
PRIMARY KEY(gfkt_id_frais_km_taux)
|
|
|
38 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
39 |
|
|
|
40 |
CREATE TABLE `gestion_v4`.gestion_note_frais (
|
|
|
41 |
gnf_id_note_frais INTEGER(11) UNSIGNED NOT NULL,
|
|
|
42 |
gnf_ce_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
43 |
gnf_libelle VARCHAR(255) NOT NULL,
|
|
|
44 |
PRIMARY KEY(gnf_id_note_frais)
|
|
|
45 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
46 |
|
|
|
47 |
CREATE TABLE `gestion_v4`.gestion_note_frais_ligne (
|
|
|
48 |
gnfl_id_note_frais_ligne INTEGER(11) UNSIGNED NOT NULL,
|
|
|
49 |
gnfl_ce_note_frais INTEGER(11) UNSIGNED NOT NULL,
|
|
|
50 |
gnfl_date DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
51 |
gnfl_montant_ht FLOAT NULL,
|
|
|
52 |
gnfl_taux_tva FLOAT NULL,
|
|
|
53 |
gnfl_montant_ttc FLOAT NOT NULL,
|
|
|
54 |
PRIMARY KEY(gnfl_id_note_frais_ligne)
|
|
|
55 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
56 |
|
|
|
57 |
CREATE TABLE `gestion_v4`.gestion_projet (
|
|
|
58 |
gp_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
|
|
59 |
gp_ce_categorie INTEGER(11) UNSIGNED NOT NULL,
|
|
|
60 |
gp_nom_projet VARCHAR(255) NOT NULL,
|
|
|
61 |
gp_description TEXT NULL,
|
|
|
62 |
gp_date_debut DATE NULL,
|
|
|
63 |
gp_duree_prevue FLOAT NULL,
|
|
|
64 |
gp_avancement INTEGER(11) NULL,
|
|
|
65 |
PRIMARY KEY(gp_id_projet)
|
|
|
66 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
67 |
|
|
|
68 |
CREATE TABLE `gestion_v4`.gestion_projet_categorie (
|
|
|
69 |
gpc_id_categorie INTEGER(11) UNSIGNED NOT NULL,
|
|
|
70 |
gpc_libelle VARCHAR(255) NOT NULL,
|
|
|
71 |
PRIMARY KEY(gpc_id_categorie)
|
|
|
72 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
73 |
|
|
|
74 |
CREATE TABLE `gestion_v4`.gestion_projet_tache (
|
|
|
75 |
gpt_id_tache INTEGER(11) UNSIGNED NOT NULL,
|
|
|
76 |
gpt_ce_tache_precedente INTEGER(11) UNSIGNED NOT NULL,
|
|
|
77 |
gpt_ce_projet INTEGER(11) UNSIGNED NOT NULL,
|
|
|
78 |
gpt_libelle VARCHAR(255) NOT NULL,
|
|
|
79 |
gpt_description TEXT NULL,
|
|
|
80 |
gpt_date_debut DATE NULL,
|
|
|
81 |
gpt_duree_prevue INTEGER(11) UNSIGNED NULL,
|
|
|
82 |
gpt_avancement INTEGER(11) NULL,
|
|
|
83 |
PRIMARY KEY(gpt_id_tache)
|
|
|
84 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
85 |
|
|
|
86 |
CREATE TABLE `gestion_v4`.gestion_travail_projet (
|
|
|
87 |
gtp_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
88 |
gtp_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
|
|
89 |
gtp_id_date_travail DATE NOT NULL DEFAULT "0000-00-00",
|
|
|
90 |
gtp_duree FLOAT NOT NULL DEFAULT 0,
|
|
|
91 |
PRIMARY KEY(gtp_id_utilisateur, gtp_id_projet, gtp_id_date_travail)
|
|
|
92 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
93 |
|
|
|
94 |
CREATE TABLE `gestion_v4`.gestion_travail_tache (
|
|
|
95 |
gtt_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
96 |
gtt_id_tache INTEGER(11) UNSIGNED NOT NULL,
|
|
|
97 |
gtt_id_date_travail DATE NOT NULL,
|
|
|
98 |
gtt_duree FLOAT NOT NULL DEFAULT 0,
|
|
|
99 |
PRIMARY KEY(gtt_id_utilisateur, gtt_id_tache, gtt_id_date_travail)
|
|
|
100 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
101 |
|
|
|
102 |
CREATE TABLE `gestion_v4`.gestion_utilisateur (
|
|
|
103 |
gu_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
104 |
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
|
|
|
105 |
gu_nom VARCHAR(100) NOT NULL,
|
|
|
106 |
gu_prenom VARCHAR(100) NOT NULL,
|
|
|
107 |
gu_password VARCHAR(32) NOT NULL,
|
|
|
108 |
gu_email VARCHAR(255) NOT NULL,
|
|
|
109 |
gu_telephone INTEGER(11) UNSIGNED NULL,
|
|
|
110 |
gu_adresse VARCHAR(255) NULL,
|
|
|
111 |
gu_code_postal INTEGER(11) UNSIGNED NULL,
|
|
|
112 |
gu_ville VARCHAR(50) NULL,
|
|
|
113 |
gu_quota_heures_supp FLOAT NULL,
|
|
|
114 |
gu_conges_payes FLOAT NULL,
|
|
|
115 |
gu_temps_de_travail FLOAT NULL,
|
|
|
116 |
gu_mark_admin BOOL NULL,
|
|
|
117 |
gu_mark_recapitulatif BOOL NULL,
|
|
|
118 |
gu_notes TEXT NULL,
|
|
|
119 |
PRIMARY KEY(gu_id_utilisateur)
|
|
|
120 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
121 |
|
|
|
122 |
CREATE TABLE `gestion_v4`.gestion_utilisateur_a_projet (
|
|
|
123 |
guap_id_utilisateur INTEGER(11) UNSIGNED NOT NULL,
|
|
|
124 |
guap_id_projet INTEGER(11) UNSIGNED NOT NULL,
|
|
|
125 |
PRIMARY KEY(guap_id_utilisateur, guap_id_projet)
|
|
|
126 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
|
127 |
|
|
|
128 |
CREATE TABLE `gestion_v4`.gestion_utilisateur_statut (
|
|
|
129 |
gus_id_utilisateur_statut TINYINT(3) UNSIGNED NOT NULL,
|
|
|
130 |
gus_libelle VARCHAR(255) NOT NULL,
|
|
|
131 |
PRIMARY KEY(gus_id_utilisateur_statut)
|
|
|
132 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|