diff options
Diffstat (limited to 'db/data.sql')
| -rw-r--r-- | db/data.sql | 15 |
1 files changed, 8 insertions, 7 deletions
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), |