Subversion Repositories Applications.gtt

Rev

Rev 10 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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