Emistry icon

SQL - Job Changer DB

Emistry | PRO | 05/03/16 04:55:01 PM UTC | 0 ⭐ | 866 👁️ | Never ⏰ | []
text |

2.82 KB

|

None

|

0 👍

/

0 👎

 --
-- Create table `e_jobchanger`
--
 CREATE TABLE IF NOT EXISTS `e_jobchanger` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`next_job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`base_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`job_lv` SMALLINT(6) UNSIGNED NULL DEFAULT '0',
	`status` TINYINT(3) NOT NULL DEFAULT '1',
	PRIMARY KEY (`id`)
) ENGINE=MyISAM;
 --
-- Dumping data for table `e_jobchanger`
--
 INSERT INTO `e_jobchanger` (`job`, `next_job`, `base_lv`, `job_lv`, `status`) VALUES
( 0, 1, 0, 10, 1),
( 0, 2, 0, 10, 1),
( 0, 3, 0, 10, 1),
( 0, 4, 0, 10, 1),
( 0, 5, 0, 10, 1),
( 0, 6, 0, 10, 1),
( 0, 24, 0, 10, 1),
( 0, 25, 0, 10, 1),
( 0, 4046, 0, 10, 1),
( 0, 4023, 0, 10, 1),
( 4023, 4024, 0, 10, 1),
( 4023, 4025, 0, 10, 1),
( 4023, 4026, 0, 10, 1),
( 4023, 4027, 0, 10, 1),
( 4023, 4028, 0, 10, 1),
( 4023, 4029, 0, 10, 1),
( 1, 7, 0, 40, 1),
( 1, 14, 0, 40, 1),
( 2, 9, 0, 40, 1),
( 2, 16, 0, 40, 1),
( 3, 11, 0, 40, 1),
( 3, 19, 0, 40, 1),
( 3, 20, 0, 40, 1),
( 4, 8, 0, 40, 1),
( 4, 15, 0, 40, 1),
( 5, 10, 0, 40, 1),
( 5, 18, 0, 40, 1),
( 6, 12, 0, 40, 1),
( 6, 17, 0, 40, 1),
( 24, 4215, 0, 40, 1),
( 4046, 4047, 0, 40, 1),
( 4046, 4049, 0, 40, 1),
( 25, 4211, 0, 40, 1),
( 25, 4212, 0, 40, 1),
( 0, 23, 45, 10, 1),
( 4024, 4030, 0, 40, 1),
( 4024, 4037, 0, 40, 1),
( 4025, 4032, 0, 40, 1),
( 4025, 4039, 0, 40, 1),
( 4026, 4034, 0, 40, 1),
( 4026, 4042, 0, 40, 1),
( 4026, 4043, 0, 40, 1),
( 4027, 4031, 0, 40, 1),
( 4027, 4038, 0, 40, 1),
( 4028, 4033, 0, 40, 1),
( 4028, 4041, 0, 40, 1),
( 4029, 4035, 0, 40, 1),
( 4029, 4040, 0, 40, 1),
( 7, 4001, 99, 50, 1),
( 14, 4001, 99, 50, 1),
( 9, 4001, 99, 50, 1),
( 16, 4001, 99, 50, 1),
( 11, 4001, 99, 50, 1),
( 19, 4001, 99, 50, 1),
( 20, 4001, 99, 50, 1),
( 8, 4001, 99, 50, 1),
( 15, 4001, 99, 50, 1),
( 15, 4001, 99, 50, 1),
( 10, 4001, 99, 50, 1),
( 18, 4001, 99, 50, 1),
( 12, 4001, 99, 50, 1),
( 17, 4001, 99, 50, 1),
( 4001, 4002, 0, 10, 1),
( 4001, 4003, 0, 10, 1),
( 4001, 4004, 0, 10, 1),
( 4001, 4005, 0, 10, 1),
( 4001, 4006, 0, 10, 1),
( 4001, 4007, 0, 10, 1),
( 4002, 4008, 0, 50, 1),
( 4002, 4015, 0, 50, 1),
( 4003, 4010, 0, 50, 1),
( 4003, 4017, 0, 50, 1),
( 4004, 4012, 0, 50, 1),
( 4004, 4020, 0, 50, 1),
( 4004, 4021, 0, 50, 1),
( 4005, 4009, 0, 50, 1),
( 4005, 4016, 0, 50, 1),
( 4006, 4011, 0, 50, 1),
( 4006, 4019, 0, 50, 1),
( 4007, 4013, 0, 50, 1),
( 4007, 4018, 0, 50, 1),
( 4008, 4060, 99, 70, 1),
( 4015, 4073, 99, 70, 1),
( 4010, 4061, 99, 70, 1),
( 4017, 4074, 99, 70, 1),
( 4012, 4062, 99, 70, 1),
( 4020, 4075, 99, 70, 1),
( 4021, 4076, 99, 70, 1),
( 4009, 4063, 99, 70, 1),
( 4016, 4077, 99, 70, 1),
( 4011, 4064, 99, 70, 1),
( 4019, 4078, 99, 70, 1),
( 4013, 4065, 99, 70, 1),
( 4018, 4079, 99, 70, 1);

Comments