SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Table structure for table `adv`
--

DROP TABLE IF EXISTS `adv`;
CREATE TABLE IF NOT EXISTS `adv` (
  `aid` int(11) NOT NULL auto_increment,
  `rid` int(11) NOT NULL,
  `acode` text NOT NULL,
  `atargeturl` text NOT NULL,
  `atargetnw` tinyint(1) NOT NULL default '0',
  `aimageurl` text NOT NULL,
  `astatus` tinyint(1) NOT NULL default '0',
  `atype` tinyint(1) NOT NULL default '0',
  `atime` int(11) NOT NULL,
  `aimp` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `rid` (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `adv`
--

INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(16, 2, '<a href="http://secure.hostgator.com/~affiliat/cgi-bin/affiliates/clickthru.cgi?id=fantasy-esoft"><img src="http://tracking.hostgator.com/img/WordPress_Hosting/728x90-animated.gif" border=0></a>', '', 0, '', 1, 1, 1304698362, 0);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(9, 1, '', 'http://secure.hostgator.com/~affiliat/cgi-bin/affiliates/clickthru.cgi?id=fantasy-esoft', 1, 'http://tracking.hostgator.com/img/Shared_Blue/468x60-animated.gif', 1, 0, 1304352255, 37);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(10, 1, '<a href="http://www.e-soft24.com/" target="_blank"><img src="http://www.e-soft24.com/banner/468x60.gif" alt="PHP Scripts and Service for you" border="0"></a>', '', 0, '', 1, 1, 1304352255, 14);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(12, 1, '<a href="http://www.great-scripts.com" target="_blank"><img src="http://www.great-scripts.com/banner/animated1_468x60-2.gif" alt="Script Directory & Web Resource" border="0"></a>', '', 0, '', 1, 1, 1304436373, 12);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(13, 1, '<a href="http://www.clipmoon.com/" target="_blank"><img src="http://www.clipmoon.com/images/clipmoon_468x60.gif" alt="ClipMoon-Share your videos with the world" border="0"></a>', '', 0, '', 1, 1, 1304436556, 6);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(14, 2, '<a href="http://www.e-soft24.com/" target="_blank"><img src="http://www.e-soft24.com/banner/728x90.gif" alt="PHP Scripts and Custom Service" border="0"></a>', '', 0, '', 1, 1, 1304436864, 6);
INSERT INTO `adv` (`aid`, `rid`, `acode`, `atargeturl`, `atargetnw`, `aimageurl`, `astatus`, `atype`, `atime`, `aimp`) VALUES(15, 2, '<a href="http://secure.hostgator.com/~affiliat/cgi-bin/affiliates/clickthru.cgi?id=fantasy-esoft"><img src="http://tracking.hostgator.com/img/Shared_Green/728x90-animated.gif" border=0></a>', '', 0, '', 1, 1, 1304436920, 8);

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

--
-- Table structure for table `rotator`
--

DROP TABLE IF EXISTS `rotator`;
CREATE TABLE IF NOT EXISTS `rotator` (
  `rid` int(11) NOT NULL auto_increment,
  `rname` varchar(100) NOT NULL,
  `rdesc` varchar(255) NOT NULL,
  `rtime` int(11) NOT NULL,
  `sid` int(5) NOT NULL,
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `rotator`
--

INSERT INTO `rotator` (`rid`, `rname`, `rdesc`, `rtime`, `sid`) VALUES(1, 'Rotator 1', 'Example Description', 1304352255, 8);
INSERT INTO `rotator` (`rid`, `rname`, `rdesc`, `rtime`, `sid`) VALUES(2, 'Rotator 2', 'Example Description', 1304438655, 15);

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `soption` varchar(60) NOT NULL,
  `svalue` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`soption`, `svalue`) VALUES('admin_name', 'admin');
INSERT INTO `settings` (`soption`, `svalue`) VALUES('admin_pass', '21232f297a57a5a743894a0e4a801fc3');
INSERT INTO `settings` (`soption`, `svalue`) VALUES('site_name', 'My Ad Management');

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

--
-- Table structure for table `size`
--

DROP TABLE IF EXISTS `size`;
CREATE TABLE IF NOT EXISTS `size` (
  `sid` int(5) NOT NULL auto_increment,
  `adsize` varchar(8) NOT NULL,
  `sizename` varchar(20) NOT NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `size`
--

INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(1, '300x250', 'Medium Rectangle');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(2, '250x250', 'Square Pop-Up');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(3, '240x400', 'Vertical Rectangle');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(4, '336x280', 'Large Rectangle');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(5, '180x150', 'Rectangle');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(6, '300x100', '3:1 Rectangle');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(8, '468x60', 'Full Banner');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(9, '234x60', 'Half Banner');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(10, '88x31', 'Micro Bar');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(11, '120x90', 'Button 1');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(12, '120x60', 'Button 2');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(13, '120x240', 'Vertical Banner');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(14, '125x125', 'Square Button');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(15, '728x90', 'Leaderboard');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(16, '160x600', 'Wide Skyscraper');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(17, '120x600', 'Skyscraper');
INSERT INTO `size` (`sid`, `adsize`, `sizename`) VALUES(18, '300x600', 'Half Page Ad');
