public void Create_WordCount_Table(string dbFile, string TableName = "WordCount", bool DropPrevious = false) // create sqlite table with WordCount columns
{
_Database.SQLite sqlite = new _Database.SQLite();
string NewTableLine = "ID INTEGER PRIMARY KEY, flagged BOOL, FilePath VARCHAR, Word VARCHAR, wCount VARCHAR";
sqlite.Table_New(dbFile, TableName, NewTableLine, DropPrevious);
}
public bool Create_Table_PrnChill(string DbFile)
{
_Database.SQLite sqlite = new _Database.SQLite();
_AHK ahk = new _AHK();
string CreateLine = "Create Table [PrnChill] (PostName VARCHAR, PostURL VARCHAR, Links VARCHAR, DateAdded VARCHAR, LinkCheckDate VARCHAR, InCollection VARCHAR, ImageDir VARCHAR)";
bool TableCreated = sqlite.Table_Exists(DbFile, "PrnChill");
if (!TableCreated)
{
TableCreated = sqlite.Table_New(DbFile, "PrnChill", "Create Table [PrnChill] (PostName VARCHAR, PostURL VARCHAR, Links VARCHAR, DateAdded VARCHAR, LinkCheckDate VARCHAR, InCollection VARCHAR, ImageDir VARCHAR", false);
}
if (!TableCreated)
{
ahk.MsgBox("[PrnChill] Created = " + TableCreated.ToString());
}
return(TableCreated);
}