Import table : house_type
ALTER TABLE xray_report ADD `xray_keeper_id` int NULL
ALTER TABLE xray_keeper ADD `xray_keeper_name` varchar(150) NOT NULL
ALTER TABLE person_house_history ADD `move_staff` varchar(25) NULL
ALTER TABLE person_house_history ADD `move_datetime` datetime NULL
ALTER TABLE person_house_history ADD `new_house_id` int NOT NULL
ALTER TABLE person_house_history ADD `old_house_id` int NOT NULL
ALTER TABLE person_house_history ADD `person_id` int NOT NULL
ALTER TABLE person_chronic_visit ADD `person_id` int NOT NULL
ALTER TABLE person_chronic_visit ADD `visit_note` longtext NULL
ALTER TABLE person_chronic_visit ADD `visit_staff` varchar(50) NULL
ALTER TABLE person_chronic_visit ADD `visit_time` time NULL
ALTER TABLE person_chronic_visit ADD `visit_date` date NULL
ALTER TABLE person_chronic_visit ADD `person_chronic_id` int NOT NULL
ALTER TABLE mosquitoes_prevent_type ADD `mosquitoes_prevent_type_name` varchar(100) NOT NULL
ALTER TABLE mosquitoes_advice_officer ADD `mosquitoes_advice_officer_name` varchar(100) NOT NULL
ALTER TABLE house_type ADD `house_type_name` varchar(150) NOT NULL
ALTER TABLE house_mosquitoes_survey ADD `survey_staff` varchar(150) NULL
ALTER TABLE house_mosquitoes_survey ADD `survey_date` date NULL
ALTER TABLE house_mosquitoes_survey ADD `other_jar_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `other_jar_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `cabinet_jar_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `cabinet_jar_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `toilet_jar_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `toilet_jar_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar3_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar3_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar2_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar2_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar1_found` int NULL
ALTER TABLE house_mosquitoes_survey ADD `jar1_count` int NULL
ALTER TABLE house_mosquitoes_survey ADD `house_id` int NOT NULL
ALTER TABLE house_mosquitoes_prevent ADD `mosquitoes_prevent_type_id` int NOT NULL
ALTER TABLE house_mosquitoes_prevent ADD `house_mosquitoes_survey_id` int NOT NULL
ALTER TABLE house_mosquitoes_advice ADD `mosquitoes_advice_officer_id` int NOT NULL
ALTER TABLE house_mosquitoes_advice ADD `house_mosquitoes_survey_id` int NOT NULL
ALTER TABLE house_image ADD `image_taken_date` date NULL
ALTER TABLE house_image ADD `image_description` varchar(250) NULL
ALTER TABLE house_image ADD `image_number` int NULL
ALTER TABLE house_image ADD `house_image` longblob NULL
ALTER TABLE house_image ADD `house_id` int NOT NULL
ALTER TABLE house ADD `house_type_id` int NULL
CREATE TABLE xray_keeper ( `xray_keeper_id` int NOT NULL )
CREATE TABLE person_house_history ( `person_house_history_id` int NOT NULL )
CREATE TABLE person_chronic_visit ( `person_chronic_visit_id` int NOT NULL )
CREATE TABLE mosquitoes_prevent_type ( `mosquitoes_prevent_type_id` int NOT NULL )
CREATE TABLE mosquitoes_advice_officer ( `mosquitoes_advice_officer_id` int NOT NULL )
CREATE TABLE house_type ( `house_type_id` int NOT NULL )
CREATE TABLE house_mosquitoes_survey ( `house_mosquitoes_survey_id` int NOT NULL )
CREATE TABLE house_mosquitoes_prevent ( `house_mosquitoes_prevent_id` int NOT NULL )
CREATE TABLE house_mosquitoes_advice ( `house_mosquitoes_advice_id` int NOT NULL )
CREATE TABLE house_image ( `house_image_id` int NOT NULL )
delete from hosxp_ddl_index
delete from hosxp_ddl_field
CREATE TABLE if not exists `hosxp_ddl_index` ( `table_name` varchar(150) NOT NULL default "", `index_name` varchar(150) NOT NULL default "", `field_number` int(11) default NULL, `field_name` varchar(150) NOT NULL default "", `index_unique` char(1) default NULL, `index_seq` int(11) default NULL, PRIMARY KEY (`table_name`,`index_name`,`field_name`), KEY `index_name` (`index_name`), KEY `table_name` (`table_name`) )
DROP TABLE if exists hosxp_ddl_index
CREATE TABLE if not exists `hosxp_ddl_field` ( `table_name` varchar(150) NOT NULL default "", `field_name` varchar(150) NOT NULL default "", `field_type_mysql` varchar(100) default NULL, `field_type_postgresql` varchar(100) default NULL, `field_type_mssql` varchar(100) default NULL, `field_type_interbase` varchar(100) default NULL, `field_width` int(11) default NULL, `field_null` varchar(10) default NULL, `field_number` int(11) default NULL, `field_primary` char(1) default NULL, `field_type_oracle` varchar(150) default NULL, `field_type_native` varchar(100) default NULL, `field_precision` int(11) default NULL, `field_precision_text` varchar(100) default NULL, PRIMARY KEY (`table_name`,`field_name`), KEY `field_name` (`field_name`), KEY `table_name` (`table_name`) )
DROP TABLE if exists hosxp_ddl_field
Update hosxp_dll_field data ...
หัวข้อ: HOSxP:PCU (อ่าน 11307 ครั้ง)