CREATE TABLE users (
  id int(11) NOT NULL IDENTITY IDENTITY(1,1),
  immunity tinyint(1) NOT NULL,
  name varchar(20) NOT NULL,
  tarif ntext NOT NULL,
  goden_do ntext NOT NULL,
  bank int(111) NOT NULL default '21',
  last_krut ntext NOT NULL,
  krut_day ntext NOT NULL,
  krut ntext NOT NULL,
  name_lat varchar(40) NOT NULL,
  password varchar(32) NOT NULL,
  from ntext NOT NULL,
  imname varchar(35) NOT NULL,
  sex char(2) NOT NULL,
  komm int(10) NOT NULL default '0',
  postforum int(10) NOT NULL default '0',
  postchat int(10) NOT NULL default '0',
  otvetov int(11) NOT NULL default '0',
  yearofbirth int(4) NOT NULL,
  datereg int(11) NOT NULL,
  lastdate int(11) NOT NULL,
  mail varchar(50) NOT NULL,
  icq int(9) NOT NULL,
  skype varchar(50) NOT NULL,
  jabber varchar(50) NOT NULL,
  www varchar(50) NOT NULL,
  about ntext NOT NULL,
  live varchar(50) NOT NULL,
  mibile varchar(50) NOT NULL,
  rights int(1) NOT NULL,
  status ntext NOT NULL,
  ip varchar(25) NOT NULL,
  browser ntext NOT NULL,
  timererfesh int(2) NOT NULL default '20',
  kolanywhwere int(2) NOT NULL default '10',
  time int(11) NOT NULL,
  preg binary(1) NOT NULL default '0',
  regadm varchar(25) NOT NULL,
  kod int(15) NOT NULL,
  mailact binary(1) NOT NULL default '0',
  mailvis binary(1) NOT NULL default '0',
  dayb int(2) NOT NULL,
  monthb int(2) NOT NULL,
  sdvig int(2) NOT NULL default '0',
  offpg tinyint(1) NOT NULL default '0',
  offgr tinyint(1) NOT NULL default '0',
  offsm tinyint(1) NOT NULL default '1',
  offtr tinyint(1) NOT NULL default '1',
  pereh tinyint(1) NOT NULL default '1',
  nastroy ntext NOT NULL,
  plus int(3) NOT NULL,
  minus int(3) NOT NULL,
  vrrat int(11) NOT NULL,
  upfp tinyint(1) NOT NULL default '0',
  farea tinyint(1) NOT NULL default '0',
  chmes int(2) NOT NULL default '10',
  nmenu ntext NOT NULL,
  carea tinyint(1) NOT NULL default '0',
  alls varchar(25) NOT NULL default '',
  balans int(11) NOT NULL,
  sestime int(15) NOT NULL,
  total_on_site int(11) NOT NULL default '0',
  digest tinyint(4) NOT NULL default '1',
  skin varchar(15) NOT NULL,
  lastpost int(11) NOT NULL,
  mailcheck ntext NOT NULL,
  reputation int(11) NOT NULL,
  PRIMARY KEY  (id),
  KEY name_lat (name_lat),
  KEY lastdate (lastdate)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=747 ;