EVE Forums

 
Capture Portrait
  • Date of Birth: 2006-12-17 23:08
  • First Forum Visit: 2011-10-06 01:51
  • Number of Posts: 1
  • Bounty: 0 ISK
  • Likes Received: 0

Joel McBeth

Security Status 4.4
  • Amok. Member since
  • Goonswarm Federation Member since

Last 20 Posts

  • Static Data Export & Image Export for Incarna 1.1 in EVE Technology and Research Center

    Quote:
    -- Adding a whole lot of foreign key constraints to signify the relationship between the new tables and the current ones.
    -- Seriously.. am I the only one really tired of all the pro-protoss players being so Colossus reliant in every matchup?!
    -- And what the **** is up with the proposed High Templar nerf?! Can we get a colussus nerf so that people at least attempt to find new plays!


    Found this guy in the comments?

    I also get multiple errors when trying create the foreign key contraints in the bottom of the file. So far two can't be created because of a type mismatch and trying to create a foreign key on a table field that doesn't exist.

    Msg 1769, Level 16, State 1, Line 89
    Foreign key 'eveOwners_FK_owner' references invalid column 'itemID' in referencing table 'eveOwners'.
    Msg 1750, Level 16, State 0, Line 89
    Could not create constraint. See previous errors

    ALTER TABLE eveOwners ADD CONSTRAINT eveOwners_FK_owner FOREIGN KEY (itemID) REFERENCES invItems(itemID)

    There is no itemID in eveOwners.

    Also, invItems.itemID is a bigint and eveNames.itemID is an int.

    This is with SQL Server Express 2008.