This week we will work with 2 tables:
- A
users
table similar to week 1 but now with an addedtoken
column. - A
snippets
table containing (code) snippets that belong to a user.
Create a new database/schema hyf_node_week2
containing the following tables:
CREATE TABLE `users` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`confirmed_at` datetime DEFAULT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`token` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email_UNIQUE` (`email`),
UNIQUE KEY `token_UNIQUE` (`token`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
CREATE TABLE `snippets` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` int unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`contents` text NOT NULL,
`is_private` tinyint NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `id_idx` (`user_id`),
CONSTRAINT `id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;