version 0.3.25

[fms.git] / src / dbconversions.cpp

diff --git a/src/dbconversions.cpp b/src/dbconversions.cpp
index 206ab64..b0cb73e 100644 (file)
--- a/src/dbconversions.cpp
+++ b/src/dbconversions.cpp
@@ -222,6 +222,27 @@ void ConvertDB0111To0112()
        db->Execute("UPDATE tblDBVersion SET Major=1, Minor=12;");\r
 }\r
 \r
+void ConvertDB0112To0113()\r
+{\r
+       // Add Tries and Key (for anonymous messages) to tblMessageRequests     \r
+       SQLite3DB::DB *db=SQLite3DB::DB::Instance();\r
+\r
+       db->Execute("ALTER TABLE tblMessageRequests ADD COLUMN Tries INTEGER DEFAULT 0;");\r
+       db->Execute("ALTER TABLE tblMessageRequests ADD COLUMN Key TEXT;");\r
+\r
+       db->Execute("UPDATE tblDBVersion SET Major=1, Minor=13;");\r
+}\r
+\r
+void ConvertDB0113To0114()\r
+{\r
+       SQLite3DB::DB *db=SQLite3DB::DB::Instance();\r
+\r
+       db->Execute("ALTER TABLE tblBoard ADD COLUMN Forum TEXT CHECK(Forum IN ('true','false')) DEFAULT 'false';");\r
+       db->Execute("ALTER TABLE tblMessage ADD COLUMN Read INTEGER CHECK(Read IN (0,1)) DEFAULT 0;");\r
+\r
+       db->Execute("UPDATE tblDBVersion SET Major=1, Minor=14;");\r
+}\r
+\r
 void FixCapitalBoardNames()\r
 {\r
        SQLite3DB::DB *db=SQLite3DB::DB::Instance();\r