1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
CREATE TABLE IF NOT EXISTS "users" (
"email" TEXT PRIMARY KEY,
"created_at" TEXT NOT NULL DEFAULT (datetime()),
"updated_at" TEXT NOT NULL DEFAULT (datetime()),
"password_hash" TEXT NOT NULL,
"name" TEXT NOT NULL,
"login_token" TEXT NULL
) STRICT;
CREATE TABLE IF NOT EXISTS "maps" (
"id" TEXT PRIMARY KEY,
"created_at" TEXT NOT NULL DEFAULT (datetime()),
"updated_at" TEXT NOT NULL DEFAULT (datetime()),
"name" TEXT NOT NULL
) STRICT;
CREATE TABLE IF NOT EXISTS "markers" (
"id" TEXT PRIMARY KEY,
"created_at" TEXT NOT NULL DEFAULT (datetime()),
"updated_at" TEXT NOT NULL DEFAULT (datetime()),
"map_id" TEXT NOT NULL REFERENCES maps(id),
"lat" REAL NOT NULL,
"lng" REAL NOT NULL,
"color" TEXT NOT NULL,
"name" TEXT NULL,
"description" TEXT NULL,
"icon" TEXT NULL,
"radius" INTEGER NULL
) STRICT;
|
