X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fdbsetup.cpp;h=1add253df1812a03a3af4dee395a820906f6330e;hp=01858aa5f7a295b5bf6de062ae0214687d85eb21;hb=HEAD;hpb=9ae3b1434e51788e6feb72e1415ec800d05c535a diff --git a/src/dbsetup.cpp b/src/dbsetup.cpp index 01858aa..1add253 100644 --- a/src/dbsetup.cpp +++ b/src/dbsetup.cpp @@ -420,6 +420,20 @@ void SetupDB(SQLite3DB::DB *db) Found BOOL CHECK(Found IN('true','false')) DEFAULT 'false'\ );"); +#ifdef FROST_SUPPORT + + db->Execute("CREATE TABLE IF NOT EXISTS tblFrostMessageRequests(\ + BoardID INTEGER,\ + Day DATE,\ + RequestIndex INTEGER,\ + Found BOOL CHECK(Found IN('true','false')) DEFAULT 'false',\ + Tries INTEGER DEFAULT 0\ + );"); + + db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxFrostMessageRequest ON tblFrostMessageRequests(BoardID,Day,RequestIndex);"); + +#endif + // begin thread db schema db->Execute("CREATE TABLE IF NOT EXISTS tblThread(\ ThreadID INTEGER PRIMARY KEY,\