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 ;