1ALTER TABLE episodes RENAME TO old_table;
2ALTER TABLE shows RENAME TO podcast;
3
4CREATE TABLE episode (
5  title	TEXT NOT NULL,
6  uri	TEXT,
7  local_uri	TEXT,
8  description	TEXT,
9  epoch	INTEGER NOT NULL DEFAULT 0,
10  length	INTEGER,
11  duration	INTEGER,
12  guid	TEXT,
13  played	INTEGER,
14  podcast_id	INTEGER NOT NULL,
15  PRIMARY KEY (title, podcast_id)
16);
17
18INSERT INTO episode (
19  title,
20  uri,
21  local_uri,
22  description,
23  epoch,
24  length,
25  duration,
26  guid,
27  played,
28  podcast_id
29) SELECT title,
30  uri,
31  local_uri,
32  description,
33  epoch, length,
34  duration,
35  guid,
36  played,
37  show_id
38FROM old_table;
39
40Drop table old_table;
41