-
Notifications
You must be signed in to change notification settings - Fork 15
/
01_db_data.sql
94 lines (88 loc) · 5.44 KB
/
01_db_data.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
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40000 ALTER TABLE `server_strings` DISABLE KEYS */;
INSERT IGNORE INTO `server_strings` (`language`, `categoryPvE`, `categoryPvP`, `serverOffline`, `serverLow`, `serverMedium`, `serverHigh`, `crowdNo`, `crowdYes`, `popup`) VALUES
('en', 'PvE', 'PvP', 'Offline', 'Low', 'Medium', 'High', 'No', 'Yes', 'Unable to access the server at this time.'),
('ru', 'PvE', 'PvP', 'Отключен', 'Низко', 'Средне', 'Высоко', 'Нет', 'Да', 'В настоящее время невозможно войти на сервер.'),
('tw', 'PvE', 'PvP', '离线', '低的', '中间', '高的', '不', '是的', '此时无法访问服务器。');
/*!40000 ALTER TABLE `server_strings` ENABLE KEYS */;
/*!40000 ALTER TABLE `shop_categories` DISABLE KEYS */;
INSERT IGNORE INTO `shop_categories` (`id`, `sort`, `active`, `createdAt`, `updatedAt`) VALUES
(1, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(2, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(3, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(4, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(5, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(6, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(7, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(8, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(9, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(10, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(11, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(12, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(13, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(14, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(15, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(16, 0, 1, '2022-07-24 05:51:20', '2022-07-24 05:51:20'),
(17, 0, 1, '2022-07-29 23:33:57', '2022-07-29 23:33:57');
/*!40000 ALTER TABLE `shop_categories` ENABLE KEYS */;
/*!40000 ALTER TABLE `shop_category_strings` DISABLE KEYS */;
INSERT IGNORE INTO `shop_category_strings` (`id`, `language`, `categoryId`, `title`, `description`) VALUES
(1, 'en', 1, 'Costumes', NULL),
(2, 'en', 2, 'Swimsuits', NULL),
(3, 'en', 3, 'School Uniform', NULL),
(4, 'en', 4, 'Weapon Styles', NULL),
(5, 'en', 5, 'Head Accessories', NULL),
(6, 'en', 6, 'Face Accessories', NULL),
(7, 'en', 7, 'Back Accessories', NULL),
(8, 'en', 8, 'Footprints', NULL),
(9, 'en', 9, 'Underwear', NULL),
(10, 'en', 10, 'Mounts', NULL),
(11, 'en', 11, 'Flying Mounts', NULL),
(12, 'en', 12, 'Pets', NULL),
(13, 'en', 13, 'Companions', NULL),
(14, 'en', 14, 'Companion Costumes', NULL),
(15, 'en', 15, 'Skill Books', NULL),
(16, 'en', 16, 'Services', NULL),
(35, 'en', 17, 'Other', NULL),
(17, 'ru', 1, 'Костюмы', NULL),
(18, 'ru', 2, 'Купальники', NULL),
(19, 'ru', 3, 'Школьная форма', NULL),
(20, 'ru', 4, 'Стили оружия', NULL),
(21, 'ru', 5, 'Аксессуары (голова)', NULL),
(22, 'ru', 6, 'Аксессуары (лицо)', NULL),
(23, 'ru', 7, 'Аксессуары (спина)', NULL),
(24, 'ru', 8, 'Следы', NULL),
(25, 'ru', 9, 'Белье', NULL),
(26, 'ru', 10, 'Маунты', NULL),
(27, 'ru', 11, 'Летающие маунты', NULL),
(28, 'ru', 12, 'Питомцы', NULL),
(29, 'ru', 13, 'Питомцы-помощники', NULL),
(30, 'ru', 14, 'Стили помощников', NULL),
(31, 'ru', 15, 'Книги умений', NULL),
(32, 'ru', 16, 'Сервисы', NULL),
(36, 'ru', 17, 'Другое', NULL);
/*!40000 ALTER TABLE `shop_category_strings` ENABLE KEYS */;
/*!40000 ALTER TABLE `shop_promocodes` DISABLE KEYS */;
INSERT IGNORE INTO `shop_promocodes` (`promoCodeId`, `promoCode`, `function`, `validAfter`, `validBefore`, `active`, `createdAt`, `updatedAt`) VALUES
(1, 'FREE-70-LVLUP', 'add_item_70_scroll', '2022-06-01 23:06:00', '2025-06-20 23:06:00', 1, '2022-06-20 23:10:40', '2022-07-01 07:38:12'),
(2, 'FREE-100-COINS', 'fund_100_coins', '2022-06-01 00:52:13', '2025-06-22 00:52:21', 1, '2022-06-22 00:52:25', '2022-06-22 00:56:50'),
(3, 'FREE-VIP-30DAY', 'add_benefit_vip_30', '2022-06-01 01:06:00', '2025-06-22 01:06:00', 1, '2022-06-22 01:40:27', '2022-07-01 06:30:31');
/*!40000 ALTER TABLE `shop_promocodes` ENABLE KEYS */;
/*!40000 ALTER TABLE `shop_promocode_strings` DISABLE KEYS */;
INSERT IGNORE INTO `shop_promocode_strings` (`id`, `language`, `promoCodeId`, `description`) VALUES
(2, 'en', 1, 'Your free scroll for instant level 70.'),
(4, 'en', 2, '100 free coins to your TERA Shop balance.'),
(5, 'en', 3, 'Premium status activation for 30 days.'),
(1, 'ru', 1, 'Свиток перехода на 70 уровень.'),
(3, 'ru', 2, '100 бесплатных монет на ваш счет.'),
(6, 'ru', 3, 'Активация VIP-статуса на 30 дней.');
/*!40000 ALTER TABLE `shop_promocode_strings` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;