INSERT INTO `{prefix}packages` (`name`, `version`, `created_at`, `updated_at`) VALUES
('shaun_event', '1.0.0', NOW(), NOW());

INSERT INTO `{prefix}model_maps` (`subject_type`, `model_class`) VALUES
('events', 'Packages\\ShaunSocial\\Event\\Models\\Event'),
('event_categories', 'Packages\\ShaunSocial\\Event\\Models\\EventCategory');

INSERT INTO `{prefix}permission_groups` (`name`, `key`, `created_at`, `updated_at`, `package`, `order`) VALUES
('Event', 'event', NOW(), NOW(), 'shaun_event', (SELECT MAX(p.`order`) + 1 FROM `{prefix}permission_groups` as p));

INSERT INTO `{prefix}permissions` (`name`, `key`, `is_support_guest`, `group_id`, `created_at`, `updated_at`, `type`, `is_support_moderator`, `order`, `description`) VALUES
('Manage Events', 'admin.event.manage', 0, 1, NOW(), NOW(), 'checkbox', 1, (SELECT MAX(p.`order`) + 1 FROM `{prefix}permissions` as p), ''),
('Event Categories', 'admin.event.manage_categories', 0, 1, NOW(), NOW(), 'checkbox', 1, (SELECT MAX(p.`order`) + 1 FROM `{prefix}permissions` as p), ''),
('Allow event creation', 'event.allow_create', 0, (SELECT `id` FROM `{prefix}permission_groups` WHERE `key` = 'event'), NOW(), NOW(), 'checkbox', 0, (SELECT MAX(p.`order`) + 1 FROM `{prefix}permissions` as p), ''),
('Maximum number of events can create per day (0 is unlimited)', 'event.create_per_day', 0, (SELECT `id` FROM `{prefix}permission_groups` WHERE `key` = 'event'), NOW(), NOW(), 'number', 0, (SELECT MAX(p.`order`) + 1 FROM `{prefix}permissions` as p), '');

INSERT INTO `{prefix}translations` (`table_name`, `column_name`, `foreign_key`, `locale`, `value`) VALUES
('permissions', 'message_error', (SELECT `id` FROM `{prefix}permissions` WHERE `key` = 'event.allow_create'), 'en', "You don't have event creation permission."),
('permissions', 'message_error', (SELECT `id` FROM `{prefix}permissions` WHERE `key` = 'event.create_per_day'), 'en', "To prevent spam, we only allow you to create a maximum of [x] events per day.");

INSERT INTO `{prefix}setting_group_subs` (`name`, `group_id`, `key`, `order`, `package`) VALUES
('Event', 2, 'event', (SELECT MAX(p.`order`) + 1 FROM `{prefix}setting_group_subs` as p), 'shaun_event');

INSERT INTO `{prefix}settings` (`key`, `name`, `description`, `value`, `params`, `type`, `order`, `group_id`, `group_sub_id`, `hidden`) VALUES
('shaun_event.enable', 'Enable', "If this option is disable, member can't access event menu and all existing events.", '1', '', 'checkbox', 1, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'event'), 0),
('shaun_event.auto_approve', 'Auto approve', '', '0', '', 'checkbox', 2, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'event'), 0),
('shaun_event.cover_default', 'Cover event default image', 'We recommend using an image with a resolution of 1024x385 for the default event cover image.', '', '{"default":"images/default/cover_group.png","style_width":"200"}', 'image', 3, 2, (SELECT `id` FROM `{prefix}setting_group_subs` WHERE `key` = 'event'), 0);

INSERT INTO `{prefix}event_categories` (`id`, `name`, `parent_id`, `is_active`, `is_delete`, `order`, `created_at`, `updated_at`) VALUES
(100, 'Sports', 0, 1, 0, 99, NOW(), NOW()),
(101, 'Technology', 0, 1, 0, 100, NOW(), NOW()),
(102, 'Art', 0, 1, 0, 101, NOW(), NOW()),
(103, 'Entertainment', 0, 1, 0, 102, NOW(), NOW()),
(104, 'Gaming', 0, 1, 0, 103, NOW(), NOW()),
(105, 'Politics', 0, 1, 0, 104, NOW(), NOW()),
(106, 'Business', 0, 1, 0, 105, NOW(), NOW()),
(107, 'Culture', 0, 1, 0, 106, NOW(), NOW()),
(108, 'Science', 0, 1, 0, 107, NOW(), NOW()),
(109, 'Food', 0, 1, 0, 108, NOW(), NOW()),
(110, 'Animals', 0, 1, 0, 109, NOW(), NOW()),
(111, 'Education', 0, 1, 0, 110, NOW(), NOW()),
(112, 'Fashion & Beauty', 0, 1, 0, 111, NOW(), NOW()),
(113, 'Health & Fitness', 0, 1, 0, 112, NOW(), NOW()),
(114, 'News', 0, 1, 0, 113, NOW(), NOW()),
(115, 'Cryptocurrency', 0, 1, 0, 114, NOW(), NOW()),
(116, 'Travel', 0, 1, 0, 115, NOW(), NOW());

INSERT INTO `{prefix}translations` (`table_name`, `column_name`, `foreign_key`, `locale`, `value`) VALUES
('event_categories', 'name', 100, 'en', 'Sports'),
('event_categories', 'name', 101, 'en', 'Technology'),
('event_categories', 'name', 102, 'en', 'Art'),
('event_categories', 'name', 103, 'en', 'Entertainment'),
('event_categories', 'name', 104, 'en', 'Gaming'),
('event_categories', 'name', 105, 'en', 'Politics'),
('event_categories', 'name', 106, 'en', 'Business'),
('event_categories', 'name', 107, 'en', 'Culture'),
('event_categories', 'name', 108, 'en', 'Science'),
('event_categories', 'name', 109, 'en', 'Food'),
('event_categories', 'name', 110, 'en', 'Animals'),
('event_categories', 'name', 111, 'en', 'Education'),
('event_categories', 'name', 112, 'en', 'Fashion & Beauty'),
('event_categories', 'name', 113, 'en', 'Health & Fitness'),
('event_categories', 'name', 114, 'en', 'News'),
('event_categories', 'name', 115, 'en', 'Cryptocurrency'),
('event_categories', 'name', 116, 'en', 'Travel');

INSERT INTO `{prefix}layout_maps` (`router`, `layout_class`) VALUES
('event_list', 'Packages\\ShaunSocial\\Event\\Repositories\\Helpers\\Layout\\EventLayout'),
('event_detail', 'Packages\\ShaunSocial\\Event\\Repositories\\Helpers\\Layout\\EventDetailLayout');

INSERT INTO `{prefix}layout_blocks` (`component`, `title`, `enable`, `class`, `support_header_footer`, `created_at`, `updated_at`, `package`) VALUES
('EventFeatured', 'Featured Events', 1, 'Packages\\ShaunSocial\\Event\\Repositories\\Helpers\\Widget\\EventFeaturedWidget', 0, NOW(), NOW(), 'shaun_event'),
('EventPopular', 'Popular Events', 1, 'Packages\\ShaunSocial\\Event\\Repositories\\Helpers\\Widget\\EventPopularWidget', 0, NOW(), NOW(), 'shaun_event');