⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.142
Server IP:
217.76.53.76
Server:
Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software:
Apache
PHP Version:
8.2.27
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
wwwroot
/
groupchat.whatxap.com
/
installer
/
View File Name :
chatnet.sql
SET FOREIGN_KEY_CHECKS=0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `chatnet` -- -- -------------------------------------------------------- -- -- Table structure for table `cn_chat_groups` -- DROP TABLE IF EXISTS `cn_chat_groups`; CREATE TABLE IF NOT EXISTS `cn_chat_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `chat_room` int(11) NOT NULL, `cover_image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_protected` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'True = 1, False = 0', `password` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'ACTIVE = 1, INACTIVE = 2', `created_by` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_chat_groups_idx_id` (`id`), KEY `cn_chat_groups_idx_chat_room_slug` (`chat_room`,`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_chat_rooms` -- DROP TABLE IF EXISTS `cn_chat_rooms`; CREATE TABLE IF NOT EXISTS `cn_chat_rooms` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `room_notice_message` text COLLATE utf8mb4_unicode_ci, `room_notice_class` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_protected` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'True = 1, False = 0', `password` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True = 1, False = 0', `chat_validity` int DEFAULT NULL COMMENT 'hours', `slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `allowed_users` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `allow_guest_view` tinyint(1) DEFAULT NULL, `ad_chat_right_bar` text COLLATE utf8mb4_unicode_ci, `ad_chat_left_bar` text COLLATE utf8mb4_unicode_ci, `show_background` tinyint(1) DEFAULT NULL, `background_image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` smallint NOT NULL DEFAULT '1' COMMENT 'ACTIVE = 1, INACTIVE = 2', `created_by` int DEFAULT NULL, `hide_chat_list` tinyint DEFAULT NULL, `disable_private_chats` tinyint DEFAULT NULL, `disable_group_chats` tinyint DEFAULT NULL, `user_list_type` tinyint DEFAULT NULL, `user_list_auth_roles` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '[]', `room_auto_join` tinyint DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_chat_rooms_idx_created_by` (`created_by`), KEY `cn_chat_rooms_idx_status_is_visible` (`status`,`is_visible`), KEY `cn_chat_rooms_idx_slug` (`slug`), KEY `cn_chat_rooms_idx_id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_group_chats` -- DROP TABLE IF EXISTS `cn_group_chats`; CREATE TABLE IF NOT EXISTS `cn_group_chats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `room_id` int(11) NOT NULL, `type` smallint(6) NOT NULL DEFAULT '1' COMMENT 'text= 1, image= 2, gif= 3', `message` text COLLATE utf8mb4_unicode_ci, `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'send= 1, seen = 2, deleted = 3', `reactions` varchar(50) NULL DEFAULT NULL, `time` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_group_chats_idx_id_group_id_sender_id` (`id`,`group_id`,`sender_id`), KEY `cn_group_chats_idx_group_id_room_id` (`group_id`,`room_id`), KEY `cn_group_chats_idx_id_group_id_room_id` (`id`,`group_id`,`room_id`), KEY `cn_group_chats_idx_updated_at_group_id` (`updated_at`,`group_id`), KEY `cn_group_chats_idx_sender_id` (`sender_id`), KEY `cn_group_chats_idx_sender_id_time_status` (`sender_id`, `status`, `time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_group_users` -- DROP TABLE IF EXISTS `cn_group_users`; CREATE TABLE IF NOT EXISTS `cn_group_users` ( `id` int NOT NULL AUTO_INCREMENT, `user` int NOT NULL, `chat_group` int NOT NULL, `user_type` smallint NOT NULL DEFAULT '2' COMMENT 'Group admin = 1, Group user = 2, Guest user = 3', `status` smallint NOT NULL DEFAULT '1' COMMENT 'Active = 1, Inactive = 2', `is_typing` tinyint(1) NOT NULL DEFAULT '0', `is_muted` tinyint NOT NULL DEFAULT '0', `unread_count` int NOT NULL DEFAULT '0', `is_mod` tinyint(1) NOT NULL DEFAULT '0', `load_chats_from` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `cn_group_users_idx_chat_group` (`chat_group`), KEY `cn_group_users_idx_user` (`user`), KEY `cn_group_users_idx_user_chat_group` (`user`,`chat_group`), KEY `cn_group_users_idx_is_muted_user_chat_group` (`is_muted`,`USER`,`chat_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_ip_logs` -- DROP TABLE IF EXISTS `cn_ip_logs`; CREATE TABLE IF NOT EXISTS `cn_ip_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `country` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time` datetime DEFAULT NULL, `type` int(11) NOT NULL DEFAULT '1' COMMENT '1 login, 2, register, 3 pass reset', `message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_languages` -- DROP TABLE IF EXISTS `cn_languages`; CREATE TABLE IF NOT EXISTS `cn_languages` ( `code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `direction` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ltr', `google_font_family` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_lang_terms` -- DROP TABLE IF EXISTS `cn_lang_terms`; CREATE TABLE IF NOT EXISTS `cn_lang_terms` ( `id` int NOT NULL AUTO_INCREMENT, `term` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `section` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_private_chats` -- DROP TABLE IF EXISTS `cn_private_chats`; CREATE TABLE IF NOT EXISTS `cn_private_chats` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_1` int(11) NOT NULL, `user_2` int(11) NOT NULL, `sender_id` int(11) NOT NULL, `room_id` int(11) NOT NULL, `type` smallint(6) NOT NULL DEFAULT '1' COMMENT 'text=1, image=2, gif=3', `message` text COLLATE utf8mb4_unicode_ci, `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'send= 1, seen = 2, deleted = 3', `reactions` varchar(50) NULL DEFAULT NULL, `time` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_private_chats_idx_id` (`id`), KEY `cn_private_chats_idx_user_1_user_2_room_id_sender_id` (`user_1`,`user_2`,`room_id`,`sender_id`), KEY `cn_private_chats_idx_user_1_user_2_room_id` (`user_1`,`user_2`,`room_id`), KEY `cn_private_chats_idx_id_user_1_user_2_room_id` (`id`,`user_1`,`user_2`,`room_id`), KEY `cn_private_chats_idx_updated_at_user_1_user_2_room_id` (`updated_at`,`user_1`,`user_2`,`room_id`), KEY `cn_private_chats_idx_user_2_sender_id` (`user_2`,`sender_id`), KEY `cn_private_chats_idx_user_1_sender_id` (`user_1`,`sender_id`), KEY `cn_private_chats_idx_sender_id_time_status` (`sender_id`, `status`, `time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_private_chat_meta` -- DROP TABLE IF EXISTS `cn_private_chat_meta`; CREATE TABLE IF NOT EXISTS `cn_private_chat_meta` ( `id` int NOT NULL AUTO_INCREMENT, `from_user` int NOT NULL, `to_user` int NOT NULL, `room_id` int DEFAULT NULL, `is_typing` tinyint(1) DEFAULT '0', `is_blocked` tinyint(1) DEFAULT '0', `is_favourite` tinyint(1) DEFAULT '0', `is_muted` tinyint DEFAULT '0', `unread_count` int DEFAULT '0', `last_chat_id` int DEFAULT NULL, `load_chats_from` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_private_chat_me_idx_to_user_room_id_from_user` (`to_user`,`room_id`,`from_user`), KEY `cn_private_chat_me_idx_from_user_to_user` (`from_user`,`to_user`), KEY `cn_private_chat_me_idx_is_muted_from_user_to_user` (`is_muted`,`from_user`,`to_user`), KEY `cn_private_chat_me_idx_from_user_to_user_id` (`from_user`,`to_user`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_push_devices` -- DROP TABLE IF EXISTS `cn_push_devices`; CREATE TABLE IF NOT EXISTS `cn_push_devices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `token` text COLLATE utf8mb4_unicode_ci NOT NULL, `device` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `perm_group` tinyint(1) NOT NULL DEFAULT '0', `perm_private` tinyint(1) NOT NULL DEFAULT '1', `perm_mentions` tinyint(1) NOT NULL DEFAULT '1', `perm_notice` tinyint(1) NOT NULL DEFAULT '1', `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_radio_stations` -- DROP TABLE IF EXISTS `cn_radio_stations`; CREATE TABLE IF NOT EXISTS `cn_radio_stations` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source` text COLLATE utf8mb4_unicode_ci, `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_settings` -- DROP TABLE IF EXISTS `cn_settings`; CREATE TABLE IF NOT EXISTS `cn_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_social_logins` -- DROP TABLE IF EXISTS `cn_social_logins`; CREATE TABLE IF NOT EXISTS `cn_social_logins` ( `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `id_key` text COLLATE utf8mb4_unicode_ci NOT NULL, `secret_key` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_translations` -- DROP TABLE IF EXISTS `cn_translations`; CREATE TABLE IF NOT EXISTS `cn_translations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lang_code` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `term_id` int(11) DEFAULT NULL, `translation` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `cn_translations_idx_term_id_lang_code` (`term_id`,`lang_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cn_users` -- DROP TABLE IF EXISTS `cn_users`; CREATE TABLE IF NOT EXISTS `cn_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` date DEFAULT NULL, `sex` smallint(6) DEFAULT NULL COMMENT 'MALE = 1, FEMALE = 2, OTHER = 3', `avatar` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `about` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_status` smallint(6) DEFAULT '1' COMMENT 'ONLINE = 1, OFFLINE = 2, BUSY = 3', `available_status` smallint(6) DEFAULT '1' COMMENT 'ACTIVE = 1, INACTIVE = 2', `last_seen` datetime NULL DEFAULT NULL, `last_login` datetime NULL DEFAULT NULL, `user_type` smallint(6) NOT NULL DEFAULT '2' COMMENT 'Admin = 1, Chat User = 2', `reset_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `timezone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Asia/Colombo', `country` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activation_key` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_key` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `badges` varchar(200) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_name` (`user_name`,`email`), KEY `cn_users_idx_id` (`id`), KEY `cn_users_idx_user_type` (`user_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for table `cn_users` -- ALTER TABLE `cn_users` ADD FULLTEXT KEY `name` (`first_name`,`last_name`); -- -- Dumping data for table `cn_settings` -- INSERT INTO `cn_settings` (`name`, `value`) VALUES ('timezone', 'Asia/Colombo'), ('chat_receive_seconds', '3'), ('user_list_check_seconds', '5'), ('chat_status_check_seconds', '3'), ('online_status_check_seconds', '10'), ('typing_status_check_seconds', '3'), ('current_version', '1.9'), ('enable_gif', '1'), ('enable_stickers', '1'), ('enable_images', '1'), ('member_registration', '1'), ('homepage_chat_room_view', 'small'), ('site_name', 'ChatNet'), ('sent_animation', 'animate__fadeIn'), ('replies_animation', 'animate__fadeIn'), ('radio', '0'), ('enable_social_login', '0'), ('push_notifications', '0'), ('pwa_enabled', '0'), ('allow_multiple_sessions', '1'), ('push_provider', 'firebase'), ('guest_inactive_hours', '48'), ('enable_recaptcha', '0'), ('enable_ip_logging', '0'), ('enable_ip_blacklist', '0'), ('autodetect_country', '0'), ('geoip_api_endpoint', 'http://ip-api.com/json/'), ('enable_email_verification', '0'), ('disable_join_confirmation', '0'), ('email_smtp', '0'), ('enable_multiple_languages', '0'), ('delete_group_chat_hours', '0'), ('delete_private_chat_hours', '0'), ('only_online_users', '0'), ('hide_chat_list', '0'), ('disable_private_chats', '0'), ('domain_filter', '0'), ('domains_list', ''), ('sso_enabled', '0'), ('sso_home_url', ''), ('sso_allowed_orgins', ''), ('sso_login_url', ''), ('sso_logout_url', ''), ('sso_allow_profile_edit', '0'), ('flood_control_message_limit', '1'), ('flood_control_time_limit', '1'), ('enable_codes', '1'), ('user_list_auth_roles', '[]'), ('boxed_bg', '0'), ('disable_group_chats', '0'), ('user_list_type', '1'), ('chatpage_layout', 'full'), ('cloud_storage', '0'), ('cloud_storage_type', 'aws'), ('cloud_storage_endpoint', ''), ('cloud_storage_region', ''), ('cloud_storage_key', ''), ('cloud_storage_secret', ''), ('cloud_storage_bucket', ''), ('cloud_storage_url', ''), ('cloud_storage_ssl_verify', ''), ('react_name_1', 'Like'), ('react_name_2', 'Love'), ('react_name_3', 'Care'), ('react_name_4', 'Haha'), ('react_name_5', 'Wow'), ('react_name_6', 'Sad'), ('react_name_7', 'Angry'), ('react_enable_1', '1'), ('react_enable_2', '1'), ('react_enable_3', '1'), ('react_enable_4', '1'), ('react_enable_5', '1'), ('react_enable_6', '1'), ('react_enable_7', '1'), ('react_css_1', 'animate__rubberBand'), ('react_css_2', 'animate__heartBeat'), ('react_css_3', 'animate__headShake'), ('react_css_4', 'animate__swing'), ('react_css_5', 'animate__tada'), ('react_css_6', 'animate__swing'), ('react_css_7', 'animate__headShake'), ('enable_badges', '0'), ('enable_videos', '1'), ('custom_menus', '0'), ('room_auto_join', '0'); INSERT INTO `cn_languages` (`code`, `name`, `country`) VALUES ('en', 'English', 'us'); DROP TABLE IF EXISTS `cn_reports`; CREATE TABLE IF NOT EXISTS `cn_reports` ( `id` int NOT NULL AUTO_INCREMENT, `report_type` smallint NOT NULL DEFAULT '1' COMMENT 'chat=1, user=2, room=3, group=4', `report_for` int NOT NULL, `chat_type` int DEFAULT NULL COMMENT 'private=1, group=2', `report_reason` int DEFAULT NULL, `report_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci, `reported_by` int DEFAULT NULL, `reported_at` datetime DEFAULT NULL, `status` smallint NOT NULL COMMENT 'reported=1, read=2', `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; DROP TABLE IF EXISTS `cn_report_reasons`; CREATE TABLE IF NOT EXISTS `cn_report_reasons` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `description` text COLLATE utf8mb4_general_ci, `reason_for` smallint NOT NULL DEFAULT '0' COMMENT 'all=0, chat=1, user=2, room=3, group=4', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO `cn_report_reasons` (`id`, `title`, `description`, `reason_for`) VALUES (1, 'report_reason_1', 'report_reason_1_description', 0), (2, 'report_reason_2', 'report_reason_2_description', 0), (3, 'report_reason_3', 'report_reason_3_description', 0), (4, 'report_reason_4', 'report_reason_4_description', 0), (5, 'report_reason_5', 'report_reason_5_description', 0), (6, 'report_reason_6', 'report_reason_6_description', 0), (7, 'report_reason_7', 'report_reason_7_description', 0), (8, 'report_reason_8', 'report_reason_8_description', 0), (9, 'report_reason_9', 'report_reason_9_description', 0), (10, 'report_reason_10', 'report_reason_10_description', 0); DROP TABLE IF EXISTS `cn_chat_interactions`; CREATE TABLE IF NOT EXISTS `cn_chat_interactions` ( `id` int NOT NULL AUTO_INCREMENT, `chat_id` int NOT NULL, `user_id` int NOT NULL, `chat_type` smallint NOT NULL DEFAULT '1' COMMENT 'Private Chat = 1, Group Chat = 2 ', `is_read` tinyint(1) NOT NULL DEFAULT '0', `is_notified` tinyint(1) NOT NULL DEFAULT '0', `is_starred` tinyint(1) NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `reaction` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=Null, 1=react_1, 2=react_2, 3=react_3, 4=react_4, 5=react_5, 6=react_6, 7=react_7', `read_at` datetime DEFAULT NULL, `notified_at` datetime DEFAULT NULL, `starred_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, `reacted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `cn_chat_interactio_idx_is_noti_chat_ty_user_id_chat_id` (`is_notified`,`chat_type`,`user_id`,`chat_id`), KEY `cn_chat_interactio_idx_chat_ty_user_id_chat_id` (`chat_type`, `user_id`, `chat_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Table structure for table `cn_notifications` -- CREATE TABLE IF NOT EXISTS `cn_notifications`( `id` INT NOT NULL AUTO_INCREMENT, `type` TINYINT NULL DEFAULT '1' COMMENT '1=general, 2=mention, 3=reminder', `content` VARCHAR(300) NULL DEFAULT NULL, `user_id` INT NULL DEFAULT NULL, `created_at` datetime DEFAULT NULL, `is_read` BOOLEAN NULL DEFAULT FALSE, `read_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY(`id`), KEY `cn_notifications_idx_user_id_is_read` (`user_id`,`is_read`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; DROP TABLE IF EXISTS `cn_pages`; CREATE TABLE IF NOT EXISTS `cn_pages` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `show_banner` tinyint(1) NOT NULL DEFAULT '1', `members_only` tinyint(1) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB ; DROP TABLE IF EXISTS `cn_menus`; CREATE TABLE IF NOT EXISTS `cn_menus` ( `id` INT NOT NULL AUTO_INCREMENT, `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permalink` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target` varchar(50) DEFAULT NULL, `icon_class` varchar(50) DEFAULT NULL, `css_class` varchar(50) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `menu_order` int DEFAULT NULL, `members_only` tinyint(1) NOT NULL DEFAULT '0', `status` smallint NOT NULL, `parent_menu_id` bigint DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB; DROP TABLE IF EXISTS `cn_badges`; CREATE TABLE `cn_badges` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(50) NULL , `icon` VARCHAR(200) NULL , `status` BOOLEAN NOT NULL DEFAULT TRUE , `is_editable` BOOLEAN NOT NULL DEFAULT TRUE , PRIMARY KEY (`id`) ) ENGINE = InnoDB; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;