CREATE DATABASE ngo_db;
USE ngo_db;
CREATE TABLE users(id INT AUTO_INCREMENT PRIMARY KEY,username VARCHAR(100),password VARCHAR(255));
CREATE TABLE beneficiaries(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(150));
CREATE TABLE distributions(id INT AUTO_INCREMENT PRIMARY KEY,distribution_type VARCHAR(150));
CREATE TABLE donors(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(150));
CREATE TABLE donations(id INT AUTO_INCREMENT PRIMARY KEY,amount DECIMAL(12,2));
CREATE TABLE ledger(id INT AUTO_INCREMENT PRIMARY KEY,type VARCHAR(50),amount DECIMAL(12,2));