Просмотр файла gbs/base.txt

Размер файла: 1.33Kb
CREATE TABLE `recs` (
  `id` int(255) NOT NULL auto_increment,
  `gid` int(20) NOT NULL default '0',
  `login` text NOT NULL,
  `msg` text NOT NULL,
  `otvet` text NOT NULL,
  `email` text NOT NULL,
  `ip` text NOT NULL,
  `brows` text NOT NULL,
  `time` text NOT NULL,
  `time2` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



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

CREATE TABLE `gbsusers` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `msgs` text NOT NULL,
  `pass` text NOT NULL,
  `email` text NOT NULL,
  `link` text NOT NULL,
  `sitename` text NOT NULL,
  `date` text NOT NULL,
  `razdel` text NOT NULL,
  `fsize` text NOT NULL,
  `komp` int(2) NOT NULL default '0',
  `proxy` int(2) NOT NULL default '0',
  `antiadv` tinyint(1) NOT NULL default '1',
  `verh` text NOT NULL,
  `niz` text NOT NULL,
  `lbrowser` text NOT NULL,
  `lip` text NOT NULL,
  `ltime` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `ban` (
  `id` int(11) NOT NULL auto_increment,
  `gid` int(11) NOT NULL default '0',
  `ip` text NOT NULL,
  `brows` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;