Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 707 → Rev 706

/trunk/doc/sql/del.sql
41,7 → 41,8
`date_creation` DATETIME NULL ,
`publiable_eflore` TINYINT(1) NULL ,
PRIMARY KEY (`id_image`) ,
UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) )
UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) ,
INDEX `fk_Images_Utilisateurs1` (`ce_utilisateur` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
73,7 → 74,8
`date_creation` DATETIME NULL ,
`date_modification` DATETIME NULL ,
`date_transmission` DATETIME NULL ,
PRIMARY KEY (`id_observation`) )
PRIMARY KEY (`id_observation`) ,
INDEX `fk_Observations_Utilisateurs1` (`ce_utilisateur` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
105,9 → 107,11
`ce_utilisateur` INT NOT NULL ,
`ce_protocole` INT NOT NULL ,
`valeur_vote` TINYINT(1) NULL ,
`date_vote_image` DATETIME NULL ,
PRIMARY KEY (`id_vote_image`) ,
UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) )
UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) ,
INDEX `fk_Vote_images_Protocoles` (`ce_protocole` ASC) ,
INDEX `fk_Vote_images_Images1` (`ce_image` ASC) ,
INDEX `fk_Vote_images_Utilisateurs1` (`ce_utilisateur` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
124,7 → 128,9
`ce_image` INT NULL ,
`ce_utilisateur` INT NULL ,
`md5` VARCHAR(32) NULL ,
PRIMARY KEY (`id_tag`) )
PRIMARY KEY (`id_tag`) ,
INDEX `fk_Tags_Vote_images1` (`ce_image` ASC) ,
INDEX `fk_Tags_Utilisateurs1` (`ce_utilisateur` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
145,7 → 151,8
`nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,
`ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' ,
`ce_observation` INT NOT NULL ,
PRIMARY KEY (`id_proposition`) )
PRIMARY KEY (`id_proposition`) ,
INDEX `fk_Propositions_Observations1` (`ce_observation` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
166,7 → 173,11
`utilisateur_prenom` VARCHAR(45) NULL ,
`utilisateur_mail` VARCHAR(45) NULL ,
`ce_observation` INT NULL ,
PRIMARY KEY (`id_commentaire`, `ce_proposition`) )
PRIMARY KEY (`id_commentaire`, `ce_proposition`) ,
INDEX `fk_Commentaires_Propositions1` (`ce_proposition` ASC) ,
INDEX `fk_Commentaires_Commentaires1` (`ce_commentaire` ASC) ,
INDEX `fk_Commentaires_Utilisateurs1` (`ce_utilisateur` ASC) ,
INDEX `fk_Commentaires_Observations1` (`ce_observation` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
182,9 → 193,10
`ce_proposition` INT NOT NULL ,
`ce_utilisateur` INT NOT NULL ,
`valeur_vote` TINYINT(1) NULL ,
`date_vote_observation` DATETIME NULL ,
PRIMARY KEY (`id_vote_observations`) ,
UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) )
UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) ,
INDEX `fk_Vote_observations_Utilisateurs1` (`ce_utilisateur` ASC) ,
INDEX `fk_Vote_observations_Propositions1` (`ce_proposition` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
200,7 → 212,10
`ce_utilisateur` INT NOT NULL ,
`ce_observation` INT NOT NULL ,
`date_liaison` DATETIME NULL ,
PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) )
PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) ,
INDEX `fk_Obs_images_Images1` (`ce_image` ASC) ,
INDEX `fk_Obs_images_Utilisateurs1` (`ce_utilisateur` ASC) ,
INDEX `fk_Obs_images_Observations1` (`ce_observation` ASC) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
210,4 → 225,3
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;