7,11 → 7,11 |
USE `del` ; |
|
-- ----------------------------------------------------- |
-- Table `del`.`del_utilisateur` |
-- Table `del`.`Utilisateurs` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_utilisateur` ; |
DROP TABLE IF EXISTS `del`.`Utilisateurs` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_utilisateur` ( |
CREATE TABLE IF NOT EXISTS `del`.`Utilisateurs` ( |
`id_utilisateur` INT NOT NULL COMMENT ' ' , |
`prenom` VARCHAR(45) NULL , |
`nom` VARCHAR(45) NULL , |
25,11 → 25,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_image` |
-- Table `del`.`Images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_image` ; |
DROP TABLE IF EXISTS `del`.`Images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_image` ( |
CREATE TABLE IF NOT EXISTS `del`.`Images` ( |
`id_image` BIGINT NOT NULL , |
`ce_utilisateur` VARCHAR(32) NOT NULL , |
`hauteur` INT NULL , |
49,11 → 49,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_observation` |
-- Table `del`.`Observations` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_observation` ; |
DROP TABLE IF EXISTS `del`.`Observations` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_observation` ( |
CREATE TABLE IF NOT EXISTS `del`.`Observations` ( |
`id_observation` INT NOT NULL , |
`ce_utilisateur` INT NULL , |
`nom_sel` VARCHAR(255) NULL , |
81,11 → 81,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_protocole` |
-- Table `del`.`Protocoles` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_protocole` ; |
DROP TABLE IF EXISTS `del`.`Protocoles` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_protocole` ( |
CREATE TABLE IF NOT EXISTS `del`.`Protocoles` ( |
`id_protocole` INT NOT NULL , |
`intitule` VARCHAR(255) NULL , |
`descriptif` VARCHAR(255) NULL , |
96,11 → 96,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_vote_image` |
-- Table `del`.`Vote_images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_vote_image` ; |
DROP TABLE IF EXISTS `del`.`Vote_images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_vote_image` ( |
CREATE TABLE IF NOT EXISTS `del`.`Vote_images` ( |
`id_vote_image` INT NOT NULL , |
`ce_image` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
114,11 → 114,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_tag` |
-- Table `del`.`Tags` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_tag` ; |
DROP TABLE IF EXISTS `del`.`Tags` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_tag` ( |
CREATE TABLE IF NOT EXISTS `del`.`Tags` ( |
`id_tag` INT NOT NULL , |
`tag` VARCHAR(45) NULL , |
`ce_image` INT NULL , |
131,11 → 131,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_proposition` |
-- Table `del`.`Propositions` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_proposition` ; |
DROP TABLE IF EXISTS `del`.`Propositions` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_proposition` ( |
CREATE TABLE IF NOT EXISTS `del`.`Propositions` ( |
`id_proposition` INT NOT NULL , |
`nom_sci` VARCHAR(45) NULL , |
`ce_utilisateur` VARCHAR(45) NULL , |
148,11 → 148,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_commentaire` |
-- Table `del`.`Commentaires` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_commentaire` ; |
DROP TABLE IF EXISTS `del`.`Commentaires` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_commentaire` ( |
CREATE TABLE IF NOT EXISTS `del`.`Commentaires` ( |
`id_commentaire` INT NOT NULL , |
`texte` VARCHAR(45) NULL , |
`ce_utilisateur` INT NULL , |
169,11 → 169,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_vote_observation` |
-- Table `del`.`Vote_observations` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_vote_observation` ; |
DROP TABLE IF EXISTS `del`.`Vote_observations` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_vote_observation` ( |
CREATE TABLE IF NOT EXISTS `del`.`Vote_observations` ( |
`id_vote_observations` INT NOT NULL , |
`ce_proposition` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
186,11 → 186,11 |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`del_obs_image` |
-- Table `del`.`Obs_images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`del_obs_image` ; |
DROP TABLE IF EXISTS `del`.`Obs_images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`del_obs_image` ( |
CREATE TABLE IF NOT EXISTS `del`.`Obs_images` ( |
`ce_image` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
`ce_observation` INT NOT NULL , |