CREATE TABLE `offline_usernames` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 UNIQUE KEY `offline_usernames_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `roles` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `app_users` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `guid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `os` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `app_version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `carrier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `more_info` longtext COLLATE utf8mb4_unicode_ci,
 `tribal_affiliation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `verified` tinyint(1) DEFAULT '0',
 `revoked` tinyint(1) DEFAULT '0',
 `admin_revoked` tinyint(1) DEFAULT '0',
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 `username_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `username_fk_8396610` (`username_id`),
 CONSTRAINT `username_fk_8396610` FOREIGN KEY (`username_id`) REFERENCES `offline_usernames` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=390 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `app_user_progress` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `total_activities` int(11) NOT NULL,
 `finished_activities` int(11) NOT NULL,
 `categories_started` int(11) DEFAULT NULL,
 `categories_finished` int(11) NOT NULL,
 `words_started` int(11) NOT NULL,
 `words_finished` int(11) NOT NULL,
 `app_starts` int(11) NOT NULL,
 `app_wakes` int(11) NOT NULL,
 `network_errors` int(11) NOT NULL,
 `updates_installed` int(11) NOT NULL,
 `data_resets` int(11) NOT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 `user_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `user_fk_8382413` (`user_id`),
 CONSTRAINT `user_fk_8382413` FOREIGN KEY (`user_id`) REFERENCES `app_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3452 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `app_versions` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `os` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `audit_logs` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
 `subject_id` bigint(20) unsigned DEFAULT NULL,
 `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `user_id` bigint(20) unsigned DEFAULT NULL,
 `properties` text COLLATE utf8mb4_unicode_ci,
 `host` varchar(46) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=471 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `categories` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `english_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `language_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `locked` tinyint(1) DEFAULT '0',
 `c_order` int(11) NOT NULL,
 `basic` tinyint(1) NOT NULL DEFAULT '0',
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `categories_c_order_unique` (`c_order`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `content_categories` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `content_pages` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `page_text` longtext COLLATE utf8mb4_unicode_ci,
 `excerpt` longtext COLLATE utf8mb4_unicode_ci,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `content_category_content_page` (
 `content_page_id` bigint(20) unsigned NOT NULL,
 `content_category_id` bigint(20) unsigned NOT NULL,
 KEY `content_page_id_fk_8382404` (`content_page_id`),
 KEY `content_category_id_fk_8382404` (`content_category_id`),
 CONSTRAINT `content_category_id_fk_8382404` FOREIGN KEY (`content_category_id`) REFERENCES `content_categories` (`id`) ON DELETE CASCADE,
 CONSTRAINT `content_page_id_fk_8382404` FOREIGN KEY (`content_page_id`) REFERENCES `content_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `content_tags` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `content_page_content_tag` (
 `content_page_id` bigint(20) unsigned NOT NULL,
 `content_tag_id` bigint(20) unsigned NOT NULL,
 KEY `content_page_id_fk_8382405` (`content_page_id`),
 KEY `content_tag_id_fk_8382405` (`content_tag_id`),
 CONSTRAINT `content_page_id_fk_8382405` FOREIGN KEY (`content_page_id`) REFERENCES `content_pages` (`id`) ON DELETE CASCADE,
 CONSTRAINT `content_tag_id_fk_8382405` FOREIGN KEY (`content_tag_id`) REFERENCES `content_tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;


CREATE TABLE `faq_categories` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `faq_questions` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `question` longtext COLLATE utf8mb4_unicode_ci,
 `answer` longtext COLLATE utf8mb4_unicode_ci,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 `category_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `category_fk_8382312` (`category_id`),
 CONSTRAINT `category_fk_8382312` FOREIGN KEY (`category_id`) REFERENCES `faq_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `migrations` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `batch` int(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `permissions` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;



CREATE TABLE `permission_role` (
 `role_id` bigint(20) unsigned NOT NULL,
 `permission_id` bigint(20) unsigned NOT NULL,
 KEY `role_id_fk_8381947` (`role_id`),
 KEY `permission_id_fk_8381947` (`permission_id`),
 CONSTRAINT `permission_id_fk_8381947` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
 CONSTRAINT `role_id_fk_8381947` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;


CREATE TABLE `popup_texts` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `pronunciation_guides` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `letter` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `text` longtext COLLATE utf8mb4_unicode_ci,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;


CREATE TABLE `role_user` (
 `user_id` bigint(20) unsigned NOT NULL,
 `role_id` bigint(20) unsigned NOT NULL,
 KEY `user_id_fk_8381956` (`user_id`),
 KEY `role_id_fk_8381956` (`role_id`),
 CONSTRAINT `role_id_fk_8381956` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
 CONSTRAINT `user_id_fk_8381956` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;


CREATE TABLE `user_alerts` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `alert_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `alert_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `user_user_alert` (
 `user_alert_id` bigint(20) unsigned NOT NULL,
 `user_id` bigint(20) unsigned NOT NULL,
 `read` tinyint(1) NOT NULL DEFAULT '0',
 KEY `user_alert_id_fk_8382386` (`user_alert_id`),
 KEY `user_id_fk_8382386` (`user_id`),
 CONSTRAINT `user_alert_id_fk_8382386` FOREIGN KEY (`user_alert_id`) REFERENCES `user_alerts` (`id`) ON DELETE CASCADE,
 CONSTRAINT `user_id_fk_8382386` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `words` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `english` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `sound` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
 `image_size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `sound_size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `locked` tinyint(1) DEFAULT '0',
 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `deleted_at` timestamp NULL DEFAULT NULL,
 `category_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `category_fk_8382040` (`category_id`),
 CONSTRAINT `category_fk_8382040` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;




INSERT INTO `app_versions` (`id`, `os`, `version`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'iOS', '1.0.0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL),
(2, 'Android', '1.0.0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL),
(3, 'MacOS', '0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL),
(4, 'Windows', '0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL),
(5, 'Linux', '0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL),
(6, 'WebGL', '0', '2023-05-09 09:18:52', '2023-05-09 09:18:52', NULL);


INSERT INTO `offline_usernames` (`id`, `username`, `created_at`, `updated_at`) VALUES
(1, 'apple', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(2, 'banana', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(3, 'cherry', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(4, 'date', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(5, 'elderberry', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(6, 'fig', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(7, 'grape', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(8, 'honeydew', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(9, 'kiwi', '2023-04-25 16:00:00', '2023-04-25 16:00:00'),
(10, 'lemon', '2023-04-25 16:00:00', '2023-04-25 16:00:00');


INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'user_management_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(2, 'permission_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(3, 'permission_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(4, 'permission_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(5, 'permission_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(6, 'permission_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(7, 'role_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(8, 'role_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(9, 'role_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(10, 'role_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(11, 'role_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(12, 'user_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(13, 'user_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(14, 'user_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(15, 'user_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(16, 'user_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(17, 'app_management_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(18, 'app_version_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(19, 'app_version_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(20, 'app_version_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(21, 'popup_text_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(22, 'popup_text_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(23, 'popup_text_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(24, 'pronunciation_guide_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(25, 'pronunciation_guide_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(26, 'pronunciation_guide_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(27, 'pronunciation_guide_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(28, 'pronunciation_guide_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(29, 'category_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(30, 'category_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(31, 'category_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(32, 'category_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(33, 'category_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(34, 'word_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(35, 'word_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(36, 'word_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(37, 'word_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(38, 'word_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(39, 'app_user_management_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(40, 'app_user_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(41, 'app_user_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(42, 'app_user_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(43, 'offline_username_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(44, 'offline_username_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(45, 'faq_management_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(46, 'faq_category_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(47, 'faq_category_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(48, 'faq_category_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(49, 'faq_category_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(50, 'faq_category_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(51, 'faq_question_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(52, 'faq_question_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(53, 'faq_question_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(54, 'faq_question_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(55, 'faq_question_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(56, 'audit_log_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(57, 'audit_log_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(58, 'user_alert_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(59, 'content_management_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(60, 'content_category_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(61, 'content_category_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(62, 'content_category_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(63, 'content_category_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(64, 'content_category_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(65, 'content_tag_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(66, 'content_tag_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(67, 'content_tag_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(68, 'content_tag_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(69, 'content_tag_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(70, 'content_page_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(71, 'content_page_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(72, 'content_page_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(73, 'content_page_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(74, 'content_page_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(75, 'app_user_progress_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(76, 'pending_user_create', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(77, 'pending_user_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(78, 'pending_user_show', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(79, 'pending_user_delete', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(80, 'pending_user_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(81, 'pending_user_approve', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(82, 'profile_password_edit', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(83, 'proofing_access', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL),
(84, 'app_user_approve', '2023-05-04 06:34:01', '2023-05-04 06:34:01', NULL);

INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', '2023-05-09 05:18:51', '2023-05-09 05:18:51', NULL),
(2, 'User', '2023-05-09 05:18:51', '2023-05-09 05:18:51', NULL);

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
(1, 71),
(1, 72),
(1, 73),
(1, 74),
(1, 75),
(1, 76),
(1, 77),
(1, 78),
(1, 79),
(1, 80),
(1, 81),
(1, 82),
(1, 83),
(1, 84),
(2, 17),
(2, 18),
(2, 19),
(2, 20),
(2, 21),
(2, 22),
(2, 23),
(2, 24),
(2, 25),
(2, 26),
(2, 27),
(2, 28),
(2, 29),
(2, 30),
(2, 31),
(2, 32),
(2, 33),
(2, 34),
(2, 35),
(2, 36),
(2, 37),
(2, 38),
(2, 39),
(2, 40),
(2, 41),
(2, 42),
(2, 43),
(2, 44),
(2, 45),
(2, 46),
(2, 47),
(2, 48),
(2, 49),
(2, 50),
(2, 51),
(2, 52),
(2, 53),
(2, 54),
(2, 55),
(2, 56),
(2, 57),
(2, 59),
(2, 60),
(2, 61),
(2, 62),
(2, 63),
(2, 64),
(2, 65),
(2, 66),
(2, 67),
(2, 68),
(2, 69),
(2, 70),
(2, 71),
(2, 72),
(2, 73),
(2, 74),
(2, 75),
(2, 76),
(2, 77),
(2, 78),
(2, 79),
(2, 80),
(2, 81),
(2, 82),
(2, 83),
(2, 84);

INSERT INTO `popup_texts` (`id`, `name`, `text`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'about_us', 'This app was produced by the Wichita and Affiliated Tribes with the technical support of The Language Conservancy 501(c)(3) non-profit organization to further the mission of providing Wichita resources to communities of learners in Anadarko, Oklahoma, and around the world.<br>Development is made possible by Grant Number 90XN0038 from Administration for Native Americans.<br>Its contents are solely the responsibility of Wichita and Affiliated Tribes and do not necessarily represent the official views of the Administration for Children and Families, Administration for Native Americans, or the Department of Health & Human Services.', '2023-04-25 16:00:00', '2023-07-12 17:46:25', NULL),
(2, 'spelling', 'Tap the blocks in the correct order to spell the word.<br><br>Click the upper panel to hear the word again.<br><br>Correctly placed letters will stay in place for the next try.', '2023-04-25 16:00:00', '2023-04-25 16:00:00', NULL),
(3, 'word_search', 'Find the 4 {Language.CurrentLanguage.LanguageName} words in the letter grid. The English versions can be found at the bottom. <br><br> The words can be oriented forward, backward, up, down, or diagonal.<br><br>Touch and drag to select the letters until the full word is highlighted.<br><br>Tap the light bulb in the upper right to see hints.', '2023-04-25 16:00:00', '2023-04-25 16:00:00', NULL),
(4, 'flight', 'Tap to the right or left of the bird to move.<br><br>Fly into the picture of the words shown above.<br><br>Avoid incorrect pictures and especially avoid the dangerous hawks!', '2023-04-25 16:00:00', '2023-04-25 16:00:00', NULL),
(5, 'category_list_native', 'Category List', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(6, 'next_game_native', 'Next Game', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(7, 'new_words_native', 'New Words', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(8, 'great_job_native', 'óono pó\'!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(9, 'im_sorry_native', 'Haxáam.', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(10, 'better_luck_next_time_native', 'Yúpan!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(11, 'wow_native', 'Wow!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(12, 'you_finished_all_games_for_this_round_native', 'You finished all the games for this round!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(13, 'amazing_native', 'Lóoviqa!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(14, 'you_completed_the_entire_category_native', 'You completed the entire category!', '2023-06-07 18:37:10', '2023-06-07 18:37:10', NULL),
(15, 'you_did_an_amazing_job_finishing_that_game_native', 'You did an amazing job finishing that game!', '2023-06-07 18:54:46', '2023-06-07 18:54:46', NULL);

INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1);

INSERT INTO `app_users` (`id`, `name`, `email`, `guid`, `os`, `app_version`, `phone`, `carrier`, `more_info`, `tribal_affiliation`, `verified`, `revoked`, `admin_revoked`, `created_at`, `updated_at`, `deleted_at`, `username_id`) VALUES
(2, NULL, NULL, '002', 'iOS', '1.0.0', NULL, NULL, NULL, NULL, 0, 0, 0, '2023-08-01 14:55:45', '2023-08-01 14:55:45', NULL, NULL);