X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbconversions.cpp;fp=src%2Fdbconversions.cpp;h=b0cb73ee8a322a7cb786f3b9f4a0845a901782fb;hp=1fa11cd3c0f515ca467cc2bc68c817c5700e7e96;hb=221236a4d3aac4144529d418ce368db5c98facb0;hpb=d5c9f7e6c1dd263dfc85a3cb5941a378a5ddd923 diff --git a/src/dbconversions.cpp b/src/dbconversions.cpp index 1fa11cd..b0cb73e 100644 --- a/src/dbconversions.cpp +++ b/src/dbconversions.cpp @@ -233,6 +233,16 @@ void ConvertDB0112To0113() db->Execute("UPDATE tblDBVersion SET Major=1, Minor=13;"); } +void ConvertDB0113To0114() +{ + SQLite3DB::DB *db=SQLite3DB::DB::Instance(); + + db->Execute("ALTER TABLE tblBoard ADD COLUMN Forum TEXT CHECK(Forum IN ('true','false')) DEFAULT 'false';"); + db->Execute("ALTER TABLE tblMessage ADD COLUMN Read INTEGER CHECK(Read IN (0,1)) DEFAULT 0;"); + + db->Execute("UPDATE tblDBVersion SET Major=1, Minor=14;"); +} + void FixCapitalBoardNames() { SQLite3DB::DB *db=SQLite3DB::DB::Instance();