7 lines
265 B
SQL
7 lines
265 B
SQL
-- Add category (enum) and subcategory (free text) to inventory items
|
|
ALTER TABLE app.inventory_item
|
|
ADD COLUMN category TEXT NOT NULL DEFAULT 'operations',
|
|
ADD COLUMN subcategory TEXT;
|
|
|
|
CREATE INDEX idx_inventory_item_category ON app.inventory_item(category);
|