Create Database for Notification Tracking

[tobi-bams]

Description:
We need to create a database table to store notification details for the notification system. This table will ensure notifications are tracked, retried, and processed effectively. The table should include fields for tracking event type, public key, notification content, retry attempts, status, and other relevant details.

Acceptance Criteria:

1. A database table named notifications is created with the following schema:

   CREATE TABLE notifications (
     id SERIAL PRIMARY KEY,
     event VARCHAR(50) NOT NULL,         -- Event type (e.g., bounty_assigned)
     pubkey VARCHAR(100) NOT NULL,       -- User's pubkey
     content TEXT NOT NULL,              -- Notification content
     retries INT DEFAULT 0,              -- Retry count
     status VARCHAR(20) DEFAULT 'PENDING', -- Status: PENDING, COMPLETE, FAILED, WAITING_KEY_EXCHANGE
     uuid UUID NOT NULL,                 -- Unique identifier for the notification
     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
   );

2. The table should support the following statuses:

   • PENDING
   • COMPLETE
   • FAILED
   • WAITING_KEY_EXCHANGE

3. Ensure the uuid column is indexed for efficient querying by notification ID.

4. Verify that the table is successfully created in the database.

Additional Notes:

• This table is foundational for the notification system and will be used to track the state of notifications as they are processed.

[Ekep-Obasi]

@tobi-bams @humansinstitute please assign me

[aliraza556]

@tobi-bams @humansinstitute Please assign me?

[saithsab877]

@humansinstitute Please assign me?

[MahtabBukhari]

@humansinstitute please assign me