
/*------ ATD 332589 ------*/
IF EXISTS (SELECT 1 FROM SYSCOLUMNS C JOIN SYSOBJECTS T ON C.ID = T.ID AND T.XTYPE = 'U'
				WHERE T.NAME = 'TRANSACAO_PEDIDO_ECOMMERCE' AND C.NAME = 'CODIGOBARRA' AND C.LENGTH < 50)
	ALTER TABLE TRANSACAO_PEDIDO_ECOMMERCE ALTER COLUMN CODIGOBARRA VARCHAR(50) NULL
go

IF EXISTS (SELECT 1 FROM SYSCOLUMNS C JOIN SYSOBJECTS T ON C.ID = T.ID AND T.XTYPE = 'U'
				WHERE T.NAME = 'CONFIGURACAO_ECOMMERCE' AND C.NAME = 'CODIGOECOMMERCE' AND C.LENGTH < 200)
	ALTER TABLE CONFIGURACAO_ECOMMERCE ALTER COLUMN CODIGOECOMMERCE VARCHAR(200) NOT NULL
go

IF EXISTS (SELECT 1 FROM SYSCOLUMNS C JOIN SYSOBJECTS T ON C.ID = T.ID AND T.XTYPE = 'U'
				WHERE T.NAME = 'CONFIGURACAO_ECOMMERCE' AND C.NAME = 'CLASSE' AND C.LENGTH < 50)
	ALTER TABLE CONFIGURACAO_ECOMMERCE ALTER COLUMN CLASSE VARCHAR(50) NOT NULL
go