X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fidentitytestglobal.cpp;h=985cb3f26d048496faf1fd1758eb105eff0ce432;hp=4b40288d4bb35340d090e1ba323592fbb2d8845d;hb=8adfd604a97d385869b0ce763b35d014d7aa2cca;hpb=9048d8e482c91960265f29c2b5b3112f2a52f3d8

diff --git a/src/identitytestglobal.cpp b/src/identitytestglobal.cpp
index 4b40288..985cb3f 100644
--- a/src/identitytestglobal.cpp
+++ b/src/identitytestglobal.cpp
@@ -126,6 +126,45 @@ void SetupDB()
 				TrustListTrust		INTEGER CHECK(TrustListTrust BETWEEN 0 AND 100)\
 				);");
 
+	db->Execute("CREATE TABLE IF NOT EXISTS tblBoard(\
+				BoardID				INTEGER PRIMARY KEY,\
+				BoardName			TEXT UNIQUE,\
+				BoardDescription	TEXT,\
+				DateAdded			DATETIME\
+				);");
+
+	db->Execute("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES('fms','Freenet Message System','2007-12-01');");
+	db->Execute("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES('freenet','Discussion about Freenet','2007-12-01');");
+	db->Execute("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES('public','Public discussion','2007-12-01');");
+	db->Execute("INSERT INTO tblBoard(BoardName,BoardDescription,DateAdded) VALUES('test','Test board','2007-12-01');");
+
+	db->Execute("CREATE TABLE IF NOT EXISTS tblMessage(\
+				MessageID			INTEGER PRIMARY KEY,\
+				MessageDate			DATE,\
+				MessageTime			TIME,\
+				Subject				TEXT,\
+				MessageUUID			TEXT UNIQUE,\
+				ReplyBoardID		INTEGER,\
+				Body				TEXT\
+				);");
+
+	db->Execute("CREATE TABLE IF NOT EXISTS tblMessageReplyTo(\
+				MessageID			INTEGER,\
+				ReplyToMessageID	INTEGER,\
+				Order				INTEGER\
+				);");
+	
+	db->Execute("CREATE TABLE IF NOT EXISTS tblMessageBoard(\
+				MessageID			INTEGER,\
+				BoardID				INTEGER\
+				);");
+
+	// 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' \
+				FROM tblBoard LEFT JOIN tblMessageBoard ON tblBoard.BoardID=tblMessageBoard.BoardID \
+				GROUP BY tblBoard.BoardID;");
+
 	// calculates peer trust
 	db->Execute("CREATE VIEW IF NOT EXISTS vwCalculatedPeerTrust AS \
 				SELECT TargetIdentityID, \