18 lines
342 B
SQL
18 lines
342 B
SQL
|
|
-- Anisette list
|
|
CREATE TABLE IF NOT EXISTS list (
|
|
lid INTEGER PRIMARY KEY,
|
|
url TEXT UNIQUE NOT NULL
|
|
);
|
|
|
|
-- Anisette server entry in list
|
|
CREATE TABLE IF NOT EXISTS server (
|
|
sid INTEGER PRIMARY KEY,
|
|
list INTEGER NOT NULL,
|
|
name TEXT NOT NULL,
|
|
url TEXT NOT NULL,
|
|
UNIQUE (name, url),
|
|
FOREIGN KEY (list) REFERENCES list(lid)
|
|
);
|
|
|