useful-qry/table-controls/테이블-update-default.sql

update pro_post set member_id = 1 where member_id = 0;
update pro_post set user_id = 1 where user_id = 0;
update pro_post set media_id = 1 where media_id = 0;

update dbr_item set media_id = 1 where media_id = 0;
update dbr_item set igroup_id = 1 where igroup_id = 0;

update dbr_item_thm set media_id1 = 1 where media_id1 = 0;
update dbr_item_thm set media_id2 = 1 where media_id2 = 0;
update dbr_item_thm set media_id3 = 1 where media_id3 = 0;
update dbr_item_thm set media_id4 = 1 where media_id4 = 0;
update dbr_item_thm set media_id5 = 1 where media_id5 = 0;

update dbr_sorder set user_id = 1 where user_id = 0;
update dbr_sorder set branch_id = 1 where branch_id = 0;
update dbr_sorder set storage_id = 1 where storage_id = 0;
update dbr_sorder set sgroup_id = 1 where sgroup_id = 0;
update dbr_sorder set vat_rate_id = 1 where vat_rate_id = 0;
update dbr_sorder set project_id = 1 where project_id = 0;
update dbr_sorder set deal_type_id = 1 where deal_type_id = 0;
update dbr_sorder set sgroup2_id = 1 where sgroup2_id = 0;

update dbr_porder set user_id = 1 where user_id = 0;
update dbr_porder set branch_id = 1 where branch_id = 0;
update dbr_porder set storage_id = 1 where storage_id = 0;
update dbr_porder set sgroup_id = 1 where sgroup_id = 0;
update dbr_porder set vat_rate_id = 1 where vat_rate_id = 0;
update dbr_porder set deal_type_id = 1 where deal_type_id = 0;

UPDATE `dbr_company` SET is_deal_end = '0';