/* Server version: LI-V6.3.3.18185 Firebird 2.1 
SET CLIENTLIB 'C:\Programme\Firebird\Firebird_2_1\bin\fbclient.dll';
   SQLDialect: 3. ODS: 11.1. Forced writes: Off. Sweep inteval: 20000.
   Page size: 16384. Cache pages: 2048 (32768 Kb). Read-only: False. */

SET SQL DIALECT 3;


SET AUTODDL ON;

/* Create Table... */
CREATE TABLE BLOBTEST(BLOBTESTID INTEGER DEFAULT 0 NOT NULL,
TEXTBLOB BLOB SUB_TYPE 1,
BINAERBLOB BLOB);


CREATE TABLE TEST(ISO_CHAR VARCHAR(250) CHARACTER SET ISO8859_1,
UTF8_CHAR VARCHAR(250),
UTF8_CHAR_1 VARCHAR(250));



/* Create Primary Key... */
ALTER TABLE BLOBTEST ADD CONSTRAINT PK_BLOBTEST PRIMARY KEY (BLOBTESTID);

/* Create(Add) Crant */
GRANT ALL ON BLOBTEST TO SYSDBA WITH GRANT OPTION;

GRANT ALL ON TEST TO SYSDBA WITH GRANT OPTION;


