nnGfQQVq

1public void CreateTables()
2    {
3        using (var connection = GetSQLiteHandle())
4        {
5            string sql = @"
6                CREATE TABLE IF NOT EXISTS statistics (
7                    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
8                    name TEXT NOT NULL,
9                    value TEXT NOT NULL
10                );
11                CREATE TABLE IF NOT EXISTS posts (
12                    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
13                    content TEXT NOT NULL,
14                    created TEXT NOT NULL
15                );
16                CREATE TABLE IF NOT EXISTS names (
17                    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
18                    name TEXT NOT NULL
19                );
20                CREATE TABLE IF NOT EXISTS users (
21                    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
22                    username TEXT NOT NULL,
23                    email TEXT NOT NULL,
24                    created TEXT NOT NULL
25                );
26                CREATE TABLE IF NOT EXISTS storage (
27                    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
28                    key TEXT NOT NULL,
29                    value TEXT NOT NULL
30                );
31            ";
32            connection.Execute(sql);
33        }
34    }