ALTER TABLE visit_note ADD `note` text NULL
ALTER TABLE visit_note ADD `dep_name` VARCHAR(25) NULL
ALTER TABLE tempmanoi_xp2 MODIFY COLUMN `person_id` CHAR(13)
ALTER TABLE tempmanoi_xp2 MODIFY COLUMN `hn` CHAR(7)
ALTER TABLE tempmanoi_xp1 MODIFY COLUMN `hn` VARCHAR(7)
ALTER TABLE tempdental1 MODIFY COLUMN `hn` VARCHAR(7)
ALTER TABLE tempcom41 MODIFY COLUMN `hn` VARCHAR(7)
ALTER TABLE opduser ADD `restrict_ward_access` CHAR(1) NULL
ALTER TABLE ipd_refer ADD `refer_number` VARCHAR(10) NULL
ALTER TABLE ipd_refer ADD `refer_doctor` VARCHAR(10) NULL
ALTER TABLE ipd_refer ADD `refer_staff` VARCHAR(25) NULL
ALTER TABLE ipd_refer ADD `refer_to_hospcode` CHAR(5) NOT NULL
ALTER TABLE ipd_refer ADD `refer_time` TIME NULL
ALTER TABLE ipd_refer ADD `refer_date` DATE NULL
ALTER TABLE ipd_refer ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE doctor_schedule ADD `doctor_fee_type_id` INT NULL
ALTER TABLE doctor_dep_dlg_list ADD `depcode` VARCHAR(3) NOT NULL
ALTER TABLE doctor_dep_dlg_list ADD `doctor` VARCHAR(7) NOT NULL
ALTER TABLE doctor_dep_dlg_list ADD `item_number` INT NULL
CREATE TABLE ipd_refer ( `ipd_refer_id` INT NOT NULL )
CREATE TABLE doctor_dep_dlg_list ( `doctor_dep_dlg_list_id` INT NOT NULL )