[sql] item
Viewer
- /*
- Navicat MySQL Data Transfer
- Source Server : 185.118.143.157_3306
- Source Server Version : 50546
- Source Host : 185.118.143.157:3306
- Source Database : player
- Target Server Type : MYSQL
- Target Server Version : 50546
- File Encoding : 65001
- Date: 2020-02-29 13:44:28
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for `item_proto`
- -- ----------------------------
- DROP TABLE IF EXISTS `item_proto`;
- CREATE TABLE `item_proto` (
- `vnum` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `name` varbinary(24) NOT NULL DEFAULT 'Noname ',
- `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname ',
- `type` tinyint(2) NOT NULL DEFAULT '0',
- `subtype` tinyint(2) NOT NULL DEFAULT '0',
- `weight` tinyint(3) DEFAULT '0',
- `size` tinyint(3) DEFAULT '0',
- `antiflag` INT(11) DEFAULT '0',
- `flag` INT(11) DEFAULT '0',
- `wearflag` INT(11) DEFAULT '0',
- `immuneflag` SET('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') NOT NULL DEFAULT '',
- `gold` INT(11) DEFAULT '0',
- `shop_buy_price` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `refined_vnum` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `refine_set` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0',
- `refine_set2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
- `magic_pct` tinyint(4) NOT NULL DEFAULT '0',
- `limittype0` tinyint(4) DEFAULT '0',
- `limitvalue0` INT(11) DEFAULT '0',
- `limittype1` tinyint(4) DEFAULT '0',
- `limitvalue1` INT(11) DEFAULT '0',
- `applytype0` tinyint(4) DEFAULT '0',
- `applyvalue0` INT(11) DEFAULT '0',
- `applytype1` tinyint(4) DEFAULT '0',
- `applyvalue1` INT(11) DEFAULT '0',
- `applytype2` tinyint(4) DEFAULT '0',
- `applyvalue2` INT(11) DEFAULT '0',
- `value0` INT(11) DEFAULT '0',
- `value1` INT(11) DEFAULT '0',
- `value2` INT(11) DEFAULT '0',
- `value3` INT(11) DEFAULT '0',
- `value4` INT(11) DEFAULT '0',
- `value5` INT(11) DEFAULT '0',
- `socket0` INT(10) DEFAULT '-1',
- `socket1` INT(10) DEFAULT '-1',
- `socket2` INT(10) DEFAULT '-1',
- `socket3` INT(10) DEFAULT '-1',
- `socket4` INT(10) DEFAULT '-1',
- `socket5` INT(10) DEFAULT '-1',
- `specular` tinyint(4) NOT NULL DEFAULT '0',
- `socket_pct` tinyint(4) NOT NULL DEFAULT '0',
- `addon_type` SMALLINT(6) NOT NULL DEFAULT '0',
- `vnum_range` tinyint(4) NOT NULL DEFAULT '0',
- PRIMARY KEY (`vnum`) USING BTREE
- ) ENGINE=MyISAM DEFAULT CHARSET=big5 ROW_FORMAT=DYNAMIC;
- -- ----------------------------
- -- Records of item_proto
- -- ----------------------------
- INSERT INTO item_proto VALUES ('1', 0xB5B7B2D9B7AFB9CC, 0x59616E67, '9', '0', '0', '1', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0', '0');
- INSERT INTO item_proto VALUES ('2', 0xC7D1B1B9B9ABBDD6B9F6C1AF, 0x54FC726BE7652053FC72FC6D, '0', '0', '0', '1', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0', '0');
- INSERT INTO item_proto VALUES ('10', 0xB5B52B30, 0x4BFD6CFDE72B30, '1', '0', '0', '2', '262176', '1', '16', '', '0', '0', '11', '1', '0', '15', '1', '0', '0', '0', '7', '22', '0', '0', '0', '0', '0', '15', '19', '13', '15', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '1', '0', '0');
Editor
You can edit this paste and save as new:
File Description
- item
- Paste Code
- 21 May-2020
- 3.34 Kb
You can Share it:
Latest Code Pastes