X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbsetup.cpp;fp=src%2Fdbsetup.cpp;h=01858aa5f7a295b5bf6de062ae0214687d85eb21;hp=644310be2d421f50d50887b2c7b992b67d9eb0a3;hb=9ae3b1434e51788e6feb72e1415ec800d05c535a;hpb=ed0732b2550c23c05fc9faf925620e87ee6dee12

diff --git a/src/dbsetup.cpp b/src/dbsetup.cpp
index 644310b..01858aa 100644
--- a/src/dbsetup.cpp
+++ b/src/dbsetup.cpp
@@ -117,13 +117,19 @@ void SetupDB(SQLite3DB::DB *db)
 			major=1;
 			minor=16;
 		}
+		if(major==1 && minor==16)
+		{
+			ConvertDB0116To0117(db);
+			major=1;
+			minor=17;
+		}
 	}
 	else
 	{
-		db->Execute("INSERT INTO tblDBVersion(Major,Minor) VALUES(1,16);");
+		db->Execute("INSERT INTO tblDBVersion(Major,Minor) VALUES(1,17);");
 	}
 
-	db->Execute("UPDATE tblDBVersion SET Major=1, Minor=16;");
+	db->Execute("UPDATE tblDBVersion SET Major=1, Minor=17;");
 
 	db->Execute("CREATE TABLE IF NOT EXISTS tblFMSVersion(\
 				Major				INTEGER,\
@@ -320,6 +326,7 @@ void SetupDB(SQLite3DB::DB *db)
 				MessageUUID			TEXT UNIQUE,\
 				ReplyBoardID		INTEGER,\
 				Body				TEXT,\
+				InsertDate			DATE,\
 				MessageIndex		INTEGER,\
 				Read				INTEGER CHECK(Read IN(0,1)) DEFAULT 0\
 				);");
@@ -431,7 +438,7 @@ void SetupDB(SQLite3DB::DB *db)
 				PostOrder		INTEGER\
 				);");
 
-	db->Execute("CREATE INDEX IF NOT EXISTS idxThreadPost_ThreadID ON tblThreadPost(ThreadID);");
+	db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxThreadPost_ThreadMessage ON tblThreadPost(ThreadID,MessageID);");
 	db->Execute("CREATE INDEX IF NOT EXISTS idxThreadPost_MessageID ON tblThreadPost(MessageID);");
 
 	db->Execute("CREATE TRIGGER IF NOT EXISTS trgDeleteOnThread AFTER DELETE ON tblThread\