phPJ3wXS

1-- phpMyAdmin SQL Dump
2-- version 3.5.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: May 02, 2018 at 03:04 PM
7-- Server version: 10.1.32-MariaDB
8-- PHP Version: 5.6.30
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `mcdb_9297`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `store_item_child`
27--
28
29CREATE TABLE IF NOT EXISTS `store_item_child` (
30  `parent` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '!parent!',
31  `type` varchar(32) NOT NULL DEFAULT 'ITEM_ERROR' COMMENT '!type!',
32  `uid` varchar(32) NOT NULL DEFAULT 'ITEM_ERROR',
33  `buyable` bit(1) NOT NULL DEFAULT b'1' COMMENT '!buyable!',
34  `giftable` bit(1) NOT NULL DEFAULT b'1' COMMENT '!giftable!',
35  `only` bit(1) NOT NULL DEFAULT b'0' COMMENT '!only!',
36  `auth` varchar(128) NOT NULL DEFAULT 'ITEM_NOT_PERSONAL' COMMENT '!personal!',
37  `vip` bit(1) NOT NULL DEFAULT b'0' COMMENT '!vip!',
38  `name` varchar(32) NOT NULL DEFAULT 'ITEM_UNNAMED' COMMENT '菜单显示的名字',
39  `lvls` tinyint(2) NOT NULL DEFAULT '0' COMMENT 'playerskin',
40  `desc` varchar(32) NOT NULL DEFAULT 'ITEM_NO_DESC' COMMENT 'playerskin',
41  `case` bit(1) NOT NULL DEFAULT b'0' COMMENT 'playerskin',
42  `compose` bit(1) NOT NULL DEFAULT b'0' COMMENT 'playerskin',
43  `1d` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'credits/day',
44  `1m` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'credits/month',
45  `pm` varchar(255) NOT NULL DEFAULT '100000' COMMENT 'credits/perment',
46  `model` varchar(192) NOT NULL DEFAULT 'ITEM_NO_MODEL' COMMENT 'playerskin|hat|nadeskin|vwmodel',
47  `arms` varchar(192) NOT NULL DEFAULT 'ITEM_NO_ARMS' COMMENT 'playerskin',
48  `team` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'playerskin',
49  `sound` varchar(192) NOT NULL DEFAULT 'ITEM_NO_SOUND' COMMENT 'playerskin|sound',
50  `position` varchar(64) NOT NULL DEFAULT '0.0 0.0 0.0' COMMENT 'hat',
51  `angles` varchar(64) NOT NULL DEFAULT '0.0 0.0 0.0' COMMENT 'hat',
52  `attachment` varchar(32) NOT NULL DEFAULT 'ITEM_NO_ATTACHMENT' COMMENT 'hat',
53  `slot` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'hat|vwmodel',
54  `material` varchar(192) NOT NULL DEFAULT 'ITEM_NO_MATERIAL' COMMENT 'nadetrail|trail|spray',
55  `color` varchar(32) NOT NULL DEFAULT 'ITEM_NO_COLOR' COMMENT 'nadetrail|trail|namecolor|msgcolor|neon',
56  `grenade` varchar(32) NOT NULL DEFAULT 'ITEM_NO_GRENADE' COMMENT 'nadeskin',
57  `shortname` varchar(32) NOT NULL DEFAULT 'ITEM_NO_SHORTNAME' COMMENT 'sound',
58  `volume` float(2,1) unsigned NOT NULL DEFAULT '1.0' COMMENT 'sound',
59  `cooldown` tinyint(3) unsigned NOT NULL DEFAULT '60' COMMENT 'sound',
60  `worldmodel` varchar(192) NOT NULL DEFAULT 'ITEM_NO_WORLDMODEL' COMMENT 'vwmodel',
61  `dropmodel` varchar(192) NOT NULL DEFAULT 'ITEM_NO_DROPMODEL' COMMENT 'vwmodel',
62  `weapon` varchar(32) NOT NULL DEFAULT 'ITEM_NO_ENTITY' COMMENT 'vwmodel',
63  `effect` varchar(32) NOT NULL DEFAULT 'ITEM_NO_EFFECT' COMMENT 'arua|particle',
64  `brightness` tinyint(2) unsigned NOT NULL DEFAULT '5' COMMENT 'neon',
65  `distance` tinyint(3) unsigned NOT NULL DEFAULT '150' COMMENT 'neon',
66  `distancefade` tinyint(3) unsigned NOT NULL DEFAULT '50' COMMENT 'neon',
67  `tag` varchar(32) NOT NULL DEFAULT 'ITEM_NO_TAG' COMMENT 'nametag',
68  PRIMARY KEY (`type`,`uid`),
69  KEY `p` (`parent`)
70) ENGINE=InnoDB DEFAULT CHARSET=utf8;
71
72/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
73/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
74/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;