6 lines
296 B
MySQL
6 lines
296 B
MySQL
|
-- BMC's own asset purpose, separate from hardware type and rental status.
|
||
|
|
-- Existing assets remain unclassified; customer hardware is not reclassified.
|
||
|
|
ALTER TABLE hardware_assets
|
||
|
|
ADD COLUMN IF NOT EXISTS bmc_asset_category VARCHAR(20)
|
||
|
|
CHECK (bmc_asset_category IN ('rental', 'internal'));
|