时间:2021-07-01 10:21:17 帮助过:34人阅读
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
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)
- );
- -- 创建索引
- CREATE INDEX log_cdate ON log4db(CDATE)
- CREATE INDEX log_level ON log4db(LOGLEVEL)