major=1;\r
minor=16;\r
}\r
+ if(major==1 && minor==16)\r
+ {\r
+ ConvertDB0116To0117(db);\r
+ major=1;\r
+ minor=17;\r
+ }\r
}\r
else\r
{\r
- db->Execute("INSERT INTO tblDBVersion(Major,Minor) VALUES(1,16);");\r
+ db->Execute("INSERT INTO tblDBVersion(Major,Minor) VALUES(1,17);");\r
}\r
\r
- db->Execute("UPDATE tblDBVersion SET Major=1, Minor=16;");\r
+ db->Execute("UPDATE tblDBVersion SET Major=1, Minor=17;");\r
\r
db->Execute("CREATE TABLE IF NOT EXISTS tblFMSVersion(\\r
Major INTEGER,\\r
MessageUUID TEXT UNIQUE,\\r
ReplyBoardID INTEGER,\\r
Body TEXT,\\r
+ InsertDate DATE,\\r
MessageIndex INTEGER,\\r
Read INTEGER CHECK(Read IN(0,1)) DEFAULT 0\\r
);");\r
Found BOOL CHECK(Found IN('true','false')) DEFAULT 'false'\\r
);");\r
\r
+#ifdef FROST_SUPPORT\r
+\r
+ db->Execute("CREATE TABLE IF NOT EXISTS tblFrostMessageRequests(\\r
+ BoardID INTEGER,\\r
+ Day DATE,\\r
+ RequestIndex INTEGER,\\r
+ Found BOOL CHECK(Found IN('true','false')) DEFAULT 'false',\\r
+ Tries INTEGER DEFAULT 0\\r
+ );");\r
+\r
+ db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxFrostMessageRequest ON tblFrostMessageRequests(BoardID,Day,RequestIndex);");\r
+\r
+#endif\r
+\r
// begin thread db schema\r
db->Execute("CREATE TABLE IF NOT EXISTS tblThread(\\r
ThreadID INTEGER PRIMARY KEY,\\r
PostOrder INTEGER\\r
);");\r
\r
- db->Execute("CREATE INDEX IF NOT EXISTS idxThreadPost_ThreadID ON tblThreadPost(ThreadID);");\r
+ db->Execute("CREATE UNIQUE INDEX IF NOT EXISTS idxThreadPost_ThreadMessage ON tblThreadPost(ThreadID,MessageID);");\r
db->Execute("CREATE INDEX IF NOT EXISTS idxThreadPost_MessageID ON tblThreadPost(MessageID);");\r
\r
db->Execute("CREATE TRIGGER IF NOT EXISTS trgDeleteOnThread AFTER DELETE ON tblThread\\r