1 2 3 4 5 6 7 8 9 10 11
| [...]
2018-12-11 11:46:12 - drop table role if exists
2018-12-11 11:46:12 - drop table user_role if exists
2018-12-11 11:46:12 - drop table utilisateur if exists
2018-12-11 11:46:12 - create table role (role_id integer generated by default as identity, role_name varchar(255) not null, primary key (role_id))
2018-12-11 11:46:12 - create table user_role (user_id bigint not null, role_id integer not null, primary key (user_id, role_id))
2018-12-11 11:46:12 - create table utilisateur (user_id bigint generated by default as identity, user_active integer not null, login varchar(255) not null, user_password varchar(255) not null, primary key (user_id))
2018-12-11 11:46:12 - alter table utilisateur add constraint UK_18vwp4resqussqmlpqnymfqxk unique (login)
2018-12-11 11:46:12 - alter table user_role add constraint FKa68196081fvovjhkek5m97n3y foreign key (role_id) references role
2018-12-11 11:46:12 - alter table user_role add constraint FK1adslu3s4xgk5eemf54qxm908 foreign key (user_id) references utilisateur
[...] |
Partager