| Line 42... |
Line 42... |
| 42 |
SELECT m.id, 19, '3'
|
42 |
SELECT m.id, 19, '3'
|
| 43 |
FROM auth.menu m
|
43 |
FROM auth.menu m
|
| 44 |
WHERE m.action_class = 'demo-partner-access'
|
44 |
WHERE m.action_class = 'demo-partner-access'
|
| 45 |
AND NOT EXISTS (SELECT 1 FROM auth.menu_category mc WHERE mc.menu_id = m.id AND mc.category_id = 19 AND mc.escalation_type = '3');
|
45 |
AND NOT EXISTS (SELECT 1 FROM auth.menu_category mc WHERE mc.menu_id = m.id AND mc.category_id = 19 AND mc.escalation_type = '3');
|
| 46 |
|
46 |
|
| - |
|
47 |
-- Sales (category 4) L6 and above: ordinals '5'=L6, '6'=L7, '7'=L8, '8'=L9, '9'=Final.
|
| - |
|
48 |
-- INSERT IGNORE on the (menu_id, category_id, escalation_type) PK keeps it re-runnable; a NOT EXISTS
|
| - |
|
49 |
-- compare fails here (menu_category is latin1, string literals arrive as utf8).
|
| - |
|
50 |
INSERT IGNORE INTO auth.menu_category (menu_id, category_id, escalation_type)
|
| - |
|
51 |
SELECT m.id, 4, '5' FROM auth.menu m WHERE m.action_class = 'demo-partner-access'
|
| - |
|
52 |
UNION ALL SELECT m.id, 4, '6' FROM auth.menu m WHERE m.action_class = 'demo-partner-access'
|
| - |
|
53 |
UNION ALL SELECT m.id, 4, '7' FROM auth.menu m WHERE m.action_class = 'demo-partner-access'
|
| - |
|
54 |
UNION ALL SELECT m.id, 4, '8' FROM auth.menu m WHERE m.action_class = 'demo-partner-access'
|
| - |
|
55 |
UNION ALL SELECT m.id, 4, '9' FROM auth.menu m WHERE m.action_class = 'demo-partner-access';
|
| - |
|
56 |
|
| 47 |
-- Verify
|
57 |
-- Verify
|
| 48 |
-- SELECT * FROM auth.menu WHERE action_class = 'demo-partner-access';
|
58 |
-- SELECT * FROM auth.menu WHERE action_class = 'demo-partner-access';
|
| 49 |
-- SELECT mc.* FROM auth.menu_category mc JOIN auth.menu m ON m.id = mc.menu_id WHERE m.action_class = 'demo-partner-access';
|
59 |
-- SELECT mc.* FROM auth.menu_category mc JOIN auth.menu m ON m.id = mc.menu_id WHERE m.action_class = 'demo-partner-access';
|
| 50 |
|
60 |
|
| 51 |
-- Rollback
|
61 |
-- Rollback
|