Skip to content

C
cloud-fb
Switch branch/tag
Find file
Normal viewHistoryPermalink
db-changelog-1.19.sql 1001 Bytes
Newer Older
master初版
9f7706e7
 
PWF-WK01\pengwufeng committed
1 2 3 4 5 6 
INSERT INTO inz_contract_cost_item (SELECT a.*, 'GENERAL'  from  inz_contract_general_receipt_payment_cost_item a);
INSERT INTO inz_contract_cost_item (SELECT c.*, '', 'CYCLE' from inz_contract_contract_cost_item c inner join inz_contract_lease_contract_cycle_cost_item a where a.id = c.id);
INSERT INTO inz_contract_cost_item (SELECT c.*, '', 'GUARANTEE' from inz_contract_contract_cost_item c inner join inz_contract_lease_contract_deposit_cost_item a where a.id = c.id);
INSERT INTO inz_contract_cost_item (SELECT c.*, '', 'ONCE' from inz_contract_contract_cost_item c inner join inz_contract_lease_contract_onetime_cost_item a where a.id = c.id);
INSERT INTO inz_contract_cost_item (SELECT c.*, '', 'PROPERTY' from inz_contract_contract_cost_item c inner join inz_contract_lease_contract_property_cost_item a where a.id = c.id);
INSERT INTO inz_contract_cost_item (SELECT c.*, '', 'SALE' from inz_contract_contract_cost_item c inner join inz_contract_sale_contract_cost_item a where a.id = c.id);