python3-webapp/schema.sql at master · Bambilu/python3-webapp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
--schema.sql

drop database if exists awesome;

create database awesome;

use awesome;

grant select,insert,update,delete on awesome.* to'www-data'@'localhost'identified by'www-data'

create table user(
`id` varchar(50)not null,
'email' varchar(50)not null,
'passwd' varchar(50)not null,
'admin' varchar(50)not null,
'name' varchar(50)not null,
'image' varchar(500)not null,
'created_at' real not null,
unique key 'idx_email'(`email`),
key `idx_created_at`(`created_at`),
primary key(`id`)
)engine=innodb default charset=utf8;

create table blogs(
'id' varchar(50)not null,
'user_id' varchar(50)not null,
'user_name' varchar(50)not null,
'user_image' varchar(500)not null,
'name' varchar(50)not null,
'summary' varchar(200)not null,
'content' mediumtext not null,
'created_at' real not null,
key `idx_created_at`(`created_at`),
primary key(`id`)
)engine=innodb default charset=utf8;

create table comments(
'id' varchar(50)not null,
'blog_id' varchar(50)not null,
'user_id' varchar(50)not null,
'user_name' varchar(50)not null,
'user_image' varchar(500)not null,
'content' mediumtext not null,
'created_at' real not null,
key `idx_created_at`(`created_at`),
primary key(`id`)
)engine=innodb default charset=utf8;