createmagazineinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'MagazineInfo'
--

DROP TABLE IF EXISTS MagazineInfo;
CREATE TABLE MagazineInfo (
  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',
  ItemLevel tinyint(3) unsigned NOT NULL default '0',
  MaxBullets tinyint(3) unsigned NOT NULL default '0',
  MaxSilverBullets tinyint(3) unsigned NOT NULL default '0',
  Vivid tinyint(3) unsigned NOT NULL default '0',
  GunType enum('AR','SMG','SG','SR') NOT NULL default 'AR',
  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;

--
-- Dumping data for table 'MagazineInfo'
--


INSERT INTO MagazineInfo VALUES (0,'SG 子弹-8','SG Shell-8',40,1,1,100000,0,8,0,0,'SG');
INSERT INTO MagazineInfo VALUES (1,'SG 子弹-16','SG Shell-16',120,1,1,75000,1,16,0,0,'SG');
INSERT INTO MagazineInfo VALUES (2,'AR 子弹-20','AR Magazine-20',70,1,1,100000,0,20,0,0,'AR');
INSERT INTO MagazineInfo VALUES (3,'AR 子弹-40','AR Magazine-40',210,1,1,75000,1,40,0,0,'AR');
INSERT INTO MagazineInfo VALUES (4,'SMG 子弹-40','SMG Magazine-40',50,1,1,100000,0,40,0,0,'SMG');
INSERT INTO MagazineInfo VALUES (5,'SMG 子弹-80','SMG Magazine-80',150,1,1,75000,1,80,0,0,'SMG');
INSERT INTO MagazineInfo VALUES (6,'SR 子弹-10','SR Magazine-10',100,1,1,100000,0,10,0,0,'SR');
INSERT INTO MagazineInfo VALUES (7,'SR 子弹-20','SR Magazine-20',300,1,1,75000,1,20,0,0,'SR');
INSERT INTO MagazineInfo VALUES (8,'银制 SG 子弹-8','Silver SG Shell-8',400,1,1,10000,2,8,8,0,'SG');
INSERT INTO MagazineInfo VALUES (9,'银制 SG 子弹-16','Silver SG Shell-16',1200,1,1,5000,3,16,16,0,'SG');
INSERT INTO MagazineInfo VALUES (10,'银制 AR 子弹-20','Silver AR Magazine-20',700,1,1,10000,2,20,20,0,'AR');
INSERT INTO MagazineInfo VALUES (11,'银制 AR 子弹-40','Silver AR Magazine-40',2100,1,1,5000,3,40,40,0,'AR');
INSERT INTO MagazineInfo VALUES (12,'银制 SMG 子弹-40','Silver SMG Magazine-40',500,1,1,10000,2,40,40,0,'SMG');
INSERT INTO MagazineInfo VALUES (13,'银制 SMG 子弹-80','Silver SMG Magazine-80',1500,1,1,5000,3,80,80,0,'SMG');
INSERT INTO MagazineInfo VALUES (14,'银制 SR 子弹-10','Silver SR Magazine-10',1000,1,1,10000,2,10,10,0,'SR');
INSERT INTO MagazineInfo VALUES (15,'银制 SR 子弹-20','Silver SR Magazine-20',3000,1,1,5000,3,20,20,0,'SR');
INSERT INTO MagazineInfo VALUES (16,'SG专用子弹  32发装','SG Shell-32',250,1,1,75000,4,32,0,1,'SG');
INSERT INTO MagazineInfo VALUES (17,'AR 专用子弹  80发装','AR Magazine-80',450,1,1,75000,4,80,0,1,'AR');
INSERT INTO MagazineInfo VALUES (18,'SMG 专用子弹  160发装','SMG Magazine-160',330,1,1,75000,4,160,0,1,'SMG');
INSERT INTO MagazineInfo VALUES (19,'SR专用子弹  40发装','SR Magazine-40',650,1,1,75000,4,40,0,1,'SR');
INSERT INTO MagazineInfo VALUES (20,'SG专用银子弹  32发装','Silver SG Shell-32',2500,1,1,5000,5,32,32,1,'SG');
INSERT INTO MagazineInfo VALUES (21,'AR专用银子弹  80发装','Silver AR Magazine-80',4500,1,1,5000,5,80,80,1,'AR');
INSERT INTO MagazineInfo VALUES (22,'SMG专用银子弹  160发装','Silver SMG Magazine-160',3300,1,1,5000,5,160,160,1,'SMG');
INSERT INTO MagazineInfo VALUES (23,'SR专用银子弹  40发装','Silver SR Magazine-40',6500,1,1,5000,5,40,40,1,'SR');