gistfile1.txt

CREATE TABLE playlists (_id INTEGER PRIMARY KEY AUTOINCREMENT, cache_date INTEGER, pubDate INTEGER, guid VARCHAR(255), title VARCHAR(255), description VARCHAR(1024), osplaylistId INTEGER, image_url VARCHAR(1024), feed_url VARCHAR(255), feed_type INTEGER, playlist_type INTEGER, is_default INTEGER, sort_order INTEGER, UNIQUE (title, feed_url) ON CONFLICT REPLACE);


CREATE TABLE playlist_items (_id INTEGER PRIMARY KEY AUTOINCREMENT, guid VARCHAR(50), title VARCHAR(255), description VARCHAR(1024), pubDate INTEGER, duration INTEGER, regular_video_url VARCHAR(512), high_video_url VARCHAR(512), hls_video_url VARCHAR(512), thumbnail_url VARCHAR(512), more_xml VARCHAR(512), playlist_id INTEGER, UNIQUE (playlist_id, guid), FOREIGN KEY(playlist_id) REFERENCES playlists(_id) ON DELETE CASCADE);


Error inserting guid=4965352 pubDate=1347906812000 thumbnail_url=http://images.1sfx.net/1202735/1202735_DA_OTU1OTEzNTQ=.jpg duration=381000 title=World's Most Beautiful Sunrises and Sunsets more_xml=null _id=399 hls_video_url=null description=Beautiful sunrises and sunsets from around the globe. Locations include: Thailand, the Seychelles, Canyonlands National Park, Bali, the Pacific Coast and migratory birds in the National Wildlife Refuges. playlist_id=1 high_video_url=http://r.onescreen.net/f/OTU1OTEzNTA= regular_video_url=http://r.onescreen.net/f/OTU1OTEzNTA=