forked from UlricQin/beego-blog
/
db.sql
41 lines (36 loc) · 1.46 KB
/
db.sql
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
create database beego_blog default character set utf8;
CREATE TABLE IF NOT EXISTS `bb_catalog` (
`id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
`ident` varchar(255) NOT NULL UNIQUE,
`name` varchar(255) NOT NULL,
`resume` varchar(255) NOT NULL,
`display_order` integer NOT NULL,
`img_url` varchar(255) NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE IF NOT EXISTS `bb_blog` (
`id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
`ident` varchar(255) NOT NULL UNIQUE,
`title` varchar(255) NOT NULL,
`keywords` varchar(255),
`catalog_id` bigint NOT NULL,
`blog_content_id` bigint NOT NULL UNIQUE,
`blog_content_last_update` bigint NOT NULL,
`type` tinyint NOT NULL,
`status` tinyint NOT NULL,
`views` bigint NOT NULL,
`created` datetime NOT NULL,
`snap_shot` varchar(2048)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE INDEX `bb_blog_catalog_id` ON `bb_blog` (`catalog_id`);
CREATE TABLE IF NOT EXISTS `bb_blog_content` (
`id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
`content` longtext NOT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
create table rss_feeder_t (
`id` bigint AUTO_INCREMENT NOT NULL PRIMARY KEY,
rss_desc varchar(1024),
`rss_url` varchar(1024) NOT NULL,
create_time timestamp not null default now(),
update_time timestamp,
subscribe_time timestamp
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;