CREATE TABLE 'gorod' (
  'id' int(11) NOT NULL auto_increment,
  'refid' int(11) NOT NULL default '0',
  'type' char(1) NOT NULL default '',
  'user_id' int(11) NOT NULL,
  'realid' int(3) NOT NULL default '0',
  'text' text NOT NULL,
  PRIMARY KEY  ('id'),
  KEY 'refid' ('refid'),
  KEY 'type' ('type'),
  KEY 'user_id' ('user_id')
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;