mmo-ref/landsandboat
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
landsandboat/sql/exp_table.sql

102 lines
7.6 KiB
MySQL
Raw Permalink Normal View History

Line ends, round 2. Fight!
2016-01-16 01:26:33 -05:00
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Structure de la table `exp_table`
--
DROP TABLE IF EXISTS `exp_table`;
CREATE TABLE IF NOT EXISTS `exp_table` (
`level` tinyint(2) NOT NULL,
Minor changes to experience table based on wiki information
2019-05-03 20:22:23 +03:00
`r1` smallint(4) unsigned NOT NULL DEFAULT '0', -- 1 to 5
`r2` smallint(4) unsigned NOT NULL DEFAULT '0', -- 6 to 10
`r3` smallint(4) unsigned NOT NULL DEFAULT '0', -- 11 to 15
`r4` smallint(4) unsigned NOT NULL DEFAULT '0', -- 16 to 20
`r5` smallint(4) unsigned NOT NULL DEFAULT '0', -- 21 to 25
`r6` smallint(4) unsigned NOT NULL DEFAULT '0', -- 26 to 30
`r7` smallint(4) unsigned NOT NULL DEFAULT '0', -- 31 to 35
`r8` smallint(4) unsigned NOT NULL DEFAULT '0', -- 36 to 40
`r9` smallint(4) unsigned NOT NULL DEFAULT '0', -- 41 to 45
`r10` smallint(4) unsigned NOT NULL DEFAULT '0', -- 46 to 50
`r11` smallint(4) unsigned NOT NULL DEFAULT '0', -- 51 to 55
`r12` smallint(4) unsigned NOT NULL DEFAULT '0', -- 56 to 60
`r13` smallint(4) unsigned NOT NULL DEFAULT '0', -- 61 to 65
`r14` smallint(4) unsigned NOT NULL DEFAULT '0', -- 66 to 70
`r15` smallint(4) unsigned NOT NULL DEFAULT '0', -- 71 to 75
`r16` smallint(4) unsigned NOT NULL DEFAULT '0', -- 76 to 80
`r17` smallint(4) unsigned NOT NULL DEFAULT '0', -- 81 to 85
`r18` smallint(4) unsigned NOT NULL DEFAULT '0', -- 86 to 90
`r19` smallint(4) unsigned NOT NULL DEFAULT '0', -- 91 to 95
`r20` smallint(4) unsigned NOT NULL DEFAULT '0', -- 96 to 99
Line ends, round 2. Fight!
2016-01-16 01:26:33 -05:00
PRIMARY KEY (`level`)
[sql] Speed up Aria table inserts See: https://mariadb.com/kb/en/aria-storage-engine/
2024-01-11 22:33:23 -05:00
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AVG_ROW_LENGTH=65;
Line ends, round 2. Fight!
2016-01-16 01:26:33 -05:00
--
-- Contenu de la table `exp_table`
--
[dbtool] Add function to dump DB to SQL files Queries database then scans corresponding SQL file, replacing values in INSERT statements with data from the database. Is not smart about which INSERT statement gets which data; line-end comments can get shuffled around if SQL file INSERTs are out of order or missing. If you're doing INSERT or DELETE operations, make sure to add a blank "INSERT INTO `table` VALUES ();" or manually remove the INSERT statement respectively before dumping tables.
2023-08-23 22:21:07 -04:00
INSERT INTO `exp_table` VALUES (15,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,1500);
INSERT INTO `exp_table` VALUES (14,800,800,800,800,800,800,800,800,800,800,800,800,720,720,720,720,720,720,720,1500);
INSERT INTO `exp_table` VALUES (13,800,800,800,800,800,800,720,720,720,720,720,720,630,630,630,630,630,630,630,1500);
INSERT INTO `exp_table` VALUES (12,720,720,720,720,720,720,630,630,630,630,630,630,580,580,580,580,580,580,580,1400);
INSERT INTO `exp_table` VALUES (11,630,630,630,630,630,630,580,580,580,580,580,580,530,530,530,530,530,530,530,1300);
INSERT INTO `exp_table` VALUES (10,580,580,580,580,580,580,530,530,530,530,530,530,480,480,480,480,480,480,480,1200);
INSERT INTO `exp_table` VALUES (9,720,720,720,720,720,720,600,600,600,600,530,480,440,440,440,400,400,400,400,1100);
INSERT INTO `exp_table` VALUES (8,600,600,600,600,600,600,550,550,550,530,480,430,400,400,400,380,380,380,380,1000);
INSERT INTO `exp_table` VALUES (7,550,550,550,550,550,550,500,500,500,470,430,380,360,360,360,340,340,340,340,900);
INSERT INTO `exp_table` VALUES (6,450,450,450,450,450,450,450,450,450,400,370,330,320,320,320,300,300,300,300,800);
INSERT INTO `exp_table` VALUES (5,350,350,350,350,350,350,400,400,400,340,310,280,280,280,280,260,260,260,260,700);
INSERT INTO `exp_table` VALUES (4,310,310,310,310,310,310,300,300,300,310,280,280,280,280,260,260,240,240,240,600);
INSERT INTO `exp_table` VALUES (3,260,260,260,260,260,260,300,300,300,300,300,300,300,300,300,320,320,320,320,500);
INSERT INTO `exp_table` VALUES (2,240,240,240,240,240,240,250,250,250,250,250,260,260,260,260,280,280,280,280,400);
INSERT INTO `exp_table` VALUES (1,220,220,220,220,220,220,225,225,225,225,225,230,230,230,230,240,240,240,240,300);
INSERT INTO `exp_table` VALUES (0,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200);
INSERT INTO `exp_table` VALUES (-1,180,180,180,180,180,180,186,192,192,192,192,192,192,192,195,195,195,195,195,195);
INSERT INTO `exp_table` VALUES (-2,160,160,160,160,160,160,172,172,180,180,186,186,186,186,190,190,190,190,190,190);
INSERT INTO `exp_table` VALUES (-3,140,140,150,150,150,150,160,160,170,170,180,180,180,180,184,184,184,184,184,185);
INSERT INTO `exp_table` VALUES (-4,130,130,140,140,140,140,150,152,160,160,170,170,172,172,180,180,180,180,180,180);
INSERT INTO `exp_table` VALUES (-5,120,120,130,130,130,130,140,146,152,152,160,160,166,166,172,172,172,172,172,172);
INSERT INTO `exp_table` VALUES (-6,100,100,120,120,120,120,130,140,146,146,152,152,160,160,166,166,166,166,166,166);
INSERT INTO `exp_table` VALUES (-7,0,80,110,110,110,110,120,130,140,140,146,146,152,154,160,160,160,160,160,160);
INSERT INTO `exp_table` VALUES (-8,0,60,90,90,100,100,110,120,130,132,140,140,146,150,155,155,155,155,155,155);
INSERT INTO `exp_table` VALUES (-9,0,0,80,80,80,80,100,110,120,126,132,132,140,144,150,150,150,150,150,150);
INSERT INTO `exp_table` VALUES (-10,0,0,0,0,80,80,80,100,110,120,126,126,132,140,145,145,145,145,145,145);
INSERT INTO `exp_table` VALUES (-11,0,0,0,0,0,0,60,80,100,110,120,120,126,132,140,140,140,140,140,140);
INSERT INTO `exp_table` VALUES (-12,0,0,0,0,0,0,0,60,80,100,110,112,120,126,132,132,132,132,132,132);
INSERT INTO `exp_table` VALUES (-13,0,0,0,0,0,0,0,0,60,80,100,106,112,120,126,126,126,126,126,126);
INSERT INTO `exp_table` VALUES (-14,0,0,0,0,0,0,0,0,0,60,90,100,106,112,120,120,120,120,120,120);
INSERT INTO `exp_table` VALUES (-15,0,0,0,0,0,0,0,0,0,0,80,90,100,106,112,112,112,112,112,112);
INSERT INTO `exp_table` VALUES (-16,0,0,0,0,0,0,0,0,0,0,0,80,80,100,106,106,106,106,106,106);
INSERT INTO `exp_table` VALUES (-17,0,0,0,0,0,0,0,0,0,0,0,0,60,80,100,100,100,100,100,100);
INSERT INTO `exp_table` VALUES (-18,0,0,0,0,0,0,0,0,0,0,0,0,0,60,90,90,90,90,90,90);
INSERT INTO `exp_table` VALUES (-19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,80,80,80,80,80,80);
INSERT INTO `exp_table` VALUES (-20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,60,70,70,70,70,70);
INSERT INTO `exp_table` VALUES (-21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,60,60,60,60,60);
INSERT INTO `exp_table` VALUES (-22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,55,55,55,55,55);
INSERT INTO `exp_table` VALUES (-23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50,50,50,50,50);
INSERT INTO `exp_table` VALUES (-24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,48,48,48,48,48);
INSERT INTO `exp_table` VALUES (-25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,45,45,45,45,45);
INSERT INTO `exp_table` VALUES (-26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,42,42,42,42,42);
INSERT INTO `exp_table` VALUES (-27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,40,40,40,40,40);
INSERT INTO `exp_table` VALUES (-28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,38,38,38,38,38);
INSERT INTO `exp_table` VALUES (-29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,36,36,36,36,36);
INSERT INTO `exp_table` VALUES (-30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,34,34,34,34,34);
INSERT INTO `exp_table` VALUES (-31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32,32,32,32,32);
INSERT INTO `exp_table` VALUES (-32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30,30,30,30,30);
INSERT INTO `exp_table` VALUES (-33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28,28,28,28,28);
INSERT INTO `exp_table` VALUES (-34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26,26,26,26,26);
INSERT INTO `exp_table` VALUES (-35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24,24,24,24,24);
INSERT INTO `exp_table` VALUES (-36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22,22,22,22,22);
INSERT INTO `exp_table` VALUES (-37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20,20,20,20,20);
INSERT INTO `exp_table` VALUES (-38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19,19,19,19,19);
INSERT INTO `exp_table` VALUES (-39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,18,18,18,18);
INSERT INTO `exp_table` VALUES (-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,17,17,17,17,17);
INSERT INTO `exp_table` VALUES (-41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,16,16,16,16);
INSERT INTO `exp_table` VALUES (-42,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,15,15,15,15);
INSERT INTO `exp_table` VALUES (-43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14,14,14,14,14);
INSERT INTO `exp_table` VALUES (-44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
Reference in a new issue Copy permalink