drop table if exists gmms2_task;
drop table if exists gmms2_user;

create table gmms2_task (
	id bigint,
	title varchar(128) not null,
	description varchar(255),
	user_id bigint not null,
    primary key (id)
);

create table gmms2_user (
	id bigint,
	login_name varchar(64) not null unique,
	name varchar(64) not null,
	password varchar(255) not null,
	salt varchar(64) not null,
	roles varchar(255) not null,
	register_date timestamp not null,
	primary key (id)
);


create sequence gmms2_seq_task start with 100 increment by 20;
create sequence gmms2_seq_user start with 100 increment by 20;