/* 组织表 */ INSERT INTO `t_organization` (`parent_to_id`, `org_name`, `description`, `enterprise_report_type`, `name_abbreviation`, `enterprise_address`, `country`, `province`, `city`, `postal_code`, `phone`) VALUES (0, '德派软件', NULL, 'CRO', 'dapchina', NULL, NULL, NULL, NULL, NULL, NULL); /* 部门表 */ INSERT INTO `sys_department` (`organization_id`, `name`, `parent_id`, `level`, `state`, `sort`, `remark`, `version`, `position`, `charge_name`, `phone`, `fax`, `email`, `country`, `identifying_code`, `create_time`, `update_time`) VALUES (1, '技术部', NULL, 1, 1, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-25 09:46:49', '2019-11-13 19:56:07'); /* 权限表 */ INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('系统管理', NULL, '/system/sys-user-list', 'system:management', 'el-icon-s-unfold', 1, 1, 1, 0, '1权限备注,可以查看所有用户信息', 0, '2019-10-26 11:12:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户管理', 1, '/system/sys-user-list', 'sys:user:management', 'el-icon-s-unfold', 1, 2, 1, 0, '100权限备注,可以查看所有用户信息', 0, '2019-10-26 11:15:48', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色管理', 1, '/system/sys-user-list', 'sys:role:management', 'el-icon-s-unfold', 1, 2, 1, 0, '200权限备注,可以查看所有用户信息', 0, '2019-10-26 11:15:48', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限管理', 1, '/system/sys-user-list', 'sys:permission:management', 'el-icon-s-unfold', 1, 2, 1, 0, '300权限备注,可以查看所有用户信息', 0, '2019-10-26 11:15:48', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门管理', 1, '/system/sys-user-list', 'sys:department:management', 'el-icon-s-unfold', 1, 2, 1, 0, '400权限备注,可以查看所有用户信息', 0, '2019-10-26 11:15:48', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('日志管理', 1, '', 'sys:log:manager', 'el-icon-s-custom', 1, 2, 1, 0, '4005权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户新增', 2, '/system/sys-user-list', 'sys:user:add', 'el-icon-s-custom', 2, 3, 1, 0, '1000权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户修改', 2, '/system/sys-user-list', 'sys:user:update', 'el-icon-s-custom', 2, 3, 1, 0, '1001权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户删除', 2, '/system/sys-user-list', 'sys:user:delete', 'el-icon-s-custom', 2, 3, 1, 0, '1002权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户详情', 2, '/system/sys-user-list', 'sys:user:info', 'el-icon-s-custom', 2, 3, 1, 0, '1003权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户分页列表', 2, '/system/sys-user-list', 'sys:user:page', 'el-icon-s-custom', 2, 3, 1, 0, '1004权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户修改密码', 2, '/system/sys-user-list', 'sys:user:update:password', 'el-icon-s-custom', 2, 3, 1, 0, '1005权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('用户修改头像', 2, '/system/sys-user-list', 'sys:user:update:head', 'el-icon-s-custom', 2, 3, 1, 0, '1006权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色新增', 3, '/system/sys-user-list', 'sys:role:add', 'el-icon-s-custom', 2, 3, 1, 0, '2000权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色修改', 3, '/system/sys-user-list', 'sys:role:update', 'el-icon-s-custom', 2, 3, 1, 0, '2001权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色删除', 3, '/system/sys-user-list', 'sys:role:delete', 'el-icon-s-custom', 2, 3, 1, 0, '2002权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色详情', 3, '/system/sys-user-list', 'sys:role:info', 'el-icon-s-custom', 2, 3, 1, 0, '2003权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色分页列表', 3, '/system/sys-user-list', 'sys:role:page', 'el-icon-s-custom', 2, 3, 1, 0, '2004权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色列表', 3, '/system/sys-user-list', 'sys:role:list', 'el-icon-s-custom', 2, 3, 1, 0, '2005权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('角色权限ID列表', 3, NULL, 'sys:permission:three-ids-by-role-id', 'el-icon-s-custom', 2, 3, 1, 0, '2006权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限新增', 4, '/system/sys-user-list', 'sys:permission:add', 'el-icon-s-custom', 2, 3, 1, 0, '3000权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限修改', 4, '/system/sys-user-list', 'sys:permission:update', 'el-icon-s-custom', 2, 3, 1, 0, '3001权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限删除', 4, '/system/sys-user-list', 'sys:permission:delete', 'el-icon-s-custom', 2, 3, 1, 0, '3002权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限详情', 4, '/system/sys-user-list', 'sys:permission:info', 'el-icon-s-custom', 2, 3, 1, 0, '3003权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限分页列表', 4, '/system/sys-user-list', 'sys:permission:page', 'el-icon-s-custom', 2, 3, 1, 0, '3004权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限所有列表', 4, '/system/sys-user-list', 'sys:permission:all:menu:list', 'el-icon-s-custom', 2, 3, 1, 0, '3005权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限所有树形列表', 4, '/system/sys-user-list', 'sys:permission:all:menu:tree', 'el-icon-s-custom', 2, 3, 1, 0, '3006权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限用户列表', 4, '/system/sys-user-list', 'sys:permission:menu:list', 'el-icon-s-custom', 2, 3, 1, 0, '3007权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限用户树形列表', 4, '/system/sys-user-list', 'sys:permission:menu:tree', 'el-icon-s-custom', 2, 3, 1, 0, '3008权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('权限用户代码列表', 4, '/system/sys-user-list', 'sys:permission:codes', 'el-icon-s-custom', 2, 3, 1, 0, '3009权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门新增', 5, '/system/sys-user-list', 'sys:department:add', 'el-icon-s-custom', 2, 3, 1, 0, '4000权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门修改', 5, '/system/sys-user-list', 'sys:department:update', 'el-icon-s-custom', 2, 3, 1, 0, '4001权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门删除', 5, '/system/sys-user-list', 'sys:department:delete', 'el-icon-s-custom', 2, 3, 1, 0, '4002权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门详情', 5, '/system/sys-user-list', 'sys:department:info', 'el-icon-s-custom', 2, 3, 1, 0, '4003权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门分页列表', 5, '/system/sys-user-list', 'sys:department:page', 'el-icon-s-custom', 2, 3, 1, 0, '4004权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门列表', 5, '/system/sys-user-list', 'sys:department:all:list', 'el-icon-s-custom', 2, 3, 1, 0, '4005权限备注,可以查看所有用户信息', 1, '2019-10-26 11:18:40', '2020-03-09 00:50:13', 0); INSERT INTO `sys_permission` (`name`, `parent_id`, `url`, `code`, `icon`, `type`, `level`, `state`, `sort`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES ('部门树形列表', 5, NULL, 'sys:department:all:tree', 'el-icon-s-custom', 2, 3, 1, 0, '4006权限备注,可以查看所有用户信息', 0, '2019-10-26 11:18:40', NULL, 0); /* 角色表 */ INSERT INTO `sys_role` (`organization_id`, `parent_id`, `name`, `code`, `type`, `state`, `remark`, `version`, `create_time`, `update_time`) VALUES (1, 0, '管理员', 'admin', NULL, 1, '管理员拥有所有权限', 0, '2019-10-25 09:47:21', NULL); /* 角色权限表 */ INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 2, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 3, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 4, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 5, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 6, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 7, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 8, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 9, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 10, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 11, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 12, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 13, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 14, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 15, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 16, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 17, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 18, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 19, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 20, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 21, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 22, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 23, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 24, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 25, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 26, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 27, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 28, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 29, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 30, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 31, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 32, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 33, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 34, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 35, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 36, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); INSERT INTO `sys_role_permission` (`role_id`, `permission_id`, `permission_type`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 37, 1, 1, NULL, 0, '2020-03-03 14:19:18', NULL, 0); /* 用户表 */ INSERT INTO `sys_user` (`organization_id`, `username`, `password`, `salt`, `nickname`, `english_name`, `job_number`, `address`, `phone`, `login_send_msg`, `gender`, `head`, `remark`, `email`, `last_login_time`, `login_count`, `first_cap`, `connect_type`, `open_id`, `state`, `deleted`, `version`, `create_time`, `update_time`) VALUES (1, 'admin', '11a254dab80d52bc4a347e030e54d861a9d2cdb2af2185a9ca4a7318e830d04d', '666', '管理员', NULL, NULL, NULL, '15888889900', 0, 1, 'http://localhost:8888/api/resource/201908201013068.png', 'Administrator Account', NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 1, '2020-02-26 00:00:00', '2019-10-27 23:32:29'); /* 用户部门表 */ INSERT INTO `sys_user_department` (`user_id`, `department_id`, `state`, `remark`, `version`, `create_time`, `update_time`) VALUES (1, 1, 1, NULL, 0, '2020-04-16 17:26:25', '2020-04-16 17:26:26'); /* 用户角色表 */ INSERT INTO `sys_user_role` (`user_id`, `role_id`, `state`, `remark`, `version`, `create_time`, `update_time`) VALUES (1, 1, 1, NULL, 0, '2020-04-16 17:26:01', '2020-04-16 17:26:02'); /* 剂型表 */ INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Absorbable coated sponge', '可吸收涂层海绵'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Aerosol', '气雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Anticoagulant and preservative solution for blood', '血液抗凝和防腐剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Bath additive', '沐浴添加剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Bladder irrigation', '膀胱冲洗剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Buccal film', '颊膜剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Buccal tablet', '含片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cachet', '扁囊剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Caplet', '小胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Capsule, hard', '硬胶囊(胶囊)'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Capsule, soft', '软胶囊(胶丸)'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Chewable capsule, soft', '可咀嚼软胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Chewable tablet', '咀嚼片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Chewable/dispersible tablet', '可咀嚼/分散片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Coated granules', '涂层颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Coated tablet', '包衣片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Collodion', '火棉胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Compressed lozenge', '压缩的锭剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for concentrate for solution for infusion', '输液溶液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for cutaneous solution', '皮肤用溶液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for cutaneous spray, emulsion', '皮肤喷雾乳剂浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for dispersion for infusion', '输液分散剂用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for emulsion for infusion', '输液乳用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for gargle', '含漱用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for intravesical solution', '膀胱内溶液浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for nebuliser solution', '雾化溶液浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for oral solution', '口服液浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for oral suspension', '口服混悬剂浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for oral/rectal solution', '口服/直肠溶液用浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for oromucosal solution', '口腔黏膜溶液浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for peritoneal dialysis solution', '腹膜透析用溶液浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for rectal solution', '直肠溶液剂用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for haemodialysis', '血液透析用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for infusion', '输液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for injection', '注射用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for injection/infusion', '注射/输注用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for intraocular irrigation', '眼内冲洗溶液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for intravesical use', '膀胱内用溶液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for solution for peritoneal dialysis', '腹膜透析液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for suspension for infusion', '输液用混悬剂用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate for suspension for injection', '注射混悬剂用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cream', '乳膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous and nasal ointment', '皮肤和鼻腔用软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous emulsion', '皮肤用乳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous foam', '泡沫剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous liquid', '皮肤用液体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous paste', '皮肤用糊剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous patch', '皮肤贴片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous powder', '皮肤用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous solution', '皮肤用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous solution/concentrate for oromucosal solution', '皮肤/口腔粘膜溶液用浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous sponge', '含药海棉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous spray, emulsion', '皮肤喷雾乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous spray, ointment', '皮肤喷雾软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous spray, powder', '皮肤用粉雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous spray, solution', '溶液型皮肤用喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous spray, suspension', '混悬剂型皮肤用喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous stick', '皮肤用棒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous suspension', '皮肤混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous/ear drops suspension', '皮肤用/滴耳用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous/nasal ointment', '皮肤/鼻腔软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous/oromucosal spray', '皮肤/口腔黏膜喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Cutaneous/oromucosal/oral solution', '皮肤/口腔粘膜/口腔用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental cement', '牙科粘合剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental emulsion', '牙科用乳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental gel', '牙胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental insert', '牙插入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental paste', '牙膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental powder', '牙粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental solution', '牙科用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental stick', '牙栓'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dental suspension', '牙科用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Denture lacquer', '义齿光洁剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersible tablet', '分散片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersible tablets for dose dispenser', '剂量分配分散片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersion', '分散体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersion for concentrate for dispersion for infusion', '输液用浓溶液分散体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersion for infusion', '输液用分散体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersion for injection', '注射用分散体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Dispersion for injection/infusion', '注射/输注用分散体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear cream', '耳乳膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear drops, emulsion', '滴耳乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear drops, powder for suspension', '滴耳液,粉剂于悬浮'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear drops, solution', '滴耳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear drops, suspension', '混悬剂型滴耳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear gel', '耳用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear ointment', '耳用软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear powder', '耳用散'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear spray, emulsion', '乳状液型耳用喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear spray, solution', '溶液型耳用喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear spray, suspension', '混悬剂型耳用喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear stick', '耳栓'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear tampon', '耳塞剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear wash, emulsion', '乳状液型洗耳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear wash, solution', '洗耳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/eye drops, solution', '溶液型滴耳液/滴眼液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/eye drops, suspension', '滴耳/滴眼混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/eye ointment', '耳用软膏剂/眼膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/eye/nasal drops, solution', '溶液型滴耳液/滴眼液/滴鼻液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/eye/nose drops, solution', '溶液型滴耳液/滴眼液/滴鼻液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear/nasal drops, suspension', '滴耳/滴鼻混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent buccal tablet', '泡腾口含片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent granules', '泡腾颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent granules for oral suspension', '口服混悬泡腾颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent powder', '泡腾散'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent tablet', '泡腾片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent vaginal tablet', '阴道泡腾片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion for emulsion for injection', '注射乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion for infusion', '乳状液型输液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion for injection', '乳状液型注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion for injection/infusion', '注射用/输液用乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion for suspension for injection', '注射用混悬乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endocervical gel', '宫颈凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endosinusial solution', '窦内溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endosinusial wash, suspension', '混悬剂型内窦洗剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, powder for solution', '支气管滴注液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, powder for suspension', '支气管滴注液混悬用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, solution', '支气管滴注液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, suspension', '混悬型支气管滴注液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Epilesional solution', '损伤面溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye cream', '眼用乳膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, emulsion', '乳状液型滴眼液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, powder for solution', '溶液型滴眼液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, powder for suspension', '混悬型滴眼液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, prolonged-release', '缓释滴眼液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, solution', '溶液型滴眼液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, solvent for reconstitution', '滴眼液配制溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, suspension', '混悬型滴眼液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye gel', '眼用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye lotion', '洗眼剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye lotion, solvent for reconstitution', '洗眼剂配制溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye ointment', '眼膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Film coated gastro-resistant tablet', '肠溶薄膜包衣片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Film-coated tablet', '薄膜包衣片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Frozen solution for sealant', '封闭剂用冷冻溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gargle', '含漱液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gargle, powder for solution', '含漱液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gargle, tablet for solution', '含漱液用片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gargle/mouthwash', '含漱液/漱口水'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gargle/nasal wash', '漱口液/洗鼻液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gas for dispersion for infusion', '气体分散型输液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gas for dispersion for injection', '气体分散型注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gas for dispersion for injection/infusion', '注射/输液用分散气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastroenteral emulsion', '胃肠用乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastroenteral solution', '胃肠用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastroenteral suspension', '胃肠用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant capsule, hard', '肠溶胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant capsule, soft', '肠溶胶丸'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant coated tablet', '肠溶片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant granules', '肠溶颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant granules for oral suspension', '肠溶口服干混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant prolonged-release tablet', '肠溶缓释片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gastro-resistant tablet', '肠溶片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gel', '凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gel for gel', '凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gel for injection', '注射用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gingival gel', '牙龈用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gingival paste', '牙龈用糊剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gingival solution', '牙龈用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules', '颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for oral and rectal suspension', '口腔和直肠混悬液用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for oral drops, solution', '溶液型口服滴剂用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for oral solution', '口服溶液用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for oral suspension', '口服混悬剂用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for oral/rectal suspension', '口腔和直肠混悬剂颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for rectal suspension', '直肠混悬颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for suspension for injection', '注射混悬颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for syrup', '糖浆用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules for vaginal solution', '阴道溶液用颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Hard capsule with gastro-resistant pellets', '含耐胃颗粒硬胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Herbal tea', '茶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implant', '植入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implantation chain', '植入链'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implantation matrix', '植入矩阵'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implantation paste', '植入膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implantation suspension', '植入混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Implantation tablet', '植入片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Impregnated dressing', '浸药敷料'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Impregnated pad', '药垫'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Impregnated plug', '浸渍插头'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation gas', '吸入气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation impregnated pad', '吸入浸渍垫'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation powder', '吸入粉雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation powder, hard capsule', '硬胶囊型吸入粉雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation powder, pre-dispensed', '预混型吸入粉雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation powder, tablet', '片剂型吸入粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation solution', '吸入溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, capsule', '胶囊型吸入蒸气'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, effervescent tablet', '泡腾片型吸入蒸气'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, emulsion', '乳剂型吸入蒸气'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, impregnated pad', '药垫型吸入蒸气'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, impregnated plug', '浸渍插头型吸入蒸气'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, liquid', '液体蒸气吸入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, ointment', '软膏剂型蒸气吸入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, powder', '粉剂型蒸气吸入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, solution', '溶液型蒸气吸入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Inhalation vapour, tablet', '片剂型蒸气吸入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Instant herbal tea', '速溶茶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intestinal gel', '肠凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intraocular instillation solution', '眼内滴注溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intraperitoneal solution', '腹腔内溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intrauterine delivery system', '子宫内给药系统'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intrauterine gel', '宫内凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intravaginal ring', '阴道环'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intravesical solution', '膀胱内溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intravesical solution/solution for injection', '膀胱内溶液/注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Intravesical suspension', '膀胱内混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Irrigation solution', '冲洗液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Kit for implant', '植入物套件'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Kit for radiopharmaceutical preparation', '放射性药品制备试剂盒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Laryngopharyngeal solution', '喉咽溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Laryngopharyngeal spray, solution', '喉咽喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Liquefied gas for dental use', '牙科用液化气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Living tissue equivalent', '活组织供体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Lozenge', '锭剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Matrix for implantation matrix', '植入矩阵基质'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated chewing-gum', '含药口香糖'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated nail lacquer', '含药指甲油'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated plaster', '药膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated sponge', '含药海绵'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated thread', '含药线'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicated vaginal tampon', '加药阴道塞'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicinal gas, compressed', '医用压缩气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicinal gas, cryogenic', '医用低温气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicinal gas, liquefied', '医用液化气体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicinal larvae', '医用幼虫'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Medicinal leech', '医用水蛭'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release capsule, hard', '控释胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release capsule, soft', '控释胶丸'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release film-coated tablet', '改性释放薄膜包衣片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release granules', '控释颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release granules for oral suspension', '控释口服混悬颗粒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Modified-release tablet', '控释片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Mouthwash', '漱口水'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Mouthwash, powder for solution', '漱口水用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Mouthwash, tablet for solution', '漱口水用片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Muco-adhesive buccal prolonged-release tablet', '粘性口腔缓释片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Muco-adhesive buccal tablet', '口腔黏膜贴片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nail solution', '指甲用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal cream', '鼻用乳膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal drops, emulsion', '乳状液型滴鼻剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal drops, powder for solution', '粉溶液型滴鼻液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal drops, solution', '溶液型滴鼻剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal drops, suspension', '混悬型滴鼻剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal gel', '鼻用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal ointment', '鼻用软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal powder', '鼻用散'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray and oromucosal solution', '鼻腔喷雾和口腔粘膜用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray, emulsion', '乳状液型鼻喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray, powder for solution', '粉溶液型鼻腔喷雾'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray, solution', '鼻腔喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray, solution/oromucosal solution', '鼻腔喷雾/口腔粘液溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal spray, suspension', '混悬型鼻喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal stick', '鼻用棒剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal wash', '洗鼻剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal/oromucosal solution', '鼻/口腔粘膜溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal/oromucosal spray, solution', '鼻/口腔粘膜喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nebuliser emulsion', '雾化乳液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nebuliser solution', '雾化液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nebuliser suspension', '雾化混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ointment', '软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ophthalmic insert', '眼内插入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ophthalmic strip', '眼科带'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, emulsion', '乳状液型口服滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, granules for solution', '溶液颗粒型口服滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, liquid', '液体型口服滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, powder for suspension', '口服滴剂,混悬剂用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, solution', '溶液型口服滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral drops, suspension', '口服混悬滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral emulsion', '口服乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral gel', '口服凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral gum', '口胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral herbal material', '口服草药材料'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral liquid', '口服液体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral lyophilisate', '口服冻干粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral paste', '口服糊剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral powder', '口服散剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral solution', '口服溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral solution/concentrate for nebuliser solution', '口服溶液/雾化溶液浓溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral suspension', '口服混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral/rectal solution', '口服/直肠溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oral/rectal suspension', '口服/直肠混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Orodispersible film', '口腔分散膜'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Orodispersible tablet', '口腔分散片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal capsule', '口腔用胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal cream', '口腔用乳膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal drops', '口腔用滴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal gel', '口腔用凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal ointment', '口腔黏膜软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal paste', '口腔用糊剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal patch', '口腔贴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal solution', '口腔用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal spray', '口腔粘膜喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal spray, emulsion', '口腔粘膜喷雾乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal spray, solution', '口腔粘膜喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal spray, suspension', '口腔粘膜喷雾混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal suspension', '口腔用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal/laryngopharyngeal solution', '口腔粘膜/喉咽溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal/laryngopharyngeal solution/spray', '口腔粘膜/喉咽用溶液/喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Oromucosal/laryngopharyngeal solution/spray, solution', '口腔粘膜/喉咽溶液/喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pastille', '锭剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Periodontal gel', '牙周胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Periodontal insert', '牙周插入剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Periodontal powder', '牙周粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pessary', '子宫托'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pill', '丸剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pillules', '丸'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Plaster for provocation test', '激发试验用硬膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pouch', '袋'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Poultice', '泥敷剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for bladder irrigation', '膀胱冲洗剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for dispersion for infusion', '输液分散浓溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for haemodialysis solution', '用于血液透析溶液的浓缩物粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for intravesical suspension', '膀胱内混悬浓溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for solution for haemodialysis', '血液透析浓溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for solution for infusion', '输液浓溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate for solution for injection/infusion', '输液/注射液浓溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for cutaneous solution', '皮肤溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for dental cement', '牙科水泥用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for dental gel', '牙胶用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for dental solution', '牙科溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for dispersion for infusion', '输液分散剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for dispersion for injection', '注射液分散剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for emulsion for injection', '注射乳剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for endocervical gel', '宫颈凝胶用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for endosinusial solution', '窦内溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for epilesional solution', '损伤面溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for gel', '凝胶用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for gingival gel', '牙龈凝胶用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for implantation matrix', '植入基质粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for implantation paste', '植入膏粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for implantation suspension', '植入混悬剂粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for intraocular instillation solution', '眼内滴注溶液粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for intravesical solution', '膀胱内溶液粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for intravesical solution/solution for injection', '膀胱内溶液/注射液粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for intravesical suspension', '膀胱内混悬剂粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for mouth wash', '漱口水用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for nebuliser solution', '雾化液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for nebuliser solution/solution for injection/infusion', '雾化器溶液/注射液/输液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for nebuliser suspension', '雾化混悬剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for oral solution', '口服溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for oral suspension', '口服混悬剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for oral/rectal suspension', '口服/直肠混悬液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for prolonged-release suspension for injection', '注射缓释混悬剂粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for rectal solution', '直肠溶液剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for rectal suspension', '直肠混悬剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for sealant', '封闭剂用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for infusion', '输液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for injection', '溶液型注射液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for injection or infusion', '注射或输液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for injection/infusion', '注射/输注溶液的粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for injection/skin-prick test', '注射溶液/皮肤针刺试验溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for intraocular irrigation', '眼内冲洗液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for intravesical use', '膀胱内使用溶液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for iontophoresis', '可溶盐离子导入溶液用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for nasal spray', '鼻喷雾剂用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution for skin-prick test', '皮肤针刺试验溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for solution/suspension for injection', '溶液用粉剂/注射用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for suspension for injection', '注射混悬剂制备用粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for syrup', '糖浆用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for vaginal solution', '阴道溶液粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pressurised inhalation, emulsion', '乳状液型吸入气雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pressurised inhalation, solution', '溶液型吸入气雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Pressurised inhalation, suspension', '混悬型吸入气雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release capsule, hard', '缓释胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release capsule, soft', '缓释胶丸'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release film-coated tablet', '缓释薄膜包衣片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release granules', '缓释颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release granules for oral suspension', '口服混悬剂的延长释放颗粒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release solution for injection', '缓释注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release suspension for injection', '注射缓释混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Prolonged-release tablet', '缓释片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Radionuclide generator', '放射性核素发生器'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Radiopharmaceutical precursor', '放射性药物前体'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Radiopharmaceutical precursor, solution', '放射性药物前体溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal capsule', '直肠胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal cream', '直肠乳膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal emulsion', '直肠乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal foam', '直肠泡沫剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal gel', '直肠凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal ointment', '直肠软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal solution', '直肠溶液剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal suspension', '直肠混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Rectal tampon', '直肠塞'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Scalp solution', '头皮用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Scrub', '擦洗'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sealant', '封闭剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sealant matrix', '封闭基质'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sealant powder', '封闭粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Shampoo', '洗发液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Soluble tablet', '可溶片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for blood fraction modification', '血液成分修改溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for cardioplegia', '心脏停搏溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for cardioplegia/organ preservation', '心脏停搏/器官保存溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for dental cement', '牙科粘合剂溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for haemodiafiltration', '血液透析过滤溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for haemodialysis', '血液透析液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for haemodialysis/haemofiltration', '血液透析/血液过滤溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for haemofiltration', '血液过滤溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for infusion', '输液溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for infusion and oral solution', '输液用溶液和口服液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for injection', '溶液型注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for injection/concentrate for solution for infusion', '注射用溶液/输液用溶液浓缩液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for injection/infusion', '注射/输液溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for injection/infusion/rectal use', '注射用/输液用/直肠用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for injection/skin-prick test', '注射/皮肤针刺试验用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for intraocular irrigation', '眼内冲洗溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for intraperitoneal use', '腹膜内用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for intravesical use', '膀胱内用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for iontophoresis', '离子电渗疗法用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for organ preservation', '器官保存液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for perfusion of organs', '器官灌注液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for peritoneal dialysis', '腹膜透析液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for provocation test', '激发试验溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for sealant', '封闭剂溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for skin-prick test', '针刺试验用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for skin-scratch test', '划痕试验用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for solution for infusion', '输液用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for solution for injection', '注射液溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for spray', '喷雾用溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solution for suspension for injection', '注射混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solvent for nasal use', '鼻腔用溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solvent for parenteral use', '胃肠外用溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solvent for solution for infusion', '输液用溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solvent for solution for intraocular irrigation', '眼内冲洗液用溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Solvent for...', '溶剂,于……'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Stomach irrigation', '洗胃剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual film', '舌下膜剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual powder', '舌下粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual spray', '舌下喷雾剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual spray, emulsion', '舌下喷雾乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual spray, solution', '舌下喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual spray, suspension', '舌下喷雾混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Sublingual tablet', '舌下片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suppository', '栓剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for emulsion for injection', '注射乳剂用混悬液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for infusion', '输液用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for injection', '混悬剂型注射液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for oral suspension', '口服混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for spray', '喷雾用混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension for suspension for injection', '注射混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Syrup', '糖浆'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet', '片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet for cutaneous solution', '皮肤溶液用片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet for oral suspension', '口服混悬剂用片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet for rectal solution', '直肠溶液剂用片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet for rectal suspension', '直肠混悬剂用片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet for vaginal solution', '阴道溶液剂用片'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet with sensor', '带传感器的片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Toothpaste', '牙膏'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal gel', '透皮凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal ointment', '透皮软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal patch', '透皮贴剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal solution', '透皮溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal spray, solution', '透皮喷雾溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Transdermal system', '透皮系统'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Urethral emulsion', '尿道乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Urethral gel', '尿道凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Urethral ointment', '尿道软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Urethral stick', '尿道棒'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal capsule, hard', '阴道硬胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal capsule, soft', '阴道软胶囊'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal cream', '阴道乳膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal delivery system', '阴道给药系统'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal emulsion', '阴道乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal foam', '阴道泡沫剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal gel', '阴道凝胶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal ointment', '阴道软膏剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal solution', '阴道溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal suspension', '阴道悬液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Vaginal tablet', '阴道片剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Wound stick', '创可贴'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and diluent for solution for infusion', '输液用溶液浓缩液和稀释液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for concentrate for solution for infusion', '输液浓溶液用浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for cutaneous solution', '外用溶液用浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for cutaneous use', '皮肤用浓缩液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for injection', '注射用浓缩液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for solution for infusion', '输液溶液用浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for solution for injection', '注射溶液浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for solution for injection/infusion', '注射/输液溶液用浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Concentrate and solvent for suspension for injection', '注射用混悬液浓溶液和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Ear drops, powder and solvent for suspension', '混悬液型滴耳液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Effervescent powder and powder for oral suspension', '口服混悬液用泡腾粉和粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Emulsion and suspension for emulsion for injection', '注射乳剂用混悬液和乳剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, powder and solvent for solution', '支气管滴注液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Endotracheopulmonary instillation, powder and solvent for suspension', '支气管滴注液用粉和混悬液溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, powder and solvent for solution', '滴眼液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Eye drops, powder and solvent for suspension', '混悬型滴眼液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Fibrin sealant-powder and solvent for fibrin sealant', '注射用/输注用分散体用气体与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Gas and solvent for dispersion for injection/infusion', '注射用/输注用分散体用气体与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules and solvent for oral suspension', '口服混悬液用颗粒和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Granules and solvent for suspension for injection', '混悬型注射液用颗粒和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Nasal drops, powder and solvent for solution', '鼻滴剂用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and gel for gel', '凝胶用粉和凝胶'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solution for dental cement', '牙粘固剂用粉和溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solution for solution for injection', '注射用粉和溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solution for suspension for injection', '混悬液型注射用粉和溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for concentrate for solution for infusion', '输液浓溶液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for cutaneous solution', '外用溶液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for dental gel', '牙胶用粉剂与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for dispersion for injection', '注射用分散体用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for emulsion for injection', '乳状液型用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for endocervical gel', '子宫颈凝胶用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for endosinusial solution', '窦内溶液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for epilesional solution', '损伤面上溶液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for gingival gel', '牙龈凝胶用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for implantation paste', '植入糊剂用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for intraocular instillation solution', '眼内滴注液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for intravesical solution', '膀胱内溶液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for intravesical suspension', '膀胱内混悬液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for nebuliser solution', '雾化液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for oral solution', '口服溶液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for oral suspension', '口服混悬液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for prolonged-release suspension for injection', '注射用缓释混悬液用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for sealant', '封闭剂用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for solution for infusion', '输液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for solution for injection', '溶液型注射液用粉剂与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for solution for injection/infusion', '注射/输注用溶液用粉剂与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for solution for injection/skin-prick test', '注射用粉剂和溶剂/皮肤点刺试验'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for suspension for injection', '混悬型注射液用粉与溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and solvent for syrup', '糖浆用粉和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder and suspension for suspension for injection', '混悬型注射用粉和混悬液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder for concentrate and solution for solution for infusion', '输液浓溶液和溶液用粉'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder, dispersion and solvent for concentrate for dispersion for infusion', '输液分散体浓溶液用粉、分散体和溶剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Powder, solvent and matrix for implantation matrix', '植入基质用粉剂、溶剂和基质'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension and effervescent granules for oral suspension', '口服混悬液用泡腾颗粒和混悬液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension and solution for spray', '喷雾用混悬液和溶液'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Suspension and solvent for suspension for injection', '注射用混悬液用溶剂和混悬剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet and powder for oral solution', '口服溶液用片和粉剂'); INSERT INTO T_Dosage_Form (english_name, chinese_name) VALUES ('Tablet and solvent for rectal suspension', '直肠混悬液用片和溶剂'); /* 国家表 */ INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AD', 'AND', '20', 'ISO 3166-2:AD', 'Andorra', '安道尔', '安道尔', '安道尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AE', 'ARE', '784', 'ISO 3166-2:AE', 'United Arab Emirates', '阿联酋', '阿联', '阿联酋', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AF', 'AFG', '4', 'ISO 3166-2:AF', 'Afghanistan', '阿富汗', '阿富汗', '阿富汗', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AG', 'ATG', '28', 'ISO 3166-2:AG', 'Antigua & Barbuda', '安提瓜和巴布达', '安提瓜和巴布达', '安提瓜和巴布达', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AI', 'AIA', '660', 'ISO 3166-2:AI', 'Anguilla', '安圭拉', '英属安圭拉', '安圭拉岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AL', 'ALB', '8', 'ISO 3166-2:AL', 'Albania', '阿尔巴尼亚', '阿尔巴尼亚', '阿尔巴尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AM', 'ARM', '51', 'ISO 3166-2:AM', 'Armenia', '亚美尼亚', '亚美尼亚', '亚美尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AO', 'AGO', '24', 'ISO 3166-2:AO', 'Angola', '安哥拉', '安哥拉', '安哥拉', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AQ', 'ATA', '10', 'ISO 3166-2:AQ', 'Antarctica', '南极洲', '南极洲', '南极洲', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AR', 'ARG', '32', 'ISO 3166-2:AR', 'Argentina', '阿根廷', '阿根廷', '阿根廷', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AS', 'ASM', '16', 'ISO 3166-2:AS', 'American Samoa', '美属萨摩亚', '美属萨摩亚', '美属萨摩亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AT', 'AUT', '40', 'ISO 3166-2:AT', 'Austria', '奥地利', '奥地利', '奥地利', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AU', 'AUS', '36', 'ISO 3166-2:AU', 'Australia', '澳大利亚', '澳洲', '澳洲', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AW', 'ABW', '533', 'ISO 3166-2:AW', 'Aruba', '阿鲁巴', '阿鲁巴', '阿鲁巴', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AX', 'ALA', '248', 'ISO 3166-2:AX', 'Åland Island', '奥兰群岛', '奥兰群岛', '亚兰群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('AZ', 'AZE', '31', 'ISO 3166-2:AZ', 'Azerbaijan', '阿塞拜疆', '阿塞拜疆', '阿塞拜疆', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BA', 'BIH', '70', 'ISO 3166-2:BA', 'Bosnia & Herzegovina', '波黑', '波黑', '波黑', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BB', 'BRB', '52', 'ISO 3166-2:BB', 'Barbados', '巴巴多斯', '巴巴多斯', '巴巴多斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BD', 'BGD', '50', 'ISO 3166-2:BD', 'Bangladesh', '孟加拉', '孟加拉', '孟加拉', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BE', 'BEL', '56', 'ISO 3166-2:BE', 'Belgium', '比利时', '比利时', '比利时', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BF', 'BFA', '854', 'ISO 3166-2:BF', 'Burkina', '布基纳法索', '布基纳法索', '布基纳法索', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BG', 'BGR', '100', 'ISO 3166-2:BG', 'Bulgaria', '保加利亚', '保加利亚', '保加利亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BH', 'BHR', '48', 'ISO 3166-2:BH', 'Bahrain', '巴林', '巴林', '巴林', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BI', 'BDI', '108', 'ISO 3166-2:BI', 'Burundi', '布隆迪', '布隆迪', '布隆迪', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BJ', 'BEN', '204', 'ISO 3166-2:BJ', 'Benin', '贝宁', '贝宁', '贝宁', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BL', 'BLM', '652', 'ISO 3166-2:BL', 'Saint Barthélemy', '圣巴泰勒米岛', '圣巴瑟米', '圣巴托洛缪岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BM', 'BMU', '60', 'ISO 3166-2:BM', 'Bermuda', '百慕大', '百慕大', '百慕大', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BN', 'BRN', '96', 'ISO 3166-2:BN', 'Brunei', '文莱', '文莱', '文莱', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BO', 'BOL', '68', 'ISO 3166-2:BO', 'Bolivia', '玻利维亚', '玻利维亚', '玻利维亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BQ', 'BES', '535', 'ISO 3166-2:BQ', 'Caribbean Netherlands', '荷兰加勒比区', '荷兰加勒比区', '荷兰加勒比区', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BR', 'BRA', '76', 'ISO 3166-2:BR', 'Brazil', '巴西', '巴西', '巴西', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BS', 'BHS', '44', 'ISO 3166-2:BS', 'The Bahamas', '巴哈马', '巴哈马', '巴哈马', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BT', 'BTN', '64', 'ISO 3166-2:BT', 'Bhutan', '不丹', '不丹', '不丹', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BV', 'BVT', '74', 'ISO 3166-2:BV', 'Bouvet Island', '布韦岛', '布威岛', '鲍威特岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BW', 'BWA', '72', 'ISO 3166-2:BW', 'Botswana', '博茨瓦纳', '博茨瓦纳', '博茨瓦纳', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BY', 'BLR', '112', 'ISO 3166-2:BY', 'Belarus', '白俄罗斯', '白俄罗斯', '白俄罗斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('BZ', 'BLZ', '84', 'ISO 3166-2:BZ', 'Belize', '伯利兹', '伯利兹', '伯利兹', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CA', 'CAN', '124', 'ISO 3166-2:CA', 'Canada', '加拿大', '加拿大', '加拿大', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CC', 'CCK', '166', 'ISO 3166-2:CC', 'Cocos (Keeling) Islands', '科科斯群岛', '可可斯群岛', '科科斯群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CF', 'CAF', '140', 'ISO 3166-2:CF', 'Central African Republic', '中非', '中非', '中非', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CH', 'CHE', '756', 'ISO 3166-2:CH', 'Switzerland', '瑞士', '瑞士', '瑞士', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CL', 'CHL', '152', 'ISO 3166-2:CL', 'Chile', '智利', '智利', '智利', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CM', 'CMR', '120', 'ISO 3166-2:CM', 'Cameroon', '喀麦隆', '喀麦隆', '喀麦隆', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CO', 'COL', '170', 'ISO 3166-2:CO', 'Colombia', '哥伦比亚', '哥伦比亚', '哥伦比亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CR', 'CRI', '188', 'ISO 3166-2:CR', 'Costa Rica', '哥斯达黎加', '哥斯达黎加', '哥斯达黎加', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CU', 'CUB', '192', 'ISO 3166-2:CU', 'Cuba', '古巴', '古巴', '古巴', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CV', 'CPV', '132', 'ISO 3166-2:CV', 'Cape Verde', '佛得角', '佛得角', '佛得角', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CX', 'CXR', '162', 'ISO 3166-2:CX', 'Christmas Island', '圣诞岛', '圣诞岛', '圣诞岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CY', 'CYP', '196', 'ISO 3166-2:CY', 'Cyprus', '塞浦路斯', '塞浦路斯', '塞浦路斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CZ', 'CZE', '203', 'ISO 3166-2:CZ', 'Czech Republic', '捷克', '捷克', '捷克', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DE', 'DEU', '276', 'ISO 3166-2:DE', 'Germany', '德国', '德国', '德国', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DJ', 'DJI', '262', 'ISO 3166-2:DJ', 'Djibouti', '吉布提', '吉布提', '吉布提', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DK', 'DNK', '208', 'ISO 3166-2:DK', 'Denmark', '丹麦', '丹麦', '丹麦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DM', 'DMA', '212', 'ISO 3166-2:DM', 'Dominica', '多米尼克', '多米尼克', '多米尼克', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DO', 'DOM', '214', 'ISO 3166-2:DO', 'Dominican Republic', '多米尼加', '多米尼加', '多米尼加', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('DZ', 'DZA', '12', 'ISO 3166-2:DZ', 'Algeria', '阿尔及利亚', '阿尔及利亚', '阿尔及利亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('EC', 'ECU', '218', 'ISO 3166-2:EC', 'Ecuador', '厄瓜多尔', '厄瓜多尔', '厄瓜多尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('EE', 'EST', '233', 'ISO 3166-2:EE', 'Estonia', '爱沙尼亚', '爱沙尼亚', '爱沙尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('EG', 'EGY', '818', 'ISO 3166-2:EG', 'Egypt', '埃及', '埃及', '埃及', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('EH', 'ESH', '732', 'ISO 3166-2:EH', 'Western Sahara', '西撒哈拉', '西撒哈拉', '西撒哈拉', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ER', 'ERI', '232', 'ISO 3166-2:ER', 'Eritrea', '厄立特里亚', '厄立垂亚', '厄立特里亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ES', 'ESP', '724', 'ISO 3166-2:ES', 'Spain', '西班牙', '西班牙', '西班牙', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FI', 'FIN', '246', 'ISO 3166-2:FI', 'Finland', '芬兰', '芬兰', '芬兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FJ', 'FJI', '242', 'ISO 3166-2:FJ', 'Fiji', '斐济群岛', '斐济', '斐济', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FK', 'FLK', '238', 'ISO 3166-2:FK', 'Falkland Islands', '马尔维纳斯群岛( 福克兰)', '福克兰群岛', '福克兰群岛( 马尔维纳斯)', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FM', 'FSM', '583', 'ISO 3166-2:FM', 'Federated States of Micronesia', '密克罗尼西亚联邦', '密克罗尼西亚联邦', '密克罗尼西亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FO', 'FRO', '234', 'ISO 3166-2:FO', 'Faroe Islands', '法罗群岛', '法罗群岛', '法罗群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('FR', 'FRA', '250', 'ISO 3166-2:FR', 'France', '法国', '法国', '法国', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GA', 'GAB', '266', 'ISO 3166-2:GA', 'Gabon', '加蓬', '加蓬', '加蓬', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GD', 'GRD', '308', 'ISO 3166-2:GD', 'Grenada', '格林纳达', '格林纳达', '格林纳达', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GE', 'GEO', '268', 'ISO 3166-2:GE', 'Georgia', '格鲁吉亚', '乔治亚', '格鲁吉亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GF', 'GUF', '254', 'ISO 3166-2:GF', 'French Guiana', '法属圭亚那', '法属圭亚那', '法属圭亚那', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GH', 'GHA', '288', 'ISO 3166-2:GH', 'Ghana', '加纳', '加纳', '加纳', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GI', 'GIB', '292', 'ISO 3166-2:GI', 'Gibraltar', '直布罗陀', '直布罗陀', '直布罗陀', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GL', 'GRL', '304', 'ISO 3166-2:GL', 'Greenland', '格陵兰', '格陵兰', '格陵兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GN', 'GIN', '324', 'ISO 3166-2:GN', 'Guinea', '几内亚', '几内亚', '几内亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GP', 'GLP', '312', 'ISO 3166-2:GP', 'Guadeloupe', '瓜德罗普', '瓜德鲁普岛', '瓜德鲁普岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GQ', 'GNQ', '226', 'ISO 3166-2:GQ', 'Equatorial Guinea', '赤道几内亚', '赤道几内亚', '赤道几内亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GR', 'GRC', '300', 'ISO 3166-2:GR', 'Greece', '希腊', '希腊', '希腊', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GS', 'SGS', '239', 'ISO 3166-2:GS', 'South Georgia and the South Sandwich Islands', '南乔治亚岛和南桑威奇群岛', '南乔治亚与南三明治群岛', '南乔治亚岛与南桑威奇群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GT', 'GTM', '320', 'ISO 3166-2:GT', 'Guatemala', '危地马拉', '危地马拉', '危地马拉', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GU', 'GUM', '316', 'ISO 3166-2:GU', 'Guam', '关岛', '关岛', '关岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GW', 'GNB', '624', 'ISO 3166-2:GW', 'Guinea-Bissau', '几内亚比绍', '几内亚比绍', '几内亚比绍', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GY', 'GUY', '328', 'ISO 3166-2:GY', 'Guyana', '圭亚那', '圭亚那', '圭亚那', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HK', 'HKG', '344', 'ISO 3166-2:HK', 'Hong Kong', '香港', '香港', '香港', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HM', 'HMD', '334', 'ISO 3166-2:HM', 'Heard Island and McDonald Islands', '赫德岛和麦克唐纳群岛', '赫德及麦当劳群岛', '赫德岛和麦克唐纳群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HN', 'HND', '340', 'ISO 3166-2:HN', 'Honduras', '洪都拉斯', '洪都拉斯', '洪都拉斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HR', 'HRV', '191', 'ISO 3166-2:HR', 'Croatia', '克罗地亚', '克罗地亚', '克罗地亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HT', 'HTI', '332', 'ISO 3166-2:HT', 'Haiti', '海地', '海地', '海地', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('HU', 'HUN', '348', 'ISO 3166-2:HU', 'Hungary', '匈牙利', '匈牙利', '匈牙利', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ID', 'IDN', '360', 'ISO 3166-2:ID', 'Indonesia', '印尼', '印尼', '印尼', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IE', 'IRL', '372', 'ISO 3166-2:IE', 'Ireland', '爱尔兰', '爱尔兰', '爱尔兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IL', 'ISR', '376', 'ISO 3166-2:IL', 'Israel', '以色列', '以色列', '以色列', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IM', 'IMN', '833', 'ISO 3166-2:IM', 'Isle of Man', '马恩岛', '马恩岛', '马恩岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IN', 'IND', '356', 'ISO 3166-2:IN', 'India', '印度', '印度', '印度', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IO', 'IOT', '86', 'ISO 3166-2:IO', 'British Indian Ocean Territory', '英属印度洋领地', '英属印度洋地区', '英属印度洋地区', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IQ', 'IRQ', '368', 'ISO 3166-2:IQ', 'Iraq', '伊拉克', '伊拉克', '伊拉克', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IR', 'IRN', '364', 'ISO 3166-2:IR', 'Iran', '伊朗', '伊朗', '伊朗', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IS', 'ISL', '352', 'ISO 3166-2:IS', 'Iceland', '冰岛', '冰岛', '冰岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('IT', 'ITA', '380', 'ISO 3166-2:IT', 'Italy', '意大利', '意大利', '意大利', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('JE', 'JEY', '832', 'ISO 3166-2:JE', 'Jersey', '泽西岛', '泽西岛', '泽西', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('JM', 'JAM', '388', 'ISO 3166-2:JM', 'Jamaica', '牙买加', '牙买加', '牙买加', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('JO', 'JOR', '400', 'ISO 3166-2:JO', 'Jordan', '约旦', '约旦', '约旦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('JP', 'JPN', '392', 'ISO 3166-2:JP', 'Japan', '日本', '日本', '日本', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KH', 'KHM', '116', 'ISO 3166-2:KH', 'Cambodia', '柬埔寨', '柬埔寨', '柬埔寨', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KI', 'KIR', '296', 'ISO 3166-2:KI', 'Kiribati', '基里巴斯', '基里巴斯', '基里巴斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KM', 'COM', '174', 'ISO 3166-2:KM', 'The Comoros', '科摩罗', '科摩罗', '科摩罗', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KW', 'KWT', '414', 'ISO 3166-2:KW', 'Kuwait', '科威特', '科威特', '科威特', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KY', 'CYM', '136', 'ISO 3166-2:KY', 'Cayman Islands', '开曼群岛', '开曼群岛', '开曼群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LB', 'LBN', '422', 'ISO 3166-2:LB', 'Lebanon', '黎巴嫩', '黎巴嫩', '黎巴嫩', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LI', 'LIE', '438', 'ISO 3166-2:LI', 'Liechtenstein', '列支敦士登', '列支敦士登', '列支敦士登', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LK', 'LKA', '144', 'ISO 3166-2:LK', 'Sri Lanka', '斯里兰卡', '斯里兰卡', '斯里兰卡', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LR', 'LBR', '430', 'ISO 3166-2:LR', 'Liberia', '利比里亚', '利比里亚', '利比里亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LS', 'LSO', '426', 'ISO 3166-2:LS', 'Lesotho', '莱索托', '莱索托', '莱索托', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LT', 'LTU', '440', 'ISO 3166-2:LT', 'Lithuania', '立陶宛', '立陶宛', '立陶宛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LU', 'LUX', '442', 'ISO 3166-2:LU', 'Luxembourg', '卢森堡', '卢森堡', '卢森堡', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LV', 'LVA', '428', 'ISO 3166-2:LV', 'Latvia', '拉脱维亚', '拉脱维亚', '拉脱维亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LY', 'LBY', '434', 'ISO 3166-2:LY', 'Libya', '利比亚', '利比亚', '利比亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MA', 'MAR', '504', 'ISO 3166-2:MA', 'Morocco', '摩洛哥', '摩洛哥', '摩洛哥', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MC', 'MCO', '492', 'ISO 3166-2:MC', 'Monaco', '摩纳哥', '摩纳哥', '摩纳哥', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MD', 'MDA', '498', 'ISO 3166-2:MD', 'Moldova', '摩尔多瓦', '摩尔多瓦', '摩尔多瓦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ME', 'MNE', '499', 'ISO 3166-2:ME', 'Montenegro', '黑山', '黑山', '黑山', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MF', 'MAF', '663', 'ISO 3166-2:MF', 'Saint Martin (France)', '法属圣马丁', '法属圣马丁 ', '法属圣马丁', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MG', 'MDG', '450', 'ISO 3166-2:MG', 'Madagascar', '马达加斯加', '马达加斯加', '马达加斯加', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MH', 'MHL', '584', 'ISO 3166-2:MH', 'Marshall islands', '马绍尔群岛', '马绍尔群岛', '马绍尔群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MK', 'MKD', '807', 'ISO 3166-2:MK', 'Republic of Macedonia (FYROM)', '马其顿', '马其顿', '马其顿', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ML', 'MLI', '466', 'ISO 3166-2:ML', 'Mali', '马里', '马利', '马里', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MM', 'MMR', '104', 'ISO 3166-2:MM', 'Myanmar (Burma)', '缅甸', '缅甸', '缅甸', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MO', 'MAC', '446', 'ISO 3166-2:MO', 'Macao', '澳门', '澳门', '澳门', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MQ', 'MTQ', '474', 'ISO 3166-2:MQ', 'Martinique', '马提尼克', '法属马丁尼克', '马提尼克', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MR', 'MRT', '478', 'ISO 3166-2:MR', 'Mauritania', '毛里塔尼亚', '毛里塔尼亚', '毛里塔尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MS', 'MSR', '500', 'ISO 3166-2:MS', 'Montserrat', '蒙塞拉特岛', '蒙塞拉特岛', '蒙塞拉特岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MT', 'MLT', '470', 'ISO 3166-2:MT', 'Malta', '马耳他', '马耳他', '马耳他', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MV', 'MDV', '462', 'ISO 3166-2:MV', 'Maldives', '马尔代夫', '马尔代夫', '马尔代夫', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MW', 'MWI', '454', 'ISO 3166-2:MW', 'Malawi', '马拉维', '马拉维', '马拉维', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MX', 'MEX', '484', 'ISO 3166-2:MX', 'Mexico', '墨西哥', '墨西哥', '墨西哥', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MY', 'MYS', '458', 'ISO 3166-2:MY', 'Malaysia', '马来西亚', '马来西亚', '马来西亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NA', 'NAM', '516', 'ISO 3166-2:NA', 'Namibia', '纳米比亚', '纳米比亚', '纳米比亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NE', 'NER', '562', 'ISO 3166-2:NE', 'Niger', '尼日尔', '尼日', '尼日尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NF', 'NFK', '574', 'ISO 3166-2:NF', 'Norfolk Island', '诺福克岛', '诺福克岛', '诺福克岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NG', 'NGA', '566', 'ISO 3166-2:NG', 'Nigeria', '尼日利亚', '尼日利亚', '尼日利亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NI', 'NIC', '558', 'ISO 3166-2:NI', 'Nicaragua', '尼加拉瓜', '尼加拉瓜', '尼加拉瓜', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NL', 'NLD', '528', 'ISO 3166-2:NL', 'Netherlands', '荷兰', '荷兰', '荷兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NO', 'NOR', '578', 'ISO 3166-2:NO', 'Norway', '挪威', '挪威', '挪威', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NP', 'NPL', '524', 'ISO 3166-2:NP', 'Nepal', '尼泊尔', '尼泊尔', '尼泊尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NR', 'NRU', '520', 'ISO 3166-2:NR', 'Nauru', '瑙鲁', '瑙鲁', '瑙鲁', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('OM', 'OMN', '512', 'ISO 3166-2:OM', 'Oman', '阿曼', '阿曼', '阿曼', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PA', 'PAN', '591', 'ISO 3166-2:PA', 'Panama', '巴拿马', '巴拿马', '巴拿马', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PE', 'PER', '604', 'ISO 3166-2:PE', 'Peru', '秘鲁', '秘鲁', '秘鲁', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PF', 'PYF', '258', 'ISO 3166-2:PF', 'French polynesia', '法属波利尼西亚', '法属波利尼西亚', '法属波利尼西亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PG', 'PNG', '598', 'ISO 3166-2:PG', 'Papua New Guinea', '巴布亚新几内亚', '巴布亚新几内亚', '巴布亚新几内亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PH', 'PHL', '608', 'ISO 3166-2:PH', 'The Philippines', '菲律宾', '菲律宾', '菲律宾', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PK', 'PAK', '586', 'ISO 3166-2:PK', 'Pakistan', '巴基斯坦', '巴基斯坦', '巴基斯坦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PL', 'POL', '616', 'ISO 3166-2:PL', 'Poland', '波兰', '波兰', '波兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PN', 'PCN', '612', 'ISO 3166-2:PN', 'Pitcairn Islands', '皮特凯恩群岛', '皮特康岛', '皮特凯恩群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PR', 'PRI', '630', 'ISO 3166-2:PR', 'Puerto Rico', '波多黎各', '波多黎各', '波多黎各', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PS', 'PSE', '275', 'ISO 3166-2:PS', 'Palestinian territories', '巴勒斯坦', '巴勒斯坦', '巴勒斯坦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PW', 'PLW', '585', 'ISO 3166-2:PW', 'Palau', '帕劳', '帕劳', '帕劳 帕劳', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PY', 'PRY', '600', 'ISO 3166-2:PY', 'Paraguay', '巴拉圭', '巴拉圭', '巴拉圭', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('QA', 'QAT', '634', 'ISO 3166-2:QA', 'Qatar', '卡塔尔', '卡达', '卡塔尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('RE', 'REU', '638', 'ISO 3166-2:RE', 'Réunion', '留尼汪', '留尼汪', '留尼汪', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('RO', 'ROU', '642', 'ISO 3166-2:RO', 'Romania', '罗马尼亚', '罗马尼亚', '罗马尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('RS', 'SRB', '688', 'ISO 3166-2:RS', 'Serbia', '塞尔维亚', '塞尔维亚', '塞尔维亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('RU', 'RUS', '643', 'ISO 3166-2:RU', 'Russian Federation', '俄罗斯', '俄罗斯', '俄罗斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('RW', 'RWA', '646', 'ISO 3166-2:RW', 'Rwanda', '卢旺达', '卢旺达', '卢旺达', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SB', 'SLB', '90', 'ISO 3166-2:SB', 'Solomon Islands', '所罗门群岛', '所罗门群岛', '所罗门群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SC', 'SYC', '690', 'ISO 3166-2:SC', 'Seychelles', '塞舌尔', '塞舌尔', '塞舌尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SD', 'SDN', '729', 'ISO 3166-2:SD', 'Sudan', '苏丹', '苏丹', '苏丹', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SE', 'SWE', '752', 'ISO 3166-2:SE', 'Sweden', '瑞典', '瑞典', '瑞典', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SG', 'SGP', '702', 'ISO 3166-2:SG', 'Singapore', '新加坡', '新加坡 星加坡', '新加坡 星加坡', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SI', 'SVN', '705', 'ISO 3166-2:SI', 'Slovenia', '斯洛文尼亚', '斯洛文尼亚', '斯洛文尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SJ', 'SJM', '744', 'ISO 3166-2:SJ', 'Template:Country data SJM Svalbard', '斯瓦尔巴群岛和 扬马延岛', '斯瓦巴及 尖棉岛', '斯瓦尔巴特群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SK', 'SVK', '703', 'ISO 3166-2:SK', 'Slovakia', '斯洛伐克', '斯洛伐克', '斯洛伐克', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SL', 'SLE', '694', 'ISO 3166-2:SL', 'Sierra Leone', '塞拉利昂', '狮子山', '塞拉利昂', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SM', 'SMR', '674', 'ISO 3166-2:SM', 'San Marino', '圣马力诺', '圣马力诺', '圣马力诺', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SN', 'SEN', '686', 'ISO 3166-2:SN', 'Senegal', '塞内加尔', '塞内加尔', '塞内加尔', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SO', 'SOM', '706', 'ISO 3166-2:SO', 'Somalia', '索马里', '索马里', '索马里', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SR', 'SUR', '740', 'ISO 3166-2:SR', 'Suriname', '苏里南', '苏里南', '苏里南', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SS', 'SSD', '728', 'ISO 3166-2:SS', 'South Sudan', '南苏丹', '南苏丹', '南苏丹', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ST', 'STP', '678', 'ISO 3166-2:ST', 'Sao Tome & Principe', '圣多美和普林西比', '圣多美普林西比', '圣多美及普林西比', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SV', 'SLV', '222', 'ISO 3166-2:SV', 'El Salvador', '萨尔瓦多', '萨尔瓦多', '萨尔瓦多', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SY', 'SYR', '760', 'ISO 3166-2:SY', 'Syria', '叙利亚', '叙利亚', '叙利亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SZ', 'SWZ', '748', 'ISO 3166-2:SZ', 'Swaziland', '斯威士兰', '斯威士兰', '斯威士兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TC', 'TCA', '796', 'ISO 3166-2:TC', 'Turks & Caicos Islands', '特克斯和凯科斯群岛', '土克斯及开科斯群岛', '特克斯和凯科斯群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TD', 'TCD', '148', 'ISO 3166-2:TD', 'Chad', '乍得', '查德', '乍得', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TG', 'TGO', '768', 'ISO 3166-2:TG', 'Togo', '多哥', '多哥', '多哥', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TH', 'THA', '764', 'ISO 3166-2:TH', 'Thailand', '泰国', '泰国', '泰国', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TK', 'TKL', '772', 'ISO 3166-2:TK', 'Tokelau', '托克劳', '托克劳群岛', '托克劳群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TL', 'TLS', '626', 'ISO 3166-2:TP', 'Timor-Leste (East Timor)', '东帝汶', '东帝汶', '东帝汶', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TN', 'TUN', '788', 'ISO 3166-2:TN', 'Tunisia', '突尼斯', '突尼斯', '突尼斯', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TO', 'TON', '776', 'ISO 3166-2:TO', 'Tonga', '汤加', '东加', '汤加', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TR', 'TUR', '792', 'ISO 3166-2:TR', 'Turkey', '土耳其', '土耳其', '土耳其', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TV', 'TUV', '798', 'ISO 3166-2:TV', 'Tuvalu', '图瓦卢', '吐瓦鲁', '图瓦卢', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TZ', 'TZA', '834', 'ISO 3166-2:TZ', 'Tanzania', '坦桑尼亚', '坦桑尼亚', '坦桑尼亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('UA', 'UKR', '804', 'ISO 3166-2:UA', 'Ukraine', '乌克兰', '乌克兰', '乌克兰', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('UG', 'UGA', '800', 'ISO 3166-2:UG', 'Uganda', '乌干达', '乌干达', '乌干达', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('US', 'USA', '840', 'ISO 3166-2:US', 'United States of America (USA)', '美国', '美国', '美国', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('UY', 'URY', '858', 'ISO 3166-2:UY', 'Uruguay', '乌拉圭', '乌拉圭', '乌拉圭', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VA', 'VAT', '336', 'ISO 3166-2:VA', 'Vatican City (The Holy See)', '梵蒂冈', '梵蒂冈', '梵蒂冈', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VE', 'VEN', '862', 'ISO 3166-2:VE', 'Venezuela', '委内瑞拉', '委内瑞拉', '委内瑞拉', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VG', 'VGB', '92', 'ISO 3166-2:VG', 'British Virgin Islands', '英属维尔京群岛', '英属维尔京群岛', '英属处女群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VI', 'VIR', '850', 'ISO 3166-2:VI', 'United States Virgin Islands', '美属维尔京群岛', '美属维尔京群岛', '美属处女群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VN', 'VNM', '704', 'ISO 3166-2:VN', 'Vietnam', '越南', '越南', '越南', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('WF', 'WLF', '876', 'ISO 3166-2:WF', 'Wallis and Futuna', '瓦利斯和富图纳', '沃里斯与伏塔那岛', '瓦利斯群岛和富图纳群岛', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('WS', 'WSM', '882', 'ISO 3166-2:WS', 'Samoa', '萨摩亚', '萨摩亚', '萨摩亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('YE', 'YEM', '887', 'ISO 3166-2:YE', 'Yemen', '也门', '也门', '也门', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('YT', 'MYT', '175', 'ISO 3166-2:YT', 'Mayotte', '马约特', '美亚特', '马约特', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ZA', 'ZAF', '710', 'ISO 3166-2:ZA', 'South Africa', '南非', '南非', '南非', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ZM', 'ZMB', '894', 'ISO 3166-2:ZM', 'Zambia', '赞比亚', '赞比亚', '赞比亚', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ZW', 'ZWE', '716', 'ISO 3166-2:ZW', 'Zimbabwe', '津巴布韦', '津巴布韦', '津巴布韦', ''); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CN', 'CHN', '156', 'ISO 3166-2:CN', 'China', '中国 内地', '大陆 中国', '大陆 内地', '“ GB/T 2659-2000”的“CN”适用于整个 中华人民共和国辖区(包括 中国大陆、 香港、 澳门)。而“ISO 3166-1”和“ CNS 12842”的“CN”则仅适用于中国大陆,不含 港澳地区。'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CG', 'COG', '178', 'ISO 3166-2:CG', 'Republic of the Congo', '刚果(布)', '刚果', '刚果', '中国大陆主要使用“刚果(布)”一词,意指“首都为 布拉柴维尔的 刚果(共和国)”,而“刚果”一词亦普遍为民间所用。'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CD', 'COD', '180', 'ISO 3166-2:CD', 'Democratic Republic of the Congo', '刚果(金)', '民主刚果', '民主刚果', '中国大陆主要使用“刚果(金)”一词,意指“首都为 金沙萨的 刚果(共和国)”,而“民主刚果”一词亦普遍为民间所用。'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MZ', 'MOZ', '508', 'ISO 3166-2:MZ', 'Mozambique', '莫桑比克', '莫桑比克', '莫桑比克', '中国大陆和 台湾均曾将之普遍译作“ 莫三比给”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GG', 'GGY', '831', 'ISO 3166-2:GG', 'Guernsey', '根西岛', '根息岛', '根西岛', '中国大陆曾将之普遍译作“ 格恩西岛”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GM', 'GMB', '270', 'ISO 3166-2:GM', 'Gambia', '冈比亚', '冈比亚', '冈比亚', '亦有部份人士使用“ 刚比亚”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MP', 'MNP', '580', 'ISO 3166-2:MP', 'Northern Mariana Islands', '北马里亚纳群岛', '北马里亚纳群岛', '北马里亚纳群岛', '亦有部份人士使用“ 北玛利安娜群岛”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('ET', 'ETH', '231', 'ISO 3166-2:ET', 'Ethiopia', '埃塞俄比亚', '埃塞俄比亚', '埃塞俄比亚', '亦有部份人士使用“ 埃塞俄比亚”一词于 台湾'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NC', 'NCL', '540', 'ISO 3166-2:NC', 'New Caledonia', '新喀里多尼亚', '新喀里多尼亚岛', '新喀里多尼亚', '亦有部份人士使用“ 新喀尔多尼亚”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VU', 'VUT', '548', 'ISO 3166-2:VU', 'Vanuatu', '瓦努阿图', '瓦努阿图', '瓦努阿图', '亦有部份人士使用“ 瓦努阿图”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TF', 'ATF', '260', 'ISO 3166-2:TF', 'French Southern Territories', '法属南部领地', '法属南部属地', '法属南部地区', '台湾亦普遍采用“ 法属南方及南极陆地”一词于其它场合(如 MSN台湾)'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NU', 'NIU', '570', 'ISO 3166-2:NU', 'Niue', '纽埃', '纽埃', '纽埃', '台湾亦普遍采用“ 纽威岛”( CNS 12842译名)一词于其它场合(如 MSN台湾)'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('UM', 'UMI', '581', 'ISO 3166-2:UM', 'United States Minor Outlying Islands', '美国本土外小岛屿', '美国边疆小岛', '美国海外小岛', '台湾亦普遍采用“ 美国外岛”一词于其它场合(如 MSN台湾)'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CK', 'COK', '184', 'ISO 3166-2:CK', 'Cook Islands', '库克群岛', '库克群岛', '库克群岛', '台湾和 香港亦普遍采用“ 科克群岛”( CNS 12842译名)一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('GB', 'GBR', '826', 'ISO 3166-2:GB', 'Great Britain (United Kingdom; England)', '英国', '英国', '英国', '台湾和 香港亦普遍采用“ 联合王国”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TT', 'TTO', '780', 'ISO 3166-2:TT', 'Trinidad & Tobago', '特立尼达和多巴哥', '特立尼达和多巴哥', '特立尼达和多巴哥', '台湾和 香港均将之简称为“ 特立尼达”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('VC', 'VCT', '670', 'ISO 3166-2:VC', 'St. Vincent & the Grenadines', '圣文森特和格林纳丁斯', '圣文森特和格林纳丁斯', '圣文森特和格林纳丁斯', '台湾将之简称为“ 圣文森”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TW', 'TWN', '158', 'ISO 3166-2:TW', 'Taiwan', '中华民国(台湾)', '中华民国 台湾 台湾', '台湾 台湾', '所用英文名称系依据 国际标准化组织之称呼 [1] [2]所示。台湾地区的国际政治地位可参见 未被国际普遍承认的国家列表、 台海现状以及 旧金山条约。'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('NZ', 'NZL', '554', 'ISO 3166-2:NZ', 'New Zealand', '新西兰', '新西兰', '新西兰', '新加坡与 马来西亚均将之译作“ 新西兰”。 香港亦普遍采用“新西兰”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SA', 'SAU', '682', 'ISO 3166-2:SA', 'Saudi Arabia', '沙特阿拉伯', '沙特阿拉伯', '沙特阿拉伯', '新加坡与 马来西亚均将之译作“ 沙特阿拉伯”。 香港亦普遍采用“沙特阿拉伯”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LA', 'LAO', '418', 'ISO 3166-2:LA', 'Laos', '老挝', '老挝', '老挝', '新加坡与 马来西亚均将之译作“老挝”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KP', 'PRK', '408', 'ISO 3166-2:KP', 'North Korea', '朝鲜 北朝鲜', '北朝鲜', '朝鲜 北朝鲜', '澳门习惯称之为“ 北朝鲜”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KR', 'KOR', '410', 'ISO 3166-2:KR', 'South Korea', '韩国 南朝鲜', '韩国 韩国', '韩国 韩国', '澳门习惯称之为“ 韩国”'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PT', 'PRT', '620', 'ISO 3166-2:PT', 'Portugal', '葡萄牙', '葡萄牙', '葡萄牙', '澳门民间亦普遍称之为葡国'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KG', 'KGZ', '417', 'ISO 3166-2:KG', 'Kyrgyzstan', '吉尔吉斯斯坦', '吉尔吉斯', '吉尔吉斯', '香港习惯略去“斯坦”后缀,有必要会用全称'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KZ', 'KAZ', '398', 'ISO 3166-2:KZ', 'Kazakhstan', '哈萨克斯坦', '哈萨克', '哈萨克', '香港习惯略去“斯坦”后缀,有必要会用全称'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TJ', 'TJK', '762', 'ISO 3166-2:TJ', 'Tajikistan', '塔吉克斯坦', '塔吉克', '塔吉克', '香港习惯略去“斯坦”后缀,有必要会用全称'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('TM', 'TKM', '795', 'ISO 3166-2:TM', 'Turkmenistan', '土库曼斯坦', '土库曼', '土库曼', '香港习惯略去“斯坦”后缀,有必要会用全称'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('UZ', 'UZB', '860', 'ISO 3166-2:UZ', 'Uzbekistan', '乌兹别克斯坦', '乌兹别克', '乌兹别克', '香港习惯略去“斯坦”后缀,有必要会用全称'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KN', 'KNA', '659', 'ISO 3166-2:KN', 'St. Kitts & Nevis', '圣基茨和尼维斯', '圣基茨和尼维斯', '圣基茨和尼维斯', '香港亦普遍采用“ 圣克里斯托佛岛及尼维斯岛”一词于其它场合(如 香港邮政的邮政指南附录表)。亦有部份人士使用“ 圣基茨和尼维斯”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('PM', 'SPM', '666', 'ISO 3166-2:PM', 'Saint-Pierre and Miquelon', '圣皮埃尔和密克隆', '圣皮耶与密克隆群岛', '圣皮埃尔岛和密克隆岛', '香港亦普遍采用“ 圣皮埃兰和密克隆群岛”一词于其它场合(如 香港邮政的邮政指南附录表)'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('SH', 'SHN', '654', 'ISO 3166-2:SH', 'St. Helena & Dependencies', '圣赫勒拿', '圣赫勒拿岛', '圣赫勒拿', '香港亦普遍采用“ 圣赫勒拿岛”一词于其它场合(如 香港邮政的邮政指南附录表)。亦有部份人士使用“ 圣海伦娜岛”一词于 港澳地区'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('LC', 'LCA', '662', 'ISO 3166-2:LC', 'St. Lucia', '圣卢西亚', '圣卢西亚', '圣卢西亚', '香港亦普遍采用“ 圣路西亚”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MU', 'MUS', '480', 'ISO 3166-2:MU', 'Mauritius', '毛里求斯', '毛里求斯', '毛里求斯', '香港亦普遍采用“ 毛里求斯”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('CI', 'CIV', '384', 'ISO 3166-2:CI', 'Côte d''Ivoire', '科特迪瓦', '科特迪瓦', '科特迪瓦', '香港亦普遍采用“科特迪瓦”一词于其它场合(如 香港邮政的邮政指南附录表)'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('KE', 'KEN', '404', 'ISO 3166-2:KE', 'Kenya', '肯尼亚', '肯尼亚', '肯尼亚', '香港亦普遍采用“ 肯尼亚”一词于其它场合'); INSERT INTO `t_country` (`two_bit_letters`, `three_bit_letters`, `numeric_code`, `iso_code`, `iso_name_en`, `chinese_name`, `taiwan_name`, `hongkong_name`, `remark`) VALUES ('MN', 'MNG', '496', 'ISO 3166-2:MN', 'Mongolia', '蒙古国 蒙古', '蒙古', '蒙古国', '香港亦普遍采用“ 蒙古”一词于其它场合'); /* 文件夹管理 */ INSERT INTO `t_folder_management` (`organization_id`, `user_id`, `parent_id`, `level`, `name`, `path`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 0, 1, '原始资料管理', '/原始资料管理', 1, NULL, 0, '2020-04-21 11:02:01', '2020-04-21 11:02:01', 0); INSERT INTO `t_folder_management` (`organization_id`, `user_id`, `parent_id`, `level`, `name`, `path`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 1, 2, '文件夹一', '/原始资料管理/文件夹一', 1, NULL, 0, '2020-04-21 11:02:41', '2020-04-21 11:02:41', 0); INSERT INTO `t_folder_management` (`organization_id`, `user_id`, `parent_id`, `level`, `name`, `path`, `state`, `remark`, `version`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 1, 2, '文件夹二', '/原始资料管理/文件夹二', 1, NULL, 0, '2020-04-21 11:03:32', '2020-04-21 11:03:32', 0); /* 产品表 */ INSERT INTO `t_product` (`organization_id`, `generic_name_zh`, `generic_name_en`, `standardized_generic_name`, `active_ingredient`, `drug_category`, `manufacturer`, `country`, `province`, `city`, `street_address`, `post_code`, `dosage_form_id`, `product_category`, `norms`, `indication`, `imp_id`, `mp_id`, `drug_phase`, `product_name`, `approval_number`, `created_by`, `created_time`, `updated_by`, `updated_time`, `enable`) VALUES (1, '阿司匹林', 'aspirin', '阿司匹林', '乙酰水杨酸', 0, '某某某', '', '', '', '', '', 0, 0, '未知', '用于发热、疼痛及类风湿关节炎等', 'D001', '', 0, '', '', 0, '2020-04-29 18:04:48', 0, '2020-04-29 18:04:48', 1); /* 项目表 */ INSERT INTO `t_project` (`organization_id`, `project_code`, `scenario_name`, `other_drugs`, `bid`, `bid_phone`, `research_category`, `project_status`, `trial_indication`, `research_design`, `start_date`, `end_date`, `drug_category`, `register_category`, `terminal_reporting`, `applicant_number`, `applicant_country`, `applicant_name`, `research_drugs`, `contrast_drugs`, `adjuvant_drugs`, `created_by`, `created_time`, `updated_by`, `updated_time`, `enable`) VALUES (1, 'DAP001', '阿司匹林研究方案', '', '123', '', NULL, NULL, '', NULL, NULL, NULL, NULL, '', 1, '', NULL, '', '1', '', '', 1, '2020-04-29 18:05:31', NULL, '2020-04-29 18:05:31', 1); /* 民族表 */ INSERT INTO `t_nation` (`code`, `name`) VALUES ('01', '汉族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('02', '蒙古族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('03', '回族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('04', '藏族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('05', '维吾尔族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('06', '苗族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('07', '彝族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('08', '壮族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('09', '布依族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('10', '朝鲜族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('11', '满族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('12', '侗族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('13', '瑶族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('14', '白族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('15', '土家族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('16', '哈尼族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('17', '哈萨克族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('18', '傣族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('19', '黎族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('20', '傈僳族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('21', '佤族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('22', '畲族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('23', '高山族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('24', '拉祜族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('25', '水族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('26', '东乡族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('27', '纳西族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('28', '景颇族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('29', '柯尔克孜族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('30', '土族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('31', '达斡尔族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('32', '仫佬族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('33', '羌族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('34', '布朗族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('35', '撒拉族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('36', '毛南族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('37', '仡佬族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('38', '锡伯族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('39', '阿昌族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('40', '普米族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('41', '塔吉克族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('42', '怒族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('43', '乌孜别克族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('44', '俄罗斯族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('45', '鄂温克族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('46', '德昂族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('47', '保安族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('48', '裕固族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('49', '京族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('50', '塔塔尔族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('51', '独龙族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('52', '鄂伦春族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('53', '赫哲族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('54', '门巴族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('55', '珞巴族'); INSERT INTO `t_nation` (`code`, `name`) VALUES ('56', '基诺族');