· 8 years ago · May 12, 2018, 05:14 AM
1drop table if exists "users";
2create table "users" (
3 id bigint not null,
4 username varchar(255) not null,
5 password varchar(255) not null,
6 groups varchar(255),
7 constraint pk_id primary key(id)
8);
9
10drop sequence if exists users_seq;
11create sequence users_seq minvalue 0 increment by 1 start with 0 no cycle;
12
13insert into users (id, username, password, groups)
14values (nextval('users_seq'), 'avarus', 'meinPassword', 'admin,reseller,user');