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;