X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdbconversions.cpp;h=b0cb73ee8a322a7cb786f3b9f4a0845a901782fb;hb=56f67ecca96efc7b72d03c95c8c42cfb66e31468;hp=206ab64498f043971049c041a3eb28727f647e1a;hpb=dec33c63afafabf83c3039e916725cac6faef9b3;p=fms.git

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