Checking STRUCTURE phase 2
ALTER TABLE village_school_shift ADD `old_student_delta` longtext NULL
ALTER TABLE village_school_shift ADD `shift_type` INT NULL
ALTER TABLE village_school_shift ADD `shift_datetime` datetime NULL
ALTER TABLE village_school_shift ADD `staff` VARCHAR(50) NOT NULL
ALTER TABLE person_women ADD `out_region` CHAR(1) NULL
ALTER TABLE person_wbc ADD `out_region` CHAR(1) NULL
ALTER TABLE person_epi ADD `out_region` CHAR(1) NULL
ALTER TABLE person_anc ADD `out_region` CHAR(1) NULL
ALTER TABLE person MODIFY COLUMN `blood_group` VARCHAR(10)
ALTER TABLE onlineuser ADD `is_admin` CHAR(1) NULL
ALTER TABLE ipt_doctor_list ADD `incharge_time` TIME NULL
ALTER TABLE ipt_doctor_list ADD `incharge_date` DATE NULL
ALTER TABLE ipt_doctor_list ADD `remark` VARCHAR(150) NULL
ALTER TABLE ipt_doctor_list ADD `doctor` VARCHAR(10) NOT NULL
ALTER TABLE ipt_doctor_list ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE doctor ADD `clinic` CHAR(3) NULL
ALTER TABLE doctor ADD `spclty` CHAR(2) NULL
ALTER TABLE department_substock_list ADD `department_id` INT NOT NULL
ALTER TABLE department_substock_list ADD `depcode` CHAR(3) NOT NULL
ALTER TABLE app_storage ADD `storage_default_value` text NULL
ALTER TABLE app_storage ADD `storage_value` text NULL
ALTER TABLE app_storage ADD `storage_section` VARCHAR(250) NULL
ALTER TABLE app_storage ADD `storage_key` VARCHAR(250) NULL
ALTER TABLE app_storage ADD `computer_name` VARCHAR(100) NOT NULL
CREATE TABLE village_school_shift ( `village_school_shift_id` INT NOT NULL )
CREATE TABLE ipt_doctor_list ( `ipt_doctor_list_id` INT NOT NULL )
CREATE TABLE department_substock_list ( `department_substock_list_id` INT NOT NULL )
CREATE TABLE app_storage ( `app_storage_id` INT NOT NULL )
Checking STRUCTURE phase 1
หัวข้อ: 3.51.1.8 (อ่าน 6186 ครั้ง)