-
Notifications
You must be signed in to change notification settings - Fork 5
/
schema.go
43 lines (37 loc) · 913 Bytes
/
schema.go
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
34
35
36
37
38
39
40
41
42
43
package store
const DB_SCHEMA string = `
create table if not exists users (
id integer not null primary key autoincrement,
username text,
api_key text
);
create table if not exists windowLogs (
id integer not null primary key autoincrement,
uid integer,
time integer,
name text,
foreign key (uid) references users(id)
);
create table if not exists keyLogs (
id integer not null primary key autoincrement,
uid integer,
time integer,
count integer,
foreign key (uid) references users(id)
);
create table if not exists notes (
id integer not null primary key autoincrement,
uid integer,
time integer,
type integer,
contents text,
foreign key (uid) references users(id)
);
INSERT INTO users
(id, username, api_key)
SELECT 1, 'admin', 'deadbeefcafe'
WHERE
NOT EXISTS (
SELECT id FROM users WHERE id = 1
);
`