X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fschemaexport-example%2Fschema.sql;h=5c57479e623784869bd654f9f2e5583e204fd161;hp=e8f93baefe584a1592a0f65f655a2d7e171e07ee;hb=4940080670944a15916c68fb294e18a6bfef12d5;hpb=69458703cddc2aea1f67e06db43bce6950c6f3cb diff --git a/src/it/schemaexport-example/schema.sql b/src/it/schemaexport-example/schema.sql index e8f93bae..5c57479e 100644 --- a/src/it/schemaexport-example/schema.sql +++ b/src/it/schemaexport-example/schema.sql @@ -1,25 +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;