iD4H1buW

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			"	reference_id INTEGER,\n"
7			"	self INTEGER,\n"
8			"	received INTEGER,\n"
9			"	datetime INTEGER,\n"
10			"	unique_id INTEGER,\n"
11			"	failed INTEGER,\n"
12			"	PRIMARY KEY(public_key, unique_id)\n"
13			");\n";
14	query = db.exec(create_command_messages);
15	const QString create_command_text_messages = 
16			"CREATE TABLE IF NOT EXISTS TextMessages\n"
17			"(\n"
18			"	reference_id INTEGER PRIMARY KEY,\n"
19			"	message STRING\n"
20			");\n"
21			"";
22	query = db.exec(create_command_text_messages);
23	const QString create_command_file_messages = 
24			"CREATE TABLE IF NOT EXISTS FileMessages\n"
25			"(\n"
26			"	reference_id INTEGER PRIMARY KEY,\n"
27			"	file_path STRING,\n"
28			"	size INTEGER\n"
29			");";