26 lines
527 B
SQL
26 lines
527 B
SQL
|
|
|
|
|
|
CREATE TABLE AppUser (
|
|
id INTEGER PRIMARY KEY,
|
|
username VARCHAR UNIQUE,
|
|
email VARCHAR UNIQUE,
|
|
password VARCHAR,
|
|
role VARCHAR
|
|
);
|
|
|
|
|
|
CREATE TABLE Monitoring (
|
|
id INTEGER PRIMARY KEY,
|
|
name VARCHAR,
|
|
samplerate VARCHAR,
|
|
sampleperiod VARCHAR,
|
|
downtime VARCHAR,
|
|
status VARCHAR,
|
|
created_at VARCHAR
|
|
);
|
|
|
|
|
|
INSERT INTO AppUser
|
|
(username, email, password, role) VALUES ('admin', 'admin@domain.com', 'admin', 'ROLE_ADMIN');
|