CREATE TABLE `love_user` (
  `id` int(11) NOT NULL auto_increment,
  `nick` varchar(255) NOT NULL default '0',
  `pas` varchar(255) NOT NULL default '0',
  `pol` INT(2) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '0',
  `god_r` INT(4) NOT NULL default '0',
  `mes_r` INT(2) NOT NULL default '0',
  `den_r` INT(2) NOT NULL default '0',
  `gorod` INT(255) NOT NULL default '0',
  `regdata` varchar(255) NOT NULL default '0',
  `foto` INT(255) NOT NULL default '0',
  `online` INT(1) NOT NULL default '0',
  `vozrast` INT(2) NOT NULL default '0',
  `ishu` INT(1) NOT NULL default '0',
  `strana` INT(1) NOT NULL default '0',
  `time` int(11) unsigned NOT NULL default '0',
  `ip` tinyblob NOT NULL,
  `ua` blob NOT NULL,
  `about` varchar(255) NOT NULL default '0',
  `rost` int(3) NOT NULL default '0',
  `ves` int(3) NOT NULL default '0',
  `cvolos` int(1) NOT NULL default '0',
  `telosl` int(1) NOT NULL default '0',
  `i_sex` varchar(255) NOT NULL default '0',
  `chlen_grud` int(1) NOT NULL default '0',
  `orient` int(1) NOT NULL default '0',
  `golos` int(255) NOT NULL default '0',
  `user_reg` varchar(255) NOT NULL default '',
  `gladmin` int(1) NOT NULL default '0',
  `bann` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `love_partner` (
  `partner` int(11) NOT NULL auto_increment,
  `log` varchar(255) NOT NULL default '0',
  `pass` varchar(255) NOT NULL default '0',
  `site` varchar(255) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`partner`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `love_nastr` (
  `id` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL,
  `ya_ishu` varchar(255) NOT NULL,
  `brak` int(1) NOT NULL,
  `sponsor` int(1) NOT NULL,
  `deti` int(1) NOT NULL,
  `zhel_vozr` int(2) NOT NULL,
  `cel_zn` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

CREATE TABLE `love_messages` (
  `id` int(10) NOT NULL auto_increment,
  `ids` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `login` varchar(100) NOT NULL,
  `msg` text NOT NULL,
  `time` varchar(50) NOT NULL,
  `reed` int(1) NOT NULL default '0',
  `time_del` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;
 
CREATE TABLE `love_golos` (
  `uid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  `ua` varchar(250) NOT NULL,
  PRIMARY KEY  (`uid`,`ip`)
) TYPE=MyISAM;

CREATE TABLE `love_anonim` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(255) NOT NULL default '',
  `ua` varchar(255) NOT NULL default '',
  `time` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

CREATE TABLE `love_count_today` (
  `uid` int(11) unsigned NOT NULL default '0',
  `date` int(11) unsigned NOT NULL default '0',
  `count` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `love_count_mes` (
  `uid` int(11) unsigned NOT NULL default '0',
  `date` int(11) unsigned NOT NULL default '0',
  `count` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM;

CREATE TABLE `love_support` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `tema` text NOT NULL,
  `email` text NOT NULL,
  `icq` text NOT NULL,
  `msg` text NOT NULL,
  `time` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;