| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/crane_image/current database/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 09, 2023 at 05:45 PM -- Server version: 10.4.25-MariaDB -- PHP Version: 8.1.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `cbimage_db` -- -- -------------------------------------------------------- -- -- Table structure for table `categorytb` -- CREATE TABLE `categorytb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `categorytb` -- INSERT INTO `categorytb` (`id`, `my_id`, `category`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '1', 'Select Category', '', '', '2021-06-30', '15:26:03'), (2, '1', 'Food', '', '', '2021-06-27', '16:00:26'), (4, '1', 'Drinks', '', '', '2021-06-28', '12:08:58'), (5, '1', 'Water', '', '', '2021-06-28', '12:10:26'), (6, '1', 'Entertainments', '', '', '2023-01-06', '17:49:28'), (7, '1', 'Sports', '', '', '2023-01-06', '17:51:42'), (8, '1', 'Health Food', '', '', '2023-01-06', '17:54:04'), (9, '1', 'Health Fitness', '', '', '2023-01-06', '17:58:06'), (10, '1', 'Fruits', '', '', '2023-01-06', '18:01:46'), (11, '1', 'Vegetables', '', '', '2023-01-06', '18:02:34'), (12, '1', 'Toys', '', '', '2023-01-06', '18:03:39'), (13, '1', 'Sounds', '', '', '2023-01-06', '18:05:17'), (14, '1', 'Shapes', '', '', '2023-01-06', '18:06:03'), (15, '1', 'Clothing', '', '', '2023-01-06', '18:07:57'), (16, '1', 'Colors', '', '', '2023-01-06', '18:08:47'), (17, '1', 'Transportation', '', '', '2023-01-06', '18:09:24'), (18, '1', 'Weather', '', '', '2023-01-06', '18:10:01'), (19, '1', 'Emotions', '', '', '2023-01-06', '18:22:31'); -- -------------------------------------------------------- -- -- Table structure for table `commenttb` -- CREATE TABLE `commenttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `post_id` varchar(255) NOT NULL, `comment_text` text NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `crane_imgtb` -- CREATE TABLE `crane_imgtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `studio_id` varchar(255) NOT NULL, `post_text` text NOT NULL, `image_url` varchar(255) NOT NULL, `category` text NOT NULL, `post_name` text NOT NULL, `tmp_css` varchar(255) NOT NULL, `font_css` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `crane_imgtb` -- INSERT INTO `crane_imgtb` (`id`, `my_id`, `studio_id`, `post_text`, `image_url`, `category`, `post_name`, `tmp_css`, `font_css`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '', '1', '', '231597301.jpg', 'Food', '', '', '', '', '', '2021-06-30', '21:36:29'), (2, '', '2', '', '1449335932.jpg', 'Drinks', 'Wonman on chiar', '', '', '', '', '2021-06-30', '21:38:38'), (30, '', '1', '', '911785578.jpg', 'Food', 'Wonman on chiar', '', '', '', '', '2021-06-30', '22:46:06'), (31, '', '2', '', '1065894941.jfif', 'Food', 'Wonman on chiar', '', '', '', '', '2021-06-30', '22:48:44'), (32, '', '1', '', '279370025.jfif', 'Food', 'Wonman on chiar', '', '', '', '', '2021-06-30', '23:00:27'), (33, '', '2', '', '1382395553.jfif', 'Drinks', 'Wonman on chiar', '', '', '', '', '2021-06-30', '23:01:57'), (34, '', '1', '', '1141678431.jpg', 'Food', 'Wonman on chiar', '', '', '', '', '2021-07-02', '00:14:47'), (35, '', '2', '', '668403706.jpg', 'Food', 'Wonman on chiar', '', '', '', '', '2021-07-02', '00:16:10'), (36, '', '1', '', '578396044.jpg', 'Food', 'Wonman on chiar', '', '', '', '', '2021-07-02', '00:18:16'), (37, '', '1', '', '600037703.jfif', 'Food', 'Wonman on chiar', '', '', '', '', '2021-08-20', '16:55:00'), (38, '', '1', '', '536876623.jpeg', 'Drinks', 'Wonman on chiar', '', '', '', '', '2021-08-20', '16:55:15'), (39, '', '1', '', '2066474972.jfif', 'Water', 'Wonman on chiar', '', '', '', '', '2021-08-20', '17:12:02'), (40, '', '2', '', '1265565670.png', 'Food', 'Man on chiar', '', '', '', '', '2021-08-20', '17:12:17'), (41, '1', '1', '', '541204272.mp4', 'the one number', 'best video', '', '', '', '', '2022-12-16', '21:07:20'), (42, '1', '1', ' How your activity is deleted\r\nWhen you choose to delete activity manually or activity is deleted automatically based on your auto-delete setting, we immediately start the process of removing it from the product and our systems.\r\n\r\nFirst, we aim to immediately remove it from view and the data may no longer be used to personalize your Google experience.\r\n\r\nWe then begin a process designed to safely and completely delete the data from our storage systems. \r\n\r\nAlong with helping you delete data manually or automatically, Google may delete some types of activity sooner when it’s no longer useful to improve your experience. \r\n\r\nFor limited purposes, like business or legal requirements, Google may retain certain types of data for an extended period of time ', '', 'Text', 'enc_word', '', '', '', '', '2022-12-17', '19:27:19'), (43, '2', '1', 'water', '', '', '', 'tmp1', 'tfont1', '', '', '2022-12-23', '17:16:46'), (44, '2', '1', 'food', '', '', '', 'tmp1', 'tfont2', '', '', '2022-12-23', '17:18:33'), (45, '2', '1', 'Trying 2', '', '', '', 'tmp2', 'tfont4', '', '', '2022-12-23', '17:26:47'), (46, '2', '1', 'This is from the mobile device ', '', '', '', 'tmp2', 'tfont3', '', '', '2022-12-23', '17:43:05'), (47, '2', '1', 'so Manchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag TrendingManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag TrendingManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag Trending', '', '', '', 'tmp1', 'tfont3', '', '', '2022-12-24', '22:39:53'), (48, '2', '1', 'so Manchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag TrendingManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag TrendingManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManager: Erik ten Hag Trending', '', '', '', 'tmp2', 'tfont2', '', '', '2022-12-24', '22:48:43'), (49, '2', '1', 'Manchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. WikipediaManchester United Football Club, commonly referred to as Man United, or simply United, is a professional football club based in Old Trafford, Greater Manchester, England. The club competes in the Premier League, the top division in the English football league system. Wikipedia', '', '', '', 'tmp1', 'tfont4', '', '', '2022-12-25', '00:07:05'), (50, '2', '1', 'This is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the naleThis is the cased of the name of the nale', '', '', '', 'tmp1', 'tfont3', '', '', '2022-12-25', '21:09:27'), (51, '2', '1', 'Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;vComic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;Comic Sans MS, cursive;', '', '', '', 'tmp2', 'tfont4', '', '', '2022-12-25', '21:50:01'), (52, '2', '1', 'dsdfsf22', '', '', '', 'tmp1', 'tfont2', '', '', '2022-12-27', '20:50:18'); -- -------------------------------------------------------- -- -- Table structure for table `describe_actiontb` -- CREATE TABLE `describe_actiontb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `describe_action` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `describe_actiontb` -- INSERT INTO `describe_actiontb` (`id`, `my_id`, `describe_action`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '1', 'Wonman on chiar', '', '', '2021-06-27', '16:16:12'), (2, '1', 'Wonman on chiar', '', '', '2021-06-28', '12:40:08'); -- -------------------------------------------------------- -- -- Table structure for table `img_down_counttb` -- CREATE TABLE `img_down_counttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `my_ip` varchar(255) NOT NULL, `img_id` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `img_viewtb` -- CREATE TABLE `img_viewtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `my_ip` varchar(255) NOT NULL, `studio_id` varchar(255) NOT NULL, `img_id` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `img_viewtb` -- INSERT INTO `img_viewtb` (`id`, `my_id`, `my_ip`, `studio_id`, `img_id`, `cur_country`, `cur_city`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, 'guest', '127.0.0.1', '1', '1', '', '', '14', '12', '2022', '22:04:45'), (2, 'guest', '127.0.0.1', '1', '30', '', '', '14', '12', '2022', '22:04:58'), (3, 'guest', '127.0.0.1', '1', '32', '', '', '14', '12', '2022', '22:05:11'), (4, 'guest', '127.0.0.1', '1', '34', '', '', '14', '12', '2022', '22:05:18'), (5, 'guest', '127.0.0.1', '1', '37', '', '', '14', '12', '2022', '22:05:53'), (6, 'guest', '127.0.0.1', '2', '35', '', '', '14', '12', '2022', '22:07:23'), (7, 'guest', '127.0.0.1', '1', '36', '', '', '16', '12', '2022', '14:50:55'), (8, 'guest', '127.0.0.1', '1', '38', '', '', '16', '12', '2022', '15:13:18'), (9, '2', '127.0.0.1', '2', '2', '', '', '16', '12', '2022', '15:15:50'), (10, '2', '127.0.0.1', '1', '39', '', '', '16', '12', '2022', '15:16:24'), (11, 'guest', '127.0.0.1', '2', '33', '', '', '16', '12', '2022', '15:53:04'), (12, 'guest', '127.0.0.1', '2', '31', '', '', '16', '12', '2022', '16:05:12'), (13, '2', '127.0.0.1', '1', '41', '', '', '16', '12', '2022', '21:21:42'), (14, 'guest', '::1', '1', '32', '', '', '16', '12', '2022', '21:55:08'), (15, 'guest', '::1', '1', '41', '', '', '16', '12', '2022', '21:55:18'), (16, 'guest', '127.0.0.1', '2', '40', '', '', '17', '12', '2022', '15:01:59'), (17, 'guest', '192.168.1.38', '1', '30', '', '', '23', '12', '2022', '17:39:31'), (18, 'guest', '192.168.1.38', '1', '41', '', '', '23', '12', '2022', '17:40:32'), (19, 'guest', '192.168.1.38', '1', '43', '', '', '23', '12', '2022', '17:40:58'), (20, 'guest', '192.168.1.38', '1', '37', '', '', '23', '12', '2022', '17:41:09'), (21, 'guest', '192.168.1.38', '1', '1', '', '', '23', '12', '2022', '17:41:23'), (22, '2', '127.0.0.1', '1', '57', '', '', '01', '01', '2023', '17:09:03'), (23, '2', '127.0.0.1', '1', '58', '', '', '01', '01', '2023', '17:09:08'), (24, '2', '127.0.0.1', '1', '56', '', '', '01', '01', '2023', '17:09:10'), (25, '2', '127.0.0.1', '1', '53', '', '', '01', '01', '2023', '17:09:14'), (26, '2', '127.0.0.1', '1', '55', '', '', '01', '01', '2023', '17:09:25'), (27, '2', '127.0.0.1', '1', '68', '', '', '01', '01', '2023', '19:06:04'), (28, '2', '127.0.0.1', '1', '47', '', '', '01', '01', '2023', '19:44:56'), (29, '2', '127.0.0.1', '1', '43', '', '', '01', '01', '2023', '19:54:42'), (30, 'guest', '192.168.1.44', '1', '37', '', '', '02', '01', '2023', '19:41:37'), (31, 'guest', '192.168.1.44', '1', '36', '', '', '02', '01', '2023', '19:41:42'), (32, 'guest', '192.168.1.44', '2', '33', '', '', '02', '01', '2023', '19:42:26'), (33, 'guest', '192.168.1.44', '2', '35', '', '', '02', '01', '2023', '19:42:31'), (34, 'guest', '127.0.0.1', '1', '50', '', '', '02', '01', '2023', '20:14:17'), (35, 'guest', '127.0.0.1', '1', '49', '', '', '02', '01', '2023', '20:14:22'), (36, 'guest', '127.0.0.1', '1', '54', '', '', '02', '01', '2023', '20:14:30'), (37, 'guest', '192.168.1.36', '1', '1', '', '', '02', '01', '2023', '21:52:42'), (38, 'guest', '192.168.1.36', '1', '32', '', '', '02', '01', '2023', '21:52:54'), (39, 'guest', '192.168.1.36', '1', '30', '', '', '02', '01', '2023', '21:53:00'), (40, 'guest', '127.0.0.1', '1', '73', '', '', '02', '01', '2023', '22:55:09'), (41, 'guest', '127.0.0.1', '1', '44', '', '', '02', '01', '2023', '22:57:51'), (42, 'guest', '127.0.0.1', '1', '74', '', '', '03', '01', '2023', '20:29:45'), (43, 'guest', '127.0.0.1', '1', '59', '', '', '03', '01', '2023', '22:07:21'), (44, 'guest', '192.168.1.41', '1', '44', '', '', '04', '01', '2023', '20:19:45'), (45, 'guest', '192.168.1.41', '1', '50', '', '', '04', '01', '2023', '20:20:09'), (46, 'guest', '192.168.1.41', '1', '73', '', '', '04', '01', '2023', '20:20:31'), (47, 'guest', '192.168.1.41', '1', '74', '', '', '04', '01', '2023', '20:20:44'), (48, 'guest', '192.168.1.41', '1', '71', '', '', '04', '01', '2023', '20:20:51'), (49, 'guest', '192.168.1.41', '1', '47', '', '', '04', '01', '2023', '20:21:09'), (50, 'guest', '192.168.1.41', '1', '34', '', '', '04', '01', '2023', '20:21:13'); -- -------------------------------------------------------- -- -- Table structure for table `studio_usertb` -- CREATE TABLE `studio_usertb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `channel_name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `image_url` text NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `studio_usertb` -- INSERT INTO `studio_usertb` (`id`, `my_id`, `channel_name`, `description`, `image_url`, `cur_country`, `cur_city`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '2', 'Better cave', 'Better Place For rivers', 'avatar2.jpg', 'Uganda', 'Kampala', '7', '11', '2021', '00:00:00'), (2, '1', 'My Healing', 'The best healing solution for both women and children', 'avatar2.jpg', '', '', '', '', '', '00:00:00'); -- -- Indexes for dumped tables -- -- -- Indexes for table `categorytb` -- ALTER TABLE `categorytb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commenttb` -- ALTER TABLE `commenttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `crane_imgtb` -- ALTER TABLE `crane_imgtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `describe_actiontb` -- ALTER TABLE `describe_actiontb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `img_down_counttb` -- ALTER TABLE `img_down_counttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `img_viewtb` -- ALTER TABLE `img_viewtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `studio_usertb` -- ALTER TABLE `studio_usertb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categorytb` -- ALTER TABLE `categorytb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `commenttb` -- ALTER TABLE `commenttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `crane_imgtb` -- ALTER TABLE `crane_imgtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75; -- -- AUTO_INCREMENT for table `describe_actiontb` -- ALTER TABLE `describe_actiontb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `img_down_counttb` -- ALTER TABLE `img_down_counttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `img_viewtb` -- ALTER TABLE `img_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64; -- -- AUTO_INCREMENT for table `studio_usertb` -- ALTER TABLE `studio_usertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; 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 */;