View file magic_us/sql.sql

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;