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

START TRANSACTION;



--
-- Database: `id20251030_rgc`
--
CREATE DATABASE IF NOT EXISTS `id20251030_rgc` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `id20251030_rgc`;

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `message` varchar(300) NOT NULL,
  `time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`id`, `sender_id`, `receiver_id`, `message`, `time`) VALUES
(1, 1, 2, 'Hello', '2024-01-31 18:14:30'),
(2, 2, 1, 'hi', '2024-01-31 18:15:00'),
(3, 3, 1, 'good', '2024-01-31 12:03:54'),
(4, 2, 3, 'how are you?', '2024-01-31 12:03:54'),
(5, 1, 2, 'How are You?', '2024-01-31 18:16:30'),
(6, 10, 2, 'Fine.And You?', '2024-01-31 18:16:00'),
(7, 1, 2, '111111111111', '2024-01-31 13:33:32'),
(8, 1, 2, '111111111111', '2024-01-31 13:37:06'),
(9, 1, 2, '111111111111', '2024-01-31 13:37:23'),
(10, 1, 2, 'a', '2024-01-31 13:44:41'),
(11, 1, 2, 'a', '2024-01-31 19:45:30'),
(12, 1, 2, '7777777', '2024-01-31 20:17:20'),
(13, 1, 2, '......', '2024-01-31 20:23:15'),
(14, 1, 2, '......', '2024-01-31 20:23:15'),
(15, 1, 2, 'tttttttt', '2024-02-01 00:30:39'),
(16, 1, 2, 'ooooooo', '2024-02-01 00:50:08'),
(17, 1, 2, 'হাই', '2024-02-01 01:02:43'),
(18, 1, 2, 'হেলো', '2024-02-01 01:03:16'),
(19, 1, 2, 'ফা', '2024-02-01 01:04:10'),
(20, 1, 2, 'কাকা', '2024-02-01 01:05:15'),
(21, 1, 2, 'চা', '2024-02-01 01:06:00'),
(22, 1, 2, 'চাচা', '2024-02-01 01:06:38'),
(23, 1, 2, 'মা', '2024-02-01 01:07:47'),
(24, 1, 2, 'শালা', '2024-02-01 01:12:10'),
(25, 1, 2, 'বা', '2024-02-01 01:16:05'),
(26, 1, 2, 'আম', '2024-02-01 01:21:53'),
(27, 1, 2, 'ত', '2024-02-01 01:49:42'),
(28, 1, 2, '', '2024-02-01 02:01:29'),
(29, 1, 2, 'hello', '2024-02-01 02:33:06'),
(30, 1, 2, 'my new job is going to be', '2024-02-02 11:10:54'),
(31, 1, 2, 'my new job is going to be', '2024-02-02 11:11:00'),
(32, 1, 2, 'hiiiiii', '2024-02-03 15:20:25'),
(33, 95, 2, 'hi', '2024-02-04 12:02:19'),
(34, 3, 2, 'fine', '2024-02-04 12:33:09'),
(35, 3, 2, 'hi', '2024-02-04 12:40:00'),
(36, 9, 2, 'hi', '2024-02-04 12:42:12'),
(37, 10, 2, 'hi', '2024-02-04 12:52:19'),
(38, 10, 2, '66666', '2024-02-04 12:54:49'),
(39, 10, 2, 'good afternoon', '2024-02-04 13:16:29'),
(40, 1, 2, 'hi', '2024-02-04 21:45:10'),
(41, 1, 2, 'hi', '2024-02-04 21:45:14'),
(42, 1, 6, 'hello', '2024-02-05 12:33:21'),
(43, 1, 2, 'hello', '2024-02-05 12:33:22'),
(44, 1, 2, 'hello', '2024-02-05 12:33:23'),
(45, 1, 5, '3333333333333333', '2024-02-05 12:33:23');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `id` int(11) NOT NULL,
  `post_user_id` int(11) NOT NULL,
  `post` varchar(255) NOT NULL,
  `time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`id`, `post_user_id`, `post`, `time`) VALUES
(1, 1, '111111111111111111111111', '2024-02-04 13:21:18'),
(2, 9, '5555555555555555', '2024-02-04 13:21:32'),
(3, 1, '111111111111111111111111', '2024-02-05 02:14:24'),
(4, 9, '111111111111111111111111', '2024-02-05 02:14:34'),
(5, 1, '111111111111111111111111', '2024-02-05 02:30:49'),
(6, 1, 'jhgj', '2024-02-04 20:33:35'),
(7, 1, 'hhhhhh', '2024-02-05 02:38:06'),
(8, 1, 'Assalamualaikum Everyone . this my First  Post', '2024-02-05 02:38:49'),
(9, 1, 'ইয়াহু! আমি এখন পোস্ট করতে পারতেছি। দেখুন মিডনাইট একটা পোস্ট করতেছি।', '2024-02-05 02:40:33'),
(10, 1, 'আমার সোনার /nবাংলা আমি তোমায়/n ভালোবাসি', '2024-02-05 02:41:18'),
(11, 9, 'nice', '2024-02-05 02:55:06'),
(12, 9, 'Good Night', '2024-02-05 02:55:47'),
(13, 9, '1 /n\\\\n 2', '2024-02-05 02:57:08'),
(14, 9, 'লাইক কমেন্ট নাই অনলি পোস্ট', '2024-02-05 09:39:29'),
(15, 11, 'Yes', '2024-02-05 12:31:12'),
(16, 11, 'hd hgf. jgv ghvcv', '2024-02-05 12:31:43');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

