+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 FixCapitalBoardNames(SQLite3DB::DB *db)\r