| Line 206... |
Line 206... |
| 206 |
-- -----------------------------------------------------
|
206 |
-- -----------------------------------------------------
|
| 207 |
DROP TABLE IF EXISTS `cel_obs_etendues` ;
|
207 |
DROP TABLE IF EXISTS `cel_obs_etendues` ;
|
| Line 208... |
Line 208... |
| 208 |
|
208 |
|
| 209 |
CREATE TABLE IF NOT EXISTS `cel_obs_etendues` (
|
209 |
CREATE TABLE IF NOT EXISTS `cel_obs_etendues` (
|
| - |
|
210 |
`id_observation` BIGINT NOT NULL ,
|
| 210 |
`id_observation` BIGINT NOT NULL ,
|
211 |
`cle` VARCHAR(255) NOT NULL COMMENT 'Clé du champ au format chat mot (sans accents).\nEx. : maCle, uneAutreCle' ,
|
| 211 |
`cle` VARCHAR(255) NOT NULL ,
|
212 |
`label` VARCHAR(255) NOT NULL COMMENT 'Intitulé du champ à afficher dans les formulaires.' ,
|
| 212 |
`valeur` VARCHAR(255) NOT NULL ,
|
213 |
`valeur` VARCHAR(255) NOT NULL COMMENT 'Valeur du champ.' ,
|
| 213 |
PRIMARY KEY (`id_observation`, `cle`) )
|
214 |
PRIMARY KEY (`id_observation`, `cle`) )
|
| 214 |
ENGINE = MyISAM
|
215 |
ENGINE = MyISAM
|
| 215 |
DEFAULT CHARACTER SET = utf8
|
216 |
DEFAULT CHARACTER SET = utf8
|
| 216 |
COLLATE = utf8_general_ci
|
217 |
COLLATE = utf8_general_ci
|
| Line 289... |
Line 290... |
| 289 |
-- -----------------------------------------------------
|
290 |
-- -----------------------------------------------------
|
| 290 |
DROP TABLE IF EXISTS `cel_images_etendues` ;
|
291 |
DROP TABLE IF EXISTS `cel_images_etendues` ;
|
| Line 291... |
Line 292... |
| 291 |
|
292 |
|
| 292 |
CREATE TABLE IF NOT EXISTS `cel_images_etendues` (
|
293 |
CREATE TABLE IF NOT EXISTS `cel_images_etendues` (
|
| - |
|
294 |
`id_observation` BIGINT NOT NULL ,
|
| 293 |
`id_observation` BIGINT NOT NULL ,
|
295 |
`cle` VARCHAR(255) NOT NULL COMMENT 'Clé du champ au format chat mot (sans accents).\nEx. : maCle, uneAutreCle' ,
|
| 294 |
`cle` VARCHAR(255) NOT NULL ,
|
296 |
`label` VARCHAR(45) NOT NULL COMMENT 'Intitulé du champ à afficher dans les formulaires.' ,
|
| 295 |
`valeur` VARCHAR(255) NOT NULL ,
|
297 |
`valeur` VARCHAR(255) NOT NULL COMMENT 'Valeur du champ.' ,
|
| 296 |
PRIMARY KEY (`id_observation`, `cle`) )
|
298 |
PRIMARY KEY (`id_observation`, `cle`) )
|
| 297 |
ENGINE = MyISAM
|
299 |
ENGINE = MyISAM
|
| 298 |
DEFAULT CHARACTER SET = utf8
|
300 |
DEFAULT CHARACTER SET = utf8
|
| 299 |
COLLATE = utf8_general_ci
|
301 |
COLLATE = utf8_general_ci
|