ALTER TABLE [OrdemServico] ADD [osLocalizacao]  varchar(15) NULL , [osTipoRecebTotal]  smallint NULL CONSTRAINT osTipoRecebTotalOrdemServico_DEFAULT DEFAULT 0 WITH VALUES, [osTipoRecebAdianto]  smallint NULL CONSTRAINT osTipoRecebAdiantoOrdemServico_DEFAULT DEFAULT 0 WITH VALUES, [osVlSinal]  smallmoney NOT NULL CONSTRAINT osVlSinalOrdemServico_DEFAULT DEFAULT convert(int, 0)
ALTER TABLE [OrdemServico] DROP CONSTRAINT osTipoRecebTotalOrdemServico_DEFAULT
ALTER TABLE [OrdemServico] DROP CONSTRAINT osTipoRecebAdiantoOrdemServico_DEFAULT
UPDATE [OrdemServico] SET [osVlSinal]=T.[osVlSinal] FROM (SELECT T1.[osFase], T1.[osId], T1.[osAno], COALESCE( T2.[osVlSinal], 0) AS osVlSinal FROM ([OrdemServico] T1 LEFT JOIN (SELECT SUM([pgValor]) AS osVlSinal, [osFase], [osId], [osAno] FROM [OrdemServicoPagto] WHERE [pgTipo] = 1 GROUP BY [osFase], [osId], [osAno] ) T2 ON T2.[osFase] = T1.[osFase] AND T2.[osId] = T1.[osId] AND T2.[osAno] = T1.[osAno])) T WHERE [OrdemServico].osFase= T.osFase AND [OrdemServico].osId= T.osId AND [OrdemServico].osAno= T.osAno
ALTER TABLE [OrdemServico] DROP CONSTRAINT osVlSinalOrdemServico_DEFAULT

ALTER TABLE [Cliente] ADD [cliCEP]  varchar(10) NULL , [cliUF]  varchar(2) NULL , [cliCidade]  varchar(20) NULL , [cliBairro]  varchar(20) NULL , [cliComplemento]  varchar(10) NULL , [cliNumero]  varchar(10) NULL , [cliEndereco]  varchar(100) NULL
ALTER TABLE [Cliente] DROP COLUMN [cliCelular]

CREATE TABLE [OrdemServicoosPagto] ([osFase]  smallint NOT NULL , [osId]  int NOT NULL , [osAno]  smallint NOT NULL , [pgDataPagto]  datetime NOT NULL , [pgTipoReceb]  smallint NOT NULL , [pgValor]  smallmoney NOT NULL , PRIMARY KEY([osFase], [osId], [osAno], [pgDataPagto], [pgTipoReceb]))
INSERT INTO [OrdemServicoosPagto] ([osFase], [osId], [osAno], [pgDataPagto], [pgTipoReceb], [pgValor]) SELECT [osFase], [osId], [osAno], [pgDataPagto], [pgTipoReceb], [pgValor] FROM (SELECT [osFase], [osId], [osAno], [pgDataPagto], [pgTipoReceb], [pgValor], ROW_NUMBER() OVER (PARTITION BY osFase, osId, osAno, pgDataPagto, pgTipoReceb ORDER BY osFase, osId, osAno, pgDataPagto, pgTipoReceb DESC) As _GX_ROW_NUMBER FROM [OrdemServicoPagto]) T WHERE _GX_ROW_NUMBER = 1

DROP TABLE [OrdemServicoPagto]

ALTER TABLE [OrdemServicoosPagto] ADD CONSTRAINT [IORDEMSERVICOOSPAGTO1] FOREIGN KEY ([osFase], [osId], [osAno]) REFERENCES [OrdemServico] ([osFase], [osId], [osAno])