-
Notifications
You must be signed in to change notification settings - Fork 0
/
structure.sql
53 lines (48 loc) · 1.06 KB
/
structure.sql
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
BEGIN TRANSACTION;
----
-- Table structure for Orders
----
CREATE TABLE "Orders" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
"datetime" INTEGER NOT NULL,
"userId" INTEGER NOT NULL,
"notes" INTEGER,
"payed" INTEGER NOT NULL DEFAULT 0,
"createdAt" INTEGER NOT NULL
);
----
-- Table structure for OrderDishes
----
CREATE TABLE "OrderDishes" (
"orderId" INTEGER NOT NULL,
"dishId" TEXT NOT NULL,
"dishQty" TEXT NOT NULL,
"dishNotes" TEXT
);
----
-- Table structure for Dishes
----
CREATE TABLE "Dishes" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
"name" TEXT NOT NULL,
"price" NUMERIC NOT NULL,
"deleted" INTEGER NOT NULL DEFAULT 0
);
----
-- Table structure for Users
----
CREATE TABLE "Users" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
"name" TEXT NOT NULL,
"email" TEXT NOT NULL,
"passwordHash" TEXT NOT NULL,
"classe" TEXT NOT NULL,
"verified" INTEGER NOT NULL DEFAULT 0,
"isStaff" INTEGER NOT NULL,
"createdAt" INTEGER NOT NULL,
"token" TEXT,
"lastLogin" INTEGER,
"emailToken" TEXT,
"lastView" TEXT
);
COMMIT;