Update
ALTER TABLE sys_creditsexchange ADD m8 FLOAT(10,5) UNSIGNED NOT NULL;
DROP TABLE IF EXISTS i_banner;
CREATE TABLE i_banner ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', obid mediumint(8) unsigned NOT NULL auto_increment, gehostet tinyint(3) unsigned NOT NULL default '0', url varchar(255) NOT NULL default '', views mediumint(8) unsigned NOT NULL default '0', klicks smallint(5) unsigned NOT NULL default '0', banner varchar(255) NOT NULL default '', pixel varchar(10) NOT NULL default '', kat tinyint(3) unsigned NOT NULL default '0', hstart tinyint(3) unsigned NOT NULL default '0', hend tinyint(3) unsigned NOT NULL default '0', lastcontrol datetime NOT NULL default '0000-00-00 00:00:00', last timestamp(14) NOT NULL, hash varchar(200) NOT NULL default '', PRIMARY KEY (obid), KEY bid (bid), KEY bid_2 (bid,pixel,kat), KEY pixel (pixel,kat)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_ipklick;
CREATE TABLE i_ipklick ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', wann datetime NOT NULL default '0000-00-00 00:00:00', pixel char(7) NOT NULL default '', ip char(15) NOT NULL default '', KEY bid (bid,ip), KEY wann (wann)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_ipsperre;
CREATE TABLE i_ipsperre ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', pixel char(7) NOT NULL default '', wann datetime NOT NULL default '0000-00-00 00:00:00', abid mediumint(8) unsigned NOT NULL default '0', aobid mediumint(8) unsigned NOT NULL default '0', ip char(15) NOT NULL default '', sponsor tinyint(3) unsigned NOT NULL default '0', uid char(23) NOT NULL default '0', KEY bid (bid,ip,pixel), KEY wann (wann)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_pixel;
CREATE TABLE i_pixel ( pixel varchar(10) NOT NULL default '', url varchar(255) NOT NULL default '', banner varchar(255) NOT NULL default '', gehostet tinyint(3) unsigned NOT NULL default '0', art tinyint(3) unsigned NOT NULL default '0', htmlo text NOT NULL, htmlu text NOT NULL, noscript tinyint(3) unsigned NOT NULL default '0', viewstot int(10) unsigned NOT NULL default '0', multi float NOT NULL default '0', maxkb smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (pixel)) TYPE=MyISAM;
INSERT INTO i_pixel VALUES ('468x60', '
http://www.webmasterpark.net/', '
http://www.webmasterpark.net/img/banner/468_g.gif', 0, 3, '', '', 1, 6, '1', 20);
DROP TABLE IF EXISTS i_preise;
CREATE TABLE i_preise ( pid tinyint(3) unsigned NOT NULL auto_increment, art tinyint(3) unsigned NOT NULL default '0', preis float NOT NULL default '0', anzahl mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (pid)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_sponbanner;
CREATE TABLE i_sponbanner ( sid smallint(5) unsigned NOT NULL default '0', kid smallint(5) unsigned NOT NULL default '0', obid mediumint(8) unsigned NOT NULL auto_increment, gehostet tinyint(3) unsigned NOT NULL default '0', url varchar(255) NOT NULL default '', views mediumint(8) unsigned NOT NULL default '0', klicks mediumint(8) unsigned NOT NULL default '0', banner varchar(255) NOT NULL default '', pixel varchar(10) NOT NULL default '', kat tinyint(3) unsigned NOT NULL default '0', hstart tinyint(3) unsigned NOT NULL default '0', hend tinyint(3) unsigned NOT NULL default '0', lastcontrol datetime NOT NULL default '0000-00-00 00:00:00', last timestamp(14) NOT NULL, hash varchar(200) NOT NULL default '', PRIMARY KEY (obid), KEY pixel (pixel,kat), KEY kid (kid)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_sponsoren;
CREATE TABLE i_sponsoren ( sid smallint(5) unsigned NOT NULL default '0', kid smallint(5) unsigned NOT NULL auto_increment, name varchar(150) NOT NULL default '', status tinyint(3) unsigned NOT NULL default '0', viewsge mediumint(8) unsigned NOT NULL default '0', klicksge mediumint(8) unsigned NOT NULL default '0', views mediumint(8) unsigned NOT NULL default '0', klicks mediumint(8) unsigned NOT NULL default '0', last timestamp(14) NOT NULL, PRIMARY KEY (kid)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_sponstat;
CREATE TABLE i_sponstat ( sid smallint(5) unsigned NOT NULL default '0', kid smallint(5) unsigned NOT NULL default '0', datum date NOT NULL default '0000-00-00', stunde tinyint(3) unsigned NOT NULL default '0', views smallint(5) unsigned NOT NULL default '0', klicks smallint(5) unsigned NOT NULL default '0', kat tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (kid,datum,stunde,kat)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_user;
CREATE TABLE i_user (id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL auto_increment, url varchar(255) NOT NULL default '', kat tinyint(3) unsigned NOT NULL default '0', status tinyint(3) unsigned NOT NULL default '0', views mediumint(8) unsigned NOT NULL default '0', klicks mediumint(8) unsigned NOT NULL default '0', verdient float(10,5) unsigned NOT NULL default '0.00000', credits float(10,5) unsigned NOT NULL default '0.00000', last timestamp(14) NOT NULL, bviews mediumint(8) unsigned NOT NULL default '0', bklicks mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (bid), KEY id (id), KEY bid (bid,credits,status)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_user_refs;
CREATE TABLE i_user_refs ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', ref varchar(250) NOT NULL default '0', count smallint(5) unsigned NOT NULL default '0', KEY bid (bid), KEY bid_2 (bid,ref(30))) TYPE=MyISAM;
DROP TABLE IF EXISTS i_usermonstat;
CREATE TABLE i_usermonstat ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', monat tinyint(3) unsigned NOT NULL default '0', jahr smallint(5) unsigned NOT NULL default '0', views mediumint(8) unsigned NOT NULL default '0', klicks mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (bid,monat,jahr)) TYPE=MyISAM;
DROP TABLE IF EXISTS i_userstat;
CREATE TABLE i_userstat ( id mediumint(8) unsigned NOT NULL default '0', bid mediumint(8) unsigned NOT NULL default '0', datum date NOT NULL default '0000-00-00', stunde tinyint(3) unsigned NOT NULL default '0', views smallint(5) unsigned NOT NULL default '0', klicks smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (bid,datum,stunde)) TYPE=MyISAM;