定制化SQL

创建数据库SQL

CREATE DATABASE `longmao-system` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `longmao-tags` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `longmao-validate` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

管理员账号、权限、跨域、oss key

1000/qixccDeRHaQSpQmq（管理员账号）

INSERT INTO `system_longmao_user`(`uid`, `password`, `nick_name`, `created_time`, `modified_time`) VALUES (1000, '0597a5f56cc6dd327f1c647d8e1a2129', 'QURNSU4=', UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
INSERT INTO `system_v2_auth_user` (`uid`, `type`, `real_name`) VALUES (1000, 2, 'ADMIN');
INSERT INTO `system_v2_user_idcard` (`uid`, `real_name`, `id_card`, `staff_status`, `status`, `type`) VALUES (1000, 'ADMIN', '1', 1, 0, 0);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (109, 9, '1000', '1', 'ADMIN', 1, 2, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (482, 481, '用户账户', '/modules/system/user/index_of.html', '_self', NULL, 1, 1, 1000, 1, '_de_dd_br');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (587, 534, '任务流管理', 'old-/tags/project/index.html?offline=1', '_self', NULL, 1, 1, 115, 1, '_gb_eu_ad');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (724, 719, '项目管理', '/modules/validate/project/index_of.html', '_self', NULL, 1, 1, 1000, 1, '_k4_jz_jx');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (455, 341, '项目总览', '/modules/statistics/plan/project/offline.html', '_self', NULL, 1, 1, 1997, 1, '_cn_9h_9d');
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-login-c.caic.com:39000', 'https://anno-login-c.caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-manager-c.caic.com:39000', 'https://anno-manager-c.caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-task-c.caic.com:39000', 'https://anno-task-c.caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-validate-c.caic.com:39000', 'https://anno-validate-c.caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-manager-api-c.caic.com:39000', 'https://anno-manager-api-c.caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict` (`id`, `pid`, `ename`, `cname`, `leaf`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (447, 445, 'OSS', 'OSS', 1, NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3093, 447, 'endpoint', 'oss-cn-shenzhen-internal.aliyuncs.com', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3094, 447, 'access_key', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3095, 447, 'access_secret', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4539, 447, 'answer_upload_url', 'https://test.oss-accelerate.aliyuncs.com', '前端答案上传URL', 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4544, 447, 'answer_upload_bucket', 'test', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4553, 447, 'domain', '.oss-accelerate.aliyuncs.com', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3090, 446, 'endpoint', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3091, 446, 'access_id', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3092, 446, 'access_key', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (552, 'pay', 'false', '', 1, 1000, 1, 1, 1, 1);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (552, 'offline', 'true', '', 1, 1000, 1, 1, 1, 1);
INSERT INTO `validate_agreement` (`id`, `name`, `budget`, `pre_budget`, `revise_budget`, `accurate_amount`, `day`, `did`, `uid`, `leader`, `customer`, `TYPE`, `currency`, `executor`, `settle_str`, `archive`, `notes`, `main_agree`, `agree_id`, `agree_pid`, `real_budget`) VALUES (1, 'online', 0, NULL, NULL, 0, 20181025, -1, 5, '', '', -1, 'rmb', NULL, NULL, 1, NULL, NULL, NULL, NULL, 0);

附原始sql文件

INSERT INTO `system_longmao_user`(`uid`, `password`, `nick_name`, `created_time`, `modified_time`) VALUES (1000, '0597a5f56cc6dd327f1c647d8e1a2129', 'QURNSU4=', UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
INSERT INTO `system_v2_auth_user` (`uid`, `type`, `real_name`) VALUES (1000, 2, 'ADMIN');
INSERT INTO `system_v2_user_idcard` (`uid`, `real_name`, `id_card`, `staff_status`, `status`, `type`) VALUES (1000, 'ADMIN', '1', 1, 0, 0);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (109, 9, '1000', '1', 'ADMIN', 1, 2, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (482, 481, '用户账户', '/modules/system/user/index_of.html', '_self', NULL, 1, 1, 1000, 1, '_de_dd_br');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (587, 534, '任务流管理', 'old-/tags/project/index.html?offline=1', '_self', NULL, 1, 1, 115, 1, '_gb_eu_ad');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (724, 719, '项目管理', '/modules/validate/project/index_of.html', '_self', NULL, 1, 1, 1000, 1, '_k4_jz_jx');
INSERT INTO `system_v2_menu` (`id`, `pid`, `name`, `url`, `target`, `icon`, `status`, `leaf`, `order`, `type`, `path`) VALUES (455, 341, '项目总览', '/modules/statistics/plan/project/offline.html', '_self', NULL, 1, 1, 1997, 1, '_cn_9h_9d');
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-login-c.t3caic.com:39000', 'https://anno-login-c.t3caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-manager-c.t3caic.com:39000', 'https://anno-manager-c.t3caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-task-c.t3caic.com:39000', 'https://anno-task-c.t3caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-validate-c.t3caic.com:39000', 'https://anno-validate-c.t3caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (373, 'https://anno-manager-api-c.t3caic.com:39000', 'https://anno-manager-api-c.t3caic.com:39000', NULL, 1, 1006, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict` (`id`, `pid`, `ename`, `cname`, `leaf`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (447, 445, 'OSS', 'OSS', 1, NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3093, 447, 'endpoint', 'oss-cn-shenzhen-internal.aliyuncs.com', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3094, 447, 'access_key', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3095, 447, 'access_secret', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4539, 447, 'answer_upload_url', 'https://test.oss-accelerate.aliyuncs.com', '前端答案上传URL', 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4544, 447, 'answer_upload_bucket', 'test', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (4553, 447, 'domain', '.oss-accelerate.aliyuncs.com', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3090, 446, 'endpoint', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3091, 446, 'access_id', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`id`, `did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (3092, 446, 'access_key', '1', NULL, 1, 1000, UNIX_TIMESTAMP(), 1000, UNIX_TIMESTAMP(), 1000);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (552, 'pay', 'false', '', 1, 1000, 1, 1, 1, 1);
INSERT INTO `system_dict_node` (`did`, `code`, `value`, `remark`, `status`, `order`, `ctime`, `cuser`, `utime`, `uuser`) VALUES (552, 'offline', 'true', '', 1, 1000, 1, 1, 1, 1);