-
- 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;