uc_init_data.sql 3.65 KB

-- ----------------------------
-- Records of uc_demension
-- ----------------------------
INSERT INTO UC_DEMENSION(ID_, DEM_NAME_, CODE_, IS_DEFAULT_, DEM_DESC_, ORGAN_ID_, IS_DELE_, VERSION_, UPDATE_TIME_, CREATE_BY_, CREATE_TIME_, CREATE_ORG_ID_, UPDATE_BY_, TENANT_ID_) VALUES ('1258608622670319616', '行政维度', 'xzwd', 1, '', '0', '0', NULL, NULL, '1', NULL, '', '1', '-1');
-- ----------------------------
-- Records of uc_org_job
-- ----------------------------
INSERT INTO UC_ORG_JOB(ID_, NAME_, CODE_, JOB_LEVEL_, DESCRIPTION_, UPDATE_TIME_, IS_DELE_, VERSION_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, TENANT_ID_) VALUES ('1258608888039739392', '职员', 'zy', NULL, '', NULL, '0', NULL, '1', '', NULL, NULL, '-1');

-- ----------------------------
-- Records of uc_role
-- ----------------------------
INSERT INTO UC_ROLE(ID_, NAME_, CODE_, ENABLED_, DESCRIPTION_, UPDATE_TIME_, IS_DELE_, VERSION_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, TENANT_ID_) VALUES ('61120', '系统管理员', 'xtgly', '1', null, null, '0', '1', '1', null, null, '-1');
INSERT INTO UC_ROLE(ID_, NAME_, CODE_, ENABLED_, DESCRIPTION_, UPDATE_TIME_, IS_DELE_, VERSION_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, TENANT_ID_) VALUES ('1258644408874700800', '人事管理员', 'rsgly', 1, NULL, NULL, '0', NULL, '1', NULL, '', NULL, '-1');
INSERT INTO UC_ROLE(ID_, NAME_, CODE_, ENABLED_, DESCRIPTION_, UPDATE_TIME_, IS_DELE_, VERSION_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, TENANT_ID_) VALUES ('1258644453707616256', '流程管理员', 'lcgly', 1, NULL, NULL, '0', NULL, '1', NULL, '', NULL, '-1');
INSERT INTO UC_ROLE(ID_, NAME_, CODE_, ENABLED_, DESCRIPTION_, UPDATE_TIME_, IS_DELE_, VERSION_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, TENANT_ID_) VALUES ('1258644481708789760', '一般用户', 'ybyh', 1, NULL, NULL, '0', NULL, '1', NULL, '', NULL, '-1');

-- ----------------------------
-- Records of uc_user
-- ----------------------------
INSERT INTO UC_USER(ID_, FULLNAME_, ACCOUNT_, PASSWORD_, EMAIL_, MOBILE_, WEIXIN_, CREATE_TIME_, ADDRESS_, PHOTO_, SEX_, FROM_, STATUS_, HAS_SYNC_TO_WX_, NOTIFY_TYPE_, USER_NUMBER_, ID_CARD_, PHONE_, BIRTHDAY_, ENTRY_DATE_, LEAVE_DATE_, EDUCATION_, UPDATE_TIME_, IS_DELE_, VERSION_, TENANT_ID_) VALUES ('1', '超级管理员', 'admin', 'jZae727K08KaOmKSgOaGzww/XVqGr/PKEgIMkjrcbJI=', '', '18888888888', null, null, '', null, '', 'system', '1', '1', null, '1', '', '', null, null, null, '', null, '0', '30', '-1');
INSERT INTO UC_TENANT_TYPE (ID_, NAME_, CODE_, STATUS_, IS_DEFAULT_, DESC_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_TIME_, UPDATE_BY_) VALUES ('1', '平台租户', 'platform', 'enable', '1', '平台租户', NULL, NULL, NULL, NULL, NULL);
INSERT INTO UC_TENANT_MANAGE (ID_, TYPE_ID_, NAME_, CODE_, STATUS_, SHORTHAND_, DOMAIN_, MANAGE_LOGO_, FRONT_LOGO_, ICO_, DESC_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_TIME_, IS_DELE_, UPDATE_BY_) VALUES ('-1', '1', '宏天企业信息平台', 'platform', 'enable', '', '', '', '', '', '', NULL, NULL, NULL, NULL, '0', '1');


INSERT INTO UC_PWD_STRATEGY(ID_, INIT_PWD_, PWD_RULE_, PWD_LENGTH_, DURATION_, ENABLE_, TENANT_ID_) VALUES ('1', '123456', 1, 6, 7, 0, '-1');

INSERT INTO UC_USER(ID_, FULLNAME_, ACCOUNT_, PASSWORD_, EMAIL_, MOBILE_, WEIXIN_, CREATE_TIME_, ADDRESS_, PHOTO_, SEX_, FROM_, STATUS_, HAS_SYNC_TO_WX_, NOTIFY_TYPE_, USER_NUMBER_, ID_CARD_, PHONE_, BIRTHDAY_, ENTRY_DATE_, LEAVE_DATE_, EDUCATION_, UPDATE_TIME_, IS_DELE_, VERSION_, TENANT_ID_) VALUES ('-1', '游客账号', 'guest', 'jZae727K08KaOmKSgOaGzww/XVqGr/PKEgIMkjrcbJI=', '', '18888888888', null, null, '', null, '', 'system', '1', '1', null, '1', '', '', null, null, null, '', null, '0', '30', '-1');