[firebase-br] Erro em Script
Pedro Leonardo
pleonardomv em bol.com.br
Qua Jan 12 14:48:02 -03 2005
Pessoal oq tem de errado neste script? Estou tentando roda-lo no IBExpert
ele cria o banco mas sem a tabela REGISTRO
SET SQL DIALECT 3;
SET NAMES WIN1252;
CREATE DATABASE 'D:\PGM\Dados\Dados.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1252;
/**** Tabelas ****/
CREATE TABLE REGISTRO (
RG VARCHAR(10 ) CHARACTER SET WIN1252 NOT NULL,
NOME VARCHAR(150) CHARACTER SET WIN1252 NOT NULL,
CPF VARCHAR(15) CHARACTER SET WIN1252 NOT NULL,
CNH_CAT VARCHAR(15) CHARACTER SET WIN1252,
PRONTUARIO_CRIME VARCHAR(15) CHARACTER SET WIN1252,
PAI VARCHAR(150) CHARACTER SET WIN1252,
MAE VARCHAR(150) CHARACTER SET WIN1252,
DT_NASC DATE,
SEXO VARCHAR(10) CHARACTER SET WIN1252,
NATURALIDADE VARCHAR(100) CHARACTER SET WIN1252,
ESTADO_CIVIL VARCHAR(15) CHARACTER SET WIN1252,
PROFISSAO VARCHAR(50) CHARACTER SET WIN1252,
ENDERECO VARCHAR(150) CHARACTER SET WIN1252,
COR VARCHAR(50) CHARACTER SET WIN1252,
ALTURA NUMERIC(1,2),
OLHOS VARCHAR(50) CHARACTER SET WIN1252,
CABELOS VARCHAR(50) CHARACTER SET WIN1252,
SINAIS VARCHAR(200) CHARACTER SET WIN1252,
MODALIDADE_ACAO VARCHAR(100) CHARACTER SET WIN1252,
RUA VARCHAR(100) CHARACTER SET WIN1252,
BAIRRO VARCHAR(100) CHARACTER SET WIN1252,
CIDADE VARCHAR(150) CHARACTER SET WIN1252,
UF VARCHAR(2) CHARACTER SET WIN1252,
FONE_RES INTEGER,
FONE_COM INTEGER,
FONE_CEL INTEGER,
PATH_FOTO VARCHAR(150) CHARACTER SET WIN1252,
HISTORICO VARCHAR(250) CHARACTER SET WIN1252,
);
/**** Primary Keys ****/
ALTER TABLE REGISTRO ADD CONSTRAINT PK_REGISTRO PRIMARY KEY (RG);
/**** Triggers ****/
SET TERM ^ ;
obrigado...
Mais detalhes sobre a lista de discussão lista