BMS-HOSxP Community
HOSxP => Development => ข้อความที่เริ่มโดย: doramon ที่ มิถุนายน 02, 2009, 16:03:05 PM
-
Checking structure phase 2
ALTER TABLE provis_women ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_surveil ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_pp ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_nutri ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_fp ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_epi ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_death ADD `hos_guid` varchar(38) NULL
ALTER TABLE provis_anc ADD `hos_guid` varchar(38) NULL
ALTER TABLE person_senile_self_type ADD `person_senile_self_type_name` varchar(150) NOT NULL
ALTER TABLE person_senile_money_aid_type ADD `person_senile_money_aid_type_name` varchar(150) NOT NULL
ALTER TABLE person_senile_helper_type ADD `person_senile_helper_type_name` varchar(150) NOT NULL
ALTER TABLE person_senile_club_type ADD `person_senile_club_type_name` varchar(150) NOT NULL
ALTER TABLE person_senile ADD `person_senile_club_type_id` int NULL
ALTER TABLE person_senile ADD `person_senile_money_aid_type_id` int NULL
ALTER TABLE person_senile ADD `person_senile_self_type_id` int NULL
ALTER TABLE person_senile ADD `person_senile_helper_type_id` int NULL
ALTER TABLE person_deformed_no_regist_type ADD `person_deformed_no_regist_type_name` varchar(150) NOT NULL
ALTER TABLE person_deformed_need_aid_type ADD `person_deformed_need_aid_type_name` varchar(150) NOT NULL
ALTER TABLE person_deformed_need_aid ADD `person_deformed_need_aid_type_id` int NOT NULL
ALTER TABLE person_deformed_need_aid ADD `person_deformed_id` int NOT NULL
ALTER TABLE person_deformed_money_aid_type ADD `person_deformed_money_aid_type_name` varchar(150) NOT NULL
ALTER TABLE person_deformed ADD `person_deformed_money_aid_type_id` int NULL
ALTER TABLE person_deformed ADD `person_deformed_no_regist_type_id` int NULL
ALTER TABLE ncd_history_type ADD `ncd_history_type_name` varchar(150) NOT NULL
ALTER TABLE agriculture_member_type ADD `agriculture_member_type_name` varchar(150) NOT NULL
CREATE TABLE person_senile_self_type ( `person_senile_self_type_id` int NOT NULL )
CREATE TABLE person_senile_money_aid_type ( `person_senile_money_aid_type_id` int NOT NULL )
CREATE TABLE person_senile_helper_type ( `person_senile_helper_type_id` int NOT NULL )
CREATE TABLE person_senile_club_type ( `person_senile_club_type_id` int NOT NULL )
CREATE TABLE person_senile ( `person_id` int NOT NULL )
CREATE TABLE person_deformed_no_regist_type ( `person_deformed_no_regist_type_id` int NOT NULL )
CREATE TABLE person_deformed_need_aid_type ( `person_deformed_need_aid_type_id` int NOT NULL )
CREATE TABLE person_deformed_need_aid ( `person_deformed_need_aid_id` int NOT NULL )
CREATE TABLE person_deformed_money_aid_type ( `person_deformed_money_aid_type_id` int NOT NULL )
CREATE TABLE ncd_history_type ( `ncd_history_type_id` int NOT NULL )
CREATE TABLE agriculture_member_type ( `agriculture_member_type_id` int NOT NULL )
Checking structure phase 1