version 0.3.23

[fms.git] / src / dbconversions.cpp

diff --git a/src/dbconversions.cpp b/src/dbconversions.cpp
index 1fa11cd..b0cb73e 100644 (file)
--- a/src/dbconversions.cpp
+++ b/src/dbconversions.cpp
@@ -233,6 +233,16 @@ void ConvertDB0112To0113()
        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