Basic h2 usage

H2database table creation syntax none -- H2 -- log table CREATETABLElog4db (sequence number, CDATETIMESTAMP, THREADVARCHAR (62), LOGLEVELVARCHAR (16), LINESMALLINT, CLASSVARCHAR (128), MSGTEXT, primarykey (ID); -- create index C

H2database TABLE creation syntax none -- H2 -- log table create table log4db (id bigint not null auto_increment comment 'sequence No. ', cdate timestamp, thread varchar (62), loglevel varchar (16 ), line smallint, class varchar (128), msg text, primary key (ID); -- create index C

H2database table creation syntax <无>

-- H2 -- create table log4db (id bigint not null auto_increment comment 'sequence No. ', 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)