CREATE TABLE IF NOT EXISTS `adv` (
`adv_id` int(11) NOT NULL auto_increment,
`adv_name` varchar(255) NOT NULL default '',
`adv_text` text NOT NULL,
`adv_status` enum('Active','Inactive') NOT NULL default 'Active',
PRIMARY KEY (`adv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
INSERT INTO `adv` (`adv_id`, `adv_name`, `adv_text`, `adv_status`) VALUES
(1, 'banner_top', 'Your Ad Code', 'Active'),
(2, 'banner_bottom', ' Your Ad Code', 'Active'),
(3, 'home_right_box', 'Your Ad Code', 'Active'),
(4, 'video_right_single', 'Your Ad Code', 'Active'),
(5, 'wide_skyscraper', 'Your Ad Code', 'Inactive'),
(7, 'player_bottom', 'Your Ad Code', 'Active');
Bookmarks