salix/db/versions/.archive/10370-pinkBirch/01-firstScript.sql

-- Place your SQL code here
DROP DATABASE IF EXISTS `roundcube__`;
DROP DATABASE IF EXISTS `mediawiki__`;
DROP DATABASE IF EXISTS `wordpress__`;
DROP DATABASE IF EXISTS `ps_helper__`;

ALTER TABLE `vn`.`invoiceOut` 
DROP COLUMN IF EXISTS `workerFk__`,
DROP COLUMN IF EXISTS `vat16__`,
DROP COLUMN IF EXISTS `vat7__`,
DROP COLUMN IF EXISTS `equ4__`,
DROP COLUMN IF EXISTS `equ1__`,
DROP COLUMN IF EXISTS `taxableBase16__`,
DROP COLUMN IF EXISTS `taxableBase7__`,
DROP INDEX IF EXISTS `Id_Trabajador` ;

ALTER TABLE `vn`.`item` 
DROP COLUMN IF EXISTS `sectorFk__`,
DROP COLUMN IF EXISTS `compression__`,
DROP COLUMN IF EXISTS `isBargain__`,
DROP COLUMN IF EXISTS `isOnOffer__`,
DROP COLUMN IF EXISTS `niche__`,
DROP COLUMN IF EXISTS `taxClassFk__`,
DROP COLUMN IF EXISTS `isDeliveryNote__`,
DROP INDEX IF EXISTS `item_ibfk_6_idx` ,
DROP INDEX IF EXISTS `iva_group_id`;

ALTER TABLE `vn`.`address` 
DROP COLUMN IF EXISTS `isVilassarBuyer__`,
DROP COLUMN IF EXISTS `codPosOld__`,
DROP COLUMN IF EXISTS `postcodeOLD__`,
DROP COLUMN IF EXISTS `porte__`,
DROP COLUMN IF EXISTS `hasInsurance__`,
DROP COLUMN IF EXISTS `notes__`,
DROP COLUMN IF EXISTS `warehouseFk__`,
DROP INDEX IF EXISTS `warehouse_id` ;

ALTER TABLE `vn`.`config` 
DROP COLUMN IF EXISTS `serialMFk__`,
DROP COLUMN IF EXISTS `serialTFk__`,
DROP COLUMN IF EXISTS `serialPFk__`,
DROP COLUMN IF EXISTS `serialHFk__`,
DROP COLUMN IF EXISTS `serialCFk__`,
DROP COLUMN IF EXISTS `serialRFk__`,
DROP COLUMN IF EXISTS `serialEFk__`,
DROP COLUMN IF EXISTS `serialAFk__`,
DROP COLUMN IF EXISTS `bookFk__`;

ALTER TABLE `vn`.`client` 
DROP COLUMN IF EXISTS `cplusTerIdNifFk__`,
DROP COLUMN IF EXISTS `codposOLD__`,
DROP COLUMN IF EXISTS `postcodeOld__`,
DROP COLUMN IF EXISTS `coreFth__`,
DROP COLUMN IF EXISTS `sepaFth__`,
DROP COLUMN IF EXISTS `splitHolland__`,
DROP COLUMN IF EXISTS `cyc__`,
DROP COLUMN IF EXISTS `hold__`,
DROP COLUMN IF EXISTS `invoiceCopy__`,
DROP COLUMN IF EXISTS `administrativeNotes__`,
DROP COLUMN IF EXISTS `notes__`,
DROP COLUMN IF EXISTS `isReExpedition__`,
DROP COLUMN IF EXISTS `wholesaler__`,
DROP COLUMN IF EXISTS `isOfficial__`,
DROP COLUMN IF EXISTS `receipt__`,
DROP COLUMN IF EXISTS `fax__`,
DROP COLUMN IF EXISTS `discount__`,
DROP INDEX IF EXISTS `codpos` ,
ADD INDEX `codpos` (`postcode` ASC) VISIBLE;

ALTER TABLE `vn`.`claimBeginning` 
DROP COLUMN IF EXISTS `claimRequestFk__`,
DROP COLUMN IF EXISTS `claimComplaintFk__`;

ALTER TABLE `vn`.`department` 
DROP COLUMN IF EXISTS `y__`,
DROP COLUMN IF EXISTS `x__`,
DROP COLUMN IF EXISTS `bossFk__`;

ALTER TABLE `vn`.`claim` 
DROP COLUMN IF EXISTS `claimDepartmentFk__`,
DROP INDEX IF EXISTS `cl_dep_id` ;

ALTER TABLE `vn`.`supplierAccount` 
DROP COLUMN IF EXISTS `bicSufix__`;

ALTER TABLE `vn`.`travelThermograph` 
DROP COLUMN IF EXISTS `temperature__`;

ALTER TABLE `vn`.`origin` 
DROP COLUMN IF EXISTS `nl__`,
DROP COLUMN IF EXISTS `flag__`;

ALTER TABLE `vn`.`itemShelving` 
DROP COLUMN IF EXISTS `stars__`,
DROP COLUMN IF EXISTS `priority__`,
DROP COLUMN IF EXISTS `shelve__`;

ALTER TABLE `vn`.`receipt` 
DROP COLUMN IF EXISTS `amountUnpaid__`;

ALTER TABLE `vn`.`agency` 
DROP COLUMN IF EXISTS `supplierFk__`,
DROP COLUMN IF EXISTS `labelZone__`,
DROP COLUMN IF EXISTS `bankFk__`,
DROP COLUMN IF EXISTS `isVolumetric__`,
DROP INDEX IF EXISTS `agency_ibfk_4_idx` ,
DROP INDEX IF EXISTS `Id_Banco` ;

ALTER TABLE `vn`.`sector` 
DROP COLUMN IF EXISTS `labelReport__`,
DROP COLUMN IF EXISTS `path__`,
DROP COLUMN IF EXISTS `pickingPlacement__`;

ALTER TABLE `vn`.`ticket` 
DROP COLUMN IF EXISTS `collectionFk__`,
DROP COLUMN IF EXISTS `isBooked__`,
DROP COLUMN IF EXISTS `invoiceOutFk__`,
DROP COLUMN IF EXISTS `notes__`,
DROP INDEX IF EXISTS `tickets_fk11_idx` ;

ALTER TABLE `vn`.`agencyMode` 
DROP COLUMN IF EXISTS `cod71__`;

ALTER TABLE `vn`.`itemType` 
DROP COLUMN IF EXISTS `f11__`,
DROP COLUMN IF EXISTS `gramsMin__`;

ALTER TABLE `vn`.`ticketRequest` 
DROP COLUMN IF EXISTS `ko__`,
DROP COLUMN IF EXISTS `ok__`,
DROP COLUMN IF EXISTS `price__`;

ALTER TABLE `vn`.`supplier` 
DROP COLUMN IF EXISTS `Fax__`;

ALTER TABLE `vn`.`clientProtected` 
DROP COLUMN IF EXISTS `isValidated__`;

ALTER TABLE `vn`.`payment` 
DROP COLUMN IF EXISTS `exchangeInsuranceFk__`,
DROP INDEX IF EXISTS `fk_pago_pago_sdc1_idx` ;

ALTER TABLE `vn`.`buy` 
DROP COLUMN IF EXISTS `producer__`;

ALTER TABLE `vn`.`host` 
DROP COLUMN IF EXISTS `packingSite__`,
DROP COLUMN IF EXISTS `itemPackingTypeFk__`,
DROP INDEX IF EXISTS `configHost_FK_1` ;

ALTER TABLE `vn`.`zone` 
DROP COLUMN IF EXISTS `warehouseFk__`,
DROP INDEX IF EXISTS `fk_zone_1_idx`;

ALTER TABLE `vn`.`floramondoConfig` 
DROP COLUMN IF EXISTS `agencyModeFk__`,
DROP COLUMN IF EXISTS `warehouseOutFk__`,
DROP INDEX IF EXISTS `floramondoConfigAgencyModeFk_idx` ,
DROP INDEX IF EXISTS `floramondoConfigWarehouseOut_idx` ;

ALTER TABLE `vn`.`sms` 
DROP COLUMN IF EXISTS `destinationFk__`;

ALTER TABLE `vn`.`itemBotanical` 
DROP COLUMN IF EXISTS `botanical__`;

ALTER TABLE `vn`.`smsConfig` 
DROP COLUMN IF EXISTS `password__`,
DROP COLUMN IF EXISTS `user__`;

ALTER TABLE `vn`.`expedition` 
DROP COLUMN IF EXISTS `checked__`,
DROP COLUMN IF EXISTS `isPickUp__`,
DROP COLUMN IF EXISTS `isRefund__`;

ALTER TABLE `vn`.`intrastat` 
DROP COLUMN IF EXISTS `import__`;

ALTER TABLE `bs`.`indicators` 
DROP COLUMN IF EXISTS `salesWorkersCostRate__`,
DROP COLUMN IF EXISTS `workerCostM3__`,
DROP COLUMN IF EXISTS `hoursM3__`,
DROP COLUMN IF EXISTS `valueM3__`,
DROP COLUMN IF EXISTS `salesValue__`,
DROP COLUMN IF EXISTS `volumeM3__`,
DROP COLUMN IF EXISTS `dailyWorkersCost__`,
DROP COLUMN IF EXISTS `productionHours__`;

ALTER TABLE `vn2008`.`payroll_employee` 
DROP COLUMN IF EXISTS `Person_id__`;

ALTER TABLE `postgresql`.`income_employee` 
DROP COLUMN IF EXISTS `person_id__`;