]>
git.datanom.net - liogui.git/blob - webapp/schema.sql
1 DROP TABLE IF EXISTS user;
2 DROP TABLE IF EXISTS permissions
;
4 CREATE TABLE permissions (
5 id INTEGER PRIMARY KEY,
9 INSERT INTO permissions
VALUES (1, 'USER');
10 INSERT INTO permissions
VALUES (3, 'SUPERUSER');
11 INSERT INTO permissions
VALUES (9, 'ADMIN');
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)
This page took 0.612229 seconds and 6 git commands to generate.