Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Primary Key Checks

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Primary Key Checks

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 20, 2004 at 3:09 pm #8575
      mmacrobert
      Member

      Hi.

      I'm using Bugzilla, which has a number of tables defined without primary keys. I've tried using SJA with limited success. The problem is that SJA fails on syncing some tables complaining “No PRIMARY KEY defined in table 'foo'”. Is there a way to get SJA to omit PRIMARY KEY checks as well as foreign key checks? If not, is there a known workaround?

      Thanks,

      Martin

    • September 20, 2004 at 5:46 pm #16293
      Ritesh
      Member

      Currently, SJA requires a PRIMARY KEY to sync table(s).

      If you dont have a PRIMARY KEY then the best solution would be to just add an auto_incremenet column to the table.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.