Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `blocks` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `image` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
- `block_id` varchar(11) COLLATE utf8_bin NOT NULL,
- `amount` int(11) NOT NULL DEFAULT '0',
- `price` int(11) NOT NULL DEFAULT '0',
- `server` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
- `name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '1',
- `sale` tinyint(1) NOT NULL DEFAULT '0',
- `time_sale` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `buys` int(255) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=822 ;
- CREATE TABLE IF NOT EXISTS `donate_logs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '1',
- `money` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `dic` varchar(512) CHARACTER SET utf8 NOT NULL DEFAULT '0',
- `date` varchar(55) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `unixtime` int(255) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=842 ;
- CREATE TABLE IF NOT EXISTS `getitem_s1` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT 'item',
- `nickname` varchar(255) DEFAULT NULL,
- `item_id` varchar(255) DEFAULT NULL,
- `extra` text,
- `item_amount` int(11) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `nickname` (`nickname`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4978 ;
- CREATE TABLE IF NOT EXISTS `getitem_s1_log` (
- `id` int(24) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `history` varchar(255) DEFAULT NULL,
- `time` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2218 ;
- CREATE TABLE IF NOT EXISTS `getitem_s2` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT 'item',
- `nickname` varchar(255) DEFAULT NULL,
- `item_id` varchar(255) DEFAULT NULL,
- `extra` text,
- `item_amount` int(11) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `nickname` (`nickname`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2084 ;
- CREATE TABLE IF NOT EXISTS `getitem_s2_log` (
- `id` int(24) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `history` varchar(255) DEFAULT NULL,
- `time` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1259 ;
- CREATE TABLE IF NOT EXISTS `getitem_s3` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT 'item',
- `nickname` varchar(255) DEFAULT NULL,
- `item_id` varchar(255) DEFAULT NULL,
- `extra` text,
- `item_amount` int(11) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `nickname` (`nickname`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1579 ;
- CREATE TABLE IF NOT EXISTS `getitem_s3_log` (
- `id` int(24) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `history` varchar(255) DEFAULT NULL,
- `time` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=859 ;
- CREATE TABLE IF NOT EXISTS `getitem_s4` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT 'item',
- `nickname` varchar(255) DEFAULT NULL,
- `item_id` varchar(255) DEFAULT NULL,
- `extra` text,
- `item_amount` int(11) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `nickname` (`nickname`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1597 ;
- CREATE TABLE IF NOT EXISTS `getitem_s4_log` (
- `id` int(24) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `history` varchar(255) DEFAULT NULL,
- `time` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=204 ;
- CREATE TABLE IF NOT EXISTS `getitem_s5` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `type` varchar(255) DEFAULT 'item',
- `nickname` varchar(255) DEFAULT NULL,
- `item_id` varchar(255) DEFAULT NULL,
- `extra` text,
- `item_amount` int(11) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `nickname` (`nickname`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1876 ;
- CREATE TABLE IF NOT EXISTS `getitem_s5_log` (
- `id` int(24) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `history` varchar(255) DEFAULT NULL,
- `time` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=446 ;
- CREATE TABLE IF NOT EXISTS `permissions_entity_s1` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `prefix` varchar(255) NOT NULL,
- `suffix` varchar(255) NOT NULL,
- `default` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `default` (`default`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3868 ;
- CREATE TABLE IF NOT EXISTS `permissions_entity_s2` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `prefix` varchar(255) NOT NULL,
- `suffix` varchar(255) NOT NULL,
- `default` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `default` (`default`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3471 ;
- CREATE TABLE IF NOT EXISTS `permissions_entity_s3` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `prefix` varchar(255) NOT NULL,
- `suffix` varchar(255) NOT NULL,
- `default` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `default` (`default`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2984 ;
- CREATE TABLE IF NOT EXISTS `permissions_entity_s4` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `prefix` varchar(255) NOT NULL,
- `suffix` varchar(255) NOT NULL,
- `default` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `default` (`default`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2910 ;
- CREATE TABLE IF NOT EXISTS `permissions_entity_s5` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `prefix` varchar(255) NOT NULL,
- `suffix` varchar(255) NOT NULL,
- `default` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `default` (`default`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3179 ;
- CREATE TABLE IF NOT EXISTS `permissions_inheritance_s1` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `child` varchar(50) NOT NULL,
- `parent` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `world` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
- KEY `child_2` (`child`,`type`),
- KEY `parent` (`parent`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2831 ;
- CREATE TABLE IF NOT EXISTS `permissions_inheritance_s2` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `child` varchar(50) NOT NULL,
- `parent` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `world` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
- KEY `child_2` (`child`,`type`),
- KEY `parent` (`parent`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=273 ;
- CREATE TABLE IF NOT EXISTS `permissions_inheritance_s3` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `child` varchar(50) NOT NULL,
- `parent` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `world` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
- KEY `child_2` (`child`,`type`),
- KEY `parent` (`parent`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2745 ;
- CREATE TABLE IF NOT EXISTS `permissions_inheritance_s4` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `child` varchar(50) NOT NULL,
- `parent` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `world` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
- KEY `child_2` (`child`,`type`),
- KEY `parent` (`parent`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2599 ;
- CREATE TABLE IF NOT EXISTS `permissions_inheritance_s5` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `child` varchar(50) NOT NULL,
- `parent` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `world` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `child` (`child`,`parent`,`type`,`world`),
- KEY `child_2` (`child`,`type`),
- KEY `parent` (`parent`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2633 ;
- CREATE TABLE IF NOT EXISTS `permissions_s1` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `permission` varchar(200) NOT NULL,
- `world` varchar(50) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
- KEY `user` (`name`,`type`),
- KEY `world` (`world`,`name`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3045668 ;
- CREATE TABLE IF NOT EXISTS `permissions_s2` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `permission` varchar(200) NOT NULL,
- `world` varchar(50) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
- KEY `user` (`name`,`type`),
- KEY `world` (`world`,`name`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1269972 ;
- CREATE TABLE IF NOT EXISTS `permissions_s3` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `permission` varchar(200) NOT NULL,
- `world` varchar(50) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
- KEY `user` (`name`,`type`),
- KEY `world` (`world`,`name`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=824027 ;
- CREATE TABLE IF NOT EXISTS `permissions_s4` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `permission` varchar(200) NOT NULL,
- `world` varchar(50) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
- KEY `user` (`name`,`type`),
- KEY `world` (`world`,`name`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16949 ;
- CREATE TABLE IF NOT EXISTS `permissions_s5` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL,
- `type` tinyint(1) NOT NULL,
- `permission` varchar(200) NOT NULL,
- `world` varchar(50) NOT NULL,
- `value` text NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `unique` (`name`,`permission`,`world`,`type`),
- KEY `user` (`name`,`type`),
- KEY `world` (`world`,`name`,`type`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8637 ;
- CREATE TABLE IF NOT EXISTS `robokassa_pays` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1',
- `money` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
- `dic` varchar(512) CHARACTER SET utf8 NOT NULL DEFAULT '0',
- `date` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
- `pay` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
- `unixtime` int(100) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2569 ;
- CREATE TABLE IF NOT EXISTS `stats_buy` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `lk` int(11) NOT NULL DEFAULT '0',
- `shop` int(11) NOT NULL DEFAULT '0',
- `enchant` int(11) NOT NULL DEFAULT '0',
- `sales` int(11) NOT NULL DEFAULT '0',
- `s1` int(255) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
- CREATE TABLE IF NOT EXISTS `stats_lk` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nick` int(11) NOT NULL DEFAULT '0',
- `group` int(11) NOT NULL DEFAULT '0',
- `skin` int(11) NOT NULL DEFAULT '0',
- `cloak` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement