Просмотр архива Кровавые земли (NEW)

DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `support` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`contacts`;

CREATE TABLE `contacts` (
  `user` int(11) NOT NULL DEFAULT
'0',
  `ho` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT
'0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS
`mail`;

CREATE TABLE `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`from` int(11) NOT NULL DEFAULT '0',
  `to` int(11) NOT NULL DEFAULT '0',
 
`text` text,
  `time` int(11) NOT NULL DEFAULT '0',
  `read` enum('0','1')
NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text,
  `time` int(11) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(100) DEFAULT NULL,

 `password` varchar(100) DEFAULT NULL,
  `money` int(64) DEFAULT '0',
 
`avatar` int(11) DEFAULT '1',
  `sila` int(11) DEFAULT '0',
  `zahita`
int(11) DEFAULT '0',
  `level` int(11) DEFAULT '1',
  `exp` int(11) DEFAULT
'0',
  `ban` int(11) DEFAULT '0',
  `online` int(11) DEFAULT '0',
 
`secret_password` text,
  `ip` text,
  `reg_time` int(11) DEFAULT '0',
 
`skill` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;