zhumj/db/migrate005.sql

drop table contract_free_fee;
alter table order_free_fee change order_id contract_store_id bigint not null;
rename table order_free_fee to contract_free_fee;

alter table order_deduction_fee change order_id contract_store_id bigint not null;
rename table order_deduction_fee to contract_fixed_fee;

alter table order_room_info change contract_room contract_room_type_id bigint not null;
alter table order_room_info change room_info_id room_id bigint not null;
alter table order_room_info drop column order_id;
rename table order_room_info to contract_reserve_room;


alter table contract_store drop foreign key FKpq2qnjfvfws7t5tkg0rmaav5s;
drop index UK_urox4q0pglct5s5bu63sipar on contract_store;
drop index UK_c4rnnp0gkygxyxc477we4x5gq on contract_store;
alter table contract_store add constraint FKpq2qnjfvfws7t5tkg0rmaav5s foreign key (contract_id) references contract (id);

drop index FK6vc2qkse1t8gnh0k5589foko5 on contract_room_type;
drop index FKiq6khr7imvc2bgbq6pgbmxnvb on contract_room_type;

update menu set path = '/contractViolationList' where id = 23871;
delete from menu where id = 637;