· 5 years ago · Feb 18, 2020, 03:10 PM
1 const QString create_command_messages =
2 "CREATE TABLE IF NOT EXISTS Messages\n"
3 "(\n"
4 " public_key BLOB,\n"
5 " type INTEGER,\n"
6 " self INTEGER,\n"
7 " received INTEGER,\n"
8 " datetime INTEGER,\n"
9 " unique_id INTEGER,\n"
10 " failed INTEGER,\n"
11 " PRIMARY KEY(public_key, unique_id)\n"
12 ");\n";
13 query = db.exec(create_command_messages);
14 const QString create_command_text_messages =
15 "CREATE TABLE IF NOT EXISTS TextMessages\n"
16 "(\n"
17 " public_key BLOB,\n"
18 " unique_id INTEGER,\n"
19 " message STRING,\n"
20 " PRIMARY KEY(public_key, unique_id)\n"
21 ");\n"
22 "";
23 query = db.exec(create_command_text_messages);