h2基本用法

-- 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)