8 lines
392 B
SQL
8 lines
392 B
SQL
-- Add created_at column to profiles table
|
|
-- This tracks when the user profile was created
|
|
-- The DEFAULT CURRENT_TIMESTAMP will automatically populate this for both existing and new profiles
|
|
|
|
ALTER TABLE public.profiles
|
|
ADD COLUMN created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP;
|
|
|
|
COMMENT ON COLUMN public.profiles.created_at IS 'Timestamp when the user profile was created';
|