diff options
Diffstat (limited to 'db/data.sql')
| -rw-r--r-- | db/data.sql | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/db/data.sql b/db/data.sql index 01f18aa..e6ac757 100644 --- a/db/data.sql +++ b/db/data.sql @@ -27,14 +27,16 @@ insert into webs.user (`name`, `hash`) values ("willem", "$2b$12$vCDpn5fnGBL7dv3Ty1cgZegDKOguoRIgHNrUFYOCWoensgI4HnJde"); -- biege update webs.user set `privileges` = 1073741824 where `name` = "loek"; -insert into webs.cart (`product`, `user`) values - (4, 1), - (5, 1), - (6, 1), - (7, 1), - (8, 1); - insert into webs.promotion (`product`, `price_buff`) values (1, 0.80), -- 20% korting (2, 0.80), (3, 0.80); + +set @order_id = webs.cart(1); -- cart id voor loek +insert into webs.orderproduct (`product`, `count`, `order`) values + (4, 1, @order_id), + (5, 1, @order_id), + (6, 1, @order_id), + (7, 1, @order_id), + (8, 1, @order_id); + |