Subversion Repositories Applications.gtt

Rev

Rev 10 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
10 jpm 1 
DROP DATABASE IF EXISTS `gestion_v4`;
11 jpm 2 
CREATE DATABASE `gestion_v4` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
10 jpm 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)
11 jpm 12 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 20 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 32 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 38 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 45 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 55 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 66 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 72 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 84 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 92 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 100 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 120 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 126 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
10 jpm 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)
11 jpm 132 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;