static struct CT_TableList ct_table_list[] =
{
{"CTContent", "ContentID INTEGER PRIMARY KEY AUTOINCREMENT"},
{"CTSubContent", "ContentID INTEGER PRIMARY KEY, ParentID INTEGER, ContentOrder INTEGER(2)"}, /* a SubContent is a Content with a parent */
{"CTContentSet", "ContentID INTEGER PRIMARY KEY, Level INTEGER(1), Year INTEGER(2), Rating INTEGER(1)"},
{"CTName", "ContentID INTEGER PRIMARY KEY, Name TEXT"},
{"CTLocation", "ContentID INTEGER PRIMARY KEY, Location TEXT UNIQUE"},
{"CTArtists", "ArtistID INTEGER PRIMARY KEY AUTOINCREMENT, Artist TEXT UNIQUE"},
{"CTContentArtist", "ContentID INTEGER, ArtistID INTEGER"},
{"CTFormats", "FormatID INTEGER PRIMARY KEY AUTOINCREMENT, Format TEXT UNIQUE"},
{"CTContentFormat", "ContentID INTEGER PRIMARY KEY, FormatID INTEGER"},
{"CTGenres", "GenreID INTEGER PRIMARY KEY AUTOINCREMENT, Genre TEXT UNIQUE"},
{"CTContentGenre", "ContentID INTEGER, GenreID INTEGER"},
{"CTVersion", "ContentID INTEGER PRIMARY KEY, Version TEXT UNIQUE"},
{"CTComment", "ContentID INTEGER PRIMARY KEY, Comment TEXT UNIQUE"},
};
/*! strings to define elements of the DB */
#define CT_STRING_CONTENT "Content"
#define CT_STRING_ARTIST "Artist"
#define CT_STRING_ALBUM "Album"
#define CT_STRING_GENRE "Genre"
#define CT_STRING_YEAR "Year"
#define CT_STRING_URL "Location"
#define CT_STRING_DISPLAYNAME "Name"
#define CT_STRING_VERSIONNAME "Version"
#define CT_STRING_COMMENT "Comment"
#define CT_STRING_RATING "Rating"
static int ct_table_found(void* cookie,int num,char** key, char**value)
{ |