Просмотр архива Клуб магии

CREATE TABLE IF NOT EXISTS `magics` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_з` int(11) NOT
NULL,
  `id_p` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8
;



INSERT INTO `magics` (`id`, `id_user`, `id_з`, `id_p`, `time`)
VALUES
(7, 27, 0, 270, 1400419691);


CREATE TABLE IF NOT EXISTS
`magics_dir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=16 ;

-

INSERT INTO `magics_dir` (`id`,
`name`) VALUES
(1, 'Волшебные маги');


CREATE TABLE IF
NOT EXISTS `magics_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_dir` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `prise`
int(11) NOT NULL,
  `url` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=271 ;



INSERT
INTO `magics_list` (`id`, `id_dir`, `name`, `prise`, `url`) VALUES
(270,
1, 'Доблесный маг', 1, '/magic_us/img/270.gif');



ALTER
TABLE `user` ADD `magic_all` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD
`magic_bolt` VARCHAR( 150 ) NOT NULL;

ALTER TABLE `user` ADD
`magic_kold` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `magic_zakold`
INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `leksir` INT( 11 ) NOT
NULL;
ALTER TABLE `user` ADD `palin` INT( 11 ) NOT NULL;
ALTER TABLE
`user` ADD `matimat` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `ambroz`
INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `podor` INT( 11 ) NOT
NULL;

ALTER TABLE `user` ADD `rubin` INT( 11 ) NOT NULL;
ALTER TABLE
`user` ADD `klu4z` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `klu4s` INT(
11 ) NOT NULL;
ALTER TABLE `user` ADD `klu4b` INT( 11 ) NOT NULL;
ALTER
TABLE `user` ADD `posox` INT( 11 ) NOT NULL;

ALTER TABLE `user` ADD
`med1` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `med2` INT( 11 ) NOT
NULL;
ALTER TABLE `user` ADD `med3` INT( 11 ) NOT NULL;
ALTER TABLE
`user` ADD `med4` INT( 11 ) NOT NULL;