-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinit-databases-simple.sql
More file actions
188 lines (182 loc) · 12.7 KB
/
init-databases-simple.sql
File metadata and controls
188 lines (182 loc) · 12.7 KB
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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
-- 简化版海牙平台数据库初始化脚本
-- 用于创建所有服务的数据库和基本表结构
-- 创建所有服务数据库
CREATE DATABASE IF NOT EXISTS haiya_user CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_video CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_comment CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_like CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_follow CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_gateway CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_registry CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_message CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_live CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_recommend CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_search CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_payment CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_ecommerce CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_ad CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_ad_analytics CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_analytics CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_ar_vr CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_article CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_audio CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_bi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_camera CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_campaign CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_cart CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_content_security CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_copyright CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_creator_tools CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_dashboard CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_data_collector CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_data_warehouse CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_database_sharding CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_distributed_transaction CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_editor CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_effect CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_feature_engineering CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_gift CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_group CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_im CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_live_interaction CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_localization CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_logistics CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_media_processing CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_mesh CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_minor_protection CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_ml_platform CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_moderation CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_notification CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_order CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_product CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_qanda CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_real_time_processing CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_storage CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_story CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_supply_chain CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_topic CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_transcoder CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_translation CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS haiya_virtual_tryon CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- 创建用户并授权
CREATE USER IF NOT EXISTS 'haiya'@'%' IDENTIFIED BY 'haiya123';
CREATE USER IF NOT EXISTS 'haiya'@'localhost' IDENTIFIED BY 'haiya123';
-- 授权用户访问所有相关数据库
GRANT ALL PRIVILEGES ON haiya_user.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_video.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_comment.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_like.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_follow.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_gateway.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_registry.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_message.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_live.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_recommend.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_search.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_payment.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_ecommerce.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_ad.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_ad_analytics.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_analytics.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_ar_vr.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_article.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_audio.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_bi.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_camera.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_campaign.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_cart.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_content_security.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_copyright.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_creator_tools.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_dashboard.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_data_collector.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_data_warehouse.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_database_sharding.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_distributed_transaction.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_editor.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_effect.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_feature_engineering.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_gift.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_group.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_im.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_live_interaction.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_localization.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_logistics.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_media_processing.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_mesh.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_minor_protection.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_ml_platform.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_moderation.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_notification.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_order.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_product.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_qanda.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_real_time_processing.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_storage.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_story.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_supply_chain.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_topic.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_transcoder.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_translation.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_virtual_tryon.* TO 'haiya'@'%';
GRANT ALL PRIVILEGES ON haiya_user.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_video.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_comment.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_like.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_follow.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_gateway.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_registry.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_message.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_live.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_recommend.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_search.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_payment.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_ecommerce.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_ad.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_ad_analytics.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_analytics.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_ar_vr.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_article.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_audio.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_bi.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_camera.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_campaign.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_cart.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_content_security.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_copyright.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_creator_tools.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_dashboard.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_data_collector.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_data_warehouse.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_database_sharding.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_distributed_transaction.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_editor.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_effect.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_feature_engineering.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_gift.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_group.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_im.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_live_interaction.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_localization.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_logistics.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_media_processing.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_mesh.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_minor_protection.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_ml_platform.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_moderation.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_notification.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_order.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_product.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_qanda.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_real_time_processing.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_storage.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_story.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_supply_chain.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_topic.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_transcoder.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_translation.* TO 'haiya'@'localhost';
GRANT ALL PRIVILEGES ON haiya_virtual_tryon.* TO 'haiya'@'localhost';
-- 刷新权限
FLUSH PRIVILEGES;
-- 显示创建的数据库
SHOW DATABASES LIKE 'haiya_%';