-- Assignment Accountability System - Database Schema Helper
-- ---------------------------------------------------------
-- This file explains how to set up your database on cPanel.
-- You have TWO options:
--
-- 1) RECOMMENDED: Let Laravel create all tables for you
--    - Upload the project in `UPLOAD_TO_CPANEL` to your host
--    - Make sure `.env` has correct MySQL credentials
--    - Visit:  https://yourdomain.com/setup.php?run=setup
--      (this runs all migrations and seeds using Laravel)
--    - Delete `setup.php` afterwards for security
--
-- 2) Manual SQL Import (if you cannot run setup.php)
--    - Create an empty MySQL database in cPanel
--    - Use phpMyAdmin to import SQL generated from your local
--      environment (export your local `reminder_db` once it is
--      migrated and working).
--
-- NOTE:
-- Because `mysqldump` is not available in this development
-- environment, a full MySQL export cannot be generated for you
-- automatically here. The structure of the tables is defined in
-- the Laravel migration files under `database/migrations/`:
--
--   - 0001_01_01_000000_create_users_table.php
--   - 0001_01_01_000001_create_cache_table.php
--   - 0001_01_01_000002_create_jobs_table.php
--   - 2026_01_25_073703_add_subscription_fields_to_users_table.php
--   - 2026_01_25_073708_create_assignments_table.php
--   - 2026_01_25_073713_create_notifications_table.php
--   - 2026_01_25_073718_create_user_preferences_table.php
--   - 2026_01_26_091803_add_is_admin_to_users_table.php
--   - 2026_01_26_104031_create_system_settings_table.php
--   - 2026_01_26_105425_create_subscription_plans_table.php
--   - 2026_01_26_133552_create_device_tokens_table.php
--
-- If you really must create tables manually in phpMyAdmin, you
-- can open those migration files and translate the schema into
-- CREATE TABLE statements.
--
-- QUICK START (recommended):
--
--   1. Upload everything in `UPLOAD_TO_CPANEL` to your hosting
--   2. Create a MySQL database and user in cPanel
--   3. Edit `.env` on the server with your DB details
--   4. Visit:  https://yourdomain.com/setup.php?run=setup
--   5. Delete `setup.php`
--
-- That will create all tables and default settings for you.

