DROP TABLE IF EXISTS `s2_adsite`;
CREATE TABLE `s2_adsite` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `clicks_today` int(10) unsigned NOT NULL default '0',
  `clicks_all` int(10) unsigned NOT NULL default '0',
  `profit_today` float unsigned NOT NULL default '0',
  `profit_all` float unsigned NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=175 ;

DROP TABLE IF EXISTS `s2_advertisement`;
CREATE TABLE `s2_advertisement` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `price` float NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `clicks_today` int(10) unsigned NOT NULL default '0',
  `clicks_all` int(10) unsigned NOT NULL default '0',
  `expense_today` float unsigned NOT NULL default '0',
  `expense_all` float unsigned NOT NULL default '0',
  `reit_start` float unsigned NOT NULL default '0',
  `reit_end` float unsigned NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=26 ;

DROP TABLE IF EXISTS `s2_advertisement_statistics`;
CREATE TABLE `s2_advertisement_statistics` (
  `id_ad` int(10) unsigned NOT NULL default '0',
  `id_adsite` int(10) unsigned NOT NULL default '0',
  `income` float NOT NULL default '0',
  `outcome` float NOT NULL default '0',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ip` varchar(15) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;


DROP TABLE IF EXISTS `s2_cash_income`;
CREATE TABLE `s2_cash_income` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL default '0',
  `amount` float NOT NULL default '0',
  `confirm` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=12 ;

DROP TABLE IF EXISTS `s2_cash_outcome`;
CREATE TABLE `s2_cash_outcome` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `webmoneyid` varchar(255) NOT NULL default '',
  `amount` float NOT NULL default '0',
  `carryout` tinyint(1) NOT NULL default '0',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21 ;


DROP TABLE IF EXISTS `s2_competition`;
CREATE TABLE `s2_competition` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `stat` float NOT NULL default '0',
  `amount` float NOT NULL default '0',
  `place` tinyint(2) NOT NULL default '0',
  `confirmed` tinyint(1) NOT NULL default '0',
  `who` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

DROP TABLE IF EXISTS `s2_message`;
CREATE TABLE `s2_message` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;

DROP TABLE IF EXISTS `s2_user`;
CREATE TABLE `s2_user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_referal` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `mail` varchar(255) NOT NULL default '',
  `balance` float NOT NULL default '0',
  `ref_profit` float unsigned NOT NULL default '0',
  `webmoneyid` varchar(255) NOT NULL default '',
  `date_reg` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `enable_mail` tinyint(1) NOT NULL default '0',
  `banned` varchar(3) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=258 ;

DROP TABLE IF EXISTS `s2_user_bhistory`;
CREATE TABLE `s2_user_bhistory` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `income` float NOT NULL default '0',
  `outcome` float NOT NULL default '0',
  `balance` float NOT NULL default '0',
  `target` varchar(255) NOT NULL default '',
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2055 ;

DROP TABLE IF EXISTS `s2_user_mess`;
CREATE TABLE `s2_user_mess` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_sender` int(10) unsigned NOT NULL default '0',
  `id_recipient` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `status` tinyint(2) unsigned NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;