X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbconversions.cpp;fp=src%2Fdbconversions.cpp;h=c339a9f9152e5b1c07eff236bf461ee51ced0314;hp=463cf7e38403613c97ba2c2c7efd325c8b49ae2e;hb=9ae3b1434e51788e6feb72e1415ec800d05c535a;hpb=ed0732b2550c23c05fc9faf925620e87ee6dee12

diff --git a/src/dbconversions.cpp b/src/dbconversions.cpp
index 463cf7e..c339a9f 100644
--- a/src/dbconversions.cpp
+++ b/src/dbconversions.cpp
@@ -252,6 +252,16 @@ void ConvertDB0115To0116(SQLite3DB::DB *db)
 	db->Execute("UPDATE tblDBVersion SET Major=1, Minor=16;");
 }
 
+void ConvertDB0116To0117(SQLite3DB::DB *db)
+{
+	// Add InsertDate to tblMessage
+
+	db->Execute("ALTER TABLE tblMessage ADD COLUMN InsertDate DATE;");
+	db->Execute("DROP INDEX IF EXISTS idxThreadPost_ThreadID;");
+
+	db->Execute("UPDATE tblDBVersion SET Major=1, Minor=17;");
+}
+
 void FixCapitalBoardNames(SQLite3DB::DB *db)
 {