Update SQL zip later today

Marc Duffy · 05-19-2006, 04:31 AM

Complete with Primary keys (thanks jarmenia) and the bug fix from the last SQL

Marc Duffy · 05-19-2006, 11:44 AM

I just had another dump!

Primary keys added to the SQL dump and those pesky bugs are fixed (that's not to say we didnt make more bugs)

Download the files from the same place again! Happy creating...

UKrookie · 05-19-2006, 01:02 PM

Thanks for the updated sql dump.

The good news is they all import with no errors, although you need to remove the first line in all the files editing out the drop table instruction since on a new install the table don't exist, that apart all is good.

jarmenia · 05-19-2006, 03:17 PM

Quote:

Originally Posted by UKrookie

Thanks for the updated sql dump.

The good news is they all import with no errors, although you need to remove the first line in all the files editing out the drop table instruction since on a new install the table don't exist, that apart all is good.

Or make your code check to see if the tables exist before trying to drop the table

UKrookie · 05-19-2006, 03:20 PM

Quote:

Or make your code check to see if the tables exist before trying to drop the table

If only, I imported them individually.

Marc Duffy · 05-19-2006, 06:07 PM

Quote:

Originally Posted by UKrookie

Thanks for the updated sql dump.

The good news is they all import with no errors, although you need to remove the first line in all the files editing out the drop table instruction since on a new install the table don't exist, that apart all is good.

Remember, this flag is configurable in the app config file talked about rhe other day.

jarmenia · 05-19-2006, 08:50 PM

Quote:

Originally Posted by Marc Duffy

Remember, this flag is configurable in the app config file talked about rhe other day.

What other parts of the dump are configurable with these flags? Its the first I've heard about them. And I thought I was almost done...

Marc Duffy · 05-23-2006, 06:57 AM

sqldump_syntax

1 -> 1 = MS Access Sets the SQL command syntax

sqldump_include_field_names_in_inserts

0 -> if you're just using the default table format without changing the table structure manually, you don't need the field names in the INSERT command. This will make the .sql files much smaller

sqldump_special_char_name_start

[ ->will be used before a table or field name

sqldump_special_char_name_end

] ->will be used after a table or field name

sqldump_drop_table

0 ->insert a drop table command for each table

sqldump_create_structure

1 ->insert a create structure command for each table

canadiancreed · 05-23-2006, 07:08 AM

is there a link at all for this?

Marc Duffy · 05-23-2006, 09:11 AM

How'd you mean?

canadiancreed · 05-23-2006, 09:21 AM

Quote:

Originally Posted by Marc Duffy

How'd you mean?

well I mean a link for the file or zip itself. UNless it's in another thread.

Marc Duffy · 05-23-2006, 09:23 AM

It's of no use since it works in conjuntion with the game exe

canadiancreed · 05-23-2006, 09:25 AM

Quote:

Originally Posted by Marc Duffy

It's of no use since it works in conjuntion with the game exe

oh

Marc Duffy · 05-23-2006, 10:35 AM

Bugs fixed
Even more data now exported
Added a CSV version now too

As a result of this, the download file size is approx 10x bigger

SQL - http://www.ootpbaseball2006.com/down...dump_mysql.zip
Access - http://www.ootpbaseball2006.com/down..._ms_access.zip
CSV - http://www.ootpbaseball2006.com/down...b_dump_csv.zip

canadiancreed · 05-23-2006, 10:51 AM

Quote:

Originally Posted by Marc Duffy

Bugs fixed
Even more data now exported
Added a CSV version now too

As a result of this, the download file size is approx 10x bigger

SQL - http://www.ootpbaseball2006.com/down...dump_mysql.zip
Access - http://www.ootpbaseball2006.com/down..._ms_access.zip
CSV - http://www.ootpbaseball2006.com/down...b_dump_csv.zip

links don't work

Marc Duffy · 05-23-2006, 10:53 AM

My bad, fixed

canadiancreed · 05-23-2006, 10:57 AM

Quote:

Originally Posted by Marc Duffy

My bad, fixed

thanks

and my GOD! This is sweet

The fun I can have with this......dammit I need mroe free time

One Q thought, all changes made in the SQL can be re-imported into the game and change what is in the game itself right?

andymac · 05-23-2006, 11:01 AM

Quote:

Originally Posted by canadiancreed

One Q thought, all changes made in the SQL can be re-imported into the game and change what is in the game itself right?

I don't believe this is the case at all, though it would be extremely nice.

Marc Duffy · 05-23-2006, 11:02 AM

No, this is not the case. It's a one way street.

canadiancreed · 05-23-2006, 11:06 AM

Quote:

Originally Posted by Marc Duffy

No, this is not the case. It's a one way street.

hmm ok that's what I figured. Just wondering regarding nations and names and what not.

Still a great step up from those damn .dat files

05-19-2006, 04:31 AM	#1 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	Update SQL zip later today Complete with Primary keys (thanks jarmenia) and the bug fix from the last SQL

05-19-2006, 01:02 PM	#3 (permalink)
UKrookie Minors (Double A) Join Date: Dec 2002 Location: Edinburgh, Scotland Posts: 176 Thanks: 0 Thanked 0x in 0 posts	Thanks for the updated sql dump. The good news is they all import with no errors, although you need to remove the first line in all the files editing out the drop table instruction since on a new install the table don't exist, that apart all is good. __________________ James IBA Reference WBL Tokyo Samurai UKBL Boston Red Sox NARBL SF Giants

05-23-2006, 07:08 AM	#9 (permalink)
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,022 Blog Entries: 1 Thanks: 462 Thanked 115x in 84 posts	is there a link at all for this? __________________ Once upon a time I stated if I ever got a warning it was time to go. It looks like that day has finally come.

05-23-2006, 10:35 AM	#14 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	Bugs fixed Even more data now exported Added a CSV version now too As a result of this, the download file size is approx 10x bigger SQL - http://www.ootpbaseball2006.com/down...dump_mysql.zip Access - http://www.ootpbaseball2006.com/down..._ms_access.zip CSV - http://www.ootpbaseball2006.com/down...b_dump_csv.zip Last edited by Marc Duffy; 05-23-2006 at 10:53 AM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

05-19-2006, 11:44 AM	#2 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	I just had another dump! Primary keys added to the SQL dump and those pesky bugs are fixed (that's not to say we didnt make more bugs) Download the files from the same place again! Happy creating...

05-23-2006, 06:57 AM	#8 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	sqldump_syntax 1 -> 1 = MS Access Sets the SQL command syntax sqldump_include_field_names_in_inserts 0 -> if you're just using the default table format without changing the table structure manually, you don't need the field names in the INSERT command. This will make the .sql files much smaller sqldump_special_char_name_start [ ->will be used before a table or field name sqldump_special_char_name_end ] ->will be used after a table or field name sqldump_drop_table 0 ->insert a drop table command for each table sqldump_create_structure 1 ->insert a create structure command for each table

05-23-2006, 09:11 AM	#10 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	How'd you mean?

05-23-2006, 09:23 AM	#12 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	It's of no use since it works in conjuntion with the game exe

05-23-2006, 10:53 AM	#16 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	My bad, fixed

05-23-2006, 11:02 AM	#19 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	No, this is not the case. It's a one way street.