-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinstall.sql
155 lines (140 loc) · 11.5 KB
/
install.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
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
INSERT INTO tc_modules (module_id, display_name, version, enabled, config_page, component_directory,
security_class)
VALUES ('57d6df06-41b6-4b76-800c-e446eed1bbad', 'OAuth Authentication', '2.0', 1, null, null, null);
-- ----------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_site_map (page_id, module_id, parent_page_id, parent_page_module_id, category_id, url, mvc_url,
controller, action, display_name, page_small_icon, panelbar_icon, show_in_sidebar,
view_order, required_permissions, menu_required_permissions, page_manager,
page_search_provider, cache_name)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', null, null, null, '', '', 'OAuth', 'Login', 'Login',
'MenuIcons/Base/Info24x24.png', null, 0, null, null, null, null, null, '');
INSERT INTO tc_site_map (page_id, module_id, parent_page_id, parent_page_module_id, category_id, url, mvc_url,
controller, action, display_name, page_small_icon, panelbar_icon, show_in_sidebar,
view_order, required_permissions, menu_required_permissions, page_manager,
page_search_provider, cache_name)
VALUES (2, '57d6df06-41b6-4b76-800c-e446eed1bbad', null, null, null, '', '', 'OAuth', 'Callback', 'Login Callback',
'MenuIcons/Base/Info24x24.png', null, 0, null, null, null, null, null, '');
INSERT INTO tc_site_map (page_id, module_id, parent_page_id, parent_page_module_id, category_id, url, mvc_url,
controller, action, display_name, page_small_icon, panelbar_icon, show_in_sidebar,
view_order, required_permissions, menu_required_permissions, page_manager,
page_search_provider, cache_name)
VALUES (3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 40, '07405876-e8c2-4b24-a774-4ef57f596384', 1, '/OAuth/Edit',
'/OAuth/Edit', 'OAuth', 'Edit', 'OAuth Settings', 'MenuIcons/Base/ServerComponents24x24.png',
'MenuIcons/Base/ServerComponents16x16.png', 1, 1000, '({07405876-e8c2-4b24-a774-4ef57f596384,0,8})
({57d6df06-41b6-4b76-800c-e446eed1bbad,1,0})
', '({07405876-e8c2-4b24-a774-4ef57f596384,0,8})
({57d6df06-41b6-4b76-800c-e446eed1bbad,1,0})
', null, null, '');
-- ---------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (4, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'Discord OAuth',
'Modify discord OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit?provider=Discord', null, 0,
null, 100, 1, null, null, null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'WHMCS OAuth',
'Modify whmcs OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit?provider=WHMCS', null, 0, null,
100, 1, null, null, null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (2, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'Google OAuth',
'Modify google OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit?provider=Google', null, 0,
null, 100, 1, null, null, null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'OAuth Information',
'Information about OAuth', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit', null, 0, null, 1, 1, null, null,
null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (5, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'Github OAuth',
'Modify github OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit?provider=Github', null, 0,
null, 100, 1, null, null, null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (6, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'Facebook OAuth',
'Modify facebook OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/Edit?provider=Facebook', null, 0,
null, 100, 1, null, null, null, null);
INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
description, icon, url, display_sql, user_type, selected_user_type, view_order,
enabled, icon_manager, is_postback, postback_class, new_page)
VALUES (7, '57d6df06-41b6-4b76-800c-e446eed1bbad', 3, 3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'OAuth Settings',
'Modify OAuth Settings', 'MenuIcons/Base/ServerNetwork.png', '/OAuth/OAuthSettings', null, 0, null, 2, 1, null,
null, null, null);
-- ---------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_panelbar_categories (category_id, module_id, display_name, view_order, parent_category_id,
parent_module_id, page_id, panelbar_icon)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'OAuth', 1002, 6, '07405876-e8c2-4b24-a774-4ef57f596384', null,
null);
-- ---------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_permission_categories (category_id, module_id, parent_category_id, parent_module_id, display_name,
view_order)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', null, null, 'OAuth Credentials', 1060);
-- ---------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_permissions (permission_id, module_id, category_id, display_name, permission_type, view_order,
role_owner_required_permissions, same_role_required_permissions, top_level_only)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', 1, 'Modify OAuth Credentials', 1, 1000, '', null, 1);
-- ---------------------------------------------------------------------------------------------------------------------
create table tcmodule_oauth_providers
(
id int auto_increment
primary key,
name text null,
typeName text null,
configurationModuleId varchar(36) not null,
configurationId int null,
app_data text null
);
INSERT INTO tcmodule_oauth_providers (id, name, typeName, configurationModuleId, configurationId, app_data)
VALUES (1, 'Google', 'TCAdminOAuth.Configurations.OAuths.GoogleOAuth, TCAdminOAuth',
'57d6df06-41b6-4b76-800c-e446eed1bbad', 1, '');
INSERT INTO tcmodule_oauth_providers (id, name, typeName, configurationModuleId, configurationId, app_data)
VALUES (2, 'Whmcs', 'TCAdminOAuth.Configurations.OAuths.WhmcsOAuth, TCAdminOAuth',
'57d6df06-41b6-4b76-800c-e446eed1bbad', 2, '');
INSERT INTO tcmodule_oauth_providers (id, name, typeName, configurationModuleId, configurationId, app_data)
VALUES (3, 'Discord', 'TCAdminOAuth.Configurations.OAuths.DiscordOAuth, TCAdminOAuth',
'57d6df06-41b6-4b76-800c-e446eed1bbad', 3, '');
INSERT INTO tcmodule_oauth_providers (id, name, typeName, configurationModuleId, configurationId, app_data)
VALUES (4, 'Github', 'TCAdminOAuth.Configurations.OAuths.GithubOAuth, TCAdminOAuth',
'57d6df06-41b6-4b76-800c-e446eed1bbad', 4, '');
INSERT INTO tcmodule_oauth_providers (id, name, typeName, configurationModuleId, configurationId, app_data)
VALUES (5, 'Facebook', 'TCAdminOAuth.Configurations.OAuths.FacebookOAuth, TCAdminOAuth',
'57d6df06-41b6-4b76-800c-e446eed1bbad', 5, '');
-- ---------------------------------------------------------------------------------------------------------------------
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (1, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'GoogleProviderConfiguration',
'TCAdminOAuth.Configurations.OAuthProviderConfiguration, TCAdminOAuth', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="AR_COMMON:ConfigurationView" value="Edit" type="System.String,mscorlib" />
</values>');
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (2, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'WhmcsProviderConfiguration',
'TCAdminOAuth.Configurations.WhmcsProviderConfiguration, TCAdminOAuth', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="AR_COMMON:ConfigurationView" value="EditWhmcs" type="System.String,mscorlib" />
</values>');
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (3, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'DiscordProviderConfiguration',
'TCAdminOAuth.Configurations.OAuthProviderConfiguration, TCAdminOAuth', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="AR_COMMON:ConfigurationView" value="Edit" type="System.String,mscorlib" />
</values>');
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (4, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'GithubProviderConfiguration',
'TCAdminOAuth.Configurations.OAuthProviderConfiguration, TCAdminOAuth', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="AR_COMMON:ConfigurationView" value="Edit" type="System.String,mscorlib" />
</values>');
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (5, '57d6df06-41b6-4b76-800c-e446eed1bbad', 'FacebookProviderConfiguration',
'TCAdminOAuth.Configurations.OAuthProviderConfiguration, TCAdminOAuth', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="AR_COMMON:ConfigurationView" value="Edit" type="System.String,mscorlib" />
</values>');