No relationships between tables?

  • Anonymous - 2010-12-25

    Is there a good reason to have all database tables without relationships be tween them? Looks like the database integrity controls are software driven instead of db engine driven.

  • Hendrik Brummermann

    No, there is no good reason.

  • Anonymous - 2010-12-25

    Is this something the team is against? I thought it was a design decision. Are you guys willing to take a patch on that? Should be only a DB upgrade thing.

  • Miguel Angel Blanch Lardin

    Hehe, I listened to several beeps on my ears and I decided to check email :)
    Happy xmas to all by the way.

    There is no relations in DB tables mainly because I coded the simplest and fastest (to do) thing. I suppose that after time, as hendrik rewrote most of the database code (mess),  decided not to change what was working.

    The original tables were more complex and I didn't want problems with database stuff ( apart of the problems other things were doing ).

  • Hendrik Brummermann

    I am fine with adding not null constraints and foreign keys. Provided that it works on both MySQL and H2.

    Changing the table structure of gameEvents and itemlog by replacing the character name with a character id, however, does not seem to be worth the trouble. It would require to take offline for a couple of days.

  • Anonymous - 2010-12-26

    So should I provide a patch? I already have those changes and have to test it anyways in both DB engines.



Cancel  Add attachments

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks