db.sql

INSERT INTO
    "public"."blockkeyword" ("text", "created_at", "user_id")
VALUES
    (
        'https://wa.me',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'أنصحكم فيها صراحة',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'اتصل بنا الآن للحصول',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'اضغط المشبك',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'اعداد البحوث باللغتين',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'اعطيك احد يحل فل مارك',
        '2024-02-19 19:10:29.482826+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'الدفع بعد',
        '2024-02-15 16:12:20.500052+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'انا مصمم فلسطنيي',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'بدون فلوس',
        '2024-02-27 19:22:19.13035+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'بدون مقابل',
        '2024-02-14 17:03:30.505531+00',
        'dcb2d2ae-4039-4172-a347-7d324337eca8'
    ),
    (
        'بلوشي',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'تواصل الآن على الوات.ساب',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'تواصل على الواتساب',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'خدماتنا مضمونة',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'دون مقابل مادي',
        '2024-02-28 21:03:45.321797+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'سلام ذي مختصة تحل واجبات',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'ضمان الفل مارك',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'عمل سيره ذاتية',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'لتواصل عبر الواتساب',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'لجميع الخدمات الطلابية',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'لطلب الخدمة',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'لطلب المساعده',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'للتواصل',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'للتواصل أو الاستفسار عبر واتساب',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'لو احد محتاج دكتور',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'مجان ',
        '2024-02-28 21:04:43.213204+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        '(منصة الأمتياز)',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'مواعيد اختبار التحصيلي',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'هذا رقمه',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'هذي دكتوره تساعد وحلها كويس مجربه',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    ),
    (
        'يتواصل ع الرقم',
        '2024-02-28 21:04:51.610793+00',
        '7ae51109-17d1-4c42-aa60-b222a36fc76a'
    );


    -- Command table
CREATE TABLE command (
  id SERIAL PRIMARY KEY,
  key VARCHAR(50) NOT NULL UNIQUE,
  value VARCHAR(255) NOT NULL,
  description TEXT,
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Message table (linked to command via one-to-many relationship)
CREATE TABLE message (
  id SERIAL PRIMARY KEY,
  command_id INTEGER REFERENCES command(id) ON DELETE CASCADE,
  key VARCHAR(50) NOT NULL,
  value TEXT NOT NULL,
  description TEXT,
  is_active BOOLEAN DEFAULT TRUE,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), 
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Add unique constraint for command_id + key combination
CREATE UNIQUE INDEX message_command_key_unique ON message(command_id, key);