-
Notifications
You must be signed in to change notification settings - Fork 12
/
Copy pathcreate_table.sql
120 lines (112 loc) · 3.66 KB
/
create_table.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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
DROP TABLE IF EXISTS job_detail;
CREATE TABLE `job_detail` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`url` text DEFAULT NULL,
`src_desc` char(100) DEFAULT NULL,
`type` int(4) DEFAULT NULL,
`catalog` char(50) DEFAULT NULL,
`title` text DEFAULT NULL,
`keywords` char(200) DEFAULT NULL,
`department` char(100) DEFAULT NULL,
`job_require` text DEFAULT NULL,
`job_duty` text DEFAULT NULL,
`job_welfare` text,
`label` char(100) DEFAULT NULL,
`company` char(100) DEFAULT NULL,
`company_desc` text,
`logo` char(100) DEFAULT NULL,
`salary` char(50) DEFAULT NULL,
`work_experience` char(20) DEFAULT NULL,
`edu` char(20) DEFAULT NULL,
`field` char(20) DEFAULT NULL,
`location` char(20) DEFAULT NULL,
`head_count` int(4) DEFAULT NULL,
`pub_time` datetime DEFAULT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `job_page_feature` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`job_id` int(4) NOT NULL,
`keywords` text NOT NULL,
`feature` text NOT NULL,
`pv` int(4) NOT NULL,
`click` int(4) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
CREATE TABLE `course_page_feature` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`course_id` int(4) NOT NULL,
`keywords` text NOT NULL,
`feature` text NOT NULL,
`pv` int(4) NOT NULL,
`click` int(4) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS course_detail;
CREATE TABLE `course_detail` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`title` char(200) NOT NULL,
`desc` text NOT NULL,
`play_url` char(200) NOT NULL,
`keywords` text NOT NULL,
`url` text NOT NULL,
`website` char(100) NOT NULL,
`img` char(100) DEFAULT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS book_detail;
CREATE TABLE `book_detail` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`title` char(200) NOT NULL,
`desc` text NOT NULL,
`url` char(200) NOT NULL,
`website` char(100) NOT NULL,
`img` char(100) DEFAULT NULL,
`prize` char(20) NOT NULL,
`orig_prize` char(20) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS link_detail;
CREATE TABLE `link_detail` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`title` char(200) NOT NULL,
`desc` text NOT NULL,
`keywords` text NOT NULL,
`url` text NOT NULL,
`website` char(100) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
CREATE TABLE `user_comments` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`page_id` int(4) NOT NULL,
`type` int(4) NOT NULL,
`uid` int(4) NOT NULL,
`avatar` char(200) NOT NULL,
`comment` text NOT NULL,
`user_profile_url` char(200) NOT NULL,
`pub_time` char(100) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS hot_job;
CREATE TABLE `hot_job` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`job_id` int(4) NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS recom_resource;
CREATE TABLE `recom_resource` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`job_id` int(4) NOT NULL,
`type` int(4) NOT NULL,
`res_ids` text NOT NULL,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;