SELECT NAME FROM REGIONS WHERE SKIP <> 1

DROP COLLATION NOCASE_COLL;

CREATE COLLATION NOCASE_COLL FOR WIN1251 FROM PXW_CYRL CASE INSENSITIVE;

SELECT FIRST 1 ID FROM REGIONS WHERE NAME = :SNAME AND SKIP IS DISTINCT FROM 1

CREATE TABLE REGIONS (
    ID                  "INT" NOT NULL /* "INT" = INTEGER */,
    PARENT              "INT" NOT NULL /* "INT" = INTEGER */,
    NAME                STRING50 NOT NULL COLLATE NOCASE_COLL /* STRING50 = VARCHAR(50) */,
    CCOUNT              "INT" DEFAULT 0 NOT NULL /* "INT" = INTEGER */,
    SORTINDEX           "INT" DEFAULT 0 NOT NULL /* "INT" = INTEGER */,
    IMAGEINDEX          "INT" DEFAULT -1 NOT NULL /* "INT" = INTEGER */,
    STATEINDEX          "INT" DEFAULT -1 NOT NULL /* "INT" = INTEGER */,
    FULLPATH            STRING255 NOT NULL COLLATE PXW_CYRL /* STRING255 = VARCHAR(255) */,
    SKIP FIB$BOOLEAN /* FIB$BOOLEAN = SMALLINT DEFAULT 0 NOT NULL CHECK (VALUE IN (0,1,NULL)) */
);