//
// DO NOT MODIFY!!! UNLESS YOU ARE AN XLSP ADMIN
//

"SqlConfig"
{

	//
	// Defines SQL connection parameters
	//

	"db"
	{
		host   gamestats
		port   3306
		user   x360test
		pwd    test
		schema x360mastertest
		table  testdata
	}

	//
	// Defines what data will be written to the table
	// from user stat packets and table fields
	//
	//  statfield	dbfield
	//

	"tabledef"
	{
		titleid		titleid
		
		version		version
		verrprt		verrprt
		dlcmask		dlcmask

		xuid		xuid
		name		gamertag
		
		lv			lv

		xrgn		xrgn
		xlng		xlng
		xloc		xloc

		scrw		scrw
		scrh		scrh
		vidi		vidi
		vidw		vidw
		vidh		vidh
		vids		vids
		scrr		scrr
		
		snd			snd
		joy			joy

		urgn		urgn
		uach		uach
		uzon		uzon
		ucrd		ucrd
		utit		utit
		udif		udif
		usns		usns
		uyax		uyax
		
		utia		utia
		utic		utic

		*dcpgmi		dcpgmi
		*dcpgme		dcpgme
		*dcpgbu		dcpgbu
		*dcbwup		dcbwup
		*dcbwdn		dcbwdn

		*******		dcid
	}

	//
	// Defines what data will be written to the table
	// when user stat packet does not contain the field
	// defaults to NULL if not specified below
	//
	//  dbfield		valuestring
	//

	"defaultvalues"
	{
		dcid		1
	}

}