gbase建表语句

CREATE TABLE mztj:fs_img_bd (
	b_key LVARCHAR(255) NOT NULL,
	b_content BLOB,
	b_extention LVARCHAR(255),
	updatetime DATE,
	PRIMARY KEY (b_key) CONSTRAINT u815_801
)
 in datadbs1 ;


CREATE TABLE mztj:des_sys_formdefine (
	fm_key NVARCHAR(160) NOT NULL,
	fm_title LVARCHAR(800),
	fm_order NVARCHAR(40),
	fm_version NVARCHAR(80),
	fm_level NVARCHAR(20),
	fm_updatetime DATETIME YEAR TO SECOND DEFAULT current,
	fm_code NVARCHAR(80),
	fm_sub_title LVARCHAR(1600),
	fm_desc LVARCHAR(4000),
	fm_serial_number NVARCHAR(80),
	fm_gather_type INTEGER,
	fm_unit LVARCHAR(2000),
	fm_secret_level INTEGER,
	fm_type INTEGER,
	fm_condition LVARCHAR(2000),
	fm_period_type INTEGER,
	fm_guide LVARCHAR(8000),
	fm_view_type INTEGER,
	fm_big_data_changed INTEGER,
	fm_master_key LVARCHAR(1600),
	fm_readonly_condition LVARCHAR(2000),
	fm_hidden_entity LVARCHAR(1600),
	fm_extends INTEGER,
	fm_quote_type INTEGER,
	fm_analysis_form INTEGER DEFAULT 0,
	fm_ledger_form INTEGER DEFAULT 0,
	fm_formextensions CLOB,
	fm_automatically_due_type INTEGER DEFAULT 0,
	fm_automatically_due_days INTEGER DEFAULT 0,
	fm_automatic_termination INTEGER DEFAULT 1,
	PRIMARY KEY (fm_key) CONSTRAINT pk_des_sys_formdefine
)
 in datadbs1 ;