Эта страница поможет создать таблицу для хранения активностей в CRM системе.
-- Создание таблицы активностей 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;