diff options
| author | lonkaars <loek@pipeframe.xyz> | 2023-06-01 16:30:41 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2023-06-01 16:30:41 +0200 |
| commit | 6715936a3b33c14b2d8c581677855bb6c1297940 (patch) | |
| tree | 49ef59d2c62f5a7cb6a640c9ac3196c4b22ecd6a /db | |
| parent | 879c72e50c172f6e20416dcf06fccdbb59525c7a (diff) | |
implement promotion buff coefficient to promotion string converter
Diffstat (limited to 'db')
| -rw-r--r-- | db/data.sql | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/db/data.sql b/db/data.sql index e6ac757..d0c5d96 100644 --- a/db/data.sql +++ b/db/data.sql @@ -27,10 +27,14 @@ insert into webs.user (`name`, `hash`) values ("willem", "$2b$12$vCDpn5fnGBL7dv3Ty1cgZegDKOguoRIgHNrUFYOCWoensgI4HnJde"); -- biege update webs.user set `privileges` = 1073741824 where `name` = "loek"; -insert into webs.promotion (`product`, `price_buff`) values - (1, 0.80), -- 20% korting - (2, 0.80), - (3, 0.80); +insert into webs.promotion (`product`, `price_buff`, `count_buff`) values + (1, 0.80, 1), -- 20% korting + (2, 0.50, 2), -- 1+1 gratis + (3, 0.6666666, 3), -- 2+1 gratis + (4, 0.50, 4), -- 2+2 gratis + (5, 0.75, 4), -- 3+1 gratis + (6, 0.80, 4), -- ???? + (7, 0.50, 6); -- 50% korting per 6-pack set @order_id = webs.cart(1); -- cart id voor loek insert into webs.orderproduct (`product`, `count`, `order`) values |