-- install.mysql.utf8.sql
CREATE TABLE IF NOT EXISTS `#__ngomanagement_ngos` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `registration_number` VARCHAR(50) NOT NULL,
    `category` VARCHAR(50) NOT NULL,
    `address` TEXT NOT NULL,
    `email` VARCHAR(100) NOT NULL,
    `status` ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `#__ngomanagement_documents` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `ngo_id` INT(11) NOT NULL,
    `document_name` VARCHAR(255) NOT NULL,
    `file_path` TEXT NOT NULL,
    `upload_date` DATETIME NOT NULL,
    PRIMARY KEY (`id`),
    FOREIGN KEY (`ngo_id`) REFERENCES `#__ngomanagement_ngos`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;