up.sql 274 Bytes
Newer Older
Gaël Berthaud-Müller's avatar
Gaël Berthaud-Müller committed
1
2
3
4
5
6
7
8
9
10
11
12
-- Your SQL goes here
CREATE TABLE localuser (
  user_id VARCHAR NOT NULL PRIMARY KEY,
  username VARCHAR NOT NULL,
  password VARCHAR NOT NULL,
  FOREIGN KEY(user_id) REFERENCES user(id)
);

CREATE TABLE user (
  id VARCHAR NOT NULL PRIMARY KEY,
  role VARCHAR NOT NULL
);