|
Сообщение от loginserver.sql
ALTER TABLE `accounts` ADD `l2answer` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '';
ALTER TABLE `accounts` ADD `l2question` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '';
ALTER TABLE `accounts` ADD `l2email` varchar(100) NOT NULL DEFAULT 'null@null';
CREATE TABLE IF NOT EXISTS `stress_log_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`log_id` int(11) NOT NULL DEFAULT '0',
`sd_shop_id` int(11) NOT NULL DEFAULT '0',
`item_count` int(11) NOT NULL DEFAULT '0',
`success` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `stress_log_donate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`char_name` varchar(45) NOT NULL,
`char_id` int(10) unsigned NOT NULL DEFAULT '0',
`server` tinyint(4) NOT NULL DEFAULT '0',
`money` double(10,2) NOT NULL DEFAULT '0.00',
`price` double(10,2) NOT NULL DEFAULT '0.00',
`time` int(11) NOT NULL default '0',
`ip` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `stress_donate_money` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`account` varchar(30) NOT NULL default '',
`money` double(10,2) NOT NULL DEFAULT '0.00',
`value` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `account` (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `stress_donate_wm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`wm_rnd` varchar(8) NOT NULL,
`wm_account` varchar(30) NOT NULL default '',
`wm_type` enum('wmz','wmr','wme','wmu') NOT NULL default 'wmz',
`wm_count` double(10,2) NOT NULL DEFAULT '0.00',
`wm_money` double(10,2) NOT NULL DEFAULT '0.00',
`wm_time` int(11) NOT NULL default '0',
`wm_ip` varchar(30) NOT NULL default '',
`wm_stage` enum('0','I','E','P','S') NOT NULL default '0',
`wm_success` enum('0','1') NOT NULL DEFAULT '0',
`payer_wm` varchar(12) NOT NULL DEFAULT '0',
`payer_wmid` varchar(13) NOT NULL DEFAULT '0',
`sys_invs_no` varchar(11) NOT NULL DEFAULT '0',
`sys_trans_no` varchar(11) NOT NULL DEFAULT '0',
`sys_trans_date` varchar(17) NOT NULL DEFAULT '0',
`wm_comment` text NOT NULL,
PRIMARY KEY (`id`),
KEY `wm_rnd` (`wm_rnd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `l2top` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick` varchar(30) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`server` tinyint(3) NOT NULL DEFAULT '0',
`success` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `stress_donate_shop` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`category` enum('etcitem','weapon','armor') NOT NULL DEFAULT 'etcitem',
`server` tinyint(4) NOT NULL DEFAULT '0',
`item_name` varchar(50) NOT NULL,
`price_sell` double(10,2) NOT NULL DEFAULT '0.00',
`count` int(4) NOT NULL DEFAULT '0',
`description` varchar(250) NOT NULL,
`active` enum('0','1') NOT NULL DEFAULT '1',
`single` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|