# Database Schema File

## File in this directory:

**schema.sql** - Complete database setup
- Creates all required tables (users, accounts, transfers)
- Creates test user: shante99
- Sets initial balance: 8,899,276.66 AUD

## How to Import into phpMyAdmin:

1. Log into phpMyAdmin
2. Select your database: `if0_40085505_wishy`
3. Click on the "Import" tab
4. Choose the file: `schema.sql`
5. Click "Go" to import

## What gets created:

- **users** table - Stores user accounts
- **accounts** table - Stores user account balances by currency
- **transfers** table - Stores money transfer records
- **Test user** - shante99 (Password: Shantel9921//)

All tables use InnoDB engine with UTF8MB4 encoding for full Unicode support.

## What gets created:

- **users** table - Stores user accounts
- **accounts** table - Stores user account balances by currency
- **transfers** table - Stores money transfer records

All tables use InnoDB engine with UTF8MB4 encoding for full Unicode support.

