11 lines
368 B
SQL
11 lines
368 B
SQL
-- Database Schema Update for Customer Profiles
|
|
|
|
-- Add 'address' column to 'icon_customers' if it doesn't exist
|
|
DO $$
|
|
BEGIN
|
|
IF NOT EXISTS (SELECT 1 FROM information_schema.columns
|
|
WHERE table_name = 'icon_customers' AND column_name = 'address') THEN
|
|
ALTER TABLE icon_customers ADD COLUMN "address" text;
|
|
END IF;
|
|
END $$;
|