now revision 85 ^^
but they should add this in the 86 :
items.sql
Code:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: roseon_beta
Target Host: localhost
Target Database: roseon_beta
Date: 11/11/2006 14:07:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for items
-- ----------------------------
CREATE TABLE `items` (
`owner` int(11) default NULL,
`itemnum` int(11) default NULL,
`itemtype` int(11) default NULL,
`refine` int(11) default NULL,
`durability` int(11) default '40',
`lifespan` int(11) default '100',
`slotnum` int(11) default NULL,
`count` int(11) default '1',
`stats` int(11) default '0',
`socketed` int(11) default '0',
`appraised` int(11) default '0',
`gemid` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
with gemid ^^