DROP TABLE feature_controls;

CREATE TABLE `feature_controls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feature_controls_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

INSERT INTO feature_controls (name, enabled, description) VALUES
('Portal Management', '1', 'On the portal, users login times are meticulously tracked and prominently displayed. This feature ensures transparency and accountability, aiding in efficient monitoring of user activities. By providing clear visibility into login activities, administrators can better manage security protocols and analyze user engagement patterns for improved system performance and user experience'),
('Leave Management', '1', 'The leave management functionality allows users to request, approve, and track leave efficiently. Users can submit leave applications, view their leave balances, and check the status of their requests. Managers can review and approve or reject leave requests, ensuring seamless communication and record-keeping. This system enhances transparency and streamlines the leave process'
),
('Shift Management', '1', 'The Shift Roster functionality enables managers to assign shifts to employees effortlessly. Employees can view their assigned shifts, ensuring clarity and organization. This feature allows for easy shift application, updates, and notifications, fostering effective scheduling and communication within the team. It helps streamline shift management and improves overall operational efficiency'),
('Payslip Management', '1', 'The Payslip functionality allows employees to access their payslips securely online. Employees can view, download, and print their payslips, ensuring they have easy access to their salary details, deductions, and net pay. This feature promotes transparency, simplifies payroll management, and provides employees with timely and accurate compensation information'),
('Policy Document', '1', 'The Policy Document functionality provides employees with easy access to important company policies and procedures. Employees can view, download, and refer to policy documents anytime, ensuring they are informed about company rules, guidelines, and standards. This feature promotes transparency, ensures compliance, and helps maintain a well-informed workforce'),
('Gallery management', '1', 'The Gallery functionality allows users to upload, view, and share photos and videos within the organization. Employees can browse through categorized albums, showcasing events, achievements, and memorable moments. This feature fosters a sense of community, enhances employee engagement, and provides a visual record of the organization culture and activities'),
('Timesheet Management', '1', 'The Timesheet functionality enables employees to log their work hours and track time spent on various tasks and projects. This feature allows for easy submission, review, and approval of timesheets, ensuring accurate record-keeping and payroll processing. It enhances productivity, supports project management, and provides valuable insights into work patterns and resource allocation'),
('Expenses Management', '1', 'The Expenses functionality allows employees to submit and track their expense claims efficiently. Users can upload receipts, categorize expenses, and monitor the status of their reimbursements. Managers can review, approve, or reject claims, ensuring accurate and timely processing. This feature streamlines expense management, enhances financial transparency, and simplifies the reimbursement process'),
('Activity Log', '1', 'The Activity Log functionality provides a comprehensive record of user actions within the system. It tracks and logs activities such as logins, updates, deletions, and other significant events. This feature enhances security, supports auditing and compliance, and allows administrators to monitor user behavior, ensuring accountability and transparency in system usage'),
('Event Management', '1', 'The Event functionality allows users to create, manage, and participate in organizational events'),
('Chatify', '1', 'The Chatify functionality enables real-time messaging and communication within the organization. Users can send instant messages, share files, and create group chats, promoting efficient collaboration and quick information sharing. This feature enhances team connectivity, streamlines communication, and supports a dynamic and interactive work environment');