From d99d91293fe9e9ad683bbd079848df4031f0a77a Mon Sep 17 00:00:00 2001
From: lonkaars <loek@pipeframe.xyz>
Date: Sat, 13 May 2023 14:35:04 +0200
Subject: add links to admin pages + more login

---
 db/data.sql  | 15 ++++++++-------
 db/init.sql  | 12 +++++++-----
 db/reset.sql |  2 +-
 3 files changed, 16 insertions(+), 13 deletions(-)

(limited to 'db')

diff --git a/db/data.sql b/db/data.sql
index d02fa61..7254a90 100644
--- a/db/data.sql
+++ b/db/data.sql
@@ -19,14 +19,15 @@ update webs.product set description = "<ul><li>lekker sappig</li><li>zonder BTW<
 update webs.product set description = "<ul><li>snel bruin</li><li>zonder BTW</li></ul>" where id = 2;
 update webs.product set description = "<ul><li>kurkdroog</li><li>zonder BTW</li></ul>" where id = 3;
 
-insert into webs.customer (`name`) values
-	("loek"),
-	("bert"),
-	("niels"),
-	("joshua"),
-	("willem");
+insert into webs.user (`name`, `hash`) values
+	("loek", "$2b$12$HuKuEfTuD081gi8/VWtAl.WwpfD6MM6fAekxng22wwquoIyiK1zGC"), -- gert123
+	("bert", "$2b$12$s8ag3gsHThqIZUzqzfcX8O.v4mXfMAeu2G4X51nQOesmVPuXl0hse"), -- win32
+	("niels", "$2b$12$4JDIzpWAQpz3Iv9IdiwNzOoeSx0IPnDiO6EMVOz6knW8JGhm60wPO"), -- bsod
+	("joshua", "$2b$12$CrBgZljVGYHZt.xF.HWziOgwD9qL7jMxfHh6.fXxO55rbwtoRXYM6"), -- darwin
+	("willem", "$2b$12$vCDpn5fnGBL7dv3Ty1cgZegDKOguoRIgHNrUFYOCWoensgI4HnJde"); -- biege
+update webs.user set `privileges` = 1073741824 where `name` = "loek";
 
-insert into webs.cart (`product`, `customer`) values
+insert into webs.cart (`product`, `user`) values
 	(4, 1),
 	(5, 1),
 	(6, 1),
diff --git a/db/init.sql b/db/init.sql
index 4be1768..b7b3310 100644
--- a/db/init.sql
+++ b/db/init.sql
@@ -25,25 +25,27 @@ create table if not exists webs.product (
     on update cascade
 );
 
-create table if not exists webs.customer (
+create table if not exists webs.user (
   `id` int not null auto_increment,
   `name` varchar(45) not null,
+	`hash` binary(64) not null,
+	`privileges` int not null default 1,
   primary key (`id`)
 );
 
 create table if not exists webs.cart (
   `id` int not null auto_increment,
   `product` int not null,
-  `customer` int not null,
+  `user` int not null,
 	`count` int not null default 1,
   primary key (`id`),
   constraint `cart_product_fk`
     foreign key (`product`)
     references webs.product (`id`)
     on update cascade,
-  constraint `cart_customer_fk`
-    foreign key (`customer`)
-    references webs.customer (`id`)
+  constraint `cart_user_fk`
+    foreign key (`user`)
+    references webs.user (`id`)
     on update cascade
 );
 
diff --git a/db/reset.sql b/db/reset.sql
index 5338395..7036613 100644
--- a/db/reset.sql
+++ b/db/reset.sql
@@ -1,6 +1,6 @@
 drop schema if exists webs;
 drop table if exists webs.product;
-drop table if exists webs.customer;
+drop table if exists webs.user;
 drop table if exists webs.cart;
 drop table if exists webs.promotion;
 drop table if exists webs.category;
-- 
cgit v1.2.3