MSSQL TO MYSQL

For discussion of the BB stats code.
nos

MSSQL TO MYSQL

Postby nos » Sun Jan 06, 2008 1:51 pm

hey guys,

Does anyone have any idea on what would be the easiest way to
convert the MSSQL tables to mysql tables?

I really dont want to have to set it up manually im to lazy for that lol.

User avatar
Piers
Comfortable with my sexuality
Comfortable with my sexuality
Posts: 1408
Joined: Fri Dec 02, 2005 7:57 am
Location: Horse country

Re: MSSQL TO MYSQL

Postby Piers » Sun Jan 06, 2008 1:59 pm

Just do a sqldump in MSSQL - I'm assuming Mort's already done this in the package - then run mysql < sqltables.sql (or whatever the database table file is called).

The majority of the changes you'll need to make to the code are to make it compliant instead of M$ code - change things like SELECT TOP x to SELECT ... LIMIT x
Image

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Sun Jan 06, 2008 2:27 pm

There is a file called "player2142.sql" that has all the table create stuff in it. I would guess for MySQL it would probably work if you just take out all the "COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL" parts.

The "CREATE UNIQUE" and "CREATE INDEX" at the bottom would probably need to be changed as well, but you could get the tables created without them and work out the INDEX command later on. It's not critical to it working, but is mostly there to prevent duplicate entries in the database.

I'm working on getting a new testing environment running, and will probably look at having a MySQL database to play around with, but don't hold your breath on that one :)
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Sun Jan 06, 2008 3:02 pm

nope MSSQL and MYSQL syntax is different, its cant be edited quickly.

MYSQL

Code: Select all

CREATE TABLE `members` (
  `index` int(20) NOT NULL auto_increment,
  `id` varchar(20) collate latin1_general_ci NOT NULL default '',
  `pid` int(10) NOT NULL default '0',
  PRIMARY KEY  (`index`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=30 ;


MSSQL

Code: Select all

CREATE TABLE [dbo].[PID2142] (
   [PID] [varchar] (16) COLLATE Latin1_General_CI_AS NOT NULL ,
   [Nick] [varchar] (24) COLLATE Latin1_General_CI_AS NOT NULL ,
   [Name] [varchar] (255) COLLATE Latin1_General_CI_AS NULL ,
   [GetStats] [varchar] (1) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO


I was hoping someone had come across a conversion tool,
Been googling but cant find one.

suppose i will just have to code one up in visual basic.
All that needs to be done is replace a few things here and there.

Nos

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Sun Jan 06, 2008 3:13 pm

I used a conversion tool called SwissSQL to help me got some of my phpBB mods worked out. There are conversion tools out there, and this code is a simple table create script, so it shouldn't be too hard to modify.

I''ll tell you what, give me the bones of what a MySQL sql for the main db would look like and I'll create the total script. The start/end bits and a couple of sample field create statements in between...
Image

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Sun Jan 06, 2008 3:58 pm

Ignore this for the moment, it's just a place holder to remind me later on. I figure this should be good enough to use as a template.

Code: Select all

'CREATE TABLE `zones` (
        `zid` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,
        `zdesc` VARCHAR( 150 ) NOT NULL,
        `zwidth` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
        `zheight` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
        `zmax` MEDIUMINT(7) unsigned NOT NULL default 12288,
        PRIMARY KEY ( `zid` )
       )'
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Mon Jan 07, 2008 8:53 am

That would be great but what exactly are u going to do?
if your planning on manually editing the sql file i can help u out
its a huge DB.

Nos

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Mon Jan 07, 2008 10:14 am

I was just going to create a MySQL version of the SQL script for creating the database table to try and help out the conversion. Nothing too fancy.

One thing to keep in mind. We have all the fields set as varchars simply because when we first started we didn't know what data types and lengths they might be. As I host the SQL server on my own server, trying to optimise it by specifying more correct data types was never a issue I got around to fixing up... that might be something you want to think about. Even so, we've got almost 2 years of stats for about 20 people and the database is pretty small (have to check size when I get home) so it just depends on what limits you might have with your own hosting provider.

One other point, don't go setting "DEFAULT" values in your SQL database for things like PID and ASOF. You never want anything other than a specified value in those fields, if no value is supplied then it would be better to have the query throw an error than to add "Default" values in the database that can screw things up.
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Mon Jan 07, 2008 11:25 am

its ok mort i got the DB converted, I just made a little mssql to mysql table conversion tool.

just about to set the stats parse up on my local machine, I have gone through the code and
updated it to work with mysql instead of mssql and i think it should be ready to go.

now the fun part, trying to figure out exactly how i should display all this info.

PS:
One other point, don't go setting "DEFAULT" values in your SQL database for things like PID and ASOF. You never want anything other than a specified value in those fields, if no value is supplied then it would be better to have the query throw an error than to add "Default" values in the database that can screw things up.


should i have no default values set at all or just on those 2 items?
I'm not exactly sure what u mean by the values will screw things up?.

cheers
Nos

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Mon Jan 07, 2008 3:15 pm

nos wrote:PS:
One other point, don't go setting "DEFAULT" values in your SQL database for things like PID and ASOF. You never want anything other than a specified value in those fields, if no value is supplied then it would be better to have the query throw an error than to add "Default" values in the database that can screw things up.


should i have no default values set at all or just on those 2 items?
I'm not exactly sure what u mean by the values will screw things up?.

cheers
Nos
The PID and ASOF values are basically your uniqueness keys, so you don't want there to be any duplicates produced. If you have defined a DEFAULT value, then if for some reason your scripts fail to populate the field, the default will be applied instead. This could create multiple entries with the same PID and ASOF values.

For our system, I have *no* default values defined at all, if anything, just allow NULLS on the stats values because in some cases players may not have played with a certain weapon or map and there won't be any data returned for those fields at all. That way you can tell the difference between a player who hasn't used a weapon etc at all (kills = NULL) compared to a player that just sucks at using that weapon (kills = 0) :) There are other ways to determine that sort of thing for that example, but I hope you see what I'm getting at.

From memory though, PID, ASOF are *the* key fields that you don't want NULL values allowed, and no Default values defined. That way you won't have "unknown" stats data collected for anyone unless those fields are explicitely populated. If your script played up and you ended up with data assigned to PID=0 at ASOF=0 then you wouldn't know which PID it should really belong to, or when the stats were read from EA.

And if you want to pass on the script for creating the MySQL tables I'll add it to the stats code bundle.
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Tue Jan 08, 2008 9:39 am

ok no thanks for explaining that mort makes allot more sense now.
I'll be working hard on creating the php version over the next week.

The way i actually converted the mssql to mysql wasn't with a script
just coded a little app up in visual basic, its nothing fancy just load
up an mssql table and it will do a basic conversion of all the mssql tbl items.

i can post it if u like but it really is nothing special looks very raw and ugly
but it does the job.

One question I did have with the mssql tables, Do all mssql table end with
"ON [PRIMARY] GO"? its just what i used to parse the end off the table
i know its lazy but it will do if its a constant end table statement.

PS;
Who makes your cool sigs, I loved the one u had the other day that
was changing through a heap of different game stats.

Cheers
Nos

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Wed Jan 09, 2008 8:26 am

Those SQL scripts are just that, scripts. In MSSQL you copy open them in Query Analyzer and "run" them to create the table, so the statements "ON [PRIMARY] GO" at the end aren't anything to do with the actual tables themselves, but are just the command that says "go ahead and do it now". I don't know your experience with SQL, so I apologise if I'm "teaching" you stuff you already know, but just think of those SQL scripts the same as a VBScript, php script or whatever. You could just type each line seperately and it would achieve the same result, or you could use the info in eac line and just create the table manually in Myphpadmin (or whatever it's called).

Don't worry about the conversion thing, for something like this I'd just use Excel actually, much easier. If you do have a copy of the converted script that you know worked I'd be interested in that.

The sig thing is a Team Fortress 2 sig generator done at another site. I was going to set up some TF2 stats for us, but as a clan we aren't into it enough to justify it.
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Wed Jan 09, 2008 9:39 am

thanks mort,

I understand how MYSQL tbl structure works I just needed to know if the "ON [PRIMARY] GO" at the end was always present
at the end of the table.anyways heres the coverted table for mysql.

MYSQL Player2142

Code: Select all

CREATE TABLE `player2142` (
`index` int(20) NOT NULL auto_increment,
`acdt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`adpr` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`akl` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`akpr` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`asof` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`atp` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`attp-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`attp-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`Avcred` VARCHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`award` VARCHAR(1000) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`awin-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`awin-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`awybt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`bksgpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`bksgpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`bnspt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`brs` VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`capa` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`cb` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`cpt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`crpt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`cs` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`csgpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`csgpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`csgpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ctgpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ctgpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`cts` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`dass` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`dcpt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`dpm` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`dstrk` VARCHAR(3) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`dths` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ent` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ent-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ent-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ent-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`expts` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fe` VARCHAR(2) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fgm` VARCHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`first` VARCHAR(1000) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fk` VARCHAR(1) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fm` VARCHAR(2) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fv` VARCHAR(2) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`fw` VARCHAR(2) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`gsco` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`hkl` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`hls` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`htp` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kdr` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kgpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kgpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kkls-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kkls-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kkls-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kkls-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`klla` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`klls` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`klse` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`klsk` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`klstrk` VARCHAR(3) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kluav` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kpm` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ktt-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ktt-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ktt-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ktt-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`level` VARCHAR(1000) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`lgdt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`los` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`md` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-0-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`nick` VARCHAR(24) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ovaccu` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`pdt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`pdtc` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`pid` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`resp` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`rnk` VARCHAR(3) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`rps` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`rvs` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`sasl` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`slbcn` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`slbspn` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`slpts` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`sluav` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`spm` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`suic` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tac` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`talw` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tas` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tasl` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tasm` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tcd` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tcrd` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tdmg` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tdrps` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tds` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tgd` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tgpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tgpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tgr` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tid` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tkls` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`toth` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tots` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`trp` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`trpm-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`trpm-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tt` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ttp` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tvdmg` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`twsc` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`unlc` VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`unlockid` VARCHAR(42) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`when` VARCHAR(1500) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`win` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-28` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-29` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-0` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-17` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-18` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-19` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-20` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-21` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-22` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-23` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-24` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-25` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-26` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-27` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-3` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-30` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-4` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-5` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-6` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-7` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-8` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-9` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`bksgpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`bp-1` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`ctgpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etp-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`etpk-16` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`kgpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tgpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`trpm-2` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdstry-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vdths-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkls-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vtp-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkls-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wdths-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wshts-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`whts-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`waccu-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wkdr-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtp-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`wtpk-31` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`tags` VARCHAR(512) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkdr-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkrls-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vkrls-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`vrkls-15` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-2-10` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-2-11` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-2-12` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-1-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mtt-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mwin-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mlos-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mbr-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`msc-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-2-13` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
`mkls-2-14` VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_bin NULL,
PRIMARY KEY  (`index`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=30 ;


updated DataFeed.php

Code: Select all

<?php
//$startTime = gettimeofday(true);
//ini_set("user_agent","GameSpyHTTP/1.0");
//ini_set("max_execution_time","200");
set_time_limit(200);
require_once("ea_support.php");

// ***************************
// ***************************
// Edit this list with your player details

// The first element should be left as 'base', the last element does *not* have a comma at the end of the line!
$pidList = array(
   array('base','00000000'),
   array('player1' ,'`123456789'),
   array('player2','123456789'),
   array('player3','123456789')
);
// ***************************
// ***************************

$authList = array();
$allstat = array();

/* let's get some auths for later use NOTE that [0] is the 0 pid for general use */
for ($i = 1; $i < count($pidList); $i++) {
   $authList[$i] = getAuth($pidList[$i][1]);
}
/*
FUNCTIONS:
getbackendinfo ? auth= [ using PID = 00000000 ]
getawardsinfo ? auth= pid=
getunlocksinfo ? auth= pid=
getplayerinfo ? auth= pid= mode=[base*|ovr|ply|titan|wrk|com|award?|wep|veh|map] [*pToken=]
*/
$global_asof = "";
$pids = "";
for ($i = 1; $i < count($pidList); $i++) {
   $pids .= $pidList[$i][1].",";
}
$pids = rtrim($pids,", ");
for ($i = 1; $i < count($pidList); $i++) {
   // gather stats for each pid
   $stat = array();
   getData('getawardsinfo','',     $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getunlocksinfo','',    $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','award',$pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','ovr',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','ply',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','titan',$pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','wrk',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','com',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','wep',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','veh',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
   getData('getplayerinfo','map',  $pidList[$i][1],$authList[$i],$stat,$global_asof);
// ***************************
// ***************************
// Uncomment the next line if you want to track your own inter-clan dogtag collection!
   //getTags($pidList[$i][1],$authList[$i],$pids,$stat);
// ***************************
// ***************************

   // now combine into one array
   $allstat[$i] = array();
   for ($di=0; $di<count($stat); $di++) {
         $allstat[$i] = array_merge($allstat[$i],$stat[$di]);
   }
   // put them into the database
   $columns = ''; $values = ''; $numfields = 0;
   foreach ($allstat[$i] as $key => $value) {
      $columns .= "`".$key."`, ";
      $values .= "'".$value."', ";
      $numfields++;
   }
// This SQL string has been tested specifically on Microsft SQL, but should also work for MySQL
   $sqlString = "INSERT into player2142 (".rtrim($columns,", ").") VALUES(".rtrim($values,", ").");";
   echo $pidList[$i][0].": ".$numfields." fields<br>\n" .$sqlString."<hr>\n";

// ***************************
// ***************************
// Update these variables with the relevant Database names and user account
   $dbhost = "dbhost";
   $dbuser = "dbuser";
   $dbpass = "dbpass";
   $dbname = "dbname";

// ***************************
// ***************************

   $db = mysql_pconnect($dbhost,$dbuser,$dbpass);
   mysql_select_db("$dbname",$db);
   mysql_query($sqlString);

}
//$endTime = gettimeofday(true);
//$timeTaken = $endTime - $startTime;
//echo "\n<br />".$timeTaken." seconds taken to process data.\n";

function getData($qFn,$mode,$pid,$auth,&$stat,&$global_asof) {
   $qSv = 'stella.prod'; // 'bf2142web'
   $theURI = 'http://'.$qSv.'.gamespy.com/'.$qFn.'.aspx?pid='.$pid.'&auth='.$auth;
   if ($qFn == 'getplayerinfo') { $theURI .= '&mode='.$mode; }
   $data = file($theURI);
   $headers = array();
   $therecord = array();
   for ($di=0; $di<count($data); $di++) {
      $temparr = explode("\t", rtrim($data[$di]));
      if ($temparr[0] == 'H') {
         if (isset($headers[0])) {
            $stat[] = array_change_key_case($therecord);
            $therecord = array();
         }
         $headers = $temparr;
      } elseif ($temparr[0] == 'D') {
         for ($ti=1; $ti<count($temparr); $ti++) {
            if ($headers[$ti] == 'asof') {
               if ($global_asof == "") { $global_asof = $temparr[$ti]; }
               $therecord[$headers[$ti]] = $global_asof;
            } else {
               if (isset($therecord[$headers[$ti]])) {
                  $therecord[$headers[$ti]] .= ','.$temparr[$ti];
               } else {
                  $therecord[$headers[$ti]] = $temparr[$ti];
               }
            } // end sep of asof
         }
      }
   }
    $stat[] = array_change_key_case($therecord);
   
}

function getTags($pid,$auth,$pids,&$stat) {
   $qSv = 'stella.prod'; // 'bf2142web'
   $theURI = 'http://'.$qSv.'.gamespy.com/getleaderboard.aspx?pid='.$pid.'&auth='.$auth;
   $theURI .= '&pos=1&after='.count(explode(",",$pids)).'&type=overallscore';
/* this if we are just doing clan: */
   $theURI .= '&buddiesFilter='.$pids;
/* this if we are doing global:
   $theURI .= '&dogTagFilter=1'; */
   $data = file($theURI);
   $therecord = array();
   for ($di=0; $di<count($data); $di++) {
      $temparr = explode("\t", rtrim($data[$di]));
      if ($temparr[0] == 'D') {
         if ($temparr[9]==1) { /* clan-only w/ tag */
            if (isset($therecord['tags'])) {
               $therecord['tags'] .= ','.$temparr[4];
            } else {
               $therecord['tags'] = $temparr[4];
            }
         } /* end clan-only w/ tag */
      }
   }
   if (isset($therecord['tags'])) {} else { $therecord['tags']=''; }
   $stat[] = array_change_key_case($therecord);
}

function getAuth($code) {
  $bfcoding  = &new ea_stats();
  $code = dwh(dechex(time())).dwh(dechex(100)).dwh(dechex($code))."0000";
  $code.= CalcCRC($code);
  $result = $bfcoding->DefEncryptBlock($bfcoding->hex2str($code));
  return $bfcoding->getBase64Encode($result);
}

function dwh($h) {
  $s = substr("0000000".$h, -8);
  return substr($s,6,2).substr($s,4,2).substr($s,2,2).substr($s,0,2);
}

function XOR32 ($a, $b) {
  $a1 = $a & 0x7FFF0000;
  $a2 = $a & 0x0000FFFF;
  $a3 = $a & 0x80000000;
  $b1 = $b & 0x7FFF0000;
  $b2 = $b & 0x0000FFFF;
  $b3 = $b & 0x80000000;
  $c = ($a3 != $b3) ? 0x80000000 : 0;
  return (($a1 ^ $b1) |($a2 ^ $b2)) + $c;
}

function SHR32 ($x, $bits) {
  if ($bits==0) return $x;
  if ($bits==32) return 0;
  $y = ($x & 0x7FFFFFFF) >> $bits;
  if (0x80000000 & $x) {
    $y |= (1<<(31-$bits));
  }
  return $y;
}

function SHL32 ($x, $bits) {
  if ($bits==0) return $x;
  if ($bits==32) return 0;
  $mask = (1<<(32-$bits)) - 1;
  return (($x & $mask) << $bits) & 0xFFFFFFFF;
}

function SAL32 ($x, $bits) {
  $s = str_pad(decbin ($x),32,"0",STR_PAD_LEFT);
  return bindec(substr($s,$bits).substr($s,0,$bits));
}

function SAR32 ($x, $bits) {
  $s = str_pad(decbin ($x),32,"0",STR_PAD_LEFT);
  $r = 32-$bits;
  return bindec(substr($s,$r,$bits).substr($s,0,$r));
}

function AND_FF ($x) {
  return str_pad(decbin ($x & 255),32,"0",STR_PAD_LEFT);
}

function CalcCRC($h) {
  $eax = 0;
  for($esi=0; $esi<14; $esi++) {
    $ecx = $eax;
    $ecx = SAR32($ecx,8);
    $ecx&= 255;
    $eax = SHL32($eax,8);
    $ecx|= $eax;
    $eax = hexdec(substr($h,$esi*2,2));
    $eax = XOR32($eax,$ecx);
    $ecx = ($eax&255);
    $ecx = SHR32($ecx,4);
    $eax = XOR32($eax,$ecx);
    $ecx = $eax;
    $ecx = SHL32($ecx,12);
    $eax = XOR32($eax,$ecx);
    $ecx = $eax;
    $ecx&= 255;
    $ecx = SHL32($ecx,5);
    $eax = XOR32($eax,$ecx);
  }
  $eax&= 65535;
  $hex = substr("0000".strtoupper(dechex($eax)), -4);
  return substr($hex,2,2).substr($hex,0,2);
}
?>


Cheers
Nos

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4232
Joined: Thu Dec 01, 2005 10:40 pm

Re: MSSQL TO MYSQL

Postby Mort » Wed Jan 09, 2008 10:02 am

I notice you've put an "Index" field in there? Do you have any particular reason for needing it? The "ASOF" and "PID" fields should be your key fields, and I've found it best to use them as a combined index to generate unique records. ASOF+PID are the two fields that are most referenced by everything and are much better suited as key index fields than having a generic incrementing "index" field.

Thanks for the updates though, I'll check out the changes and merge them as required.
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Wed Jan 09, 2008 12:42 pm

Just added the index field because I had not noticed the Index fields on the ASOF and pid
thanks for the tip I'll mod the tbl.

cheers
nos


Return to “The Buddabudda Stats system”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests