[WIP] More Readable DB

[substep]

Hello everyone,

 

I went through most of the SQL files and noticed how atrocious the syntax was and decided to clean it up a bit. Shouldn't have any affect on the actual execution (especially since MySQL supports this new format).

As most of up know, the current syntax is this for all the sql files:

REPLACE INTO `mob_db_re` VALUES (1018,'CREAMY','Creamy','Creamy',23,378,1,144,162,1,61,62,28,20,16,1,1,0,1,20,10,12,0,4,24,0x181,150,1136,720,840,0,0,0,0,0,0,0,924,9000,2322,10,518,150,602,100,2207,2,712,500,692,100,0,0,0,0,4040,1);

Ill be changing the mob,item and mob skill db's to this:

REPLACE INTO `mob_db_re`
       (a,b,c,d,e,f,g,h,i,j,k)
VALUES (a,b,c,d,e,f,g,h,i,j,k),
       (a,b,c,d,e,f,g,h,i,j,k);

It should work unless there is something I don't know about. Also Ill be adding a lot of whitespace so they all line up nicely in rows and columns in case anyone wants to do some serious editing. Its tedious but it should help everyone out in the long run.

 

Mob_db_re: 3% complete <- This is a total lie (its more like 1% lol)

Mob_db2_re: 0%

Item_db_re: 0%

Item_db2_re: 0%

mob_skill_db_re: 0%

mob_skill_db2_re:0%

Edited March 27, 2015 by substep