init_tran.sql 623 B

12345678910
  1. use `sys-tran`;
  2. ALTER TABLE `tran_hospital_dept`
  3. ADD COLUMN `order_no` int(11) NOT NULL DEFAULT '0' COMMENT '排序号' AFTER `status`;
  4. ALTER TABLE `tran_hospital_dept`
  5. ADD COLUMN `url` varchar(255) NOT NULL DEFAULT '' COMMENT '医院科室地址' AFTER `order_no`;
  6. 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显示医院科室');