X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdbsetup.cpp;h=b9f30be6802a85264bd0cc822571da50c5ae23b9;hb=05ef25de71be91442b4cbd22dc7cc45629c5d5bb;hp=9b2ab003a6d5ea31f04d6679886624472e9d3480;hpb=b88f50bfec6dbcd169bb8285e7c42b93baf52b6b;p=fms.git diff --git a/src/dbsetup.cpp b/src/dbsetup.cpp index 9b2ab00..b9f30be 100644 --- a/src/dbsetup.cpp +++ b/src/dbsetup.cpp @@ -401,6 +401,12 @@ void SetupDB() LocalIdentityID INTEGER\ );"); + // Temporary table for form passwords + db->Execute("CREATE TEMPORARY TABLE IF NOT EXISTS tmpFormPassword(\ + Date DATETIME,\ + Password TEXT\ + );"); + // low / high / message count for each board db->Execute("CREATE VIEW IF NOT EXISTS vwBoardStats AS \ SELECT tblBoard.BoardID AS 'BoardID', IFNULL(MIN(MessageID),0) AS 'LowMessageID', IFNULL(MAX(MessageID),0) AS 'HighMessageID', COUNT(MessageID) AS 'MessageCount' \