-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 15, 2025 at 04:14 PM -- Server version: 5.7.41-cll-lve -- PHP Version: 7.4.33 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: `h265968_sinaplus` -- -- -------------------------------------------------------- -- -- Table structure for table `block_list` -- CREATE TABLE `block_list` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `block_guid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `channels` -- CREATE TABLE `channels` ( `id` int(11) NOT NULL, `channel_link` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guid` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `channel_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci, `members_count` bigint(20) DEFAULT '0', `channel_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `color` int(11) DEFAULT NULL, `blue_tick` int(11) NOT NULL DEFAULT '0', `developer` int(11) DEFAULT '0', `ban` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `channel_admins` -- CREATE TABLE `channel_admins` ( `id` int(11) NOT NULL, `channel_id` int(11) NOT NULL, `admin_id` int(11) NOT NULL, `role` enum('owner','admin') NOT NULL DEFAULT 'admin', `can_send_messages` tinyint(1) DEFAULT '0', `can_edit_channel_info` tinyint(1) DEFAULT '0', `can_edit_messages` tinyint(1) DEFAULT '0', `can_delete_messages` tinyint(1) DEFAULT '0', `can_view_members` tinyint(1) DEFAULT '0', `can_view_admins` tinyint(1) DEFAULT '0', `can_add_admin` tinyint(1) DEFAULT '0', `assigned_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `assigned_by` bigint(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `channel_members` -- CREATE TABLE `channel_members` ( `id` int(11) NOT NULL, `channel_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `joined_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_admin` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `devices` -- CREATE TABLE `devices` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `platform` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `device` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `devices` -- INSERT INTO `devices` (`id`, `user_id`, `platform`, `auth`, `device`, `date`, `ip`) VALUES (76, 76, 'android', 'fvspryzllbskkkaefrhhxirhkxcssgjq', 'POCOM2102J20SG', '1736862983', '83.123.183.217'); -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` int(11) NOT NULL, `guid` varchar(15) NOT NULL, `group_name` varchar(255) NOT NULL, `description` text, `group_image` text, `color` int(11) DEFAULT '1', `created_at` datetime NOT NULL, `group_link` varchar(255) DEFAULT NULL, `members_count` int(11) NOT NULL, `blue_tick` tinyint(1) NOT NULL, `developer` tinyint(1) NOT NULL, `ban` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `group_admins` -- CREATE TABLE `group_admins` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `admin_id` int(11) NOT NULL, `role` enum('owner','admin') NOT NULL, `can_send_messages` tinyint(1) DEFAULT '1', `can_edit_group_info` tinyint(1) DEFAULT '1', `can_edit_messages` tinyint(1) DEFAULT '1', `can_delete_messages` tinyint(1) DEFAULT '1', `can_view_members` tinyint(1) DEFAULT '1', `can_add_members` tinyint(1) DEFAULT '1', `can_remove_members` tinyint(1) DEFAULT '1', `can_add_admin` tinyint(1) DEFAULT '1', `assigned_at` datetime NOT NULL, `can_view_admins` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `group_members` -- CREATE TABLE `group_members` ( `id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `joined_at` datetime NOT NULL, `is_admin` tinyint(1) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `muted_users` -- CREATE TABLE `muted_users` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `muted_guid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `profiles` -- CREATE TABLE `profiles` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `url` mediumtext COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `now_timestamp` bigint(20) DEFAULT NULL, `expiry_timestamp` bigint(20) DEFAULT NULL, `hash_rec` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` int(11) DEFAULT NULL, `ban` tinyint(1) DEFAULT NULL, `blue_tick` tinyint(1) DEFAULT NULL, `developer` tinyint(1) DEFAULT NULL, `bio` mediumtext COLLATE utf8mb4_unicode_ci, `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_seen` bigint(20) DEFAULT NULL, `username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profile` text COLLATE utf8mb4_unicode_ci, `show_number` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `number`, `ip`, `code`, `now_timestamp`, `expiry_timestamp`, `hash_rec`, `guid`, `color`, `ban`, `blue_tick`, `developer`, `bio`, `name`, `last_seen`, `username`, `profile`, `show_number`) VALUES (76, '09159430417', '83.123.183.217', '91792', 1736862977, 1736863097, '562629632663450032424254332954759720961122', 'ffd3d2b1-ae02-4acd-9586-21d44b763cd2', 3, 0, 0, 0, 'سلام! من از سینا+ استفاده میکنم', 'بدون نام', 1736863035, 'arash', NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `user_reports` -- CREATE TABLE `user_reports` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `report_guid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `report_id` int(11) NOT NULL, `custom_description` mediumtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `vitrin` -- CREATE TABLE `vitrin` ( `id` varchar(32) NOT NULL, `user_id` int(11) NOT NULL, `file_url` text NOT NULL, `caption` text, `likes` int(11) DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Indexes for dumped tables -- -- -- Indexes for table `block_list` -- ALTER TABLE `block_list` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `channels` -- ALTER TABLE `channels` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `guid` (`guid`), ADD UNIQUE KEY `username` (`channel_link`); -- -- Indexes for table `channel_admins` -- ALTER TABLE `channel_admins` ADD PRIMARY KEY (`id`), ADD KEY `channel_id` (`channel_id`), ADD KEY `admin_id` (`admin_id`); -- -- Indexes for table `channel_members` -- ALTER TABLE `channel_members` ADD PRIMARY KEY (`id`), ADD KEY `channel_id` (`channel_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `devices` -- ALTER TABLE `devices` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `guid` (`guid`); -- -- Indexes for table `group_admins` -- ALTER TABLE `group_admins` ADD PRIMARY KEY (`id`), ADD KEY `group_id` (`group_id`), ADD KEY `admin_id` (`admin_id`); -- -- Indexes for table `group_members` -- ALTER TABLE `group_members` ADD PRIMARY KEY (`id`), ADD KEY `group_id` (`group_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `muted_users` -- ALTER TABLE `muted_users` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `profiles` -- ALTER TABLE `profiles` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_reports` -- ALTER TABLE `user_reports` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `vitrin` -- ALTER TABLE `vitrin` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `block_list` -- ALTER TABLE `block_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `channels` -- ALTER TABLE `channels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58; -- -- AUTO_INCREMENT for table `channel_admins` -- ALTER TABLE `channel_admins` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58; -- -- AUTO_INCREMENT for table `channel_members` -- ALTER TABLE `channel_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58; -- -- AUTO_INCREMENT for table `devices` -- ALTER TABLE `devices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `group_admins` -- ALTER TABLE `group_admins` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `group_members` -- ALTER TABLE `group_members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `muted_users` -- ALTER TABLE `muted_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `profiles` -- ALTER TABLE `profiles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77; -- -- AUTO_INCREMENT for table `user_reports` -- ALTER TABLE `user_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- Constraints for dumped tables -- -- -- Constraints for table `block_list` -- ALTER TABLE `block_list` ADD CONSTRAINT `block_list_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `channel_admins` -- ALTER TABLE `channel_admins` ADD CONSTRAINT `channel_admins_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `channel_admins_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `channel_members` -- ALTER TABLE `channel_members` ADD CONSTRAINT `channel_members_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `channels` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `channel_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `devices` -- ALTER TABLE `devices` ADD CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `group_admins` -- ALTER TABLE `group_admins` ADD CONSTRAINT `group_admins_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `group_admins_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `group_members` -- ALTER TABLE `group_members` ADD CONSTRAINT `group_members_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `group_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `muted_users` -- ALTER TABLE `muted_users` ADD CONSTRAINT `muted_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `profiles` -- ALTER TABLE `profiles` ADD CONSTRAINT `profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); -- -- Constraints for table `vitrin` -- ALTER TABLE `vitrin` ADD CONSTRAINT `vitrin_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`); 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 */;