-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `kitistop_app`
--

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `text_comment` varchar(255) NOT NULL,
  `comment_user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `comment_image` varchar(255) NOT NULL DEFAULT 'null',
  `publish_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `text_comment`, `comment_user_id`, `post_id`, `comment_image`, `publish_date`) VALUES
(138, 'kmn', 2, 151, 'null', '1759223121944'),
(143, 'juhu', 6, 152, 'comment/1001884541.jpg', '1759420046939'),
(144, 'hh', 6, 152, 'null', '1759420068251'),
(145, 'hh', 6, 152, 'comment/1001876118.png', '1759420137330'),
(147, 'done ðŸ‘', 6, 168, 'null', '1759466833120'),
(148, 'good', 6, 151, 'null', '1759473701721'),
(151, 'daron system', 6, 152, 'null', '1759508148954'),
(153, 'good luck', 21, 173, 'null', '1759543407233'),
(155, 'good picture', 6, 176, 'null', '1759561242014'),
(156, 'hii', 6, 169, 'null', '1759921226248'),
(157, '.', 22, 156, 'comment/1000567230.jpg', '1760001689379'),
(158, '@saiguk', 6, 151, 'null', '1760412486823'),
(159, 'oii', 6, 167, 'null', '1760529302917'),
(160, 'oi', 6, 178, 'null', '1760529341399');

-- --------------------------------------------------------

--
-- Table structure for table `comments_replies`
--

CREATE TABLE `comments_replies` (
  `id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `reply_comment` varchar(255) NOT NULL,
  `coment_reply_user_id` int(11) NOT NULL,
  `comment_image` varchar(255) NOT NULL DEFAULT 'null',
  `publish_date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `comments_replies`
--

INSERT INTO `comments_replies` (`id`, `comment_id`, `reply_comment`, `coment_reply_user_id`, `comment_image`, `publish_date`) VALUES
(12, 138, '@Saiful297  photos', 2, 'comment/1001064348.jpg', '1759415812330'),
(13, 138, 'ok', 2, 'null', '1759473716852'),
(14, 147, '@sayem341 আচà§ছা ঠিক আছে', 6, 'null', '1759509683371'),
(15, 155, '@sayem341 tnx brother ðŸ’', 22, 'null', '1759666288988'),
(16, 157, '@wafi sondor hoise', 6, 'null', '1760207595173');

-- --------------------------------------------------------

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `url_user_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `link`
--

INSERT INTO `link` (`id`, `title`, `url`, `url_user_id`) VALUES
(16, 'YouTube', 'https://console.firebase.google.com/u/0/project/fir-970d0/settings/cloudmessaging/android:com.Sparty.Pxel', 2);

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `image_url` varchar(2000) NOT NULL DEFAULT 'null',
  `video_url` varchar(255) NOT NULL DEFAULT 'null',
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_read` tinyint(1) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `sender_id`, `receiver_id`, `content`, `image_url`, `video_url`, `timestamp`, `is_read`) VALUES
(63, 24, 25, 'null', '[\"http://kitis.top/posts/IMG_20250821_160207.jpg\",\"http://kitis.top/posts/Screenshot_2025-07-25-17-26-26-92_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\",\"http://kitis.top/posts/IMG20250723072830.jpg\",\"http://kitis.top/posts/Screenshot_2025-05-02-21-54-14-56_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\",\"http://kitis.top/post/IMG_20250518_154714.jpg\",\"http://kitis.top/post/Screenshot_2025-05-02-11-59-25-88_f598e1360c96b5a5aa16536c303cff92.jpg\",\"http://kitis.top/post/Screenshot_2025-04-28-17-39-03-14_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\"]', 'null', '2025-10-17 06:04:35', 0),
(62, 24, 25, 'androidx.core.widget.NestedScrollView', '[\"http://kitis.top/posts/IMG20251014112849.jpg\",\"http://kitis.top/posts/IMG20251015203845.jpg\",\"http://kitis.top/posts/IMG20251014113256.jpg\"]', 'null', '2025-10-17 05:50:14', 0),
(64, 24, 25, 'testing for img 2 inthe mor', '[\"http://kitis.top/posts/IMG20220810082847.jpg\",\"http://kitis.top/posts/IMG20220806120137.jpg\",\"http://kitis.top/posts/IMG20220802080512.jpg\",\"http://kitis.top/posts/IMG20220713191512.jpg\",\"http://kitis.top/posts/IMG20220713151832.jpg\",\"http://kitis.top/posts/IMG20220713143806.jpg\",\"http://kitis.top/post/IMG20220709175053.jpg\",\"http://kitis.top/post/IMG_20220824_170314.png\",\"http://kitis.top/post/20220302_151821.jpg\"]', 'null', '2025-10-17 06:19:31', 0),
(65, 24, 25, 'Name	Type Documentation	Length/Values 	Default 	Collation	Attributes	Null	Adjust privileges Documentation	A_I	Comments	Virtuality	Move column\nimage_u', 'null', 'null', '2025-10-17 07:21:21', 0),
(66, 24, 25, 'Name	Type Documentation	Length/Values 	Default 	Collation	Attributes	Null	Adjust privileges Documentation	A_I	Comments	Virtuality	Move column\nimage_url\n\nVARCHAR\n2000\n\nAs defined:\n \nnull\n\nutf8mb3_general_ci\n\n			\n\n\n \nOnline ', 'null', 'null', '2025-10-17 07:21:33', 0),
(67, 24, 25, 'ok boste parsi ki k9rte hobo ok', 'null', 'null', '2025-10-17 07:21:49', 0),
(68, 24, 25, 'null89iiiijji', '[\"http://kitis.top/posts/Screenshot_2025-10-14-10-29-13-66_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\"]', 'null', '2025-10-17 06:22:29', 0),
(69, 24, 25, 'hii', 'null', 'null', '2025-10-17 07:45:45', 0),
(70, 24, 25, 'just done', 'null', 'null', '2025-10-17 09:20:26', 0),
(71, 24, 25, 'যরররর', '[\"http://kitis.top/posts/IMG20251014113256.jpg\",\"http://kitis.top/posts/Screenshot_2025-10-14-10-29-13-66_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\",\"http://kitis.top/posts/IMG20251014112849.jpg\",\"http://kitis.top/posts/IMG_20250906_123149_244.jpg\",\"http://kitis.top/posts/IMG_20250906_123152_272.jpg\"]', 'null', '2025-10-17 09:34:00', 0),
(72, 24, 25, 'null', '[\"http://kitis.top/posts/Screenshot_2025-10-10-23-48-48-24_40deb401b9ffe8e1df2f1cc5ba480b12.jpg\",\"http://kitis.top/posts/Screenshot_2025-10-10-12-53-52-56_f598e1360c96b5a5aa16536c303cff92.jpg\"]', 'null', '2025-10-17 09:39:26', 0),
(73, 24, 31, 'jj', 'null', 'null', '2025-10-17 10:57:03', 0),
(74, 24, 2, 'oii', 'null', 'null', '2025-10-17 11:04:04', 0),
(75, 24, 2, 'null', '[\"http://kitis.top/posts/IMG20220810082847.jpg\",\"http://kitis.top/posts/IMG20220806120137.jpg\",\"http://kitis.top/posts/IMG20220802080512.jpg\",\"http://kitis.top/posts/IMG20220713191512.jpg\",\"http://kitis.top/posts/IMG20220713151832.jpg\",\"http://kitis.top/posts/IMG20220713143806.jpg\",\"http://kitis.top/post/IMG20220709175053.jpg\",\"http://kitis.top/post/IMG_20220824_170314.png\",\"http://kitis.top/post/20220302_151821.jpg\"]', 'null', '2025-10-17 11:05:02', 0),
(76, 24, 25, 'hhhhh', '[\"http://kitis.top/posts/IMG20251004152005.jpg\"]', 'null', '2025-10-17 14:11:32', 0),
(77, 24, 0, 'hii', 'null', 'null', '2025-10-17 16:08:15', 0),
(78, 24, 0, 'hii', 'null', 'null', '2025-10-17 16:16:18', 0),
(79, 24, 0, 'oii', 'null', 'null', '2025-10-17 16:17:04', 0),
(80, 24, 0, 'oii', 'null', 'null', '2025-10-17 16:18:01', 0),
(81, 24, 0, 'hh', 'null', 'null', '2025-10-17 16:18:05', 0),
(82, 24, 24, 'naw', 'null', 'null', '2025-10-17 16:20:17', 0),
(83, 24, 24, 'ki koros toi', 'null', 'null', '2025-10-17 16:20:27', 0),
(84, 24, 27, 'deleted message', 'null', 'null', '2025-10-18 01:48:09', 0),
(85, 24, 27, 'ki obista', 'null', 'null', '2025-10-17 16:20:52', 0),
(86, 24, 27, 'akon forward korlam', '[\"http://kitis.top/posts/IMG_20250821_160207.jpg\",\"http://kitis.top/posts/Screenshot_2025-07-25-17-26-26-92_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\",\"http://kitis.top/posts/IMG20250723072830.jpg\",\"http://kitis.top/posts/Screenshot_2025-05-02-21-54-14-56_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\",\"http://kitis.top/post/IMG_20250518_154714.jpg\",\"http://kitis.top/post/Screenshot_2025-05-02-11-59-25-88_f598e1360c96b5a5aa16536c303cff92.jpg\",\"http://kitis.top/post/Screenshot_2025-04-28-17-39-03-14_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\"]', 'null', '2025-10-17 16:21:42', 0),
(87, 24, 23, 'hhii dev how are you?', 'null', 'null', '2025-10-17 16:24:36', 0),
(88, 24, 23, 'kmn aso toi bondo', 'null', 'null', '2025-10-17 16:24:50', 0),
(89, 24, 27, 'ok bosji', 'null', 'null', '2025-10-17 16:36:25', 0),
(90, 24, 25, 'oii', 'null', 'null', '2025-10-17 16:39:56', 0),
(91, 24, 25, 'yyy', 'null', 'null', '2025-10-17 16:42:47', 0),
(92, 24, 25, 'u', 'null', 'null', '2025-10-17 16:42:52', 0),
(93, 24, 25, 'uu', 'null', 'null', '2025-10-17 16:42:54', 0),
(94, 24, 25, 'uu', 'null', 'null', '2025-10-17 16:45:34', 0),
(95, 24, 25, '9', 'null', 'null', '2025-10-17 16:49:13', 0),
(96, 2, 24, 'hii', 'null', 'null', '2025-10-18 02:08:20', 0),
(97, 6, 2, 'deleted message', 'null', 'null', '2025-10-21 16:40:09', 0),
(98, 6, 2, 'deleted message', 'null', 'null', '2025-10-21 16:25:35', 0),
(99, 6, 2, 'null', 'null', 'null', '2025-10-18 07:17:23', 0),
(100, 6, 2, 'onk ager picture ', '[\"http://kitis.top/posts/IMG_20251018_084824.jpg\"]', 'null', '2025-10-18 07:18:08', 0),
(101, 6, 2, 'hii kmn aso tomra', 'null', 'null', '2025-10-19 04:26:40', 0),
(102, 6, 2, 'ok bote partedi', 'null', 'null', '2025-10-19 04:27:02', 0),
(103, 6, 2, 'à¦খানে কিছà§ ইà¦দà§র গরà§ত খà§à¦ড়ে গম চà§রি করে । à¦র তা পà§লিশ কে জানানো হয়। à¦রপর পà§লিশ তার দলবল নিয়ে আসে ইà¦দà§র ধরতে। à¦রপর ইà¦দà§র à¦বং পà§লিশের মধà§যে তà§মà§ল গà§লাগà§লি শà§রà§ হয়। à¦রপর বোমা টোমা মেরে পà§লিশ ইà¦দà§র কে হারিয়ে দেয়। à¦বং ইà¦দà§র দল পালিয়ে যায়।', 'null', 'null', '2025-10-21 15:36:22', 0),
(104, 6, 2, 'অবশà§যই 😊 নিচে তোমার গলà§পটা à¦কটà§ সà§নà§দরভাবে, সাজানোভাবে লিখে দিলাম —\n\n---\n\n### **ইà¦দà§র আর পà§লিশের লড়াই**\n\nà¦কটি গà§রামে কিছà§ চতà§র ইà¦দà§র বসবাস করত। তারা রাতে গোপনে গমের গোদাম ঘà§রে বেড়াত আর মাটির নিচে গরà§ত খà§à¦ড়ে চà§পিচà§পি গম চà§রি করে নিয়ে যেত। গà§রামের মানà§ষ à¦তে খà§ব বিপদে পড়ল—গমের বসà§তা দিনে দিনে হালকা হয়ে যাচà§ছে, অথচ চোরের কোনো খোà¦জ নেই!\n\nশেষ পরà§যনà§ত গà§রামের লোকজন বিষয়টি পà§লিশকে জানায়। খবর পেয়ে পà§লিশ সঙà§গে সঙà§গে তাদের দলবল নিয়ে ঘটনাসà§থলে হাজির হয়। গমচোর ইà¦দà§রদের ধরার জনà§য তারা চারদিক ঘিরে ফেলে।\n\nকিনà§তà§ ইà¦দà§ররাও ছিল চালাক! তারা গরà§তের ভেতর থেকে তà§মà§ল পà§রতিরোধ শà§রà§ করে। যেন যà§দà§ধ লেগে গেল—পà§লিশ আর ইà¦দà§রদের মধà§যে শà§রà§ হলো ভয়ংকর গà§লাগà§লি!\n\nà¦ক পরà§যায়ে পà§লিশ বà§à¦ল, শà§ধà§ গà§লি ছà§à¦ড়ে ইà¦দà§র ধরা যাবে না। তাই তারা বà§দà§ধি খাটিয়ে বোমা ছà§à¦ড়ল গরà§তের দিকে। জোরে à¦কের পর à¦ক বিসà§ফোরণ!\n\nশেষমেশ ইà¦দà§ররা টিকতে না পেরে পালিয়ে যায়। গোটা গà§রাম সà§বসà§তির নিঃশà§বাস ফেলে, আর পà§লিশ জয়ী হয়ে ফিরে যায়।\n\nসেদিন থেকে গà§রামের মানà§ষ তাদের গমের ভানà§ডার পাহারা দেয় আরও ভালোভাবে—যাতে আর কোনো ইà¦দà§র সাহস না করে ফিরে আসে!\n\n---\n\nতà§মি চাইলে আমি à¦টাকে **মজার শিশà§দের গলà§পের মতো** বা **অà§যাকশন কমেডি গলà§পের মতো**ও সাজিয়ে দিতে পারি। কোনভাবে চাও?\n', 'null', 'null', '2025-10-21 15:36:31', 0),
(105, 6, 2, 'deleted message', 'null', 'null', '2025-10-21 16:50:37', 0),
(106, 6, 2, 'deleted message', 'null', 'null', '2025-10-21 16:42:37', 0),
(107, 24, 24, 'hii', 'null', 'null', '2025-10-22 07:51:46', 0),
(108, 36, 24, 'hell', 'null', 'null', '2025-10-26 17:41:41', 0),
(109, 36, 8, 'hello', 'null', 'null', '2025-10-26 17:42:05', 0),
(110, 24, 25, 'ওকে ', 'null', 'null', '2025-10-26 18:17:34', 0),
(111, 36, 24, 'how are You', 'null', 'null', '2025-10-26 18:20:54', 0),
(112, 36, 24, 'Brother', 'null', 'null', '2025-10-26 18:20:59', 0),
(113, 36, 24, 'sjbsvs', 'null', 'null', '2025-10-26 18:33:23', 0),
(114, 24, 36, 'hello', 'null', 'null', '2025-10-26 18:50:43', 0),
(115, 24, 36, 'kmn aso', 'null', 'null', '2025-10-26 18:50:46', 0),
(116, 24, 36, 'how are you bro', 'null', 'null', '2025-10-26 18:50:55', 0),
(117, 24, 36, 'what r you doing now ', 'null', 'null', '2025-10-26 18:51:08', 0),
(118, 24, 0, 'kmn oise', '[\"http://kitis.top/posts/Screenshot_2025-10-18-05-36-26-74_f598e1360c96b5a5aa16536c303cff92.jpg\"]', 'null', '2025-10-26 18:51:30', 0),
(119, 24, 0, 'ttggg', '[\"http://kitis.top/posts/Screenshot_2025-10-18-05-36-26-74_f598e1360c96b5a5aa16536c303cff92.jpg\"]', 'null', '2025-10-26 18:51:57', 0),
(120, 24, 25, 'ki kros', 'null', 'null', '2025-10-27 05:21:13', 0),
(121, 6, 21, 'hii', 'null', 'null', '2025-10-28 04:45:41', 0),
(122, 6, 21, 'how r you ', 'null', 'null', '2025-10-28 04:45:51', 0),
(123, 2, 6, 'hii', 'null', 'null', '2025-10-29 20:36:11', 0),
(124, 24, 24, 'hii', 'null', 'null', '2025-10-29 20:39:37', 0),
(125, 24, 24, 'oiii', 'null', 'null', '2025-10-29 20:39:44', 0),
(126, 2, 24, 'now', 'null', 'null', '2025-10-29 20:41:01', 0),
(127, 2, 24, 'oii ki kortesot toi', 'null', 'null', '2025-10-29 20:42:56', 0),
(128, 2, 6, 'moina ki korteso tumi haa', 'null', 'null', '2025-10-29 20:44:35', 0),
(129, 24, 24, 'yy', 'null', 'null', '2025-10-29 20:54:32', 0),
(130, 24, 24, 'fr', 'null', 'null', '2025-10-29 20:54:44', 0),
(131, 2, 24, 'iuu', 'null', 'null', '2025-10-29 20:55:14', 0),
(132, 41, 6, 'hello', 'null', 'null', '2025-10-30 08:38:18', 0),
(133, 24, 0, 'aii rokom post korle kmn hoi bolo to', '[\"http://kitis.top/posts/Screenshot_2025-10-22-16-06-58-70_f598e1360c96b5a5aa16536c303cff92.jpg\"]', 'null', '2025-11-01 19:08:48', 0),
(134, 6, 41, 'yes', 'null', 'null', '2025-11-01 19:11:43', 0),
(135, 6, 2, 'deko kmn hoise ata', '[\"http://kitis.top/posts/Screenshot_2025-10-22-16-06-58-70_f598e1360c96b5a5aa16536c303cff92.jpg\"]', 'null', '2025-11-01 19:12:59', 0);

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `post_user_id` varchar(100) NOT NULL,
  `post_id` varchar(100) NOT NULL,
  `profile_picture` varchar(255) NOT NULL,
  `publish_date` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `title`, `type`, `post_user_id`, `post_id`, `profile_picture`, `publish_date`) VALUES
(37, '', '', '', '', '', ''),
(38, '', '', '', '', '', ''),
(39, '', '', '', '', '', ''),
(40, '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `comment_disable` enum('true','false') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `publish_with` enum('public','only me') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `load_url` longtext NOT NULL,
  `liked` longtext DEFAULT NULL,
  `publish_date` varchar(255) NOT NULL,
  `post_user_id` int(11) DEFAULT NULL,
  `post_total_share` int(50) DEFAULT 0,
  `share_user_id` int(50) NOT NULL DEFAULT 0,
  `share_post_id` int(50) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `title`, `comment_disable`, `publish_with`, `load_url`, `liked`, `publish_date`, `post_user_id`, `post_total_share`, `share_user_id`, `share_post_id`) VALUES
(151, 'onk koste korlam', 'true', 'public', '[\"http://kitis.top/posts/IMG20250918114220.jpg\",\"http://kitis.top/posts/IMG20250918112508.jpg\",\"http://kitis.top/posts/IMG20250916112907.jpg\"]', '\"bdware\":\"true\",\"01605692210\":\"true\",\"01304127020\":\"true\"', '1759151975497', 2, 0, 0, 0),
(152, 'nice function for college lifes', 'true', 'public', '[\"http://kitis.top/posts/IMG20250702101252.jpg\"]', '\"bdware\":\"true\"', '1759153365177', 2, 1, 0, 0),
(156, 'nice app', 'true', 'public', '[\"http://kitis.top/posts/IMG_20250906_123156_460.jpg\",\"http://kitis.top/posts/IMG_20250906_123152_272.jpg\",\"http://kitis.top/posts/IMG_20250906_123149_244.jpg\"]', '\"bdware\":\"true\",\"01304127020\":\"true\"', '1759327661430', 2, 0, 0, 0),
(167, 'hey friends @Saiful297', 'true', 'public', 'null', '\"bdware\":\"true\",\"01304127020\":\"true\"', '1759413919051', 6, 0, 0, 0),
(168, 'tikbolesen bro7', 'true', 'public', '[\"http://kitis.top/posts/FB_IMG_1641838399980.jpg\"]', '\"bdware\":\"true\",\"01747419946\":\"true\"', '1759422037057', 6, 0, 0, 0),
(169, 'testing share', 'true', 'public', 'null', '\"bdware\":\"true\"', '1759490107791', 6, 0, 2, 152),
(173, 'likes this ðŸ«©', 'true', 'public', '[\"http://kitis.top/posts/Screenshot_2025-10-01-09-20-34-22_50ef9f5a0f3fc24b6f0ffc8843167fe4.jpg\"]', '\"bdware\":\"true\"', '1759500140573', 6, 0, 0, 0),
(175, 'testing', 'true', 'public', '[\"http://kitis.top/posts/20250806_132207.jpg\"]', '\"bdware\":\"true\"', '1759543479825', 21, 0, 0, 0),
(176, '✨', 'true', 'public', '[\"http://kitis.top/posts/IMG_20251003_171249.jpg\",\"http://kitis.top/posts/IMG_20251003_190020.jpg\",\"http://kitis.top/posts/IMG_20251003_170505.jpg\"]', '\"bdware\":\"true\",\"01747419946\":\"true\"', '1759560056069', 22, 0, 0, 0),
(178, 'uquw', 'true', 'public', 'null', '\"bdware\":\"true\"', '1759919932615', 6, 0, 0, 0),
(179, 'Milestone Devastated Campus 💔', 'true', 'public', '[\"http://kitis.top/posts/IMG_20250926_102931.jpg\",\"http://kitis.top/posts/IMG_20250926_102947.jpg\",\"http://kitis.top/posts/IMG_20250926_080400.jpg\",\"http://kitis.top/posts/IMG_20250926_080403.jpg\"]', '\"bdware\":\"true\"', '1760012671026', 22, 1, 0, 0),
(180, 'wow ki khobor dilo YouTube dada', 'true', 'public', '[\"http://kitis.top/posts/Screenshot_2025-10-09-19-45-40-91_f9ee0578fe1cc94de7482bd41accb329.jpg\"]', '\"bdware\":\"true\"', '1760149116477', 6, 0, 0, 0),
(181, 'good morning everyone', 'true', 'public', '[\"http://kitis.top/posts/1760440550359.jpg\",\"http://kitis.top/posts/1760440547039.jpg\"]', '\"bdware\":\"true\",\"03110797156\":\"true\"', '1760440579473', 6, 1, 0, 0),
(182, 'test', 'true', 'public', '[\"http://kitis.top/posts/Untitled40_20250629121610.png\",\"http://kitis.top/posts/Untitled34_20250629153057.png\"]', '\"bdware\":\"true\"', '1760442684995', 6, 0, 0, 0),
(183, 'শেয়ার কযা করা হলো', 'true', 'public', 'null', '\"bdware\":\"true\"', '1760445986586', 6, 0, 6, 181),
(189, 'kmn holo bondora', 'true', 'public', 'null', '\"bdware\":\"true\"', '1760553505883', 6, 0, 22, 179),
(190, 'à¦ই চোখে চোখ রেখে..!â¤ï¸â€🩹😊#viral #new_trending #foryou #capcut #tiktok @TikTok Bangladesh', 'true', 'public', '[\"http://kitis.top/videos/1001933430.mp4\"]', '\"bdware\":\"true\"', '1760706120056', 6, 0, 0, 0),
(191, 'ki cute beby how sweet', 'true', 'public', '[\"http://kitis.top/videos/1000737733.mp4\"]', '\"bdware\":\"true\",\"01304127020\":\"true\"', '1761542125490', 6, 0, 0, 0),
(192, 'null', 'true', 'public', '[\"http://kitis.top/videos/1001948411.mp4\"]', '\"bdware\":\"true\"', '1761555995781', 6, 0, 0, 0);

--
-- Triggers `posts`
--
DELIMITER $$
CREATE TRIGGER `set_default_liked` BEFORE INSERT ON `posts` FOR EACH ROW BEGIN
    IF NEW.liked IS NULL THEN
        SET NEW.liked = '"bdware":"true"';
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `reels`
--

CREATE TABLE `reels` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `video_url` longtext NOT NULL,
  `publish_with` varchar(50) NOT NULL,
  `comment_disable` varchar(50) NOT NULL,
  `reels_user_id` int(11) NOT NULL,
  `total_share` int(11) NOT NULL DEFAULT 0,
  `liked` longtext DEFAULT NULL,
  `publish_date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reels`
--

INSERT INTO `reels` (`id`, `title`, `video_url`, `publish_with`, `comment_disable`, `reels_user_id`, `total_share`, `liked`, `publish_date`) VALUES
(1, 'fast video ', 'http://kitis.top/videos/1001750512.mp4', '', '', 2, 0, '', ''),
(2, 'TikTok video for naw', 'https://kitis.top/videos/1001933430.mp4', '', '', 2, 0, '', ''),
(4, 'hiiuhvv', 'http://kitis.top/videos/1001918184.mp4', '', '', 2, 0, '', ''),
(5, 'gyyyy', 'http://kitis.top/videos/1001909700.mp4', '', '', 2, 0, '', ''),
(6, 'ও ছেমরা রে ছেমরা তà§ঈ অপরাধি রে', 'http://kitis.top/videos/1001753111.mp4', '', '', 2, 0, '', ''),
(7, 'aii problem kivabe aomadan korbo', 'http://kitis.top/videos/1001944547.mp4', '', '', 2, 0, '', ''),
(8, '#মেনশন_করà§ন_আপনার_পà§রিয়_মানà§ষকেâ£ï¸😊 #1millionaudition #natok_lover_support_me#foryoupage #viralchall', 'http://kitis.top/videos/1001944945.mp4', '', '', 2, 0, '', ''),
(9, '#রনি_ডà§যানà§স_à¦কাডেমী #ti ̇ktok #dance #foryou #rony_dance_academy', 'http://kitis.top/videos/1001944978.mp4', '', '', 2, 0, '', ''),
(10, 'Leader ✊ #foryoupage #viral #video #tiktok #unfrezzmyaccoun', 'http://kitis.top/videos/1001944979.mp4', '', '', 2, 0, '', ''),
(11, 'jsnsnzj', 'http://kitis.top/videos/1001944980.mp4', '', '', 2, 0, '', ''),
(12, 'Those dinosaurs popping up suddenly 🦖 | Jurassic World | #edit #movie', 'http://kitis.top/videos/1001945100.mp4', '', '', 2, 0, '', ''),
(13, 'yhujjj', 'http://kitis.top/reels/1001109672.mp4', '', '', 2, 0, NULL, ''),
(14, 'কি অভিমানী মেয়েরে বাবা ☺ï¸', 'http://kitis.top/reels/1001727179.mp4', '', '', 6, 0, NULL, '1761544331836'),
(15, 'null', 'http://kitis.top/reels/1001948323.mp4', '', '', 6, 0, NULL, '1761545274125'),
(16, 'https://vt.tiktok.com/ZSUoKf1T2/https://vt.tiktok.com/ZSUoKf1T2/https://vt.tiktok.com/ZSUoKf1T2/https://vt.tiktok.com/ZSUoKf1T2/https://vt.tiktok.com/ZSUoKf1T2/', 'http://kitis.top/reels/1001948323.mp4', '', '', 6, 0, NULL, '1761547998298'),
(17, 'দেখà§ন কিভাবে নাটকের শà§টিং করি 🥰# #bdtiktokofficial #vairal #trending #explore #foryoupage', 'http://kitis.top/reels/1001948410.mp4', '', '', 6, 0, NULL, '1761550543643'),
(18, 'null', 'http://kitis.top/reels/1001948411.mp4', '', '', 6, 0, NULL, '1761556133296'),
(19, 'Ankhu se bat hoti hai🦋#song #foryou #rabeesakhan11 #viral', 'http://kitis.top/reels/1001948431.mp4', '', '', 6, 0, NULL, '1761595895352'),
(20, 'kmn hoise bondora sobai bolo', 'http://kitis.top/reels/1001950348.mp4', '', '', 6, 0, NULL, '1761832176752'),
(21, 'coco co cola song', 'http://kitis.top/reels/1001952162.mp4', '', '', 6, 0, NULL, '1761934968884'),
(22, '', '', '', '', 0, 0, NULL, ''),
(23, '', '', '', '', 0, 0, NULL, ''),
(24, '', '', '', '', 0, 0, NULL, ''),
(25, '', '', '', '', 0, 0, NULL, ''),
(26, '', '', '', '', 0, 0, NULL, ''),
(27, '', '', '', '', 0, 0, NULL, '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_post_comment` (`post_id`),
  ADD KEY `fk_comments_user` (`comment_user_id`);

--
-- Indexes for table `comments_replies`
--
ALTER TABLE `comments_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_replies_comment` (`comment_id`),
  ADD KEY `fk_comments_replies_user` (`coment_reply_user_id`);

--
-- Indexes for table `link`
--
ALTER TABLE `link`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_link_user` (`url_user_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_posts_user` (`post_user_id`);

--
-- Indexes for table `reels`
--
ALTER TABLE `reels`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;

--
-- AUTO_INCREMENT for table `comments_replies`
--
ALTER TABLE `comments_replies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `link`
--
ALTER TABLE `link`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=193;

--
-- AUTO_INCREMENT for table `reels`
--
ALTER TABLE `reels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `fk_comments_user` FOREIGN KEY (`comment_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_post_comment` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `comments_replies`
--
ALTER TABLE `comments_replies`
  ADD CONSTRAINT `fk_comments_replies_user` FOREIGN KEY (`coment_reply_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_replies_comment` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `link`
--
ALTER TABLE `link`
  ADD CONSTRAINT `fk_link_user` FOREIGN KEY (`url_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `fk_posts_user` FOREIGN KEY (`post_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

