Skip to content

Instantly share code, notes, and snippets.

@jonathanyee

jonathanyee/gist:3751767

Created September 19, 2012 19:41
Show Gist options
  • Save jonathanyee/3751767 to your computer and use it in GitHub Desktop.
Save jonathanyee/3751767 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
String createPlaylistItemsTable = "CREATE TABLE " + PlaylistItems.TABLE_NAME + " ("
+ PlaylistItems.COLUMN_NAME_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ PlaylistItems.COLUMN_NAME_GUID + " VARCHAR(50), " + PlaylistItems.COLUMN_NAME_TITLE
+ " VARCHAR(255), " + PlaylistItems.COLUMN_NAME_DESCRIPTION + " VARCHAR(1024), "
+ PlaylistItems.COLUMN_NAME_PUB_DATE + " INTEGER, " + PlaylistItems.COLUMN_NAME_DURATION
+ " INTEGER, " + PlaylistItems.COLUMN_NAME_REGULAR_VIDEO_URL + " VARCHAR(512), "
+ PlaylistItems.COLUMN_NAME_HIGH_VIDEO_URL + " VARCHAR(512), "
+ PlaylistItems.COLUMN_NAME_HLS_VIDEO_URL + " VARCHAR(512), "
+ PlaylistItems.COLUMN_NAME_THUMBNAIL_URL + " VARCHAR(512), " + PlaylistItems.COLUMN_NAME_MORE_XML
+ " VARCHAR(512), " + PlaylistItems.COLUMN_NAME_PLAYLIST_ID + " INTEGER, UNIQUE ("
+ PlaylistItems.COLUMN_NAME_PLAYLIST_ID + ", " + PlaylistItems.COLUMN_NAME_GUID + "), FOREIGN KEY("
+ PlaylistItems.COLUMN_NAME_PLAYLIST_ID + ") REFERENCES " + Playlists.TABLE_NAME + "("
+ Playlists.COLUMN_NAME_ID + ") ON DELETE CASCADE);";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment