1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `video` (
`video_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`video_titre` VARCHAR(150) NOT NULL,
`video_info` TEXT ,
`video_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`video_vue` INT,
`video_tag` VARCHAR (150),
`categorie_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`video_id`),
CONSTRAINT `FKcategorie` FOREIGN KEY `FKcategorie` (`categorie_id`)
REFERENCES `categorie` (`categorie_id`)
ON DELETE CASCADE
ON UPDATE CASCADE
)ENGINE = InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
CREATE TABLE `categorie` (
`categorie_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`libelle_categorie` VARCHAR(32) NOT NULL
)TYPE=InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
CREATE TABLE `commentaire` (
`commentaire_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`commentaire_info` TEXT,
`video_id` INT UNSIGNED NOT NULL,
CONSTRAINT `FKvideo` FOREIGN KEY `FKvideo` (`video_id`)
REFERENCES `video` (`video_id`)
ON DELETE CASCADE
ON UPDATE CASCADE
)TYPE=InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
CREATE TABLE `note` (
`note_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`note_note` INT (10),
`video_id` INT UNSIGNED NOT NULL,
CONSTRAINT `FKvideo` FOREIGN KEY `FKvideo` (`video_id`)
REFERENCES `video` (`video_id`)
ON DELETE CASCADE
ON UPDATE CASCADE
)
TYPE=InnoDB
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
SET FOREIGN_KEY_CHECKS = 1; |
Partager