X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbsetup.cpp;h=68ee6768c0445f2fc1f7485e98230cdf93c1177f;hp=bc197cc84f777f0fdebdf741c0d19d8c149b4af4;hb=76805933f794915a72b7f0a21b12af6654759f4f;hpb=047cea32f848d605c549ec123c12c1c400dd7ec1 diff --git a/src/dbsetup.cpp b/src/dbsetup.cpp index bc197cc..68ee676 100644 --- a/src/dbsetup.cpp +++ b/src/dbsetup.cpp @@ -15,7 +15,7 @@ void SetupDB() SQLite3DB::DB *db=SQLite3DB::DB::Instance(); db->Open("fms.db3"); - db->SetBusyTimeout(10000); // set timeout to 10 seconds + db->SetBusyTimeout(20000); // set timeout to 20 seconds tempval=""; Option::Instance()->Get("VacuumOnStartup",tempval); @@ -112,6 +112,18 @@ void SetupDB() db->Execute("UPDATE tblDBVersion SET Major=1, Minor=12;"); + db->Execute("CREATE TABLE IF NOT EXISTS tblFMSVersion(\ + Major INTEGER,\ + Minor INTEGER,\ + Release INTEGER,\ + Notes TEXT,\ + Changes TEXT,\ + PageKey TEXT,\ + SourceKey TEXT\ + );"); + + db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxFMSVersion_Version ON tblFMSVersion(Major,Minor,Release);"); + db->Execute("CREATE TABLE IF NOT EXISTS tblOption(\ Option TEXT UNIQUE,\ OptionValue TEXT NOT NULL,\