일반 Pure Java DB (H2 Database)

SET WRITE_DELAY 0;
SET CLUSTER '';
SET DEFAULT_TABLE_TYPE 0;
SET DEFAULT_LOCK_TIMEOUT 2000;
SET CACHE_SIZE 16384;

CREATE USER IF NOT EXISTS SA SALT 'f8752c85c729c186' HASH '883ecfdc106537ace2e018d70b96f50779fcc98fad6150910f3890ac568d9292' ADMIN;

DROP TABLE IF EXISTS PUBLIC.USERINFO;
DROP TABLE IF EXISTS PUBLIC.AUTHORITIES;
DROP TABLE IF EXISTS PUBLIC.EMPLOYEE;

CREATE TABLE PUBLIC.USERINFO(USERNAME VARCHAR(50) NOT NULL PRIMARY KEY,PASSWORD VARCHAR(50) NOT NULL,ENABLED INTEGER DEFAULT 0 NOT NULL);
CREATE TABLE PUBLIC.AUTHORITIES(USERNAME VARCHAR(12) NOT NULL,AUTHORITY VARCHAR(20) NOT NULL);
CREATE TABLE PUBLIC.EMPLOYEE(EMP_NAME VARCHAR(64),PASSWORD VARCHAR(64),EMAIL VARCHAR(64));

INSERT INTO PUBLIC.USERINFO(USERNAME, PASSWORD, ENABLED) VALUES
('admin','admin',1),
('kim','kim',0),
('son','son',1),
('user','user',1);

INSERT INTO PUBLIC.AUTHORITIES(USERNAME, AUTHORITY) VALUES
('admin','ADMIN'),
('admin','USER'),
('user','USER'),
('son','ADMIN'),
('son','USER'),
('kim','USER');

INSERT INTO PUBLIC.EMPLOYEE(EMP_NAME, PASSWORD, EMAIL) VALUES
('admin','admin','admin@gmail.com'),
('user','user','user@gmail.com'),
('son','son','son@gmail.com');