pdo bug - db sql code

/******************************************************************************/
/***          Generated by IBExpert 2011.09.05 02.05.2012 10:22:51          ***/
/******************************************************************************/

SET SQL DIALECT 3;

SET NAMES WIN1251;

CREATE DATABASE 'server_cru:f:\sqlbase\niokr\niokr2.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251;



/******************************************************************************/
/***                                Domains                                 ***/
/******************************************************************************/

CREATE DOMAIN DOM_DATETIME AS
TIMESTAMP
NOT NULL;

CREATE DOMAIN DOM_INTNULL AS
INTEGER;

CREATE DOMAIN DOM_NAME AS
VARCHAR(255) CHARACTER SET WIN1251
NOT NULL;

CREATE DOMAIN DOM_STR255 AS
VARCHAR(255) CHARACTER SET WIN1251
NOT NULL;

CREATE DOMAIN DOM_TEXT AS
BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET WIN1251;

CREATE DOMAIN DOM_YEAR AS
INTEGER
NOT NULL;

CREATE DOMAIN TKEY AS
INTEGER
NOT NULL;



/******************************************************************************/
/***                               Generators                               ***/
/******************************************************************************/

CREATE GENERATOR GEN_KEY;
SET GENERATOR GEN_KEY TO 6505;



/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/



CREATE TABLE TB_NIOKR (
    ID          TKEY NOT NULL,
    NIOKR_TYPE  TKEY,
    INV_NO      DOM_NAME DEFAULT '',
    NAME        DOM_TEXT,
    CREATOR     DOM_NAME DEFAULT ' ',
    N_DOG       DOM_NAME DEFAULT '',
    AUTHOR      DOM_NAME DEFAULT '',
    AYEAR       DOM_NAME DEFAULT '',
    CITY        DOM_NAME DEFAULT '',
    ACOUNT      DOM_NAME DEFAULT 0,
    GRIF        DOM_NAME DEFAULT '',
    ACOMMENT    DOM_TEXT,
    ANNOTATION  DOM_TEXT
);




/******************************************************************************/
/***                              Primary Keys                              ***/
/******************************************************************************/

ALTER TABLE TB_NIOKR ADD CONSTRAINT PK_TB_NIOKR PRIMARY KEY (ID);


/******************************************************************************/
/***                                Triggers                                ***/
/******************************************************************************/


SET TERM ^ ;



/******************************************************************************/
/***                          Triggers for tables                           ***/
/******************************************************************************/



/* Trigger: TB_NIOKR_BI */
CREATE TRIGGER TB_NIOKR_BI FOR TB_NIOKR
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.id IS NULL) THEN
    NEW.id = gen_id(gen_key,1);
END
^


SET TERM ; ^



/******************************************************************************/
/***                          Fields descriptions                           ***/
/******************************************************************************/

DESCRIBE FIELD NIOKR_TYPE TABLE TB_NIOKR
'0 - отчеты по никор и окр
1 - чертежи
2 - НИР
3 - раб. проект';



/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/


/* Privileges of users */
GRANT SELECT ON RDB$ROLES TO PUBLIC;
GRANT ALL ON TB_NIOKR TO USER_NIOKR;
GRANT ALL ON TB_TEST TO USER_NIOKR;

/* Privileges of triggers */
GRANT UPDATE, REFERENCES ON TB_NIOKR TO TRIGGER TB_NIOKR_BI;
GRANT UPDATE, REFERENCES ON TB_TEST TO TRIGGER TB_TEST_BI;