Skip to content

PLM Features Rename manufacturers table

Dale Scott edited this page Feb 24, 2026 · 9 revisions

A "manufacturers" table already exists for storing "brands" (used for sales reporting IIUC) and must be renamed in order to create a true manufacturers table.

Also see:

1. Change name table to "brands" and update column names and indexes.

image

2. Change script name from "Manufacturers.php" to "Brands.php"

% git mv Manufacturers.php Brands.php

3. Update code table and column references

To update code references

  • search for each of the old column names
  • replace the old column name with with the new name
  • find and replace the old table name for the commit with the new table name
image

Also no foreign key constraints or internal relationships exist.

image

3.1. manufacturers_id

image

3.2. manufacturers_name

image

3.3 manufacturers_url

image

3.4. manufacturers_image

image

Clone this wiki locally