| wuchimedes | d2dda83 | 2025-05-13 17:50:46 +0800 | [diff] [blame] | 1 | -- Game 分类 |
| 2 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (0, 'Game', NULL); |
| 3 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES |
| 4 | (1, 'android', 0), |
| 5 | (2, 'mac', 0), |
| 6 | (3, 'pc', 0), |
| 7 | (4, 'ios', 0), |
| 8 | (5, 'other', 0), |
| 9 | (6, 'action', 0), |
| 10 | (7, 'adventure', 0), |
| 11 | (8, 'leisure', 0), |
| 12 | (9, 'riddle', 0), |
| 13 | (10, 'sport', 0), |
| 14 | (11, 'strategy', 0), |
| 15 | (12, 'table', 0); |
| 16 | |
| 17 | -- video 分类 |
| 18 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (20, 'video', NULL); |
| 19 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES |
| 20 | (21, 'chinese', 20), |
| 21 | (22, 'America', 20), |
| 22 | (23, 'Japan', 20), |
| 23 | (24, 'Korea', 20), |
| 24 | (25, 'Europe', 20), |
| 25 | (26, 'other', 20), |
| 26 | (27, 'Short', 20), |
| 27 | (28, 'plot', 20), |
| 28 | (29, 'comedy', 20), |
| 29 | (30, 'love', 20), |
| 30 | (31, 'action', 20), |
| 31 | (32, 'terror', 20), |
| 32 | (33, 'science fiction', 20), |
| 33 | (34, 'commit a crime', 20), |
| 34 | (35, 'Thriller', 20); |
| 35 | |
| 36 | -- music 分类 |
| 37 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (40, 'music', NULL); |
| 38 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES |
| 39 | (41, 'chinese', 40), |
| 40 | (42, 'America', 40), |
| 41 | (43, 'Japan', 40), |
| 42 | (44, 'Korea', 40), |
| 43 | (45, 'Europe', 40), |
| 44 | (46, 'other', 40), |
| 45 | (47, 'rap', 40), |
| 46 | (48, 'Electric sound', 40), |
| 47 | (49, 'Guofeng', 40), |
| 48 | (50, 'motion', 40), |
| 49 | (51, 'ballad', 40), |
| 50 | (52, 'Rock and roll', 40), |
| 51 | (53, 'classical', 40); |
| 52 | |
| 53 | -- software 分类 |
| 54 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES (60, 'software', NULL); |
| 55 | INSERT IGNORE INTO tags (tag_id, tag_name, parent_id) VALUES |
| 56 | (61, 'android', 60), |
| 57 | (62, 'mac', 60), |
| 58 | (63, 'pc', 60), |
| 59 | (64, 'ios', 60), |
| 60 | (65, 'other', 60), |
| 61 | (66, 'life', 60), |
| 62 | (67, 'shopping', 60), |
| 63 | (68, 'video', 60), |
| 64 | (69, 'music', 60), |
| 65 | (70, 'read', 60), |
| 66 | (71, 'system', 60); |