61 lines
2.4 KiB
PHP
61 lines
2.4 KiB
PHP
<?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");
|
|
} |