Spaces:
Running
Running
File size: 781 Bytes
5c2ed06 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
CREATE TABLE friends (
user1 TEXT NOT NULL,
user2 TEXT NOT NULL,
PRIMARY KEY (user1, user2)
) WITHOUT ROWID;
CREATE TABLE friend_requests (
sender TEXT NOT NULL,
receiver TEXT NOT NULL,
sent_at INTEGER NOT NULL,
PRIMARY KEY (sender, receiver)
) WITHOUT ROWID;
CREATE TABLE friend_settings (
userid TEXT NOT NULL,
send_login_data INTEGER NOT NULL,
last_login INTEGER NOT NULL,
public_list INTEGER NOT NULL,
PRIMARY KEY (userid)
) WITHOUT ROWID;
CREATE TABLE database_settings (
name TEXT NOT NULL,
val TEXT NOT NULL,
PRIMARY KEY (name, val)
) WITHOUT ROWID;
-- set version if not exists
INSERT INTO database_settings (name, val) VALUES ('version', 0);
CREATE INDEX list ON friends (user1, user2);
CREATE INDEX request_list ON friend_requests (sender, receiver);
|