version 0.3.2

[fms.git] / src / dbsetup.cpp

diff --git a/src/dbsetup.cpp b/src/dbsetup.cpp
index bc197cc..68ee676 100644 (file)
--- a/src/dbsetup.cpp
+++ b/src/dbsetup.cpp
@@ -15,7 +15,7 @@ void SetupDB()
        SQLite3DB::DB *db=SQLite3DB::DB::Instance();\r
 \r
        db->Open("fms.db3");\r
-       db->SetBusyTimeout(10000);              // set timeout to 10 seconds\r
+       db->SetBusyTimeout(20000);              // set timeout to 20 seconds\r
 \r
        tempval="";\r
        Option::Instance()->Get("VacuumOnStartup",tempval);\r
@@ -112,6 +112,18 @@ void SetupDB()
 \r
        db->Execute("UPDATE tblDBVersion SET Major=1, Minor=12;");\r
 \r
+       db->Execute("CREATE TABLE IF NOT EXISTS tblFMSVersion(\\r
+                               Major                           INTEGER,\\r
+                               Minor                           INTEGER,\\r
+                               Release                         INTEGER,\\r
+                               Notes                           TEXT,\\r
+                               Changes                         TEXT,\\r
+                               PageKey                         TEXT,\\r
+                               SourceKey                       TEXT\\r
+                               );");\r
+\r
+       db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxFMSVersion_Version ON tblFMSVersion(Major,Minor,Release);");\r
+\r
        db->Execute("CREATE TABLE IF NOT EXISTS tblOption(\\r
                                Option                          TEXT UNIQUE,\\r
                                OptionValue                     TEXT NOT NULL,\\r