1.7数据库中升级任务数据错误的修改 [复制链接]

上一主题下一主题查看指定楼层

离线rushairer

新手上路

发帖: 23

祝福宝石: 0

威望: 0

玛雅之石: 0

创造宝石: 0

只看楼主倒序阅读使用道具楼主发表于: 2006-09-15

/*
SQLyog 企业版 - MySQL GUI v5.02
主机 - 4.0.26-nt : 数据库 - audition
*********************************************************************
服务器版本 : 4.0.26-nt
*/

create database if not exists `audition`;

USE `audition`;

/*数据表 `level_quest` 的表结构*/

DROP TABLE IF EXISTS `level_quest`;

CREATE TABLE `level_quest` (
`Id` int(6) unsigned NOT NULL auto_increment,
`Level` varchar(18) default NULL,
`Exp` varchar(17) default NULL,
`Score` varchar(18) default NULL,
`Perfect` varchar(19) default NULL,
`ConsecutivePerfect` varchar(27) default NULL,
`GameMode` varchar(25) default NULL,
`MusicCode` varchar(28) default NULL,
`StageCode` varchar(16) default NULL,
`Fee` varchar(23) default NULL,
`WinDen` varchar(23) default NULL,
`WinExp` varchar(21) default NULL,
PRIMARY KEY (`Id`)
) TYPE=MyISAM;

/*数据表 `level_quest` 的数据*/

insert into `level_quest` values

(1,'5','7140','180000','5','2','1','17','1','150','600','500'),

(2,'6','12500','200000','5','2','1','17','1','200','800','500'),

(3,'7','19695','240000','6','2','1','17','1','250','1000','500'),

(4,'8','29000','280000','6','2','1','17','1','300','1200','500'),

(5,'9','40500','300000','7','2','1','17','1','550','2800','500'),

(6,'10','54500','330000','7','2','1','17','1','600','3000','500'),

(7,'11','71000','350000','8','2','1','21','1','700','3500','500'),

(8,'12','90000','370000','8','2','1','21','1','750','3800','500'),

(9,'13','112000','380000','9','2','1','21','1','850','5100','500'),

(10,'14','137000','390000','9','2','1','21','1','900','5400','500'),

(11,'15','165000','300000','10','2','5','21','2','1000','6000','500'),

(12,'16','196000','330000','10','2','1','9','1','1050','6300','500'),

(13,'17','230500','350000','11','2','3','9','1','1500','10500','500'),

(14,'18','268500','370000','11','2','3','9','1','1600','11200','500'),

(15,'19','310000','350000','12','2','1','9','1','1700','11900','500'),

(16,'20','354500','370000','12','2','1','9','1','1800','12600','500'),

(17,'21','403500','390000','13','2','1','10','1','1900','13300','500'),

(18,'22','456000','410000','13','2','3','10','1','2000','14000','500'),

(19,'23','512000','350000','14','2','3','10','1','2100','16800','500'),

(20,'24','572500','360000','14','2','3','10','1','2200','17600','500'),

(21,'25','637000','370000','15','3','3','5','1','2300','18400','500'),

(22,'26','705500','380000','15','3','3','5','1','2400','19200','500'),

(23,'27','778000','500000','16','3','3','5','1','2500','20000','500'),

(24,'28','855500','520000','16','3','3','5','1','2600','20800','500'),

(25,'29','937000','540000','17','3','3','16','1','3400','30600','500'),

(26,'30','1023000','560000','17','3','3','16','1','3500','31500','500'),

(27,'31','1113500','410000','18','3','4','16','1','3650','32900','500'),

(28,'32','1208500','430000','18','3','4','16','1','3750','33800','500'),

(29,'33','1308500','440000','19','3','4','11','1','3900','35100','500'),

(30,'34','1413500','450000','19','3','4','11','1','4000','36000','500'),

(31,'35','1523000','470000','20','4','4','11','1','4150','37400','500'),

(32,'36','1638000','490000','20','4','4','11','1','4250','32300','500'),

(33,'37','1757500','505000','21','4','4','22','1','4400','39600','500'),

(34,'38','1882500','510000','21','4','4','22','1','4500','45000','500'),

(35,'39','2012000','530000','22','4','5','22','1','4650','46500','500'),

(36,'40','2147500','540000','22','4','5','22','1','4750','47500','500'),

(37,'41','2288000','550000','23','4','5','23','1','4900','49000','500'),

(38,'42','2434000','560000','23','4','5','23','1','5000','50000','500'),

(39,'43','2585000','460000','24','4','5','23','1','5150','51500','500'),

(40,'44','2742000','470000','24','4','5','23','1','5250','52500','500'),

(41,'45','2904500','480000','25','4','5','18','1','6450','77400','500'),

(42,'46','3072500','490000','25','4','5','18','1','6600','79200','500'),

(43,'47','3246500','480000','26','5','5','18','1','6750','81000','500'),

(44,'48','3426000','490000','26','5','5','18','1','6900','82800','500'),

(45,'49','3611000','500000','27','5','5','6','1','7050','84600','500'),

(46,'50','3802500','510000','28','6','5','6','1','7200','86400','500'),

(47,'51','4000000','530000','28','6','1','6','1','8400','90000','500'),

(48,'52','4300000','560000','29','6','1','6','1','8800','92000','500'),

(49,'53','4650000','580000','29','6','1','25','1','9000','94000','500'),

(50,'54','5000000','600000','30','6','3','25','1','9500','98000','500'),

(51,'55','5400000','620000','30','6','3','25','1','9800','99000','500'),

(52,'56','5850000','640000','30','7','3','25','1','10000','100000','500'),

(53,'57','6350000','660000','30','7','3','25','1','12000','120000','500'),

(54,'58','6900000','680000','32','7','3','25','1','15000','150000','500'),

(55,'59','7500000','700000','34','8','3','25','1','18000','180000','500'),

(56,'60','8400000','800000','36','10','3','25','1','20000','200000','500');