Просмотр архива Клон tak.ru|

CREATE TABLE `forum` (
  `id` int(10) NOT NULL auto_increment,
  `uid`
int(10) NOT NULL,
  `date` varchar(20) NOT NULL,
  `name` varchar(50) NOT
NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE
`forum_cat` (
  `id` int(10) NOT NULL auto_increment,
  `name`
varchar(50) NOT NULL,
  `text` varchar(100) NOT NULL,
  PRIMARY KEY 
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE `game` (
  `id` int(10) NOT NULL auto_increment,
 
`name` varchar(50) NOT NULL,
  `winball` varchar(255) NOT NULL,
  PRIMARY
KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE `mobile` (
  `id` int(10) NOT NULL auto_increment,
 
`uid` int(10) NOT NULL,
  `summ` int(10) NOT NULL,
  `oper` varchar(60)
NOT NULL,
  `nom` varchar(15) NOT NULL,
  PRIMARY KEY  (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE
`news` (
  `id` int(10) NOT NULL auto_increment,
  `date` varchar(15) NOT
NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE
`online` (
  `id` int(6) NOT NULL auto_increment,
  `ip` char(15) default
NULL,
  `brauz` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
 
UNIQUE KEY `id` (`id`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `user` (
  `id` int(10)
NOT NULL auto_increment,
  `login` varchar(20) NOT NULL,
  `pass`
varchar(20) NOT NULL,
  `email` varchar(60) NOT NULL,
  `wmr` varchar(15)
NOT NULL,
  `level` varchar(10) NOT NULL,
  `ban` varchar(10) NOT NULL,

 `ball` varchar(10) NOT NULL,
  `act` int(2) NOT NULL,
  `act_code`
int(15) NOT NULL,
  `z` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=1
;

CREATE TABLE `webmoney` (
  `id` int(10) NOT NULL auto_increment,
 
`uid` int(10) NOT NULL,
  `summ` int(10) NOT NULL,
  `wmr` varchar(15)
NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;