CCMS DATABASE (MySQL) - README

WHAT THIS IS
This folder contains the MySQL database script for the Campus Club Management System (CCMS).
It creates the database, tables, constraints, sample data, triggers, stored procedures and indexes.

FILES
- ccms.sql

HOW TO IMPORT (UniServerZ / phpMyAdmin)
1) Start MySQL in UniServerZ
2) Open: http://localhost/phpmyadmin
3) Create a database called: ccms
4) Click Import -> Choose file -> select ccms.sql -> Go

HOW TO IMPORT (MySQL CLI)
1) Open UniServerZ MySQL console or Windows CMD
2) Run:
   mysql -u root -p < ccms.sql
3) When asked for password, enter your MySQL password (often: root in UniServerZ)

VERIFY INSTALL
Run:
USE ccms;
SHOW TABLES;

NOTES
- Run the full script to ensure triggers and stored procedures are created.
- The script uses InnoDB and utf8mb4.
