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