<?php
defined('BASEPATH') or exit('No direct script access allowed');

$CI = &get_instance();

// Add module options
add_option('hubtel_sms_client_id', '');
add_option('hubtel_sms_client_secret', '');
add_option('hubtel_sms_sender_id', '');
add_option('hubtel_sms_enabled', 1);
add_option('hubtel_sms_show_in_clients_menu', 1);
add_option('hubtel_sms_show_in_staff_menu', 1);

// Create messages table
if (!$CI->db->table_exists(db_prefix() . 'hubtel_sms_messages')) {
    $CI->db->query('CREATE TABLE `' . db_prefix() . "hubtel_sms_messages` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `to` varchar(15) NOT NULL,
        `message` text NOT NULL,
        `rate` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
        `status` varchar(20) DEFAULT NULL,
        `date_sent` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `sent_by` int(11) NOT NULL,
        PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=" . $CI->db->char_set . ';');
}

// Create templates table
if (!$CI->db->table_exists(db_prefix() . 'hubtel_sms_templates')) {
    $CI->db->query('CREATE TABLE `' . db_prefix() . "hubtel_sms_templates` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `name` varchar(100) NOT NULL,
        `template` text NOT NULL,
        `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updated_at` datetime DEFAULT NULL,
        PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=" . $CI->db->char_set . ';');
}

// Create logs table
if (!$CI->db->table_exists(db_prefix() . 'hubtel_sms_logs')) {
    $CI->db->query('CREATE TABLE `' . db_prefix() . "hubtel_sms_logs` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `message_id` int(11) NOT NULL,
        `response` text,
        `status` varchar(20) DEFAULT NULL,
        `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=" . $CI->db->char_set . ';');
}


$CI->db->query("SHOW COLUMNS FROM `" . db_prefix() . "hubtel_sms_messages` LIKE 'response_code'");
if ($CI->db->affected_rows() == 0) {
    $CI->db->query("ALTER TABLE `" . db_prefix() . "hubtel_sms_messages` 
        ADD COLUMN `response_code` varchar(10) DEFAULT NULL,
        ADD COLUMN `rate` decimal(10,2) DEFAULT NULL,
        ADD COLUMN `network_id` varchar(50) DEFAULT NULL,
        ADD COLUMN `response_message` text DEFAULT NULL,
        ADD COLUMN `message_id` varchar(50) DEFAULT NULL");
}