26 lines
1.1 KiB
SQL
26 lines
1.1 KiB
SQL
-- AlterTable: Adicionar limites aos campos de texto
|
|
ALTER TABLE "clientes"
|
|
ALTER COLUMN "nome" TYPE VARCHAR(100),
|
|
ALTER COLUMN "email" TYPE VARCHAR(100),
|
|
ALTER COLUMN "cpfCnpj" TYPE VARCHAR(18),
|
|
ALTER COLUMN "rg" TYPE VARCHAR(20),
|
|
ALTER COLUMN "orgaoEmissor" TYPE VARCHAR(10),
|
|
ALTER COLUMN "estadoRg" TYPE CHAR(2),
|
|
ALTER COLUMN "telefone" TYPE VARCHAR(20),
|
|
ALTER COLUMN "instagram" TYPE VARCHAR(50),
|
|
ALTER COLUMN "cep" TYPE VARCHAR(9),
|
|
ALTER COLUMN "endereco" TYPE VARCHAR(150),
|
|
ALTER COLUMN "numero" TYPE VARCHAR(10),
|
|
ALTER COLUMN "complemento" TYPE VARCHAR(50),
|
|
ALTER COLUMN "bairro" TYPE VARCHAR(100),
|
|
ALTER COLUMN "cidade" TYPE VARCHAR(100),
|
|
ALTER COLUMN "estado" TYPE CHAR(2),
|
|
ALTER COLUMN "estadoCivil" TYPE VARCHAR(20),
|
|
ALTER COLUMN "profissao" TYPE VARCHAR(100),
|
|
ALTER COLUMN "vinculoEmpregaticio" TYPE VARCHAR(50),
|
|
ALTER COLUMN "tipoPrevidencia" TYPE VARCHAR(20),
|
|
ALTER COLUMN "nomePai" TYPE VARCHAR(100),
|
|
ALTER COLUMN "nomeMae" TYPE VARCHAR(100),
|
|
ALTER COLUMN "conjugeNome" TYPE VARCHAR(100),
|
|
ALTER COLUMN "conjugeCpf" TYPE VARCHAR(14);
|