yuanchengpasc/application/common/versionsql/sql.2

INSERT INTO `bodypart` (`id`, `name`, `exam_class_id`)
VALUES
	('1', '头颅', 'c8ee6b63d4e73871'),
	('10', '腰椎', 'c8ee6b63d4e73871'),
	('11', '四肢骨关节', 'c8ee6b63d4e73871'),
	('12', '鼻窦', 'c8ee6b63d4e73871'),
	('13', '胸腰椎', 'c8ee6b63d4e73871'),
	('14', '盆骨', 'c8ee6b63d4e73871'),
	('15', '四肢关节', 'c8ee6b63d4e73871'),
	('16', '头颅', 'cfe527f085e4a377'),
	('17', '胸部', 'cfe527f085e4a377'),
	('18', '腰椎', 'cfe527f085e4a377'),
	('19', '四肢骨关节', 'cfe527f085e4a377'),
	('2', '胸部', 'c8ee6b63d4e73871'),
	('20', '鼻窦', 'cfe527f085e4a377'),
	('21', '腹部', 'cfe527f085e4a377'),
	('22', '胸部', '2'),
	('23', '颈椎', '2'),
	('24', '胸腰椎', '2'),
	('25', '盆骨', '2'),
	('26', '四肢关节', '2'),
	('27', '颈椎', '5ad1eb430bf536d0'),
	('28', '胸部', '5ad1eb430bf536d0'),
	('29', '胸腰椎', '5ad1eb430bf536d0'),
	('3', '腹部', 'c8ee6b63d4e73871'),
	('30', '腹部', '5ad1eb430bf536d0'),
	('31', '盆骨', '5ad1eb430bf536d0'),
	('32', '四肢关节', '5ad1eb430bf536d0'),
	('4', '泌尿', 'c8ee6b63d4e73871'),
	('5', '五官颈部', 'c8ee6b63d4e73871'),
	('6', '骨关节', 'c8ee6b63d4e73871'),
	('7', '盆腔', 'cfe527f085e4a377'),
	('8', '颈椎', 'cfe527f085e4a377'),
	('9', '胸椎', 'cfe527f085e4a377');
INSERT INTO `exam_project` (`id`, `name`, `exam_class_id`, `status`)
VALUES
	('04607647bcd5e4b3', '123123', '1', '0'),
	('1', '五官颈部', '2', '1'),
	('10', '胸部', '1', '0'),
	('11', '腰椎', '1', '0'),
	('12', '腹部', '1', '0'),
	('13', '颈椎', '1', '0'),
	('14', '骨关节', '1', '0'),
	('15', '鼻窦', '1', '0'),
	('16', '2222', '2', '0'),
	('1fbc79513610bd79', '123123', '1', '0'),
	('2', '四肢关节', '1', '0'),
	('3', '四肢骨关节', '1', '0'),
	('4', '头颅', '1', '0'),
	('4706269d2c9c7391', '123123', '1', '0'),
	('5', '泌尿', '1', '0'),
	('5712eec3b43a8166', '333', '1', '0'),
	('6', '盆腔', '1', '0'),
	('6c6799a7c7c1e20a', '44444', '1', '0'),
	('7', '盆骨', '1', '0'),
	('8', '胸椎', '1', '0'),
	('9', '胸腰椎', '1', '0'),
	('a99fbe50ff75cc47', '123455555', '1', '0');
INSERT INTO `exam_subclass` (`id`, `name`, `exam_class_id`)
VALUES
	('700bae6ac9efcefc', 'CR平片', '5ad1eb430bf536d0'),
	('e5fec1f1074b5dcb', 'CR造影片', '2');
INSERT INTO `menu` (`id`, `name`, `status`, `parent_id`, `url`, `ordernum`, `icon_name`)
VALUES
	('64022a6a4b32abae', '本地系统', NULL, 'root', '', 1010, NULL),
	('814dc08e8183952d', '远程系统', NULL, 'root', '', 1020, NULL),
	('80ddb7d09ebc44b4', '科室报告', NULL, '64022a6a4b32abae', '/sectionreport/sectionreport', 1013, 'chart'),
	('0eac42ef01de23ff', '登记列表', NULL, '64022a6a4b32abae', '/application/application', 1012, 'list'),
	('0aa9d7b2fdf7268e', '工作列表', NULL, '814dc08e8183952d', '/remotereport/index', 1025, 'list');
INSERT INTO `sys_menus` (`id`, `pid`, `name`, `url`, `ordernum`, `target`)
VALUES
	('07442f916c1d9a63', 'ad02fab359b91ebb', '配置-数据字典', '/manage/constant/index', 9089, NULL),
	('0b48638f82818130', 'ad02fab359b91ebb', '每日上传统计数量', '/manage/studiesnums/index', 10001, NULL),
	('0fd462a79d0f267c', 'ad02fab359b91ebb', '机构管理', '/manage/institution/index', 9001, NULL),
	('15c7c3306f9846d7', 'ad02fab359b91ebb', '配置-检查类别项目', '/manage/examProject/index', 9084, NULL),
	('186a2bea923f7a5a', 'ad02fab359b91ebb', '医生信息管理', '/manage/doctors/index', 9010, NULL),
	('3b381700e023407f', 'root', '医院信息管理', '22', 2000, NULL),
	('5b4b01c75308756f', 'ffa1ef3bbd49529f', '合作机构统计', '/manage/stats/insstat', 3020, NULL),
	('5b4b01c753087asd', 'ffa1ef3bbd49529f', '数据统计信息', '/manage/counts/index', 3020, ''),
	('5cc92a58584fea1d', 'ad02fab359b91ebb', '统计-代理', '', 9103, NULL),
	('665dec1b9645000c', 'ad02fab359b91ebb', '患者信息管理', '/manage/patientInfo/index', 9050, NULL),
	('66d2c37d572f4592', 'ad02fab359b91ebb', '配置-检查类别子类', '/manage/examsubclass/index', 9083, NULL),
	('68e78adba43efaf8', 'ad02fab359b91ebb', '统计-医生', '', 9100, NULL),
	('6e956175c1fe5325', 'ad02fab359b91ebb', '菜单配置', '/manage/sysmenu/index', 9998, NULL),
	('867bbab88ac64a51', 'ad02fab359b91ebb', '检查信息管理', '/manage/exam/index', 9030, NULL),
	('8e2a171b1f37f308', 'ad02fab359b91ebb', '配置-查检类别', '/manage/examclass/index', 9082, NULL),
	('995defb30bac9f03', 'ad02fab359b91ebb', '管理员管理', '/manage/manager/index', 9997, NULL),
	('ad02fab359b91ebb', 'root', '后台配置', '', 9000, NULL),
	('afe7db2716908158', '3b381700e023407f', '医院医生管理', '/manage/insdoctors/index', 2010, NULL),
	('b9f0e881525bc1e9', 'ad02fab359b91ebb', '系统日志', '/manage/syslog/index', 9999, NULL),
	('c17cac89e28a3f60', 'ad02fab359b91ebb', '诊断模版管理', '/manage/template/index', 9011, NULL),
	('c8c33f6bea1e1b74', 'ffa1ef3bbd49529f', '合作整体统计', '/manage/stats/index', 3010, NULL),
	('ce5413b40457d096', 'ad02fab359b91ebb', '数据统计信息', '/manage/counts/index', 10000, NULL),
	('d2f4f8aeeedd7dfc', 'ad02fab359b91ebb', '配置-前端菜单管理', '/manage/frontmenu/index', 9081, NULL),
	('eed548fd10c592ff', '3b381700e023407f', '医院数据统计', '/manage/insdoctors/stats', 2011, NULL),
	('f4513b798b2a3e6d', 'ad02fab359b91ebb', '统计-医院', '', 9102, NULL),
	('f4c11ace1a11e682', 'ad02fab359b91ebb', '消息通知管理', '/manage/messages/index', 9012, NULL),
	('ffa1ef3bbd49529f', 'root', '合作伙伴', '', 3000, NULL);
INSERT INTO `version` (`id`, `version`)
VALUES
	(1, '2');
INSERT INTO `manager` (`id`, `role_id`, `username`, `password`, `email`, `phone`, `logintime`, `loginip`, `loginfailure`, `createdAt`, `updatedAt`, `institution_id`, `status`)
VALUES
	('og11yjl51e7b3l4q', '0', 'admin', 'admin', '0', '13651111111', '2019-07-04 17:58:36', '121.69.81.74', 0, '2018-08-16 15:06:12', '2018-08-20 15:32:13', '', 1);