Prayer Journal Database Setup

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.

Table Structure:

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

Sample Data:

ID	Title	Category	Status	Name	Country	Date Created
420	God forgiveness and breakthrough	Health	answered	N/A	N/A	2026-03-29 07:56:30
419	Spiritual groth	Personal	answered	Winifred Oghenekevwe sadjere	Nigeria	2026-03-26 14:01:16
418	Who am I to worshiping god you save me from my sin can you protect me from evil hand amen 🙏	Personal	answered	N/A	N/A	2026-03-24 19:26:32
417	Who am I to worshiping god you save me from my sin can you protect me from evil hand amen 🙏	Personal	pending	Samuel Kwabena	Ghana	2026-03-24 19:26:32
416	Who am I to worshiping god you save me from my sin can you protect me from evil hand amen 🙏	Personal	pending	Samuel Kwabena	Ghana	2026-03-24 19:26:31

Database Statistics:

Total Prayers: 405
Pending: 183
Ongoing: 0
Answered: 222
Countries Represented: 39
Unique Names: 111

Setup Complete!

Your Prayer Journal database is ready to use with name and country fields!

Next Steps:

Upload the config.php, Prayer.php, and prayers.php files to your server
Update the database credentials in config.php if needed
Test the API endpoints with the new name and country fields

API Usage Examples:

// 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