src/main/resources/data.sql

-- 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);