-- Real Notiz backup generated at 2026-07-29 14:02:34
SET FOREIGN_KEY_CHECKS=0;

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `department_id`, `role_id`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `two_factor_enabled`, `username`, `is_super_admin`, `is_active`, `company_id`) VALUES ('1', 'Super Admin', 'admin@notifyhub.local', NULL, '$2y$04$e.tqaCCNnY3BLDzEBZOsROiNvBypwLyF//YdQQd9tfJm0xKyJ6Rhu', NULL, '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL, NULL, NULL, NULL, NULL, '0', 'superadmin', '1', '1', NULL);
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `department_id`, `role_id`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `two_factor_enabled`, `username`, `is_super_admin`, `is_active`, `company_id`) VALUES ('2', 'Company Admin', 'company.admin@notifyhub.local', NULL, '$2y$04$GNkRtwmHlPv1lFvFJwmNAO8/Pym9kyYgdBJkbb3Jif3VRsxDY9Zui', NULL, '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL, '1', NULL, NULL, NULL, '0', 'companyadmin', '0', '1', '1');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `department_id`, `role_id`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `two_factor_enabled`, `username`, `is_super_admin`, `is_active`, `company_id`) VALUES ('3', 'Manager User', 'manager@notifyhub.local', NULL, '$2y$04$nSRmWxty8s5U/nAoYs9W1O.iJgO70BaMADPbik86lghok/x.qEpYK', NULL, '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL, '2', NULL, NULL, NULL, '0', 'manager', '0', '1', '1');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `department_id`, `role_id`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `two_factor_enabled`, `username`, `is_super_admin`, `is_active`, `company_id`) VALUES ('4', 'Viewer User', 'viewer@notifyhub.local', NULL, '$2y$04$4DfojqBufE3OTq13y0hfrOEUmu2vuh3OOhDw0Gk4V0ElYUiCscDNG', NULL, '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL, '3', NULL, NULL, NULL, '0', 'viewer', '0', '1', '1');

INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('1', 'credited', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('2', 'debited', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('3', 'payment', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('4', 'otp', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('5', 'momo', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('6', 'received', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');
INSERT INTO `keywords` (`id`, `keyword`, `status`, `created_at`, `updated_at`, `company_id`) VALUES ('7', 'bank', 'active', '2026-07-29 14:02:34', '2026-07-29 14:02:34', '1');

INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('1', 'app_name', 'Real Notiz', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('2', 'logo_path', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('3', 'favicon_path', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('4', 'default_theme', 'dark', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('5', 'maintenance_mode', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('6', 'maintenance_message', 'Real Notiz is undergoing scheduled maintenance. Please check back soon.', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('7', 'notify_otp_alerts', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('8', 'notify_large_payment_alerts', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('9', 'notify_sync_failure_alerts', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('10', 'notify_email_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('11', 'notify_email_recipients', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('12', 'notify_telegram_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('13', 'telegram_bot_token', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('14', 'telegram_chat_id', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('15', 'notify_sms_alerts', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('16', 'sms_gateway_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('17', 'sms_provider', 'none', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('18', 'sms_arkesel_api_key', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('19', 'sms_arkesel_sender_id', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('20', 'sms_default_recipients', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('21', 'mail_gateway_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('22', 'mail_mailer', 'smtp', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('23', 'mail_host', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('24', 'mail_port', '587', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('25', 'mail_username', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('26', 'mail_password', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('27', 'mail_encryption', 'tls', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('28', 'mail_from_address', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('29', 'mail_from_name', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('30', 'require_device_hmac', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('31', 'webhook_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('32', 'webhook_url', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('33', 'webhook_secret', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('34', 'webhook_events', '[\"message.received\",\"alert.created\"]', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('35', 'large_payment_threshold', '1000', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('36', 'notify_sound_enabled', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('37', 'notify_sound_announce_device', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('38', 'message_poll_enabled', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('39', 'message_poll_interval_minutes', '5', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('40', 'allow_device_code_reuse', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('41', 'two_factor_policy', 'optional', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('42', 'payment_gateway_enabled', 'false', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('43', 'payment_provider', 'none', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('44', 'paystack_secret_key', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('45', 'paystack_public_key', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('46', 'paystack_webhook_secret', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('47', 'hubtel_client_id', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('48', 'hubtel_client_secret', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('49', 'hubtel_merchant_account_number', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('50', 'hubtel_webhook_secret', '', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('51', 'payment_currency', 'GHS', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('52', 'payment_registration_amount', '100', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('53', 'login_max_attempts', '5', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('54', 'login_lockout_minutes', '15', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('55', 'security_headers_enabled', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `company_id`) VALUES ('56', 'require_device_id_header', 'true', '2026-07-29 14:02:34', '2026-07-29 14:02:34', NULL);

SET FOREIGN_KEY_CHECKS=1;