[firebase-br] Comportamento Estranho firebird 2.1
Paulo Sérgo Feix
paulinhofeix em gmail.com
Qua Out 15 10:19:37 -03 2008
Bom dia
Gostaria de uma informação, no novo banco de dados que estou
construíndo firebird
2.1 esta aparecendo umas tabelas Domains estranhas que eu não criei, desta
forma a baixo
/******************************************************************************/
/* Generated by IBExpert 15/10/2008
09:16:00 */
/******************************************************************************/
/******************************************************************************/
/*
Tables */
/******************************************************************************/
CREATE TABLE FTS$_IND (
FTS$IND_NME FTS$IND_NME_DM NOT NULL /* FTS$IND_NME_DM = VARCHAR(10)
CHECK ( NOT VALUE LIKE '\_%' ESCAPE '\' ) */,
FTS$TBL_NME FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$KEY_COL FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$AUX_COL FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$SCH_COL FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$SCH_LEN FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>= 10 ) OR ( VALUE IS NULL )) */,
FTS$WRD_LEN FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>= 10 ) OR ( VALUE IS NULL )) */,
FTS$USR_LEN FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>= 10 ) OR ( VALUE IS NULL )) */,
FTS$MIN_LEN FTS$MIN_LEN_DM NOT NULL /* FTS$MIN_LEN_DM = SMALLINT CHECK
(( VALUE BETWEEN 1 AND 9 ) OR ( VALUE IS NULL )) */,
FTS$KEY_DM FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$KEY_TYP FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$KEY_IND FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$WDS_TYP FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
FTS$STATUS FTS$IND_STATUS_DM NOT NULL /* FTS$IND_STATUS_DM =
VARCHAR(2) CHECK ( VALUE IN ( 'IP', /* INACTIVE PENDING . */
'IC', /* INACTIVE CORRUPTED . */
'I', /* INACTIVE . */
'MP', /* META LOADED PENDING . */
'MC', /* META CORRUPTED . */
'M', /* META LOADED . */
'LP', /* DATA LOADED PENDING . */
'LC', /* DATA LOADED CORRUPTED . */
'L', /* DATA LOADED . */
'AP', /* ACTIVE PENDING . */
'AC', /* ACTIVE CORRUPTED . */
'A' )) */,
FTS$LOG FTS$BOOLEAN_DM NOT NULL /* FTS$BOOLEAN_DM = CHAR(1) CHECK
(( VALUE IN ( 'T', 'F' )) OR ( VALUE IS NULL )) */
);
/******************************************************************************/
/* Primary
Keys */
/******************************************************************************/
ALTER TABLE FTS$_IND ADD CONSTRAINT FTS$PK__IND PRIMARY KEY (FTS$IND_NME);
/******************************************************************************/
/*
Privileges */
/******************************************************************************/
/* Privileges of users */
GRANT ALL ON FTS$_IND TO PUBLIC;
-----------------------------------------
CREATE DOMAIN FTS$BOOLEAN_DM AS
CHAR(1) CHARACTER SET ISO8859_1
CHECK (( VALUE IN ( 'T', 'F' )) OR ( VALUE IS NULL ))
COLLATE ISO8859_1;
----------------------------------------------------
CREATE DOMAIN FTS$IND_STATUS_DM AS
VARCHAR(2) CHARACTER SET ISO8859_1
CHECK (VALUE IN ( 'IP', /* INACTIVE PENDING . */
'IC', /* INACTIVE CORRUPTED . */
'I', /* INACTIVE . */
'MP', /* META LOADED PENDING . */
'MC', /* META CORRUPTED . */
'M', /* META LOADED . */
'LP', /* DATA LOADED PENDING . */
'LC', /* DATA LOADED CORRUPTED . */
'L', /* DATA LOADED . */
'AP', /* ACTIVE PENDING . */
'AC', /* ACTIVE CORRUPTED . */
'A' ))
COLLATE ISO8859_1;
--
Paulinho Sérgio Feix
Mais detalhes sobre a lista de discussão lista