IF NOT EXISTS (SELECT * FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID('PRC_FILIAL') AND NAME = 'AREA_FARMA')
	ALTER TABLE PRC_FILIAL ADD AREA_FARMA MONEY NOT NULL CONSTRAINT DF_PRC_FILIAL_AREA_FARMA DEFAULT 0

GO

IF NOT EXISTS (SELECT * FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID('PRC_FILIAL') AND NAME = 'AREA_NAO_FARMA')
	ALTER TABLE PRC_FILIAL ADD AREA_NAO_FARMA MONEY NOT NULL CONSTRAINT DF_PRC_FILIAL_AREA_NAO_FARMA DEFAULT 0

GO

IF NOT EXISTS (SELECT * FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID('PRC_FILIAL') AND NAME = 'AREA_OUTROS')
	ALTER TABLE PRC_FILIAL ADD AREA_OUTROS MONEY NOT NULL CONSTRAINT DF_PRC_FILIAL_AREA_OUTROS DEFAULT 0

GO

IF NOT EXISTS (SELECT * FROM SYS.COLUMNS WHERE OBJECT_ID = OBJECT_ID('PRC_FILIAL') AND NAME = 'AREA_CUSTO')
	ALTER TABLE PRC_FILIAL ADD AREA_CUSTO MONEY NOT NULL CONSTRAINT DF_PRC_FILIAL_AREA_CUSTO DEFAULT 0

GO

