Просмотр архива противостояние

CREATE TABLE IF NOT EXISTS `demons_battles` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `stage` varchar(255) NOT NULL DEFAULT 'mobs',
 
`status` varchar(255) NOT NULL DEFAULT 'prepare',
  `killboss` int(11) NOT
NULL,
  `firstinfo` varchar(255) NOT NULL,
  `secondinfo` varchar(255)
NOT NULL,
  `thirdinfo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT
EXISTS `demons_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`battle` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `health` int(11)
NOT NULL,
  `heal_cd` int(11) NOT NULL,
  `arrow_cd` int(11) NOT NULL,
 
`attack_cd` int(11) NOT NULL,
  `damage` int(11) NOT NULL DEFAULT '0',
 
`count` int(11) NOT NULL DEFAULT '0'
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS
`demons_mobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle`
int(11) NOT NULL,
  `health` int(11) NOT NULL,
  `attack` int(11) NOT
NULL,
  `defense` int(11) NOT NULL,
  `stage` varchar(255) NOT NULL
default 'mobs',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;