createwaterinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'WaterInfo'
--

DROP TABLE IF EXISTS WaterInfo;
CREATE TABLE WaterInfo (
  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',
  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;

--
-- Dumping data for table 'WaterInfo'
--

INSERT INTO WaterInfo VALUES (0,'小圣水瓶','Small Water Bottle',5,1,1,0);
INSERT INTO WaterInfo VALUES (1,'中圣水瓶','Medium Water Bottle',10,1,1,0);
INSERT INTO WaterInfo VALUES (2,'大圣水瓶','Large Water Bottle',25,1,1,0);

INSERT INTO WaterInfo VALUES (3,'小剂量药瓶','Small Potion Bottle',150,1,1,0);
INSERT INTO WaterInfo VALUES (4,'中剂量药瓶','Medium Potion Bottle',500,1,1,0);
INSERT INTO WaterInfo VALUES (5,'大剂量药瓶','Large Potion Bottle',1500,1,1,0);
INSERT INTO WaterInfo VALUES (6,'全剂量药瓶','Full Potion Bottle',5000,1,1,0);