createmoneyinfo.sql

天之炼狱OpenDE_SQL.tar.gz

# MySQL dump 8.14
#
# Host: localhost    Database: DARKEDEN
#--------------------------------------------------------
# Server version	3.23.38

#
# Table structure for table 'MoneyInfo'
#

DROP TABLE IF EXISTS MoneyInfo;
CREATE TABLE MoneyInfo (
  ItemType tinyint(3) unsigned NOT NULL default '0',
  Name varchar(30) NOT NULL default '',
  EName varchar(30) NOT NULL default '',
  Price int(10) unsigned NOT NULL default '0',
  Volume tinyint(3) unsigned NOT NULL default '0',
  Weight tinyint(3) unsigned NOT NULL default '0',
  Ratio int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE UNIQUE INDEX MoneyInfo_u1 ON MoneyInfo(ItemType);
#
# Dumping data for table 'MoneyInfo'
#

INSERT INTO MoneyInfo VALUES (0,'铜币','Lei',0,1,1,0);
INSERT INTO MoneyInfo VALUES (1,'银币','Geld',0,1,1,0);

INSERT INTO MoneyInfo VALUES (2,' Zard ','Zard',0,1,1,0);