【SQL开源代码栏目提醒】:本文主要为网学会员提供001_createSchemaVersionTable.hsqldb.sql,希望对需要001_createSchemaVersionTable.hsqldb.sql网友有所帮助,学习一下!
CREATE TABLE changelog (
change_number INTEGER NOT NULL,
delta_set VARCHAR(10) NOT NULL,
start_dt TIMESTAMP NOT NULL,
complete_dt TIMESTAMP NULL,
applied_by VARCHAR(100) NOT NULL,
description VARCHAR(500) NOT NULL
);
ALTER TABLE changelog ADD CONSTRAINT Pkchangelog PRIMARY KEY (change_number, delta_set)
;