CREATE TABLE `banner_gallery` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `category_id` int(11) NOT NULL,
 `image_name` varchar(255) NOT NULL,
 `status` tinyint(2) NOT NULL DEFAULT '1',
 `added_date` date DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


INSERT INTO `banner_gallery` (`id`, `category_id`, `image_name`, `status`, `added_date`) VALUES
(1, 1, 'automobiles1.png', 1, '2016-04-04'),
(2, 1, 'automobiles2.png', 1, '2016-04-04'),
(3, 1, 'automobiles3.png', 1, '2016-04-04'),
(4, 1, 'automobiles4.png', 1, '2016-04-04'),
(5, 2, 'entertainment1.png', 1, '2016-04-04'),
(6, 2, 'entertainment2.png', 1, '2016-04-04'),
(7, 3, 'marketers1.png', 1, '2016-04-04'),
(8, 3, 'marketers2.png', 1, '2016-04-04'),
(9, 3, 'marketers3.png', 1, '2016-04-04'),
(10, 3, 'marketers4.png', 1, '2016-04-04'),
(11, 3, 'marketers5.png', 1, '2016-04-04'),
(12, 3, 'marketers6.png', 1, '2016-04-04'),
(13, 3, 'marketers7.png', 1, '2016-04-04'),
(14, 3, 'marketers8.png', 1, '2016-04-04'),
(15, 3, 'marketers9.png', 1, '2016-04-04'),
(16, 3, 'marketers10.png', 1, '2016-04-04'),
(17, 3, 'marketers11.png', 1, '2016-04-04'),
(18, 4, 'restaurants1.png', 1, '2016-04-04'),
(19, 4, 'restaurants2.png', 1, '2016-04-04'),
(20, 4, 'restaurants3.png', 1, '2016-04-04'),
(21, 4, 'restaurants4.png', 1, '2016-04-04'),
(22, 4, 'restaurants5.png', 1, '2016-04-04'),
(23, 4, 'restaurants6.png', 1, '2016-04-04'),
(24, 4, 'restaurants7.png', 1, '2016-04-04'),
(25, 4, 'restaurants8.png', 1, '2016-04-04'),
(26, 4, 'restaurants9.png', 1, '2016-04-04'),
(27, 4, 'restaurants10.png', 1, '2016-04-04'),
(28, 4, 'restaurants11.png', 1, '2016-04-04'),
(29, 4, 'restaurants12.png', 1, '2016-04-04'),
(30, 4, 'restaurants13.png', 1, '2016-04-04'),
(31, 4, 'restaurants14.png', 1, '2016-04-04'),
(32, 4, 'restaurants15.png', 1, '2016-04-04'),
(33, 4, 'restaurants16.png', 1, '2016-04-04'),
(34, 5, 'e-tailers1.png', 1, '2016-04-04'),
(35, 5, 'e-tailers2.png', 1, '2016-04-04'),
(36, 5, 'e-tailers3.png', 1, '2016-04-04'),
(37, 5, 'e-tailers4.png', 1, '2016-04-04'),
(38, 5, 'e-tailers5.png', 1, '2016-04-04'),
(39, 5, 'e-tailers6.png', 1, '2016-04-04'),
(40, 5, 'e-tailers7.png', 1, '2016-04-04'),
(41, 6, 'realestate1.png', 1, '2016-04-04'),
(42, 6, 'realestate2.png', 1, '2016-04-04'),
(43, 6, 'realestate3.png', 1, '2016-04-04'),
(44, 6, 'realestate4.png', 1, '2016-04-04'),
(45, 6, 'realestate5.png', 1, '2016-04-04'),
(46, 6, 'realestate6.png', 1, '2016-04-04'),
(47, 6, 'realestate7.png', 1, '2016-04-04'),
(48, 6, 'realestate8.png', 1, '2016-04-04'),
(49, 7, 'personal1.png', 1, '2016-04-04'),
(50, 7, 'personal2.png', 1, '2016-04-04'),
(51, 7, 'personal3.png', 1, '2016-04-04'),
(52, 7, 'personal4.png', 1, '2016-04-04'),
(53, 7, 'personal5.png', 1, '2016-04-04'),
(54, 7, 'personal6.png', 1, '2016-04-04'),
(55, 7, 'personal7.png', 1, '2016-04-04'),
(56, 8, 'resell1.png', 1, '2016-04-04'),
(57, 8, 'resell2.png', 1, '2016-04-04'),
(58, 8, 'resell3.png', 1, '2016-04-04'),
(59, 8, 'resell4.png', 1, '2016-04-04');
