Berichten voorbeeld

We gaan onze database uitbreiden met een 'berichten' tabel. Voor onderstaan de query uit op je database.

CREATE TABLE `berichten` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
   `titel` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   `bericht` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
   `van_id` INT(10) UNSIGNED NOT NULL,
   `aan_id` INT(10) UNSIGNED NOT NULL,
   `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
   `updated_at` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
   `deleted_at` TIMESTAMP NULL DEFAULT NULL,
   PRIMARY KEY (`id`) USING BTREE,
   INDEX `FK_berichten_users` (`van_id`) USING BTREE,
   INDEX `FK_berichten_users_2` (`aan_id`) USING BTREE,
   CONSTRAINT `FK_berichten_users` FOREIGN KEY (`van_id`) REFERENCES `users` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT `FK_berichten_users_2` FOREIGN KEY (`aan_id`) REFERENCES `users` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;