+void ConvertDB0112To0113(SQLite3DB::DB *db)\r
+{\r
+ // Add Tries and Key (for anonymous messages) to tblMessageRequests \r
+\r
+ db->Execute("ALTER TABLE tblMessageRequests ADD COLUMN Tries INTEGER DEFAULT 0;");\r
+ db->Execute("ALTER TABLE tblMessageRequests ADD COLUMN Key TEXT;");\r
+\r
+ db->Execute("UPDATE tblDBVersion SET Major=1, Minor=13;");\r
+}\r
+\r
+void ConvertDB0113To0114(SQLite3DB::DB *db)\r
+{\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 ConvertDB0114To0115(SQLite3DB::DB *db)\r
+{\r
+\r
+ db->Execute("ALTER TABLE tblOption ADD COLUMN DisplayType TEXT CHECK (DisplayType IN ('textbox','textarea','select','multiselect')) DEFAULT 'textbox';");\r
+ db->Execute("ALTER TABLE tblOption ADD COLUMN DisplayParam1 TEXT;");\r
+ db->Execute("ALTER TABLE tblOption ADD COLUMN DisplayParam2 TEXT;");\r
+ db->Execute("ALTER TABLE tblOption ADD COLUMN Mode TEXT CHECK (Mode IN ('simple','advanced')) DEFAULT 'simple';");\r
+\r
+ db->Execute("UPDATE tblDBVersion SET Major=1, Minor=15;");\r
+}\r
+\r
+void ConvertDB0115To0116(SQLite3DB::DB *db)\r
+{\r
+ // Add FromIdentityID to tblMessageRequests so we know who we got this index from\r
+ // Add FailureCount\r
+\r
+ db->Execute("ALTER TABLE tblMessageRequests ADD COLUMN FromIdentityID INTEGER;");\r
+ db->Execute("ALTER TABLE tblIdentity ADD COLUMN FailureCount INTEGER CHECK(FailureCount>=0) DEFAULT 0;");\r
+\r
+ db->Execute("UPDATE tblDBVersion SET Major=1, Minor=16;");\r
+}\r
+\r
+void ConvertDB0116To0117(SQLite3DB::DB *db)\r
+{\r
+ // Add InsertDate to tblMessage\r
+\r
+ db->Execute("ALTER TABLE tblMessage ADD COLUMN InsertDate DATE;");\r
+ db->Execute("DROP INDEX IF EXISTS idxThreadPost_ThreadID;");\r
+\r
+ db->Execute("UPDATE tblDBVersion SET Major=1, Minor=17;");\r
+}\r
+\r
+void FixCapitalBoardNames(SQLite3DB::DB *db)\r