Subversion Repositories eFlore/Applications.del

Rev

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

Rev 692 Rev 694
Line 5... Line 5...
5 
DROP SCHEMA IF EXISTS `del` ;
 5 
DROP SCHEMA IF EXISTS `del` ;
6 
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
 6 
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
7 
USE `del` ;
 7 
USE `del` ;
Line 8... Line 8...
8 
 
 8 
 
9 
-- -----------------------------------------------------
 9 
-- -----------------------------------------------------
10 
-- Table `del`.`Utilisateurs`
 10 
-- Table `del`.`del_utilisateur`
11 
-- -----------------------------------------------------
 11 
-- -----------------------------------------------------
Line 12... Line 12...
12 
DROP TABLE IF EXISTS `del`.`Utilisateurs` ;
 12 
DROP TABLE IF EXISTS `del`.`del_utilisateur` ;
13 
 
 13 
 
14 
CREATE  TABLE IF NOT EXISTS `del`.`Utilisateurs` (
 14 
CREATE  TABLE IF NOT EXISTS `del`.`del_utilisateur` (
15 
  `id_utilisateur` INT NOT NULL COMMENT '	' ,
 15 
  `id_utilisateur` INT NOT NULL COMMENT '	' ,
16 
  `prenom` VARCHAR(45) NULL ,
 16 
  `prenom` VARCHAR(45) NULL ,
17 
  `nom` VARCHAR(45) NULL ,
 17 
  `nom` VARCHAR(45) NULL ,
Line 23... Line 23...
23 
DEFAULT CHARACTER SET = utf8
 23 
DEFAULT CHARACTER SET = utf8
24 
COLLATE = utf8_general_ci;
 24 
COLLATE = utf8_general_ci;
Line 25... Line 25...
25 
 
 25 
 
26 
 
 26 
 
27 
-- -----------------------------------------------------
 27 
-- -----------------------------------------------------
28 
-- Table `del`.`Images`
 28 
-- Table `del`.`del_image`
Line 29... Line 29...
29 
-- -----------------------------------------------------
 29 
-- -----------------------------------------------------
30 
DROP TABLE IF EXISTS `del`.`Images` ;
 30 
DROP TABLE IF EXISTS `del`.`del_image` ;
31 
 
 31 
 
32 
CREATE  TABLE IF NOT EXISTS `del`.`Images` (
 32 
CREATE  TABLE IF NOT EXISTS `del`.`del_image` (
33 
  `id_image` BIGINT NOT NULL ,
 33 
  `id_image` BIGINT NOT NULL ,
34 
  `ce_utilisateur` VARCHAR(32) NOT NULL ,
 34 
  `ce_utilisateur` VARCHAR(32) NOT NULL ,
Line 47... Line 47...
47 
DEFAULT CHARACTER SET = utf8
 47 
DEFAULT CHARACTER SET = utf8
48 
COLLATE = utf8_general_ci;
 48 
COLLATE = utf8_general_ci;
Line 49... Line 49...
49 
 
 49 
 
50 
 
 50 
 
51 
-- -----------------------------------------------------
 51 
-- -----------------------------------------------------
52 
-- Table `del`.`Observations`
 52 
-- Table `del`.`del_observation`
Line 53... Line 53...
53 
-- -----------------------------------------------------
 53 
-- -----------------------------------------------------
54 
DROP TABLE IF EXISTS `del`.`Observations` ;
 54 
DROP TABLE IF EXISTS `del`.`del_observation` ;
55 
 
 55 
 
56 
CREATE  TABLE IF NOT EXISTS `del`.`Observations` (
 56 
CREATE  TABLE IF NOT EXISTS `del`.`del_observation` (
57 
  `id_observation` INT NOT NULL ,
 57 
  `id_observation` INT NOT NULL ,
58 
  `ce_utilisateur` INT NULL ,
 58 
  `ce_utilisateur` INT NULL ,
Line 79... Line 79...
79 
DEFAULT CHARACTER SET = utf8
 79 
DEFAULT CHARACTER SET = utf8
80 
COLLATE = utf8_general_ci;
 80 
COLLATE = utf8_general_ci;
Line 81... Line 81...
81 
 
 81 
 
82 
 
 82 
 
83 
-- -----------------------------------------------------
 83 
-- -----------------------------------------------------
84 
-- Table `del`.`Protocoles`
 84 
-- Table `del`.`del_protocole`
Line 85... Line 85...
85 
-- -----------------------------------------------------
 85 
-- -----------------------------------------------------
86 
DROP TABLE IF EXISTS `del`.`Protocoles` ;
 86 
DROP TABLE IF EXISTS `del`.`del_protocole` ;
87 
 
 87 
 
88 
CREATE  TABLE IF NOT EXISTS `del`.`Protocoles` (
 88 
CREATE  TABLE IF NOT EXISTS `del`.`del_protocole` (
89 
  `id_protocole` INT NOT NULL ,
 89 
  `id_protocole` INT NOT NULL ,
90 
  `intitule` VARCHAR(255) NULL ,
 90 
  `intitule` VARCHAR(255) NULL ,
91 
  `descriptif` VARCHAR(255) NULL ,
 91 
  `descriptif` VARCHAR(255) NULL ,
92 
  PRIMARY KEY (`id_protocole`) )
 92 
  PRIMARY KEY (`id_protocole`) )
Line 93... Line 93...
93 
ENGINE = MyISAM
 93 
ENGINE = MyISAM
94 
DEFAULT CHARACTER SET = utf8
 94 
DEFAULT CHARACTER SET = utf8
95 
COLLATE = utf8_general_ci;
 95 
COLLATE = utf8_general_ci;
96 
 
 96 
 
Line 97... Line 97...
97 
 
 97 
 
98 
-- -----------------------------------------------------
 98 
-- -----------------------------------------------------
99 
-- Table `del`.`Vote_images`
 99 
-- Table `del`.`del_vote_image`
100 
-- -----------------------------------------------------
 100 
-- -----------------------------------------------------
101 
DROP TABLE IF EXISTS `del`.`Vote_images` ;
 101 
DROP TABLE IF EXISTS `del`.`del_vote_image` ;
102 
 
 102 
 
Line 112... Line 112...
112 
DEFAULT CHARACTER SET = utf8
 112 
DEFAULT CHARACTER SET = utf8
113 
COLLATE = utf8_general_ci;
 113 
COLLATE = utf8_general_ci;
Line 114... Line 114...
114 
 
 114 
 
115 
 
 115 
 
116 
-- -----------------------------------------------------
 116 
-- -----------------------------------------------------
117 
-- Table `del`.`Tags`
 117 
-- Table `del`.`del_tag`
Line 118... Line 118...
118 
-- -----------------------------------------------------
 118 
-- -----------------------------------------------------
119 
DROP TABLE IF EXISTS `del`.`Tags` ;
 119 
DROP TABLE IF EXISTS `del`.`del_tag` ;
120 
 
 120 
 
121 
CREATE  TABLE IF NOT EXISTS `del`.`Tags` (
 121 
CREATE  TABLE IF NOT EXISTS `del`.`del_tag` (
122 
  `id_tag` INT NOT NULL ,
 122 
  `id_tag` INT NOT NULL ,
123 
  `tag` VARCHAR(45) NULL ,
 123 
  `tag` VARCHAR(45) NULL ,
Line 129... Line 129...
129 
DEFAULT CHARACTER SET = utf8
 129 
DEFAULT CHARACTER SET = utf8
130 
COLLATE = utf8_general_ci;
 130 
COLLATE = utf8_general_ci;
Line 131... Line 131...
131 
 
 131 
 
132 
 
 132 
 
133 
-- -----------------------------------------------------
 133 
-- -----------------------------------------------------
134 
-- Table `del`.`Propositions`
 134 
-- Table `del`.`del_proposition`
Line 135... Line 135...
135 
-- -----------------------------------------------------
 135 
-- -----------------------------------------------------
136 
DROP TABLE IF EXISTS `del`.`Propositions` ;
 136 
DROP TABLE IF EXISTS `del`.`del_proposition` ;
137 
 
 137 
 
138 
CREATE  TABLE IF NOT EXISTS `del`.`Propositions` (
 138 
CREATE  TABLE IF NOT EXISTS `del`.`del_proposition` (
139 
  `id_proposition` INT NOT NULL ,
 139 
  `id_proposition` INT NOT NULL ,
140 
  `nom_sci` VARCHAR(45) NULL ,
 140 
  `nom_sci` VARCHAR(45) NULL ,
Line 146... Line 146...
146 
DEFAULT CHARACTER SET = utf8
 146 
DEFAULT CHARACTER SET = utf8
147 
COLLATE = utf8_general_ci;
 147 
COLLATE = utf8_general_ci;
Line 148... Line 148...
148 
 
 148 
 
149 
 
 149 
 
150 
-- -----------------------------------------------------
 150 
-- -----------------------------------------------------
151 
-- Table `del`.`Commentaires`
 151 
-- Table `del`.`del_commentaire`
Line 152... Line 152...
152 
-- -----------------------------------------------------
 152 
-- -----------------------------------------------------
153 
DROP TABLE IF EXISTS `del`.`Commentaires` ;
 153 
DROP TABLE IF EXISTS `del`.`del_commentaire` ;
154 
 
 154 
 
155 
CREATE  TABLE IF NOT EXISTS `del`.`Commentaires` (
 155 
CREATE  TABLE IF NOT EXISTS `del`.`del_commentaire` (
156 
  `id_commentaire` INT NOT NULL ,
 156 
  `id_commentaire` INT NOT NULL ,
157 
  `texte` VARCHAR(45) NULL ,
 157 
  `texte` VARCHAR(45) NULL ,
Line 167... Line 167...
167 
DEFAULT CHARACTER SET = utf8
 167 
DEFAULT CHARACTER SET = utf8
168 
COLLATE = utf8_general_ci;
 168 
COLLATE = utf8_general_ci;
Line 169... Line 169...
169 
 
 169 
 
170 
 
 170 
 
171 
-- -----------------------------------------------------
 171 
-- -----------------------------------------------------
172 
-- Table `del`.`Vote_observations`
 172 
-- Table `del`.`del_vote_observation`
Line 173... Line 173...
173 
-- -----------------------------------------------------
 173 
-- -----------------------------------------------------
174 
DROP TABLE IF EXISTS `del`.`Vote_observations` ;
 174 
DROP TABLE IF EXISTS `del`.`del_vote_observation` ;
175 
 
 175 
 
176 
CREATE  TABLE IF NOT EXISTS `del`.`Vote_observations` (
 176 
CREATE  TABLE IF NOT EXISTS `del`.`del_vote_observation` (
177 
  `id_vote_observations` INT NOT NULL ,
 177 
  `id_vote_observations` INT NOT NULL ,
178 
  `ce_proposition` INT NOT NULL ,
 178 
  `ce_proposition` INT NOT NULL ,
Line 184... Line 184...
184 
DEFAULT CHARACTER SET = utf8
 184 
DEFAULT CHARACTER SET = utf8
185 
COLLATE = utf8_general_ci;
 185 
COLLATE = utf8_general_ci;
Line 186... Line 186...
186 
 
 186 
 
187 
 
 187 
 
188 
-- -----------------------------------------------------
 188 
-- -----------------------------------------------------
189 
-- Table `del`.`Obs_images`
 189 
-- Table `del`.`del_obs_image`
Line 190... Line 190...
190 
-- -----------------------------------------------------
 190 
-- -----------------------------------------------------
191 
DROP TABLE IF EXISTS `del`.`Obs_images` ;
 191 
DROP TABLE IF EXISTS `del`.`del_obs_image` ;
192 
 
 192 
 
193 
CREATE  TABLE IF NOT EXISTS `del`.`Obs_images` (
 193 
CREATE  TABLE IF NOT EXISTS `del`.`del_obs_image` (
194 
  `ce_image` INT NOT NULL ,
 194 
  `ce_image` INT NOT NULL ,
195 
  `ce_utilisateur` INT NOT NULL ,
 195 
  `ce_utilisateur` INT NOT NULL ,