-- author: usman didi khamdani
-- author's email: usmankhamdani@gmail.com
-- author's phone: +6287883919293
CREATE TABLE IF NOT EXISTS `image_banner` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`category` varchar(20) COLLATE latin1_general_ci NOT NULL,
`title` varchar(100) COLLATE latin1_general_ci NOT NULL,
`image` varchar(100) COLLATE latin1_general_ci NOT NULL,
`target` varchar(100) COLLATE latin1_general_ci NOT NULL,
`owner` varchar(50) COLLATE latin1_general_ci NOT NULL,
`address` text COLLATE latin1_general_ci NOT NULL,
`email` varchar(50) COLLATE latin1_general_ci NOT NULL,
`phone` varchar(15) COLLATE latin1_general_ci NOT NULL,
`start_time` datetime NOT NULL,
`ending_time` datetime NOT NULL,
`hits` int(6) NOT NULL,
`ip_hits` text COLLATE latin1_general_ci NOT NULL,
`denied_ip` text COLLATE latin1_general_ci NOT NULL,
`hits_time` text COLLATE latin1_general_ci NOT NULL,
`hits_page` text COLLATE latin1_general_ci NOT NULL,
`status` enum('0','1') COLLATE latin1_general_ci NOT NULL,
`last_update` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `image_banner`
--
INSERT INTO `image_banner` (`id`, `category`, `title`, `image`, `target`, `owner`, `address`, `email`, `phone`, `start_time`, `ending_time`, `hits`, `ip_hits`, `denied_ip`, `hits_time`, `hits_page`, `status`, `last_update`) VALUES
(1, 'top', 'Edelweis Art :: Developing and Designing Web', 'images/banner/edelweis-art1.jpg', 'http://www.edelweis-art.co.cc', 'Usman Didi Khamdani', 'BSD, Tangerang, Indonesia', 'usmankhamdani@gmail.com', '6287883919293', '2009-08-01 00:00:00', '2019-07-31 23:59:59', 0, '', '', '', '', '1', '0000-00-00 00:00:00'),
(2, 'top', 'Edelweis Art :: Developing and Designing Web', '', 'http://www.edelweis-art.co.cc', 'Usman Didi Khamdani', 'BSD, Tangerang, Indonesia', 'usmankhamdani@gmail.com', '622192512772', '2009-08-01 00:00:00', '2019-07-31 23:59:59', 0, '', '', '', '', '1', '0000-00-00 00:00:00'),
(3, 'left', 'Edelweis Art :: Developing and Designing Web', 'images/banner/edelweis-art2.jpg', '', 'Usman Didi Khamdani', 'BSD, Tangerang, Indonesia', 'usmankhamdani@gmail.com', '6287883919293', '2009-08-01 00:00:00', '2019-07-31 23:59:59', 0, '', '', '', '', '1', '0000-00-00 00:00:00');
|
Download
