292
293
294
295
296
297
298
299
300
301
302
303
304
305
|
(
signal TEXT NOT NULL,
plugin TEXT NOT NULL REFERENCES plugins (id),
callback TEXT NOT NULL,
PRIMARY KEY (signal, plugin)
);
---------- FILES ----------------
CREATE TABLE IF NOT EXISTS files
-- Files metadata
(
id INTEGER NOT NULL PRIMARY KEY,
path TEXT NOT NULL,
|
>
>
>
>
>
>
>
>
>
>
>
>
>
|
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
|
(
signal TEXT NOT NULL,
plugin TEXT NOT NULL REFERENCES plugins (id),
callback TEXT NOT NULL,
PRIMARY KEY (signal, plugin)
);
CREATE TABLE IF NOT EXISTS api_credentials
(
id INTEGER NOT NULL PRIMARY KEY,
label TEXT NOT NULL,
key TEXT NOT NULL,
secret TEXT NOT NULL,
created TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
last_use TEXT NULL,
access_level INT NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS api_credentials_key ON api_credentials (key);
---------- FILES ----------------
CREATE TABLE IF NOT EXISTS files
-- Files metadata
(
id INTEGER NOT NULL PRIMARY KEY,
path TEXT NOT NULL,
|