public static void SQLDatabaseInitilize()
{
String dbName = Environment.UserName+"@"+Environment.MachineName+"_"+System.DateTime.Now.ToString("MM_dd_yy_H_mm_ss");
//MessageBox.Show(dbName);
try
{
//if (File.Exists(".db"))
//File.Delete("db.db");
sqlCon = new SQLiteConnection("Data Source="+dbName+".sdb;Version=3;New=True;Compress=True;"); //create a new database
sqlCon.Open(); //open the connection
String []password = dbName.Split('@');
String[] dbPassword = password[1].Split('_');
sqlCon.ChangePassword(password[0] + dbPassword[0]);
sqlCmd = sqlCon.CreateCommand();
// Create scanned table
sqlCmd.CommandText = "CREATE TABLE if not exists Scanned (fileIndex integer PRIMARY KEY AUTOINCREMENT, filename text, " +
"filePath text, count integer, priority text, pattern_D9_Count integer, pattern_D324_Count integer);";
sqlCmd.ExecuteNonQuery();
// Create unScannable table
sqlCmd.CommandText = "CREATE TABLE if not exists UnScannable (filename text, filePath text, owner text, reason text);";
sqlCmd.ExecuteNonQuery();
// Create CreditCard table
sqlCmd.CommandText = "CREATE TABLE if not exists CreditCard (filename text, filePath text, count integer, priority text, " +
"visa integer, mastercard integer, americanExpress integer, discover integer, dinerClub integer, JCB integer);";
sqlCmd.ExecuteNonQuery();
//Create CrashStatus table
sqlCmd.CommandText = "CREATE TABLE if not exists CrashStatus (status text);";
sqlCmd.ExecuteNonQuery();
}
catch (Exception) { /*MessageBox.Show(e.ToString());*/ }
}