[firebase-br] Comportamento Estranho firebird 2.1

[Carlos H. Cantu]

Isso não tem nada a ver com o FB 2.1

Olhando o nome das tabelas, e se vc usa IBO, acredito que vc testou o
recurso de FullTextSearch (FTS) dele, que pra funcionar tem que criar
diversas tabelas, etc. no banco.

[]s
Carlos H. Cantu
www.warmboot.com.br - www.firebirdnews.org
www.FireBase.com.br - blog.firebase.com.br

PSF> Bom dia
PSF> Gostaria de uma informação, no novo banco de dados que estou
PSF> construíndo firebird
PSF> 2.1 esta aparecendo umas tabelas Domains  estranhas que eu não criei, desta
PSF> forma a baixo

PSF> /******************************************************************************/
PSF> /*                 Generated by IBExpert 15/10/2008
PSF> 09:16:00                  */
PSF> /******************************************************************************/

PSF> /******************************************************************************/
PSF> /*
PSF> Tables                                   */
PSF> /******************************************************************************/

PSF> CREATE TABLE FTS$_IND (
PSF>     FTS$IND_NME  FTS$IND_NME_DM NOT NULL /* FTS$IND_NME_DM = VARCHAR(10)
PSF> CHECK ( NOT VALUE LIKE '\_%' ESCAPE '\' ) */,
PSF>     FTS$TBL_NME  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$KEY_COL  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$AUX_COL  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$SCH_COL  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$SCH_LEN  FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>>= 10 ) OR ( VALUE IS NULL )) */,
PSF>     FTS$WRD_LEN  FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>>= 10 ) OR ( VALUE IS NULL )) */,
PSF>     FTS$USR_LEN  FTS$LEN_DM NOT NULL /* FTS$LEN_DM = SMALLINT CHECK (( VALUE
>>= 10 ) OR ( VALUE IS NULL )) */,
PSF>     FTS$MIN_LEN  FTS$MIN_LEN_DM NOT NULL /* FTS$MIN_LEN_DM = SMALLINT CHECK
PSF> (( VALUE BETWEEN 1 AND 9 ) OR ( VALUE IS NULL )) */,
PSF>     FTS$KEY_DM   FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$KEY_TYP  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$KEY_IND  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$WDS_TYP  FTS$IDENT_DM NOT NULL /* FTS$IDENT_DM = VARCHAR(32) */,
PSF>     FTS$STATUS   FTS$IND_STATUS_DM NOT NULL /* FTS$IND_STATUS_DM =
PSF> VARCHAR(2) CHECK ( VALUE IN ( 'IP',   /* INACTIVE PENDING      . */
PSF>                      'IC',   /* INACTIVE CORRUPTED    . */
PSF>                      'I',    /* INACTIVE              . */
PSF>                      'MP',   /* META LOADED PENDING   . */
PSF>                      'MC',   /* META CORRUPTED        . */
PSF>                      'M',    /* META LOADED           . */
PSF>                      'LP',   /* DATA LOADED PENDING   . */
PSF>                      'LC',   /* DATA LOADED CORRUPTED . */
PSF>                      'L',    /* DATA LOADED           . */
PSF>                      'AP',   /* ACTIVE PENDING        . */
PSF>                      'AC',   /* ACTIVE CORRUPTED      . */
PSF>                      'A' )) */,
PSF>     FTS$LOG      FTS$BOOLEAN_DM NOT NULL /* FTS$BOOLEAN_DM = CHAR(1) CHECK
PSF> (( VALUE IN ( 'T', 'F' )) OR ( VALUE IS NULL )) */
PSF> );


PSF> /******************************************************************************/
PSF> /*                                Primary
PSF> Keys                                */
PSF> /******************************************************************************/
PSF> ALTER TABLE FTS$_IND ADD CONSTRAINT FTS$PK__IND PRIMARY KEY (FTS$IND_NME);

PSF> /******************************************************************************/
PSF> /*
PSF> Privileges                                 */
PSF> /******************************************************************************/

PSF> /* Privileges of users */
PSF> GRANT ALL ON FTS$_IND TO PUBLIC;
PSF> -----------------------------------------
PSF> CREATE DOMAIN FTS$BOOLEAN_DM AS
PSF> CHAR(1) CHARACTER SET ISO8859_1
PSF> CHECK (( VALUE IN ( 'T', 'F' )) OR ( VALUE IS NULL ))
PSF> COLLATE ISO8859_1;
PSF> ----------------------------------------------------
PSF> CREATE DOMAIN FTS$IND_STATUS_DM AS
PSF> VARCHAR(2) CHARACTER SET ISO8859_1
PSF> CHECK (VALUE IN ( 'IP',   /* INACTIVE PENDING      . */
PSF>                      'IC',   /* INACTIVE CORRUPTED    . */
PSF>                      'I',    /* INACTIVE              . */
PSF>                      'MP',   /* META LOADED PENDING   . */
PSF>                      'MC',   /* META CORRUPTED        . */
PSF>                      'M',    /* META LOADED           . */
PSF>                      'LP',   /* DATA LOADED PENDING   . */
PSF>                      'LC',   /* DATA LOADED CORRUPTED . */
PSF>                      'L',    /* DATA LOADED           . */
PSF>                      'AP',   /* ACTIVE PENDING        . */
PSF>                      'AC',   /* ACTIVE CORRUPTED      . */
PSF>                      'A' ))
PSF> COLLATE ISO8859_1;