添加dockerfile,修改torrent表结构,实现原文件名存储,修改post表结构,关联torrent_id
Change-Id: Ie82f559d859e378b5991eb90880e95a0ffcf775d
diff --git a/src/main/resources/data.sql b/src/main/resources/data.sql
index 607d353..a6860f1 100644
--- a/src/main/resources/data.sql
+++ b/src/main/resources/data.sql
@@ -1,11 +1,66 @@
-# # 后面统一数据库数据用
-#
-# # tags表父标签
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (1, '电影', NULL);
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (2, '游戏', NULL);
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (3, '音乐', NULL);
-#
-# # tags表子标签
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (4, '动作', 1);
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (5, '喜剧', 1);
-# INSERT INTO `tags` (tag_id, tag_name, parent_id) VALUES (6, '科幻', 1);
\ No newline at end of file
+-- Game 分类
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (0, 'Game', NULL);
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES
+ (1, 'android', 0),
+ (2, 'mac', 0),
+ (3, 'pc', 0),
+ (4, 'ios', 0),
+ (5, 'other', 0),
+ (6, 'action', 0),
+ (7, 'adventure', 0),
+ (8, 'leisure', 0),
+ (9, 'riddle', 0),
+ (10, 'sport', 0),
+ (11, 'strategy', 0),
+ (12, 'table', 0);
+
+-- video 分类
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (20, 'video', NULL);
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES
+ (21, 'chinese', 20),
+ (22, 'America', 20),
+ (23, 'Japan', 20),
+ (24, 'Korea', 20),
+ (25, 'Europe', 20),
+ (26, 'other', 20),
+ (27, 'Short', 20),
+ (28, 'plot', 20),
+ (29, 'comedy', 20),
+ (30, 'love', 20),
+ (31, 'action', 20),
+ (32, 'terror', 20),
+ (33, 'science fiction', 20),
+ (34, 'commit a crime', 20),
+ (35, 'Thriller', 20);
+
+-- music 分类
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (40, 'music', NULL);
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES
+ (41, 'chinese', 40),
+ (42, 'America', 40),
+ (43, 'Japan', 40),
+ (44, 'Korea', 40),
+ (45, 'Europe', 40),
+ (46, 'other', 40),
+ (47, 'rap', 40),
+ (48, 'Electric sound', 40),
+ (49, 'Guofeng', 40),
+ (50, 'motion', 40),
+ (51, 'ballad', 40),
+ (52, 'Rock and roll', 40),
+ (53, 'classical', 40);
+
+-- software 分类
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (60, 'software', NULL);
+INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES
+ (61, 'android', 60),
+ (62, 'mac', 60),
+ (63, 'pc', 60),
+ (64, 'ios', 60),
+ (65, 'other', 60),
+ (66, 'life', 60),
+ (67, 'shopping', 60),
+ (68, 'video', 60),
+ (69, 'music', 60),
+ (70, 'read', 60),
+ (71, 'system', 60);