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