OOTP Developments Forums - View Single Post

BMW · 04-14-2007, 01:29 PM

I apologize if this is already somewhere, but I have not been able to track it down.

Does someone know where a document with the table schema for the 2007 SQL dump output?

Much of it is easy to figure out, but the definition of fields like "IPF" on the fielding table elude me. I searched this board in particular, and three separate charts of stat abbreviations, and I cannot figure out what it is.

Some are easily deduced, like the CASE statements I need to write for League_Levels (1=ML, 2=AAA, 3=AA, etc...)

But does anyone have documentation for this?

Thanks,
Bryan

04-14-2007, 01:29 PM	#1
BMW Hall Of Famer Join Date: May 2003 Location: New Jersey Posts: 2,030	SQL Dump Table Schema I apologize if this is already somewhere, but I have not been able to track it down. Does someone know where a document with the table schema for the 2007 SQL dump output? Much of it is easy to figure out, but the definition of fields like "IPF" on the fielding table elude me. I searched this board in particular, and three separate charts of stat abbreviations, and I cannot figure out what it is. Some are easily deduced, like the CASE statements I need to write for League_Levels (1=ML, 2=AAA, 3=AA, etc...) But does anyone have documentation for this? Thanks, Bryan