RadioDownloader/store.sql at master · ribbons/RadioDownloader · GitHub

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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
/*
 * Copyright © 2007-2019 Matt Robinson
 *
 * SPDX-License-Identifier: GPL-3.0-or-later
 */

BEGIN TRANSACTION;

CREATE TABLE images
(
    imgid integer NOT NULL PRIMARY KEY AUTOINCREMENT,
    image blob
);

CREATE TABLE subscriptions
(
    progid integer UNIQUE NOT NULL REFERENCES programmes(progid)
);

CREATE TABLE favourites
(
    progid integer UNIQUE NOT NULL REFERENCES programmes(progid)
);

CREATE TABLE settings
(
    property varchar NOT NULL COLLATE nocase PRIMARY KEY,
    value varchar NOT NULL
);

CREATE TABLE tempfiles
(
    filepath varchar NOT NULL PRIMARY KEY
);

CREATE TABLE downloads
(
    epid integer UNIQUE NOT NULL REFERENCES episodes(epid),
    status integer NOT NULL DEFAULT 0,
    filepath varchar,
    errorcount integer NOT NULL DEFAULT 0,
    totalerrors integer NOT NULL DEFAULT 0,
    errortime datetime,
    errordetails varchar,
    playcount integer NOT NULL DEFAULT 0,
    errortype integer
);

CREATE TABLE programmes
(
    progid integer NOT NULL PRIMARY KEY AUTOINCREMENT,
    pluginid varchar NOT NULL,
    extid varchar NOT NULL,
    name varchar NOT NULL,
    lastupdate datetime,
    image integer REFERENCES images(imgid),
    description varchar,
    singleepisode NOT NULL DEFAULT 0,
    latestdownload datetime,
    UNIQUE (pluginid, extid)
);

CREATE TABLE episodes
(
    epid integer NOT NULL PRIMARY KEY AUTOINCREMENT,
    progid integer NOT NULL REFERENCES programmes(progid) ON DELETE CASCADE,
    extid varchar NOT NULL,
    name varchar NOT NULL,
    description varchar,
    duration integer,
    date datetime NOT NULL,
    image integer REFERENCES images(imgid),
    autodownload integer NOT NULL DEFAULT 1,
    available integer NOT NULL DEFAULT 0,
    UNIQUE (progid, extid)
);

CREATE TABLE episodeext
(
    epid integer NOT NULL REFERENCES episodes(epid) ON DELETE CASCADE,
    name varchar NOT NULL,
    value varchar NOT NULL,
    PRIMARY KEY (epid, name)
);

CREATE TABLE chapters
(
    epid integer NOT NULL REFERENCES episodes(epid) ON DELETE CASCADE,
    start integer NOT NULL,
    name varchar NOT NULL,
    link varchar,
    image integer REFERENCES images(imgid),
    PRIMARY KEY (epid, start)
);

COMMIT;