KYVSFJe7

1CREATE DATABASE IF NOT EXISTS `test`;
2USE `test`;
3SET NAMES utf8;
4SET character_set_client = utf8mb4;
5
6DROP TABLE IF EXISTS `note`;
7
8CREATE TABLE `note` (
9  `id_note` int(11) NOT NULL AUTO_INCREMENT,
10  `content_note` varchar(45) NOT NULL,
11  `date_note` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
12  `author_id` int(11) NOT NULL,
13  PRIMARY KEY (`id_note`),
14  KEY `note_author_fk_idx` (`author_id`),
15  CONSTRAINT `note_author_fk` FOREIGN KEY (`author_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE
16) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
17
18DROP TABLE IF EXISTS `user`;
19
20
21CREATE TABLE `user` (
22  `id_user` int(11) NOT NULL AUTO_INCREMENT,
23  `name_user` varchar(45) NOT NULL,
24  PRIMARY KEY (`id_user`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;