Nfvy3pXG

1CREATE TABLE IF NOT EXISTS users(
2  id integer primary key,
3  name text not null,
4  email text not null,
5  passwordhash text not null
6);
7
8
9CREATE TABLE IF NOT EXISTS stores(
10  id integer primary key,
11  name text not null,
12  adress text not null 
13);
14
15CREATE TABLE IF NOT EXISTS orders(
16  id integer primary key,
17  date date not null,
18  owner_id integer default null,
19  store_id integer default null,
20  FOREIGN KEY (store_id) REFERENCES stores(id)
21);
22
23CREATE TABLE IF NOT EXISTS availability (
24  id integer primary key,
25  order_id integer not null,
26  date date not null,
27  user_id integer,
28  availability integer DEFAULT 1 /*1 = available 0= not available*/
29);
30
31
32
33CREATE TABLE IF NOT EXISTS order_items(
34  id integer primary key,
35  order_id integer not null,
36  userId integer not null,
37  name text not null,
38  date date not null,
39  price decimal(10,2) not null,
40  paid boolean
41  
42);
43
44
45INSERT INTO users(id,name, email, passwordHash) values(1, "admin", "admin@admin.nl",
46  "$2b$12$9BwyzrkCBioedc6.YLh6xO8jWpHfMeN6hrguMR7qAY7m8CSGrt8Si");
47
48/*
49  orders 
50*/
51
52insert into orders(id,date) values(1,"2019-10-26");
53insert into orders(id,date) values(2,"2019-10-27");
54insert into orders(id,date) values(3,"2019-10-28");
55insert into orders(id,date) values(4,"2019-10-29");
56insert into orders(id,date) values(5,"2019-10-30");
57insert into orders(id,date) values(6,"2019-10-31");
58insert into orders(id,date) values(7,"2019-11-01");
59/*
60 availability
61*/
62insert into availability(id,order_id,date,user_id,availability) values(1,1,"2019-10-26",1,0);
63insert into availability(id,order_id,date,user_id) values(2,2,"2019-10-27",1);
64insert into availability(id,order_id,date,user_id) values(3,3,"2019-10-28",1);
65insert into availability(id,order_id,date,user_id,availability) values(4,4,"2019-10-29",1,0);
66insert into availability(id,order_id,date,user_id) values(5,5,"2019-10-30",1);
67insert into availability(id,order_id,date,user_id) values(6,6,"2019-10-31",1);
68insert into availability(id,order_id,date,user_id) values(7,7,"2019-11-01",1);
69
70/*
71  stores
72*/
73
74insert into stores(id,name,adress) values(1,"AH To Go","Zutphenseweg 51020, 7418 AJ Deventer");
75insert into stores(id,name,adress) values(2,"Mc Donalds","Deventerweg 121A, 7418 DA Deventer");