X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fschemaexport-example%2Fschema.sql;h=5c57479e623784869bd654f9f2e5583e204fd161;hp=bd7142cdb29ce7823dc2dc2a114bef1dead17e4b;hb=4940080670944a15916c68fb294e18a6bfef12d5;hpb=fdda82a6f76deefd10f83da89d7e82054e3c3ecd diff --git a/src/it/schemaexport-example/schema.sql b/src/it/schemaexport-example/schema.sql index bd7142cd..5c57479e 100644 --- a/src/it/schemaexport-example/schema.sql +++ b/src/it/schemaexport-example/schema.sql @@ -1,26 +1,21 @@ - alter table Employee - drop constraint FK_12v0w2dqasbw95xtn8qc2uj83; - - drop table ABTEILUNG if exists; - - drop table Employee if exists; + create sequence hibernate_sequence start with 1 increment by 1; create table ABTEILUNG ( - OID bigint generated by default as identity (start with 1), + OID bigint not null, gender varchar(255), name varchar(255) not null, primary key (OID) ); create table Employee ( - OID bigint generated by default as identity (start with 1), - name varchar(81) not null, + OID bigint not null, + name varchar(255) not null, FK_department bigint, primary key (OID) ); alter table Employee - add constraint FK_12v0w2dqasbw95xtn8qc2uj83 + add constraint FKps0mm7o60mrhle838yeh1u1rh foreign key (FK_department) references ABTEILUNG;