nu2ZpBnN

1create sequence hibernate_sequence start 1 increment 1;
2
3create table message (
4id int8 not null,
5filename varchar(255),
6tag varchar(255) not null,
7text varchar(2048) not null,
8user_id int8,
9primary key (id)
10);
11
12create table user_role (
13  user_id int8 not null,
14  roles varchar(255)
15 );
16
17create table usr (
18  id int8 not null,
19  activation_code varchar(255),
20  active boolean not null,
21  email varchar(255),
22  password varchar(255) not null,
23  username varchar(255) not null,
24  primary key (id)
25);
26
27alter table if exists message
28  add constraint message_user_fk
29  foreign key (user_id) references usr;
30
31alter table if exists user_role
32  add constraint user_role_fk
33  foreign key (user_id) references usr;