| Server IP : 14.225.204.176 / Your IP : 216.73.216.169 Web Server : nginx/1.24.0 System : Linux nodejs-ybgk 6.8.0-40-generic #40-Ubuntu SMP PREEMPT_DYNAMIC Fri Jul 5 10:34:03 UTC 2024 x86_64 User : root ( 0) PHP Version : 8.1.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/php/wit-crm/api/ |
Upload File : |
<?php
defined('BASEPATH') or exit('No direct script access allowed');
$CI = & get_instance();
if (!$CI->db->table_exists(db_prefix() . 'user_api')) {
$CI->db->query('CREATE TABLE `'. db_prefix() .'user_api` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user` VARCHAR(50) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`token` VARCHAR(255) NOT NULL,
`expiration_date` DATETIME NOT NULL,
PRIMARY KEY (`id`));
');
}
if($CI->db->field_exists('password',db_prefix() . 'user_api')) {
$CI->db->query('ALTER TABLE '.db_prefix().'user_api DROP `password`');
}