--- /dev/null
+
+ drop table EVENTS if exists;
+
+ drop table EVENTS_AUD if exists;
+
+ drop table REVINFO if exists;
+
+ create table EVENTS (
+ id bigint not null,
+ EVENT_DATE timestamp,
+ title varchar(255),
+ primary key (id)
+ );
+
+ create table EVENTS_AUD (
+ id bigint not null,
+ REV integer not null,
+ REVTYPE tinyint,
+ EVENT_DATE timestamp,
+ title varchar(255),
+ primary key (id, REV)
+ );
+
+ create table REVINFO (
+ REV integer generated by default as identity,
+ REVTSTMP bigint,
+ primary key (REV)
+ );
+
+ alter table EVENTS_AUD
+ add constraint FK_3hegaqrrpmx0jj0c8qacjtira
+ foreign key (REV)
+ references REVINFO;