12 lines
408 B
MySQL
12 lines
408 B
MySQL
|
-- Migration 014: Add user_company field to contacts
|
||
|
|
-- Adds company/organization field to contact records
|
||
|
|
|
||
|
|
ALTER TABLE contacts
|
||
|
|
ADD COLUMN IF NOT EXISTS user_company VARCHAR(255);
|
||
|
|
|
||
|
|
-- Add index for searching by company
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_contacts_user_company ON contacts(user_company);
|
||
|
|
|
||
|
|
-- Add comment
|
||
|
|
COMMENT ON COLUMN contacts.user_company IS 'Company/organization name from vTiger contact';
|