]> git.datanom.net - liogui.git/blob - webapp/schema.sql
Completed User Administration
[liogui.git] / webapp / schema.sql
1 DROP TABLE IF EXISTS user;
2 DROP TABLE IF EXISTS permissions;
3
4 CREATE TABLE permissions (
5 id INTEGER PRIMARY KEY,
6 name TEXT NOT NULL
7 );
8
9 INSERT INTO permissions VALUES (1, 'USER');
10 INSERT INTO permissions VALUES (3, 'SUPERUSER');
11 INSERT INTO permissions VALUES (9, 'ADMIN');
12
13 CREATE TABLE user (
14 id INTEGER PRIMARY KEY AUTOINCREMENT,
15 username TEXT UNIQUE NOT NULL,
16 password TEXT NOT NULL,
17 perm INTEGER DEFAULT 1,
18 FOREIGN KEY (perm) REFERENCES permissions (id)
19 );
20
This page took 0.612229 seconds and 6 git commands to generate.