| 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:/khalafsite-backup/New/database/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.8.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 12, 2020 at 12:31 PM -- 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, `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 `ad_viewstb` -- INSERT INTO `ad_viewstb` (`id`, `advert_id`, `user_ip`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '17', '66.249.64.154', 'United States', '', '2020-02-04', '08:30:37'), (2, '5', '66.249.64.156', 'United States', '', '2020-02-04', '10:21:00'), (3, '14', '66.249.64.156', 'United States', '', '2020-02-04', '11:10:57'), (4, '13', '66.249.64.152', 'United States', '', '2020-02-04', '11:21:09'), (5, '1', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-04', '12:47:03'), (6, '12', '66.249.64.152', 'United States', '', '2020-02-04', '18:03:04'), (7, '17', '66.249.64.152', 'United States', '', '2020-02-04', '19:02:53'), (8, '11', '66.249.64.156', 'United States', '', '2020-02-04', '19:13:14'), (9, '3', '66.249.73.25', 'United States', '', '2020-02-04', '21:53:41'), (10, '5', '66.249.73.24', 'United States', '', '2020-02-05', '01:54:01'), (11, '15', '66.249.73.24', 'United States', '', '2020-02-05', '03:44:45'), (12, '17', '66.249.73.25', 'United States', '', '2020-02-05', '04:31:29'), (13, '3', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:29:25'), (14, '2', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:30:40'), (15, '4', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:31:25'), (16, '5', '66.249.73.23', 'United States', '', '2020-02-05', '11:40:55'), (17, '3', '66.249.68.24', 'United States', '', '2020-02-05', '19:33:18'), (18, '6', '54.36.150.67', 'France', '', '2020-02-06', '18:38:08'), (19, '3', '54.36.148.106', 'France', '', '2020-02-07', '12:59:21'), (20, '8', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:27:18'), (21, '9', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:28:08'), (22, '10', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:28:47'), (23, '11', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:29:40'), (24, '12', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:30:02'), (25, '13', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:30:49'), (26, '15', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:02'), (27, '17', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:24'), (28, '16', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:44'), (29, '7', '66.249.68.28', 'United States', '', '2020-02-08', '10:19:36'), (30, '17', '66.249.68.28', 'United States', '', '2020-02-08', '11:09:47'), (31, '17', '66.249.68.26', 'United States', '', '2020-02-08', '23:14:21'); -- -------------------------------------------------------- -- -- 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, `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; -- -------------------------------------------------------- -- -- 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, `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 `agent_viewtb` -- INSERT INTO `agent_viewtb` (`id`, `my_ip`, `user_id`, `country`, `city`, `curr_date`, `curr_time`) VALUES (32, '54.36.148.37', '2', 'France', '', '2020-02-07', '04:19:17'); -- -------------------------------------------------------- -- -- 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, '1', 'Hoora', '2019-11-21', '16:22:35'), (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 Al Hassam', '2019-02-14', '10:24:51'), (9, '', 'Panorama', '2019-02-14', '10:31:09'), (10, '', 'Segeya', '2019-02-14', '10:32:42'), (11, '1', 'Bu Ashira', '2019-11-21', '16:19:38'), (12, '1', 'Exhibition Road', '2019-11-21', '16:21:57'), (13, '1', 'Zinji', '2019-11-21', '16:22:19'); -- -------------------------------------------------------- -- -- 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', 'Un Al Hassam', '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', 'Adel House', 'Bu Ashira', 'Residential', '2019-11-28', '16:04:02'); -- -------------------------------------------------------- -- -- Table structure for table `complainttb` -- CREATE TABLE `complainttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `complaint_detail` text NOT NULL, `complaint_by` varchar(255) NOT NULL, `complaint_to` varchar(255) NOT NULL, `comp_status` varchar(255) NOT NULL, `comp_finished_by` varchar(255) NOT NULL, `id_edit_comp_to` varchar(255) NOT NULL, `id_edit_comp_status` varchar(255) NOT NULL, `id_edit_comp_done_by` 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=utf8mb4; -- -- Dumping data for table `complainttb` -- INSERT INTO `complainttb` (`id`, `my_id`, `building_name`, `flat_no`, `complaint_detail`, `complaint_by`, `complaint_to`, `comp_status`, `comp_finished_by`, `id_edit_comp_to`, `id_edit_comp_status`, `id_edit_comp_done_by`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', 'Salmaniya Plaza', '23', 'No Tv signal,MBC not working ', 'Adul', 'Madan', 'Replaced New', 'Vicent', '1', '1', '1', '04', '02', '2020', '12:34:06'), (2, '1', 'Saj 2', '24', 'Tv give bad sound', 'Sayed H', 'Madan', 'Working', 'Vicent/Sayed M', '1', '1', '1', '04', '02', '2020', '12:35:39'), (3, '1', 'Saj 2', '11', 'Tv not working at all', 'Sayed H', 'Madan', 'Done', 'Vicent/Sayed M', '1', '1', '1', '04', '02', '2020', '12:36:48'), (4, '1', 'Saj 2', '12', 'Water leak form roof top to bedroomcomp by Client ', 'Abid', 'Jose', 'Working', 'Jose/Sebin', '1', '1', '1', '05', '02', '2020', '15:06:41'), (5, '1', 'Panorama Center', '54', 'Tv not working locked with password smart tv', 'Suresh', 'Jamil/Madan', 'Done', 'Vicent/Hakim/Sayed M', '1', '1', '1', '05', '02', '2020', '15:31:26'), (6, '1', 'Lenox 2', '24', 'Fridge working but bad smell coming out', 'Dinsh', 'Madan', 'Replaced New', 'Madan/salam gas', '1', '1', '1', '06', '02', '2020', '08:24:17'), (7, '1', 'Real Suites A', '92', 'Water heater not working', 'Jihad', 'Jose/Sebin', 'Working', '', '1', '1', '', '06', '02', '2020', '08:41:13'), (8, '1', 'Panorama Center', '51', 'One sofa damaged need repair', 'Suresh', 'Madan', '', '', '1', '', '', '06', '02', '2020', '08:42:03'), (9, '1', 'Panorama Center', '45', 'Mattress not good', 'Suresh', 'Madan', 'Working', 'Madan', '1', '1', '1', '06', '02', '2020', '08:42:38'), (10, '1', 'Panorama Center', '36', 'There is water leak in the bathroom', 'Suresh', 'Madan', 'Working', 'Suresh', '1', '1', '1', '06', '02', '2020', '08:43:46'), (11, '1', 'Saj 2', '13', 'Sweet water machine tank not workingkitchen area', 'Sayed H', 'Madan', 'Working', 'Sayed H', '1', '1', '1', '06', '02', '2020', '10:48:34'), (12, '1', 'Lenox 1', '32', 'Kitchen light 2 not working', 'Tenant', 'Dinesh', 'Done', 'Dinesh', '1', '1', '1', '08', '02', '2020', '10:35:42'), (13, '1', 'Lenox 1', '32', 'kitchen cabinet top need to chane', 'Dinesh', 'Madan', 'No Action', '', '1', '1', '', '09', '02', '2020', '11:53:14'), (14, '1', 'Real Suites A', '92', 'Water heater not woriking master bedroom', 'Sebin', 'Jose/Sebin', 'Working', 'Jose/Sebin', '1', '1', '1', '09', '02', '2020', '12:02:51'), (15, '1', 'Lenox 3', '42', 'Some Tv channels are not working', 'Tenant', 'M khalaf', 'Done', 'M Khalaf', '1', '1', '1', '09', '02', '2020', '13:14:34'), (16, '1', 'Lenox 3', 'Main tank', 'Ground tank overflow', 'Rajack', 'Madan/Hamad', 'Working', '', '1', '1', '', '09', '02', '2020', '14:22:02'), (17, '1', 'Lenox 1', '33', 'Bathroom,Shower basin broken cl 2:00pm', 'Dinesh', 'Madan', '', '', '1', '', '', '11', '02', '2020', '11:51:51'); -- -------------------------------------------------------- -- -- Table structure for table `complaint_datingtb` -- CREATE TABLE `complaint_datingtb` ( `id` int(11) NOT NULL, `my_id` 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=utf8mb4; -- -- Dumping data for table `complaint_datingtb` -- INSERT INTO `complaint_datingtb` (`id`, `my_id`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (2, '1', '04', '02', '2020', '12:34:06'), (3, '1', '05', '02', '2020', '15:06:41'), (4, '1', '06', '02', '2020', '08:24:17'), (5, '1', '08', '02', '2020', '10:35:42'), (6, '1', '09', '02', '2020', '11:53:14'), (7, '1', '11', '02', '2020', '11:51:51'); -- -------------------------------------------------------- -- -- Table structure for table `expendituretb` -- CREATE TABLE `expendituretb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `shop_id` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `amount` 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, `currtime` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `expendituretb` -- INSERT INTO `expendituretb` (`id`, `my_id`, `shop_id`, `shop_name`, `amount`, `start_date`, `end_date`, `curr_day`, `curr_month`, `curr_year`, `currtime`) VALUES (1, '1', '1', 'Salman Fardan', '779.6', '01-09-2019', '15-09-2019', '25', '11', '2019', '15:57:36'), (2, '1', '2', 'Javed Air Conditioners', '535.920', '01-08-2019', '11-09-2019', '25', '11', '2019', '16:08:47'), (3, '1', '3', 'Al Salam Gas', '6290.998', '09-06-2019', '26-09-2019', '25', '11', '2019', '16:43:28'), (4, '1', '1', 'Salman Fardan', '1061.7', '15-09-2019', '30-09-2019', '27', '11', '2019', '16:51:17'), (5, '1', '2', 'Javed Air Conditioners', '565.635', '12-09-2019', '21-10-2019', '27', '11', '2019', '16:53:09'), (6, '1', '1', 'Salman Fardan', '835.150', '30-09-2019', '16-10-2019', '28', '11', '2019', '10:33:36'), (7, '1', '2', 'Javed Air Conditioners', '183.070', '24-10-2019', '19-11-2019', '28', '11', '2019', '10:34:36'), (8, '1', '3', 'Al Salam Gas', '1911.998', '05-10-2019', '31-10-2019', '28', '11', '2019', '10:35:20'), (9, '1', '1', 'Salman Fardan', '680.6', '17-10-2019', '02-11-2019', '28', '11', '2019', '10:36:03'), (10, '1', '1', 'Salman Fardan', '766.8', '02-11-2019', '14-11-2019', '28', '11', '2019', '10:48:25'), (11, '1', '1', 'Salman Fardan', '560.2', '14-11-2019', '01-12-2019', '02', '12', '2019', '16:22:02'), (12, '1', '1', 'Salman Fardan', '527.9', '01-12-2019', '15-12-2019', '19', '12', '2019', '09:53:25'); -- -------------------------------------------------------- -- -- Table structure for table `graph_calendartb` -- CREATE TABLE `graph_calendartb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `status_code` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `total_amount` 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`, `status_code`, `shop_name`, `total_amount`, `start_date`, `end_date`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', '530515', 'Salman Fardan', '779.6', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:14:06'), (2, '1', '304065', 'Javed Air Conditioners', '535.920', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:09:26'), (3, '1', '274059', 'Al Salam Gas', '6290.998', '09-06-2019', '26-09-2019', '07', '12', '2019', '15:59:25'), (4, '1', '44624', 'Salman Fardan', '1061.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:25:59'), (5, '1', '854028', 'Javed Air Conditioners', '565.635', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:47:24'), (6, '1', '746228', 'Salman Fardan', '835.150', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:11:16'), (7, '1', '879994', 'Javed Air Conditioners', '183.070', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:57:10'), (8, '1', '500320', 'Al Salam Gas', '1911.998', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:46:52'), (9, '1', '765857', 'Salman Fardan', '680.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:23:55'), (10, '1', '339022', 'Salman Fardan', '766.8', '02-11-2019', '14-11-2019', '08', '12', '2019', '15:38:28'), (11, '1', '286587', 'Salman Fardan', '560.2', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:53:28'), (12, '1', '247998', 'Salman Fardan', '527.9', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:30:07'); -- -------------------------------------------------------- -- -- Table structure for table `graph_datatb` -- CREATE TABLE `graph_datatb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `status_code` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `property_ower` varchar(255) NOT NULL, `amount` 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`, `status_code`, `property_name`, `property_ower`, `amount`, `trans_start_date`, `trans_end_date`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '1', '530515', 'Adel House', 'ADEL', '23.3', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:14:06'), (2, '1', '530515', 'Brown Tower', 'ADEL AND SALAH', '15.8', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:23:55'), (3, '1', '530515', 'Lenox 1', 'KHALAF SONS', '50.9', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:26:41'), (4, '1', '530515', 'Lenox 2', 'KHALAF SONS', '45.5', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:27:39'), (5, '1', '530515', 'Lenox 3', 'KHALAF SONS', '29.3', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:28:32'), (6, '1', '530515', 'Capital Medical Complex', 'KHALAF SONS', '26.8', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:26:30'), (7, '1', '530515', 'Indonesian Embassy', 'KHALAF SONS', '6.5', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:10'), (8, '1', '530515', 'Panorama Center', 'KHALAF SONS', '47.9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:32'), (9, '1', '530515', 'Patrex Tower', 'KHALAF SONS', '84.3', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:50'), (10, '1', '530515', 'Real Suites A', 'ADEL AND SALAH', '32.650', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:16'), (11, '1', '530515', 'Real Suites B', 'ADEL AND SALAH', '88.050', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:30'), (12, '1', '530515', 'Saj 1', 'KHALAF SONS', '13', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:45'), (13, '1', '530515', 'Saj 2', 'KHALAF SONS', '9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:57'), (14, '1', '530515', 'Saj 3', 'KHALAF SONS', '27.9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:29:11'), (15, '1', '530515', 'Salah House', 'SALAH', '79.8', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:41:10'), (16, '1', '530515', 'Salmaniya Plaza', 'ADEL AND SALAH', '168.4', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:41:25'), (17, '1', '530515', 'Tubli Center', 'ADEL', '13', '01-09-2019', '15-09-2019', '03', '12', '2019', '12:46:04'), (18, '1', '530515', 'Vintage', 'SALAH', '15', '01-09-2019', '15-09-2019', '03', '12', '2019', '12:46:33'), (19, '1', '304065', 'Adel House', 'ADEL', '7.875', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:09:26'), (20, '1', '304065', 'Lenox 1', 'KHALAF SONS', '6.3', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:14:45'), (21, '1', '304065', 'Lenox 2', 'KHALAF SONS', '51.450', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:15:00'), (22, '1', '304065', 'Lenox 3', 'KHALAF SONS', '2.1', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:11'), (23, '1', '304065', 'Panorama Center', 'KHALAF SONS', '3.78', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:26'), (24, '1', '304065', 'Patrex Tower', 'KHALAF SONS', '133.77', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:39'), (25, '1', '304065', 'Real Suites A', 'ADEL AND SALAH', '67.725', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:56'), (26, '1', '304065', 'Real Suites B', 'ADEL AND SALAH', '105.525', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:07'), (27, '1', '304065', 'Saj 1', 'KHALAF SONS', '4.620', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:23'), (28, '1', '304065', 'Saj 2', 'KHALAF SONS', '38.325', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:37'), (29, '1', '304065', 'Salmaniya Plaza', 'ADEL AND SALAH', '114.45', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:55'), (30, '1', '274059', 'Adel House', 'ADEL', '129.999', '09-06-2019', '26-09-2019', '07', '12', '2019', '15:59:25'), (31, '1', '274059', 'Brown Tower', 'ADEL AND SALAH', '100', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:00:42'), (32, '1', '274059', 'Lenox 1', 'KHALAF SONS', '572', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:00:57'), (33, '1', '274059', 'Lenox 2', 'KHALAF SONS', '425', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:07'), (34, '1', '274059', 'Lenox 3', 'KHALAF SONS', '250', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:17'), (35, '1', '274059', 'Panorama Center', 'KHALAF SONS', '1640', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:32'), (36, '1', '274059', 'Patrex Tower', 'KHALAF SONS', '496', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:45'), (37, '1', '274059', 'Real Suites A', 'ADEL AND SALAH', '661', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:59'), (38, '1', '274059', 'Real Suites B', 'ADEL AND SALAH', '680', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:08'), (39, '1', '274059', 'Saj 1', 'KHALAF SONS', '214', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:20'), (40, '1', '274059', 'Saj 2', 'KHALAF SONS', '365', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:32'), (41, '1', '274059', 'Salmaniya Plaza', 'ADEL AND SALAH', '493', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:46'), (42, '1', '274059', 'Vintage', 'SALAH', '264.999', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:03:03'), (43, '1', '44624', '5Villa', 'ADEL', '37.4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:25:59'), (44, '1', '44624', 'Adel House', 'ADEL', '15', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:26:34'), (45, '1', '44624', 'Brown Tower', 'ADEL AND SALAH', '50.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:26:52'), (46, '1', '44624', 'Capital Medical Complex', 'KHALAF SONS', '28', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:03'), (47, '1', '44624', 'Indonesian Embassy', 'KHALAF SONS', '0.8', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:21'), (48, '1', '44624', 'Korean Embassy', 'KHALAF SONS', '4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:32'), (49, '1', '44624', 'Lenox 1', 'KHALAF SONS', '50.3', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:43'), (50, '1', '44624', 'Lenox 2', 'KHALAF SONS', '24', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:51'), (51, '1', '44624', 'Lenox 3', 'KHALAF SONS', '16.4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:05'), (52, '1', '44624', 'Panorama Center', 'KHALAF SONS', '67.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:17'), (53, '1', '44624', 'Patrex Tower', 'KHALAF SONS', '146.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:32'), (54, '1', '44624', 'Real Suites A', 'ADEL AND SALAH', '84.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:47'), (55, '1', '44624', 'Real Suites B', 'ADEL AND SALAH', '152', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:54'), (56, '1', '44624', 'Saj 1', 'KHALAF SONS', '83.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:11'), (57, '1', '44624', 'Saj 2', 'KHALAF SONS', '93.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:25'), (58, '1', '44624', 'Saj 3', 'KHALAF SONS', '8.5', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:35'), (59, '1', '44624', 'Salmaniya Plaza', 'ADEL AND SALAH', '157.6', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:48'), (60, '1', '44624', 'Tubli Center', 'ADEL', '40', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:30:14'), (61, '1', '44624', 'Vintage', 'SALAH', '2.5', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:30:28'), (62, '1', '854028', 'Lenox 1', 'Select Holder', '31.5', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:47:24'), (63, '1', '854028', 'Lenox 2', 'KHALAF SONS', '14.7', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:48:43'), (64, '1', '854028', 'Lenox 3', 'KHALAF SONS', '8.4', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:48:57'), (65, '1', '854028', 'Panorama Center', 'KHALAF SONS', '41.475', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:22'), (66, '1', '854028', 'Patrex Tower', 'KHALAF SONS', '120.435', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:38'), (67, '1', '854028', 'Real Suites A', 'ADEL AND SALAH', '42.525', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:55'), (68, '1', '854028', 'Real Suites B', 'ADEL AND SALAH', '63', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:02'), (69, '1', '854028', 'Saj 1', 'KHALAF SONS', '67.2', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:43'), (70, '1', '854028', 'Saj 2', 'KHALAF SONS', '45.15', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:55'), (71, '1', '854028', 'Salmaniya Plaza', 'ADEL AND SALAH', '131.25', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:51:16'), (72, '1', '746228', '5Villa', 'ADEL', '24', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:11:16'), (73, '1', '746228', 'Adliya Tower', 'KHALAF SONS', '15', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:12:25'), (74, '1', '746228', 'Brown Tower', 'ADEL AND SALAH', '25.1', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:12:50'), (75, '1', '746228', 'Indonesian Embassy', 'KHALAF SONS', '27.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:06'), (76, '1', '746228', 'Korean Embassy', 'KHALAF SONS', '35.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:30'), (77, '1', '746228', 'Lenox 1', 'KHALAF SONS', '7.1', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:43'), (78, '1', '746228', 'Lenox 2', 'KHALAF SONS', '3', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:51'), (79, '1', '746228', 'Lenox 3', 'KHALAF SONS', '31.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:03'), (80, '1', '746228', 'Panorama Center', 'KHALAF SONS', '78.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:16'), (81, '1', '746228', 'Patrex Tower', 'KHALAF SONS', '81.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:38'), (82, '1', '746228', 'Real Suites A', 'ADEL AND SALAH', '65.85', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:58'), (83, '1', '746228', 'Real Suites B', 'ADEL AND SALAH', '308.2', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:10'), (84, '1', '746228', 'Saj 1', 'KHALAF SONS', '61.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:27'), (85, '1', '746228', 'Saj 2', 'KHALAF SONS', '15.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:39'), (86, '1', '746228', 'Saj 3', 'KHALAF SONS', '13', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:50'), (87, '1', '746228', 'Salmaniya Plaza', 'ADEL AND SALAH', '9', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:03'), (88, '1', '746228', 'Tubli Center', 'ADEL', '19.4', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:24'), (89, '1', '746228', 'Vintage', 'SALAH', '12.5', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:43'), (90, '1', '879994', 'Adel House', 'ADEL', '18.05', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:57:11'), (91, '1', '879994', 'Capital Medical Complex', 'KHALAF SONS', '40.95', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:58:46'), (92, '1', '879994', 'Korean Embassy', 'KHALAF SONS', '2.3', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:21'), (93, '1', '879994', 'Lenox 2', 'KHALAF SONS', '15.12', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:35'), (94, '1', '879994', 'Patrex Tower', 'KHALAF SONS', '43.575', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:51'), (95, '1', '879994', 'Real Suites A', 'ADEL AND SALAH', '2.625', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:06'), (96, '1', '879994', 'Real Suites B', 'ADEL AND SALAH', '9', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:28'), (97, '1', '879994', 'Salmaniya Plaza', 'ADEL AND SALAH', '51.45', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:52'), (98, '1', '500320', 'Brown Tower', 'ADEL AND SALAH', '560', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:46:52'), (99, '1', '500320', 'Manama Office', 'KHALAF SONS', '32', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:12'), (100, '1', '500320', 'Panorama Center', 'KHALAF SONS', '154', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:28'), (101, '1', '500320', 'Patrex Tower', 'KHALAF SONS', '283.999', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:43'), (102, '1', '500320', 'Real Suites B', 'ADEL AND SALAH', '667', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:06'), (103, '1', '500320', 'Salmaniya Plaza', 'ADEL AND SALAH', '79.999', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:23'), (104, '1', '500320', 'Vintage', 'SALAH', '135', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:36'), (105, '1', '765857', 'Adel House', 'ADEL', '6.3', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:23:55'), (106, '1', '765857', 'Adliya Tower', 'KHALAF SONS', '3.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:24:49'), (107, '1', '765857', 'Brown Tower', 'ADEL AND SALAH', '24.7', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:06'), (108, '1', '765857', 'Capital Medical Complex', 'KHALAF SONS', '15.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:25'), (109, '1', '765857', 'Indonesian Embassy', 'KHALAF SONS', '214.1', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:40'), (110, '1', '765857', 'Lenox 1', 'KHALAF SONS', '12', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:50'), (111, '1', '765857', 'Lenox 2', 'KHALAF SONS', '16.8', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:03'), (112, '1', '765857', 'Panorama Center', 'KHALAF SONS', '25.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:15'), (113, '1', '765857', 'Patrex Tower', 'KHALAF SONS', '129.8', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:29'), (114, '1', '765857', 'Real Suites A', 'ADEL AND SALAH', '33', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:42'), (115, '1', '765857', 'Real Suites B', 'ADEL AND SALAH', '11.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:52'), (116, '1', '765857', 'Saj 1', 'KHALAF SONS', '42.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:05'), (117, '1', '765857', 'Saj 2', 'KHALAF SONS', '61.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:20'), (118, '1', '765857', 'Saj 3', 'KHALAF SONS', '64.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:35'), (119, '1', '765857', 'Salmaniya Plaza', 'ADEL AND SALAH', '19.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:53'), (120, '1', '339022', '5Villa', 'ADEL', '7', '02-11-2019', '14-11-2019', '08', '12', '2019', '15:38:28'), (121, '1', '339022', 'Adliya Tower', 'KHALAF SONS', '84.7', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:07'), (122, '1', '339022', 'Brown Tower', 'ADEL AND SALAH', '15.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:28'), (123, '1', '339022', 'Capital Medical Complex', 'KHALAF SONS', '9', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:39'), (124, '1', '339022', 'Indonesian Embassy', 'KHALAF SONS', '129.1', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:56'), (125, '1', '339022', 'Korean Embassy', 'KHALAF SONS', '50.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:13'), (126, '1', '339022', 'Lenox 1', 'KHALAF SONS', '37', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:27'), (127, '1', '339022', 'Lenox 2', 'KHALAF SONS', '39.9', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:35'), (128, '1', '339022', 'Lenox 3', 'KHALAF SONS', '2', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:43'), (129, '1', '339022', 'Panorama Center', 'KHALAF SONS', '33', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:52'), (130, '1', '339022', 'Patrex Tower', 'KHALAF SONS', '80.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:03'), (131, '1', '339022', 'Real Suites A', 'ADEL AND SALAH', '70.4', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:21'), (132, '1', '339022', 'Real Suites B', 'ADEL AND SALAH', '67.3', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:37'), (133, '1', '339022', 'Saj 1', 'KHALAF SONS', '16.6', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:53'), (134, '1', '339022', 'Saj 2', 'KHALAF SONS', '63', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:02'), (135, '1', '339022', 'Salmaniya Plaza', 'ADEL AND SALAH', '26.8', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:18'), (136, '1', '339022', 'Tubli Center', 'ADEL', '12', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:32'), (137, '1', '339022', 'Vintage', 'SALAH', '22.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:52'), (138, '1', '286587', '5Villa', 'ADEL', '17', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:53:28'), (139, '1', '286587', 'Adel House', 'ADEL', '34.7', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:21'), (140, '1', '286587', 'Brown Tower', 'ADEL AND SALAH', '113.1', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:40'), (141, '1', '286587', 'Indonesian Embassy', 'KHALAF SONS', '107.6', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:59'), (142, '1', '286587', 'Korean Embassy', 'KHALAF SONS', '3.8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:12'), (143, '1', '286587', 'Lenox 1', 'KHALAF SONS', '8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:23'), (144, '1', '286587', 'Lenox 2', 'KHALAF SONS', '24.5', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:30'), (145, '1', '286587', 'Lenox 3', 'KHALAF SONS', '17', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:40'), (146, '1', '286587', 'Panorama Center', 'KHALAF SONS', '21', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:51'), (147, '1', '286587', 'Patrex Tower', 'KHALAF SONS', '42.3', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:02'), (148, '1', '286587', 'Real Suites A', 'ADEL AND SALAH', '20.2', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:22'), (149, '1', '286587', 'Real Suites B', 'ADEL AND SALAH', '16.7', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:33'), (150, '1', '286587', 'Saj 1', 'KHALAF SONS', '19', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:52'), (151, '1', '286587', 'Saj 2', 'KHALAF SONS', '5.8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:07'), (152, '1', '286587', 'Saj 3', 'KHALAF SONS', '16', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:17'), (153, '1', '286587', 'Salmaniya Plaza', 'ADEL AND SALAH', '27.5', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:30'), (154, '1', '286587', 'Vintage', 'SALAH', '66', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:43'), (155, '1', '247998', '5Villa', 'ADEL', '6.8', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:30:07'), (156, '1', '247998', 'Adel House', 'ADEL', '98.4', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:41:35'), (157, '1', '247998', 'Brown Tower', 'ADEL AND SALAH', '44', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:42:06'), (158, '1', '247998', 'Capital Medical Complex', 'KHALAF SONS', '3.4', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:43:39'), (159, '1', '247998', 'Indonesian Embassy', 'KHALAF SONS', '12.3', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:44:19'), (160, '1', '247998', 'Korean Embassy', 'KHALAF SONS', '2', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:44:41'), (161, '1', '247998', 'Lenox 1', 'KHALAF SONS', '48.1', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:45:06'), (162, '1', '247998', 'Lenox 2', 'KHALAF SONS', '28.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:45:36'), (163, '1', '247998', 'Lenox 3', 'KHALAF SONS', '86.3', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:46:07'), (164, '1', '247998', 'Panorama Center', 'KHALAF SONS', '26.7', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:47:01'), (165, '1', '247998', 'Real Suites A', 'KHALAF SONS', '21.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:48:13'), (166, '1', '247998', 'Saj 3', 'KHALAF SONS', '3.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:50:13'), (167, '1', '247998', 'Korean Embassy', 'SALAH', '42.6', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:51:38'), (168, '1', '247998', 'Salmaniya Plaza', 'ADEL AND SALAH', '3.6', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:52:20'), (169, '1', '247998', 'Vintage', 'SALAH', '4.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:53:07'), (170, '1', '247998', 'Patrex Tower', 'KHALAF SONS', '84.2', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:59:00'), (171, '1', '247998', 'Saj 2', 'KHALAF SONS', '11.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '11:00:36'); -- -------------------------------------------------------- -- -- 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, `user_ip` 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; -- -------------------------------------------------------- -- -- Table structure for table `khalaf_admintb` -- CREATE TABLE `khalaf_admintb` ( `id` int(11) NOT NULL, `user_id_adm` varchar(255) NOT NULL, `user_cpr` 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`, `user_cpr`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '1', '434343', '', '', '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; -- -------------------------------------------------------- -- -- 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, `user_ip` 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; -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- 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, `user_cpr` 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`, `user_cpr`, `gender`, `email`, `password`, `image_url`, `curr_date`, `curr_time`) VALUES (1, 'kaketo', 'ben', '11223344', '434343', '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', '34343434', '545454', 'Female', 'dora@kvt.com', '1234', 'avatar2.jpg', '2019-02-26', '15:10:17'), (4, 'mama', 'papa', '21212121', '', 'Female', 'mama@kvt.com', '1234', 'avatar2.jpg', '2020-02-04', '11:47:19'), (5, 'sayed', 'mohamed', '36738381', '921205929', 'Male', 'sayed@kvt.com', '1223', 'avatar2.jpg', '2020-02-04', '12:40:29'), (6, 'sayed', 'mohamed', '36738381', '', 'Male', 'sayed@kvt.wn', '1223', 'avatar2.jpg', '2020-02-08', '09:46:05'); -- -------------------------------------------------------- -- -- Table structure for table `lang_transtb` -- CREATE TABLE `lang_transtb` ( `id` int(11) NOT NULL, `english` varchar(255) NOT NULL, `arabic` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `lang_transtb` -- INSERT INTO `lang_transtb` (`id`, `english`, `arabic`) VALUES (1, 'shop name', 'اسم المحل'), (2, 'Money', 'مال'), (3, 'percentge ', 'النسبة المئوية'), (4, 'expenses', 'المصروفات'), (5, 'Salman Fardan', 'سلمان الفردان'), (6, 'Javed Air Conditioners', 'مكيفات جاويد'), (7, 'print', 'طباعة'), (8, 'details', 'تفاصيل'), (9, 'property', 'خاصية'), (10, 'careers', 'وظائف'), (11, 'our agents', 'وكلائنا'), (12, 'about', 'حول'), (13, 'extraction ', 'استخلاص'), (14, 'exit', 'الخروج'), (15, 'property name ', 'اسم الخاصية'), (16, 'date', 'تاريخ'), (17, 'Lenox 1', 'لينوكس 1\r\n'), (18, 'Indonesian Embassy', 'السفارة الاندونيسية\r\n'), (19, 'Saj 1', 'صاج 1'), (20, 'Brown Tower', 'برج براون'), (21, 'Capital Medical Complex', 'مجمع العاصمة الطبي'), (22, 'Patrex Tower', 'برج باتريكس'), (23, 'Salmaniya Plaza', 'السلمانية بلازا'), (24, 'Tubli Center', 'مركز توبلي'), (25, 'Panorama Center', 'مركز بانوراما'), (26, 'Saj 2', 'صاج 2'), (27, 'Saj 3', 'صاج 3'), (28, 'Lenox 2', 'لينوكس 2'), (29, 'Salah House', 'بيت صلاح'); -- -------------------------------------------------------- -- -- Table structure for table `mainttb` -- CREATE TABLE `mainttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `employee_cpr` varchar(255) NOT NULL, `permission_status` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` 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=utf8mb4; -- -- Dumping data for table `mainttb` -- INSERT INTO `mainttb` (`id`, `my_id`, `employee_cpr`, `permission_status`, `country`, `city`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', '434343', 'Full Permission', '', '', '29', '01', '2020', '15:33:32'), (2, '1', '921205929', 'Read only', 'Bahrain', 'Manama', '04', '02', '2020', '12:47:39'); -- -------------------------------------------------------- -- -- 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, '1', 'Real Suites A', 'Mahooz', 'Residential', '1036', '3321', 'Jehad', '32213149', '218762400.JPG', '2019-02-14', '12:05:27'), (2, '1', 'Real Suites B', 'Un Al Hassam', 'Residential', '1038', '3321', 'Jihad', '+97333213149', '1218736699.JPG', '2019-11-23', '12:51:43'), (3, '1', 'Lenox 1', 'Segeya', 'Residential', '1627', '3241', 'Jamil', '17822550', '79621283.JPG', '2019-05-04', '17:38:16'), (4, '1', 'Lenox 2', 'Segeya', 'Residential', '1625', '3241', 'Jamil', '17822550', '194364817.JPG', '2019-05-05', '11:22:20'), (5, '1', 'Lenox 3', 'Bu Ashira', 'Residential', '19', '3201', 'Kumar', '+97339142917', '2094162997.JPG', '2019-11-23', '12:57:29'), (6, '1', 'Saj 1', 'Un Al Hassam', 'Residential', '924', '3318', 'Sayed Hassan', '+97339600062', '999876390.JPG', '2019-11-23', '12:29:40'), (7, '1', 'Saj 2', 'Mahooz', 'Residential', '922', '3318', 'Hassan S', '17822550', '1773446624.JPG', '2019-07-06', '11:16:40'), (8, '1', 'Saj 3', 'Manama', 'Residential', '743', '515', 'Kumar', '391429709', '65906118.JPG', '2019-11-23', '12:45:33'), (9, '1', 'Adliya Tower', 'Adliya', 'Residential', '2000', '3321', 'Jehad', '32213149', '1581047250.JPG', '2019-02-16', '14:58:28'), (10, '1', 'Patrex Tower', 'patrex', 'Residential', '111', '222', 'Hamad', '32213149', '1286671067.JPG', '2019-02-18', '11:16:06'), (11, '1', 'Panorama Center', 'Exhibition Road', 'Residential', '189', '18', 'Jamil', '+97339616064', '1550418107.JPG', '2019-11-23', '13:03:32'), (12, '1', 'Salmaniya Plaza', 'Salmaniya', 'Residential', '234', '2903', 'Jamil', '+97339616064', '1455400190.JPG', '2019-11-23', '13:11:59'), (13, '1', 'Adel House', 'Bu Ashira', 'Residential', '18', '3241', 'Jamil', '391429709', '1410182882.JPG', '2019-11-28', '16:07:22'), (14, '1', 'Brown Tower', 'Juffair', 'Residential', '767', '2412', 'Aziz', '33729709', '1045443179.jpeg', '2019-11-28', '16:22:34'), (15, '1', 'Capital Medical Complex', 'Zinji', 'Medical Shop', '71', '3201', 'Jamil', '+97339616064', '308882575.jpg', '2019-12-01', '14:49:40'), (16, '1', 'Korean Embassy', 'Manama', 'Villa', '401', '915', 'Jamil', '+97339616064', '292070803.jpg', '2019-12-01', '14:56:39'), (17, '1', 'Indonesian Embassy', 'Manama', 'Villa', '2113', '2432', 'Jamil', '+97339616064', '922918280.JPEG', '2019-12-01', '14:58:15'), (18, '1', 'Vintage', 'Bu Ashira', 'Residential', '747', '3214', 'Jamil', '+97339616064', '557643344.JPEG', '2019-12-01', '15:04:47'), (19, '1', '5Villa', 'Bu Ashira', 'Residential', '1255', '3227', 'Jamil', '+97339616064', '920052564.jpeg', '2019-12-01', '15:11:52'), (20, '1', 'Salah House', 'Bu Ashira', 'Residential', '747', '3214', 'SALAH', '17822550', '1290914002.jpeg', '2019-12-02', '12:39:22'), (21, '1', 'Tubli Center', 'Tubli', 'Shop', '1288', '1325', 'Qasim', '33346212', '1435905923.jpeg', '2019-12-02', '13:00:05'), (22, '1', 'Manama Office', 'Bu Ashira', 'Office', '19', '3201', 'Jamil', '+97339616064', '1715816998.jpg', '2019-12-08', '12:34:20'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- Table structure for table `projecttb` -- CREATE TABLE `projecttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `description` text NOT NULL, `file_url` varchar(255) NOT NULL, `file_type` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `projecttb` -- INSERT INTO `projecttb` (`id`, `my_id`, `description`, `file_url`, `file_type`, `curr_day`, `curr_month`, `curr_year`, `time`) VALUES (1, '1', 'Brown Tower Pump room construction By Arazii Company', '2016567356', '.mp4', '26', '10', '2019', '13:04:49'), (2, '1', 'Brown Tower Pumproom constraction', '107276055', '.jpeg', '26', '10', '2019', '14:48:18'), (3, '1', 'Brown Tower Pump room construction By Arazii Company', '432598856', '.jpeg', '27', '10', '2019', '14:36:20'), (4, '1', '', '1284545662', '.jpeg', '27', '10', '2019', '14:37:22'), (5, '1', '', '538572176', '.jpeg', '27', '10', '2019', '14:38:24'), (6, '1', 'Brown Tower Pump room construction By Arazii Company', '798208515', '.mp4', '27', '10', '2019', '14:39:35'), (7, '1', '', '165816346', '.jpeg', '27', '10', '2019', '14:54:30'), (9, '1', 'Brown Tower Pump room construction By Arazii Company', '1820273032', '.mp4', '27', '10', '2019', '15:03:48'), (10, '1', 'Brown Tower Pump room construction By Arazii Company', '105159777', '.jpeg', '27', '10', '2019', '15:12:23'), (11, '1', '', '1850480707', '.jpeg', '27', '10', '2019', '15:14:19'); -- -------------------------------------------------------- -- -- 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'), (4, '1', '2', '2023187209.JPG', '2020-01-05', '12:04:41'), (5, '1', '2', '2018866092.JPG', '2020-01-05', '12:04:50'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- Table structure for table `shoptb` -- CREATE TABLE `shoptb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `shoptb` -- INSERT INTO `shoptb` (`id`, `my_id`, `shop_name`, `curr_day`, `curr_month`, `curr_year`, `time`) VALUES (1, '1', 'Salman Fardan', '25', '11', '2019', '14:49:00'), (2, '1', 'Javed Air Conditioners', '25', '11', '2019', '14:58:52'), (3, '1', 'Al Salam Gas', '25', '11', '2019', '15:07:40'); -- -- 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 `complainttb` -- ALTER TABLE `complainttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `complaint_datingtb` -- ALTER TABLE `complaint_datingtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expendituretb` -- ALTER TABLE `expendituretb` 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 `lang_transtb` -- ALTER TABLE `lang_transtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mainttb` -- ALTER TABLE `mainttb` 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 `projecttb` -- ALTER TABLE `projecttb` 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`); -- -- Indexes for table `shoptb` -- ALTER TABLE `shoptb` 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=32; -- -- AUTO_INCREMENT for table `agent_calltb` -- ALTER TABLE `agent_calltb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `agent_viewtb` -- ALTER TABLE `agent_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `bd_locationtb` -- ALTER TABLE `bd_locationtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- 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 `complainttb` -- ALTER TABLE `complainttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `complaint_datingtb` -- ALTER TABLE `complaint_datingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `expendituretb` -- ALTER TABLE `expendituretb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `graph_calendartb` -- ALTER TABLE `graph_calendartb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `graph_datatb` -- ALTER TABLE `graph_datatb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=172; -- -- AUTO_INCREMENT for table `jobstb` -- ALTER TABLE `jobstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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 for table `khalaf_cvtb` -- ALTER TABLE `khalaf_cvtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `khalaf_messagetb` -- ALTER TABLE `khalaf_messagetb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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=7; -- -- AUTO_INCREMENT for table `lang_transtb` -- ALTER TABLE `lang_transtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `mainttb` -- ALTER TABLE `mainttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `main_buildingtb` -- ALTER TABLE `main_buildingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `new_ordertb` -- ALTER TABLE `new_ordertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `projecttb` -- ALTER TABLE `projecttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `property_albumtb` -- ALTER TABLE `property_albumtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `purchased_producttb` -- ALTER TABLE `purchased_producttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shoptb` -- ALTER TABLE `shoptb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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 */;