Eve Online Empyrean Age 1.0 Database Dump for PostgreSQL
Today CCP announced the release of their MS SQL dump. Following in step with past conversions here is a Postgres version. Tested with 8.0.15 but should work on everything.
This dump is odd: CCP is using integers where they mean to use booleans. So in those cases remember 1 is true, 0 is false. Good luck.
Edit: As a note the Eve Online Database Viewer is updated with this dump.
Edit 2 (July 31, 2008): I nearly forgot to give props to bunjiboys for providing the .sql files from which the above dump is derrived.
The 001_schema.sql file does not include the primary key definitions or indexes exported in the MS SQL dump. I’ve added them to produce an updated schema script here:
http://owenja.dyndns.org/files/001_schema.v2.sql
Comment by Jason Owen — July 31, 2008 @ 2:20 am
Thanks for postgresifying this Lisa.
Jason@1: nice addition but any chance you could create the primary keys and indexes in a 999_indices.sql file? Generally much nicer to build the indices after loading the database rather than at the start and have to update the index on each insert…
Sure, I know, I’m expecting other people to do the work for me.
Comment by Sam — July 31, 2008 @ 12:36 pm
Sam: That’s a good idea.
http://owenja.dyndns.org/files/001_schema.v3.sql
and
http://owenja.dyndns.org/files/999_indices.sql
Comment by Jason Owen — July 31, 2008 @ 8:37 pm
Not to sound ungrateful, but I also meant you can create the primary keys at the end too with ALTER TABLE table ADD PRIMARY KEY ( keyfield ), saves you quite a bit of time because of the implicit index on the primary key.
Seriously though, thanks to both of you for saving me a bunch of typing, now if only I hadn’t run out of disk space on my server, d’oh…
Comment by Sam — July 31, 2008 @ 9:24 pm