CREATE TABLE users
(
  id serial NOT NULL,
  username character varying,
  "password" character varying,
  CONSTRAINT users_pk PRIMARY KEY (id),
  CONSTRAINT username_uk UNIQUE (username)
);

insert into users("username","password") values('admin', md5('admin'));
insert into users("username","password") values('test', md5('testpwd'));