h2基本用法

h2database建表语法 无 -- H2-- 日志表CREATE TABLE log4db( ID BIGINT NOT NULL auto_increment comment '序号', CDATE TIMESTAMP, THREAD VARCHAR(62), LOGLEVEL VARCHAR(16), LINE SMALLINT, CLASS VARCHAR(128), MSG TEXT, primary key(ID));-- 创建索引C

-- H2


-- 日志表
CREATE TABLE log4db
(
 ID BIGINT NOT NULL auto_increment 	comment '序号',
 CDATE TIMESTAMP,
 THREAD VARCHAR(62),
 LOGLEVEL VARCHAR(16),
 LINE SMALLINT,
 CLASS VARCHAR(128),
 MSG TEXT,
 primary key(ID)
);


-- 创建索引
CREATE INDEX log_cdate ON log4db(CDATE)

CREATE INDEX log_level ON log4db(LOGLEVEL)