🛠️ Создание таблицы активностей

-- Создание таблицы активностей CRM
DROP TABLE IF EXISTS crm_activities CASCADE;

CREATE TABLE crm_activities (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  deal_id UUID NOT NULL,
  contact_id UUID,
  type VARCHAR(50) NOT NULL,
  subject VARCHAR(255) NOT NULL,
  description TEXT,
  activity_date TIMESTAMPTZ NOT NULL,
  duration INTEGER,
  outcome VARCHAR(50) DEFAULT 'pending',
  is_completed BOOLEAN DEFAULT FALSE,
  created_by UUID,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX idx_crm_activities_deal_id ON crm_activities(deal_id);
CREATE INDEX idx_crm_activities_date ON crm_activities(activity_date);

ALTER TABLE crm_activities ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Allow all for authenticated users" ON crm_activities
  FOR ALL USING (auth.role() = 'authenticated');

INSERT INTO crm_activities (deal_id, type, subject, activity_date, description) 
VALUES (
  '00000000-0000-0000-0000-000000000000', 
  'note', 
  'Тестовая активность', 
  NOW(),
  'Таблица активностей создана успешно!'
);

SELECT 'crm_activities table created successfully' as status;