Connected to PostgreSQL server successfully!
Database 'engrprimusapps_journal' already exists.
Table 'prayers' already exists with all required fields.
Indexes created successfully!
Trigger for auto-updating timestamp created successfully!
Sample data already exists in the database.
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | integer | No | nextval('prayers_id_seq'::regclass) |
| title | character varying | No | None |
| content | text | No | None |
| category | character varying | No | None |
| status | character varying | Yes | 'pending'::character varying |
| date_created | timestamp without time zone | No | None |
| date_answered | timestamp without time zone | Yes | None |
| notes | text | Yes | None |
| created_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP |
| updated_at | timestamp without time zone | Yes | CURRENT_TIMESTAMP |
| name | character varying | Yes | None |
| country | character varying | Yes | None |
| ID | Title | Category | Status | Name | Country | Date Created |
|---|---|---|---|---|---|---|
| 560 | Grinss | Family | pending | Samuel | ansahkwame548@gmail.com | 2026-10-08 20:53:09 |
| 559 | Exdous | Other | answered | Philip Nyamekye. | Ghana | 2026-09-27 11:40:11 |
| 558 | Exdous | Church | answered | null | null | 2026-09-27 11:40:10 |
| 557 | Be a warrior 💪 | Church | answered | null | null | 2026-09-27 10:09:33 |
| 556 | Be a warrior 💪 | Personal | answered | null Evans Thompson | nullGhana | 2026-09-27 10:09:23 |
Your Prayer Journal database is ready to use with name and country fields!
Next Steps:
// Create prayer with name and country
POST /prayers.php
{
"title": "Prayer for Peace",
"content": "Praying for world peace",
"category": "World",
"name": "John Doe",
"country": "Nigeria"
}
// Get prayers by country
GET /prayers.php?country=Nigeria
// Get countries with prayer counts
GET /prayers.php?countries