v7buvKgW

1DROP TABLE IF EXISTS `person`;
2DROP TABLE IF EXISTS `friendship`;
3DROP TABLE IF EXISTS `team`;
4DROP TABLE IF EXISTS `membership`;
5
6CREATE TABLE `person` (
7	`id` int NOT NULL AUTO_INCREMENT,
8	`name` varchar(255) NOT NULL,
9	`birthday` DATE NOT NULL,
10	`height` int NOT NULL,
11	`wears_glasses` tinyint(1) NOT NULL,
12	PRIMARY KEY (`id`)
13);
14
15CREATE TABLE `friendship` (
16	`id` int NOT NULL AUTO_INCREMENT,
17	`a_id` int NOT NULL,
18	`b_id` int NOT NULL,
19	`started_at` DATETIME NOT NULL,
20	`ended_at` DATETIME NOT NULL,
21	PRIMARY KEY (`id`)
22);
23
24CREATE TABLE `team` (
25	`id` int NOT NULL AUTO_INCREMENT,
26	`name` varchar(255) NOT NULL,
27	PRIMARY KEY (`id`)
28);
29
30CREATE TABLE `membership` (
31	`id` int NOT NULL AUTO_INCREMENT,
32	`team_id` int NOT NULL,
33	`person_id` int NOT NULL,
34	PRIMARY KEY (`id`)
35);