| 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:/Desktop/setup/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.8.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 23, 2019 at 11:40 AM -- Server version: 10.1.37-MariaDB -- PHP Version: 7.3.1 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: `khalaf_sonsdb` -- -- -------------------------------------------------------- -- -- Table structure for table `adverttb` -- CREATE TABLE `adverttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `road_no` varchar(255) NOT NULL, `bedroom_no` varchar(255) NOT NULL, `bathroom_no` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `kitchen` varchar(255) NOT NULL, `swimming_pool` varchar(255) NOT NULL, `suana` varchar(255) NOT NULL, `squash` varchar(255) NOT NULL, `furniture` varchar(255) NOT NULL, `gym` varchar(255) NOT NULL, `steam` varchar(255) NOT NULL, `balicon` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `adverttb` -- INSERT INTO `adverttb` (`id`, `user_id`, `building_name`, `location`, `building_no`, `road_no`, `bedroom_no`, `bathroom_no`, `price`, `description`, `kitchen`, `swimming_pool`, `suana`, `squash`, `furniture`, `gym`, `steam`, `balicon`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '1', 'Real Suites A', 'Mahooz', '1036', '3321', '1', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '521990193.JPG', '2019-03-22', '16:12:42'), (2, '1', 'Patrex Tower', 'Patrex', '', '', '1', '1', '', 'Residential', 'Closed', 'Yes', 'Yes', 'No', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '1022832310.JPG', '2019-03-22', '16:21:52'), (3, '1', 'Salmaniya Plaza', 'Salmaniya', '', '', '2', '2', '', 'Residential', 'Open', 'Yes', 'No', 'No', 'Fully Furnished', 'Yes', 'No', 'No', '1412367304.JPG', '2019-03-23', '09:59:42'), (4, '1', 'Real Suites A', 'Mahooz', '1036', '3321', '2', '2', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '280516737.JPG', '2019-03-22', '16:14:48'), (5, '1', 'Saj 1', 'Mahooz', '', '', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Semi Furnished', 'Yes', 'Yes', 'Yes', '655326602.JPG', '2019-03-23', '11:06:55'), (6, '1', 'Real Suites B', 'Mahooz', '1038', '3321', '2', '2', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1567143876.JPG', '2019-03-22', '16:30:16'), (7, '1', 'Real Suites B', 'Mahooz', '1038', '3321', '1', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1716607035.JPG', '2019-03-22', '16:36:27'), (8, '1', 'Adliya Tower', 'Adliya', '', '', '1', '1', '', 'Office', 'Closed', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'No', '647539857.JPG', '2019-03-23', '09:53:56'), (9, '1', 'Real Suites A', 'Mahooz', '1036', '3321', 'Studio', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1711404267.JPG', '2019-03-22', '16:19:24'), (10, '1', 'Salmaniya Plaza', 'Salmaniya', '', '', '1', '1', '', 'Residential', 'Open', 'Yes', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '426912845.JPG', '2019-03-23', '10:14:33'), (11, '1', 'Saj 1', 'Mahooz', '', '', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Semi Furnished', 'Yes', 'Yes', 'No', '1147310389.JPG', '2019-03-23', '11:02:36'), (12, '1', 'Patrex Tower', 'Patrex', '', '', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'No', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '814633903.JPG', '2019-03-22', '16:26:16'), (13, '1', 'Lenox 1', 'Segeya', '1627', '3241', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Fully Furnished', 'No', 'No', 'No', '1939682329.JPG', '2019-05-04', '17:40:46'), (14, '1', 'Lenox 1', 'Segeya', '1627', '3241', '1', '1', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Semi Furnished', 'Yes', 'No', 'No', '2143866705.JPG', '2019-05-05', '11:04:23'), (15, '1', 'Lenox 2', 'Segeya', '1625', '3241', '2', '2', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '339139075.JPG', '2019-05-05', '11:24:24'), (16, '1', 'Lenox 2', 'Segeya', '1625', '3241', '1', '1', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '954750471.JPG', '2019-05-05', '11:27:36'), (17, '1', 'Saj 2', 'Mahooz', '922', '3318', '2', '2', '360', 'Residential', 'Closed', 'No', 'No', 'No', 'Semi Furnished', 'Yes', 'No', 'Yes', '356673589.jpg', '2019-07-06', '11:19:42'); -- -------------------------------------------------------- -- -- Table structure for table `advert_albumtb` -- CREATE TABLE `advert_albumtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `post_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `advert_albumtb` -- INSERT INTO `advert_albumtb` (`id`, `user_id`, `post_id`, `building_name`, `building_no`, `location`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1441234857.JPG', '2019-03-23', '12:03:02'), (2, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1596341156.JPG', '2019-03-23', '12:03:13'), (3, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1290549276.JPG', '2019-03-23', '12:06:07'), (4, '1', '1', 'Real Suites A', '1036', 'Mahooz', '152487108.JPG', '2019-03-23', '12:06:23'), (5, '1', '4', 'Real Suites A', '1036', 'Mahooz', '646521173.JPG', '2019-03-23', '12:09:36'), (6, '1', '4', 'Real Suites A', '1036', 'Mahooz', '679089202.JPG', '2019-03-23', '12:12:52'), (7, '1', '4', 'Real Suites A', '1036', 'Mahooz', '685168566.JPG', '2019-03-23', '12:15:12'), (8, '1', '4', 'Real Suites A', '1036', 'Mahooz', '830449926.JPG', '2019-03-23', '12:15:34'), (9, '1', '7', 'Real Suites B', '1038', 'Mahooz', '517997250.JPG', '2019-03-23', '12:18:44'), (10, '1', '7', 'Real Suites B', '1038', 'Mahooz', '1352306324.JPG', '2019-03-23', '12:18:59'), (11, '1', '7', 'Real Suites B', '1038', 'Mahooz', '1155817171.JPG', '2019-03-23', '12:19:11'), (12, '1', '7', 'Real Suites B', '1038', 'Mahooz', '786500692.JPG', '2019-03-23', '12:19:21'), (13, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1814585002.JPG', '2019-03-23', '12:21:31'), (14, '1', '9', 'Real Suites A', '1036', 'Mahooz', '60399969.JPG', '2019-03-23', '12:22:08'), (15, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1933838893.JPG', '2019-03-23', '12:22:18'), (16, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1856384435.JPG', '2019-03-23', '12:22:25'), (17, '1', '6', 'Real Suites B', '1038', 'Mahooz', '1180355296.JPG', '2019-03-23', '12:23:06'), (18, '1', '6', 'Real Suites B', '1038', 'Mahooz', '1669447230.JPG', '2019-03-23', '12:23:18'), (19, '1', '6', 'Real Suites B', '1038', 'Mahooz', '505844901.JPG', '2019-03-23', '12:23:36'), (20, '1', '6', 'Real Suites B', '1038', 'Mahooz', '422956229.JPG', '2019-03-23', '12:24:20'), (21, '1', '2', 'Patrex Tower', '', 'Patrex', '2054334651.JPG', '2019-03-23', '12:25:35'), (22, '1', '2', 'Patrex Tower', '', 'Patrex', '2067413336.JPG', '2019-03-23', '12:26:01'), (23, '1', '2', 'Patrex Tower', '', 'Patrex', '793795538.JPG', '2019-03-23', '12:26:40'), (24, '1', '2', 'Patrex Tower', '', 'Patrex', '324450368.JPG', '2019-03-23', '12:27:08'), (25, '1', '2', 'Patrex Tower', '', 'Patrex', '2141211203.JPG', '2019-03-23', '12:27:31'), (26, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '1027441111.JPG', '2019-03-23', '13:02:12'), (27, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '173792802.JPG', '2019-03-23', '13:02:41'), (28, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '457590239.JPG', '2019-03-23', '13:03:08'), (29, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1821502762.JPG', '2019-03-23', '13:05:07'), (30, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1458831.JPG', '2019-03-23', '13:05:29'), (31, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1503278568.JPG', '2019-03-23', '13:05:53'), (32, '1', '5', 'Saj 1', '', 'Mahooz', '1727416769.JPG', '2019-03-23', '13:06:41'), (33, '1', '5', 'Saj 1', '', 'Mahooz', '580459341.JPG', '2019-03-23', '13:06:50'), (34, '1', '5', 'Saj 1', '', 'Mahooz', '1867694984.JPG', '2019-03-23', '13:06:56'), (38, '1', '11', 'Saj 1', '', 'Mahooz', '604588386.JPG', '2019-05-04', '17:20:16'), (39, '1', '11', 'Saj 1', '', 'Mahooz', '1151663666.JPG', '2019-05-04', '17:20:27'), (40, '1', '8', 'Adliya Tower', '', 'Adliya', '1148915686.JPG', '2019-05-04', '17:21:49'), (41, '1', '8', 'Adliya Tower', '', 'Adliya', '496623396.JPG', '2019-05-04', '17:22:05'), (42, '1', '12', 'Patrex Tower', '', 'Patrex', '8935211.JPG', '2019-05-04', '17:23:38'), (43, '1', '12', 'Patrex Tower', '', 'Patrex', '570698612.JPG', '2019-05-04', '17:23:48'), (44, '1', '12', 'Patrex Tower', '', 'Patrex', '2044557347.JPG', '2019-05-04', '17:24:00'), (45, '1', '13', 'Lenox 1', '2222', 'Segeya', '619539998.JPG', '2019-05-04', '17:42:07'), (46, '1', '13', 'Lenox 1', '2222', 'Segeya', '1772829081.JPG', '2019-05-04', '17:42:16'), (47, '1', '13', 'Lenox 1', '2222', 'Segeya', '711078413.JPG', '2019-05-04', '17:42:31'), (48, '1', '13', 'Lenox 1', '2222', 'Segeya', '1879496439.JPG', '2019-05-04', '17:42:45'), (49, '1', '13', 'Lenox 1', '2222', 'Segeya', '1060113289.JPG', '2019-05-04', '17:42:56'), (50, '1', '14', 'Lenox 1', '1627', 'Segeya', '46477619.JPG', '2019-05-05', '11:05:43'), (51, '1', '14', 'Lenox 1', '1627', 'Segeya', '611278288.JPG', '2019-05-05', '11:05:55'), (52, '1', '15', 'Lenox 2', '1625', 'Segeya', '2082159816.JPG', '2019-05-05', '11:29:11'), (53, '1', '15', 'Lenox 2', '1625', 'Segeya', '1142046559.JPG', '2019-05-05', '11:29:23'), (54, '1', '15', 'Lenox 2', '1625', 'Segeya', '1923126355.JPG', '2019-05-05', '11:29:37'), (55, '1', '15', 'Lenox 2', '1625', 'Segeya', '2141166203.JPG', '2019-05-05', '11:29:45'), (56, '1', '16', 'Lenox 2', '1625', 'Segeya', '2129218352.JPG', '2019-05-05', '11:31:05'), (57, '1', '16', 'Lenox 2', '1625', 'Segeya', '439796846.JPG', '2019-05-05', '11:31:24'), (58, '1', '16', 'Lenox 2', '1625', 'Segeya', '1471261010.JPG', '2019-05-05', '11:31:36'); -- -------------------------------------------------------- -- -- Table structure for table `ad_viewstb` -- CREATE TABLE `ad_viewstb` ( `id` int(11) NOT NULL, `advert_id` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ad_viewstb` -- INSERT INTO `ad_viewstb` (`id`, `advert_id`, `user_ip`, `curr_date`, `curr_time`) VALUES (1, '1', '82.194.57.131', '2019-03-23', '10:17:14'), (2, '4', '92.97.157.26', '2019-03-23', '10:55:03'), (3, '7', '37.131.52.114', '2019-03-23', '12:48:31'), (4, '5', '82.194.57.131', '2019-03-23', '13:06:02'), (5, '1', '84.255.186.142', '2019-03-25', '05:10:40'), (6, '6', '82.194.57.131', '2019-03-25', '16:08:43'), (7, '1', '88.201.72.245', '2019-03-30', '05:49:55'), (8, '12', '84.255.163.118', '2019-04-15', '07:44:48'), (9, '12', '82.194.57.131', '2019-04-16', '08:00:58'), (10, '2', '66.249.81.53', '2019-04-18', '12:12:57'), (11, '1', '154.228.56.183', '2019-04-20', '16:10:31'), (12, '1', '217.17.255.252', '2019-04-22', '05:44:45'), (13, '2', '89.148.5.99', '2019-04-28', '05:35:15'), (14, '4', '89.148.5.99', '2019-04-28', '05:36:02'), (15, '10', '89.148.5.99', '2019-04-28', '05:38:04'), (16, '12', '89.148.5.99', '2019-04-28', '05:41:46'), (17, '4', '88.201.34.229', '2019-04-28', '07:28:48'), (18, '9', '54.36.150.182', '2019-04-28', '10:04:42'), (19, '5', '54.36.149.10', '2019-04-28', '11:31:44'), (20, '1', '62.210.201.91', '2019-04-29', '08:26:05'), (21, '12', '62.210.201.91', '2019-04-29', '08:26:06'), (22, '2', '62.210.201.91', '2019-04-29', '08:26:07'), (23, '8', '62.210.201.91', '2019-04-29', '08:26:08'), (24, '10', '62.210.201.91', '2019-04-29', '08:26:13'), (25, '6', '62.210.201.91', '2019-04-29', '08:26:16'), (26, '11', '62.210.201.91', '2019-04-29', '08:26:17'), (27, '3', '62.210.201.91', '2019-04-29', '08:26:20'), (28, '7', '62.210.201.91', '2019-04-29', '08:26:20'), (29, '9', '62.210.201.91', '2019-04-29', '08:26:23'), (30, '5', '62.210.201.91', '2019-04-29', '08:26:24'), (31, '4', '62.210.201.91', '2019-04-29', '08:26:24'), (32, '3', '82.194.57.131', '2019-04-29', '10:49:08'), (33, '7', '54.36.148.103', '2019-04-30', '23:42:06'), (34, '1', '54.36.149.5', '2019-05-01', '09:21:05'), (35, '10', '54.36.148.216', '2019-05-01', '15:14:47'), (36, '2', '84.255.139.231', '2019-05-02', '13:12:14'), (37, '2', '82.194.57.132', '2019-05-02', '13:12:44'), (38, '6', '54.36.148.116', '2019-05-02', '14:51:13'), (39, '1', '88.201.111.78', '2019-05-03', '18:50:48'), (40, '10', '88.201.111.78', '2019-05-03', '18:52:05'), (41, '5', '54.36.148.209', '2019-05-03', '20:57:00'), (42, '6', '54.36.149.81', '2019-05-03', '21:34:32'), (43, '7', '54.36.149.87', '2019-05-03', '22:45:02'), (44, '12', '54.36.148.168', '2019-05-04', '01:00:59'), (45, '1', '54.36.149.53', '2019-05-04', '02:00:22'), (46, '5', '54.36.149.82', '2019-05-04', '04:02:50'), (47, '10', '54.36.148.2', '2019-05-04', '04:53:04'), (48, '4', '54.36.148.93', '2019-05-04', '08:33:07'), (49, '8', '82.194.57.131', '2019-05-04', '09:18:08'), (50, '11', '54.36.148.29', '2019-05-04', '11:22:05'), (51, '1', '89.148.15.65', '2019-05-04', '11:35:48'), (52, '10', '89.148.15.65', '2019-05-04', '11:39:08'), (53, '9', '89.148.15.65', '2019-05-04', '11:40:14'), (54, '11', '89.148.15.65', '2019-05-04', '11:42:44'), (55, '12', '89.148.15.65', '2019-05-04', '11:42:55'), (56, '8', '89.148.15.65', '2019-05-04', '11:43:09'), (57, '2', '89.148.15.65', '2019-05-04', '11:47:26'), (58, '3', '54.36.148.195', '2019-05-04', '13:51:33'), (59, '2', '54.36.149.9', '2019-05-04', '16:08:07'), (60, '8', '185.128.27.142', '2019-05-04', '16:27:48'), (61, '10', '82.194.57.131', '2019-05-04', '17:18:07'), (62, '11', '82.194.57.131', '2019-05-04', '17:18:25'), (63, '9', '82.194.57.131', '2019-05-04', '17:24:52'), (64, '7', '82.194.57.131', '2019-05-04', '17:25:02'), (65, '4', '82.194.57.131', '2019-05-04', '17:25:30'), (66, '2', '82.194.57.131', '2019-05-04', '17:25:50'), (67, '13', '82.194.57.131', '2019-05-04', '17:41:36'), (68, '11', '54.36.148.72', '2019-05-04', '20:12:41'), (69, '13', '89.148.15.65', '2019-05-04', '20:39:49'), (70, '8', '54.36.148.127', '2019-05-04', '22:58:39'), (71, '6', '89.148.24.8', '2019-05-05', '05:30:26'), (72, '8', '54.36.148.10', '2019-05-05', '06:21:04'), (73, '9', '51.255.65.46', '2019-05-05', '07:00:41'), (74, '5', '82.194.52.180', '2019-05-05', '08:45:13'), (75, '4', '82.194.57.132', '2019-05-05', '09:26:18'), (76, '14', '82.194.57.131', '2019-05-05', '11:05:07'), (77, '15', '82.194.57.131', '2019-05-05', '11:28:14'), (78, '16', '82.194.57.131', '2019-05-05', '11:30:33'), (79, '2', '54.36.148.84', '2019-05-05', '18:45:49'), (80, '1', '217.17.255.119', '2019-05-05', '20:08:59'), (81, '3', '54.36.148.43', '2019-05-06', '05:07:32'), (82, '4', '54.36.148.160', '2019-05-06', '05:40:41'), (83, '1', '54.36.148.133', '2019-05-06', '22:39:12'), (84, '7', '54.36.148.151', '2019-05-07', '02:12:09'), (85, '10', '54.36.148.73', '2019-05-07', '05:50:35'), (86, '1', '88.201.36.140', '2019-05-07', '16:18:32'), (87, '3', '88.201.36.140', '2019-05-07', '16:18:52'), (88, '15', '88.201.36.140', '2019-05-07', '16:19:10'), (89, '16', '88.201.36.140', '2019-05-07', '16:19:40'), (90, '14', '88.201.36.140', '2019-05-07', '16:19:57'), (91, '2', '88.201.36.140', '2019-05-07', '16:20:16'), (92, '6', '66.249.64.165', '2019-05-09', '03:03:06'), (93, '7', '66.249.64.165', '2019-05-09', '03:03:18'), (94, '4', '66.249.64.165', '2019-05-09', '03:03:29'), (95, '9', '66.249.64.165', '2019-05-09', '03:03:41'), (96, '5', '66.249.64.165', '2019-05-09', '03:03:52'), (97, '3', '66.249.64.165', '2019-05-09', '03:04:04'), (98, '2', '66.249.64.165', '2019-05-09', '03:04:16'), (99, '8', '66.249.64.165', '2019-05-09', '03:04:27'), (100, '1', '66.249.64.165', '2019-05-09', '03:04:39'), (101, '10', '66.249.64.165', '2019-05-09', '03:04:51'), (102, '14', '66.249.64.165', '2019-05-09', '03:05:02'), (103, '16', '66.249.64.167', '2019-05-09', '03:05:14'), (104, '12', '66.249.64.167', '2019-05-09', '03:05:26'), (105, '15', '66.249.64.165', '2019-05-09', '03:05:37'), (106, '13', '66.249.64.165', '2019-05-09', '03:05:50'), (107, '11', '66.249.64.165', '2019-05-09', '03:06:04'), (108, '6', '66.249.69.84', '2019-05-10', '12:34:34'), (109, '7', '66.249.69.80', '2019-05-10', '14:14:18'), (110, '4', '66.249.69.84', '2019-05-10', '15:54:01'), (111, '9', '66.249.69.84', '2019-05-10', '17:33:44'), (112, '5', '66.249.69.84', '2019-05-10', '19:13:28'), (113, '3', '66.249.79.18', '2019-05-10', '20:53:11'), (114, '1', '66.249.79.4', '2019-05-11', '06:51:29'), (115, '10', '66.249.79.4', '2019-05-11', '08:31:14'), (116, '14', '66.249.79.4', '2019-05-11', '10:10:56'), (117, '16', '66.249.79.4', '2019-05-11', '11:50:39'), (118, '12', '66.249.79.4', '2019-05-11', '13:30:23'), (119, '15', '66.249.79.4', '2019-05-11', '15:10:06'), (120, '13', '66.249.79.8', '2019-05-11', '16:49:49'), (121, '11', '66.249.79.8', '2019-05-11', '18:29:32'), (122, '5', '88.201.16.175', '2019-05-12', '05:05:47'), (123, '16', '62.210.201.91', '2019-05-12', '17:03:10'), (124, '13', '62.210.201.91', '2019-05-12', '17:03:10'), (125, '15', '62.210.201.91', '2019-05-12', '17:03:24'), (126, '14', '62.210.201.91', '2019-05-12', '17:03:31'), (127, '8', '77.69.156.232', '2019-05-12', '19:18:19'), (128, '9', '54.36.148.164', '2019-05-13', '14:26:11'), (129, '12', '54.36.149.77', '2019-05-13', '19:17:45'), (130, '10', '54.36.148.143', '2019-05-14', '16:27:13'), (131, '6', '54.36.148.139', '2019-05-15', '17:17:51'), (132, '3', '88.201.105.43', '2019-05-19', '11:22:08'), (133, '8', '88.201.105.43', '2019-05-19', '13:44:47'), (134, '11', '88.201.69.91', '2019-05-19', '20:45:50'), (135, '8', '88.201.69.91', '2019-05-19', '20:48:19'), (136, '1', '88.201.69.91', '2019-05-19', '20:49:05'), (137, '1', '77.69.159.11', '2019-05-20', '11:27:54'), (138, '3', '77.69.159.11', '2019-05-20', '11:30:52'), (139, '5', '77.69.159.11', '2019-05-20', '11:54:52'), (140, '2', '77.69.159.11', '2019-05-20', '13:16:04'), (141, '8', '54.36.148.70', '2019-05-21', '05:15:56'), (142, '2', '54.36.149.8', '2019-05-21', '07:30:32'), (143, '9', '54.36.148.157', '2019-05-21', '20:03:10'), (144, '13', '54.36.148.120', '2019-05-21', '21:23:58'), (145, '1', '54.36.148.224', '2019-05-22', '06:18:13'), (146, '16', '89.148.13.215', '2019-05-22', '17:49:29'), (147, '6', '54.36.148.174', '2019-05-22', '23:14:52'), (148, '12', '54.36.148.136', '2019-05-23', '00:54:49'), (149, '14', '54.36.149.57', '2019-05-23', '03:10:04'), (150, '11', '54.36.148.191', '2019-05-23', '03:34:28'), (151, '4', '54.36.148.56', '2019-05-23', '15:22:16'), (152, '5', '66.249.64.183', '2019-05-23', '21:00:43'), (153, '2', '54.36.148.32', '2019-05-23', '22:32:03'), (154, '3', '54.36.149.13', '2019-05-25', '21:40:55'), (155, '16', '54.36.149.13', '2019-05-26', '02:11:04'), (156, '2', '82.194.50.186', '2019-05-29', '04:57:28'), (157, '2', '88.201.11.139', '2019-05-29', '13:58:21'), (158, '16', '84.255.142.121', '2019-06-05', '14:27:47'), (159, '5', '54.36.150.74', '2019-06-11', '08:45:25'), (160, '4', '54.36.150.95', '2019-06-12', '01:57:15'), (161, '15', '54.36.148.252', '2019-06-12', '08:10:21'), (162, '2', '89.148.46.168', '2019-06-14', '06:43:51'), (163, '10', '54.36.150.128', '2019-06-15', '04:31:29'), (164, '7', '54.36.150.105', '2019-06-15', '06:31:04'), (165, '1', '54.36.148.207', '2019-06-15', '16:29:21'), (166, '16', '54.36.149.14', '2019-06-15', '20:33:59'), (167, '13', '54.36.150.103', '2019-06-15', '21:03:03'), (168, '6', '54.36.150.110', '2019-06-19', '22:00:26'), (169, '9', '54.36.149.73', '2019-06-21', '10:36:55'), (170, '2', '54.36.148.221', '2019-06-26', '17:48:38'), (171, '11', '54.36.150.174', '2019-06-28', '11:00:45'), (172, '2', '54.36.148.182', '2019-07-03', '18:49:02'), (173, '3', '54.36.149.23', '2019-07-04', '10:09:03'), (174, '12', '54.36.149.2', '2019-07-04', '11:44:07'), (175, '16', '89.148.52.223', '2019-07-07', '05:35:39'), (176, '13', '54.36.150.144', '2019-07-09', '23:32:26'), (177, '16', '54.36.150.64', '2019-07-10', '08:47:00'), (178, '1', '84.255.187.230', '2019-07-10', '18:37:07'), (179, '3', '54.36.150.63', '2019-07-11', '05:30:45'), (180, '6', '66.249.64.185', '2019-07-17', '12:35:34'), (181, '4', '66.249.64.183', '2019-07-17', '12:35:53'), (182, '9', '66.249.64.187', '2019-07-17', '12:36:12'), (183, '3', '66.249.64.183', '2019-07-17', '12:36:51'), (184, '2', '66.249.64.183', '2019-07-17', '12:37:10'), (185, '8', '66.249.64.187', '2019-07-17', '12:37:29'), (186, '1', '66.249.64.183', '2019-07-17', '12:37:50'), (187, '10', '66.249.64.185', '2019-07-17', '12:38:13'), (188, '8', '89.148.25.148', '2019-07-18', '05:32:32'), (189, '3', '78.110.72.122', '2019-07-18', '21:30:22'), (190, '10', '78.110.72.122', '2019-07-18', '21:30:49'), (191, '10', '89.148.4.209', '2019-07-18', '21:31:27'), (192, '3', '188.71.213.168', '2019-07-19', '19:15:13'), (193, '3', '188.71.255.91', '2019-07-20', '08:22:04'), (194, '2', '84.255.165.208', '2019-07-27', '05:45:50'), (195, '1', '81.22.16.102', '2019-07-29', '13:06:53'), (196, '12', '81.22.16.102', '2019-07-29', '13:07:45'), (197, '3', '109.161.170.45', '2019-07-30', '08:53:58'), (198, '14', '62.209.9.89', '2019-08-05', '07:12:35'), (199, '10', '62.209.9.89', '2019-08-05', '07:13:00'), (200, '8', '62.209.9.89', '2019-08-05', '07:13:41'), (201, '7', '62.209.9.89', '2019-08-05', '07:13:52'), (202, '12', '62.209.9.89', '2019-08-05', '07:15:05'), (203, '3', '66.249.79.23', '2019-08-05', '20:56:42'), (204, '8', '66.249.79.14', '2019-08-06', '21:21:01'), (205, '8', '66.249.79.116', '2019-08-07', '08:16:22'), (206, '10', '54.36.150.48', '2019-08-07', '13:16:16'), (207, '14', '54.36.149.46', '2019-08-07', '16:59:00'), (208, '8', '66.249.79.204', '2019-08-07', '20:29:45'), (209, '6', '84.255.148.57', '2019-08-07', '20:53:20'), (210, '2', '54.36.150.29', '2019-08-08', '06:55:48'), (211, '12', '54.36.148.68', '2019-08-08', '15:24:59'), (212, '2', '127.0.0.1', '2019-09-13', '13:59:09'); -- -------------------------------------------------------- -- -- Table structure for table `agent_calltb` -- CREATE TABLE `agent_calltb` ( `id` int(11) NOT NULL, `my_ip` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `agent_calltb` -- INSERT INTO `agent_calltb` (`id`, `my_ip`, `user_id`, `curr_date`, `curr_time`) VALUES (1, '::1', '1', '2019-02-27', '17:55:38'), (2, '192.168.100.38', '1', '2019-03-16', '15:33:25'), (3, '127.0.0.1', '1', '2019-03-16', '15:33:58'), (4, '192.168.100.38', '2', '2019-03-16', '16:30:32'), (5, '89.148.5.99', '1', '2019-04-28', '05:47:07'), (6, '77.69.240.53', '3', '2019-04-30', '05:34:16'); -- -------------------------------------------------------- -- -- Table structure for table `agent_viewtb` -- CREATE TABLE `agent_viewtb` ( `id` int(11) NOT NULL, `my_ip` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `agent_viewtb` -- INSERT INTO `agent_viewtb` (`id`, `my_ip`, `user_id`, `curr_date`, `curr_time`) VALUES (2, '::1', '1', '2019-02-27', '17:55:24'), (3, '::1', '3', '2019-02-28', '08:16:12'), (4, '::1', '2', '2019-02-28', '08:16:21'), (5, '192.168.100.38', '1', '2019-03-14', '13:24:57'), (6, '127.0.0.1', '1', '2019-03-15', '13:31:25'), (7, '192.168.100.38', '2', '2019-03-16', '15:49:49'), (8, '192.168.100.5', '1', '2019-03-17', '13:23:06'), (9, '89.148.5.99', '1', '2019-04-28', '05:46:58'), (10, '77.69.240.53', '3', '2019-04-30', '05:33:55'), (11, '54.36.148.7', '2', '2019-05-07', '22:46:29'), (12, '54.36.148.213', '1', '2019-05-07', '23:13:53'), (13, '54.36.148.62', '3', '2019-05-08', '07:19:52'), (14, '66.249.64.165', '3', '2019-05-09', '03:04:05'), (15, '66.249.64.165', '1', '2019-05-09', '03:04:38'), (16, '66.249.64.165', '2', '2019-05-09', '03:04:45'), (17, '66.249.79.20', '3', '2019-05-10', '22:32:54'), (18, '66.249.79.18', '1', '2019-05-11', '00:12:37'), (19, '66.249.79.20', '2', '2019-05-11', '01:52:20'), (20, '54.36.148.120', '1', '2019-05-13', '11:27:53'), (21, '54.36.148.88', '1', '2019-05-13', '13:20:13'), (22, '54.36.149.2', '3', '2019-05-13', '17:33:44'), (23, '54.36.148.238', '2', '2019-05-22', '03:30:26'), (24, '54.36.149.73', '3', '2019-05-22', '17:50:19'), (25, '54.36.148.15', '2', '2019-05-24', '20:16:36'), (26, '54.36.148.141', '1', '2019-05-27', '14:39:50'), (27, '54.36.150.84', '3', '2019-05-28', '16:11:52'), (28, '54.36.149.68', '1', '2019-06-22', '15:50:55'), (29, '62.209.9.89', '3', '2019-08-05', '07:09:54'), (30, '62.209.9.89', '2', '2019-08-05', '07:10:05'); -- -------------------------------------------------------- -- -- Table structure for table `bd_locationtb` -- CREATE TABLE `bd_locationtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `location_name` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `bd_locationtb` -- INSERT INTO `bd_locationtb` (`id`, `user_id`, `location_name`, `curr_date`, `curr_time`) VALUES (1, '', 'Mahooz', '2019-02-14', '10:23:08'), (2, '', 'Juffair', '2019-02-14', '10:23:25'), (3, '', 'Tubli', '2019-02-14', '10:23:33'), (4, '', 'Al hoora', '2019-02-14', '10:23:47'), (5, '', 'Manama', '2019-02-14', '10:23:56'), (6, '', 'Salmaniya', '2019-02-14', '10:24:16'), (7, '', 'Adliya', '2019-02-14', '10:24:32'), (8, '', 'Un Alhassam', '2019-02-14', '10:24:51'), (9, '', 'Panorama', '2019-02-14', '10:31:09'), (10, '', 'Segeya', '2019-02-14', '10:32:42'); -- -------------------------------------------------------- -- -- Table structure for table `buliding_type` -- CREATE TABLE `buliding_type` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `buliding_name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `buliding_type` -- INSERT INTO `buliding_type` (`id`, `user_id`, `buliding_name`, `location`, `description`, `curr_date`, `curr_time`) VALUES (1, '', 'Real Suites A', 'Mahooz', 'Residential', '2019-02-14', '10:25:29'), (2, '', 'Real Suites B', 'Mahooz', 'Residential', '2019-02-14', '10:25:44'), (3, '', 'Adliya Tower', 'Adliya', 'Office', '2019-02-14', '10:26:52'), (4, '', 'Adliya Tower', 'Adliya', 'Shop', '2019-02-14', '10:27:05'), (5, '', 'Patrex Tower', 'patrex', 'Residential', '2019-02-14', '10:27:59'), (6, '', 'Salmaniya Plaza', 'Salmaniya', 'Residential', '2019-02-14', '10:28:45'), (7, '', 'Saj 1', 'Mahooz', 'Residential', '2019-02-14', '10:29:22'), (8, '', 'Saj 2', 'Mahooz', 'Residential', '2019-02-14', '10:29:36'), (9, '', 'Saj 3', 'Manama', 'Residential', '2019-02-14', '10:30:07'), (10, '', 'Saj 3', 'Manama', 'Office', '2019-02-14', '10:30:28'), (11, '', 'Saj 3', 'Manama', 'Shop', '2019-02-14', '10:30:39'), (12, '', 'Panorama Center', 'Panorama', 'Residential', '2019-02-14', '10:31:37'), (13, '', 'Panorama Center', 'Panorama', 'Shop', '2019-02-14', '10:32:16'), (14, '', 'Lenox 1', 'Segeya', 'Residential', '2019-02-14', '10:33:01'), (15, '', 'Lenox 2', 'Segeya', 'Residential', '2019-02-14', '10:33:21'), (16, '', 'Lenox 3', 'Segeya', 'Residential', '2019-02-14', '10:33:39'), (17, '1', 'Truck Diver', 'Ready to start work on the spot go', 'mahooz', '2019-03-01', '15:10:52'); -- -------------------------------------------------------- -- -- Table structure for table `graph_calendartb` -- CREATE TABLE `graph_calendartb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `start_date` varchar(255) NOT NULL, `end_date` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `graph_calendartb` -- INSERT INTO `graph_calendartb` (`id`, `my_id`, `start_date`, `end_date`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (13, '1', '01-09-2019', '15-09-2019', '15', '10', '2019', '16:13:14'), (17, '1', '01-10-2019', '15-10-2019', '16', '10', '2019', '16:29:26'), (20, '', '', '', '17', '10', '2019', '14:28:02'), (21, '', '12', '12', '17', '10', '2019', '14:32:31'); -- -------------------------------------------------------- -- -- Table structure for table `graph_datatb` -- CREATE TABLE `graph_datatb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `amount_percentage` varchar(255) NOT NULL, `trans_start_date` varchar(255) NOT NULL, `trans_end_date` 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=latin1; -- -- Dumping data for table `graph_datatb` -- INSERT INTO `graph_datatb` (`id`, `my_id`, `property_name`, `amount`, `amount_percentage`, `trans_start_date`, `trans_end_date`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '1', 'Saj 2', '32', '3', '01-09-2019', '15-09-2019', '16', '10', '2019', '15:28:27'), (2, '1', 'Saj 2', '23', '3', '01-09-2019', '15-09-2019', '16', '10', '2019', '15:30:33'), (3, '1', 'Real Suites A', '40', '3', '01-09-2019', '15-09-2019', '16', '10', '2019', '15:30:37'), (4, '1', 'Adliya Tower', '43', '3', '01-09-2019', '15-09-2019', '16', '10', '2019', '15:30:40'), (5, '1', 'Patrex Tower', '55', '3', '01-10-2019', '15-10-2019', '16', '10', '2019', '15:30:43'), (6, '1', 'Lenox 1', '60', '3', '01-10-2019', '15-10-2019', '16', '10', '2019', '15:30:46'), (7, '1', 'Lenox 2', '70', '3', '01-10-2019', '15-10-2019', '16', '10', '2019', '15:30:51'), (8, '1', 'Adliya Tower', '90', '3', '15-10-2019', '30-10-2019', '16', '10', '2019', '16:29:26'), (9, '1', 'Real Suites A', '300', '76', '15-10-2019', '30-10-2019', '17', '10', '2019', '10:07:06'), (10, '1', 'Adliya Tower', '400', '86', '17-10-2019', '30-10-2019', '17', '10', '2019', '10:07:48'), (11, '1', 'Lenox 1', '200', '67', '17-10-2019', '30-10-2019', '17', '10', '2019', '10:09:51'), (12, '1', 'Lenox 1', '100', '67', '01-10-2019', '30-10-2019', '17', '10', '2019', '11:43:36'), (13, '', 'Real Suites A', '', '', '', '', '17', '10', '2019', '14:28:02'), (14, '', 'Lenox 1', '80', '77', '12', '12', '17', '10', '2019', '14:32:31'); -- -------------------------------------------------------- -- -- Table structure for table `jobstb` -- CREATE TABLE `jobstb` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `job_title` text NOT NULL, `job_description` text NOT NULL, `job_location` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `jobstb` -- INSERT INTO `jobstb` (`id`, `user_id`, `job_title`, `job_description`, `job_location`, `curr_date`, `curr_time`) VALUES (1, 1, 'Truck Diver', 'Ready to start work on the spot go', 'Mahooz', '2019-03-01', '15:12:26'), (2, 1, 'Cleaner Position', 'Ready to start work on the spot go', 'Mahooz', '2019-03-01', '15:15:55'), (3, 1, 'Security Guards', 'For the ones who are able', 'Segeya', '2019-03-03', '13:34:45'), (4, 1, 'Campany Secretary', 'Now hiring! \r\nKhalaf Sons Real estate company are looking for a secretary for immediate joining.\r\nCandidate must have the following conditions in order to cover the job responsibilities and duties requirements:\r\n- Bachelor degree holder in business administration or management.\r\n- Fluent in English and Arabic /speaking / reading / writing. \r\n- Being able to multitask. \r\n- Quick forecast.\r\n- Two years as a minimum year of experience. \r\n- Office management experienced and skills.\r\n- Admin experience is a must.\r\nPlease send your updated cv and attached the following:\r\n - Passport copy.\r\n - CPR copy.\r\n - Attach the bachelor degree and professional certificates.\r\nKindly attach the documents.\r\nCandidates with missing documents will be rejected.\r\nCareer Email Address hr@khalafsonsrealestate.com', 'Manama', '2019-08-31', '12:48:42'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_admintb` -- CREATE TABLE `khalaf_admintb` ( `id` int(11) NOT NULL, `user_id_adm` varchar(255) NOT NULL, `cpr_no` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_admintb` -- INSERT INTO `khalaf_admintb` (`id`, `user_id_adm`, `cpr_no`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '1', '1212', '', '', '2019-02-25', '10:31:48'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_agenttb` -- CREATE TABLE `khalaf_agenttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `cpr_no` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_agenttb` -- INSERT INTO `khalaf_agenttb` (`id`, `user_id`, `cpr_no`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '1', '11223344', 'Bahrain', 'Manama', '2019-03-17', '13:14:08'), (2, '2', '202020202', 'Bahrain', 'Manama', '2019-02-24', '13:37:23'), (3, '3', '343434343', 'Bahrain', 'Manama', '2019-02-26', '15:11:21'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_cvtb` -- CREATE TABLE `khalaf_cvtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `cv_title` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `cv_cover` text NOT NULL, `file_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_cvtb` -- INSERT INTO `khalaf_cvtb` (`id`, `user_id`, `cv_title`, `name`, `contact`, `email`, `cv_cover`, `file_url`, `curr_date`, `curr_time`) VALUES (1, '1', 'Truck Diver', 'katongole jef', '695855945945', 'jefrtythyhyh', 'k.j l/bi kuttfyjxjxg ', '1581939548.docx', '2019-03-03', '11:25:33'), (2, '1', 'Truck Diver', 'mamohmad hassan', '4324252453245', 'hassan@kvt.com', ' the cv cover read it carefully coz if,you do not ,i will push you badly. \r\ndo not waste my time please .\r\nYou hard me right.\r\ncome one come all but do not miss this\r\nthanks omulala agaana', '1733047085.docx', '2019-03-03', '12:05:10'), (3, '1', 'Security Guards', 'Robert Regal', '4584754857485', 'rob@kvt.com', ' Am able to perform full duty time with no stress to my bosses \r\nam hard working and skilled worker.\r\ntry me you will not regret.', '1090541167.docx', '2019-03-03', '13:37:05'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_messagetb` -- CREATE TABLE `khalaf_messagetb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `message` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_messagetb` -- INSERT INTO `khalaf_messagetb` (`id`, `my_id`, `user_id`, `message`, `curr_date`, `curr_time`) VALUES (1, '1', '2', 'kib', '2019-02-26', '13:01:26'), (2, '1', '2', 'OK i hope this will work for me well', '2019-02-26', '14:09:15'), (3, '1', '2', 'kibkibOK i hope this will work for me wellOK i hope this will work for me well', '2019-02-26', '14:09:45'), (4, '2', '1', 'try it out', '2019-02-26', '14:42:07'), (5, '2', '1', 'what', '2019-02-26', '17:25:17'), (6, '1', '2', 'so also you send', '2019-02-26', '17:34:56'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_propertytbb` -- CREATE TABLE `khalaf_propertytbb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `property_details` text NOT NULL, `property_location` varchar(255) NOT NULL, `property_road_no` varchar(255) NOT NULL, `property_build_no` varchar(255) NOT NULL, `property_image` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_propertytbb` -- INSERT INTO `khalaf_propertytbb` (`id`, `user_id`, `property_name`, `property_details`, `property_location`, `property_road_no`, `property_build_no`, `property_image`, `curr_date`, `curr_time`) VALUES (1, '', 'REAL SUITES TOWERS', '\r\nWhen we talk about Real Suites we are not only talking about the building,\r\nbut a twin tower with 13 floors each located in Mahooz,Road no.3321,Block no.333 few meters off to Saudi high way.\r\nReal suites flats has the best furniture that solves the uncomfortability problem.\r\nit\'s calm ,with enough car parking space for each flat and secure with a 24/7 hour security guard and CCTV cameras on each floor.\r\nReal suites has it\'s own maintenance team that is always there to solve faults. \r\n\r\n\r\n', 'Mahooz', '3321', '1036', '1139191632.JPG', '2019-02-14', '12:44:16'), (2, '', 'PATREX TOWER', 'The Giant building in the heart of the city of the Kingdom of Bahrain.\r\nWith a great view of the city,\r\nSpeak of luxury, Patrex Tower stands to take a shapes in our imagination, that take our life from the usual routine to an extraordinary adventure', 'Patrex', '100', '200', '418091599.JPG', '2019-02-14', '14:03:25'), (3, '', 'ADLIYA TOWER', 'Sure about what makes Adliya Tower so weirdly wonderful , Live like a local and find out for yourself at our newly renovated apartments in Mahooz , All Amenities are available. We are located in Adliya', 'Adliya', '300', '400', '1274061614.JPG', '2019-02-14', '14:42:49'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_usertb` -- CREATE TABLE `khalaf_usertb` ( `id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `gender` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_usertb` -- INSERT INTO `khalaf_usertb` (`id`, `first_name`, `last_name`, `contact`, `gender`, `email`, `password`, `image_url`, `curr_date`, `curr_time`) VALUES (1, 'kaketo', 'ben', '11223344', 'Male', 'ben@kvt.com', '1234', '910731546.jpg', '2019-02-13', '12:31:35'), (2, 'Remmie', 'Kb', '4454533', 'Female', 'remmie@kvt.com', '1234', '1217319548.jpg', '2019-02-24', '12:05:45'), (3, 'Dora', 'kirabo', '343434', 'Female', 'dora@kvt.com', '1234', 'avatar2.jpg', '2019-02-26', '15:10:17'); -- -------------------------------------------------------- -- -- Table structure for table `main_buildingtb` -- CREATE TABLE `main_buildingtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `building_location` varchar(255) NOT NULL, `bd_description` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `road_no` varchar(255) NOT NULL, `manager_name` varchar(255) NOT NULL, `manager_tel` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `main_buildingtb` -- INSERT INTO `main_buildingtb` (`id`, `user_id`, `building_name`, `building_location`, `bd_description`, `building_no`, `road_no`, `manager_name`, `manager_tel`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '', 'Real Suites A', 'Mahooz', 'Residential', '1036', '3321', 'Jehad', '32213149', '218762400.JPG', '2019-02-14', '12:05:27'), (2, '', 'Adliya Tower', 'Adliya', 'Residential', '2000', '3321', 'Jehad', '32213149', '1581047250.JPG', '2019-02-16', '14:58:28'), (3, '', 'Patrex Tower', 'patrex', 'Residential', '111', '222', 'Hamad', '32213149', '1286671067.JPG', '2019-02-18', '11:16:06'), (4, '1', 'Lenox 1', 'Segeya', 'Residential', '1627', '3241', 'Jamil', '17822550', '79621283.JPG', '2019-05-04', '17:38:16'), (5, '1', 'Lenox 2', 'Segeya', 'Residential', '1625', '3241', 'Jamil', '17822550', '194364817.JPG', '2019-05-05', '11:22:20'), (6, '1', 'Saj 2', 'Mahooz', 'Residential', '922', '3318', 'Hassan S', '17822550', '1773446624.JPG', '2019-07-06', '11:16:40'); -- -------------------------------------------------------- -- -- Table structure for table `new_ordertb` -- CREATE TABLE `new_ordertb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_qty` varchar(255) NOT NULL, `order_by_id` varchar(255) NOT NULL, `image_url_one` text NOT NULL, `image_url_two` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `new_ordertb` -- INSERT INTO `new_ordertb` (`id`, `my_id`, `building_name`, `flat_no`, `product_name`, `product_qty`, `order_by_id`, `image_url_one`, `image_url_two`, `curr_date`, `curr_time`) VALUES (1, '22', '45r', 'thr', 'trth', 'thrh', 'th', '', '', '2019-03-19', '16:30:11'), (5, '1', 'Salmaniya Plaza', '54', 'tape head', '3', 'opnfpog', '', '', '2019-03-19', '16:44:40'), (6, '1', 'Real suites A', '44', 'Ac fan', '1', 'thtttt', '', '', '2019-03-19', '16:45:02'), (7, '1', 'fd', 'v', 'fv', 'df', 'f', '', '', '2019-03-19', '16:46:35'), (8, '1', 'Patrex tower', '11', 'exust fan', '4', 'hamad', '', '', '2019-03-20', '11:50:37'), (9, '1', 'Real suites B', '74', 'spot lights', '6', 'Jehad', '', '', '2019-03-20', '11:52:08'), (10, '1', 'Saj 2', '31', 'body spray', '2', 'said hassan', '', '', '2019-03-20', '11:54:11'), (12, '1', 'Saj 2', '21', 'Shut off', '2', '1', '575158625.jpg', '1138105390.', '2019-08-31', '16:51:13'), (13, '1', 'Salmaniya plaza', '34', 'spot led light white', '5', '1', '860836751.jpg', '2144453636.', '2019-09-10', '13:35:46'); -- -------------------------------------------------------- -- -- Table structure for table `property_albumtb` -- CREATE TABLE `property_albumtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `property_id` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `property_albumtb` -- INSERT INTO `property_albumtb` (`id`, `user_id`, `property_id`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '', '1', '673881864.JPG', '2019-02-14', '12:47:22'), (2, '', '1', '1410748263.JPG', '2019-02-14', '12:47:36'), (3, '', '1', '314019947.JPG', '2019-02-14', '12:47:57'); -- -------------------------------------------------------- -- -- Table structure for table `purchased_producttb` -- CREATE TABLE `purchased_producttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `order_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_qty` varchar(255) NOT NULL, `shop_iterm` varchar(255) NOT NULL, `total_price` varchar(255) NOT NULL, `order_by_id` varchar(255) NOT NULL, `picked_by` varchar(255) NOT NULL, `invoice_no` varchar(255) NOT NULL, `curr_date` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `purchased_producttb` -- INSERT INTO `purchased_producttb` (`id`, `user_id`, `order_id`, `building_name`, `flat_no`, `product_name`, `product_qty`, `shop_iterm`, `total_price`, `order_by_id`, `picked_by`, `invoice_no`, `curr_date`, `curr_month`, `curr_year`, `curr_time`) VALUES (15, '1', '13', 'Salmaniya plaza', '34', 'spot led light white', '5', 'Salman Fardan', '10', '1', 'M Khalaf', '1111', '13', '09', '2019', '16:31:02'); -- -- Indexes for dumped tables -- -- -- Indexes for table `adverttb` -- ALTER TABLE `adverttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `advert_albumtb` -- ALTER TABLE `advert_albumtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ad_viewstb` -- ALTER TABLE `ad_viewstb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `agent_calltb` -- ALTER TABLE `agent_calltb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `agent_viewtb` -- ALTER TABLE `agent_viewtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bd_locationtb` -- ALTER TABLE `bd_locationtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `buliding_type` -- ALTER TABLE `buliding_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `graph_calendartb` -- ALTER TABLE `graph_calendartb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `graph_datatb` -- ALTER TABLE `graph_datatb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobstb` -- ALTER TABLE `jobstb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_admintb` -- ALTER TABLE `khalaf_admintb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_agenttb` -- ALTER TABLE `khalaf_agenttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_cvtb` -- ALTER TABLE `khalaf_cvtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_messagetb` -- ALTER TABLE `khalaf_messagetb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_propertytbb` -- ALTER TABLE `khalaf_propertytbb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_usertb` -- ALTER TABLE `khalaf_usertb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `main_buildingtb` -- ALTER TABLE `main_buildingtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `new_ordertb` -- ALTER TABLE `new_ordertb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `property_albumtb` -- ALTER TABLE `property_albumtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchased_producttb` -- ALTER TABLE `purchased_producttb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `adverttb` -- ALTER TABLE `adverttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `advert_albumtb` -- ALTER TABLE `advert_albumtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59; -- -- AUTO_INCREMENT for table `ad_viewstb` -- ALTER TABLE `ad_viewstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=213; -- -- AUTO_INCREMENT for table `agent_calltb` -- ALTER TABLE `agent_calltb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `agent_viewtb` -- ALTER TABLE `agent_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `bd_locationtb` -- ALTER TABLE `bd_locationtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `buliding_type` -- ALTER TABLE `buliding_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `graph_calendartb` -- ALTER TABLE `graph_calendartb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `graph_datatb` -- ALTER TABLE `graph_datatb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `jobstb` -- ALTER TABLE `jobstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `khalaf_admintb` -- ALTER TABLE `khalaf_admintb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `khalaf_agenttb` -- ALTER TABLE `khalaf_agenttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `khalaf_cvtb` -- ALTER TABLE `khalaf_cvtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `khalaf_messagetb` -- ALTER TABLE `khalaf_messagetb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `khalaf_propertytbb` -- ALTER TABLE `khalaf_propertytbb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `khalaf_usertb` -- ALTER TABLE `khalaf_usertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `main_buildingtb` -- ALTER TABLE `main_buildingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `new_ordertb` -- ALTER TABLE `new_ordertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `property_albumtb` -- ALTER TABLE `property_albumtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `purchased_producttb` -- ALTER TABLE `purchased_producttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; 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 */;