Просмотр файла sgb/gb.sql

#
# Структура таблицы `ban`
#

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 AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Структура таблицы `nline`
#

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 AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Структура таблицы `recs`
#

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 AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Структура таблицы `users`
#

CREATE TABLE `users` (
  `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',
  `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 AUTO_INCREMENT=1 ;