-- ------------------------------------------------------------------------------------------------------------------------
-- Actualización de TB y SP
-- 2026.01
-- 

-- ------------------------------------------------------------------------------------------------------------------------
drop table if exists tb_f_obudget;
drop table if exists tb_f_obudget_dproducts;

drop procedure sp_form_f_obudget_c;
drop procedure sp_form_f_obudget_dproducts_c;
drop procedure sp_form_f_obudget_dproduts_u;
drop procedure sp_form_f_obudget_u;

-- ------------------------------------------------------------------------------------------------------------------------
ALTER TABLE `tb_f_oquote` 
DROP COLUMN `envio_direccion`,
DROP COLUMN `envio_zcode`,
DROP COLUMN `envio_ciudad`,
DROP COLUMN `envio_estado_ciudad`,
DROP COLUMN `envio_pais`,
DROP COLUMN `envio_nombre`,
DROP COLUMN `bill_name`,
DROP COLUMN `ship_to`;

