[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