This repository has been archived by the owner on Jul 22, 2020. It is now read-only.
/
create_db.sql
51 lines (51 loc) · 1.77 KB
/
create_db.sql
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
44
45
46
47
48
49
50
51
BEGIN TRANSACTION;
CREATE TABLE "table_settings_sonarr" (
`ip` TEXT NOT NULL,
`port` INTEGER NOT NULL,
`base_url` TEXT,
`ssl` INTEGER,
`apikey` TEXT,
`enabled` INTEGER
);
INSERT INTO `table_settings_sonarr` (ip,port,base_url,ssl,apikey,enabled) VALUES ('127.0.0.1',8989,'/','False','',NULL);
CREATE TABLE "table_settings_radarr" (
`ip` TEXT NOT NULL,
`port` INTEGER NOT NULL,
`base_url` TEXT,
`ssl` INTEGER,
`apikey` TEXT,
`enabled` INTEGER
);
INSERT INTO `table_settings_radarr` (ip,port,base_url,ssl,apikey,enabled) VALUES ('127.0.0.1',7878,'/','False','',NULL);
CREATE TABLE "table_settings_plex" (
`ip` TEXT NOT NULL,
`port` INTEGER NOT NULL,
`base_url` TEXT,
`ssl` INTEGER,
`username` TEXT,
`password` TEXT,
`enabled` INTEGER
);
INSERT INTO `table_settings_plex` (ip,port,base_url,ssl,username,password,enabled) VALUES ('127.0.0.1',32400,'/','False','','',NULL);
CREATE TABLE "table_settings_general" (
`ip` TEXT NOT NULL,
`port` INTEGER NOT NULL,
`base_url` TEXT,
`log_level` TEXT,
`branch` TEXT,
`auto_update` INTEGER,
`configured` "integer",
`updated` "integer"
);
INSERT INTO `table_settings_general` (ip,port,base_url,log_level,branch,auto_update,configured,updated) VALUES ('0.0.0.0',5656,'/','INFO','master','True',0,0);
CREATE TABLE "table_settings_emby" ( `ip` TEXT NOT NULL, `port` INTEGER NOT NULL, `base_url` TEXT, `ssl` INTEGER, `userid` TEXT,`apikey` TEXT, `enabled` INTEGER );
INSERT INTO `table_settings_emby` (ip,port,base_url,ssl,userid,apikey,enabled) VALUES ('127.0.0.1',8096,'/','False','','',NULL);
CREATE TABLE "table_settings_bazarr" (
`ip` TEXT NOT NULL,
`port` INTEGER NOT NULL,
`base_url` TEXT,
`apikey` TEXT,
`enabled` INTEGER
);
INSERT INTO `table_settings_bazarr` (ip,port,base_url,apikey,enabled) VALUES ('127.0.0.1',6767,'/','',NULL);
COMMIT;