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;