git.iko.soy/maciek134/podphoenix
on main help sign in
maciek134/podphoenix/migration.sql
55 lines 1.4 kB history raw
1CREATE TABLE IF NOT EXISTS Podcast (
2 artist text,
3 name text,
4 description text,
5 feed text,
6 image text,
7 lastupdate timestamp
8);
10CREATE INDEX podcast_feed ON Podcast (feed);
11CREATE INDEX podcast_lastupdate ON Podcast (lastupdate);
14CREATE TABLE IF NOT EXISTS Episode (
15 guid text,
16 podcast integer,
17 name text,
18 subtitle text,
19 description text,
20 duration integer,
21 audiourl text,
22 downloadedfile text,
23 published timestamp,
24 queued boolean,
25 listened boolean,
26 favourited boolean,
27 position integer,
28 FOREIGN KEY (podcast) REFERENCES Podcast (rowid)
29);
31CREATE INDEX episode_guid ON Episode (guid);
32CREATE INDEX episode_podcast ON Episode (podcast);
33CREATE INDEX episode_published ON Episode (published);
34CREATE INDEX episode_queued ON Episode (queued);
35CREATE INDEX episode_listened ON Episode (listened);
36CREATE INDEX episode_favourited ON Episode (favourited);
37CREATE INDEX episode_position ON Episode (position);
38CREATE INDEX episode_downloadedfile ON Episode (downloadedfile);
39CREATE INDEX episode_name ON Episode (name);
42CREATE TABLE IF NOT EXISTS Queue (
43 position integer,
44 ind integer NOT NULL,
45 guid text,
46 image text,
47 name text,
48 artist text,
49 url text
50);
52CREATE INDEX queue_position ON Queue (position);
53CREATE INDEX queue_ind ON Queue (ind);
54CREATE INDEX queue_guid ON Queue (guid);
55CREATE INDEX queue_url ON Queue (url);