CREATE TABLE dbo.chrFactions(
 factionID int,
 factionName varchar(100),
 description varchar(1000),
 raceIDs INTEGER,
 solarSystemID int,
 corporationID int,
 sizeFactor float,
 stationCount smallint,
 stationSystemCount smallint);


CREATE TABLE dbo.eveUnits(
 unitID tinyint,
 unitName varchar(100),
 displayName varchar(20),
 description varchar(100));

CREATE TABLE dbo.invMetaGroups(
 metaGroupID INTEGER,
 metaGroupName varchar(100),
 description varchar(100),
 graphicID smallint);
 
CREATE TABLE dbo.invMetaTypes(
 typeID int,
 parentTypeID int,
 metaGroupID INTEGER);


CREATE TABLE dbo.TL2MaterialsForTypeWithActivity(
 typeID int,
 activity tinyint,
 requiredTypeID smallint,
 quantity int,
 damagePerJob DOUBLE PRECISION);

CREATE TABLE dbo.chrSchoolAgents(
 schoolID tinyint,
 agentIndex INTEGER,
 agentID int);

CREATE TABLE dbo.invFlags(
 flagID INTEGER,
 flagName varchar(100),
 flagText varchar(1000),
 flagType varchar(1000),
 orderID INTEGER);

CREATE TABLE dbo.invTypeReactions(
 reactionTypeID INTEGER,
 input bit,
 typeID int,
 quantity int);

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these behemoths is Titans, the largest spacefaring vessels ever constructed. The sheer cost in resources, manpower and time, as well as the necessary technological knowledge, makes construction of a Titan-class vessel a venture only empires can usually fathom. Some of these mammoth vessels have taken decades to assemble. Many are over a century old themselves, and the three mammoth Jovian motherships, the first Titans, have origins pre-dating modern space travel. They are

---

Originally by: Eewec Ourbyni

---

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these <snip>

---

Are we ever going to find out what "They are".....? Was hoping this was in this datadrop as it got cut off in the last one....

---

Originally by: Keikko Aranata

---

Originally by: Eewec Ourbyni

---

Originally by: select description from dbo.invGroups where record = 30

---

The collective name for these <snip>

---

Are we ever going to find out what "They are".....? Was hoping this was in this datadrop as it got cut off in the last one....

---

I don't understand why that is truncated at 500 characters. The table def says nvarchar 3000? Maybe when t20 can update the missing table defs and missing tables, and rename the dbo_* to dbo.* he can re-export so data isn't truncated? Sounds like a lot of work as I am a newbie, but please take pity on us t20 :)

---

Originally by: ItsIdMe

---

Originally by: Rede

---

Edited by: Rede on 09/12/2006 15:58:13
I was trying to import this stuff to MS-SQL Express, but stuck with true/false flags.

I get only:

Msg 128, Level 15, State 1, Line 3
The name "true" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Any help would be appreciated. Basically I need this to make SQLite3 database, but that's another story.

EDIT: I'm using management studio. If I need to use something else..?

---

You have to replace the true and false values with 1 and 0.
That worked for me anyway.

---

Originally by: Rede

---

Originally by: ItsIdMe

---

Originally by: Rede

---

Edited by: Rede on 09/12/2006 15:58:13
I was trying to import this stuff to MS-SQL Express, but stuck with true/false flags.

I get only:

Msg 128, Level 15, State 1, Line 3
The name "true" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Any help would be appreciated. Basically I need this to make SQLite3 database, but that's another story.

EDIT: I'm using management studio. If I need to use something else..?

---

You have to replace the true and false values with 1 and 0.
That worked for me anyway.

---

Worked for me too... But now I'm hitting new problems:

Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'dgmAttributeTypes' when IDENTITY_INSERT is set to OFF

This ms-sql stuff is killing me.. :)

---

Originally by: Rede

---

I can't import eveNames, I hit "out of memory" error - 1.5GB physical memory is not enough?

---

Originally by: ToxicFire

---

Originally by: Keikko Aranata

---

I don't understand why that is truncated at 500 characters. The table def says nvarchar 3000? <snip>

---

<snip> you will hit a few issues with nvarchar and char lengths that are over a certain number <snip>

---

Quote:

---

This is only the data, the icons will be rendered out tomorrow, alongside with the alliance logos for the alliance pages and most probably the item database on the website as well.

---

Originally by: Andargor theWise

---

FWIW this is my MySQL conversion:

<...>

CCP again forgot some CREATEs... So I guesstimated.

---

 Dim FileName As String = "SolarSystems"

 Dim sr As New StreamReader(Server.MapPath(FileName) & ".sql")
 Dim data As String = sr.ReadToEnd

 Dim re As New Regex("VALUES\((.*?)\)", RegexOptions.Singleline)

 Dim sw As New StreamWriter(Server.MapPath(FileName) & ".csv")
 For Each m As Match In re.Matches(data)
 Dim SqlRecord As String = m.Groups(1).Value
 Dim CsvRecord As String = ""
 Dim Columns As Array = SqlRecord.Split(",")

 For Each s As String In Columns
 If s.StartsWith("'") And s.EndsWith("'") Then
 s = s.Substring(1, s.Length - 2)
 End If
 If s.Contains("""") Then
 Throw New Exception("Oops!")
 End If
 CsvRecord += """" + s + """:"
 Next
 CsvRecord = CsvRecord.Substring(0, CsvRecord.Length - 1)
 sw.WriteLine(CsvRecord)
 Next
 sw.Close()

Originally by: Emily Spankratchet

---

Does anyone understand why there are negative values for some things in TL2MaterialsForTypeWithActivity?

Looking at the Vagabond blueprint (item ID 12000), there are negative values in activity 1 (manufacturing) for Trit (-271996), Pyer (-77203), Mex (-25832), Nocx (-506) and Zyd (-103).

In game, the blueprint doesn't appear to need those minerals. What's going on? Does it have some deep meaning, or is it a Db error or overflow problem?

---

Originally by: Emily Spankratchet

---

Originally by: Andargor theWise

---

FWIW this is my MySQL conversion:

<...>

CCP again forgot some CREATEs... So I guesstimated.

---

Great work, it's made my life a lot easier.

One small bit of feedback: In the table TL2MaterialsForTypeWithActivity you guesstimated the type for field damagePerJob as smallint. It should be float, as it has values in the range 0.0 to 1.0.

---

Originally by: Mortimus

---

i'm pretty sure if you look at the base T1 item print you'll discover that those are what's required to make it. Feel free to call me a dumbass because i never actually CHECKED that i just assumed that's what it was :)

---