create sequence hibernate_sequence minvalue 100;

create table users (
    id          integer primary key,
    username    varchar(255) unique,
    password    varchar(255),
    enabled     boolean not null default 't'
);

-- {noop} tells Spring Security that the password is not encrypted.
insert into users values (1, 'admin', '{noop}1234', 't');
insert into users values (2, 'cysun', '{noop}abcd', 't');

create table authorities (
    username    varchar(255) not null references users(username),
    authority   varchar(255)
);

insert into authorities values('admin', 'ROLE_ADMIN');
insert into authorities values('cysun', 'ROLE_USER');