store.sql

/*
 * This file is part of Radio Downloader.
 * Copyright © 2007-2018 by the authors - see the AUTHORS file for details.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

BEGIN TRANSACTION;

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

CREATE TABLE subscriptions
(
    progid integer UNIQUE NOT NULL
);

CREATE TABLE favourites
(
    progid integer UNIQUE NOT NULL
);

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,
    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,
    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,
    extid varchar NOT NULL,
    name varchar NOT NULL,
    description varchar,
    duration integer,
    date datetime NOT NULL,
    image integer,
    autodownload integer NOT NULL DEFAULT 1,
    available integer NOT NULL DEFAULT 0,
    UNIQUE (progid, extid)
);

CREATE TABLE episodeext
(
    epid integer NOT NULL,
    name varchar NOT NULL,
    value varchar NOT NULL,
    PRIMARY KEY (epid, name)
);

CREATE TABLE chapters
(
    epid integer NOT NULL,
    start integer NOT NULL,
    name varchar NOT NULL,
    link varchar,
    image integer,
    PRIMARY KEY (epid, start)
);

COMMIT;