createbloodbibleobject.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: localhost    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.53-log

--
-- Table structure for table 'BloodBibleObject'
--
CREATE TABLE BloodBibleObject (
  ItemID bigint(20) unsigned NOT NULL default '0',
  ObjectID int(10) unsigned NOT NULL default '0',
  ItemType tinyint(3) unsigned NOT NULL default '0',
  OwnerID varchar(10) NOT NULL default '',
  Storage tinyint(3) unsigned NOT NULL default '0',
  StorageID bigint(20) unsigned NOT NULL default '0',
  X tinyint(3) unsigned NOT NULL default '0',
  Y tinyint(3) unsigned NOT NULL default '0',
  OptionType tinyint(3) unsigned NOT NULL default '0',
  Durability smallint(5) unsigned NOT NULL default '0',
  EnchantLevel smallint(5) unsigned NOT NULL default '0',
  Status int(11) NOT NULL default '0',
  ItemFlag tinyint NOT NULL default 0,

  PRIMARY KEY  (ItemID),
  KEY IDX_BloodBibleObject (OwnerID),
  KEY IDX_BloodBibleObject2 (Storage)
) TYPE=MyISAM;