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

START TRANSACTION;



--
-- Database: `classify_db`
--

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

--
-- Table structure for table `ci_admin`
--

CREATE TABLE IF NOT EXISTS `ci_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_role_id` int(11) NOT NULL,
  `username` varchar(100) CHARACTER SET utf8 NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile_no` varchar(255) NOT NULL,
  `image` varchar(300) NOT NULL,
  `password` varchar(255) NOT NULL,
  `last_login` datetime NOT NULL,
  `is_verify` tinyint(4) NOT NULL DEFAULT '1',
  `is_admin` tinyint(4) NOT NULL DEFAULT '1',
  `is_active` tinyint(4) NOT NULL DEFAULT '0',
  `is_supper` tinyint(4) NOT NULL DEFAULT '0',
  `token` varchar(255) NOT NULL,
  `password_reset_code` varchar(255) NOT NULL,
  `last_ip` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_admin`
--

INSERT INTO `ci_admin` (`admin_id`, `admin_role_id`, `username`, `firstname`, `lastname`, `email`, `mobile_no`, `image`, `password`, `last_login`, `is_verify`, `is_admin`, `is_active`, `is_supper`, `token`, `password_reset_code`, `last_ip`, `created_at`, `updated_at`) VALUES
(27, 5, 'schoo43543', 'rewr', 'erew', 'erew@dfsfs', 'ewre43543', '', '0a7eab610f12cb73aa0a4aa7c0acf691', '2019-01-02 00:00:00', 1, 1, 0, 0, '', '', '', '2018-03-18 00:00:00', '2019-01-16 23:33:26'),
(31, 1, 'superadmin', 'Nauman', 'Ahmed', 'naumanahmedcs@gmail.com', '123456', '', '$2y$10$9q/f5C6rEq/OESFPUWY49uTeekXC.0/eogpt41O7Tbt/QNhIw.o.i', '0000-00-00 00:00:00', 1, 1, 1, 1, '', '', '', '2019-01-16 06:01:58', '2019-07-16 09:07:37'),
(35, 2, 'techogrip', 'Gabriel', 'Khan', 'iricjohn@gmail.com', '3214519', '', '$2y$10$iFdPKAurNHRILiTo0Vl7EutoCrJ2qaKuyXf00BfQjwWBQ7FoXMI6u', '0000-00-00 00:00:00', 1, 1, 1, 0, '', '', '', '2020-01-03 00:00:00', '2020-01-03 00:00:00'),
(36, 2, 'techno', 'Tech', 'Admin', 'officialarea423@gmail.com', '03002320332', '', '$2y$10$Hf9CyTFd0HXUNtn00GpRbe4m9UHjl/ex9qJGq4fTBpCBW48eVJAqq', '0000-00-00 00:00:00', 1, 1, 1, 0, '', '', '', '2020-06-09 00:00:00', '2020-06-09 00:00:00'),
(37, 2, 'nauman', 'nauman', 'ahmed', 'naumanadmin@gmail.com', '03469548054', '', '$2y$10$42we8/4Ayg34IqMgosQp4.PtdzkvFcgiXAxjp2QRbRKjYYPrgSoN6', '0000-00-00 00:00:00', 1, 1, 1, 0, '', '', '', '2020-06-12 11:06:21', '2020-06-12 11:06:21');

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

--
-- Table structure for table `ci_admin_roles`
--

CREATE TABLE IF NOT EXISTS `ci_admin_roles` (
  `admin_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_role_title` varchar(30) CHARACTER SET utf8 NOT NULL,
  `admin_role_status` int(11) NOT NULL,
  `admin_role_created_by` int(1) NOT NULL,
  `admin_role_created_on` datetime NOT NULL,
  `admin_role_modified_by` int(11) NOT NULL,
  `admin_role_modified_on` datetime NOT NULL,
  PRIMARY KEY (`admin_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_admin_roles`
--

INSERT INTO `ci_admin_roles` (`admin_role_id`, `admin_role_title`, `admin_role_status`, `admin_role_created_by`, `admin_role_created_on`, `admin_role_modified_by`, `admin_role_modified_on`) VALUES
(1, 'Super Admin', 1, 0, '2018-03-15 12:48:04', 0, '2018-03-17 12:53:16'),
(2, 'Admin', 1, 0, '2018-03-15 12:53:19', 0, '2019-01-26 08:27:34'),
(3, 'Accountant', 1, 0, '2018-03-15 01:46:54', 0, '2019-01-26 02:17:38'),
(4, 'Operator', 1, 0, '2018-03-16 05:52:45', 0, '2019-01-26 02:17:52');

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

--
-- Table structure for table `ci_ads`
--

CREATE TABLE IF NOT EXISTS `ci_ads` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `seller` int(11) NOT NULL,
  `package` int(11) NOT NULL,
  `buyer_package_id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `category` int(11) NOT NULL,
  `subcategory` int(11) DEFAULT NULL,
  `description` longtext NOT NULL,
  `price` double NOT NULL,
  `total_price` double NOT NULL,
  `pricing_option` tinyint(4) NOT NULL,
  `no_of_items` int(11) NOT NULL,
  `item_condition` tinyint(4) NOT NULL,
  `urgent` tinyint(4) NOT NULL,
  `location` varchar(255) NOT NULL,
  `lang` double DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `suburb` varchar(255) NOT NULL,
  `city` varchar(60) NOT NULL,
  `state` int(11) NOT NULL,
  `country` varchar(60) NOT NULL,
  `postcode` varchar(15) NOT NULL,
  `tags` varchar(225) DEFAULT NULL,
  `img_1` varchar(225) DEFAULT 'assets/img/default-img.jpg',
  `img_2` varchar(225) DEFAULT NULL,
  `img_3` varchar(225) DEFAULT NULL,
  `admin_view` int(11) NOT NULL DEFAULT '0',
  `is_featured` int(1) NOT NULL DEFAULT '0',
  `featured_status` varchar(50) NOT NULL,
  `featured_expiry_date` date DEFAULT NULL,
  `is_status` int(11) NOT NULL DEFAULT '1',
  `delete_request` int(11) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_ads`
--

INSERT INTO `ci_ads` (`id`, `seller`, `package`, `buyer_package_id`, `title`, `slug`, `category`, `subcategory`, `description`, `price`, `total_price`, `pricing_option`, `no_of_items`, `item_condition`, `urgent`, `location`, `lang`, `lat`, `address1`, `address2`, `suburb`, `city`, `state`, `country`, `postcode`, `tags`, `img_1`, `img_2`, `img_3`, `admin_view`, `is_featured`, `featured_status`, `featured_expiry_date`, `is_status`, `delete_request`, `updated_date`, `created_date`) VALUES
(21, 3, 8, 0, 'Summer Lawn Suite', 'summer-lawn-suite-21', 100, 97, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 50, 50, 1, 1, 2, 1, 'Islamabad Capital Territory, Pakistan', 73.0405277, 33.7204997, 'Islamabad Capital Territory, Pakistan', '', 'Sheikh Zayed Hospital Khayaban-e-Jamia Punjab, Blo', '', 0, '', '', 'lawn, suite', 'uploads/media_file_b52c193288aa21ad2778495be2225af8.jpg', NULL, NULL, 0, 0, '', NULL, 1, NULL, NULL, '2021-04-13 16:20:34'),
(22, 3, 8, 0, 'Girls Makeup', 'girls-makeup-22', 100, 97, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 100, 100, 1, 1, 2, 0, 'Model Town, Lahore, Pakistan', 74.3239342, 31.4804642, 'Model Town, Lahore, Pakistan', '', 'Lahore', '', 0, '', '', 'makeup, kit, girls', 'uploads/media_file_69b0314020fd7ed867cf88aca8c09721.jpg', NULL, NULL, 0, 1, '', '2021-05-13', 1, NULL, NULL, '2021-04-13 16:28:38'),
(24, 3, 5, 0, 'Samsung Glaxy S11', 'samsung-glaxy-s11-24', 103, 87, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 999, 999, 1, 1, 2, 1, 'Embassy Suites by Hilton Portland Maine, Westbrook Street, Portland, ME, USA', -70.3105697, 43.6508865, 'Embassy Suites by Hilton Portland Maine, Westbrook Street, Portland, ME, USA', '', 'Portland', '', 0, '', '04102', 'mobile, samsung', 'uploads/media_file_8b2a1be2f4eb902f0619aea0b43442f3.jpg', NULL, NULL, 0, 0, '', NULL, 1, NULL, NULL, '2021-04-15 14:43:59'),
(25, 3, 5, 0, 'Home Double Bed', 'home-double-bed-25', 109, 87, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 800, 800, 1, 1, 2, 1, 'Suite Parking Lot, E Parmer Ln, Round Rock, TX, USA', -97.63044719999999, 30.5264085, 'Suite Parking Lot, E Parmer Ln, Round Rock, TX, USA', '', 'Round Rock', '', 0, '', '78665', 'bed, double bed, living bed', 'uploads/media_file_7fd3d441b629f760ebc87f7739c4596c.jpg', NULL, NULL, 0, 1, '', '2021-04-22', 1, NULL, NULL, '2021-04-15 14:53:05'),
(26, 3, 5, 0, 'German Shepherd', 'german-shepherd-26', 108, 87, 'some text here some teIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 2000, 10000, 1, 5, 1, 1, 'Candaba, Pampanga, Philippines', 120.8728615, 15.1040545, 'Candaba, Pampanga, Philippines', '', 'Candaba', '', 0, '', '', 'dogs, german dogs', 'uploads/media_file_93331b81b72428c0bc164fa078eedff5.jpg', NULL, NULL, 0, 1, '', '2021-04-22', 1, NULL, NULL, '2021-04-15 14:54:09'),
(49, 3, 7, 0, 'Test Paypal', 'test-paypal-49', 97, 87, 'some thxt ehreasfa adfadsfdsfdsf', 100, 500, 1, 5, 1, 1, 'Suite Drive, Huntington Beach, California, USA', 0, 0, '', '', 'Huntington Beach', '', 0, '', '92649', 'test, test', 'uploads/media_file_1a45d1b7b28b26ac45c3fdb039d29b20.jpg', NULL, NULL, 0, 0, '', NULL, 3, NULL, NULL, '2021-06-11 18:02:45'),
(47, 3, 7, 0, 'Test Ad', 'test-ad-47', 97, 87, 'some text here some text herre', 100, 100, 1, 1, 1, 1, 'Suite Drive, Huntington Beach, California, USA', 0, 0, '', '', 'Huntington Beach', '', 0, '', '92649', 'test', 'uploads/media_file_eca00dd4362f7a8183ba5e395eac3583.jpg', NULL, NULL, 0, 0, '', NULL, 3, NULL, NULL, '2021-06-11 17:39:43'),
(48, 3, 8, 0, 'Test Ads', 'test-ads-48', 97, 87, 'some thext here some thext here', 100, 100, 1, 1, 1, 1, 'Suite Drive, Huntington Beach, California, USA', 0, 0, '', '', 'Huntington Beach', '', 0, '', '92649', 'test', 'uploads/media_file_325cabe8acc2b89863431a2c586d8911.jpg', NULL, NULL, 0, 0, '', NULL, 1, NULL, NULL, '2021-06-11 17:43:28'),
(46, 3, 7, 0, 'Range Rover', 'range-rover-46', 97, 88, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', 50000000, 50000000, 1, 1, 1, 0, 'Austin Hospital, Studley Road, Heidelberg VIC, Australia', 145.0585666, -37.7561889, 'Austin Hospital, Studley Road, Heidelberg VIC, Australia', '', 'Heidelberg', '', 0, '', '3084', '', 'uploads/media_file_c37b2932b1f20572754d5a6bbdf6c1cf.jpg', NULL, NULL, 0, 1, '', '2021-05-17', 1, NULL, NULL, '2021-04-27 00:08:16');

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

--
-- Table structure for table `ci_ad_detail`
--

CREATE TABLE IF NOT EXISTS `ci_ad_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `field_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_ad_detail`
--

INSERT INTO `ci_ad_detail` (`id`, `ad_id`, `field_id`, `field_value`) VALUES
(11, 6, 50, 'Harvest'),
(12, 6, 49, '401'),
(21, 8, 50, 'Harvest'),
(22, 8, 49, '402'),
(23, 8, 52, '401'),
(36, 11, 49, '201'),
(37, 11, 50, 'Harvest'),
(38, 11, 52, '301'),
(42, 9, 50, 'Harvest'),
(43, 9, 49, '401'),
(44, 9, 52, '101'),
(45, 10, 50, 'Harvest'),
(46, 10, 49, '45'),
(47, 10, 52, 'HR 45 R1 (85 Series)'),
(48, 12, 49, '401'),
(49, 12, 50, 'Harvest'),
(50, 12, 52, '202'),
(51, 24, 49, '101'),
(52, 24, 50, 'Harvest'),
(53, 24, 52, '401'),
(54, 25, 49, '101'),
(55, 25, 50, 'Harvest'),
(56, 25, 52, '401'),
(57, 26, 49, '101'),
(58, 26, 50, 'Harvest'),
(59, 26, 52, '401'),
(60, 7, 50, 'Harvest'),
(61, 7, 49, '402'),
(62, 7, 52, '401'),
(63, 39, 49, '401'),
(64, 39, 50, 'Harvest'),
(65, 39, 52, '201'),
(66, 42, 50, 'Harvest'),
(67, 42, 49, '101'),
(68, 42, 52, '101'),
(69, 43, 50, 'Harvest'),
(70, 43, 49, '101'),
(71, 43, 52, '101'),
(72, 44, 50, 'Harvest'),
(73, 44, 49, '101'),
(74, 44, 52, '101'),
(75, 45, 50, 'Harvest'),
(76, 45, 49, '101'),
(77, 45, 52, '101'),
(78, 47, 53, '40'),
(79, 47, 54, '50'),
(80, 48, 53, '50'),
(81, 48, 54, '500'),
(82, 49, 53, '50'),
(83, 49, 54, '1000');

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

--
-- Table structure for table `ci_ad_favorite`
--

CREATE TABLE IF NOT EXISTS `ci_ad_favorite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_ad_favorite`
--

INSERT INTO `ci_ad_favorite` (`id`, `ad_id`, `user_id`, `created_date`) VALUES
(1, 2, 1, '2021-03-11 13:21:11'),
(2, 11, 3, '2021-04-14 19:58:49');

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

--
-- Table structure for table `ci_ad_rating`
--

CREATE TABLE IF NOT EXISTS `ci_ad_rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_ad_rating`
--

INSERT INTO `ci_ad_rating` (`id`, `ad_id`, `user_id`, `rating`, `updated_date`) VALUES
(1, 9, 3, 5, '2021-03-30 21:00:28'),
(2, 46, 3, 4, '2021-05-04 19:24:39');

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

--
-- Table structure for table `ci_blog_categories`
--

CREATE TABLE IF NOT EXISTS `ci_blog_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_id` int(11) DEFAULT '1',
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `category_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ci_blog_comments`
--

CREATE TABLE IF NOT EXISTS `ci_blog_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `comment` varchar(5000) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ci_blog_posts`
--

CREATE TABLE IF NOT EXISTS `ci_blog_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_id` int(11) DEFAULT '1',
  `title` varchar(500) DEFAULT NULL,
  `slug` varchar(500) DEFAULT NULL,
  `summary` varchar(1000) DEFAULT NULL,
  `content` longtext,
  `keywords` varchar(500) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `image_default` varchar(255) DEFAULT NULL,
  `image_small` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_blog_posts`
--

INSERT INTO `ci_blog_posts` (`id`, `lang_id`, `title`, `slug`, `summary`, `content`, `keywords`, `category_id`, `image_default`, `image_small`, `user_id`, `created_at`) VALUES
(7, 1, 'Creative Design Solution', 'creative-design-solution', NULL, '<p>\r\n\r\n<strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum\r\n\r\n<br></p>', 'about, aboutus, about us', 5, 'uploads/blog/media_file_b696974e2a70fe1385de340a70fb1132.jpg', NULL, 1, '2020-05-21 07:05:01');

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

--
-- Table structure for table `ci_blog_tags`
--

CREATE TABLE IF NOT EXISTS `ci_blog_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `tag_slug` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_blog_tags`
--

INSERT INTO `ci_blog_tags` (`id`, `post_id`, `tag`, `tag_slug`) VALUES
(31, 7, 'gift', 'gift'),
(32, 7, ' happy', 'happy'),
(33, 7, ' birthday', 'birthday');

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

--
-- Table structure for table `ci_categories`
--

CREATE TABLE IF NOT EXISTS `ci_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `picture` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `top_category` tinyint(4) NOT NULL DEFAULT '0',
  `show_on_home` int(11) DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_categories`
--

INSERT INTO `ci_categories` (`id`, `name`, `slug`, `description`, `picture`, `status`, `top_category`, `show_on_home`, `created_at`) VALUES
(97, 'Cars', 'cars', '', 'uploads/category/media_file_dcd3539aa1ef307497078a66f4ff4897.png', 1, 0, 1, '2021-03-04 13:28:45'),
(99, 'Sport', 'sport', 'Sport', 'uploads/category/media_file_632275eec4b952c0dd0bf385aac9614d.png', 1, 0, 1, '2021-04-13 14:45:37'),
(100, 'Fashion & Beauty', 'fashion-beauty', '', 'uploads/category/media_file_493042501559865df7f284b02ebb1e5d.png', 1, 0, 1, '2021-04-29 14:46:29'),
(101, 'Jobs', 'jobs', '', 'uploads/category/media_file_ebc078a44b3170b455620094845f3b01.png', 1, 0, 1, '2021-04-29 14:47:08'),
(102, 'Electronics & Home Appliances', 'electronics-home-appliances', '', 'uploads/category/media_file_cb6ce6419d13145282bffd32050f6830.png', 1, 0, 1, '2021-04-29 14:47:46'),
(103, 'Mobiles', 'mobiles', '', 'uploads/category/media_file_a3191a18432b070ce43972f1e3bb0ebe.png', 1, 0, 1, '2021-04-29 14:48:16'),
(104, 'Bikes', 'bikes', '', 'uploads/category/media_file_82dcb3ffc6eb3fd85dafb42a4aabbf54.png', 1, 0, 1, '2021-04-29 14:48:45'),
(105, 'Property', 'property', '', 'uploads/category/media_file_c4a2c12ac8653dcc0d14c759f16a70e2.png', 1, 0, 1, '2021-04-29 14:49:37'),
(106, 'Services', 'services', '', 'uploads/category/media_file_f71572e162ae4f97c786873f72c80c7f.png', 1, 0, 1, '2021-04-29 14:50:16'),
(107, 'Kids', 'kids', '', 'uploads/category/media_file_a29f203a73e41198777cdf8e8da83357.png', 1, 0, 1, '2021-04-29 14:50:52'),
(108, 'Pets', 'pets', '', 'uploads/category/media_file_465b922c288db1b5d8a24a369ff0396c.png', 1, 0, 1, '2021-04-29 14:51:32'),
(109, 'Furniture & Home Decore', 'furniture-home-decore', '', 'uploads/category/media_file_5d2800baeb78a332f4a249878a4ac723.png', 1, 0, 1, '2021-04-29 15:21:34');

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

--
-- Table structure for table `ci_cities`
--

CREATE TABLE IF NOT EXISTS `ci_cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `state_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_cities`
--

INSERT INTO `ci_cities` (`id`, `name`, `slug`, `state_id`) VALUES
(3, 'Lahore', 'lahore', 6),
(4, 'Gujrat', 'gujrat', 6),
(5, 'Faisalabad', 'faisalabad', 6),
(6, 'Karachi', 'karachi', 7),
(7, 'Hydrabad', 'hydrabad', 7),
(8, 'Pashawar', 'pashawar', 8),
(9, 'Uper Dir', 'uper-dir', 8),
(10, 'Balochistan', 'balochistan', 9);

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

--
-- Table structure for table `ci_contact_us`
--

CREATE TABLE IF NOT EXISTS `ci_contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(220) NOT NULL,
  `email` varchar(220) NOT NULL,
  `subject` varchar(220) NOT NULL,
  `message` text NOT NULL,
  `admin_view` int(11) NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_contact_us`
--

INSERT INTO `ci_contact_us` (`id`, `username`, `email`, `subject`, `message`, `admin_view`, `created_date`, `updated_date`) VALUES
(1, 'Hurairah Demo', 'abuhurairah108108@gmail.com', 'demo demo demo', 'demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo demo', 1, '2019-11-08 00:00:00', '2019-11-08 00:00:00'),
(2, 'Zain', 'jobstuff423@gmail.com', 'Testing email', 'this is again testing process', 1, '2019-12-13 08:12:00', '2019-12-13 08:12:00'),
(3, 'abdullah', 'officialarea423@gmail.com', 'Complete Your Profile', 'asdfasdfasdfa terms_n_conditionsterms_n_conditionsterms_n_conditions', 1, '2020-03-16 00:00:00', '2020-03-16 00:00:00'),
(4, 'naumanit', 'naumanahmedit@gmail.com', 'wwe', 'test test', 0, '2021-06-21 02:06:12', '2021-06-21 02:06:12');

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

--
-- Table structure for table `ci_countries`
--

CREATE TABLE IF NOT EXISTS `ci_countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sortname` varchar(3) NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `phonecode` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_countries`
--

INSERT INTO `ci_countries` (`id`, `sortname`, `name`, `slug`, `phonecode`, `status`) VALUES
(6, '', 'Pakistan', 'pakistan', 0, 1);

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

--
-- Table structure for table `ci_currency`
--

CREATE TABLE IF NOT EXISTS `ci_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `symbol` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=226 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_currency`
--

INSERT INTO `ci_currency` (`id`, `name`, `code`, `symbol`) VALUES
(114, 'Dollars', 'USD', '$'),
(115, 'Afghanis', 'AFN', '؋'),
(116, 'Pesos', 'ARS', '$'),
(117, 'Guilders', 'AWG', 'ƒ'),
(118, 'Dollars', 'AUD', '$'),
(119, 'New Manats', 'AZN', 'ман'),
(120, 'Dollars', 'BSD', '$'),
(121, 'Dollars', 'BBD', '$'),
(122, 'Rubles', 'BYR', 'p.'),
(123, 'Euro', 'EUR', '€'),
(124, 'Dollars', 'BZD', 'BZ$'),
(125, 'Dollars', 'BMD', '$'),
(126, 'Bolivianos', 'BOB', '$b'),
(127, 'Convertible Marka', 'BAM', 'KM'),
(128, 'Pula', 'BWP', 'P'),
(129, 'Leva', 'BGN', 'лв'),
(130, 'Reais', 'BRL', 'R$'),
(131, 'Pounds', 'GBP', '£'),
(132, 'Dollars', 'BND', '$'),
(133, 'Riels', 'KHR', '៛'),
(134, 'Dollars', 'CAD', '$'),
(135, 'Dollars', 'KYD', '$'),
(136, 'Pesos', 'CLP', '$'),
(137, 'Yuan Renminbi', 'CNY', '¥'),
(138, 'Pesos', 'COP', '$'),
(139, 'Colón', 'CRC', '₡'),
(140, 'Kuna', 'HRK', 'kn'),
(141, 'Pesos', 'CUP', '₱'),
(142, 'Koruny', 'CZK', 'Kč'),
(143, 'Kroner', 'DKK', 'kr'),
(144, 'Pesos', 'DOP ', 'RD$'),
(145, 'Dollars', 'XCD', '$'),
(146, 'Pounds', 'EGP', '£'),
(147, 'Colones', 'SVC', '$'),
(148, 'Pounds', 'FKP', '£'),
(149, 'Dollars', 'FJD', '$'),
(150, 'Cedis', 'GHC', '¢'),
(151, 'Pounds', 'GIP', '£'),
(152, 'Quetzales', 'GTQ', 'Q'),
(153, 'Pounds', 'GGP', '£'),
(154, 'Dollars', 'GYD', '$'),
(155, 'Lempiras', 'HNL', 'L'),
(156, 'Dollars', 'HKD', '$'),
(157, 'Forint', 'HUF', 'Ft'),
(158, 'Kronur', 'ISK', 'kr'),
(159, 'Rupees', 'INR', 'Rp'),
(160, 'Rupiahs', 'IDR', 'Rp'),
(161, 'Rials', 'IRR', '﷼'),
(162, 'Pounds', 'IMP', '£'),
(163, 'New Shekels', 'ILS', '₪'),
(164, 'Dollars', 'JMD', 'J$'),
(165, 'Yen', 'JPY', '¥'),
(166, 'Pounds', 'JEP', '£'),
(167, 'Tenge', 'KZT', 'лв'),
(168, 'Won', 'KPW', '₩'),
(169, 'Won', 'KRW', '₩'),
(170, 'Soms', 'KGS', 'лв'),
(171, 'Kips', 'LAK', '₭'),
(172, 'Lati', 'LVL', 'Ls'),
(173, 'Pounds', 'LBP', '£'),
(174, 'Dollars', 'LRD', '$'),
(175, 'Switzerland Francs', 'CHF', 'CHF'),
(176, 'Litai', 'LTL', 'Lt'),
(177, 'Denars', 'MKD', 'ден'),
(178, 'Ringgits', 'MYR', 'RM'),
(179, 'Rupees', 'MUR', '₨'),
(180, 'Pesos', 'MXN', '$'),
(181, 'Tugriks', 'MNT', '₮'),
(182, 'Meticais', 'MZN', 'MT'),
(183, 'Dollars', 'NAD', '$'),
(184, 'Rupees', 'NPR', '₨'),
(185, 'Guilders', 'ANG', 'ƒ'),
(186, 'Dollars', 'NZD', '$'),
(187, 'Cordobas', 'NIO', 'C$'),
(188, 'Nairas', 'NGN', '₦'),
(189, 'Krone', 'NOK', 'kr'),
(190, 'Rials', 'OMR', '﷼'),
(191, 'Rupees', 'PKR', '₨'),
(192, 'Balboa', 'PAB', 'B/.'),
(193, 'Guarani', 'PYG', 'Gs'),
(194, 'Nuevos Soles', 'PEN', 'S/.'),
(195, 'Pesos', 'PHP', 'Php'),
(196, 'Zlotych', 'PLN', 'zł'),
(197, 'Rials', 'QAR', '﷼'),
(198, 'New Lei', 'RON', 'lei'),
(199, 'Rubles', 'RUB', 'руб'),
(200, 'Pounds', 'SHP', '£'),
(201, 'Riyals', 'SAR', '﷼'),
(202, 'Dinars', 'RSD', 'Дин.'),
(203, 'Rupees', 'SCR', '₨'),
(204, 'Dollars', 'SGD', '$'),
(205, 'Dollars', 'SBD', '$'),
(206, 'Shillings', 'SOS', 'S'),
(207, 'Rand', 'ZAR', 'R'),
(208, 'Rupees', 'LKR', '₨'),
(209, 'Kronor', 'SEK', 'kr'),
(210, 'Dollars', 'SRD', '$'),
(211, 'Pounds', 'SYP', '£'),
(212, 'New Dollars', 'TWD', 'NT$'),
(213, 'Baht', 'THB', '฿'),
(214, 'Dollars', 'TTD', 'TT$'),
(215, 'Lira', 'TRY', 'TL'),
(216, 'Liras', 'TRL', '£'),
(217, 'Dollars', 'TVD', '$'),
(218, 'Hryvnia', 'UAH', '₴'),
(219, 'Pesos', 'UYU', '$U'),
(220, 'Sums', 'UZS', 'лв'),
(221, 'Bolivares Fuertes', 'VEF', 'Bs'),
(222, 'Dong', 'VND', '₫'),
(223, 'Rials', 'YER', '﷼'),
(224, 'Zimbabwe Dollars', 'ZWD', 'Z$'),
(225, 'New Ciuurc', 'NCY', '@&323');

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

--
-- Table structure for table `ci_email_templates`
--

CREATE TABLE IF NOT EXISTS `ci_email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(220) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `last_update` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_email_templates`
--

INSERT INTO `ci_email_templates` (`id`, `name`, `slug`, `subject`, `body`, `last_update`) VALUES
(1, 'Welcome', 'welcome', 'Thanks for joining us', '<p>Hi {USERNAME},</p><p>Thanks for email verification and we warmly welcome you.</p><p>Now you can do cool stuff with us like,</p><p></p><ul><li><b>Sell your items with in no time</b></li><li><b>Buy your \n\nfavourite\n\nitems with best price</b></li><li><b>Visit our blog </b></li><li><b>and many more</b></li></ul><p><b></b>Regards,<br>Team</p><p></p>', '2019-11-12 16:34:53'),
(2, 'Forget Password', 'forget-password', 'Forget Password Request', '<p>Hi {USERNAME},</p><p>We have received a request to reset your password.</p><p>If you did not initiate this request, you can simply ignore this message and no action will be taken.<br></p><p>To reset your password, please click the link below:<br></p><p><b></b><a href=\"{RESET_LINK}\" target=\"_blank\" title=\"Link: {RESET_LINK}\">RESET MY PASSWORD</a><br></p><p>Regards,<br>Team</p>', '2019-11-12 16:35:05'),
(3, 'General Notification', 'general-notification', 'Notification', '<p>Hello,</p><p>{CONTENT}</p><p>Regards,<br>Team</p>', '2019-10-20 01:00:39'),
(4, 'Subscription Invoice', 'subscription-invoice', 'asdfasdfasdfasdfasd', '<p><b>last email \n\nlast email\n\n\n\nlast </b>email\n<b>\n\n\nlast email\n\n\n\nlast email\n\n\n\nlast email\n\n\n\nlast email\n\n\n\nlast email\n\n\n\nlast email <a href=\"http://oknew.com\" title=\"Link: http://oknew.com\">http://oknew.com/</a> </b></p>', '2019-08-28 01:51:17'),
(5, 'Ad Post', 'ad-post', 'Ad Post Notification', '<p>Hi {USERNAME},</p><p>Your ad <u><b><a target=\"_blank\" rel=\"nofollow\" title=\"Link: null\" href=\"{POST_LINK}\">{POST_TITLE}</a></b></u> <br></p><p>Bellow are few tips for your sefty<br></p><ul><li><i>Meet buyer on safe place</i></li><li><i>Don\'t sell illegal stuff</i></li><li><i>Make your conversation clear </i></li><li><i>Discuss in inbox or on call before meetup</i></li></ul><p>Best of Luck!<br><i></i>Regards,</p><p>Team</p><p><i></i></p><p></p>', '2021-04-21 01:31:07'),
(6, 'Login Alert', 'login-alert', 'Login Alert', '<p>Hi {USERNAME},</p><p>Your Account is just logged in at {TIMESTAMP}</p><p>Please keep chaging your password randomly</p>', '2019-11-12 16:35:21'),
(7, 'Email Verification', 'email-verification', 'Verify your account', '<p></p>\n\nHello,<div><br>Thank you for signing up with us<br><br>To activate your account and verify your email address,<p></p></div><div>Please click on following link<br><a></a></div><div><br></div><div>{VERIFICATION_LINK}<br></div><div><br></div><div><a title=\"Link: null\">Regards,<br>Team</a></div>', '2019-11-12 16:35:33'),
(8, 'Message Alert', 'message-alert', 'New Message For You', '<p></p>\n\nHello,<div><br>You received new message for <a href=\"{POST_LINK}\" target=\"_blank\"><a target=\"_blank\" rel=\"nofollow\" title=\"Link: null\">{POST_TITLE}</a></a></div><div><br><i><blockquote>{MESSAGE}</blockquote></i></div><div><a target=\"_blank\" rel=\"nofollow\"><br></a></div><div><a target=\"_blank\" rel=\"nofollow\">Regards,<br>Team</a></div>', '2019-10-18 22:51:05');

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

--
-- Table structure for table `ci_email_template_variables`
--

CREATE TABLE IF NOT EXISTS `ci_email_template_variables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_id` int(11) NOT NULL,
  `variable_name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_email_template_variables`
--

INSERT INTO `ci_email_template_variables` (`id`, `template_id`, `variable_name`) VALUES
(1, 6, '{USERNAME}'),
(3, 6, '{TIMESTAMP}'),
(4, 1, '{USERNAME}'),
(7, 7, '{VERIFICATION_LINK}'),
(8, 2, '{RESET_LINK}'),
(9, 2, '{USERNAME}'),
(11, 5, '{USERNAME}'),
(13, 5, '{POST_LINK}'),
(14, 5, '{POST_TITLE}'),
(15, 8, '{POST_TITLE}'),
(16, 8, '{POST_LINK}'),
(17, 8, '{MESSAGE}'),
(18, 3, '{CONTENT}');

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

--
-- Table structure for table `ci_feature_packages`
--

CREATE TABLE IF NOT EXISTS `ci_feature_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT 'Feature Ad',
  `slug` varchar(255) NOT NULL,
  `tagline` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `prorated_price` double NOT NULL,
  `description` varchar(255) NOT NULL,
  `no_of_days` int(11) NOT NULL,
  `is_upgrade` tinyint(4) NOT NULL DEFAULT '0',
  `is_active` int(11) NOT NULL DEFAULT '1',
  `sort_order` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_feature_packages`
--

INSERT INTO `ci_feature_packages` (`id`, `title`, `slug`, `tagline`, `price`, `prorated_price`, `description`, `no_of_days`, `is_upgrade`, `is_active`, `sort_order`, `created_date`, `updated_date`) VALUES
(7, 'Premium', '', 'Grow Your Business', 100, 0, '', 21, 0, 1, 2, '2019-05-24 09:05:33', '2021-03-18 10:03:21'),
(6, 'Plus', '', 'Boost Your Business', 50, 0, '', 15, 0, 1, 3, '2019-05-24 10:05:42', '2021-03-18 10:03:13'),
(5, 'Basic', '', 'Start Your Business', 30, 0, '', 7, 0, 0, 1, '2019-05-24 10:05:25', '2021-04-20 02:04:49'),
(8, 'Free', '', 'Free Listing Package', 0, 0, '', 5, 0, 1, 0, '2021-03-18 10:03:27', '2021-03-18 10:03:22'),
(9, 'Feature Ad', '', '', 100, 0, '', 30, 1, 1, 0, '2021-03-30 10:03:36', '2021-03-30 10:03:36'),
(10, 'Feature Ad', '', '', 50, 0, '', 15, 1, 1, 0, '2021-03-30 11:03:24', '2021-03-30 11:03:24');

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

--
-- Table structure for table `ci_fields`
--

CREATE TABLE IF NOT EXISTS `ci_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `type` varchar(25) NOT NULL,
  `length` int(11) NOT NULL,
  `default_value` varchar(50) DEFAULT NULL,
  `required` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_fields`
--

INSERT INTO `ci_fields` (`id`, `name`, `slug`, `type`, `length`, `default_value`, `required`, `status`, `created_at`) VALUES
(50, 'Make', 'make', 'text', 5, '', 1, 1, '2021-03-04 13:35:45'),
(52, 'Model', 'model', 'text', 3, '', 1, 1, '2021-03-29 15:23:48'),
(53, 'Mileage', 'mileage', 'text', 3, '', 1, 1, '2021-04-29 15:26:55'),
(54, 'Engine Type', 'engine-type', 'text', 3, '', 1, 1, '2021-04-29 15:30:34');

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

--
-- Table structure for table `ci_fields_to_category`
--

CREATE TABLE IF NOT EXISTS `ci_fields_to_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `subcategory` int(11) DEFAULT NULL,
  `field` int(11) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_fields_to_category`
--

INSERT INTO `ci_fields_to_category` (`id`, `category`, `subcategory`, `field`, `updated_at`, `created_at`) VALUES
(14, 104, 0, 50, NULL, '2021-04-29 14:52:59'),
(15, 104, 0, 52, NULL, '2021-04-29 14:53:18'),
(16, 97, 0, 53, NULL, '2021-04-29 15:31:03'),
(17, 97, 0, 54, NULL, '2021-04-29 15:31:45');

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

--
-- Table structure for table `ci_field_options`
--

CREATE TABLE IF NOT EXISTS `ci_field_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_field` int(11) NOT NULL,
  `name` varchar(220) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `Field ID` (`parent_field`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ci_field_type`
--

CREATE TABLE IF NOT EXISTS `ci_field_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `code` varchar(100) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_field_type`
--

INSERT INTO `ci_field_type` (`id`, `name`, `code`, `created_at`) VALUES
(1, 'text', 'form_input', '2019-06-30 21:54:48'),
(2, 'textarea', 'form_textarea', '2019-06-30 21:54:48'),
(3, 'checkbox', 'form_checkbox', '2019-06-30 21:56:01'),
(4, 'multiple_checkbox', 'form_multiple_checkbox', '2019-06-30 21:56:01'),
(5, 'dropdown', 'form_dropdown', '2019-06-30 21:56:14'),
(6, 'radio', 'form_radio', '2019-06-30 21:56:14'),
(7, 'multiple_radio', 'multiple_radio', '2019-06-30 21:56:14');

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

--
-- Table structure for table `ci_footer_settings`
--

CREATE TABLE IF NOT EXISTS `ci_footer_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `grid_column` int(11) NOT NULL,
  `content` text CHARACTER SET utf32 COLLATE utf32_unicode_ci,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_footer_settings`
--

INSERT INTO `ci_footer_settings` (`id`, `title`, `grid_column`, `content`, `updated_date`) VALUES
(193, 'About Us', 3, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing, Quisque lobortis elit.</p>\r\n          <ul class=\"footer-stats\">\r\n            <li>\r\n            <p><i class=\"lnr lnr-gift\"></i>   <span> 850.296</span> Products</p>\r\n            </li>\r\n            <li>\r\n            <p><i class=\"lnr lnr-earth\"></i>   <span> 1.207.300</span> Members</p>\r\n            </li>\r\n            <li>\r\n            <p><i class=\"lnr lnr-user\"></i>   <span> 74.059</span> Sellers</p>\r\n            </li>\r\n          </ul>', '2021-06-14 21:35:49'),
(194, 'Useful Links', 3, '<ul class=\"footer-nav\">\r\n            <li><a href=\"\">How to Sell Faster</a></li>\r\n            <li><a href=\"#\">Membership Details</a></li>\r\n            <li><a href=\"#\">Why Choose</a></li>\r\n            <li><a href=\"#\">Purchase Protection</a></li>\r\n            <li><a href=\"#\">Using This Platform</a></li>\r\n          </ul>', '2021-06-14 21:35:49'),
(195, 'Help & Support', 3, '<ul class=\"footer-nav\">\r\n            <li><a href=\"https://codeglamour.com/php/classify/p/privacy-policy\">Privacy Policy</a></li>\r\n            <li><a href=\"https://codeglamour.com/php/classify/p/about-us\">About Us</a></li>\r\n            <li><a href=\"https://codeglamour.com/php/classify/p/Terms-and-Conditions\">Terms & Conditions</a></li>\r\n            <li><a href=\"blog-home.html\">Support</a></li>\r\n            <li><a href=\"contact\">Contact us</a></li>\r\n          </ul>', '2021-06-14 21:35:49'),
(196, 'Contact Information', 3, '<ul class=\"footer-nav\">\r\n            <li>\r\n            <strong>Address :</strong><span class=\"pl-2\">1900 Pico Blvd, New York</span>\r\n            </li>\r\n            <li>\r\n            <strong>Phone :</strong><span class=\"pl-2\">+48 123 456 789</span>\r\n            </li>\r\n            <li>\r\n            <strong>E-mail :</strong><span class=\"pl-2\"><a href=\"#\">example@example.com</a></span>\r\n            </li>\r\n          </ul>', '2021-06-14 21:35:49');

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

--
-- Table structure for table `ci_general_settings`
--

CREATE TABLE IF NOT EXISTS `ci_general_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application_name` varchar(255) DEFAULT NULL,
  `description` text,
  `favicon` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `language` varchar(50) DEFAULT NULL,
  `copyright` tinytext,
  `admin_email` varchar(255) NOT NULL,
  `email_from` varchar(100) NOT NULL,
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_port` int(11) DEFAULT NULL,
  `smtp_user` varchar(50) DEFAULT NULL,
  `smtp_pass` varchar(50) DEFAULT NULL,
  `facebook_link` varchar(255) DEFAULT NULL,
  `twitter_link` varchar(255) DEFAULT NULL,
  `google_link` varchar(255) DEFAULT NULL,
  `youtube_link` varchar(255) DEFAULT NULL,
  `linkedin_link` varchar(255) DEFAULT NULL,
  `instagram_link` varchar(255) DEFAULT NULL,
  `recaptcha_secret_key` varchar(255) DEFAULT NULL,
  `recaptcha_site_key` varchar(255) DEFAULT NULL,
  `map_api_key` varchar(225) NOT NULL,
  `map_access_token` varchar(255) NOT NULL,
  `default_map` varchar(10) DEFAULT 'google',
  `terms_and_conditions` text NOT NULL,
  `recaptcha_lang` varchar(50) DEFAULT NULL,
  `stripe_publishable_key` varchar(255) NOT NULL,
  `stripe_secrate_key` varchar(255) NOT NULL,
  `stripe_status` tinyint(4) NOT NULL,
  `paypal_sandbox` tinyint(4) NOT NULL,
  `paypal_sandbox_url` varchar(255) NOT NULL,
  `paypal_live_url` varchar(255) NOT NULL,
  `paypal_email` varchar(255) NOT NULL,
  `paypal_client_id` varchar(255) NOT NULL,
  `paypal_secrate_key` varchar(255) NOT NULL,
  `paypal_status` tinyint(4) NOT NULL DEFAULT '1',
  `email_verification` tinyint(4) NOT NULL DEFAULT '0',
  `created_date` datetime DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_general_settings`
--

INSERT INTO `ci_general_settings` (`id`, `application_name`, `description`, `favicon`, `logo`, `timezone`, `currency`, `language`, `copyright`, `admin_email`, `email_from`, `smtp_host`, `smtp_port`, `smtp_user`, `smtp_pass`, `facebook_link`, `twitter_link`, `google_link`, `youtube_link`, `linkedin_link`, `instagram_link`, `recaptcha_secret_key`, `recaptcha_site_key`, `map_api_key`, `map_access_token`, `default_map`, `terms_and_conditions`, `recaptcha_lang`, `stripe_publishable_key`, `stripe_secrate_key`, `stripe_status`, `paypal_sandbox`, `paypal_sandbox_url`, `paypal_live_url`, `paypal_email`, `paypal_client_id`, `paypal_secrate_key`, `paypal_status`, `email_verification`, `created_date`, `updated_date`) VALUES
(1, 'Classify', 'Classify marketplace is a platform for buying and selling services and goods such as electronics, beauty, Vehicles or any kind of products', 'uploads/site/caf5b0e8c45d0e2652bda7112d8cee6c.png', 'uploads/site/media_file_8538d13c36080eedf1855f406fbe9848.png', 'America/Adak', '114', '2', 'Copyright © 2021 CODEGLAMOUR All rights reserved.', 'no-reply@yourdomain.com', 'no-reply@yourdomain.com', 'mail.yourdomain.com', 587, 'no-reply@yourdomain.com', 'yourpassword', 'https://facebook.com/', 'https://twitter.com', 'https://google.com', 'https://youtube.com', 'https://linkedin.com', 'https://instagram.com', '6Le0HZIUAAAAABxzALAPxfn_EvPTQEkDtxZm2OxQ', '6Le0HZIUAAAAAGlN837KsF6nbXsjZ0KeU2q-TzY8', 'AIzaSyBQSqMjy-m2jF2ZRxwgdZk07KPA8ZW2I34', '', 'google', 'The Website and the Service are provided to you subject to these SITE Terms of Use (these \"Terms\"). For the purpose of the Terms and wherever the context so requires, the terms \'you\' and “your” shall mean any person who uses the Website or the Service in any manner whatsoever including persons browsing the Website and its content, posting comments or any content or responding to any advertisements or content on the Website. By accessing, browsing or using the Website or Service, you agree to comply with these Terms. Additionally, when using a portion of the Service, you agree to conform to any applicable posted guidelines for such Service, which may change or be updated from time to time at SITE’s sole discretion. You understand and agree that you are solely responsible for reviewing these Terms from time to time. Should you object to any term or condition of these Terms, any guideline, or any subsequent changes thereto or become unhappy with SITE or the Service in any way, your only choice is to immediately discontinue use of SITE. These Terms may be updated by SITE at any time at its sole discretion. SITE may send you notices of changes to the Website or the Terms pursuant to Section xxi (I) herein. SITE may provide a translation of the English version of the Terms into other languages. You understand and agree that any translation of the Terms into other languages is for your convenience only and that the English version governs the terms of your relationship with SITE. Furthermore, if there are any inconsistencies between the English version of the Terms and any translation, the English version of the Terms shall govern.\r\n\r\nThe Website and the Service are provided to you subject to these SITE Terms of Use (these \"Terms\"). For the purpose of the Terms and wherever the context so requires, the terms \'you\' and “your” shall mean any person who uses the Website or the Service in any manner whatsoever including persons browsing the Website and its content, posting comments or any content or responding to any advertisements or content on the Website. By accessing, browsing or using the Website or Service, you agree to comply with these Terms. Additionally, when using a portion of the Service, you agree to conform to any applicable posted guidelines for such Service, which may change or be updated from time to time at SITE’s sole discretion. You understand and agree that you are solely responsible for reviewing these Terms from time to time. Should you object to any term or condition of these Terms, any guideline, or any subsequent changes thereto or become unhappy with SITE or the Service in any way, your only choice is to immediately discontinue use of SITE. These Terms may be updated by SITE at any time at its sole discretion. SITE may send you notices of changes to the Website or the Terms pursuant to Section xxi (I) herein. SITE may provide a translation of the English version of the Terms into other languages. You understand and agree that any translation of the Terms into other languages is for your convenience only and that the English version governs the terms of your relationship with SITE. Furthermore, if there are any inconsistencies between the English version of the Terms and any translation, the English version of the Terms shall govern.\r\n\r\nThe Website and the Service are provided to you subject to these SITE Terms of Use (these \"Terms\"). For the purpose of the Terms and wherever the context so requires, the terms \'you\' and “your” shall mean any person who uses the Website or the Service in any manner whatsoever including persons browsing the Website and its content, posting comments or any content or responding to any advertisements or content on the Website. By accessing, browsing or using the Website or Service, you agree to comply with these Terms. Additionally, when using a portion of the Service, you agree to conform to any applicable posted guidelines for such Service, which may change or be updated from time to time at SITE’s sole discretion. You understand and agree that you are solely responsible for reviewing these Terms from time to time. Should you object to any term or condition of these Terms, any guideline, or any subsequent changes thereto or become unhappy with SITE or the Service in any way, your only choice is to immediately discontinue use of SITE. These Terms may be updated by SITE at any time at its sole discretion. SITE may send you notices of changes to the Website or the Terms pursuant to Section xxi (I) herein. SITE may provide a translation of the English version of the Terms into other languages. You understand and agree that any translation of the Terms into other languages is for your convenience only and that the English version governs the terms of your relationship with SITE. Furthermore, if there are any inconsistencies between the English version of the Terms and any translation, the English version of the Terms shall govern.', 'en', 'pk_test_51Ib28SGKLTmaB9k45ENqAGYDE2YKdZoBp8qSs0tYRo6qaYDCcQNQORmxLlx8T4dDkOvWUtTHaDBEtVYrunvhlI4200L0L0Rzwe', 'sk_test_51Ib28SGKLTmaB9k4W2uwMbTDA3rhecnuoRDk7L1VlEl5jkwymhypC39xvqLStrtU9MAPZjSzZdTtrzjp0mISxVqT00xZzoGyyo', 1, 1, 'https://sandbox.paypal.com/cgi-bin/webscr', 'https://www.paypal.com/cgi-bin/webscr', 'nacreativeprogrammer-facilitator@gmail.com', 'AW1tZTsRtL362R1TvXxV4J6KsXDDszBpxqLpty-dDNTpL4B3O5fOWsyGSGJ3yNGTCxqhCsZYWqEqAuc-', '', 1, 0, '2021-06-14 07:06:49', '2021-06-14 07:06:49');

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

--
-- Table structure for table `ci_inbox`
--

CREATE TABLE IF NOT EXISTS `ci_inbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ad` int(11) NOT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ci_inbox_messages`
--

CREATE TABLE IF NOT EXISTS `ci_inbox_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inbox_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `not_visible_to` int(11) DEFAULT '0',
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ci_language`
--

CREATE TABLE IF NOT EXISTS `ci_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `short_form` varchar(15) NOT NULL,
  `code` varchar(15) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_language`
--

INSERT INTO `ci_language` (`id`, `name`, `short_form`, `code`, `status`, `created_at`) VALUES
(2, 'English', 'en', 'en_us', 1, '2019-09-16 01:13:17'),
(3, 'French', 'fr', 'fr_eu', 1, '2019-09-16 08:11:08');

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

--
-- Table structure for table `ci_menu`
--

CREATE TABLE IF NOT EXISTS `ci_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) NOT NULL,
  `link` varchar(225) NOT NULL,
  `active` int(11) NOT NULL DEFAULT '1',
  `sort_order` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_menu`
--

INSERT INTO `ci_menu` (`id`, `name`, `link`, `active`, `sort_order`, `created_at`) VALUES
(1, 'Home', '', 1, 1, '2019-08-22 16:58:47'),
(2, 'Services', 'services', 1, 3, '2019-11-08 05:09:51'),
(3, 'Categories', 'category', 1, 4, '2019-11-08 05:12:59'),
(4, 'Blog', 'blog', 1, 5, '2019-11-08 05:13:22'),
(5, 'Contact', 'contact', 1, 6, '2019-11-08 05:13:35'),
(6, 'Listing', 'ads', 1, 2, '2019-11-08 05:09:51');

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

--
-- Table structure for table `ci_module`
--

CREATE TABLE IF NOT EXISTS `ci_module` (
  `module_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(255) NOT NULL,
  `controller_name` varchar(255) NOT NULL,
  `fa_icon` varchar(100) NOT NULL,
  `operation` text NOT NULL,
  `sort_order` tinyint(4) NOT NULL,
  PRIMARY KEY (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_module`
--

INSERT INTO `ci_module` (`module_id`, `module_name`, `controller_name`, `fa_icon`, `operation`, `sort_order`) VALUES
(1, 'Admin', 'admin', 'fa-pie-chart', 'view|add|edit|delete|change_status|access', 14),
(2, 'Roles & Permissions', 'admin_roles', 'fa-dashboard', 'view|add|edit|delete|change_status|access', 15),
(3, 'Users', 'users', 'fa fa-user', 'view|add|edit|delete|change_status|access', 10),
(7, 'Backp & Export', 'export', 'fa fa-user', 'access', 16),
(8, 'Settings', 'general_settings', 'fa fa-cogs', 'view|add|edit|email_templates|payments|access', 13),
(9, 'Pages', 'pages', 'fa fa-book', 'add|edit|delete|access', 10),
(11, 'Newsletter', 'newsletter', 'fa fa-envelope', 'add', 11),
(12, 'Blog', 'blog', 'fa fa-book', 'add|edit|delete|access', 13),
(13, 'Invoices', 'invoices', 'fa fa-book', 'add|edit|delete|access', 11),
(14, 'Custom Fields', 'custom_fields', 'fa fa-bars', 'add|edit|delete|access', 4),
(16, 'Miscellaneous', 'misc', 'fa fa-list', 'access', 12),
(17, 'Category', 'category', 'fa fa-list', 'access|add|edit|del|subcategories|add_subcategory|edit_subcategory|del_subcategory', 3),
(18, 'Testimonials', 'testimonial', 'fa fa-users', 'access', 14),
(19, 'Ads', 'ads', 'fa-bars', 'access', 2),
(21, 'Contact Form', 'contact', 'fa fa-address-card', 'access|contact_del', 10),
(22, 'Reports', 'reports', 'fa-bar-chart', 'access', 12),
(23, 'Feature Ads Pricing', 'feature_packages', 'fa-life-ring', 'add|edit|delete|access', 9),
(24, 'Upgrade Ads Pricing', 'package_upgrade', 'fa-recycle', 'add|edit|delete|access', 9),
(27, 'Vouchers', 'vouchers', 'fa fa-book', 'add|edit|delete|access', 9);

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

--
-- Table structure for table `ci_module_access`
--

CREATE TABLE IF NOT EXISTS `ci_module_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_role_id` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  `operation` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `RoleId` (`admin_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_module_access`
--

INSERT INTO `ci_module_access` (`id`, `admin_role_id`, `module`, `operation`) VALUES
(8, 1, 'general_settings', 'view'),
(9, 1, 'general_settings', 'add'),
(10, 1, 'general_settings', 'edit'),
(11, 1, 'general_settings', 'access'),
(18, 1, 'export', 'access'),
(20, 1, 'users', 'view'),
(21, 1, 'users', 'add'),
(25, 1, 'users', 'change_status'),
(30, 1, 'users', 'delete'),
(31, 1, 'users', 'access'),
(32, 2, 'users', 'view'),
(33, 2, 'users', 'add'),
(34, 2, 'users', 'edit'),
(35, 2, 'users', 'delete'),
(36, 2, 'users', 'access'),
(37, 2, 'users', 'change_status'),
(38, 2, 'export', 'access'),
(39, 2, 'pages', 'add'),
(40, 2, 'pages', 'edit'),
(41, 2, 'packages', 'add'),
(42, 2, 'packages', 'edit'),
(43, 2, 'packages', 'delete'),
(44, 2, 'general_settings', 'view'),
(45, 2, 'general_settings', 'add'),
(46, 2, 'general_settings', 'edit'),
(47, 2, 'general_settings', 'access'),
(48, 2, 'general_settings', 'email_templates'),
(49, 2, 'general_settings', 'payments'),
(50, 2, 'category', 'access'),
(51, 2, 'misc', 'access'),
(52, 2, 'invoices', 'add'),
(53, 2, 'invoices', 'edit'),
(54, 2, 'invoices', 'delete'),
(55, 2, 'custom_fields', 'add'),
(56, 2, 'custom_fields', 'edit'),
(57, 2, 'custom_fields', 'delete'),
(58, 2, 'testimonial', 'access'),
(59, 2, 'ads', 'access'),
(60, 2, 'invoices', 'access');

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

--
-- Table structure for table `ci_notifications`
--

CREATE TABLE IF NOT EXISTS `ci_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `admin_view` int(11) NOT NULL DEFAULT '0',
  `user_view` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_notifications`
--

INSERT INTO `ci_notifications` (`id`, `user_id`, `admin_id`, `content`, `admin_view`, `user_view`, `deleted`, `created_at`) VALUES
(134, 3, 0, 'Your Ad <b>Football</b> is updated', 0, 1, 0, '2021-05-03 23:06:12'),
(135, 3, 0, 'Your Ad <b>Football Best Quality</b> is updated', 0, 1, 0, '2021-05-03 23:08:46'),
(136, 3, 0, 'Your Ad <b>Football Best Quality</b> is updated', 0, 1, 0, '2021-05-03 23:21:34'),
(137, 3, 0, 'Your Ad <b>Range Rover</b> is updated', 0, 1, 0, '2021-05-03 23:23:37'),
(138, 3, 0, 'Your Ad <b>German Shepherd</b> is updated', 0, 1, 0, '2021-05-03 23:27:40'),
(139, 3, 0, 'Your Ad <b>Home Double Bed</b> is updated', 0, 1, 0, '2021-05-03 23:30:09'),
(140, 3, 0, 'Your Ad <b>Samsung Glaxy S11</b> is updated', 0, 1, 0, '2021-05-03 23:35:15'),
(141, 3, 0, 'Your Ad <b>Girls Makeup</b> is updated', 0, 0, 0, '2021-05-03 23:41:28'),
(142, 3, 0, 'Your Ad <b>Summer Lawn Suite</b> is updated', 0, 0, 0, '2021-05-03 23:43:45'),
(143, 3, 0, 'Your Ad <b>Test Ads</b> is pending for admin approval', 0, 0, 0, '2021-06-11 17:43:49');

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

--
-- Table structure for table `ci_packages`
--

CREATE TABLE IF NOT EXISTS `ci_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `tagline` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `detail` varchar(255) NOT NULL,
  `no_of_posts` int(11) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `sort_order` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_packages`
--

INSERT INTO `ci_packages` (`id`, `title`, `slug`, `tagline`, `price`, `detail`, `no_of_posts`, `is_active`, `sort_order`, `created_date`, `updated_date`) VALUES
(7, 'Premium', '', 'Grow Your Business', 100, 'xyz', 5, 1, 3, '2019-05-24 09:05:33', '2021-04-20 02:04:53'),
(6, 'Plus', '', 'Boost Your Business', 50, 'Some text here', 3, 1, 2, '2019-05-24 10:05:42', '2021-04-20 02:04:31'),
(5, 'Basic', '', 'Start Your Business', 30, 'Basic Package description', 2, 0, 1, '2019-05-24 10:05:25', '2021-04-20 02:04:05');

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

--
-- Table structure for table `ci_pages`
--

CREATE TABLE IF NOT EXISTS `ci_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `sort_order` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT '1',
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_pages`
--

INSERT INTO `ci_pages` (`id`, `title`, `slug`, `description`, `keywords`, `content`, `sort_order`, `is_active`, `created_date`, `updated_date`) VALUES
(1, 'About Us', 'about-us', 'onjob about page', 'about, aboutus, about us', 'Lorem ipsum dolor sit amet, te mea mundi commune vulputate. Ad errem option sensibus has. Ad eam idque menandri necessitatibus. An mel scaevola scriptorem <i><u>mediocritatem</u></i>, illud viderer maiestatis id mei. Vim cibo nusquam disputando ex. No est putant ornatus, quo ut dico graeci.Nec tota feugiat ea, timeam detracto ius id, perpetua suscipiantur mea ex. Sumo eruditi no mel, vel cu integre oportere voluptaria, sea ea euismod officiis luptatum. <div><br>mentitum appareat, vim at omnium abhorreant. Pri id natum velit facilisi, no eos dicat altera commodo.Lorem ipsum dolor sit amet, te mea mundi commune vulputate. Ad errem option sensibus has. Ad eam idque menandri necessitatibus. An mel scaevola scriptorem mediocritatem, illud viderer maiestatis id mei. Vim cibo nusquam disputando ex. No est putant ornatus, quo ut dico graeci.Nec tota feugiat ea, timeam detracto ius id, perpetua suscipiantur mea ex. Sumo eruditi no mel, vel cu integre oportere voluptaria, sea ea euismod officiis luptatum.<br><img alt=\"\"><br> Cu dolor nonumes dissentiet mei, mei verterem sapientem no. Id nam ignota vidisse gubergren. Vel bonorum gloriatur ad, in pro utroque mentitum appareat, vim at omnium abhorreant. Pri id natum velit facilisi, no eos dicat altera commodo.\"\"\"\"\"\"\"</div>', 2, 1, '2019-12-17 09:12:21', '0000-00-00 00:00:00'),
(4, 'Terms and Conditions', 'terms-and-conditions', 'terms and conditions', 'terms and condition', '<p>\r\n\r\n</p><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<br><p></p>', 1, 1, '2019-12-17 09:12:46', '0000-00-00 00:00:00'),
(5, 'Privacy Policy', 'privacy-policy', 'Privacy Policy', 'Privacy Policy', '<p>\r\n\r\nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).\r\n\r\n<br></p><p><br></p><p>\r\n\r\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.\r\n\r\n<br></p>\"', 3, 1, '2019-12-17 09:12:48', '0000-00-00 00:00:00');

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

--
-- Table structure for table `ci_payments`
--

CREATE TABLE IF NOT EXISTS `ci_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_ipn` tinyint(4) NOT NULL DEFAULT '0',
  `invoice_no` varchar(30) NOT NULL,
  `payment_for` varchar(50) NOT NULL,
  `package_id` int(11) NOT NULL,
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `payer_email` varchar(255) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `txn_id` varchar(255) NOT NULL,
  `sub_total` decimal(10,2) NOT NULL,
  `total_tax` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `grand_total` decimal(10,2) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `payment_status` varchar(30) NOT NULL,
  `client_note` longtext NOT NULL,
  `termsncondition` longtext NOT NULL,
  `due_date` date DEFAULT NULL,
  `created_date` date NOT NULL,
  `updated_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_payments`
--

INSERT INTO `ci_payments` (`id`, `is_ipn`, `invoice_no`, `payment_for`, `package_id`, `ad_id`, `user_id`, `admin_id`, `payer_email`, `payment_method`, `txn_id`, `sub_total`, `total_tax`, `discount`, `grand_total`, `currency`, `payment_status`, `client_note`, `termsncondition`, `due_date`, `created_date`, `updated_date`) VALUES
(31, 0, 'INV-16194541463', 'package', 6, 0, 3, NULL, 'naumanahmedit@gmail.com', '2', 'txn_1IkXCWGKLTmaB9k4lcZzMePy', '50.00', '0.00', '0.00', '50.00', 'aud', 'succeeded', '', '', NULL, '2021-04-26', NULL),
(32, 0, 'INV-16194589933', 'package', 7, 0, 3, NULL, 'naumanahmedit@gmail.com', '2', 'txn_1IkYSiGKLTmaB9k4cttkbDOE', '100.00', '0.00', '0.00', '100.00', 'aud', 'succeeded', '', '', NULL, '2021-04-26', NULL),
(33, 0, 'INV-16194595763', 'featured', 9, 0, 3, NULL, 'naumanahmedit@gmail.com', '2', 'txn_1IkYc6GKLTmaB9k43H5fH745', '100.00', '0.00', '0.00', '100.00', 'aud', 'succeeded', '', '', NULL, '2021-04-26', NULL),
(34, 0, 'INV-16194641003', 'featured', 7, 46, 3, NULL, '', '2', 'txn_1IkZn5GKLTmaB9k4gFVZSwf0', '100.00', '0.00', '0.00', '100.00', 'aud', 'succeeded', '', '', NULL, '2021-04-26', NULL);

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

--
-- Table structure for table `ci_payment_methods`
--

CREATE TABLE IF NOT EXISTS `ci_payment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(220) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_payment_methods`
--

INSERT INTO `ci_payment_methods` (`id`, `name`) VALUES
(1, 'Paypal'),
(2, 'Stripe'),
(3, 'Tingg');

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

--
-- Table structure for table `ci_states`
--

CREATE TABLE IF NOT EXISTS `ci_states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `country_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_states`
--

INSERT INTO `ci_states` (`id`, `name`, `slug`, `country_id`) VALUES
(6, 'Punjab', 'punjab', 6),
(7, 'Sindh', 'sindh', 6),
(8, 'KPK', 'kpk', 6),
(9, 'NWFP', 'nwfp', 6),
(10, 'Gilgit', 'gilgit', 6);

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

--
-- Table structure for table `ci_subcategories`
--

CREATE TABLE IF NOT EXISTS `ci_subcategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `parent` int(11) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `top_category` tinyint(4) NOT NULL DEFAULT '0',
  `sort_order` tinyint(4) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_subcategories`
--

INSERT INTO `ci_subcategories` (`id`, `name`, `slug`, `parent`, `description`, `status`, `top_category`, `sort_order`, `created_at`) VALUES
(87, 'Truck / Buss', 'truck-buss', 97, '', 1, 0, 0, '2021-03-29 15:21:59'),
(88, 'Car / 4X4 / Passenger Vehicle', 'car-4x4-passenger-vehicle', 97, '', 1, 0, 0, '2021-03-29 15:22:14'),
(90, 'Others', 'others', 97, '', 1, 0, 8, '2021-03-29 15:22:45'),
(91, 'Tracks', 'tracks', 98, 'Tracks', 1, 0, 1, '2021-04-12 14:52:48'),
(92, 'Tracks Fitted Over Tyres', 'tracks-fitted-over-tyres', 98, 'Tracks Fitted Over Tyres', 1, 0, 2, '2021-04-12 14:53:19'),
(93, 'Others', 'others', 98, 'Others', 1, 0, 3, '2021-04-12 14:56:29'),
(94, 'Options - TBD', 'options-tbd', 99, 'Options - TBD', 1, 0, 1, '2021-04-13 14:46:23'),
(95, 'TVs, Audio & Video', 'tvs-audio-video', 102, '', 1, 0, 1, '2021-04-29 15:06:52'),
(96, 'Computers & Peripherals', 'computers-peripherals', 102, '', 1, 0, 2, '2021-04-29 15:07:29'),
(97, 'Girls Clothing', 'girls-clothing', 100, '', 1, 0, 1, '2021-04-29 15:10:10'),
(98, 'Boys Clothing', 'boys-clothing', 100, '', 1, 0, 2, '2021-04-29 15:11:01');

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

--
-- Table structure for table `ci_subscribers`
--

CREATE TABLE IF NOT EXISTS `ci_subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_subscribers`
--

INSERT INTO `ci_subscribers` (`id`, `email`, `created_at`) VALUES
(3, 'officialarea423@gmail.com', '2019-12-12 04:38:58');

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

--
-- Table structure for table `ci_sub_menu`
--

CREATE TABLE IF NOT EXISTS `ci_sub_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_sub_menu`
--

INSERT INTO `ci_sub_menu` (`id`, `parent`, `name`, `link`, `sort_order`) VALUES
(2, 2, 'Module Setting', 'module', 1),
(3, 2, 'Roles & Permissions', '', 2),
(5, 1, 'Profile', 'profile', 3),
(8, 8, 'General Settings', '', 1),
(9, 11, 'Send Email to Subscribers', 'send_email', 1),
(10, 11, 'Subscribers', 'subscribers', 2),
(11, 8, 'User Menu Settings', 'user_menu', 2),
(12, 1, 'goto', 'gototo', 3);

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

--
-- Table structure for table `ci_sub_module`
--

CREATE TABLE IF NOT EXISTS `ci_sub_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Parent Module ID` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_sub_module`
--

INSERT INTO `ci_sub_module` (`id`, `parent`, `name`, `link`, `sort_order`) VALUES
(2, 2, 'Module Setting', 'module', 1),
(3, 2, 'Roles & Permissions', '', 2),
(4, 1, 'Add New Admin', 'add', 2),
(6, 1, 'Admin List', '', 1),
(8, 8, 'General Settings', '', 1),
(9, 11, 'Send Email to Subscribers', '', 1),
(11, 8, 'User Menu Settings', 'user_menu', 2),
(12, 8, 'Email Templates', 'email_templates', 3),
(14, 12, 'Posts', '', 1),
(15, 12, 'Category', 'category', 2),
(17, 8, 'Payment Settings', 'payments', 4),
(20, 16, 'Country', 'country', 1),
(21, 16, 'State', 'state', 2),
(22, 16, 'City', 'city', 3),
(23, 16, 'Currency', 'currency', 4),
(24, 16, 'Language', 'language', 5),
(29, 19, 'Ads Listing', '', 1);

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

--
-- Table structure for table `ci_testimonials`
--

CREATE TABLE IF NOT EXISTS `ci_testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `testimonial` text NOT NULL,
  `testimonial_by` varchar(225) NOT NULL,
  `comp_and_desig` varchar(255) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `is_default` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_testimonials`
--

INSERT INTO `ci_testimonials` (`id`, `testimonial`, `testimonial_by`, `comp_and_desig`, `photo`, `is_default`, `status`, `created_at`) VALUES
(1, 'Here is my testimonials Here is my testimonials  Here is my testimonials  Here is my testimonials Here is my testimonials  Here is my testimonials Here is my testimonials  Here is my testimonials Here is my testimonials Here is my testimonials Here is my testimonials Here is my testimonials Here is my testimonials Here is my testimonials', 'Camery Lee', 'Developer Ozient', 'uploads/testimonials/media_file_0563d8cf5264dbf4e9a14b567f87e3ff.jpg', 0, 1, '2019-09-16 11:27:57'),
(2, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 'Scott Smith', 'ABC', 'uploads/testimonials/media_file_a790d310a061a9a35a25281db64e6698.jpg', 0, 0, '2019-12-17 00:20:47');

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

--
-- Table structure for table `ci_users`
--

CREATE TABLE IF NOT EXISTS `ci_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(225) NOT NULL,
  `firstname` varchar(30) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(50) NOT NULL,
  `location` varchar(255) NOT NULL,
  `location_lat` varchar(255) NOT NULL,
  `location_lang` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `phone_no` varchar(50) NOT NULL,
  `alt_phone_no` varchar(50) NOT NULL,
  `suburb` varchar(50) NOT NULL,
  `postcode` varchar(50) NOT NULL,
  `password` mediumtext NOT NULL,
  `gender` varchar(30) NOT NULL,
  `country` int(11) NOT NULL,
  `state` varchar(50) NOT NULL,
  `city` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `profile_picture` varchar(250) DEFAULT NULL,
  `profile_completed` tinyint(4) NOT NULL DEFAULT '1',
  `is_active` tinyint(4) NOT NULL DEFAULT '1',
  `is_verify` tinyint(4) NOT NULL DEFAULT '0',
  `is_verified` tinyint(4) NOT NULL DEFAULT '0',
  `is_admin` tinyint(4) NOT NULL DEFAULT '0',
  `token` varchar(255) NOT NULL,
  `password_reset_code` varchar(255) NOT NULL,
  `last_ip` varchar(30) NOT NULL,
  `admin_view` int(11) NOT NULL DEFAULT '0',
  `updated_date` datetime DEFAULT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_users`
--

INSERT INTO `ci_users` (`id`, `username`, `firstname`, `lastname`, `email`, `location`, `location_lat`, `location_lang`, `address1`, `address2`, `phone_no`, `alt_phone_no`, `suburb`, `postcode`, `password`, `gender`, `country`, `state`, `city`, `address`, `profile_picture`, `profile_completed`, `is_active`, `is_verify`, `is_verified`, `is_admin`, `token`, `password_reset_code`, `last_ip`, `admin_view`, `updated_date`, `created_date`) VALUES
(3, 'demouser', 'Demo', 'User', 'user@demo.com', 'Suite Drive, Huntington Beach, California, USA', '', '', 'Suite Drive, Huntington Beach, California, USA', 'Suite Drive, Huntington Beach, California, USA', '11122223333', '111 222 333', 'Huntington Beach', '92649', '$2y$10$/OGIPDsFX1xCUR..IROc/e9i2tAWOzxkVtBM1NjCnOG1KEW4BDtlW', '', 0, 'CA', 0, '', 'uploads/users/media_file_909a51827d941c147fb312ed779bb7bf.jpg', 1, 1, 1, 1, 0, '', 'ce653013fadbb2ff27530d3de3790f1b', '', 1, '2021-05-04 12:05:04', '2021-03-29 12:03:07');

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

--
-- Table structure for table `ci_user_packages`
--

CREATE TABLE IF NOT EXISTS `ci_user_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `no_of_credits` int(11) NOT NULL,
  `purchase_date` date NOT NULL,
  `package_status` varchar(20) NOT NULL,
  `package_type` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_user_packages`
--

INSERT INTO `ci_user_packages` (`id`, `user_id`, `payment_id`, `package_id`, `no_of_credits`, `purchase_date`, `package_status`, `package_type`) VALUES
(16, 3, 32, 7, 5, '2021-04-26', 'active', ''),
(15, 3, 31, 6, 3, '2021-04-26', 'active', ''),
(14, 3, 25, 6, 10, '2021-04-14', 'active', ''),
(13, 3, 24, 7, 10, '2021-04-14', 'active', ''),
(12, 3, 20, 5, 15, '2021-04-05', 'active', '');

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

--
-- Table structure for table `ci_vouchers`
--

CREATE TABLE IF NOT EXISTS `ci_vouchers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `voucher_code` varchar(100) NOT NULL,
  `discount` int(11) NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `multi_redeem` tinyint(4) NOT NULL,
  `redeemed_state` tinyint(4) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `is_active` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_vouchers`
--

INSERT INTO `ci_vouchers` (`id`, `title`, `voucher_code`, `discount`, `expiry_date`, `multi_redeem`, `redeemed_state`, `status`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 'special', '101', 15, '2021-04-07', 1, NULL, 'active', 1, '2021-04-04 12:04:15', '2021-04-12 10:04:54'),
(3, 'special', '501', 20, NULL, 0, 1, 'expired', 1, '2021-04-13 11:04:11', '2021-04-13 11:04:35'),
(4, 'offer', '601', 25, '0000-00-00', 0, 1, 'expired', 1, '2021-04-14 12:04:28', NULL),
(5, 'OFFER', '5P15CFWXML', 10, '2021-04-22', 1, NULL, 'active', 1, '2021-04-20 05:04:33', NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ci_field_options`
--
ALTER TABLE `ci_field_options`
  ADD CONSTRAINT `Field ID` FOREIGN KEY (`parent_field`) REFERENCES `ci_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ci_sub_module`
--
ALTER TABLE `ci_sub_module`
  ADD CONSTRAINT `Parent Module ID` FOREIGN KEY (`parent`) REFERENCES `ci_module` (`module_id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

