GVAX6edw

1create sequence hibernate_sequence start 1 increment 1
2
3create table message (
4    id int8 not null,
5    filename varchar(255),
6    tag varchar(255),
7    text varchar(2048) not null,
8    user_id int8,
9    primary 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
28add constraint message_user_fk
29foreign key (user_id) references usr
30
31alter table if exists user_role a
32dd constraint user_role_fk
33foreign key (user_id) references usr