| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 2 post(s) |
|
CCP Zirnitra
   |
Posted - 2009.05.15 15:24:00 -
[1]
Introducing the Apocrypha 1.2 data dump!
http://ccp.vo.llnwd.net/o2/data/Apocrypha_1.2.0.88517_db.zip
The following changes have been made, compared to the previous version:
- crtCertificates.categoryID changed to tinyint
The categoryID type was int in crtCertificates, but tinyint in crtCategories, but is now changed to be tinyint in both places
- The tables chrCareerSkills and chrCareerSpecialitySkills have been removed
These tables are no longer being used, and have been removed
We will have the toolkit page update to reflect the newest version in the near future, but we wanted to
|
|
EveMap
|
Posted - 2009.05.15 17:46:00 -
[2]
Edited by: EveMap on 15/05/2009 17:46:55
Zofu the magnificent has once again ported the datadump to mysql, postgresql, sqlite and the eve asset manager dump.
http://eve.no-ip.de/apo120/ get it naow!
|
Sigos
ORIGIN SYSTEMS
Shadows of Light
|
Posted - 2009.05.15 17:50:00 -
[3]
MySQL, SQLite, EVE Asset Manager, and Postgres conversions
|
Vessper
Indicium Technologies
|
Posted - 2009.05.15 18:00:00 -
[4]
MS Access version for anyone needing it: http://www.evehq.net/downloads/evehq_mdb_apoc1.2.zip
- - -
EveHQ Character App | Item Database |
ChaseTheLasers
|
Posted - 2009.05.17 14:37:00 -
[5]
Edited by: ChaseTheLasers on 17/05/2009 14:37:31
http://www.ekchu.com/dev/databases/
MySQL version with no extended inserts, for those that use scripts like BigDump
|
Kaylan Jahlar
Minmatar
Minmatar Industrial Limited
|
Posted - 2009.05.18 09:04:00 -
[6]
While trying to migrate this datadump to MySQL including all primary keys and indexes, I'm getting the following error:
Duplicate entry '40036795' for key 'PRIMARY'
While trying to import the mapCelestialStatistics table.
Is it just me?
|
Ellamar
|
Posted - 2009.05.18 18:15:00 -
[7]
My MySQL Import worked just fine. I don't know what you exactly mean with primary keys and indexes, but can look something up if that's helpful for you. This Table is very large with over 450000 rows! I'm using Sequel Pro 0.9.5.
I have a question as well. I don't find any relation between the items and the market group. I like to link items directly to the right market group. Is this possible?
BR Ellamar
|
Shir Akeena
Panta-Rhei
Guardian Federation
|
Posted - 2009.05.20 15:27:00 -
[8]
Edited by: Shir Akeena on 20/05/2009 15:31:10
each entry in invTypes has a groupID and marketGroupID. That's the relation.
--
Praise the Lord and hand over the ammunition |
LifeHatesMe
Royal Enterprise
|
Posted - 2009.05.22 17:33:00 -
[9]
 Originally by: ChaseTheLasers
Edited by: ChaseTheLasers on 17/05/2009 14:37:31
http://www.ekchu.com/dev/databases/
MySQL version with no extended inserts, for those that use scripts like BigDump
BigDump works great! However.. the database I downloaded from ekchu doesn't have all the wording for large texts like this one;SELECT `description` FROM `invtypes` WHERE `typeID` = '641';
Description: "The Megathron has established itself as one of the..." What I don't get.. is it says that the description field is a varchar(3000)... so why is it cutting off then.. ?
Originally by: Kaylan Jahlar
While trying to migrate this datadump to MySQL including all primary keys and indexes, I'm getting the following error:
Duplicate entry '40036795' for key 'PRIMARY'
While trying to import the mapCelestialStatistics table.
Is it just me?
I would try first selecting all the tables in phpMyAdmin, and dropping them. Then try another import. Sometimes you can accidentally press it twice, or the data gets read wrong. If it still doesn't work, re-download the dump, and try again. If that doesn't work.. you can try to search it with a program like wordpad for a duplicate entry. (notepad will not suffice since it loads files with RAM) I can't guarantee that wordpad won't truncate the file however.. so make sure to compare file sizes before/after if you attempt that.
Originally by: Shir Akeena
Edited by: Shir Akeena on 20/05/2009 15:31:10
each entry in invTypes has a groupID and marketGroupID. That's the relation.
I've heard that one of these relations doesn't always work, and the other is alot more reliable.. why is that.. ? And what's the difference between the two grouping id's?
|
|
CCP Explorer
|
Posted - 2009.05.25 22:02:00 -
[10]
Originally by: CCP Zirnitra
We will have the toolkit page update to reflect the newest version in the near future
And the download page has been updated. |
|
neoe77
Amarr
|
Posted - 2009.06.01 01:14:00 -
[11]
here is a csv version
---------
check path using eve-path-find |
Jack Tau
Caldari
Coalition of Nations
|
Posted - 2009.06.01 19:02:00 -
[12]
Why has all the ship information been removed from the npcs? This seems very strange, and makes my NPC explorer tool now completely useless.
prism-x lurves CON
Enkidu Production Manager |
Ph Ranger
|
Posted - 2009.06.04 04:47:00 -
[13]
Edited by: Ph Ranger on 04/06/2009 04:47:58
What is about localize version of eveNames table?
In russian client was translated names of NPC corporations.
For example "Republic University" = "Университет Республики".
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |