-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 23, 2021 at 11:27 AM
-- Server version: 5.7.34
-- PHP Version: 7.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `jobzmart_osmedia`
--

-- --------------------------------------------------------

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('000b014ba796c34810d6bd607e6f2b6543a86131', '45.127.134.94', 1624053856, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035333835323b),
('001b755812dabe57b733d92e0da75e692631d32a', '54.190.21.205', 1623818711, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831383731313b),
('006044ef7d3fbf3113df18ca415aeddfe1bfcad7', '154.160.9.64', 1623264032, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333236333934333b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('00b70651a0220ccfc08d03ba8313b1c221fa54a0', '124.71.180.89', 1623546689, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333534363638393b),
('00d114b0ceed2c95ecbcd301bd2ed973ea46dbd2', '95.142.120.6', 1623357847, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335373834353b),
('0124680daf66b9e2cb561f2aae7a239e72f6dd53', '45.127.134.94', 1623930647, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933303634343b),
('014326693e55736eaee19df9dffccdea951a4f97', '212.83.146.233', 1623459562, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333435393536323b),
('019243c5b75238db38e7f9e0046b031fbd399751', '124.71.180.89', 1623387437, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338373433373b),
('026059fb2146771b0cb820382a05e9a5fd5d0324', '107.172.253.134', 1624159377, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343135393337373b),
('02a81e8f0409c3217391308b6fd04102b1838d44', '41.207.252.122', 1623245625, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234353632353b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('02d12c669badd3046e0fc3cb6491381e58be04e9', '34.72.71.73', 1623330292, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303239313b),
('02d7dd7ed63bcd150b23a87fcfebb97beb075570', '40.85.168.14', 1623362843, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336323834333b),
('0300b67ccd10c211f7a55da6c0a8014ff298f27c', '172.247.250.146', 1624276795, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343237363739353b),
('03416ad32827a532750ee1972da57591313f3953', '36.150.60.24', 1623378265, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383236353b),
('0380431d5f3ab360d00121b464144aeb9a6849e5', '34.220.80.187', 1624251366, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313336363b),
('058d455ca9dc2012332b361ea71e1fa2f04fe995', '129.213.160.208', 1623660044, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636303034333b),
('067c22a5b2a1685df051a1303300f3a9c2746004', '124.71.180.89', 1624281129, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343238313132393b),
('06ff5dd3f26367bc74c6878839f1f6c99ff89e88', '41.207.252.122', 1623251689, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313638393b),
('0710616c83afaa144f1d7094d55c778b9c4a103d', '35.161.55.221', 1623590140, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303134303b),
('072a31934fced69387cb918a2ade52fd6cc2f2a5', '51.91.125.152', 1623312294, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323239343b),
('07401a65fe67e79847216b4c3cfed1f2009eb0d3', '124.71.180.89', 1623345663, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334353636333b),
('075168323f502fcadefe76ba33de3ee799297641', '52.11.12.154', 1623628043, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333632383034333b),
('07a0e15f39f1fd0cd5ecf4b246b51b155530626e', '124.71.180.89', 1623418027, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333431383032373b),
('07a6ad5a515a5d67f6906f8d622433b4e5edb807', '3.85.21.102', 1623620761, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333632303736313b),
('07a8bf3283edc0bf3de61d7f678d2c8dcb472bc2', '34.254.95.214', 1623485423, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333438353432333b),
('07d5faeb8a324c7584d15c8afdb2c1069f31689d', '45.127.134.94', 1623925427, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333932353432363b),
('085723b7d6006842ceb3524f2f702647a4b82c79', '174.138.16.88', 1623940089, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934303038383b),
('08659ec0f7f854d5ec91d5ebb9412d700ab2ed38', '51.91.125.152', 1623312297, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323239373b),
('08745bde656220147e250a3fc97aacbe5b7c564b', '174.138.16.88', 1623931216, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933313231353b),
('08a32dbb3c3bfbd3a6147a38d6f199f89516dbe9', '40.85.168.14', 1623364582, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336343538323b),
('09094b17208d4d282f805b6ef51ece516752147b', '139.99.61.171', 1623356190, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363139303b),
('0a547cf9fab5277a5aa115b9eca2490a79397334', '35.239.112.123', 1623577195, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537373139343b),
('0a73bf8557f507aac1c36c097bce1a1d7dd0d576', '169.38.68.188', 1623625420, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333632353431383b),
('0ab2681632010dc4be5f46caaef055a3d095ac82', '139.99.61.171', 1623356219, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363231393b),
('0ac870762576f552f13b376b88e21be96f5cefb1', '205.169.39.177', 1623354814, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335343831343b),
('0b8666a431a94682d1cb6a303e27f7b48f2598e5', '174.138.16.88', 1623935482, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933353438313b),
('0bc56c377362154e8a865ded8ac748ec83e0d0bb', '154.27.68.104', 1623734181, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733343138313b),
('0bff44ad9f7d757a6e1a87ab1d11a681892c416a', '35.161.55.221', 1623590137, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303133373b),
('0c3fa692e16b41442ff05a5027b81fa9579a03f3', '174.138.16.88', 1623931804, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933313830333b),
('0c538e153de980ea2f1c06d268bd1ae418478bf7', '103.236.201.74', 1624084231, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343038343233313b),
('0caccb6560b552037d4544d7e1d31f13c50b0f0b', '113.31.114.242', 1623494596, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439343539363b),
('0cbf914d666326861a01bc77a5ac81dbc778a3ad', '43.250.156.125', 1624367775, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343336373737353b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('0d60e676d69a6bcf97994411e1c6febe4d1e30fc', '181.214.170.33', 1623243677, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234333637373b),
('0d65ac2b6438280710034ad6806a45ec901a5d61', '123.58.210.104', 1623525193, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333532343936353b),
('0f8e8f0b2e009fa0767354d2f0d5a7dac96df71c', '34.212.115.233', 1623343942, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334333934323b),
('0fe02098c8463b1cd6f98040717c2bf231dff278', '43.249.228.14', 1624354808, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343335343830383b),
('0ff890395fcf401764abacd2c04b6777b1aa06ac', '41.207.252.122', 1623247448, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234373431313b),
('107405de84a15e8db35bf4368eaa992ede46244b', '134.209.112.39', 1623646525, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634363532353b),
('108cff4e521c20efacfe9f62b4191e193ad452c8', '62.210.202.242', 1624277629, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343237373632383b),
('110d9492b75c096b906091100d1d2d1c0e7c98b5', '185.104.184.122', 1623509524, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530393532323b),
('1123862eeffe8b43755864e6fa525681475d4f36', '154.160.23.25', 1624284255, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343238343235353b),
('1253a6a89d0677786c7028361c8a44b995c8601c', '36.150.60.24', 1623378293, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383239333b),
('12ee240fb455d4e606f664c2fe8f4cef5f4e83db', '124.71.180.89', 1623998341, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333939383334313b),
('12f0b5abfdcfd0522d2e18767479d0a2beb88ea8', '41.207.252.122', 1623403747, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430333538383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('130721e5089c39c06cf8478f1847af6d59bfa7d8', '34.83.123.173', 1623333315, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333333331353b),
('139d3aa4606be48b37f5a32742709ac237746ea3', '52.213.169.140', 1623593528, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333532383b),
('13e872bdab5e1b933199f608352d59ec7ba2a2d9', '54.184.197.4', 1624252311, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235323331313b),
('13f282231da7e5cbe1432abd0b94a7b6f1eb2248', '36.152.143.154', 1623377790, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337373739303b),
('142c89a52c4aaa96df60dc5de1be79bec653bfe2', '18.237.129.137', 1624077305, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343037373330353b),
('147c529b4e283f24a45db9855ac7b373c7f402e2', '103.155.80.155', 1624236540, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343233363534303b),
('15464b8cfc8cd54e2cd868d296d7150221539941', '150.129.206.170', 1624465385, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343436353338353b),
('158b9c5919cd852ec407d8c85a2dff9d6fc19a17', '34.212.147.34', 1624252128, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235323132383b),
('15aa086fae364dd6416af177ce35b2c76f5a1e52', '52.147.192.214', 1623592666, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539323636353b),
('15c0f498d780d8a9df7940910b50c78b230fe7c0', '154.160.20.245', 1623835925, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333833353932343b),
('17578ded731d41ac217bba864cdda3f0cbaa167f', '195.201.111.42', 1623326632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332363633323b),
('17c78416f87ff6bda91d79670e34571fe0c270ff', '84.22.150.186', 1623476633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437363633333b),
('17f1c42ef8fbf464f826f6fb4723b919c2ba889c', '139.162.168.39', 1623336052, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333363035323b),
('18cef221ac32d03ee8ac289657413ec06b2242e5', '38.131.158.121', 1623330222, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303232323b),
('194241080f8eefc524f3613c6022ee526f28c456', '36.150.60.24', 1623378236, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383233363b),
('1953ea1b0db4f3a1c94f5dc27006dbee0be6c3b3', '41.207.252.122', 1623403588, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430333538383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('19fc957ed9d7982203c6c5c39e715798066e6170', '124.71.180.89', 1623855817, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333835353831373b),
('1a05adbebebdb3e48caab53ac53dce49d3bf414e', '154.160.20.245', 1623862007, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323030333b69647c733a323a223134223b757365726e616d657c733a363a22737065617265223b656d61696c7c733a31343a22737065617265406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('1aaa36b4cdd50d890db4feeb619f21da04a4a146', '198.199.123.69', 1623343233, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334333233323b),
('1abd13a7e85eab826a3400dc38dcb7180b88baff', '54.168.75.245', 1623911417, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931313337303b),
('1ae8a9dbab00e754f913c40ca6b650024a117d57', '124.71.180.89', 1623333499, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333333439393b),
('1b1e7277bc4ccc09424f3961ee0a23ff6f7ed5cb', '205.169.39.75', 1624014934, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343031343933343b),
('1b9907fecabb547144209d2a06e9cd93f8c5596a', '139.99.61.171', 1623356237, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363233373b),
('1c35218db545cb9449cb1cc8b8c996ba3f9117f2', '84.22.151.222', 1623669460, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636393436303b),
('1c6b13d6b8b4aaceaf5101cfb386a45b111557c1', '64.137.22.166', 1623503224, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530333232343b),
('1d1db47b89e25e475e0369252539930d6da22b39', '20.77.17.107', 1624190340, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343139303334303b),
('1e08faa2db91c9ba93f2c8d50e4d74ca29cb4678', '134.122.31.214', 1624169884, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136393838333b),
('1e72c7dda570b643344a41e671662aae5da0a62a', '58.152.195.85', 1623367854, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336373835343b),
('1e8c801b99cd72c8d7ad372b37228fc39907753e', '124.71.180.89', 1623402241, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430323234313b),
('1ecf8053bc138a43ac0f9e088d533a5d9d652be3', '102.176.94.129', 1623862492, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323333393b69647c733a323a223134223b757365726e616d657c733a363a22737065617265223b656d61696c7c733a31343a22737065617265406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('1f640cf95c48c6057e12fc1f43c4de19a654a8d4', '54.68.89.117', 1623734810, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733343831303b),
('1f88de1da8225af52b1ff727a541809519558d03', '1.20.168.94', 1623379808, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337393830383b),
('205676e3bf14b99d696e69fd42639c024e910a56', '45.127.134.94', 1623982533, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333938323532383b),
('20c1d3de56fc0bacf26abea550ab804e24ec8393', '34.211.48.138', 1624251521, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313532313b),
('21bb202a5ae9b07090076b6463e4e496cf184172', '121.5.145.96', 1623562473, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536323437333b),
('21e68263174ddfa51ff521e36e7f8aee50d30694', '52.188.207.218', 1623591813, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539313831333b),
('2262b2204e11a40da0d660f8ee3b1aa694aff4f7', '54.184.132.107', 1623407690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373639303b),
('235a7f5c1536bf67ecb83be6cd0ee4a896e74aca', '174.138.16.88', 1623930955, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933303935343b),
('2393c1f5730dd50e510c2a2b18be9bfecb9a39eb', '124.71.180.89', 1624143785, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343134333738353b),
('2394902fbd7c883c35166dae468f863dd2104ef0', '36.150.60.24', 1623378285, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383238353b),
('2397d0c900528bcc92eb6e8af9da103967c32ee8', '165.22.243.190', 1623899692, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333839393639313b),
('239c28882ee3e5217b04e04972914dda2466cbf8', '125.164.237.170', 1623505097, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530353039323b),
('23d6f604cc6fecf2203b78da2620e76a889587a4', '124.71.180.89', 1623608817, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333630383831373b),
('2497517b735dcab37f998bc0f6a7fda7b3c505e2', '124.71.180.89', 1623319816, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331393831363b),
('249ce13c1faccd4e65958eedbf632727a98c08fb', '62.171.148.95', 1624142106, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343134323130363b),
('25c4770259b1b15e0e2ed00b61cacb83ca2e5c41', '181.215.207.30', 1623502929, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530323932393b),
('25f013edfd09448b613b74a46a43eef1162217cb', '158.69.64.72', 1623322340, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332323334303b),
('262b267685ee536a0ec58350a88beda7f46f8a18', '45.127.134.94', 1623928912, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333932383833313b),
('26b2a72b257acf17214d116a8e1f1cf92723f8a0', '41.207.252.122', 1623245273, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234353237333b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('2813a0636a4a465a7bbd031f1b226b066f720d0b', '34.221.24.184', 1624167682, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136373638323b),
('28333809570da33b81bcde1c2f8b688b381d2630', '40.71.84.68', 1623372419, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337323431393b),
('289f6dbe64be9a2920403331f1c4a3f07cf28c3e', '18.117.253.181', 1623243194, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234333139343b),
('290798527b7d86d583bc30ca6747e718f69eab8c', '41.207.252.122', 1623251350, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313335303b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('2984711606fb9822277ea396c55176669c1a1408', '34.222.246.153', 1624060025, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343036303032353b),
('2a02864eb05703ffddbb165d7b23920e558507f1', '41.207.252.122', 1623251046, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313034363b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('2a6607e6a90d6239b3159693428ad57e5bb20645', '124.71.180.89', 1623692928, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333639323932383b),
('2b086f1bc8ef208da01598031ef84dfcb077f7d5', '41.207.252.122', 1623252233, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235323233333b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('2e84f5fdb784cbf8c3029ae7cae582a009e9a149', '34.77.162.28', 1623737818, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733373831383b),
('2ec6f43d28542dc8898cd6b1858285c96a0e6301', '124.71.180.89', 1623740958, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333734303935383b),
('2f4224d184e50bf4887f15eac4989355b92bee6a', '192.71.42.108', 1623422265, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333432323236353b),
('2f6f8b9fb223ec7fea4b0cc1257e42527b20bed5', '34.223.5.126', 1623793904, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333930343b),
('30875ad8c0d541bd9b79bf4ab7c07145f39b4b37', '54.250.201.85', 1623971166, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937313136363b),
('308f9c6a4dfd493371e666ab2465d2d8c87b6138', '154.160.19.161', 1623530937, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333533303931383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('309132d9630829656f6ff9cd4afc8a1f8be089f5', '3.85.226.144', 1623380406, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338303430363b),
('30cdac556d0e14e81bdc36a283a5d9267937030f', '52.2.198.95', 1623461872, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333436313837323b),
('310cff6331d0d40a46fb48813dcb85ff043ade1a', '40.71.84.68', 1623372429, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337323432393b),
('3133c682cde60fc4dcf0366ec91f608b21f97176', '154.27.68.104', 1623713241, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333731333234313b),
('31edc56304d6e70e74121e4dad153acc5c9123fa', '18.237.30.16', 1623386761, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338363736313b),
('326b88e2abb838324602d20bb42376728fca4b4f', '193.160.73.106', 1623476633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437363633333b),
('327b340666fe3e344ecb8b9a5d26c927f202673f', '18.236.140.54', 1624081397, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343038313339373b),
('32add892a9261e5b046072fd114f7da767a3493f', '191.101.97.225', 1623345149, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334353134393b),
('332a817a9cd315b919ace8c682c36e0696255e3c', '54.145.116.72', 1623358494, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383439343b),
('342e0798fd3c5a5ebeb62c595d1a314e22d3d388', '174.138.16.88', 1623937407, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933373430363b),
('345a7fe1d4883be2d3310141e19fdbb329a671df', '46.98.102.35', 1623454530, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333435343533303b),
('3490573b2619a48b0e731be8e89c536ba237d4f0', '34.220.213.238', 1623407824, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373832343b),
('349ade614b5361ea52eeb9b1ddfee94713120a53', '45.127.134.94', 1623977987, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937373938323b),
('349ce11eef2d83c8ee2d161fcb713977385ccb41', '54.189.230.128', 1624048633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343034383633333b),
('34a5fb284cc5a56a62fed513bc1e7dafb63c997a', '41.207.252.122', 1623255023, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235353032333b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('34c838d83e57ae4a1ccd04287d48857d0c55a1d2', '2.137.100.68', 1623581131, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538313133313b),
('357571ff07a24d6f4ebb32663a9b2d40600d43db', '3.142.141.202', 1623783207, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333738333230373b),
('360c90bcff20c37f87d247b3c8371abf9f731fbf', '54.86.186.169', 1623577058, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537373035343b),
('37644319d6065cc66411c40e7a13fcc95b517ea4', '34.220.187.133', 1624059605, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393630353b),
('37bb998e26c434dc3d315487c3f849b7454f5128', '52.213.169.140', 1623593529, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333532393b),
('38bb85f57498f7ff402a646ad79e830401843175', '49.34.229.87', 1624465311, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343436353331313b),
('3979c54f8288d6669052c2dee6c005c73ad3202e', '150.129.104.28', 1624456039, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343435363033363b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('39b32676dc674be2c417b0b514687a779dc96398', '124.71.180.89', 1623937274, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933373237343b),
('39b55f647be5aa0cce33d8e6b7f235ae850d86d8', '34.217.122.104', 1624077685, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343037373638353b),
('3ae01600ccdeceadc5d2237ad31ef71dc44943fe', '206.189.85.228', 1624213880, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343231333837383b),
('3b0932923c051da3e9efe47842013c4d4c570465', '149.202.180.22', 1623366986, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336363938363b),
('3b2444a30bb1fc15d471cb07b90348e6df955dfb', '36.150.60.24', 1623378238, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383233383b),
('3c2875cc9f888756bc376013e4c5f22793cb4d10', '171.25.193.77', 1623363851, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336333835313b),
('3c60e2c2a24898ef40aa3414698a59e12e50499b', '174.138.16.88', 1623938361, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933383336303b),
('3cc00ba83171a241560e55c707fe6a1915a6b7a8', '174.138.16.88', 1623944060, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934343035393b),
('3cf74a34466ca1e4bef2a601273459fd83f9dd76', '41.207.252.122', 1623254691, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235343639313b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('3cfbf88f174f1c5363832aae293763727840179f', '34.221.139.101', 1623385321, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338353332313b),
('3dcff0bce8747fda6f00578a1dd23a690c7892b5', '62.210.202.242', 1624149493, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343134393439333b),
('3e0efbb976a587fe33bf7169e10951a43a3fc69d', '34.209.40.176', 1623407820, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373832303b),
('3fa2eef909e1d624af5ea1946c473a273e0254ae', '207.148.116.191', 1623399896, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339393839353b),
('3ff89d6a2752a85fd6097e6b90cc80f830b785cc', '20.51.241.179', 1623661513, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636313531323b),
('40e162b22f34da6eb775b6aa8451ab22a4809b2e', '176.107.177.6', 1623954690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333935343639303b),
('40e55f5ebf395318301227764d7cef45fd7fb193', '34.219.60.149', 1624059715, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393731353b),
('41285b8e31038572b40555f32481c988874859dc', '124.71.180.89', 1623410223, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333431303232333b),
('414a0fe2b0d0a81d07d957dd8267fb151859b885', '45.127.134.94', 1624058189, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035383138363b),
('42ad6c7f0b323e5b0cc0f1504ce68e312fa567b8', '46.4.33.48', 1623430725, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333433303732353b),
('42cd98a07c4c9dbaa362de30090a4e6db4a5fe70', '124.71.180.89', 1623833981, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333833333938313b),
('42efeec9746099a290666a307fea5454c0530b89', '103.62.94.139', 1623645346, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634353334363b),
('430745f9bb8087a216bdef8989b16ab75a1be0e9', '54.218.14.94', 1624251875, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313837353b),
('436e63fdb306f6a2438405ebe377c5103f361a22', '167.172.226.36', 1623356908, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363930383b),
('43881f5c76f945acae36858a4b536dfccce0f066', '124.71.180.89', 1623366283, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336363238333b),
('43a0b565b10801c5ccca7dd78319cc22e9520a67', '124.71.180.89', 1624122537, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343132323533373b),
('44357f8b80b04b7de9b982dcc8fb207634c84e41', '174.138.16.88', 1623933570, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933333536393b),
('4443176224b5193782d9c24405f98db09f22d687', '52.32.220.15', 1624060017, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343036303031373b),
('4512d47fc30cb8a3652c0bc5c484dcb66bb96d9d', '54.186.76.234', 1623793932, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333933323b),
('45a33e22e67ba5a47fcf95fca6e5ca0ce930f50e', '54.212.220.205', 1623793839, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333833393b),
('45ecf868f22fcc34f05dc885547d4426d3a0fc17', '84.22.149.125', 1623564311, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536343331313b),
('4629b21accb01ff5d64d13b8cb1bc56224e86c8f', '66.249.93.110', 1623593527, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333532373b),
('47e11c047474f99736e598be111c624dec721922', '50.112.228.138', 1623793856, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333835363b),
('47fc504cc9676e3ff04f7ac563641a6473ca633c', '103.62.48.238', 1623610932, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333631303933303b),
('481bf2558c8016ee864cad1da049139f3bc2a7ad', '102.176.94.101', 1623971011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937313031303b),
('48eafed0073e5c4438c536e4a197bc25134c9d79', '174.138.16.88', 1623915547, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931353534363b),
('493561ca701e8f9f1076af22ca6cd2181617a6fa', '124.71.180.89', 1623436888, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333433363838383b),
('497e0c721d159d46cb97fccc1956a1a12da2bbe8', '34.83.222.70', 1623333305, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333333330353b),
('49d9515fdfdd469008337870b27643fdd7e71d89', '34.208.188.35', 1623818669, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831383636393b),
('4a0c8401fdc33d7bf1d26336555833d3b8d34528', '185.151.57.136', 1623476633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437363633333b),
('4a99356923260e5e22993a80dd7199407dbbe093', '191.101.223.198', 1623331071, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333313037313b),
('4b3bb84d10e1c57b175b9bf541b31348d953ab9c', '41.207.252.122', 1623255025, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235353032333b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('4b898baa2420027dbf438ddb3c9b4e3f992f647c', '34.221.150.63', 1623731815, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733313831353b),
('4cddc06eb0009a2ba71d9deba62e6d54952fa93d', '35.225.72.125', 1623834785, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333833343738353b),
('4d024f059c63ac0c05844187d35d0c253206a709', '62.210.92.175', 1623657176, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635373137363b),
('4d2063335cd91fff5c8039618f918a32e3a31227', '196.201.63.4', 1623263965, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333236333936353b),
('4dc77f202db8fe23492b2acb55d8d8cbf2ac5403', '154.160.20.245', 1623862392, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323339323b69647c733a323a223134223b757365726e616d657c733a363a22737065617265223b656d61696c7c733a31343a22737065617265406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('4df516028e9a22b60856980265a4b1c711507e7c', '162.218.230.219', 1623400953, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430303934363b),
('4e2488d431521efd23f0aea9137afaf3a6ad6669', '124.71.180.89', 1623380315, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338303331353b),
('4e406eeb7dce2efd55f5110253f605709f75c14b', '35.165.246.227', 1623407677, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373637373b),
('4e52d4e7a1c00f7ad67128448eef8403eb2a0cd0', '65.154.226.165', 1623656771, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635363737313b),
('4e6d5b10f119df7f064306ca90baf1109c2574c7', '102.176.94.101', 1624005389, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343030353338383b),
('4f2d9b15baf362c79fd41f0b29fe2e353d9c28d0', '54.36.18.184', 1623742620, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333734323631393b),
('4f5da6f3d7bb982d9bc64bdf1830319885953fd6', '20.51.241.179', 1623661513, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636313531323b),
('4f97bad1b567457f8d28d259c5029fec261e7ea3', '41.207.252.122', 1623255702, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235353537363b),
('50e4746bb43b6478c0c4993c6ed5d6472de574d3', '34.210.69.99', 1623500943, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530303934333b),
('5195029193e4490eca78d4c0f9933292db7cadc4', '54.86.186.169', 1623581633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538313633333b),
('51eb64fed480b31e0a1e9cb565d9faa86e0cc636', '124.71.180.89', 1623506371, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530363337313b),
('51f7320f2c8b707c056cb10ab544d54262811075', '113.31.114.242', 1623493674, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439333637343b),
('53390edbdb461d0d7b3402ed8f073b6b3a09dfe0', '154.27.68.104', 1624175437, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343137353433373b),
('5354ad28df437d4b050f5ab323697bf2a85f4127', '54.36.10.79', 1623930840, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933303833393b),
('53c3b9b850c613a64482a370133c38b93b24b486', '62.4.14.198', 1623313017, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331333031373b),
('540497f72056bfa10e4ead78d8289839e132f29c', '34.215.118.39', 1623365445, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333336353434353b),
('54686a9dfcb5ac0aa468cb4495f01a0794dba9e9', '103.236.201.74', 1624085887, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343038353838343b),
('54a34aa0f32095c04e772412add83628bb6e1b7f', '41.207.252.122', 1623247162, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234373131383b69647c733a323a223132223b757365726e616d657c733a393a2272616d706162656e67223b656d61696c7c733a31363a22726963686d6f6e64406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('555ee22a753627c85653521cf7dba591d6792cbe', '40.122.33.61', 1623589597, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538393539373b),
('55c793c0887e88e088cd4e30b082e424854abf55', '109.69.66.101', 1623586628, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538363632383b),
('560399192bf8c048a481a15fcc29aab0e93f08b9', '191.101.76.34', 1623345150, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334353135303b),
('5655e9004ad488c3f8682c16b58ad5988c7d7ab7', '52.41.73.220', 1623330012, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303031323b),
('56c642c13b86d9c5abd39cf8f92e8b6c5d9f334b', '205.185.118.129', 1623315582, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331353538323b),
('5780f12f3dc490371a5ff8a1a8581766506b63c4', '35.84.23.54', 1624059619, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393631393b),
('57fbc5677149fc17634a37e9894fcc33002f36f3', '107.191.102.97', 1623403193, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430333139333b),
('58e78453baaa892f3c519937a1f1d74416f3ae8c', '124.71.180.89', 1624060862, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343036303836323b),
('59b3422d6c5d4f55384a85ed71e0768ede5586bf', '52.37.206.66', 1623386666, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338363636363b),
('5b0efe5dbecec04953491ad7f353a3307c1bebe6', '134.122.31.214', 1623821442, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333832313434323b),
('5c5df455047a9463afec0e3e4cc6fda33b736f22', '113.31.114.242', 1623515237, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333531353233373b),
('5e1d15862dc221742d97a3076d371d2b9eed682f', '103.62.48.231', 1624133454, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343133333435333b),
('5ec8543f8dc20aae1ed3568be2abcd9e5436a7bb', '18.236.200.242', 1623385621, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338353632313b),
('5ed960959993416c704a49e7a428c1c979f2f325', '34.83.11.124', 1623333324, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333333332343b),
('5eeb8fef2c4e4e8faca69ade52ac7f950aee2606', '174.138.16.88', 1623936088, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933363038373b),
('5fcc5a724b737cf9be9c2bd9e59b683b570b30c4', '124.71.180.89', 1623477657, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437373635373b),
('612ea0fbde2a2ef0c611ebfa19fd467818d3197f', '174.138.16.88', 1623897293, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333839373239313b),
('620c291b9f9aafb11d6281515359e44aabbfb19c', '45.127.134.94', 1624067270, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343036373236383b),
('62919285ecd24b0831637c1d8a31d02d337c0238', '45.127.134.94', 1623971708, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937313639373b),
('633e0c7e2b0008837919345651a7626aa26c4b2f', '45.127.134.94', 1623993235, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333939333233313b),
('6356b4304518987f357493d28eb0cbf303eba5ac', '124.71.180.89', 1624205284, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343230353238343b),
('646c1c405cf2da80e77ef0977bb2376c8e48524d', '193.160.68.98', 1623669461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636393436313b),
('65f6f44af80c6616e1808a9628eff6a32a90cf0c', '54.213.181.240', 1623818672, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831383637323b),
('66ec5988a5e823078ff6d3480eb36b3fed8e1567', '51.91.125.152', 1623312300, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323239393b),
('67b253403c0758293258292757aab6518547183e', '113.31.106.180', 1623654713, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635343731333b),
('68198e422ee2d3e03bfbeb2ccdaad38184a54960', '154.160.1.32', 1623263943, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333236333934333b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('6a5619b00d8035d7fe8d46681c78a5cecc2bc2c7', '124.71.180.89', 1623957627, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333935373632373b),
('6afbc984ef7998bafda2a41fc884c4d82ef65d57', '196.196.85.196', 1623823873, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333832333837333b),
('6b010a79c22b85d2fc30bd321b618058e31a19d2', '65.155.30.101', 1623358838, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383833383b),
('6b1d6c3818db18d3c7462d1c0c76b29df5d84081', '45.127.134.94', 1623996231, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333939363232393b),
('6b9c4e1646d5becde8b39e4e03b90e471a9368ce', '34.214.66.93', 1623343932, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334333933323b),
('6bcfb82b71cda49531efb3b17995ea5c7f68aee5', '124.71.180.89', 1623443475, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333434333437353b),
('6ecf26d881513c946bdb599b7b14947b544460b1', '34.243.200.96', 1624053229, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035333232393b),
('6f19533358e2fb5f1cca3f89b595ea16fa451eba', '178.171.52.217', 1623376246, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337363234363b),
('6f471b08fd5f9353c6ab64ba3fb9f5457a1c339a', '174.138.16.88', 1623931954, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933313935333b),
('6f9c4e3b193d2a52e60914a8585fe07aca7f3fb7', '51.91.125.152', 1623312306, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323330363b),
('6fdb4900472234b2af82c59bf74b010c98933c6b', '34.221.184.25', 1624059367, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393336373b),
('705812738449202d0bafe1605a335d6ba95e4440', '221.229.218.152', 1623924517, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333932343531333b),
('7083657709dfca6afb0ba0c1dbf3d4c97914d7aa', '54.145.116.72', 1623358494, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383439343b),
('709d3f73aaf4c4d958e151fad9657d563be52132', '124.71.180.89', 1623491779, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439313737393b),
('7149e49d1cf34557d37233d2adde4e690cb8db99', '150.129.104.28', 1624465266, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343436353236363b),
('72f27f44fecec9471c70a63c28165f6ca6984807', '45.40.123.92', 1623590530, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303533303b),
('73fb267107f11051ca2be32d67621180c471dee6', '35.161.55.221', 1623590504, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303530343b),
('74e7fec22110cfa8137024c4e56131f0c2efdd1f', '34.219.28.92', 1623330021, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303032313b),
('75027d0668dfa25cfd263ecb4268ecf8debbf491', '134.209.112.39', 1623643242, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634333234323b),
('7504f7f35ad57e8daa74edee878b29c26ea34068', '23.19.80.227', 1623510324, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333531303332343b),
('7543aa60e265bcbb04711ed3e39090c7e63819ff', '92.118.160.45', 1624049130, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343034393133303b),
('76240b0ee4160e01627f6bffcec783675a42efdf', '124.71.180.89', 1624236696, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343233363639363b),
('76e3ec23a2378083ddc00f46733a244a08771707', '52.213.169.140', 1623593523, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333532333b),
('778bc7df70dd97c63dae8a01fca88b888a0b193f', '54.221.27.173', 1623407584, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373538343b),
('779e10be00f442bcefcae7031a37336852217624', '54.145.116.72', 1623358473, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383437333b),
('792d78276a7546875cc301a32caacdcc58530466', '154.160.20.245', 1623860411, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836303431313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('79af32c7e33b50de5fbace1d480303bbdbc05103', '104.251.219.234', 1623315583, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331353538333b),
('7a52bd4fcde8fecf8e0e66938357330d24512ff0', '124.71.180.89', 1624100800, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343130303830303b),
('7a721b5463f33edfd43aa89fefa966b6809d13f2', '169.38.68.189', 1623578405, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537383430323b),
('7a9d0e044fc54e3e4f9327963a06be0471e81344', '174.138.16.88', 1623888029, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333838383032383b),
('7ac38013d1168748608b0a51ed6cbe95035dbadd', '173.249.22.173', 1623310225, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331303232353b),
('7b08e1ca1dc594c9524c792eb140d259033eda6c', '139.99.61.171', 1623356213, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363231333b),
('7bc96e9417e1368caea7b604e5a535e79e77af25', '92.118.160.17', 1624114328, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343131343332383b),
('7cf88490d4d092963e122e82c1c447cd1a159a3c', '154.27.68.104', 1623804820, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333830343832303b),
('7db37468acb8924e6313221c116db66ba53de9f0', '34.215.175.70', 1623793900, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333930303b),
('7dc7ee4101cd24000b2f5189f5ff00c87f47efca', '45.131.102.121', 1623476633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437363633333b),
('7dcc7744525fe05572b3fc197a1cf70bdceb852d', '46.101.80.192', 1623911559, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931313535393b),
('7dce3e288dae346357f5ccaf3f189376a2b4bec7', '167.172.226.36', 1623741061, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333734313036313b),
('7e50b5cd4bf384cea248e5891cd650175577d1d2', '174.138.16.88', 1623949210, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934393230393b),
('7f1ed033c942600e04a6cbd3bad149e11ebaad7b', '103.236.201.74', 1624081469, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343038313436373b),
('800c624f453e3a2cfd73665b680c80d07a0bc297', '13.212.108.245', 1623461368, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333436313336383b),
('80c595bb1cb1b079920d29d7dbfed0d9da64dff8', '138.246.253.24', 1624064088, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343036343038383b),
('80e9fbf9face0f096ef368be2c52597f2e4daef5', '124.71.180.89', 1623514519, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333531343531393b),
('8311daab9fd8f00e70b033ed1178893c7dabcd82', '52.12.44.206', 1623816816, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831363831363b),
('83215e37bdf47830800d33a5e9c9a40f42ce6f30', '124.71.180.89', 1624079839, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343037393833393b),
('832e58ae96395c22243dd9fa3698558c94c1eba7', '34.219.248.146', 1623501216, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530313231363b),
('8389dfa3f6918ca0cfbefe7caebbfe7578f0e621', '124.71.180.89', 1624184475, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343138343437353b),
('83a686a0cc3bffe36aaaa941155ab485c874b5b1', '41.207.252.122', 1623252451, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235323435313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('83bfef5ae0506f7813c0ad5ec6fc87605e322631', '5.181.235.72', 1623773060, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333737333035393b),
('84714ed493f4a462cf630d4a7d947f883858bbf5', '52.149.231.148', 1623856744, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333835363734343b),
('861316ca057113fe84f932e8f45fa319c97542ed', '134.209.112.39', 1623761662, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333736313636323b),
('8637b48f3332dcc4b71e5a974e1273301e61a2bb', '154.27.68.104', 1623776547, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333737363534373b),
('86a466a0e839116054631f769747bc0518c34038', '20.77.17.107', 1624192249, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343139323234383b),
('87260bec38aad44db75cf9e312574206f6961d75', '124.71.180.89', 1623394721, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339343732313b),
('8795923e6fdfaed9bcd45dc0a58a493526d59289', '18.237.150.65', 1623385687, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338353638373b),
('87a143c7c2b1ab97432521e2cc09242b9df75187', '167.172.226.36', 1623358665, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383636353b),
('882196d150b54190ed4dd5b5bbce2a129e917958', '128.199.149.190', 1623598687, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539383638363b),
('8894aa2214222fa5768e5c364dd6f1c27eaa8b47', '36.150.60.24', 1623378185, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383138353b),
('892f7d286736f0c685a5ae0d354f0bbe48a88b07', '124.71.180.89', 1623359592, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335393539323b),
('895f464dcced675d9f552644da46ced4126c56d1', '3.83.9.228', 1623380407, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338303430373b),
('8a19961cdf7a7baf8efd7ccd32ca9797c768e983', '208.80.194.41', 1623915561, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931353536313b),
('8a7afe9a48eece836a7af5bd4569b8ba07384784', '205.169.39.218', 1623654006, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635343030363b),
('8abbccfbd35d26ee1516c0392f3f760ef7b7b0b6', '185.170.200.149', 1623583936, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538333933363b),
('8b1b54bc409815cf317e8ea0f30dda7c0eccadc2', '35.161.55.221', 1623570848, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537303834383b),
('8b38dd0fe3ac5528ee14e23495ad460cbf1756d9', '69.25.58.56', 1623356549, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335363534393b),
('8c3d51bfeb62b295e084f139e0603a866ad99de8', '176.113.42.192', 1623345150, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334353135303b),
('8c5afc790018e3089652fd9b67169eff3206c5d6', '174.138.16.88', 1623944086, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934343038353b),
('8d355a8ba71e4495ba01c946d7ea2fb8223365ef', '34.222.56.91', 1623628071, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333632383037313b),
('8d9c28b220646b8095a71cfcd7222cc2dfd1ecca', '20.83.169.32', 1623355561, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335353536303b),
('8dcfacaa840b489d1d28aad97c48d4de9a7d9e0f', '18.216.46.124', 1624203366, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343230333336363b),
('8e77e0eeb1fb408de713aed144140d4a564b8242', '154.160.20.245', 1623861818, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836313831383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('8eaeae9f925128d8554d6ceef84ff107a4b11af8', '149.56.150.71', 1623432617, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333433323631373b),
('8ed4cdb16eb259c5ff5f709d16262018a0e91ca0', '191.101.92.32', 1623376245, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337363234353b),
('8f54189af8739cb4cd7a086c4a148eda6a56cb5f', '35.164.226.221', 1623384980, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338343938303b),
('8faf3d0a3ee6e1d299fd770392002ee7c98f914d', '43.250.156.125', 1624374039, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343337343033393b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('8fcb919054f94cf8b17672eb3d7883d6339ead2b', '102.176.94.222', 1623499872, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439393837303b),
('90cebeabb8f2e9500a9f50888cea773df69c5624', '43.250.156.125', 1624374461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343337343436313b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('931c295b8d89180fcbf15ffbbb0eccdfe9be1cc2', '52.42.79.222', 1624010020, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343031303032303b),
('9326783b87b01d703a9a35e4b3e0392be44e6a8e', '69.25.58.56', 1623357523, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335373532333b),
('93fb7b56ee3b4c4de6801907841bd7be771a730e', '124.71.180.89', 1623463809, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333436333830393b),
('945272caab320789ae0bed3ffde37dbb2c2f9e91', '205.169.39.110', 1624003670, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343030333637303b),
('94619bae6857d9db20ee4024c1ea932f051765fe', '35.165.215.140', 1623259373, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235393337333b),
('9465bdcee64c5f38377e35e773b241a8ef48d5a5', '38.145.86.71', 1623244333, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234343333333b);
INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('94c06f9ba5ba35ed2ac6df5dbb1f00f616786f96', '117.97.172.21', 1623660406, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636303430363b),
('94d28f5b3f4e02fa6f425a7f1bd5aeb2f6ddc26d', '102.176.94.1', 1624043881, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343034333837343b),
('971a235faf0b0791568077b557f53bff82863c53', '41.207.252.122', 1623251685, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313638353b),
('97292fc2c91f7026b8d6db3ca446edffe9b6f03e', '174.138.16.88', 1623938967, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933383936363b),
('976d1b5e997cb87e97c33b761b0bf23723f48613', '41.207.252.122', 1623246611, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234363332323b69647c733a323a223132223b757365726e616d657c733a393a2272616d706162656e67223b656d61696c7c733a31363a22726963686d6f6e64406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('98a17133f69f3764cc7482d06ed651026a5fe817', '41.207.252.122', 1623246306, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234363330363b),
('996a1b89616edc0a8a597e0839591c85173f9caa', '41.207.252.122', 1623252453, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235323435313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('9978d4e1a18611cf2b391e18714651af75c25717', '54.200.152.143', 1624167639, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136373633393b),
('99dfbf1e6da17df0e39c8053b10e0165d450689b', '34.213.234.160', 1623407790, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373739303b),
('9b880cadaaff0aadf9c054f95dfae872b819b4ca', '209.97.163.81', 1623340488, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334303438383b),
('9d87d8e87f7e791e6fb9118b99e6566507935620', '128.127.104.80', 1623543809, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333534333830363b),
('9dd0a2508c87c9bf7250f47249ff530ad00bd4bf', '154.27.68.104', 1623640944, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634303934343b),
('9e01c4c674090ecd891f4fc748c34b93653ee5ea', '41.207.252.122', 1623244361, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234343336313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('9e0e93b4a0636dce580eb2e770218f2436005e1c', '34.216.218.117', 1624252355, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235323335353b),
('9e29abc071167b0c83666d142885074bcdd164fe', '82.102.25.155', 1624125916, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343132353931353b),
('9eecc743d7c90fdc3a80a9cdab57aa6acb574c36', '124.71.180.89', 1623330569, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303536393b),
('9ef492c607b518e438ff693e1dcdf2d0a62fb373', '171.13.14.83', 1623392424, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339323432343b),
('9fd9304aad66c161a480ff65742a896e36154b5e', '124.126.78.180', 1623476220, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437363232303b),
('a00e6e994369d872b6cfb53c43a4cb9e53b924b6', '31.6.11.232', 1623573652, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537333635323b),
('a0259910c8b82c2416bf68963f5df2f012bb557b', '102.176.94.76', 1623612516, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333631323333343b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('a04ffe0eaa7b91d59cdaaef316432cf8ccc4ef6b', '191.101.112.45', 1623345150, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334353135303b),
('a0a0e1345eae2e9073f5205812e213998bf8c7d3', '124.71.180.89', 1623670359, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333637303335393b),
('a19d800a418b22231e9f0d3b8737b957a71a39f9', '62.210.202.242', 1624187410, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343138373430393b),
('a1cb540a8adedd90c8c1fa9110d1d59bde02a1ff', '212.90.39.68', 1623891213, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333839313231333b),
('a1f926bfd8ee6bfc064f587cbf0520f0701ca280', '52.213.169.140', 1623593523, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333532333b),
('a2249d46129639d6a2b7ecb4c3cd1b431fbdf57d', '174.138.16.88', 1623882534, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333838323533333b),
('a24ef5cd28415148b6d69b2f0d3276664a24a8fb', '34.209.63.114', 1623500564, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530303536333b),
('a2686c43d6108fdf51ee6c566a09f4ff6f242888', '62.115.15.146', 1623655177, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635353137373b),
('a29673611733a30fda606a4449c206282ef6d184', '124.71.180.89', 1623585356, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538353335363b),
('a2c1fa155cbba35124c5f81b4db10542a90f51cc', '198.199.123.69', 1623394834, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339343833333b),
('a335195d7d249d9029994ccf4a0da3922289f813', '193.160.68.71', 1623564312, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536343331323b),
('a3764bf620f2836471d1c4c1770c4d5a1af462d1', '124.71.180.89', 1624163050, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136333035303b),
('a4a099960acc038a4ae8b83bd7f7d41ec6752d24', '34.220.28.207', 1624251509, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313530393b),
('a4b0b43d03b5e68d6e8c3de615d4a05577019b3e', '154.160.23.25', 1624284605, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343238343630353b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('a5011ddd2798251ca8c9eba3e4798cc3b428eb06', '5.181.235.76', 1623695551, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333639353535303b),
('a5149214a20ee33c767af3ed928dee4b209639cc', '52.175.245.102', 1623574913, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537343931333b),
('a51e134bbac308e9da1d67d305a8b23072d35f2b', '54.148.41.231', 1623818641, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831383634313b),
('a52cdd5cc9aba17ecff7d19ba0a358f751a300d4', '45.127.134.94', 1623978027, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937383032373b),
('a55f3aeecbc1b0e78dad11e65ee2d6666f5e89e7', '18.237.59.156', 1623331126, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333313132363b),
('a5f1fca1e480880c23606cbc6e8fc2acf52cfdbf', '168.119.90.77', 1623323789, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332333738393b),
('a5f8ecbe7c588724cebae558b52b120648dbf714', '174.138.16.88', 1623963583, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333936333538323b),
('a625b4ff8b48ea522c79e379ddd1dcd13c8173ff', '34.220.99.111', 1623562032, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536323033323b),
('a736a40f5484572163e33f6522fbbdaa31e3c747', '41.207.252.122', 1623244010, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234343031303b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('a738483d4cebee344dee17f18388257767106a22', '34.68.199.189', 1623707958, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333730373935383b),
('a866bc57e6befa408438222a7eaf719db282a8b8', '162.55.183.34', 1624219913, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343231393931323b),
('a96f5897fe9f1c30fbdde193dbce53fd9baabd1c', '154.160.20.245', 1623862318, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323331383b),
('a9cdf2c8a9a282f759dbddeb66405b75f8ce25b1', '34.86.35.12', 1623761197, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333736313139373b),
('aa6b38cabf76a5e609c3d35991f148a1aee9cb29', '92.118.160.45', 1624053823, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035333832333b),
('aae5ee87dfffd13dcc62231674ceb513d2812d3a', '195.201.41.238', 1623458545, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333435383534353b),
('acce8d1959000547413201fee31cd453f479d1cc', '52.12.126.95', 1623501408, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530313430383b),
('adaa05a427cead7153e6c8baa9b59e2f1995b88f', '20.102.50.44', 1623583478, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538333437383b),
('ae19005c4ef5a55343b0e5c4b2021b78429067e9', '212.83.146.233', 1623310210, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331303231303b),
('af1a6d8966e8f6c64d0f61840ce6275210c05d1d', '54.212.214.59', 1624059693, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393639333b),
('b020d5603da43a198e3b4334170d560722798ecd', '124.71.180.89', 1623977960, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937373936303b),
('b0251b1c324abcc4917600753b599bec426b4271', '34.219.241.176', 1623501187, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530313138373b),
('b14f89d30b51279087762a69702fa65b948709af', '103.155.80.155', 1624236536, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343233363533363b),
('b1892888bb9df326bca61f65cd6e0e9460ce7598', '34.221.186.223', 1623499853, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439393835333b),
('b2127b4bda0801284273ca288f18f76b1afc721d', '20.102.49.87', 1623735738, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733353733373b),
('b37c0da6be45c4596e5dcc38f4d54217049f27a4', '35.161.55.221', 1623571101, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537313130313b),
('b4fb0f37dff8ee695ed19518009f379f8a9b5f8e', '23.100.232.233', 1623422741, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333432323734313b),
('b7665a42829cc187058a2930c0851c0523a58a52', '40.85.168.14', 1623779427, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333737393432373b),
('b885701159b7ff7af5c913b710f6187d0a494c7e', '45.127.134.94', 1623941434, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934313338353b),
('b8ace5d053d0061b37dffbbc965a9b38b17442bb', '146.148.177.163', 1623573416, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333537333431363b),
('b8ba6795f978ecf48cf63411d6096cdf07906eb7', '144.217.80.80', 1623374694, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337343639343b),
('b933c59c004a78d3418d711fdb6e3cd88bbb97d9', '54.213.131.230', 1623990766, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333939303736353b),
('b93f7f76dbbd4adf73c71f26d7ac362b571389ef', '205.169.39.196', 1623354948, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335343934383b),
('b9aaa42b10a49efde79c1f1a6ceb182e00a6782f', '154.160.20.245', 1623862003, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323030333b69647c733a323a223134223b757365726e616d657c733a363a22737065617265223b656d61696c7c733a31343a22737065617265406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('ba2897ee6aba6d86bd24ab42a9efaceaf4bc7587', '46.101.80.192', 1623911557, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931313535373b),
('ba343b6a2e2e4dc96d29529bd6db731975520ceb', '34.221.196.182', 1623991243, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333939313234333b),
('ba6d69bd780dc28fe42802fa409971f4297bd769', '154.160.20.245', 1623862408, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836323339323b69647c733a323a223134223b757365726e616d657c733a363a22737065617265223b656d61696c7c733a31343a22737065617265406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('bb3ab049a17819a8124cec49bc085c51b921c322', '50.112.211.96', 1623817746, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831373734363b),
('bbdea985e016509a4d75dcdddc2d16e9c766bf3d', '124.71.180.89', 1623717106, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333731373130363b),
('bc1a747318ef12df51991883e44eebec018b7956', '34.217.178.168', 1623470342, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437303334323b),
('be544102ad351e5cf7ab1f018bac373e9f8a8678', '195.154.61.206', 1623309873, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333330393837333b),
('bf4ab077c91653ed68e9a47d52695a498aaaa1cf', '54.149.177.203', 1624077302, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343037373330323b),
('bf7d2df92c275d89da1bf08c71af3dbccac55e1e', '54.202.94.83', 1623385926, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338353932363b),
('c062becec27f96fa09f00c61ab568652233f50b8', '34.218.224.246', 1623500402, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530303430323b),
('c0ccea19049ce2f3dc01270f1358691e52b59544', '124.71.180.89', 1623450066, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333435303036363b),
('c0fec733e78f2c2862547ad25013a1e2178e40ea', '124.71.180.89', 1623326209, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332363230393b),
('c126b01a0cd7f1403fd9f257946e5519a30c13d2', '45.127.134.94', 1623968011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333936383030333b),
('c1376e80972c19a079d784a1b2ce8cdc4b3dc582', '124.71.180.89', 1623352661, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335323636313b),
('c1504be9a65598e40522594dd5b192590a72cfcb', '36.152.143.154', 1623377784, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337373738343b),
('c18fd1349e43d77f4915fbc84bbdeee9ec50c14c', '185.170.200.156', 1623583935, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538333933353b),
('c2bd83747ae91dd5fb5d55db04f7e4d2d184ae58', '18.237.62.242', 1623645611, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634353631313b),
('c3338cf2b20d4cb9db373079d88e1730ce05915c', '174.138.16.88', 1623879189, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333837393138383b),
('c5fbb0c5d3b18d180fc2e758422c58ad83ced9a6', '43.250.156.125', 1624374631, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343337343436313b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('c621bdbe0b72f2997205b78426a195fe701b3276', '34.222.89.196', 1624251326, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313332363b),
('c6a819eac817c1bc3673406c0c3e54cb136ef9aa', '41.207.252.122', 1623243248, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234333234383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('c6de419419152ed3e7487e5646844737f9be57e9', '134.209.146.89', 1623373054, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337333035343b),
('c795ec5264d8249a6a3b2f1392e00186f63aacc1', '193.160.69.55', 1623376247, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337363234373b),
('c84f5c3af0057d9d967c33913612fde53314d88f', '84.22.150.186', 1623564312, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536343331323b),
('c8931e6b2a08cd95b13928973c16cae3cd800076', '124.71.180.89', 1623499057, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439393035373b),
('c8fb96acad5843997c7aede8fc8cdbd97e45482a', '124.71.180.89', 1623524589, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333532343538393b),
('c9b10de8d6dc4cca3d30e23e013ccf920c2c4cf7', '103.62.93.239', 1623419528, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333431393532383b),
('c9b66352d5d93067b7c598dd002298fe26820f4c', '154.160.23.25', 1624285820, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343238353832303b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('ca777f1ea0ed75bded43ea4739fbad4b09b310a6', '34.210.74.179', 1623731823, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733313832333b),
('cad605d77c241932a68ba9dd8f2a5fff33047191', '124.71.180.89', 1623627688, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333632373638383b),
('cb3f5d452a91250eec6ed59b372f0c60a865dd3f', '174.138.16.88', 1624156179, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343135363137383b),
('cbbcbd5d8c80f786946b0f6dd838f828af0b6719', '174.138.16.88', 1623922377, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333932323337363b),
('ccac53ebc564ebd7018c483d3ad8922fe7de9968', '36.150.60.24', 1623378289, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383238393b),
('cd9c8b78339118714f6a11b6e66ecb8e06b9d073', '124.71.180.89', 1623812957, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831323935373b),
('cdb57e59099329bdae666b199a32207561eca126', '174.138.16.88', 1623964152, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333936343135313b),
('cde9c9f7a0059919a13fc9eecd5b7a8ea95d0ff7', '154.27.68.104', 1623667465, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636373436343b),
('ce1ae8cb86ce4a1bf8739dd7439454a9779b3b90', '54.190.168.60', 1623734777, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733343737373b),
('ce6bad9de6d95b60a7706ff92c29fff3ea8fd445', '34.217.68.154', 1623734808, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733343830383b),
('ce7850f20ee7eaa06a9d762e18b80155f1d91dca', '52.11.35.166', 1623499447, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333439393434373b),
('cee609df70533a56bb7173534e02c207d7dbe7b4', '34.215.61.249', 1624059391, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393339313b),
('cf3132795d5b39318cf6234a4979c06997da65f6', '124.71.180.89', 1623877737, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333837373733373b),
('cf355d700c0d97d3d578cbf4053803250762b9f8', '174.138.16.88', 1623937797, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933373739363b),
('cf3e15d3e23456e2f83eada348c1ecc7512d49ef', '103.155.80.155', 1624236544, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343233363534343b),
('cf50986dc34cf7019aa47c10193be1ac526d6936', '45.127.134.94', 1623970004, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937303030303b),
('cf86bb955c9a44d3b24f918d2a61461618181ae3', '54.202.94.83', 1623386203, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338363230333b),
('d075941e50bb2960e285c2a5708b7c9975cce60f', '103.133.104.38', 1623875855, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333837353835343b),
('d0c19073f9cd69460ea874a1a77182fe2935ad92', '46.101.80.192', 1623911558, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931313535383b),
('d19519aa897accb46f753c41a70252b2e55982d2', '84.22.151.222', 1623376246, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337363234363b),
('d257cf3fecdb8f81b7a99ec813e25c3b201d42d1', '124.71.180.89', 1623647805, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333634373830353b),
('d302c5e693283218f571349379b51bf8057f8cd9', '205.169.39.218', 1623654001, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333635343030313b),
('d3937368aef0b4dc93d33787326cb7d1aa7e4682', '54.148.41.231', 1623816916, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831363931363b),
('d45dd74db6db6f842baef221b3ba040543232af0', '45.127.134.94', 1624056678, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035363637333b),
('d467328c2b84439ac10c44879e334734a04cedb1', '150.129.104.28', 1624456036, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343435363033363b),
('d46a534fa70226349b949dfd636fa36340d430e8', '34.229.249.112', 1623341767, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334313736373b),
('d47ff8183161f8143b80341c89d9c6c01b1b576b', '174.138.16.88', 1623930852, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333933303835313b),
('d4a02e5d5ed8e4e4a3d6ea198c293e18886621c3', '41.207.252.122', 1623402380, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430323338303b),
('d52c27ee6e8c27fcf1df12cefba92a7083667ed6', '52.43.126.53', 1623386247, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333338363234373b),
('d69de2f7ed05899199856dd1d247fbb4424e25fb', '198.199.123.69', 1623842947, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333834323934363b),
('d72ab8420954ca91f6aecb91b0668ab4e31b3442', '205.169.39.177', 1623354805, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335343830353b),
('d7b01277ba59562cc7eb98e5c9bd1eba61ca0bb4', '41.207.252.122', 1623402749, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430323734393b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('d7ba06a0752356bcaa58f521224db027377459d1', '5.181.235.76', 1623949857, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333934393835343b),
('d93ee94fed507e50c9c8efdd5da64775f5462959', '76.164.198.173', 1623321193, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332313139333b),
('d97043b334e562ea859c5cfbcc5a17e0165023d5', '54.190.35.202', 1624167647, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136373634373b),
('d9e9c07c14e100fedfe271f0082ba41c29ab36be', '124.71.180.89', 1623470729, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437303732393b),
('d9fec957dd5f9b3b33cf2775aad2401279f35cc2', '124.71.180.89', 1624040173, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343034303137333b),
('da3632f372c30505c1c86e0eba8321fdbdcd9dd9', '221.229.218.152', 1623924547, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333932343533303b),
('db04ed98cf889c03e5ebb7ab7b650d8ff9ef802f', '124.71.180.89', 1623566701, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536363730313b),
('db370c2335c408f2ee99130eaecf5e75ce221132', '54.250.201.85', 1623971165, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937313136353b),
('db99096850089547e48d940ddc7006b6d5ec2f3a', '54.190.122.53', 1623793889, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739333838393b),
('dc09303864ecb6ec9124ecd37bea8a47164525aa', '124.71.180.89', 1624018619, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343031383631393b),
('dc62a921c220e6264b663774c62e2ca969b656d5', '212.83.146.233', 1623312263, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323236333b),
('dce7e02956c7b6245842eec22f713a1d3bb9d247', '171.13.14.28', 1623392460, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339323436303b),
('dd5f89321be95f4f36adeebff66d54c117af65c9', '205.169.39.75', 1624014942, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343031343934323b),
('dd96c55449a734fcc74e6fa4ae7db3edb0915146', '138.201.84.36', 1623610079, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333631303037383b),
('ddf82228f02a03099f0673b2233688f5e86f6924', '134.209.146.89', 1623326654, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332363635343b),
('e032fe12b42ecd00817384cda5370b95a83ee36a', '54.145.116.72', 1623358473, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335383437333b),
('e044598cad860e9b3c32b39d45d6e1985bf6e967', '124.71.180.89', 1623426086, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333432363038363b),
('e0c7709d348a29015a718424bb0a82e901790f63', '154.160.20.245', 1623860725, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836303732353b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('e11950e3a1eed68e345810fa5f289b445621cbe8', '34.220.187.133', 1624059607, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393630373b),
('e2494a52e50189db858163e599f4d53ca25c76e9', '18.236.139.246', 1623472402, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333437323430323b),
('e25d345eb879d2c5d589a41c82a21b7931b43eae', '41.207.252.122', 1623251554, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313535343b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('e2b0b6dbe0e072411cfdf29203a7d22fe744bc4d', '23.94.55.62', 1623403192, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430333139323b),
('e2d2c5aa1bceecb8271966a92a06d068c2dcf2fa', '36.150.60.24', 1623378267, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337383236373b),
('e3cb6fc71f052cc9ec7590994999d42a33766b0b', '113.31.114.242', 1623532258, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333533323235383b),
('e3fbd2da5526d33c125043145cdb8b7ef2b8a9ef', '52.42.15.87', 1623343964, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334333936343b),
('e424325252b136459074dc0abc28b474d7a37f57', '188.241.83.123', 1623323084, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332333038343b),
('e45672f1e3664257518eb16791d011b5e284bc8d', '52.41.73.220', 1623343933, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334333933333b),
('e46d115d1c78282b06155a485efb65246ed22432', '124.71.180.89', 1623316452, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331363435323b),
('e47c2c82f573fa3d94298999b4fea62d76a86581', '34.212.174.53', 1624251853, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313835333b),
('e4874e18b6669bac16c9597f1977d27440846941', '205.169.39.196', 1623354945, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333335343934353b),
('e4d93065c3cc7670c0147db877ace092953aaf6c', '34.77.162.3', 1624059492, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343035393439323b),
('e4e720eb4531639101e72e3bfebd247157114b71', '161.69.99.11', 1623580130, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538303133303b),
('e5420c82c85eaca3c4bb54c7f4800852bf8f2216', '35.197.22.49', 1623333321, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333333332313b),
('e683713af671987eae2e4bda1bbb080942736f68', '154.160.20.245', 1623861381, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836313338313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('e69963008160208c2bcf876f95c640ebc60f8e46', '77.90.163.216', 1623669461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636393436313b),
('e6d1ca3734d073f55e40f0657a189b6e3393a5bf', '174.138.16.88', 1623882923, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333838323932323b),
('e758865f8ccb5f8977ed37fd1a56a77bc168e682', '46.101.80.192', 1623911557, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931313535373b),
('e7d1053806db2ded03232acf1a45e6fee41a1c78', '20.102.50.44', 1623592184, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539323138333b),
('e7dd8c5f8d596b691068d7177d95a952bb871c40', '94.126.205.86', 1623669461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333636393436313b),
('e8060c2c36a3a4d8bd5e44a9d7302c828009d914', '41.207.252.122', 1623246621, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234363632313b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('e86b442f3123a269892602e5263567be3b4ba26c', '34.86.35.16', 1624045061, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343034353036313b),
('e892516456018b77a65feb373569297df63e4a23', '154.160.19.161', 1623612334, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333631323333343b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('e8c6ae08a8c6532700073345af5bc59eaff8c52c', '34.208.32.78', 1623544000, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333534343030303b),
('e9d0cca73778b4bb6d4336b9268fcb14984e219b', '52.12.64.199', 1623734775, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333733343737353b),
('eae51fb47fb36ba4976596c71582f346286f25b5', '174.138.16.88', 1623871623, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333837313632313b),
('eae811c9b6ea7af71fa1048833a8a9c1babd7e6b', '205.169.39.110', 1624003653, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343030333635333b),
('eb727a8be74db19802277ec631e4b85827027146', '221.155.11.36', 1623433459, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333433333435393b),
('ec273f09aac6cc336f4f246882810d52aaf246cd', '124.71.180.89', 1623484670, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333438343637303b),
('ec7dee04bab474808eaca6a4cf08a416fda329f7', '212.83.146.233', 1623310446, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331303434363b),
('ee022c4209ed514482cf9d6d6b6d441400b51942', '52.149.208.200', 1623757021, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333735373032313b),
('ee40323bb58bf950aacde7c76d9df363697be78f', '198.251.83.193', 1623326588, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333332363538383b),
('ee7afc68a5d77363976dacb65bb3e3d3409e4252', '40.71.84.68', 1623372418, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337323431383b),
('eedc66a671239351d1bf8cd2d43fd9618d68ab72', '41.207.252.122', 1623247118, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234373131383b69647c733a323a223132223b757365726e616d657c733a393a2272616d706162656e67223b656d61696c7c733a31363a22726963686d6f6e64406468612e636f6d223b735f726f6c657c733a333a22725f32223b6c6f67676564696e7c623a313b),
('ef0c30818bfe775fef9642a0336aeb83a0ea97aa', '154.160.23.25', 1624285835, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343238353832303b69647c733a323a223133223b757365726e616d657c733a373a2245777572616261223b656d61696c7c733a31383a226e61616b7261736940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('ef191346e75d80c2908e23ef315a6794d48455b7', '174.138.16.88', 1623914577, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931343537353b),
('ef6fbf813bef79f2030fbb192c1c83e983cfc25d', '41.207.252.122', 1623243614, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234333631343b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('ef848d60d502d460390976fd6729169a7d6d7a89', '54.202.206.157', 1623330012, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333333303031323b),
('f003f73b973170213ab6af47235d199fcde35c2e', '34.212.226.232', 1623501384, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333530313338343b),
('f07a90c35b8553c21da11250404fb454b18924e6', '34.222.31.112', 1623407698, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333430373639383b),
('f084f467a1bb63c9953cd203689aded7abcb71b1', '18.224.135.78', 1623346261, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333334363236313b),
('f17329dacc5ac60bed1a09887f2da7c017337fae', '52.167.223.26', 1623843168, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333834333136383b),
('f1b5a7ace005527c58844fe2dfc0366f91792ee9', '41.207.252.122', 1623251694, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333235313639343b),
('f2379d0d6beaa887aeaae94f285fe1fc0a0b9511', '54.214.218.165', 1624077336, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343037373333363b),
('f2de16aa555874ec4ae87fe35994739167e077e6', '159.242.234.43', 1623869880, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836393837393b),
('f3bf974c48238ae60abf04692da584f57f79a263', '149.56.150.71', 1623432618, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333433323631383b),
('f3fdc950d0a7ab458f6742eed962f47f93d3eab0', '102.176.94.80', 1624310513, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343331303531333b),
('f56b78260f5364c5e2f00c3e987fb50289869b6d', '35.226.104.238', 1623584627, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333538343632373b),
('f6542b222753bb53151faa8de2d7a7a6d0da2d6b', '54.190.120.236', 1623816633, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333831363633333b),
('f6b5a8ff8ce5a7a90bde18c38c154719e5065ee7', '51.91.125.152', 1623312305, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333331323330353b),
('f75ebc231a8080aaa67b41ec9e682efff8a078a8', '41.207.252.122', 1623245958, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333234353935383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('f7675d766fcc57e4ea28273d34bee4d3993850b7', '124.71.180.89', 1623456991, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333435363939313b),
('f830e33aca0dd86448eb5cf93331b94c11233089', '124.71.180.89', 1623916712, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333931363731323b),
('f8959af7b7f1069aebbd0d499e4ee0662354e37b', '162.218.230.219', 1623396278, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333339363237383b),
('f8b6313fa3bb0efff308774242dde647ae474479', '34.219.82.46', 1624167661, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343136373636303b),
('f92bc30825dc9580d5f36cff954b7931673304ce', '45.127.134.94', 1623977949, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333937373934323b),
('f92fdfb8b2b3485165aeedc4345c9f66d7010781', '54.189.230.128', 1623765979, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333736353937393b),
('f95aad5c5e2cf26d163c348747f3404f5e08fb25', '35.161.55.221', 1623590501, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303530313b),
('fa346b9afac9f03bdffd2f9530e86b1021a04206', '181.215.95.127', 1623590409, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539303430393b),
('faa9344bd5fa1e36bcc595ad91a5f1dab9008353', '107.150.31.25', 1623593516, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333539333531353b),
('fc4437569f486b85b4005ea85a878eadc7fa1bba', '124.71.180.89', 1623373300, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333337333330303b),
('fc6ff139b62d22107aaf3b7642f9a6716ac99937', '154.16.52.154', 1623564312, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536343331323b),
('fce89c2f703347bd3023be3e013c812e09e464e7', '31.6.11.232', 1623569417, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333536393431373b),
('fcf2a69867f6115ac9d6784946b419d363a851a4', '34.217.18.59', 1624251503, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632343235313530333b),
('fdb7cbce430ddf661da0f8fc26eb90e6485c18b6', '154.160.20.245', 1623861991, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333836313831383b69647c733a323a223131223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a22616d706162656e67393940676d61696c2e636f6d223b735f726f6c657c733a333a22725f35223b6c6f67676564696e7c623a313b),
('fe5d3a77a5d007c2e4aa80a52f855dd3707fa069', '40.85.168.14', 1623783761, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333738333736313b),
('fffec71aeee170e8ed01a4551e798d0ffa1aea5e', '124.71.180.89', 1623792811, 0x5f5f63695f6c6173745f726567656e65726174657c693a313632333739323831313b);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_accounts`
--

CREATE TABLE `geopos_accounts` (
  `id` int(5) NOT NULL,
  `acn` varchar(35) NOT NULL,
  `holder` varchar(100) NOT NULL,
  `adate` datetime NOT NULL,
  `lastbal` decimal(16,2) DEFAULT '0.00',
  `code` varchar(30) DEFAULT NULL,
  `loc` int(4) DEFAULT NULL,
  `account_type` enum('Assets','Expenses','Income','Liabilities','Equity','Basic') NOT NULL DEFAULT 'Basic'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_accounts`
--

INSERT INTO `geopos_accounts` (`id`, `acn`, `holder`, `adate`, `lastbal`, `code`, `loc`, `account_type`) VALUES
(1, '123456', 'Sales Account', '2018-01-01 00:00:00', 172.00, 'Default Sales Account', 0, 'Basic');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_attendance`
--

CREATE TABLE `geopos_attendance` (
  `id` int(11) NOT NULL,
  `emp` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `adate` date NOT NULL,
  `tfrom` time NOT NULL,
  `tto` time NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `actual_hours` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_bank_ac`
--

CREATE TABLE `geopos_bank_ac` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `bank` varchar(50) NOT NULL,
  `acn` varchar(50) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `note` varchar(2000) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `branch` varchar(100) DEFAULT NULL,
  `enable` enum('Yes','No') NOT NULL DEFAULT 'No'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_config`
--

CREATE TABLE `geopos_config` (
  `id` int(11) NOT NULL,
  `type` int(3) NOT NULL,
  `val1` varchar(50) NOT NULL,
  `val2` varchar(200) NOT NULL,
  `val3` varchar(100) NOT NULL,
  `val4` varchar(100) NOT NULL,
  `rid` int(11) NOT NULL,
  `other` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_currencies`
--

CREATE TABLE `geopos_currencies` (
  `id` int(4) NOT NULL,
  `code` varchar(3) CHARACTER SET latin1 DEFAULT NULL,
  `symbol` varchar(3) DEFAULT NULL,
  `rate` decimal(10,5) NOT NULL,
  `thous` char(1) CHARACTER SET latin1 DEFAULT NULL,
  `dpoint` char(1) CHARACTER SET latin1 NOT NULL,
  `decim` int(2) NOT NULL,
  `cpos` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_currencies`
--

INSERT INTO `geopos_currencies` (`id`, `code`, `symbol`, `rate`, `thous`, `dpoint`, `decim`, `cpos`) VALUES
(1, 'GHS', '₵', 1.00000, ',', '.', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_customers`
--

CREATE TABLE `geopos_customers` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `region` varchar(30) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `postbox` varchar(20) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `picture` varchar(100) NOT NULL DEFAULT 'example.png',
  `gid` int(5) NOT NULL DEFAULT '1',
  `company` varchar(100) DEFAULT NULL,
  `taxid` varchar(100) DEFAULT NULL,
  `name_s` varchar(100) DEFAULT NULL,
  `phone_s` varchar(100) DEFAULT NULL,
  `email_s` varchar(100) DEFAULT NULL,
  `address_s` varchar(100) DEFAULT NULL,
  `city_s` varchar(100) DEFAULT NULL,
  `region_s` varchar(100) DEFAULT NULL,
  `country_s` varchar(100) DEFAULT NULL,
  `postbox_s` varchar(100) DEFAULT NULL,
  `balance` decimal(16,2) DEFAULT '0.00',
  `loc` int(11) DEFAULT '0',
  `docid` varchar(255) DEFAULT NULL,
  `custom1` varchar(255) DEFAULT NULL,
  `discount_c` decimal(16,2) DEFAULT NULL,
  `reg_date` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_customers`
--

INSERT INTO `geopos_customers` (`id`, `name`, `phone`, `address`, `city`, `region`, `country`, `postbox`, `email`, `picture`, `gid`, `company`, `taxid`, `name_s`, `phone_s`, `email_s`, `address_s`, `city_s`, `region_s`, `country_s`, `postbox_s`, `balance`, `loc`, `docid`, `custom1`, `discount_c`, `reg_date`) VALUES
(1, 'Walk-in Client', '045565454', '', '', '', '', '', 'example@example.com', 'example.png', 1, '', '', '', '', '', '', '', '', '', '', 0.00, 0, '', '', 0.00, NULL),
(2, 'Adwenpa Systems', '0200777262', 'knust', 'kumasi', 'Ashanti', 'Ghana', '89', 'richmond@digitalhealthaccess.com', 'example.png', 1, 'Adwenpa Technologies', '', 'Adwenpa Systems', '0200777262', 'richmond@digitalhealthaccess.com', 'knust', 'kumasi', 'Ashanti', 'Ghana', '89', 0.00, 0, '', '', NULL, '2021-06-09 08:38:22');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_custom_data`
--

CREATE TABLE `geopos_custom_data` (
  `id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  `module` int(3) NOT NULL,
  `data` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_custom_fields`
--

CREATE TABLE `geopos_custom_fields` (
  `id` int(11) NOT NULL,
  `f_module` int(3) NOT NULL,
  `f_type` varchar(30) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `placeholder` varchar(30) DEFAULT NULL,
  `value_data` text NOT NULL,
  `f_view` int(2) NOT NULL,
  `other` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_cust_group`
--

CREATE TABLE `geopos_cust_group` (
  `id` int(10) NOT NULL,
  `title` varchar(60) DEFAULT NULL,
  `summary` varchar(250) DEFAULT NULL,
  `disc_rate` decimal(9,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_cust_group`
--

INSERT INTO `geopos_cust_group` (`id`, `title`, `summary`, `disc_rate`) VALUES
(1, 'Default Group', 'Default Group', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_documents`
--

CREATE TABLE `geopos_documents` (
  `id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `filename` varchar(50) DEFAULT NULL,
  `cdate` date NOT NULL,
  `permission` int(1) DEFAULT NULL,
  `cid` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `rid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_draft`
--

CREATE TABLE `geopos_draft` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `ship_tax` decimal(16,2) DEFAULT NULL,
  `ship_tax_type` enum('incl','excl','off') DEFAULT 'off',
  `discount` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `total` decimal(16,2) DEFAULT '0.00',
  `pmethod` varchar(14) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` enum('paid','due','canceled','partial') NOT NULL DEFAULT 'due',
  `csd` int(5) NOT NULL DEFAULT '0',
  `eid` int(4) NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` decimal(10,2) NOT NULL,
  `taxstatus` enum('yes','no','cgst','igst') NOT NULL DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','bflat','b_p') NOT NULL DEFAULT '%',
  `refer` varchar(20) DEFAULT NULL,
  `term` int(3) NOT NULL,
  `multi` int(4) DEFAULT NULL,
  `i_class` int(1) NOT NULL DEFAULT '0',
  `loc` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_draft_items`
--

CREATE TABLE `geopos_draft_items` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `product` varchar(255) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `qty` decimal(10,2) NOT NULL DEFAULT '0.00',
  `price` decimal(16,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `discount` decimal(16,2) DEFAULT '0.00',
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `totaltax` decimal(16,2) DEFAULT '0.00',
  `totaldiscount` decimal(16,2) DEFAULT '0.00',
  `product_des` text,
  `i_class` int(1) NOT NULL DEFAULT '0',
  `unit` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_employees`
--

CREATE TABLE `geopos_employees` (
  `id` int(11) NOT NULL,
  `username` varchar(30) NOT NULL,
  `name` varchar(50) NOT NULL,
  `address` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `region` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `postbox` varchar(20) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `phonealt` varchar(15) DEFAULT NULL,
  `picture` varchar(50) NOT NULL DEFAULT 'example.png',
  `sign` varchar(100) DEFAULT 'sign.png',
  `joindate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dept` int(11) DEFAULT NULL,
  `degis` int(11) DEFAULT NULL,
  `salary` decimal(16,2) DEFAULT '0.00',
  `clock` int(1) DEFAULT NULL,
  `clockin` int(11) DEFAULT NULL,
  `clockout` int(11) DEFAULT NULL,
  `c_rate` decimal(16,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_employees`
--

INSERT INTO `geopos_employees` (`id`, `username`, `name`, `address`, `city`, `region`, `country`, `postbox`, `phone`, `phonealt`, `picture`, `sign`, `joindate`, `dept`, `degis`, `salary`, `clock`, `clockin`, `clockout`, `c_rate`) VALUES
(11, 'admin', 'BusinessOwner', 'Test Street', 'Test City', 'Test Region', 'Test Country', '123456', '12345678', '0', 'example.png', 'sign.png', '2021-06-09 07:48:19', NULL, NULL, 0.00, NULL, NULL, NULL, NULL),
(12, 'rampabeng', 'Ampabeng Richmond', 'knust', 'kumasi', 'Ashanti', 'Ghana', '665', '0200777262', NULL, 'example.png', 'sign.png', '2021-06-09 08:44:48', 0, NULL, 100.00, NULL, NULL, NULL, 10.00),
(13, 'Ewuraba', 'Nana Abena', 'Ahenama Kokoben', 'Kumasi', 'Ashanti', 'Ghana', '98', '0243162888', NULL, 'example.png', 'sign.png', '2021-06-09 10:12:22', 0, NULL, 1000.00, NULL, NULL, NULL, 10.00),
(14, 'speare', 'kwaku', 'knust', 'ksi', '', '', '', '', NULL, 'example.png', 'sign.png', '2021-06-16 11:15:53', 0, NULL, 0.00, NULL, NULL, NULL, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_events`
--

CREATE TABLE `geopos_events` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `color` varchar(7) NOT NULL DEFAULT '#3a87ad',
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `allDay` varchar(50) NOT NULL DEFAULT 'true',
  `rel` int(2) NOT NULL DEFAULT '0',
  `rid` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_gateways`
--

CREATE TABLE `geopos_gateways` (
  `id` int(5) NOT NULL,
  `name` varchar(50) NOT NULL,
  `enable` enum('Yes','No') NOT NULL,
  `key1` varchar(255) NOT NULL,
  `key2` varchar(255) DEFAULT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'USD',
  `dev_mode` enum('true','false') NOT NULL,
  `ord` int(5) NOT NULL,
  `surcharge` decimal(16,2) NOT NULL,
  `extra` varchar(40) NOT NULL DEFAULT 'none'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geopos_gateways`
--

INSERT INTO `geopos_gateways` (`id`, `name`, `enable`, `key1`, `key2`, `currency`, `dev_mode`, `ord`, `surcharge`, `extra`) VALUES
(1, 'Stripe', 'Yes', 'sk_test_secratekey', 'stripe_public_key', 'USD', 'true', 1, 0.00, 'none'),
(2, 'Authorize.Net', 'Yes', 'TRANSACTIONKEY', 'LOGINID', 'AUD', 'true', 2, 0.00, 'none'),
(3, 'Pin Payments', 'Yes', 'TEST', 'none', 'AUD', 'true', 3, 0.00, 'none'),
(4, 'PayPal', 'Yes', 'MyPayPalClientId', 'MyPayPalSecret', 'USD', 'true', 4, 0.00, 'none'),
(5, 'SecurePay', 'Yes', 'ABC0001', 'abc123', 'AUD', 'true', 5, 0.00, 'none'),
(6, '2Checkout', 'Yes', 'Publishable Key', 'Private Key', 'USD', 'true', 6, 0.00, 'seller_id'),
(7, 'PayU Money', 'Yes', 'MERCHANT_KEY', 'MERCHANT_SALT', 'USD', 'true', 7, 0.00, 'none'),
(8, 'RazorPay', 'Yes', 'Key Id', 'Key Secret', 'INR', 'true', 8, 0.00, 'none');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_goals`
--

CREATE TABLE `geopos_goals` (
  `id` int(1) NOT NULL,
  `income` bigint(20) NOT NULL,
  `expense` bigint(20) NOT NULL,
  `sales` bigint(20) NOT NULL,
  `netincome` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_goals`
--

INSERT INTO `geopos_goals` (`id`, `income`, `expense`, `sales`, `netincome`) VALUES
(1, 999999, 999999, 999999, 999999);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_hrm`
--

CREATE TABLE `geopos_hrm` (
  `id` int(11) NOT NULL,
  `typ` int(2) NOT NULL,
  `rid` int(11) NOT NULL,
  `val1` varchar(255) DEFAULT NULL,
  `val2` varchar(255) DEFAULT NULL,
  `val3` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_invoices`
--

CREATE TABLE `geopos_invoices` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `ship_tax` decimal(16,2) DEFAULT NULL,
  `ship_tax_type` enum('incl','excl','off') DEFAULT 'off',
  `discount` decimal(16,2) DEFAULT '0.00',
  `discount_rate` decimal(10,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `total` decimal(16,2) DEFAULT '0.00',
  `pmethod` varchar(14) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` enum('paid','due','canceled','partial') NOT NULL DEFAULT 'due',
  `csd` int(5) NOT NULL DEFAULT '0',
  `eid` int(4) NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` decimal(10,2) NOT NULL,
  `taxstatus` enum('yes','no','incl','cgst','igst') NOT NULL DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') NOT NULL DEFAULT '%',
  `refer` varchar(20) DEFAULT NULL,
  `term` int(3) NOT NULL,
  `multi` int(4) DEFAULT NULL,
  `i_class` int(1) NOT NULL DEFAULT '0',
  `loc` int(4) NOT NULL,
  `r_time` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_invoices`
--

INSERT INTO `geopos_invoices` (`id`, `tid`, `invoicedate`, `invoiceduedate`, `subtotal`, `shipping`, `ship_tax`, `ship_tax_type`, `discount`, `discount_rate`, `tax`, `total`, `pmethod`, `notes`, `status`, `csd`, `eid`, `pamnt`, `items`, `taxstatus`, `discstatus`, `format_discount`, `refer`, `term`, `multi`, `i_class`, `loc`, `r_time`) VALUES
(1, 1001, '2021-06-09', '2021-06-09', 6.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 6.00, 'Cash', '', 'paid', 1, 11, 6.00, 3.00, 'yes', 1, '%', '', 1, 0, 1, 0, NULL),
(2, 1001, '2021-06-09', '2021-06-09', 12.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 12.00, NULL, '', 'due', 2, 11, 0.00, 2.00, 'yes', 1, '%', '', 1, 1, 0, 0, NULL),
(3, 1002, '2021-06-09', '2021-06-09', 10.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 10.00, 'Cash', '', 'paid', 1, 11, 10.00, 1.00, 'yes', 1, '%', '', 1, 0, 1, 0, NULL),
(4, 1003, '2021-06-09', '2021-06-09', 12.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 12.00, 'Cash', '', 'paid', 1, 11, 12.00, 2.00, 'yes', 1, '%', '', 1, 0, 1, 0, NULL),
(5, 1004, '2021-06-09', '2021-06-09', 24.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 24.00, 'Cash', '', 'paid', 1, 12, 24.00, 4.00, 'yes', 1, '%', '', 1, 0, 1, 0, NULL),
(7, 1005, '2021-06-16', '2021-06-16', 120.00, 0.00, 0.00, 'incl', 0.00, 0.00, 0.00, 120.00, 'Cash', '', 'paid', 1, 13, 120.00, 20.00, 'yes', 1, '%', '', 1, 0, 1, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_invoice_items`
--

CREATE TABLE `geopos_invoice_items` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `product` varchar(255) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `qty` decimal(10,2) NOT NULL DEFAULT '0.00',
  `price` decimal(16,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `discount` decimal(16,2) DEFAULT '0.00',
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `totaltax` decimal(16,2) DEFAULT '0.00',
  `totaldiscount` decimal(16,2) DEFAULT '0.00',
  `product_des` text,
  `i_class` int(1) NOT NULL DEFAULT '0',
  `unit` varchar(5) DEFAULT NULL,
  `serial` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_invoice_items`
--

INSERT INTO `geopos_invoice_items` (`id`, `tid`, `pid`, `product`, `code`, `qty`, `price`, `tax`, `discount`, `subtotal`, `totaltax`, `totaldiscount`, `product_des`, `i_class`, `unit`, `serial`) VALUES
(1, 1, 1, 'Atadwe Drinks-', '', 3.00, 2.00, 0.00, 0.00, 6.00, 0.00, 0.00, NULL, 1, '', ''),
(2, 2, 1, 'Atadwe Drinks', '', 1.00, 2.00, 0.00, 0.00, 2.00, 0.00, 0.00, '', 0, '', ''),
(3, 2, 2, 'Ewuraba Hair', '', 1.00, 10.00, 0.00, 0.00, 10.00, 0.00, 0.00, '', 0, '', ''),
(4, 3, 2, 'Ewuraba Hair-', '', 1.00, 10.00, 0.00, 0.00, 10.00, 0.00, 0.00, NULL, 1, '', ''),
(5, 4, 2, 'Ewuraba Hair-', '', 1.00, 10.00, 0.00, 0.00, 10.00, 0.00, 0.00, NULL, 1, '', ''),
(6, 4, 1, 'Atadwe Drinks-', '', 1.00, 2.00, 0.00, 0.00, 2.00, 0.00, 0.00, NULL, 1, '', ''),
(7, 5, 2, 'Ewuraba Hair-', '', 2.00, 10.00, 0.00, 0.00, 20.00, 0.00, 0.00, NULL, 1, '', ''),
(8, 5, 1, 'Atadwe Drinks-', '', 2.00, 2.00, 0.00, 0.00, 4.00, 0.00, 0.00, NULL, 1, '', ''),
(11, 7, 2, 'Ewuraba Hair-', '', 10.00, 10.00, 0.00, 0.00, 100.00, 0.00, 0.00, NULL, 1, '', ''),
(12, 7, 1, 'Atadwe Drinks-', '', 10.00, 2.00, 0.00, 0.00, 20.00, 0.00, 0.00, NULL, 1, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_locations`
--

CREATE TABLE `geopos_locations` (
  `id` int(3) NOT NULL,
  `cname` varchar(100) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `region` varchar(40) DEFAULT NULL,
  `country` varchar(40) DEFAULT NULL,
  `postbox` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `taxid` varchar(40) DEFAULT NULL,
  `logo` varchar(50) DEFAULT 'logo.png',
  `cur` int(4) NOT NULL,
  `ware` int(11) DEFAULT '0',
  `ext` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_log`
--

CREATE TABLE `geopos_log` (
  `id` int(11) NOT NULL,
  `note` mediumtext NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_log`
--

INSERT INTO `geopos_log` (`id`, `note`, `created`, `user`) VALUES
(1, '[Logged In] ampabeng99@gmail.com', '2021-06-09 12:48:48', ''),
(2, '[Category Edited] Drinks ID 1', '2021-06-09 13:13:07', 'admin'),
(3, '[Category Created] Spices ID 2', '2021-06-09 13:13:59', 'admin'),
(4, '[Category Created] Hair Pomade ID 3', '2021-06-09 13:14:23', 'admin'),
(5, '[Category Created] Rice ID 4', '2021-06-09 13:14:58', 'admin'),
(6, '[Category Created] Body Pomade ID 5', '2021-06-09 13:15:28', 'admin'),
(7, '[New Product] -Atadwe Drinks  -Qty-10 ID 1', '2021-06-09 13:29:34', 'admin'),
(8, '[New Product] -Ewuraba Hair  -Qty-10 ID 2', '2021-06-09 13:30:42', 'admin'),
(9, '[Payment Invoice 1]  Transaction-1 - 6 ', '2021-06-09 13:32:16', 'admin'),
(10, '[Client Added] Adwenpa Systems ID 2', '2021-06-09 13:38:22', 'admin'),
(11, '[Logged In] richmond@dha.com', '2021-06-09 13:46:36', ''),
(12, '[Payment Invoice 3]  Transaction-3 - 10 ', '2021-06-09 13:48:42', 'rampabeng'),
(13, '[Payment Invoice 4]  Transaction-4 - 12 ', '2021-06-09 13:49:43', 'rampabeng'),
(14, '[Logged In] richmond@dha.com', '2021-06-09 13:54:32', ''),
(15, '[Payment Invoice 5]  Transaction-5 - 24 ', '2021-06-09 13:55:23', 'rampabeng'),
(16, '[Logged In] ampabeng99@gmail.com', '2021-06-09 15:05:27', ''),
(17, '[Client Updated] Walk-in Client ID 1', '2021-06-09 15:09:46', 'admin'),
(18, '[Logged Out] admin', '2021-06-09 15:12:34', ''),
(19, '[Logged In] naakrasi@gmail.com', '2021-06-09 15:13:31', ''),
(20, '[Logged In] naakrasi@gmail.com', '2021-06-09 18:35:11', ''),
(21, '[Logged In] ampabeng99@gmail.com', '2021-06-11 09:11:07', ''),
(22, '[Logged In] ampabeng99@gmail.com', '2021-06-12 20:48:55', ''),
(23, '[Logged In] naakrasi@gmail.com', '2021-06-13 19:16:26', ''),
(24, '[Logged In] ampabeng99@gmail.com', '2021-06-16 16:11:08', ''),
(25, '[Logged In] ampabeng99@gmail.com', '2021-06-16 16:12:55', ''),
(26, '[Logged Out] admin', '2021-06-16 16:16:29', ''),
(27, '[Logged In] speare@dha.com', '2021-06-16 16:17:54', ''),
(28, '[Logged In] speare@dha.com', '2021-06-16 16:17:55', ''),
(29, '[Payment Invoice 6]  Transaction-6 - 120 ', '2021-06-16 16:19:43', 'speare'),
(30, '[WareHouse Created] Adansi ID 7', '2021-06-16 16:38:23', 'admin'),
(31, '[Update Product] -Ewuraba Hair  -Qty-100 ID 2', '2021-06-16 16:45:25', 'admin'),
(32, '[Update Product] -Atadwe Drinks  -Qty-50 ID 1', '2021-06-16 16:46:22', 'admin'),
(33, '[Logged In] speare@dha.com', '2021-06-16 16:48:17', ''),
(34, '[Logged In] speare@dha.com', '2021-06-16 16:48:18', ''),
(35, '[Logged In] speare@dha.com', '2021-06-16 16:52:47', ''),
(36, '[Payment Invoice 7]  Transaction-7 - 120 ', '2021-06-16 16:54:18', 'speare'),
(37, '[Logged In] naakrasi@gmail.com', '2021-06-21 14:08:12', ''),
(38, '[Logged In] naakrasi@gmail.com', '2021-06-22 13:07:30', ''),
(39, '[Logged In] naakrasi@gmail.com', '2021-06-23 13:47:16', '');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_login_attempts`
--

CREATE TABLE `geopos_login_attempts` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(39) DEFAULT '0',
  `timestamp` datetime DEFAULT NULL,
  `login_attempts` tinyint(2) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geopos_login_attempts`
--

INSERT INTO `geopos_login_attempts` (`id`, `ip_address`, `timestamp`, `login_attempts`) VALUES
(4, '41.207.252.122', '2021-06-09 14:04:08', 2);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_metadata`
--

CREATE TABLE `geopos_metadata` (
  `id` int(11) NOT NULL,
  `type` int(3) NOT NULL,
  `rid` int(11) NOT NULL,
  `col1` varchar(255) DEFAULT NULL,
  `col2` varchar(255) DEFAULT NULL,
  `d_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `geopos_metadata`
--

INSERT INTO `geopos_metadata` (`id`, `type`, `rid`, `col1`, `col2`, `d_date`) VALUES
(1, 9, 1, '-3', NULL, '2021-06-09'),
(2, 9, 2, '4', NULL, '2021-06-09'),
(3, 9, 3, '5', NULL, '2021-06-09'),
(4, 9, 4, '4', NULL, '2021-06-09'),
(5, 9, 5, '8', NULL, '2021-06-09'),
(6, 9, 6, '0', NULL, '2021-06-16'),
(7, 9, 7, '40', NULL, '2021-06-16');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_milestones`
--

CREATE TABLE `geopos_milestones` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sdate` date NOT NULL,
  `edate` date NOT NULL,
  `exp` text NOT NULL,
  `color` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_movers`
--

CREATE TABLE `geopos_movers` (
  `id` int(11) NOT NULL,
  `d_type` int(3) NOT NULL,
  `rid1` int(11) NOT NULL,
  `rid2` int(11) NOT NULL,
  `rid3` int(11) NOT NULL,
  `d_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `note` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_movers`
--

INSERT INTO `geopos_movers` (`id`, `d_type`, `rid1`, `rid2`, `rid3`, `d_time`, `note`) VALUES
(1, 1, 1, 10, 0, '2021-06-09 13:29:34', 'Stock Initialized'),
(2, 1, 2, 10, 0, '2021-06-09 13:30:42', 'Stock Initialized'),
(3, 1, 2, 95, 0, '2021-06-16 16:45:25', 'Stock Changes'),
(4, 1, 1, 47, 0, '2021-06-16 16:46:22', 'Stock Changes');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_notes`
--

CREATE TABLE `geopos_notes` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text,
  `cdate` date NOT NULL,
  `last_edit` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cid` int(11) NOT NULL DEFAULT '0',
  `fid` int(11) NOT NULL DEFAULT '0',
  `rid` int(11) NOT NULL DEFAULT '0',
  `ntype` int(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_pms`
--

CREATE TABLE `geopos_pms` (
  `id` int(11) UNSIGNED NOT NULL,
  `sender_id` int(11) UNSIGNED NOT NULL,
  `receiver_id` int(11) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text,
  `date_sent` datetime DEFAULT NULL,
  `date_read` datetime DEFAULT NULL,
  `pm_deleted_sender` int(1) NOT NULL,
  `pm_deleted_receiver` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_premissions`
--

CREATE TABLE `geopos_premissions` (
  `id` int(11) NOT NULL,
  `module` enum('Sales','Stock','Crm','Project','Accounts','Miscellaneous','Employees','Assign Project','Customer Profile','Reports','Delete','POS') NOT NULL,
  `r_1` int(1) NOT NULL,
  `r_2` int(1) NOT NULL,
  `r_3` int(1) NOT NULL,
  `r_4` int(1) NOT NULL,
  `r_5` int(1) NOT NULL,
  `r_6` int(1) NOT NULL,
  `r_7` int(1) NOT NULL,
  `r_8` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geopos_premissions`
--

INSERT INTO `geopos_premissions` (`id`, `module`, `r_1`, `r_2`, `r_3`, `r_4`, `r_5`, `r_6`, `r_7`, `r_8`) VALUES
(1, 'Sales', 0, 1, 1, 1, 1, 0, 0, 0),
(2, 'Stock', 1, 0, 1, 1, 1, 0, 0, 0),
(3, 'Crm', 0, 0, 1, 1, 1, 0, 0, 0),
(4, 'Project', 0, 0, 0, 1, 1, 1, 0, 0),
(5, 'Accounts', 0, 0, 0, 1, 1, 0, 0, 0),
(6, 'Miscellaneous', 0, 0, 0, 1, 1, 0, 0, 0),
(7, 'Assign Project', 0, 1, 0, 0, 1, 0, 0, 0),
(8, 'Customer Profile', 0, 0, 0, 0, 1, 0, 0, 0),
(9, 'Employees', 0, 0, 0, 0, 1, 0, 0, 0),
(10, 'Reports', 0, 0, 0, 1, 1, 0, 0, 0),
(11, 'Delete', 1, 1, 1, 1, 1, 1, 1, 1),
(12, 'POS', 1, 1, 1, 1, 1, 1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_products`
--

CREATE TABLE `geopos_products` (
  `pid` int(11) NOT NULL,
  `pcat` int(3) NOT NULL DEFAULT '1',
  `warehouse` int(11) NOT NULL DEFAULT '1',
  `product_name` varchar(80) NOT NULL,
  `product_code` varchar(30) DEFAULT NULL,
  `product_price` decimal(16,2) DEFAULT '0.00',
  `fproduct_price` decimal(16,2) DEFAULT '0.00',
  `taxrate` decimal(16,2) DEFAULT '0.00',
  `disrate` decimal(16,2) DEFAULT '0.00',
  `qty` decimal(10,2) NOT NULL,
  `product_des` text,
  `alert` int(11) DEFAULT NULL,
  `unit` varchar(4) DEFAULT NULL,
  `image` varchar(120) DEFAULT 'default.png',
  `barcode` varchar(16) DEFAULT NULL,
  `merge` int(2) NOT NULL,
  `sub` int(11) NOT NULL,
  `vb` int(11) NOT NULL,
  `expiry` date DEFAULT NULL,
  `code_type` varchar(8) DEFAULT 'EAN13',
  `sub_id` int(11) DEFAULT '0',
  `b_id` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_products`
--

INSERT INTO `geopos_products` (`pid`, `pcat`, `warehouse`, `product_name`, `product_code`, `product_price`, `fproduct_price`, `taxrate`, `disrate`, `qty`, `product_des`, `alert`, `unit`, `image`, `barcode`, `merge`, `sub`, `vb`, `expiry`, `code_type`, `sub_id`, `b_id`) VALUES
(1, 1, 1, 'Atadwe Drinks', '', 2.00, 3.00, 0.00, 0.00, 40.00, '', 5, '', 'default.png', '263358488599', 0, 0, 0, NULL, '  EAN13', 0, NULL),
(2, 3, 1, 'Ewuraba Hair', '', 10.00, 5.00, 0.00, 0.00, 90.00, '', 3, '', 'default.png', '846235503903', 0, 0, 0, NULL, '  EAN13', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_product_cat`
--

CREATE TABLE `geopos_product_cat` (
  `id` int(3) NOT NULL,
  `title` varchar(100) NOT NULL,
  `extra` varchar(255) DEFAULT NULL,
  `c_type` int(2) DEFAULT '0',
  `rel_id` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_product_cat`
--

INSERT INTO `geopos_product_cat` (`id`, `title`, `extra`, `c_type`, `rel_id`) VALUES
(1, 'Drinks', 'General Cat', 0, 0),
(2, 'Spices', 'Spices', 0, 0),
(3, 'Hair Pomade', 'Hair Pomade', 0, 0),
(4, 'Rice', 'Rice', 0, 0),
(5, 'Body Pomade', 'Body Pomade', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_product_serials`
--

CREATE TABLE `geopos_product_serials` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `serial` varchar(200) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_projects`
--

CREATE TABLE `geopos_projects` (
  `id` int(11) NOT NULL,
  `p_id` varchar(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` enum('Waiting','Pending','Terminated','Finished','Progress') NOT NULL DEFAULT 'Pending',
  `priority` enum('Low','Medium','High','Urgent') NOT NULL DEFAULT 'Medium',
  `progress` int(3) NOT NULL,
  `cid` int(11) NOT NULL,
  `sdate` date NOT NULL,
  `edate` date NOT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `phase` varchar(255) DEFAULT NULL,
  `note` text,
  `worth` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ptype` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_project_meta`
--

CREATE TABLE `geopos_project_meta` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `meta_key` int(11) NOT NULL,
  `meta_data` varchar(200) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `key3` varchar(20) DEFAULT NULL,
  `key4` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_promo`
--

CREATE TABLE `geopos_promo` (
  `id` int(11) NOT NULL,
  `code` varchar(15) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `valid` date NOT NULL,
  `active` int(1) NOT NULL,
  `note` varchar(100) NOT NULL,
  `reflect` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `available` int(11) NOT NULL,
  `location` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_purchase`
--

CREATE TABLE `geopos_purchase` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `ship_tax` decimal(16,2) DEFAULT NULL,
  `ship_tax_type` enum('incl','excl','off') DEFAULT 'off',
  `discount` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `total` decimal(16,2) DEFAULT '0.00',
  `pmethod` varchar(14) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` enum('paid','due','canceled','partial') DEFAULT 'due',
  `csd` int(5) NOT NULL DEFAULT '0',
  `eid` int(4) NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` decimal(10,2) NOT NULL,
  `taxstatus` enum('yes','no','incl','cgst','igst') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT NULL,
  `refer` varchar(20) DEFAULT NULL,
  `term` int(3) NOT NULL,
  `loc` int(4) NOT NULL,
  `multi` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_purchase_items`
--

CREATE TABLE `geopos_purchase_items` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `qty` decimal(10,2) NOT NULL,
  `price` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `discount` decimal(16,2) DEFAULT '0.00',
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `totaltax` decimal(16,2) DEFAULT '0.00',
  `totaldiscount` decimal(16,2) DEFAULT '0.00',
  `product_des` text,
  `unit` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_quotes`
--

CREATE TABLE `geopos_quotes` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `ship_tax` decimal(16,2) DEFAULT NULL,
  `ship_tax_type` enum('incl','excl','off') DEFAULT 'off',
  `discount` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `total` decimal(16,2) DEFAULT '0.00',
  `pmethod` varchar(14) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` enum('pending','accepted','rejected','customer_approved') DEFAULT 'pending',
  `csd` int(5) NOT NULL DEFAULT '0',
  `eid` int(4) NOT NULL,
  `pamnt` decimal(16,2) NOT NULL,
  `items` decimal(10,2) NOT NULL,
  `taxstatus` enum('yes','no','incl','cgst','igst') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT '%',
  `refer` varchar(20) DEFAULT NULL,
  `term` int(3) NOT NULL,
  `proposal` text,
  `multi` int(4) DEFAULT NULL,
  `loc` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_quotes_items`
--

CREATE TABLE `geopos_quotes_items` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `qty` decimal(16,2) NOT NULL,
  `price` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `discount` decimal(16,2) DEFAULT '0.00',
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `totaltax` decimal(16,2) DEFAULT '0.00',
  `totaldiscount` decimal(16,2) DEFAULT '0.00',
  `product_des` text,
  `unit` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_register`
--

CREATE TABLE `geopos_register` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `o_date` datetime NOT NULL,
  `c_date` datetime NOT NULL,
  `cash` decimal(16,2) NOT NULL,
  `card` decimal(16,2) NOT NULL,
  `bank` decimal(16,2) NOT NULL,
  `cheque` decimal(16,2) NOT NULL,
  `r_change` decimal(16,2) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_register`
--

INSERT INTO `geopos_register` (`id`, `uid`, `o_date`, `c_date`, `cash`, `card`, `bank`, `cheque`, `r_change`, `active`) VALUES
(1, 11, '2021-06-09 12:49:31', '0000-00-00 00:00:00', 6.00, 0.00, 0.00, 0.00, 4.00, 1),
(2, 12, '2021-06-09 13:48:05', '0000-00-00 00:00:00', 46.00, 0.00, 0.00, 0.00, 0.00, 1),
(3, 13, '2021-06-09 15:16:12', '0000-00-00 00:00:00', 0.00, 0.00, 0.00, 0.00, 0.00, 1),
(4, 14, '2021-06-16 16:18:27', '0000-00-00 00:00:00', 120.00, 0.00, 0.00, 0.00, 0.00, 1);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_reports`
--

CREATE TABLE `geopos_reports` (
  `id` int(11) NOT NULL,
  `month` varchar(10) DEFAULT NULL,
  `year` int(4) NOT NULL,
  `invoices` int(11) NOT NULL,
  `sales` decimal(16,2) DEFAULT '0.00',
  `items` decimal(10,2) NOT NULL,
  `income` decimal(16,2) DEFAULT '0.00',
  `expense` decimal(16,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_restkeys`
--

CREATE TABLE `geopos_restkeys` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `key` varchar(40) DEFAULT NULL,
  `level` int(2) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
  `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
  `ip_addresses` text,
  `date_created` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_smtp`
--

CREATE TABLE `geopos_smtp` (
  `id` int(11) NOT NULL,
  `host` varchar(100) NOT NULL,
  `port` int(11) NOT NULL,
  `auth` enum('true','false') NOT NULL,
  `auth_type` enum('none','tls','ssl') NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `sender` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_smtp`
--

INSERT INTO `geopos_smtp` (`id`, `host`, `port`, `auth`, `auth_type`, `username`, `password`, `sender`) VALUES
(1, 'smtp.com', 587, 'true', 'none', 'support@example.com', '123456', 'support@example.com');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_stock_r`
--

CREATE TABLE `geopos_stock_r` (
  `id` int(11) NOT NULL,
  `tid` int(8) NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `ship_tax` decimal(16,2) DEFAULT NULL,
  `ship_tax_type` enum('incl','excl','off') DEFAULT 'off',
  `discount` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `total` decimal(16,2) DEFAULT '0.00',
  `pmethod` varchar(14) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` enum('pending','accepted','rejected','partial','canceled') DEFAULT 'pending',
  `csd` int(5) NOT NULL DEFAULT '0',
  `eid` int(4) NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` decimal(10,0) NOT NULL,
  `taxstatus` enum('yes','no','incl','cgst','igst') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','bflat','b_p') DEFAULT NULL,
  `refer` varchar(20) DEFAULT NULL,
  `term` int(3) NOT NULL,
  `loc` int(4) NOT NULL,
  `i_class` int(1) NOT NULL DEFAULT '0',
  `multi` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_stock_r_items`
--

CREATE TABLE `geopos_stock_r_items` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `qty` decimal(10,2) NOT NULL,
  `price` decimal(16,2) DEFAULT '0.00',
  `tax` decimal(16,2) DEFAULT '0.00',
  `discount` decimal(16,2) DEFAULT '0.00',
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `totaltax` decimal(16,2) DEFAULT '0.00',
  `totaldiscount` decimal(16,2) DEFAULT '0.00',
  `product_des` text,
  `unit` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_supplier`
--

CREATE TABLE `geopos_supplier` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `region` varchar(30) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `postbox` varchar(20) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `picture` varchar(100) NOT NULL DEFAULT 'example.png',
  `gid` int(5) NOT NULL DEFAULT '1',
  `company` varchar(100) DEFAULT NULL,
  `taxid` varchar(100) DEFAULT NULL,
  `loc` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_system`
--

CREATE TABLE `geopos_system` (
  `id` int(1) NOT NULL,
  `cname` char(50) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(30) NOT NULL,
  `region` varchar(40) NOT NULL,
  `country` varchar(30) NOT NULL,
  `postbox` varchar(15) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(40) NOT NULL,
  `taxid` varchar(20) NOT NULL,
  `tax` int(11) NOT NULL,
  `currency` varchar(4) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `currency_format` int(1) NOT NULL,
  `prefix` varchar(5) NOT NULL,
  `dformat` int(1) NOT NULL,
  `zone` varchar(25) NOT NULL,
  `logo` varchar(30) NOT NULL,
  `lang` varchar(20) DEFAULT 'english',
  `foundation` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_system`
--

INSERT INTO `geopos_system` (`id`, `cname`, `address`, `city`, `region`, `country`, `postbox`, `phone`, `email`, `taxid`, `tax`, `currency`, `currency_format`, `prefix`, `dformat`, `zone`, `logo`, `lang`, `foundation`) VALUES
(1, 'EWURABA NATURAL VENTURES', 'Aheneba Kokobeng', 'Kumasi', 'Ashanti', 'Ghana', '123', '+233 24 316 2888', 'support@ewurabanaturals.com', '23442', -1, '₵', 0, 'SRN', 1, 'Etc/Greenwich', '16232435751186128331.png', 'english', '2021-06-09');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_terms`
--

CREATE TABLE `geopos_terms` (
  `id` int(4) NOT NULL,
  `title` varchar(100) NOT NULL,
  `type` int(1) NOT NULL,
  `terms` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_terms`
--

INSERT INTO `geopos_terms` (`id`, `title`, `type`, `terms`) VALUES
(1, 'Payment On Receipt', 0, '<p>1. 10% discount if payment received within ten days otherwise payment 30 days\n            after invoice date<br></p>');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_tickets`
--

CREATE TABLE `geopos_tickets` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `cid` int(11) NOT NULL,
  `status` enum('Solved','Processing','Waiting') NOT NULL,
  `section` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_tickets_th`
--

CREATE TABLE `geopos_tickets_th` (
  `id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `message` text,
  `cid` int(11) NOT NULL,
  `eid` int(11) NOT NULL,
  `cdate` datetime NOT NULL,
  `attach` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_todolist`
--

CREATE TABLE `geopos_todolist` (
  `id` int(11) NOT NULL,
  `tdate` date NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `status` enum('Due','Done','Progress') NOT NULL DEFAULT 'Due',
  `start` date NOT NULL,
  `duedate` date NOT NULL,
  `description` text,
  `eid` int(11) NOT NULL,
  `aid` int(11) NOT NULL,
  `related` int(11) NOT NULL,
  `priority` enum('Low','Medium','High','Urgent') NOT NULL,
  `rid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_transactions`
--

CREATE TABLE `geopos_transactions` (
  `id` int(11) NOT NULL,
  `acid` int(11) NOT NULL,
  `account` varchar(200) NOT NULL,
  `type` enum('Income','Expense','Transfer') NOT NULL,
  `cat` varchar(200) NOT NULL,
  `debit` decimal(16,2) DEFAULT '0.00',
  `credit` decimal(16,2) DEFAULT '0.00',
  `payer` varchar(200) DEFAULT NULL,
  `payerid` int(11) NOT NULL DEFAULT '0',
  `method` varchar(200) DEFAULT NULL,
  `date` date NOT NULL,
  `tid` int(11) NOT NULL DEFAULT '0',
  `eid` int(11) NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `ext` int(1) DEFAULT '0',
  `loc` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_transactions`
--

INSERT INTO `geopos_transactions` (`id`, `acid`, `account`, `type`, `cat`, `debit`, `credit`, `payer`, `payerid`, `method`, `date`, `tid`, `eid`, `note`, `ext`, `loc`) VALUES
(1, 1, 'Sales Account', 'Income', 'Sales', 0.00, 6.00, 'Walk-in Client', 1, 'Cash', '2021-06-09', 1, 11, '#1001-Cash', 0, 0),
(2, 1, 'Sales Account', 'Income', 'Sales', 0.00, 0.00, 'Walk-in Client', 1, 'Cash', '2021-06-09', 1, 11, 'Payment for invoice #1001', 0, 0),
(3, 1, 'Sales Account', 'Income', 'Sales', 0.00, 10.00, 'Walk-in Client', 1, 'Cash', '2021-06-09', 3, 11, '#1002-Cash', 0, 0),
(4, 1, 'Sales Account', 'Income', 'Sales', 0.00, 12.00, 'Walk-in Client', 1, 'Cash', '2021-06-09', 4, 11, '#1003-Cash', 0, 0),
(5, 1, 'Sales Account', 'Income', 'Sales', 0.00, 24.00, 'Walk-in Client', 1, 'Cash', '2021-06-09', 5, 12, '#1004-Cash', 0, 0),
(7, 1, 'Sales Account', 'Income', 'Sales', 0.00, 120.00, 'Walk-in Client', 1, 'Cash', '2021-06-16', 7, 13, '#1005-Cash', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `geopos_trans_cat`
--

CREATE TABLE `geopos_trans_cat` (
  `id` int(11) NOT NULL,
  `name` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_trans_cat`
--

INSERT INTO `geopos_trans_cat` (`id`, `name`) VALUES
(1, 'Income'),
(2, 'Expenses'),
(3, 'Other');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_units`
--

CREATE TABLE `geopos_units` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `code` varchar(5) NOT NULL,
  `type` int(1) NOT NULL,
  `sub` int(1) NOT NULL,
  `rid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `geopos_users`
--

CREATE TABLE `geopos_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `email` varchar(100) NOT NULL,
  `pass` varchar(64) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `banned` tinyint(1) DEFAULT '0',
  `last_login` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `date_created` datetime DEFAULT NULL,
  `forgot_exp` text,
  `remember_time` datetime DEFAULT NULL,
  `remember_exp` text,
  `verification_code` text,
  `totp_secret` varchar(16) DEFAULT NULL,
  `ip_address` text,
  `roleid` int(1) NOT NULL,
  `picture` varchar(50) DEFAULT NULL,
  `loc` int(11) NOT NULL,
  `lang` char(15) NOT NULL DEFAULT 'english'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_users`
--

INSERT INTO `geopos_users` (`id`, `email`, `pass`, `username`, `banned`, `last_login`, `last_activity`, `date_created`, `forgot_exp`, `remember_time`, `remember_exp`, `verification_code`, `totp_secret`, `ip_address`, `roleid`, `picture`, `loc`, `lang`) VALUES
(11, 'ampabeng99@gmail.com', '391ed40ef01e7c09b0c27d97adba46d9aa04e52e1a3c9c7561185393b84d223c', 'admin', 0, '2021-06-16 16:12:55', '2021-06-16 16:12:55', '2021-06-09 12:48:18', NULL, NULL, NULL, '', NULL, '154.160.20.245', 5, 'example.png', 0, 'english'),
(12, 'richmond@dha.com', 'cf5bc6f5153ce90f89fc44735d7d0288b69c09f64ba3f434f39d2a9ef2274764', 'rampabeng', 0, '2021-06-09 13:54:32', '2021-06-09 13:54:32', '2021-06-09 13:44:48', NULL, NULL, NULL, NULL, NULL, '41.207.252.122', 2, 'example.png', 0, 'english'),
(13, 'naakrasi@gmail.com', 'b42e2fbcb7e1134a46054d69d40f91bc354d43d2e51fad44b585db1c8ff0b3f6', 'Ewuraba', 0, '2021-06-23 13:47:16', '2021-06-23 13:47:16', '2021-06-09 15:12:22', NULL, '2021-06-12 00:00:00', 'CoFbq2kJGtISwpYd', NULL, NULL, '150.129.104.28', 5, 'example.png', 0, 'english'),
(14, 'speare@dha.com', '2a74b4a28f00408c278c6620a81f507dd1a74a7e0237eab83c4a967665968f48', 'speare', 0, '2021-06-16 16:52:47', '2021-06-16 16:52:47', '2021-06-16 16:15:53', NULL, NULL, NULL, NULL, NULL, '102.176.94.129', 2, 'example.png', 0, 'english');

-- --------------------------------------------------------

--
-- Table structure for table `geopos_warehouse`
--

CREATE TABLE `geopos_warehouse` (
  `id` int(3) NOT NULL,
  `title` varchar(100) NOT NULL,
  `extra` varchar(255) DEFAULT NULL,
  `loc` int(4) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `geopos_warehouse`
--

INSERT INTO `geopos_warehouse` (`id`, `title`, `extra`, `loc`) VALUES
(1, 'Main WareHouse', 'The Main WareHouse', 0),
(2, 'sokoban', 'The Main WareHouse', 0),
(3, 'Tuc', 'The Main WareHouse', 0),
(4, 'Main WareHouse', 'The Main WareHouse', 0),
(5, 'Main WareHouse', 'The Main WareHouse', 0),
(6, 'Main WareHouse', 'The Main WareHouse', 0),
(7, 'Adansi', 'For drinks only', 0);

-- --------------------------------------------------------

--
-- Table structure for table `univarsal_api`
--

CREATE TABLE `univarsal_api` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `key1` varchar(255) DEFAULT NULL,
  `key2` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `method` varchar(10) DEFAULT NULL,
  `other` text,
  `active` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `univarsal_api`
--

INSERT INTO `univarsal_api` (`id`, `name`, `key1`, `key2`, `url`, `method`, `other`, `active`) VALUES
(1, 'Goo.gl URL Shortner', 'yourkey', '0', '0', '0', '0', 0),
(2, 'Twilio SMS API', 'ac', 'key', '+11234567', '0', '0', 1),
(3, 'Company Support', '1', '1', 'support@gmail.com', NULL, '<p>Your footer</p>', 1),
(4, 'Currency', '.', ',', '2', 'l', '', 0),
(5, 'Exchange', 'key1v', 'key2', 'GHS', NULL, '1', 1),
(6, 'New Invoice Notification', '[{Company}] Invoice #{BillNumber} Generated', NULL, NULL, NULL, '<p>Dear\n            Client,\r\n</p><p>We are contacting you in regard to a payment received for invoice # {BillNumber} that has\n            been created on your account. You may find the invoice with below link.\r\n\r\nView\n            Invoice\r\n{URL}\r\n\r\nWe look forward to conducting future business with you.\r\n\r\nKind\n            Regards,\r\nTeam\r\n{CompanyDetails}</p>', NULL),
(7, 'Invoice Payment Reminder', '[{Company}] Invoice #{BillNumber} Payment Reminder', NULL, NULL, NULL, '<p>Dear\n            Client,</p><p>We are contacting you in regard to a payment reminder of invoice # {BillNumber} that has been\n            created on your account. You may find the invoice with below link. Please pay the balance of {Amount} due by\n            {DueDate}.</p><p>\r\n\r\n<b>View Invoice</b></p><p><span style=\"font-size: 1rem;\">{URL}\r\n</span></p><p>\n            <span style=\"font-size: 1rem;\">\r\nWe look forward to conducting future business with you.</span></p><p>\n            <span style=\"font-size: 1rem;\">\r\n\r\nKind Regards,\r\n</span></p><p><span style=\"font-size: 1rem;\">\r\nTeam\r\n</span>\n        </p><p><span style=\"font-size: 1rem;\">\r\n{CompanyDetails}</span></p>', NULL),
(8, 'Invoice Refund Proceeded', '{Company} Invoice #{BillNumber} Refund Proceeded', NULL, NULL, NULL, '<p>Dear\n            Client,</p><p>\r\nWe are contacting you in regard to a refund request processed for invoice # {BillNumber}\n            that has been created on your account. You may find the invoice with below link. Please pay the balance of\n            {Amount} by {DueDate}.\r\n</p><p>\r\nView Invoice\r\n</p><p>{URL}\r\n</p><p>\r\nWe look forward to\n            conducting future business with you.\r\n</p><p>\r\nKind Regards,\r\n</p><p>\n            \r\nTeam\r\n\r\n{CompanyDetails}</p>', NULL),
(9, 'Invoice payment Received', '{Company} Payment Received for Invoice #{BillNumber}', NULL, NULL, NULL, '<p>\n            Dear Client,\r\n</p><p>We are contacting you in regard to a payment received for invoice # {BillNumber} that\n            has been created on your account. You can find the invoice with below link.\r\n</p><p>\r\nView Invoice</p>\n        <p>\r\n{URL}\r\n</p><p>\r\nWe look forward to conducting future business with you.\r\n</p><p>\r\nKind\n            Regards,\r\n</p><p>\r\nTeam\r\n</p><p>\r\n{CompanyDetails}</p>', NULL),
(10, 'Invoice Overdue Notice', '{Company} Invoice #{BillNumber} Generated for you', NULL, NULL, NULL, '<p>Dear\n            Client,</p><p>\r\nWe are contacting you in regard to an Overdue Notice for invoice # {BillNumber} that has\n            been created on your account. You may find the invoice with below link.\r\nPlease pay the balance of\n            {Amount} due by {DueDate}.\r\n</p><p>View Invoice\r\n</p><p>{URL}\r\n</p><p>\r\nWe look forward to\n            conducting future business with you.\r\n</p><p>\r\nKind Regards,\r\n</p><p>\r\nTeam</p><p>\n            \r\n\r\n{CompanyDetails}</p>', NULL),
(11, 'Quote Proposal', '{Company} Quote #{BillNumber} Generated for you', NULL, NULL, NULL, '<p>Dear Client,</p>\n        <p>\r\nWe are contacting you in regard to a new quote # {BillNumber} that has been created on your account. You\n            may find the quote with below link.\r\n</p><p>\r\nView Invoice\r\n</p><p>{URL}\r\n</p><p>\r\nWe look forward\n            to conducting future business with you.</p><p>\r\n\r\nKind Regards,</p><p>\r\n\r\nTeam</p><p>\n            \r\n\r\n{CompanyDetails}</p>', NULL),
(12, 'Purchase Order Request', '{Company} Purchase Order #{BillNumber} Requested', NULL, NULL, NULL, '<p>Dear\n            Client,\r\n</p><p>We are contacting you in regard to a new purchase # {BillNumber} that has been requested\n            on your account. You may find the order with below link. </p><p>\r\n\r\nView Invoice\r\n</p><p>{URL}</p><p>\n            \r\n\r\nWe look forward to conducting future business with you.</p><p>\r\n\r\nKind Regards,\r\n</p><p>\n            \r\nTeam</p><p>\r\n\r\n{CompanyDetails}</p>', NULL),
(13, 'Stock Return Mail', '{Company} New purchase return # {BillNumber}', NULL, NULL, NULL, 'Dear Client,\r\n\r\nWe are contacting you in regard to a new purchase return # {BillNumber} that has been requested on your account. You may find the order with below link.\r\n\r\nView Invoice\r\n\r\n{URL}\r\n\r\nWe look forward to conducting future business with you.\r\n\r\nKind Regards,\r\n\r\nTeam\r\n\r\n{CompanyDetails}', NULL),
(14, 'Customer Registration', '{Company}  Customer Registration - {NAME}', NULL, NULL, NULL, 'Dear Customer,\r\nThank You for registration, please confirm the registration by the following URL {REG_URL}\r\nRegards', NULL),
(15, ' Customer Password Reset', '{Company}  Customer Password Reset- {NAME}', NULL, NULL, NULL, 'Dear Customer,\r\nPlease reset the password by the following URL {RESET_URL}\r\nRegards', NULL),
(16, 'Customer Registration by Employee', '{Company}  Customer Registration - {NAME}', '0', '0', '0', 'Dear Customer,\r\nThank You for registration.\r\nLogin URL: {URL}\r\nLogin Email: {EMAIL}\r\nPassword: {PASSWORD}\r\n\r\nRegards\r\n{CompanyDetails}', 0),
(30, 'New Invoice Notification', NULL, NULL, NULL, NULL, 'Dear Customer, new invoice  # {BillNumber} generated. {URL} Regards', NULL),
(31, 'Invoice Payment Reminder', NULL, NULL, NULL, NULL, 'Dear Customer, Please make payment of invoice  # {BillNumber}. {URL} Regards', NULL),
(32, 'Invoice Refund Proceeded', NULL, NULL, NULL, NULL, 'Dear Customer, Refund generated of invoice # {BillNumber}. {URL} Regards', NULL),
(33, 'Invoice payment Received', NULL, NULL, NULL, NULL, 'Dear Customer, Payment received of invoice # {BillNumber}. {URL} Regards', NULL),
(34, 'Invoice Overdue Notice', NULL, NULL, NULL, NULL, 'Dear Customer, Dear Customer,Payment is overdue of invoice # {BillNumber}. {URL} Regards', NULL),
(35, 'Quote Proposal', NULL, NULL, NULL, NULL, 'Dear Customer, Dear Customer, a quote created for you # {BillNumber}. {URL} Regards', NULL),
(36, 'Purchase Order Request', NULL, NULL, NULL, NULL, 'Dear Customer, Dear, a purchased order for you # {BillNumber}. {URL} Regards', NULL),
(51, 'QT#', 'PO#', 'SUB#', 'SR#', 'TRN#', 'SRN#', 1),
(52, 'ThermalPrint', '0', NULL, NULL, NULL, 'POS#', 0),
(53, 'ConfPort', 'Public Key', '0', 'Private Key', NULL, NULL, 1),
(54, 'online_payment', '1', 'USD', '0', '0', NULL, 1),
(55, 'CronJob', '99293768', 'rec_email', 'email', 'rec_due', 'recemail', NULL),
(56, 'Auto Email SMS', 'email', 'sms', NULL, NULL, NULL, NULL),
(60, 'Warehouse', '1', NULL, NULL, NULL, NULL, NULL),
(61, 'Discount & Shipping', '%', '10.00', 'incl', NULL, '% Discount After TAX', NULL),
(62, 'AutoAttendance', '1', '0', '0', '0', '0', NULL),
(63, 'Zero Stock Billing', '1', '0', '0', '0', '0', 0),
(64, 'FrontEndSection', '0', '0', '0', '0', NULL, 0),
(65, 'Dual Entry', '0', '1', '0', '0', '0', 0),
(66, 'Email Alert', '0', '0', 'sample@email.com', '0', '0', 0),
(67, 'billing_settings', '0', '0', NULL, NULL, NULL, NULL),
(69, 'pos_settings', '1', '0', '0', '0', '0', 0);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `users_id` int(11) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `var_key` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `is_deleted` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `profile_pic` varchar(255) DEFAULT NULL,
  `user_type` varchar(255) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `lang` varchar(25) NOT NULL DEFAULT 'english',
  `code` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`users_id`, `user_id`, `var_key`, `status`, `is_deleted`, `name`, `password`, `email`, `profile_pic`, `user_type`, `cid`, `lang`, `code`) VALUES
(1, '1', NULL, 'active', '0', 'Walk-in Client', '$2y$10$TKfTVltchv/jxZIouy8i8O7rSzVvtdx4Y5wNRodK5RNyTBJkEoIAW', 'example@example.com', NULL, 'Member', 1, 'english', NULL),
(2, '1', NULL, 'active', '0', 'Adwenpa Systems', '$2y$10$8wwPQdYNk1PlDq6YAihsKOgo8bnPS5WMIbQz8wRB/I8XtkzXUqzpK', 'richmond@digitalhealthaccess.com', NULL, 'Member', 2, '', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `geopos_accounts`
--
ALTER TABLE `geopos_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `acn` (`acn`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `geopos_attendance`
--
ALTER TABLE `geopos_attendance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `emp` (`emp`);

--
-- Indexes for table `geopos_bank_ac`
--
ALTER TABLE `geopos_bank_ac`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_config`
--
ALTER TABLE `geopos_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `geopos_currencies`
--
ALTER TABLE `geopos_currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_customers`
--
ALTER TABLE `geopos_customers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gid` (`gid`);

--
-- Indexes for table `geopos_custom_data`
--
ALTER TABLE `geopos_custom_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fid` (`field_id`,`rid`);

--
-- Indexes for table `geopos_custom_fields`
--
ALTER TABLE `geopos_custom_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `f_module` (`f_module`);

--
-- Indexes for table `geopos_cust_group`
--
ALTER TABLE `geopos_cust_group`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_documents`
--
ALTER TABLE `geopos_documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_draft`
--
ALTER TABLE `geopos_draft`
  ADD PRIMARY KEY (`id`),
  ADD KEY `eid` (`eid`),
  ADD KEY `csd` (`csd`),
  ADD KEY `invoice` (`tid`) USING BTREE,
  ADD KEY `i_class` (`i_class`),
  ADD KEY `loc` (`loc`);

--
-- Indexes for table `geopos_draft_items`
--
ALTER TABLE `geopos_draft_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice` (`tid`),
  ADD KEY `i_class` (`i_class`);

--
-- Indexes for table `geopos_employees`
--
ALTER TABLE `geopos_employees`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_events`
--
ALTER TABLE `geopos_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rel` (`rel`),
  ADD KEY `rid` (`rid`);

--
-- Indexes for table `geopos_gateways`
--
ALTER TABLE `geopos_gateways`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_hrm`
--
ALTER TABLE `geopos_hrm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_invoices`
--
ALTER TABLE `geopos_invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `eid` (`eid`),
  ADD KEY `csd` (`csd`),
  ADD KEY `invoice` (`tid`) USING BTREE,
  ADD KEY `i_class` (`i_class`),
  ADD KEY `loc` (`loc`);

--
-- Indexes for table `geopos_invoice_items`
--
ALTER TABLE `geopos_invoice_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice` (`tid`),
  ADD KEY `i_class` (`i_class`);

--
-- Indexes for table `geopos_locations`
--
ALTER TABLE `geopos_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_log`
--
ALTER TABLE `geopos_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_login_attempts`
--
ALTER TABLE `geopos_login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_metadata`
--
ALTER TABLE `geopos_metadata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `rid` (`rid`);

--
-- Indexes for table `geopos_milestones`
--
ALTER TABLE `geopos_milestones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_movers`
--
ALTER TABLE `geopos_movers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `d_type` (`d_type`,`rid1`,`rid2`,`rid3`);

--
-- Indexes for table `geopos_notes`
--
ALTER TABLE `geopos_notes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_pms`
--
ALTER TABLE `geopos_pms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `full_index` (`id`,`sender_id`,`receiver_id`,`date_read`);

--
-- Indexes for table `geopos_premissions`
--
ALTER TABLE `geopos_premissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_products`
--
ALTER TABLE `geopos_products`
  ADD PRIMARY KEY (`pid`),
  ADD KEY `pcat` (`pcat`),
  ADD KEY `warehouse` (`warehouse`);

--
-- Indexes for table `geopos_product_cat`
--
ALTER TABLE `geopos_product_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_product_serials`
--
ALTER TABLE `geopos_product_serials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_projects`
--
ALTER TABLE `geopos_projects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `p_id` (`p_id`);

--
-- Indexes for table `geopos_project_meta`
--
ALTER TABLE `geopos_project_meta`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pid` (`pid`),
  ADD KEY `meta_key` (`meta_key`),
  ADD KEY `key3` (`key3`);

--
-- Indexes for table `geopos_promo`
--
ALTER TABLE `geopos_promo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code_2` (`code`),
  ADD KEY `code` (`code`);

--
-- Indexes for table `geopos_purchase`
--
ALTER TABLE `geopos_purchase`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice` (`tid`),
  ADD KEY `eid` (`eid`),
  ADD KEY `csd` (`csd`);

--
-- Indexes for table `geopos_purchase_items`
--
ALTER TABLE `geopos_purchase_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice` (`tid`);

--
-- Indexes for table `geopos_quotes`
--
ALTER TABLE `geopos_quotes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice` (`tid`),
  ADD KEY `eid` (`eid`),
  ADD KEY `csd` (`csd`);

--
-- Indexes for table `geopos_quotes_items`
--
ALTER TABLE `geopos_quotes_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice` (`tid`);

--
-- Indexes for table `geopos_register`
--
ALTER TABLE `geopos_register`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `geopos_reports`
--
ALTER TABLE `geopos_reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_restkeys`
--
ALTER TABLE `geopos_restkeys`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_smtp`
--
ALTER TABLE `geopos_smtp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_stock_r`
--
ALTER TABLE `geopos_stock_r`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice` (`tid`),
  ADD KEY `eid` (`eid`),
  ADD KEY `csd` (`csd`);

--
-- Indexes for table `geopos_stock_r_items`
--
ALTER TABLE `geopos_stock_r_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice` (`tid`) KEY_BLOCK_SIZE=1024 USING BTREE;

--
-- Indexes for table `geopos_supplier`
--
ALTER TABLE `geopos_supplier`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gid` (`gid`);

--
-- Indexes for table `geopos_system`
--
ALTER TABLE `geopos_system`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_terms`
--
ALTER TABLE `geopos_terms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_tickets`
--
ALTER TABLE `geopos_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_tickets_th`
--
ALTER TABLE `geopos_tickets_th`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tid` (`tid`),
  ADD KEY `cid` (`cid`),
  ADD KEY `eid` (`eid`);

--
-- Indexes for table `geopos_todolist`
--
ALTER TABLE `geopos_todolist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_transactions`
--
ALTER TABLE `geopos_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loc` (`loc`),
  ADD KEY `acid` (`acid`),
  ADD KEY `eid` (`eid`),
  ADD KEY `tid` (`tid`);

--
-- Indexes for table `geopos_trans_cat`
--
ALTER TABLE `geopos_trans_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_units`
--
ALTER TABLE `geopos_units`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `geopos_users`
--
ALTER TABLE `geopos_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email` (`email`),
  ADD KEY `username` (`username`);

--
-- Indexes for table `geopos_warehouse`
--
ALTER TABLE `geopos_warehouse`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `univarsal_api`
--
ALTER TABLE `univarsal_api`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`users_id`),
  ADD KEY `code` (`code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `geopos_accounts`
--
ALTER TABLE `geopos_accounts`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `geopos_attendance`
--
ALTER TABLE `geopos_attendance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_bank_ac`
--
ALTER TABLE `geopos_bank_ac`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_config`
--
ALTER TABLE `geopos_config`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_currencies`
--
ALTER TABLE `geopos_currencies`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `geopos_customers`
--
ALTER TABLE `geopos_customers`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `geopos_custom_data`
--
ALTER TABLE `geopos_custom_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_custom_fields`
--
ALTER TABLE `geopos_custom_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_cust_group`
--
ALTER TABLE `geopos_cust_group`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `geopos_documents`
--
ALTER TABLE `geopos_documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_draft`
--
ALTER TABLE `geopos_draft`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_draft_items`
--
ALTER TABLE `geopos_draft_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_employees`
--
ALTER TABLE `geopos_employees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `geopos_events`
--
ALTER TABLE `geopos_events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_gateways`
--
ALTER TABLE `geopos_gateways`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `geopos_hrm`
--
ALTER TABLE `geopos_hrm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_invoices`
--
ALTER TABLE `geopos_invoices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `geopos_invoice_items`
--
ALTER TABLE `geopos_invoice_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `geopos_locations`
--
ALTER TABLE `geopos_locations`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_log`
--
ALTER TABLE `geopos_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `geopos_login_attempts`
--
ALTER TABLE `geopos_login_attempts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `geopos_metadata`
--
ALTER TABLE `geopos_metadata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `geopos_milestones`
--
ALTER TABLE `geopos_milestones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_movers`
--
ALTER TABLE `geopos_movers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `geopos_notes`
--
ALTER TABLE `geopos_notes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_pms`
--
ALTER TABLE `geopos_pms`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_premissions`
--
ALTER TABLE `geopos_premissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `geopos_products`
--
ALTER TABLE `geopos_products`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `geopos_product_cat`
--
ALTER TABLE `geopos_product_cat`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `geopos_product_serials`
--
ALTER TABLE `geopos_product_serials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_projects`
--
ALTER TABLE `geopos_projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_project_meta`
--
ALTER TABLE `geopos_project_meta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_promo`
--
ALTER TABLE `geopos_promo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_purchase`
--
ALTER TABLE `geopos_purchase`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_purchase_items`
--
ALTER TABLE `geopos_purchase_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_quotes`
--
ALTER TABLE `geopos_quotes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_quotes_items`
--
ALTER TABLE `geopos_quotes_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_register`
--
ALTER TABLE `geopos_register`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `geopos_reports`
--
ALTER TABLE `geopos_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_restkeys`
--
ALTER TABLE `geopos_restkeys`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_stock_r`
--
ALTER TABLE `geopos_stock_r`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_stock_r_items`
--
ALTER TABLE `geopos_stock_r_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_supplier`
--
ALTER TABLE `geopos_supplier`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_terms`
--
ALTER TABLE `geopos_terms`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `geopos_tickets`
--
ALTER TABLE `geopos_tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_tickets_th`
--
ALTER TABLE `geopos_tickets_th`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_todolist`
--
ALTER TABLE `geopos_todolist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_transactions`
--
ALTER TABLE `geopos_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `geopos_trans_cat`
--
ALTER TABLE `geopos_trans_cat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `geopos_units`
--
ALTER TABLE `geopos_units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `geopos_users`
--
ALTER TABLE `geopos_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `geopos_warehouse`
--
ALTER TABLE `geopos_warehouse`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `univarsal_api`
--
ALTER TABLE `univarsal_api`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `users_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;