-- PostgreSQL Data Insertion for ZIPA Summit 2026
-- Generated from Laravel Seeders

-- 1. Permissions
INSERT INTO permissions (id, permission_name, created_at, updated_at) VALUES 
(1, 'Admin access', NOW(), NOW()),
(2, 'adding new user', NOW(), NOW()),
(3, 'User management', NOW(), NOW()),
(4, 'disabling user', NOW(), NOW()),
(5, 'managing roles', NOW(), NOW()),
(6, 'adding roles to user', NOW(), NOW()),
(7, 'auditing system and activities', NOW(), NOW()),
(8, 'adding contract', NOW(), NOW()),
(9, 'view contract', NOW(), NOW()),
(10, 'adding consultant', NOW(), NOW()),
(11, 'viewing consultant', NOW(), NOW()),
(12, 'viewing report', NOW(), NOW()),
(13, 'approve contract', NOW(), NOW()),
(14, 'extend contract', NOW(), NOW()),
(15, 'terminate contract', NOW(), NOW()),
(16, 'viewing contract', NOW(), NOW()),
(17, 'resend contract', NOW(), NOW());

-- 2. Roles
INSERT INTO roles (id, role_name, created_at, updated_at) VALUES 
(1, 'admin', NOW(), NOW());

-- 3. Permission Roles (Admin has permissions 1-6 according to Seeder)
INSERT INTO permission_roles (permission_id, role_id) VALUES 
(1, 1), (2, 1), (3, 1), (4, 1), (5, 1), (6, 1);

-- 5. User Roles (Assign Admin Role to Users)
-- Assuming IDs 1 and 2 for the above users
INSERT INTO user_roles (user_id, role_id) VALUES 
(1, 1),
(2, 1);

-- 6. Packages
INSERT INTO packages (title, features, price, created_at, updated_at) VALUES 
('PLATINUM', '["Priority seating at all conference sessions", "Access to VIP/Speaker Lounge with catering and dedicated assistance", "Access to Invest Zanzibar Golf Tournament", "VIP Invitation to the Gala Dinner", "Dedicated Workspace / Plot Lounge", "Full Access to all Social Events", "Access to the Gala Dinner"]', 200000, NOW(), NOW()),
('GOLD', '["General Seating at all conference sessions", "Access to VIP/Speaker Lounge, opening ceremony and dedicated assistance", "Full Access to Exhibition", "Access to Networking Lounge", "Access to the Gala Dinner", "Access to Delegate Business Lunch", "Invite to Cocktail Reception with Partners"]', 150000, NOW(), NOW()),
('SILVER', '["General Seating at all conference sessions", "Access to VIP/Speaker Lounge, opening ceremony and dedicated assistance", "Full Access to Exhibition", "Access to the Gala Dinner", "Access to Delegate Business Lunch", "Delegate Package", "Site Visits to Key Industry Locations"]', 75000, NOW(), NOW()),
('BRONZE', '["General/Subsidiary Seating", "Access to VIP/Speaker Lounge, opening ceremony and dedicated assistance", "Full Access to Exhibition", "Includes the Gala Dinner", "Access to Delegate Business Lunch", "Delegate Package", "Site Visits to Key Industry Locations"]', 50000, NOW(), NOW());
