X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fglobal.cpp;h=0c6f913ddbb19d57ddf9c4bdbdff1fca782d004e;hp=7f635791088beb7281125b2110f27a67c3e7539e;hb=52c0819bfc1d083c6e0738f75f0d7eeba521295a;hpb=df316253862dc50e8e5a790d9634ef90be37badb diff --git a/src/global.cpp b/src/global.cpp index 7f63579..0c6f913 100644 --- a/src/global.cpp +++ b/src/global.cpp @@ -343,6 +343,12 @@ void SetupDB() DELETE FROM tblTrustListInserts WHERE LocalIdentityID=old.LocalIdentityID;\ END;"); + db->Execute("CREATE TRIGGER IF NOT EXISTS trgDeleteBoard AFTER DELETE ON tblBoard \ + FOR EACH ROW \ + BEGIN \ + DELETE FROM tblMessageBoard WHERE BoardID=old.BoardID;\ + END;"); + // delete introduction puzzles that were half-way inserted db->Execute("DELETE FROM tblIntroductionPuzzleInserts WHERE Day IS NULL AND InsertIndex IS NULL;"); @@ -565,6 +571,12 @@ void SetupDefaultOptions() st.Step(); st.Reset(); + st.Bind(0,"ChangeMessageTrustOnReply"); + st.Bind(1,"0"); + st.Bind(2,"How much the local message trust level of an identity should change when you reply to one of their messages."); + st.Step(); + st.Reset(); + } void SetupLogFile()