· 8 years ago · Dec 18, 2017, 02:40 PM
1CREATE TABLE IF NOT EXISTS users
2(
3 "id" SERIAL PRIMARY KEY,
4 "username" varchar(30) DEFAULT NULL,
5 "password" varchar(30) DEFAULT NULL,
6 "enabled" boolean,
7 "authorities" varchar(30) DEFAULT NULL
8);
9
10INSERT INTO users(username, password, enabled, authorities) VALUES ('admin', 'admin', 'true', 'ROLE_USER');