1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
|
DROP TABLE IF EXISTS `bb1_ads`;
CREATE TABLE `bb1_ads` (
`adid` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '0',
`kategorie` int(2) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`bannerurl` varchar(255) NOT NULL default '',
`code` text NOT NULL,
`alt` varchar(255) NOT NULL default '',
`hyperlink` varchar(255) NOT NULL default '',
`target` int(1) NOT NULL default '',
`views_available` int(11) NOT NULL default '0',
`views_used` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`klicks_available` int(11) NOT NULL default '0',
`klicks_used` int(11) NOT NULL default '0',
`verhaeltnis` int(3) NOT NULL default '0',
PRIMARY KEY (`adid`)
) TYPE=MyISAM;
INSERT INTO `bb1_ads` VALUES ('', 'PyroGX', 1, 1, 'http://www.ruhrpottforum.de/banner/pyrogx.jpg', '', 'PyroGX.de', 'http://www.pyrogx.de', 1, 0, 0, 0, 0, 0, 1);
INSERT INTO `bb1_ads` VALUES ('', 'RPF', 1, 1, 'http://www.ruhrpottforum.de/banner/rpf-1.jpg', '', 'Ruhrpottforum.de', 'http://www.ruhrpottforum.de', 1, 0, 0, 0, 0, 0, 1); |