magic-emerge Goto Github PK

-- 初始化超级管理员
INSERT INTO public.sys_user (username, auth_password, wechat, avatar_url, phone_number, user_role, is_deleted, email,
                             is_active)
VALUES ('admin', 'xBDZ8qiR1aP24rkFBo4ncw==', '', '', 'xxxxx', 'SUPER_ADMIN', false, '[email protected]', true);

-- manager_id 必须是超级用户的id
INSERT INTO public.workspace (id, name, is_valid, remark, create_by, create_at, update_by, update_at, is_deleted,
                              is_public, manager_id)
VALUES (1, 'Magic Emerge''s 默认空间', true, '默认空间', '', false, false, '1673979417059454978');

-- user_id 必须是超级用户的id
INSERT INTO public.workspace_members (id, workspace_id, username, user_id, user_type, create_by, update_by, is_deleted,
                                      is_active)
VALUES (1, 1, 'admin', '1673979417059454978', 'OWNER', '', '', false, true);


-- 增加应用类型

INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (1, '客服', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (2, '电商', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (3, '角色扮演', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (5, '法律', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (6, '家装/工业设计', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (4, '小工具', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (8, 'UI设计', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (7, '法律法规', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (9, '政策解读', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (10, '经济财报', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (11, 'QA问答', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (12, '代码助手', true);
INSERT INTO public.app_category (id, category_name, is_valid)
VALUES (13, '教育', true);