MAS 模块化应用支撑平台 ​

-- 注意将5.12.x替换为实际的版本号
 
insert into cos_portal_app_version(c_app_code,c_app_version) values('mas-explorer','5.12.x');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'mas-explorer-5.12.x.tgz');
insert into cos_app_publish_log(c_app_code,c_app_version) values('mas-explorer','5.12.x');
insert into cos_site_component_grant(c_tenant_id,c_site_id,c_app_code) values(1,1,'mas-explorer');
insert into cos_portal_component_grant(c_tenant_id,c_app_code) values(1,'mas-explorer');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('mas-explorer','5.12.x','PC端explorer',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'mas-explorer');

insert into cos_portal_app_version(c_app_code,c_app_version) values('user-password-login','5.12.x');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'user-password-login-5.12.x.tgz');
insert into cos_app_publish_log(c_app_code,c_app_version) values('user-password-login','5.12.x');
insert into cos_site_component_grant(c_tenant_id,c_site_id,c_app_code) values(1,1,'user-password-login');
insert into cos_portal_component_grant(c_tenant_id,c_app_code) values(1,'user-password-login');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('user-password-login','5.12.x','用户名密码登录APP',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'user-password-login');

-- 如需要调整管理平台站点页面名称请修改c_title字段对应的值（初始化默认值为：中科天翔系统管理平台）
-- 如需要调整平台管理员账号请修改c_contact字段对应的值（初始化默认值为：whzk）,需对应修改cos_admin_account_info表里的c_login_name字段和密码值，见下一说明
INSERT INTO "cos_admin_site_info"("c_id", "c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_site_type", "c_title", "c_theme", "c_logo", "c_code", "c_name", "c_contact", "c_mobile", "c_email", "c_activate_time", "c_invalid_time", "c_site_domain", "c_inited", "c_tenant_id", "c_site_setting", "c_tenant_code", "c_app_key", "c_app_secret", "c_manage_sites") VALUES (1, 1, NULL, 1, NULL, 1, 0, '中科天翔系统管理平台', '', '', 'sys', '系统站点', 'whzk', '', '', NULL, NULL, '[]', NULL, 1, '{"systemName":"中科天翔系统管理平台","logo":"","theme":"maui-explorer.default","shortName":"管理平台","loginImage":""}', 'sys', NULL, NULL, NULL);

-- 如需要调整平台管理员账号请修改c_login_name字段对应的值（初始化默认值为：whzk），如调整还需对应调整c_password字段值
-- 平台管理员账号初始化脚本密码加密方式为：bcrypt，如将平台部署成国密加密方式（sm3），需调整c_password字段值为sm3的密文
INSERT INTO "cos_admin_account_info"("c_id", "c_granted_apis", "c_account_expired", "c_account_locked", "c_credentials_expired", "c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_tenant_id", "c_login_name", "c_login_dingding", "c_login_phone", "c_login_email", "c_status", "c_password_policy", "c_password", "c_mobile_device", "c_allow_mobile_access", "c_last_login_time", "c_last_login_client_ip", "c_last_login_failed", "c_default_tenant", "c_account_source", "c_account_type", "c_full_name", "c_tag", "c_theme", "c_avatar", "c_account_uuid") VALUES (1, '/**', '0', '0', '0', 1, now(), NULL, NULL, 1, 1, 'whzk', NULL, NULL, NULL, '1', NULL, '$2a$10$7B1jfrju3iOGFd8F5dfZzuCgReqJBqasvSPyO0oYtNCP3n2h69Q8C', NULL, NULL, NULL, NULL, NULL, 'sys', NULL, 0, '系统管理员', NULL, 'maui-explorer.default', '48f5333954584687b9fe5020404e90f6', '03cdec6f43014eba880b797bf8653e17');

INSERT INTO cos_basicdata_dictionary_item(c_site_id,c_tenant_id,c_dic_key,c_code,c_value,c_sort_number) VALUES (1,1, 'appCategory', '1','系统管理',1);

INSERT INTO cos_basicdata_dictionary_item(c_site_id,c_tenant_id,c_dic_key,c_code,c_value,c_sort_number) VALUES (1,1, 'appCategory', '2','低代码',2);

INSERT INTO cos_basicdata_dictionary_item(c_site_id,c_tenant_id,c_dic_key,c_code,c_value,c_sort_number) VALUES (1,1, 'appCategory', '3','主题应用',3);

INSERT INTO cos_basicdata_dictionary_item(c_site_id,c_tenant_id,c_dic_key,c_code,c_value,c_sort_number) VALUES (1,1, 'appCategory', '4','其他',4);

--调整c_app_version字段对应的值为实际的运维应用版本
insert into cos_portal_app_version(c_app_code,c_app_version) values('mas-ops-app','5.12.x');
insert into cos_portal_app_version(c_app_code,c_app_version) values('mas-ops-tenant','5.12.x');
insert into cos_portal_app_version(c_app_code,c_app_version) values('mas-ops-site','5.12.x');


--调整c_file_name字段对应的值为实际的运维应用版本应用文件名
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'mas-ops-app-5.12.x.tgz');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'mas-ops-tenant-5.12.x.tgz');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'mas-ops-site-5.12.x.tgz');


--调整c_app_version字段对应的值为实际的运维应用版本
insert into cos_app_publish_log(c_app_code,c_app_version) values('mas-ops-app','5.12.x');
insert into cos_app_publish_log(c_app_code,c_app_version) values('mas-ops-tenant','5.12.x');
insert into cos_app_publish_log(c_app_code,c_app_version) values('mas-ops-site','5.12.x');


--调整c_version字段对应的值为实际的运维应用版本
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('mas-ops-app','5.12.x','应用管理',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('mas-ops-tenant','5.12.x','租户管理',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('mas-ops-site','5.12.x','站点管理',0,0,'["app","page","print"]','2023-08-15 14:00:00');


--调整三个运维应用的分类关联
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'mas-ops-app');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'mmas-ops-tenant');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'mas-ops-site');

--必须将mas-explorer、user-password-login应用初始化并授权到平台管理站点，否则无法登录
insert into cos_portal_app_version(c_app_code,c_app_version) values('mas-explorer','5.12.x');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'mas-explorer-5.12.x.tgz');
insert into cos_app_publish_log(c_app_code,c_app_version) values('mas-explorer','5.12.x');
insert into cos_site_component_grant(c_tenant_id,c_site_id,c_app_code) values(1,1,'mas-explorer');
insert into cos_portal_component_grant(c_tenant_id,c_app_code) values(1,'mas-explorer');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('mas-explorer','5.12.x','PC端explorer',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'mas-explorer');

insert into cos_portal_app_version(c_app_code,c_app_version) values('user-password-login','5.12.x');
insert into cos_portal_import_record(c_tenant_id,c_result,c_file_name) values(1,0,'user-password-login-5.12.x.tgz');
insert into cos_app_publish_log(c_app_code,c_app_version) values('user-password-login','5.11.24');
insert into cos_site_component_grant(c_tenant_id,c_site_id,c_app_code) values(1,1,'user-password-login');
insert into cos_portal_component_grant(c_tenant_id,c_app_code) values(1,'user-password-login');
insert into cos_portal_component(c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('user-password-login','5.11.24','用户名密码登录APP',0,0,'["app","page","print"]','2023-08-15 14:00:00');
insert into t_app_catalog_mapping(c_catalog_id, c_app_code) values (1, 'user-password-login');