File: sql/image_banner.sql

-- 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');