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

DROP TABLE IF EXISTS `aliance`;

CREATE TABLE `aliance` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `rools`
varchar(100) NOT NULL,
  `data` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`aliance_forum_m`;

CREATE TABLE `aliance_forum_m` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `cid` varchar(100) NOT NULL,
  `uid` varchar(100)
NOT NULL,
  `player` varchar(100) NOT NULL,
  `time` varchar(255) NOT
NULL,
  `msg` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `aliance_forum_t`;

CREATE
TABLE `aliance_forum_t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid`
varchar(100) NOT NULL,
  `name` varchar(200) NOT NULL,
  `last`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `aliance_journal`;

CREATE TABLE
`aliance_journal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid`
varchar(100) NOT NULL,
  `msg` text NOT NULL,
  `data` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `carma`;

CREATE TABLE `carma` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `who` varchar(100) NOT NULL,
  `whom` varchar(100) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `user` varchar(100) NOT NULL,
  `msg` text NOT NULL,
 
`time` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `res` varchar(100) NOT NULL,
 
`crystal` varchar(100) NOT NULL,
  `online` varchar(100) NOT NULL,
 
`scout_percent` varchar(100) NOT NULL,
  `scout_recovery` varchar(100) NOT
NULL,
  `thief_percent` varchar(100) NOT NULL,
  `thief_recovery`
varchar(100) NOT NULL,
  `saboteur_percent` varchar(100) NOT NULL,
 
`saboteur_recovery` varchar(100) NOT NULL,
  `recruiter_percent`
varchar(100) NOT NULL,
  `recruiter_recovery` varchar(100) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;

INSERT INTO `config`
VALUES("1","600","10000","1","10","1000","10","1000","10","1000","10","1000");



DROP
TABLE IF EXISTS `construct`;

CREATE TABLE `construct` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `cid` varchar(100) NOT
NULL,
  `timeleft` varchar(100) NOT NULL,
  `stamp` varchar(255) NOT NULL,

 `maxlvl` varchar(100) NOT NULL,
  `uplvl` varchar(100) NOT NULL,
  `level`
varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `duty`;

CREATE TABLE `duty` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
 
`lot` varchar(100) NOT NULL,
  `timeleft` varchar(255) NOT NULL,
  `cid`
int(11) NOT NULL,
  `user` varchar(100) NOT NULL,
  `health` varchar(100)
NOT NULL,
  `power` varchar(100) NOT NULL,
  `defence` varchar(100) NOT
NULL,
  `speed` varchar(100) NOT NULL,
  `capacity` varchar(100) NOT NULL,

 `done` int(55) NOT NULL,
  `time_back` varchar(100) NOT NULL,
  `back`
varchar(100) NOT NULL,
  `run` varchar(100) NOT NULL,
  `time_run`
varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `forum_m`;

CREATE TABLE `forum_m`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` varchar(100) NOT NULL,
 
`uid` varchar(100) NOT NULL,
  `msg` text NOT NULL,
  `player` varchar(100)
NOT NULL,
  `time` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`forum_r`;

CREATE TABLE `forum_r` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`forum_t`;

CREATE TABLE `forum_t` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `uid` varchar(100) NOT NULL,
  `name` varchar(100) NOT
NULL,
  `last` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `generals`;

CREATE TABLE
`generals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player`
varchar(100) NOT NULL,
  `timeleft` varchar(100) NOT NULL,
  `level`
varchar(100) NOT NULL,
  `health` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`ignor`;

CREATE TABLE `ignor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`ig_id` varchar(100) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`kolces`;

CREATE TABLE `kolces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `player` varchar(100) NOT NULL,
  `kc` varchar(100) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`letters`;

CREATE TABLE `letters` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `who` varchar(100) NOT NULL,
  `idwho` varchar(100) NOT
NULL,
  `message` text NOT NULL,
  `data` varchar(255) NOT NULL,
  `read`
varchar(250) NOT NULL,
  `mod` varchar(200) NOT NULL DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`location`;

CREATE TABLE `location` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `pic` varchar(100) NOT NULL,
  `id_player` varchar(100)
NOT NULL,
  `x` varchar(100) NOT NULL,
  `y` varchar(100) NOT NULL,
 
`time` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
 
`text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `players_aliance`;

CREATE TABLE
`players_aliance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player`
varchar(100) NOT NULL,
  `uid` varchar(100) NOT NULL,
  `level`
varchar(255) NOT NULL,
  `moder` varchar(100) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `point_map`;

CREATE TABLE `point_map` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `uid` varchar(100) NOT NULL,
  `player` varchar(100) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `recruiters`;

CREATE TABLE
`recruiters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player`
varchar(100) NOT NULL,
  `timeleft` varchar(100) NOT NULL,
  `time_back`
varchar(100) NOT NULL,
  `run` varchar(100) NOT NULL,
  `black`
varchar(100) NOT NULL,
  `time_run` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`rialto`;

CREATE TABLE `rialto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `player` varchar(100) NOT NULL,
  `timeleft` varchar(100) NOT NULL,
 
`dealer` varchar(100) NOT NULL,
  `time_run` varchar(100) NOT NULL,
 
`time_back` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `saboteurs`;

CREATE TABLE
`saboteurs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player`
varchar(100) NOT NULL,
  `timeleft` varchar(100) NOT NULL,
  `health`
varchar(100) NOT NULL,
  `time_back` varchar(100) NOT NULL,
  `run`
varchar(100) NOT NULL,
  `time_run` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`scouts`;

CREATE TABLE `scouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `player` varchar(100) NOT NULL,
  `timeleft` varchar(100) NOT NULL,
 
`time_back` varchar(100) NOT NULL,
  `run` varchar(100) NOT NULL,
  `back`
varchar(100) NOT NULL,
  `time_run` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`temporary`;

CREATE TABLE `temporary` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `food` varchar(100) NOT NULL,
  `tree` varchar(100) NOT
NULL,
  `stone` varchar(100) NOT NULL,
  `ore` varchar(100) NOT NULL,
 
`gold` varchar(100) NOT NULL,
  `player` varchar(100) NOT NULL,
 
`timeleft` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `thiefs`;

CREATE TABLE
`thiefs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player` varchar(100)
NOT NULL,
  `timeleft` varchar(100) NOT NULL,
  `health` varchar(100) NOT
NULL,
  `time_recovery` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`upgraded_units`;

CREATE TABLE `upgraded_units` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `player` varchar(100) NOT NULL,
  `power` varchar(100)
NOT NULL,
  `uid` varchar(100) NOT NULL,
  `defence` varchar(100) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `login` varchar(100) NOT NULL,
  `password` varchar(100)
NOT NULL,
  `onl` varchar(100) NOT NULL,
  `visit` char(255) NOT NULL,
 
`soft` char(25) NOT NULL,
  `ip` int(5) NOT NULL DEFAULT '0',
  `date_reg`
int(11) NOT NULL DEFAULT '0',
  `on_time` int(11) NOT NULL DEFAULT '0',
 
`breach` int(11) NOT NULL DEFAULT '0',
  `ban` int(11) NOT NULL DEFAULT
'0',
  `why` char(50) NOT NULL,
  `nick` char(20) NOT NULL,
  `race`
smallint(1) NOT NULL DEFAULT '0',
  `food` int(11) NOT NULL DEFAULT '700',

 `tree` int(11) NOT NULL DEFAULT '700',
  `stone` int(11) NOT NULL DEFAULT
'700',
  `ore` int(11) NOT NULL DEFAULT '700',
  `gold` int(11) NOT NULL
DEFAULT '700',
  `time_later` int(11) NOT NULL DEFAULT '0',
  `time_duty`
int(11) NOT NULL DEFAULT '0',
  `timeleft` int(11) NOT NULL DEFAULT '0',
 
`where` char(15) NOT NULL,
  `level` smallint(1) NOT NULL DEFAULT '0',
 
`time_hunger` int(11) NOT NULL DEFAULT '0',
  `nmsg` smallint(2) NOT NULL
DEFAULT '10',
  `crystal` int(11) NOT NULL DEFAULT '0',
  `coor_x`
smallint(3) NOT NULL DEFAULT '0',
  `coor_y` smallint(3) NOT NULL DEFAULT
'0',
  `advisor` tinyint(4) NOT NULL DEFAULT '0',
  `time_run` int(11) NOT
NULL DEFAULT '0',
  `terrain` int(11) NOT NULL DEFAULT '0',
  `untouch`
int(11) NOT NULL DEFAULT '0',
  `carma` int(11) NOT NULL DEFAULT '0',
 
`avatar` char(40) NOT NULL,
  `name` char(15) NOT NULL,
  `city` char(20)
NOT NULL,
  `age` smallint(2) NOT NULL DEFAULT '0',
  `aboutme` char(255)
NOT NULL,
  `sex` tinyint(4) NOT NULL DEFAULT '0',
  `forever` tinyint(4)
NOT NULL DEFAULT '0',
  `email` char(50) NOT NULL,
  `recall` char(20) NOT
NULL,
  `kolcoy` varchar(100) NOT NULL,
  `kolcoo` varchar(100) NOT NULL,
 
`loks` varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`worldkassa`;

CREATE TABLE `worldkassa` (
  `id` int(11) unsigned NOT NULL
AUTO_INCREMENT COMMENT 'ID платежа (Внутренний ID)',
 
`id_user` int(11) unsigned NOT NULL COMMENT 'ID пользователя',

 `id_bill` int(11) unsigned NOT NULL COMMENT 'ID платежа в
Worldkassa',
  `time` int(11) unsigned NOT NULL COMMENT 'Время
инициализации платежа',
  `time_oplata` int(11)
unsigned DEFAULT '0' COMMENT 'Время оплаты',
  `summa`
decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статистика
платежей через WorldKassa';