use `sys-tran`;

ALTER TABLE `tran_hospital_dept`
ADD COLUMN `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号' AFTER `status`；

ALTER TABLE `tran_hospital_dept`
ADD COLUMN `url` varchar(255) NOT NULL DEFAULT '' COMMENT '医院科室地址' AFTER `order_no`;


INSERT INTO `sys-tran`.`tran_sys_set` (`is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `hospital_code`, `plan`, `sys_type`, `name`, `code`, `value`, `remark`) VALUES ('N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', NULL, NULL, 'A001', '0', '9', '科室显示模式', 'dept_mode', '2', '1显示标准科室，2显示医院科室');
