13 lines
294 B
SQL
13 lines
294 B
SQL
|
|
CREATE TABLE AppUser (
|
|
id INTEGER PRIMARY KEY,
|
|
username VARCHAR UNIQUE,
|
|
email VARCHAR UNIQUE,
|
|
password VARCHAR,
|
|
role VARCHAR
|
|
);
|
|
|
|
|
|
INSERT INTO AppUser
|
|
(username, email, password, role) VALUES ('admin', 'admin@domain.com', 'admin', 'ROLE_ADMIN');
|