Просмотр архива Долина сражений

DROP TABLE IF EXISTS `ban_list`;

CREATE TABLE `ban_list` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `about`
varchar(255) DEFAULT NULL,
  `time_end` varchar(255) DEFAULT NULL,
  `adm`
varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `avtorlogin` varchar(244) NOT
NULL,
  `avtor` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
`msg` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `clan`;

CREATE TABLE `clan` (
 
`id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
 
`opis` varchar(120) NOT NULL,
  `rating` varchar(120) NOT NULL DEFAULT
'0',
  `max_user` int(11) NOT NULL DEFAULT '0',
  `exp` int(12) NOT NULL
DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `lider` int(12) NOT
NULL,
  `def` int(12) NOT NULL DEFAULT '0',
  `avatar` int(2) NOT NULL
DEFAULT '0',
  `time_creat` int(12) NOT NULL,
  `gold` int(11) NOT NULL
DEFAULT '0',
  `cristal` int(11) NOT NULL DEFAULT '0',
  `work` int(11) NOT
NULL DEFAULT '0',
  `svit` int(11) NOT NULL DEFAULT '0',
  `log` int(11)
NOT NULL DEFAULT '0',
  `buil` int(11) DEFAULT '0',
  `min_def` int(11)
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `clan_chat`;

CREATE TABLE
`clan_chat` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `msg` varchar(100)
NOT NULL,
  `clan` int(11) NOT NULL,
  `avtor` int(12) NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `clan_inv`;

CREATE TABLE
`clan_inv` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `user_id` int(11)
NOT NULL,
  `clan` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `clan_log`;

CREATE TABLE `clan_log` (
  `id` int(12) NOT
NULL AUTO_INCREMENT,
  `clan_id` int(11) NOT NULL,
  `text` varchar(500)
NOT NULL,
  `time` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`exp`;

CREATE TABLE `exp` (
  `level` int(11) NOT NULL,
  `exp` int(11)
NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO exp
VALUES("1","5");
INSERT INTO exp
VALUES("2","10");
INSERT INTO exp
VALUES("3","30");
INSERT INTO exp
VALUES("4","40");
INSERT INTO exp
VALUES("5","50");
INSERT INTO exp
VALUES("6","1000");
INSERT INTO exp
VALUES("7","1200");
INSERT INTO exp
VALUES("8","1500");
INSERT INTO exp
VALUES("9","1700");
INSERT INTO exp
VALUES("10","10000");
INSERT INTO exp
VALUES("11","2200");
INSERT INTO exp
VALUES("12","2400");
INSERT INTO exp
VALUES("13","2500");
INSERT INTO exp
VALUES("14","2700");
INSERT INTO exp
VALUES("15","3000");
INSERT INTO exp
VALUES("16","3100");
INSERT INTO exp
VALUES("17","3500");
INSERT INTO exp
VALUES("18","4100");
INSERT INTO exp
VALUES("19","4500");
INSERT INTO exp
VALUES("20","5000");
INSERT INTO exp
VALUES("21","5100");
INSERT INTO exp
VALUES("22","5400");
INSERT INTO exp
VALUES("23","6000");
INSERT INTO exp
VALUES("24","7000");
INSERT INTO exp
VALUES("25","10000");
INSERT INTO exp
VALUES("26","13000");
INSERT INTO exp
VALUES("27","15000");
INSERT INTO exp
VALUES("28","17000");
INSERT INTO exp
VALUES("28","18000");
INSERT INTO exp
VALUES("29","25000");
INSERT INTO exp
VALUES("30","30000");
INSERT INTO exp
VALUES("31","40000");
INSERT INTO exp
VALUES("32","50000");
INSERT INTO exp
VALUES("33","60000");
INSERT INTO exp
VALUES("34","70000");
INSERT INTO exp
VALUES("35","80000");
INSERT INTO exp
VALUES("36","90000");
INSERT INTO exp
VALUES("37","100000");
INSERT INTO exp
VALUES("38","150000");
INSERT INTO exp
VALUES("39","200000");
INSERT INTO exp
VALUES("40","500000");



DROP TABLE IF EXISTS
`forum_post`;

CREATE TABLE `forum_post` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `msg` varchar(10024) DEFAULT NULL,
  `time` int(11) NOT
NULL,
  `id_user` int(11) NOT NULL,
  `id_tema` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `forum_razdel`;

CREATE TABLE `forum_razdel` (
  `id`
int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `mod`
int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5
DEFAULT CHARSET=utf8;

INSERT INTO forum_razdel
VALUES("1","Предложения по
игре","0");
INSERT INTO forum_razdel
VALUES("2","Ошибки в
игре","0");
INSERT INTO forum_razdel
VALUES("3","Кланы","0");
INSERT INTO
forum_razdel
VALUES("4","Вопрос-ответ","0");



DROP
TABLE IF EXISTS `forum_tema`;

CREATE TABLE `forum_tema` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(10024) DEFAULT NULL,
  `msg`
varchar(10024) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `id_user` int(11)
NOT NULL,
  `id_razdel` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `inventar`;

CREATE TABLE `inventar` (
  `id` int(12) NOT NULL
AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `class` int(12) NOT NULL,

 `sila` int(12) NOT NULL,
  `lovk` int(12) NOT NULL,
  `def` int(12) NOT
NULL,
  `hp` int(12) NOT NULL,
  `id_user` int(12) NOT NULL,
  `img`
varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL,
  `id_resa` int(12)
NOT NULL,
  `level` int(12) NOT NULL,
  `up` int(11) NOT NULL DEFAULT '0',

 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `kont`;

CREATE TABLE `kont` (
 
`id_user` int(11) NOT NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11)
NOT NULL,
  `new_msg` int(11) NOT NULL DEFAULT '0',
  `name` varchar(64)
DEFAULT NULL,
  UNIQUE KEY `id_user` (`id_user`,`id_kont`),
  KEY `time`
(`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`mail`;

CREATE TABLE `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11)
NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `read` set('0','1') NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`,`id_kont`),
 
KEY `read` (`read`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
 
`id` int(12) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
 
`text` varchar(500) NOT NULL,
  `time` int(12) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `pets`;

CREATE TABLE `pets` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `hp` int(11) DEFAULT '0',
  `max_hp` int(11) DEFAULT
'0',
  `sila` int(11) DEFAULT '0',
  `def` int(11) DEFAULT '0',
  `name`
varchar(50) NOT NULL,
  `img` int(11) DEFAULT '0',
  `cena` int(11) DEFAULT
'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT
CHARSET=utf8;

INSERT INTO pets
VALUES("2","100","100","10","10","Ящер","1","1000");
INSERT
INTO pets
VALUES("3","500","500","100","100","Варг","2","5000");



DROP
TABLE IF EXISTS `pets_user`;

CREATE TABLE `pets_user` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `hp` int(11) DEFAULT '0',
  `name` varchar(50) NOT
NULL,
  `max_hp` int(11) DEFAULT '0',
  `sila` int(11) DEFAULT '0',
  `def`
int(11) DEFAULT '0',
  `img` int(11) DEFAULT '0',
  `user` int(11) DEFAULT
'0',
  `open` set('open','close') NOT NULL DEFAULT 'close',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `premium`;

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




DROP TABLE IF EXISTS
`smile`;

CREATE TABLE `smile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(50) NOT NULL,
  `img` varchar(100) DEFAULT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

INSERT
INTO smile
VALUES("2",":1","http://warhis.ru/style/smile/1.png");
INSERT
INTO smile
VALUES("3",":2","http://warhis.ru/style/smile/2.png");
INSERT
INTO smile
VALUES("4",":3","http://warhis.ru/style/smile/3.png");
INSERT
INTO smile
VALUES("8",":4","http://warhis.ru/style/smile/4.png");
INSERT
INTO smile
VALUES("9",":5","http://warhis.ru/style/smile/5.png");
INSERT
INTO smile
VALUES("10",":6","http://warhis.ru/style/smile/6.png");
INSERT
INTO smile
VALUES("11",":7","http://warhis.ru/style/smile/7.png");
INSERT
INTO smile
VALUES("12",":8","http://warhis.ru/style/smile/8.png");
INSERT
INTO smile
VALUES("13",":9","http://warhis.ru/style/smile/9.png");
INSERT
INTO smile
VALUES("14",":10","http://warhis.ru/style/smile/10.png");
INSERT
INTO smile
VALUES("15",":11","http://warhis.ru/style/smile/11.png");



DROP
TABLE IF EXISTS `trade`;

CREATE TABLE `trade` (
  `id` int(12) NOT NULL
AUTO_INCREMENT,
  `class` int(12) NOT NULL,
  `name` varchar(50) NOT NULL,

 `sila` int(12) NOT NULL DEFAULT '0',
  `lovk` int(12) NOT NULL DEFAULT
'0',
  `def` int(12) NOT NULL DEFAULT '0',
  `hp` int(12) NOT NULL DEFAULT
'0',
  `cena` int(12) NOT NULL,
  `url` varchar(50) NOT NULL,
  `level`
int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6
DEFAULT CHARSET=utf8;

INSERT INTO trade
VALUES("1","3","Меч
новичка","50","50","50","50","100","style/items/1.png","1");
INSERT
INTO trade VALUES("2","4","Кираса
новичка","50","50","50","50","100","style/items/2.png","1");
INSERT
INTO trade VALUES("3","2","Щит
новичка","50","50","50","50","100","style/items/3.png","1");
INSERT
INTO trade VALUES("4","1","Шлем
новичка","50","50","50","50","100","style/items/4.png","1");
INSERT
INTO trade VALUES("5","5","Ботинки
новичка","50","50","50","50","100","style/items/5.png","1");



DROP
TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `hp` int(11) DEFAULT '0',
  `max_hp` int(11) DEFAULT
'0',
  `sila` int(11) DEFAULT '0',
  `lovk` int(11) DEFAULT '0',
  `def`
int(11) DEFAULT '0',
  `sex` set('w','m') NOT NULL DEFAULT 'm',
  `side`
set('paladins','mer','magic') NOT NULL DEFAULT 'mer',
  `gold` int(11)
DEFAULT '0',
  `cristal` int(11) DEFAULT '0',
  `exp` int(11) DEFAULT '0',

 `avatar` int(11) DEFAULT '0',
  `online` int(11) NOT NULL,
  `reg` int(11)
NOT NULL,
  `pass` varchar(50) NOT NULL,
  `login` varchar(50) NOT NULL,
 
`level` int(11) NOT NULL DEFAULT '0',
  `energy` int(11) NOT NULL DEFAULT
'0',
  `max_energy` int(11) NOT NULL DEFAULT '0',
  `bait` int(11) NOT NULL
DEFAULT '0',
  `skin` int(11) NOT NULL DEFAULT '0',
  `sh_sila` int(11) NOT
NULL DEFAULT '0',
  `sh_lovk` int(11) NOT NULL DEFAULT '0',
  `sh_def`
int(11) NOT NULL DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
 
`log` int(11) NOT NULL DEFAULT '0',
  `moder` int(11) NOT NULL DEFAULT
'0',
  `clan` int(11) NOT NULL DEFAULT '0',
  `clan_dol` int(11) NOT NULL
DEFAULT '0',
  `rudnik` enum('0','1') NOT NULL,
  `grass` int(11) DEFAULT
'0',
  `chat_online` int(11) DEFAULT '0',
  `bonus` int(11) NOT NULL
DEFAULT '0',
  `bonus_time` int(11) NOT NULL DEFAULT '0',
  `town` int(11)
NOT NULL DEFAULT '0',
  `rang_row` int(11) NOT NULL DEFAULT '0',
 
`time_regen` int(11) NOT NULL DEFAULT '0',
  `start_quest` int(11) NOT NULL
DEFAULT '0',
  `arrow` int(11) NOT NULL DEFAULT '0',
  `otm` int(11) NOT
NULL DEFAULT '0',
  `lev_roz` int(11) NOT NULL DEFAULT '0',
  `hook`
int(11) NOT NULL DEFAULT '0',
  `energy_time` int(11) NOT NULL DEFAULT
'0',
  `premka` int(11) DEFAULT NULL,
  `exp_premka` int(11) DEFAULT NULL,

 `secret` text,
  `msg_close` text,
  `color` text,
  `news_status` text,
 
`param` text,
  PRIMARY KEY (`id`),
  KEY `moder` (`moder`)
) ENGINE=InnoDB
AUTO_INCREMENT=154 DEFAULT CHARSET=utf8;