Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ConfigboxUpdateHelper::getFkConstraintName($tableName, $columnName) : string[] - Returns an array of foreign key constraints for related to the given column

Best Practices

  • Test upgrade scripts very thoroughly before committing to VCS or deployment - be aware of how much effort goes into rectifying a messy situation with upgrades

  • Before committing to VCS, see if colleagues already committed an upgrade script of the same name. DO NOT MERGE, but pick the next version number and check how both scripts will interplay

  • Make use of the method in ConfigboxUpdateHelpers. There are methods that check if tables, columns, keys and constraints exist alreadymethods in ConfigboxUpdateHelpers to keep the scripts easily readable.