PHP Code:
/*
Navicat MySQL Data Transfer
Source Server : Test Server
Source Server Version : 50085
Source Host : 5.99.999.100:3306
Source Database : player
Target Server Type : MYSQL
Target Server Version : 50085
File Encoding : 65001
Date: 2010-10-25 20:58:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `item_proto_copy`
-- ----------------------------
DROP TABLE IF EXISTS `item_proto_copy`;
CREATE TABLE `item_proto_copy` (
`vnum` int(11) unsigned NOT NULL default '0',
`hashName` varbinary(24) NOT NULL default 'Noname ',
`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',
`buy_price` int(10) unsigned 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` tinyint(4) default '-1',
`socket1` tinyint(4) default '-1',
`socket2` tinyint(4) default '-1',
`socket3` tinyint(4) default '-1',
`socket4` tinyint(4) default '-1',
`socket5` tinyint(4) default '-1',
`refined_vnum` int(10) unsigned NOT NULL default '0',
`refine_set` smallint(11) unsigned NOT NULL default '0',
`magic_pct` tinyint(4) NOT NULL default '0',
`specular` tinyint(4) NOT NULL default '0',
`socket_pct` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
-- ----------------------------
-- Records of item_proto_copy
-- ----------------------------