XAvUz5xj

1CREATE TABLE IF NOT EXISTS `sessions` (
2    `id` char(72),
3    `session_data` text,
4    PRIMARY KEY(`id`)
5) ENGINE=InnoDB DEFAULT CARACTER SET utf8;
6
7CREATE TABLE IF NOT EXISTS event (
8    `id` int unsigned auto_increment,
9    `name` varchar(64),
10    `url` text,
11    `event_time` bigint(20) unsigned not null,
12    `created_time` bigint(20) unsigned,
13    PRIMARY KEY (`id`)
14) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
15
16CREATE TABLE IF NOT EXISTS `circle` (
17    `id` int unsigned auto_increment,
18    `name` varchar(64),
19    `url` text,
20    `created_time` bigint(20) unsigned,
21    `updated_time` bigint(20) unsigned,
22    PRIMARY KEY (`id`)
23) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
24
25CREATE TABLE IF NOT EXISTS `event_circle` (
26    `id` int unsigned auto_increment,
27    `circle_id` int unsigned not null,
28    `event_id` int unsigned not null,
29    `url` text,
30    `priority_id` tinyint default 127,
31    `space` varchar(32),
32    `memo` text,
33    `created_time` bigint(20) unsigned,
34    `updated_time` bigint(20) unsigned,
35    PRIMARY KEY (`id`),
36    UNIQUE (`circle_id`, `event_id`)
37) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
38
39CREATE TABLE IF NOT EXISTS `comment` (
40    `comment_id`  INT UNSIGNED AUTO_INCREMENT,
41    `event_id`    INT UNSIGNED,
42    `user_id`     INT UNSIGNED,
43    `body`        TEXT,
44    `created_time` BIGINT(20) DEFAULT 0,
45    `updated_time` BIGINT(20) DEFAULT 0,
46    `deleted_time` BIGINT(20),
47    PRIMARY KEY (`comment_id`)
48) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
49 
50CREATE TABLE IF NOT EXISTS `item` (
51    `id` int unsigned auto_increment,
52    `name` varchar(64),
53    `price` int default 0,
54    `num` int default 0,
55    `bought_num` int default null,
56    `memo` text,
57    `circle_id` int unsigned,
58    `event_id` int unsigned,
59    `created_time` bigint(20) unsigned,
60    `updated_time` bigint(20) unsigned,
61    `deleted_time` bigint(20),
62    PRIMARY KEY (`id`)
63) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
64
65CREATE TABLE IF NOT EXISTS `plan` (
66    `id` int unsigned auto_increment,
67    `name` varchar(32),
68    `circle_id` int unsigned,
69    `event_id` int unsigned,
70    `priority_id` tinyint,
71    `created_time` bigint(20) unsigned,
72    `updated_time` bigint(20) unsigned,
73    PRIMARY KEY (`id`),
74    UNIQUE (`plan`, `circle_id`, `event_id`)
75) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
76
77CREATE TABLE IF NOT EXISTS `priority` (
78    `id` int unsigned auto_increment,
79    `name` varchar(32),
80    `created_time` bigint(20) unsigned,
81    `updated_time` bigint(20) unsigned,
82    PRIMARY KEY (`id`),
83    UNIQUE (`name`)
84) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
85
86CREATE TABLE IF NOT EXISTS `user` (
87    `id` int unsigned auto_increment,
88    `nickname` varchar(32),
89    `password` text not null,
90    `create_user_id` INT UNSIGNED,
91    PRIMARY KEY (`id`),
92    UNIQUE (`nickname`)
93) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
94
95CREATE TABLE IF NOT EXISTS `history` (
96    `id` int unsigned auto_increment,
97    `title` varchar(64),
98    `body` text not null,
99    PRIMARY KEY (`id`)
100) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;