1ALTER TABLE episode RENAME TO old_table;
2
3CREATE TABLE episode (
4	title	TEXT NOT NULL,
5	uri	TEXT,
6	local_uri	TEXT,
7	description	TEXT,
8	epoch	INTEGER NOT NULL DEFAULT 0,
9	length	INTEGER,
10	duration	INTEGER,
11	guid	TEXT,
12	played	INTEGER,
13	podcast_id	INTEGER NOT NULL,
14	favorite	INTEGER DEFAULT 0,
15	archive	INTEGER DEFAULT 0,
16	PRIMARY KEY (title, podcast_id)
17);
18
19INSERT INTO episode (title, uri, local_uri, description, epoch, length, duration, guid, played, favorite, archive, podcast_id)
20SELECT title, uri, local_uri, description, epoch, length, duration, guid, played, favorite, archive, podcast_id
21FROM old_table;
22
23Drop table old_table;