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 |
|---|---|---|---|---|---|---|
| 492 | Peter | Family | answered | N/A | N/A | 2026-05-30 00:55:02 |
| 491 | Peter | Personal | answered | null | null | 2026-05-30 00:55:01 |
| 490 | Health | Health | answered | Michael Yeboah Ghana | N/A | 2026-05-29 05:35:25 |
| 489 | God's migGOFO MERCYhtiness | Personal | pending | Nwamaka Cynthia | nigeria | 2026-05-27 06:09:01 |
| 488 | Novena Yaa Mohammed | Personal | answered | frank. Arthur | 0545027363 | 2026-05-15 11:28:09 |
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