Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

  • No constraints in 3.0 database?

    Posted by daniels on March 15, 2010 at 17:21

    Hi folks.

      I noticed that the 3.0 database has no constraints. Is that right? I migrate from 2.1 and had a lot of manual work in database to make them match. I would like to know if the constraints where indeed removed in the 3.0 version of the database.

      Regards.

    daniels replied 14 years, 8 months ago 2 Members · 2 Replies
  • 2 Replies
  • Sancho

    Administrator
    April 5, 2010 at 02:04
    2229 Karma points
    Community awards: bulb Bright ideas
    Community rank: tentacle_master_icon Tentacle Master
    Like it
    Up
    0
    Down
    Drop it
    ::

    Weird 😕

    No database constraints has been removed, in fact, alert system has it’s constraings, as well as update manager tables, and report tables.

    Have you changed your Mysql settings or something ?

    Hi folks.

      I noticed that the 3.0 database has no constraints. Is that right? I migrate from 2.1 and had a lot of manual work in database to make them match. I would like to know if the constraints where indeed removed in the 3.0 version of the database.

      Regards.

  • daniels

    Member
    April 15, 2010 at 22:36
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    The database schema update was hard and I had to do a lot of things by hand…

    I put the constrains by hand as I saw in a test environment with a brand new 3.0 version installed. So, now, (I think) I have the database schema ok.

    Regards.