-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `aicodestudio_billing`
--

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

--
-- Table structure for table `aauth_login_attempts`
--

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

--
-- Dumping data for table `aauth_login_attempts`
--

INSERT INTO `aauth_login_attempts` (`id`, `ip_address`, `timestamp`, `login_attempts`) VALUES
(7, '172.71.81.78', '2025-02-20 08:56:14', 2),
(19, '108.162.226.79', '2025-03-12 11:26:19', 1),
(21, '162.158.192.163', '2025-04-09 17:30:59', 1),
(25, '162.158.26.156', '2025-10-18 13:32:15', 2);

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

--
-- Table structure for table `aauth_pms`
--

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

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

--
-- Table structure for table `aauth_users`
--

CREATE TABLE `aauth_users` (
  `id` int 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 NOT NULL,
  `picture` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aauth_users`
--

INSERT INTO `aauth_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`) VALUES
(8, 'ku34r4n@gmail.com', '773b3ac6b8c810bf5e45425831ef737ec673272f1b2e69e8c18d0b7d1990a396', 'admin', 0, '2025-10-18 13:33:09', '2025-10-18 13:33:09', '2025-02-19 23:51:15', NULL, NULL, NULL, '8bde5549c1759a028a732de8b866604eda7210c5', NULL, '162.158.26.157', 5, 'example.png'),
(9, 'harris@inceif.edu.my', 'cad5d067e32347d970f163d9716b41a5f4e48e7bbe8738b28d8d486d7be06be9', 'harris', 0, NULL, NULL, '2025-02-20 08:46:42', NULL, NULL, NULL, NULL, NULL, NULL, 3, 'example.png');

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

--
-- Table structure for table `aauth_user_variables`
--

CREATE TABLE `aauth_user_variables` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `data_key` varchar(100) NOT NULL,
  `value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `acn`, `holder`, `adate`, `lastbal`, `code`) VALUES
(1, '107096130110', 'MayBank Berhad', '2018-01-01 00:00:00', 5124.11, 'Company Sales Account');

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

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `key` varchar(40) DEFAULT NULL,
  `level` int 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=utf8mb3;

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

--
-- Table structure for table `app_system`
--

CREATE TABLE `app_system` (
  `id` int 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(30) NOT NULL,
  `taxid` varchar(20) NOT NULL,
  `tax` int NOT NULL,
  `currency` varchar(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_swedish_ci NOT NULL,
  `currency_format` int NOT NULL,
  `prefix` varchar(5) NOT NULL,
  `dformat` int NOT NULL,
  `zone` varchar(25) NOT NULL,
  `logo` varchar(30) NOT NULL,
  `lang` varchar(20) DEFAULT 'english'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `app_system`
--

INSERT INTO `app_system` (`id`, `cname`, `address`, `city`, `region`, `country`, `postbox`, `phone`, `email`, `taxid`, `tax`, `currency`, `currency_format`, `prefix`, `dformat`, `zone`, `logo`, `lang`) VALUES
(1, 'AiCodeStudio', 'Dataran Hamodal Blok A, Tingkat 5 Jalan Bersatu 13/4, Seksyen 13', 'Petaling Jaya', 'Selangor', 'Malaysia', '46200', '01121156329', 'admin@aicodestudio.net', '', 1, 'MYR', 0, 'INV', 1, 'Asia/Kuala_Lumpur', '17400102532082868299.png', 'english');

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

--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` int 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=utf8mb3;

--
-- Dumping data for table `bank_accounts`
--

INSERT INTO `bank_accounts` (`id`, `name`, `bank`, `acn`, `code`, `note`, `address`, `branch`, `enable`) VALUES
(1, 'Adam Harris Bin Suppuramany', '', '107096130110', 'MBBEMYKLXXX', 'MALAYAN BANKING BERHAD (MAYBANK)', 'Jalan University A', 'No 1 Jalan Equine 1B Taman Equine 43300 Seri Kembangan ', 'Yes');

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

--
-- Table structure for table `billing_terms`
--

CREATE TABLE `billing_terms` (
  `id` int NOT NULL,
  `title` varchar(100) NOT NULL,
  `type` int NOT NULL,
  `terms` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `billing_terms`
--

INSERT INTO `billing_terms` (`id`, `title`, `type`, `terms`) VALUES
(1, 'Payment on receipt', 0, 'Payment due on receipt');

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

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

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

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

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('000fb66ec9f650a6046cd3e1cfc7c0de00d1bcc2', '172.71.81.62', 1740025728, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032353732383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('05200c465b620019966eab740cb77235f752acb3', '172.70.142.117', 1745477029, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734353437373032393b),
('05737a03c7eee395f82bbee2fff9813ca649d3e7', '172.71.154.10', 1740033366, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033333336363b),
('072fdb9e1f0c790bdb3fc42a3ec096558313e09f', '162.158.26.184', 1763876796, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736333837363739363b),
('08271ef1d9b851e52d74509261daa41fffc039ae', '172.71.81.29', 1740018295, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031383239353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('0a33c4ce3049ca817d59f568277b96fc3999964d', '172.71.124.196', 1740114100, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303131343130303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('0c44e6080b202b906617ceb148cd6365656fd18d', '172.71.81.61', 1740027797, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032373739373b),
('109f69e142574907e09900eec19d40c5d2367215', '172.69.85.138', 1740012287, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031323238373b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('123c1b6d81b94ce5cd575745040c753cce904282', '172.71.81.219', 1740035655, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033353635353b),
('127f96be6d825117e80a2e37f2f01033ff8260c1', '172.71.81.61', 1740028265, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032383236353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('12dea78f62bc9f9a6587fadd60800de419a89ac4', '172.71.81.61', 1740030078, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033303037383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('15103408f2868ba483cc9f302bf2f165ead106a8', '172.71.81.10', 1740014332, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031343333323b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('16447b4a3d0fabe28f10f59b032733e9c0ce6fd2', '172.69.22.33', 1740224596, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303232343539363b),
('1dcd85f9d21b7d4a413759767b0b5bf21eeaa5cf', '172.71.81.62', 1740026460, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032363436303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('27badced1b2910867cbc3919342ae068841b9ae0', '172.71.81.175', 1740026993, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032363835303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('27c3bcb30732fc796732ec5de4041705b7d75254', '162.158.192.174', 1740031964, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033313936343b),
('286dd2c36a5bc87f439e204343e29e7666c83217', '172.71.82.109', 1740015930, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031353933303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('30a2fd94cffd3878513e74e32e43a571433c4604', '172.71.81.78', 1740013587, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031333538373b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('312193612b67b0665da00d8b547f1075e627f675', '172.71.81.30', 1740017640, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031373634303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('31dc1b41b7e4d058488d99912cc4201dd6a0d821', '172.71.81.61', 1740014677, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031343637373b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('31f5b4173fa8b09d56f1817861476cdc4423f23a', '172.71.81.61', 1740028724, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032383732343b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('35f97770eb04c28fd53a7ac907621dd8adc517c7', '162.158.163.134', 1756362353, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735363336323335333b),
('3905a7342c71bc7b171126e8cf8ea44467badc79', '108.162.227.16', 1751952988, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735313935323938383b),
('39927fab63e432b6ce36d22780496d466c0de4e7', '162.158.192.157', 1741082434, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313038323433343b),
('3f748bcbcf20c98719ec798d5a409a47b647eea5', '162.158.26.157', 1758240276, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735383234303237353b),
('41142c1e69ee6fd9e61d227f82582e1bc4930304', '172.69.194.252', 1742174844, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137343834343b),
('43c8f881fc9929205285372b3078cd7efb9753c5', '172.71.81.29', 1740017945, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031373934353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('4474af15a6d6eb58d1ea432d317eca52b645052f', '108.162.226.198', 1747608171, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373630383137313b),
('45352a7591aef2bb931ab4f8577cd7a44f4b164a', '172.69.85.138', 1740020418, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032303431383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('46f01a177d0eeebb43d1ab1430bc50d94abbd8ce', '172.70.143.139', 1754523575, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735343532333537353b),
('48e67ac7f727e2e252d7f4b6ae054adf61de8afb', '162.158.163.174', 1749429592, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734393432393539323b),
('4aaa3c1cc270635c63d0e4dcdc97eac756b1e44a', '172.71.81.61', 1740027206, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032373230363b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('4adb975a763afe37f98da8fe56d5cc6fb2bdf510', '162.158.192.169', 1741941395, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313934313339353b),
('527fad7f6d3902de3a9c2352dbea7051fc61c2a1', '172.69.85.138', 1740009415, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303030393431353b),
('565ee5040ae04383e6e4dc652c37daf43811596c', '162.158.192.163', 1741998847, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313939383834363b),
('59977f7da5c285975b549e9819fb6d06e32ffe61', '162.158.192.157', 1742171531, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137313533313b),
('5a2884b8285ef71a264885eb07d8030fd647984b', '172.71.178.59', 1742177861, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137373836303b),
('5cfc484e8059ef8226fe62d0e29f8d610a794da6', '172.71.124.19', 1740119705, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303131393730353b),
('5d2f64b61fb00414db94be71904d5afa32d0183a', '172.71.26.88', 1742175400, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137353430303b),
('5d4b6a0ead655e0a15d00e665dc92a619b5b8a91', '172.71.81.61', 1740015141, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031353134313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('61cfebde310b0fe0cbae540022e44c7040747400', '172.70.86.235', 1742177860, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137373836303b),
('648819701e43d95288e89e6291a80da81ed40289', '172.70.92.155', 1751850072, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735313835303037323b),
('6757de27cdba1066ce76922f600c923153287c32', '162.158.88.128', 1764292040, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736343239323034303b),
('67a4330cfbd250dcfdf1868f17f3664cd8411c92', '172.71.81.61', 1740026068, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032363036383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('6817996ea8744122ffcaa7f2705608626ef1ba1b', '162.158.26.184', 1763869688, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736333836393638383b),
('694323ebe2ff9b70e722927257964ea1b552177f', '162.158.189.136', 1741068272, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313036383237323b),
('69fb4c1f4307648227adbe0d5e1f797f6be543f5', '104.23.175.46', 1756722584, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735363732323538343b),
('6b4dd29e1c3d72ba6ee59e5ee6a3d2b36d223f1b', '172.71.81.77', 1740013261, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031333236313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('6b8b2f2d147ae53632298b5b21c2bd5e7afdb78e', '172.71.124.217', 1741749979, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313734393937393b),
('6e6a9f3646d2f334f269377c09cb6a26a3e4af58', '172.69.85.139', 1740012741, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031323734313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('70996dffacd12f21c85bddcb23d87bfed2c668e3', '162.158.162.60', 1741736487, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313733363438373b),
('70e904ac889562a1029e2ff77a390cb175baed37', '162.158.26.51', 1747449414, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373434393431343b),
('7214052d9694e40d28f6077c4dc54bddfba0fbf6', '162.158.26.157', 1760852614, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303835323631323b),
('748ae6a2bd4ae3d2ef63c710b59f2f4daf6367b8', '172.69.85.137', 1740023140, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032333134303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('74bb126aef2399b1ec188e3f0713eb5e16f0b481', '162.158.163.214', 1755503905, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735353530333930343b),
('74c3a4b0ffd52571f5616e1a4322c740e2870adc', '162.158.26.184', 1751277657, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735313237373635373b),
('77186aef2c82ddc6a25610bc622d80edbf90fe59', '162.158.26.157', 1760766229, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303736363232393b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('791a1996b60e88e6f73095a692f7f108417e1c73', '172.68.225.146', 1740054680, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303035343637343b),
('7adcafddbfb5f95609b5554ae099db55d2ceb5a3', '172.71.215.74', 1740054674, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303035343637343b),
('7cc624f771083ab79a72dd069036b40be3bd44cc', '172.71.81.167', 1740031785, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033313738353b),
('7dd1ac10da7739a0dfee22b9360737eb3450cbb2', '172.70.147.192', 1764889287, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736343838393238373b),
('7edeea899e8a021a349e0f96a100e2ae19ead746', '172.71.135.90', 1740224605, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303232343630353b),
('7fb3802daaba54ba204894f0248258af73f59106', '162.158.26.156', 1760766731, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303736363535333b),
('7ffc9e2e91030f943c45cf8c6535a1fda09dfc97', '172.71.124.196', 1740119469, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303131393436393b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('81dd13f0b0785b8c8e6fef593d6abfdbd2ab0c10', '172.71.81.8', 1740014004, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031343030343b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('8382061e077efcc0332ffbf8e477b1988a56a9d3', '172.69.85.139', 1740013602, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031333630323b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('84ffca7e309c4e4448bff6ea9be08c469f782fa6', '108.162.226.79', 1741749979, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313734393937393b),
('86e937888c39b0bfbf2a086ca367a0c503ed5e86', '162.158.26.156', 1760766449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303736363434393b),
('8921eb2b3d0d2c3ab8400c872eea4f5970b80423', '162.158.162.190', 1755844701, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735353834343730313b),
('8ac4e4ff17e4a20c4969bdfd633ae2a17f1df465', '172.71.81.62', 1740030521, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033303532313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('8b549111d123e326b158fc57b7ab0953c8ba9766', '162.158.106.130', 1740117413, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303131373431333b),
('8ca229192a910471dbddbe5418637f5c5ee83b4d', '172.71.152.82', 1753156240, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735333135363234303b),
('8d8782a2f3ee2221b5a24b1d04b6b9f2cc479bcb', '172.71.81.29', 1740016788, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031363738383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('8ebaec0db41c2fd00d539ef98efe38b60dacf263', '162.158.192.163', 1744191076, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343139313035313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('8f577068b1003a47291fc1d0b6536886ab8beec1', '162.158.167.51', 1740034566, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033343534323b),
('904c4e5929e3c91f086d96b031d1e7c34462af07', '172.71.124.38', 1753664478, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735333636343437383b),
('936a005b7ad446d8c7a73b7dc026488ac18b411a', '172.71.81.61', 1740029421, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032393432313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('93f629a55d7b7c3befa2dc3e799ff159a9c2f228', '162.158.192.168', 1741941389, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734313934313338393b),
('9585f947f137fdcfb53f7c991092e6a3fc8ee7a9', '108.162.227.105', 1747349080, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373334393038303b),
('960fb146dbe5e7dc56373fa9a02deb4f529a8e47', '172.69.43.148', 1742175469, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323137353436393b),
('9822b8fff91deafa95d2a5a5cb8568d3a6264d55', '172.71.82.105', 1740026974, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032363937343b),
('9a3e02c8d84ea53a5a12382266026013aba05003', '172.69.85.137', 1740022278, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032323237383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('9b5822fb03fef61f62eae432f42ac4853a74e923', '162.158.26.156', 1760867124, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303836373132343b),
('9bc6094ad3ec639c0227af298d68c2483509f2e8', '162.158.26.156', 1760851981, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303835313933343b),
('9f6ae35661781d76da21c91056cdcef22a33c7c6', '162.158.26.156', 1760847607, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303834373630373b),
('a09168769fedb4a9f7c7e8d46b178b9d0e64e28a', '162.158.26.156', 1760847588, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736303834373538383b),
('a2addb766dd4fa2eec7ff2fe3fe0353b54164df1', '172.69.85.138', 1740010036, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031303033363b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('a2c814f5d8ee895d2ab3c57b59b43f8cbc946894', '172.71.81.62', 1740029105, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032393130353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('a2e689155ebbce13f550ef395c2688d03c20b687', '172.68.164.128', 1744258475, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734343235383437353b),
('a30b8eed377bdc9498a6b49f5492ff6e2530707b', '172.71.81.167', 1740021968, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032313936383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('a3fb58a7c91181dac0d6796c21d6d78affe1b162', '162.158.26.156', 1763446406, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736333434363430363b),
('a40508db0929defa3e6cd65d90e302a8dcadfeff', '172.69.85.140', 1740025024, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032353032343b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('a55dcee799c334420b2cd471670d7b974f363489', '162.158.162.124', 1768180449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736383138303434393b),
('a787da9c12ee656d0c1df642a64ab711f628193f', '162.158.26.184', 1763876796, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736333837363739363b),
('a83f530b9459ed11fcc5910be47d627747d89b73', '162.158.26.90', 1747448690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373434383639303b),
('a8f588beb56a1b451cf5240a3290c15fb2fceaf1', '172.69.176.3', 1740038796, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033383739363b),
('a9271ca15db4d8521905dd841b1718122a17c996', '172.71.82.108', 1740015449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031353434393b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('a9ca43a35c3a7a081b69da3162534e0bd81d429c', '172.69.85.139', 1740011970, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031313937303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('aa87c79d7dbda8aa5f9fcbc666d5826f04775db0', '172.69.85.138', 1740010350, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031303335303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('ace973f6481cbbfde9ced30eb57a487325365ec8', '172.71.81.61', 1740029754, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032393735343b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('aed106d10d6af61b1ad6e217a0085689ca2b794e', '172.69.85.137', 1740022802, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032323830323b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('b7b89f8e4d82c6bbf2431987e6d7f9e4530e7480', '172.71.81.126', 1740030827, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033303832373b),
('b87c375430e2f8a9d671dc9445772287a05b7570', '172.69.176.97', 1751594530, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735313539343533303b),
('b893e5323f422559d1497599d04c6df71c398d62', '172.69.85.138', 1740011477, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031313437373b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('bfdbd65377772f2ef9d80c9fb357c6b38e5a81e0', '162.158.26.185', 1763871823, 0x5f5f63695f6c6173745f726567656e65726174657c693a313736333837313832333b),
('c1ac50be0887d611d89ac47f3b86e1bd5e183719', '172.71.81.62', 1740025365, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032353336353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('c24517acd6fbad6a630cd7dbca784e48446684f0', '172.69.85.136', 1740035502, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033353530323b),
('c73f3a9c00a4b99f41aab8ccd56fd03788f254d1', '172.69.85.141', 1740024686, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032343638363b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('c8ecd56334f464c3aa18a2b29349ab9c1cdc9ac8', '172.69.85.138', 1740032098, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033323034333b),
('ca93ce75c801117451fb9cb32a1be1e0eb010133', '172.69.85.137', 1740023945, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032333934353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('cab0494d9adaf1c26e7bc65187f52d1e314200fd', '172.71.81.62', 1740026822, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303032363832323b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('cf77c06fb088e6a5054e374844f204c3c3e913e8', '172.71.81.29', 1740018738, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031383733383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('d116e5456f3ed08301fd6db8dc2a8241c349a1e2', '172.69.85.141', 1740031832, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033313833323b),
('d402693ab75a4e82739a888460cfa79b3ebed8b6', '162.158.26.119', 1747448596, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373434383537303b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('d46f3a12d1360828af59766a50813f3139331c6a', '172.71.81.61', 1740030881, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033303838313b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('d7c601d8662a1dd7dcffcfe71229493dea930c4f', '172.71.81.30', 1740019507, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031393530373b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('d8af1f975f525c5beaeb913f14da0e3e0490777d', '172.71.154.253', 1740113166, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303131333136333b),
('d946044a8b26d0930f8322c53724421decc2f223', '172.69.176.151', 1742870042, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734323837303034323b),
('daf28cbb956e4537f2b06c4e63f16c26fb1fa8e9', '162.158.26.90', 1747492092, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734373439323034393b),
('dbf11e14e202d7c77ae10cae7b7a0bbdc7a46b91', '172.69.85.140', 1740009717, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303030393730353b),
('de3e6b86d197afe33f9ac0ebf1c65ffce9d129b5', '172.69.85.139', 1740009725, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303030393732353b),
('dkrjgs4tcb0ad1cmsajohb7kki92qf3p', '::1', 1655184289, 0x5f5f63695f6c6173745f726567656e65726174657c693a313635353138343235353b69647c733a313a2237223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31353a2261646d696e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('e72db6e4ec022e8b9522bcd9f58b4487e26a2f30', '172.69.85.139', 1740011078, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031313037383b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('ebc675f51b81ff73fb49ec08ff68b5190e1590fb', '162.158.189.38', 1752125254, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735323132353235343b),
('ebcffc1c33bf9584a3780a94b0e11a35bd872346', '172.71.81.62', 1740031729, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033313732393b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('edbe265e21414541726eb9b24f85cd7254756755', '162.158.108.86', 1751244046, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735313234343034363b),
('f193f47b9afc4e55354e97128ac4c24445cdec66', '172.71.154.121', 1740034542, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033343534323b),
('f3a924e6c0877052ab270a7fcd843022c0a49e15', '172.71.82.108', 1740016486, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031363438363b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('fa07c3d35dc5f02a8fda587600b4092116a2c413', '162.158.108.121', 1750900574, 0x5f5f63695f6c6173745f726567656e65726174657c693a313735303930303537343b),
('fc8706d29e252bde31497e8913c00b0188fea731', '172.71.81.61', 1740031193, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303033313139333b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('ff5a231d69f3e075b9502e959b910147be3bb32f', '172.71.81.29', 1740017286, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031373238363b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('ff7511d97543c46b43c6ec0a07daf9323b9b125b', '172.69.85.138', 1740010665, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734303031303636353b69647c733a313a2238223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a31373a226b75333472346e40676d61696c2e636f6d223b6c6f67676564696e7c623a313b),
('ff953833ceba837746fd2cac17187bd950a31b99', '162.158.26.59', 1749098262, 0x5f5f63695f6c6173745f726567656e65726174657c693a313734393039383236323b);

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

--
-- Table structure for table `conf`
--

CREATE TABLE `conf` (
  `id` int NOT NULL DEFAULT '1',
  `bank` int NOT NULL,
  `acid` int NOT NULL,
  `ext1` varchar(255) DEFAULT NULL,
  `ext2` varchar(255) DEFAULT NULL,
  `recaptcha_p` varchar(255) DEFAULT NULL,
  `captcha` int NOT NULL,
  `recaptcha_s` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `conf`
--

INSERT INTO `conf` (`id`, `bank`, `acid`, `ext1`, `ext2`, `recaptcha_p`, `captcha`, `recaptcha_s`) VALUES
(1, 1, 1, 'ltr', '0', '0', 0, '0');

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

--
-- Table structure for table `corn_job`
--

CREATE TABLE `corn_job` (
  `id` int NOT NULL,
  `cornkey` varchar(50) NOT NULL,
  `rec_email` int DEFAULT NULL,
  `email` int DEFAULT NULL,
  `rec_due` int DEFAULT NULL,
  `recemail` varchar(60) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `corn_job`
--

INSERT INTO `corn_job` (`id`, `cornkey`, `rec_email`, `email`, `rec_due`, `recemail`) VALUES
(1, '345648', 0, 0, 0, '0');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int NOT NULL,
  `code` varchar(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `symbol` varchar(3) DEFAULT NULL,
  `rate` decimal(10,3) NOT NULL,
  `thous` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dpoint` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `decim` int NOT NULL,
  `cpos` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `code`, `symbol`, `rate`, `thous`, `dpoint`, `decim`, `cpos`) VALUES
(1, 'MYR', 'RM', 1.000, ',', '.', 2, 0);

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int 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 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` float(16,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `customers`
--

INSERT INTO `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`) VALUES
(1, 'The Nahrayn Sdn Bhd', '0192270989', 'Lot 1606 Kampung Menderang,', 'Sungkai', 'Perak', 'Malaysia', '35600', 'admin@thenahrayn.com', 'example.png', 1, 'The Nahrayn Sdn Bhd', '', '', '', '', '', '', '', '', '', 0.00),
(2, 'Nikmat Mujur Sdn Bhd', '0351210873', 'Lot 1954, Brm 11, Jalan Sungai Pelubung 32/14 Off ', 'Bukit Kemuning', 'Shah Alam Selangor', 'Malaysia', '42450', 'admin@nikmatmujur.com.my', 'example.png', 1, 'Nikmat Mujur Sdn Bhd', '', '', '', '', '', '', '', '', '', 0.00);

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

--
-- Table structure for table `customers_group`
--

CREATE TABLE `customers_group` (
  `id` int NOT NULL,
  `title` varchar(60) DEFAULT NULL,
  `summary` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `customers_group`
--

INSERT INTO `customers_group` (`id`, `title`, `summary`) VALUES
(1, 'Default Group', 'Default Group');

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `filename` varchar(50) DEFAULT NULL,
  `cdate` date NOT NULL,
  `permission` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `employee_profile`
--

CREATE TABLE `employee_profile` (
  `id` int 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `employee_profile`
--

INSERT INTO `employee_profile` (`id`, `username`, `name`, `address`, `city`, `region`, `country`, `postbox`, `phone`, `phonealt`, `picture`, `sign`) VALUES
(8, 'admin', 'Adam Harris bin Suppuramany', 'Test Street', 'Test City', 'Test Region', 'Test Country', '123456', '12345678', '0', 'example.png', 'sign-v1.png'),
(9, 'harris', 'Adam Harris bin Suppuramany', '', '', '', '', '', '', NULL, 'example.png', 'sign.png');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int 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 NOT NULL DEFAULT '0',
  `rid` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `goals`
--

CREATE TABLE `goals` (
  `id` int NOT NULL,
  `income` bigint NOT NULL,
  `expense` bigint NOT NULL,
  `sales` bigint NOT NULL,
  `netincome` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `goals`
--

INSERT INTO `goals` (`id`, `income`, `expense`, `sales`, `netincome`) VALUES
(1, 9999, 3333, 99999, 100000);

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `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 NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` int NOT NULL,
  `taxstatus` enum('yes','no') 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 NOT NULL,
  `multi` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`id`, `tid`, `invoicedate`, `invoiceduedate`, `subtotal`, `shipping`, `discount`, `tax`, `total`, `pmethod`, `notes`, `status`, `csd`, `eid`, `pamnt`, `items`, `taxstatus`, `discstatus`, `format_discount`, `refer`, `term`, `multi`) VALUES
(1, 1215, '2025-02-20', '2025-03-31', 5315.11, 0.00, 0.00, 0.00, 5315.11, 'Bank', '', 'partial', 1, 8, 4624.11, 0, 'yes', 1, '%', '', 1, 0),
(2, 1216, '2025-02-20', '2025-03-15', 500.00, 0.00, 0.00, 0.00, 500.00, 'Bank', ' This invoice covers only support and maintenance for the existing developed website. Any new enhancements or additional features will be quoted and charged separately.', 'paid', 2, 8, 500.00, 0, 'yes', 1, '%', '', 1, 0);

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

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `pid` int NOT NULL DEFAULT '0',
  `product` varchar(255) DEFAULT NULL,
  `qty` int NOT NULL DEFAULT '0',
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` (`id`, `tid`, `pid`, `product`, `qty`, `price`, `tax`, `discount`, `subtotal`, `totaltax`, `totaldiscount`, `product_des`) VALUES
(36, 1216, 0, 'Website Support & Maintenance (2 Year Term 2025 - 2027)', 1, 500.00, 0.00, 0.00, 500.00, 0.00, 0.00, '1. Bug Fixes & Security Updates<br>\r\n2. Content Updates (if required)<br>\r\n3. Performance Monitoring<br>\r\n4. Technical Assistance & Troubleshooting<br>'),
(37, 1215, 0, 'The Nahrayn Web Development', 1, 5000.00, 0.00, 0.00, 5000.00, 0.00, 0.00, '1. UI/UX Design<br>\r\n2. Front-End Development<br>\r\n3. Back-End Development<br>\r\n4. PayHalal Integration<br>\r\n5. Testing & Debugging<br>\r\n6. Domain & Email Configurations<br>\r\n7. Social Media and SEO Integration<br>\r\n8. Deployment & Maintenance<br>\r\n9. Service Support (6 Month)'),
(38, 1215, 0, 'Domain Purchase (2 Years Term) April 2024 - April 2026', 1, 124.11, 0.00, 0.00, 124.11, 0.00, 0.00, ''),
(39, 1215, 0, 'Web Server (10GB 1 Year Term) Feb 2025 to Feb 2026', 1, 191.00, 0.00, 0.00, 191.00, 0.00, 0.00, '');

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

--
-- Table structure for table `meta_data`
--

CREATE TABLE `meta_data` (
  `id` int NOT NULL,
  `type` int NOT NULL,
  `rid` int NOT NULL,
  `col1` varchar(255) NOT NULL,
  `col2` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_data`
--

INSERT INTO `meta_data` (`id`, `type`, `rid`, `col1`, `col2`) VALUES
(2, 1, 1215, '8472232024-04-23M2UMaybank.pdf', ''),
(3, 1, 1215, '3834562024-04-232024-001MYR1500PaymentVouchertoAdamHarris.pdf', ''),
(4, 1, 1215, '806006DomainPurchase.pdf', ''),
(5, 1, 1215, '300238JomhostingInvoice121286.pdf', ''),
(6, 1, 1215, '4713602025-02-21M2UtoAdamAiCodeStudioRM1.5k.pdf', ''),
(7, 1, 1216, '244630NMSBPAYMENTWEBSITEENHARRISDD14032025.pdf', ''),
(8, 1, 1215, '6039902025-05-17M2UtoAdamHarisAicodeStudioRM1500.pdf', '');

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

--
-- Table structure for table `milestones`
--

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

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text,
  `cdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `online_payment`
--

CREATE TABLE `online_payment` (
  `id` int NOT NULL,
  `default_acid` int NOT NULL DEFAULT '1',
  `currency_code` varchar(3) NOT NULL,
  `enable` int NOT NULL,
  `bank` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `online_payment`
--

INSERT INTO `online_payment` (`id`, `default_acid`, `currency_code`, `enable`, `bank`) VALUES
(1, 1, 'USD', 0, 1);

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` int 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 NOT NULL,
  `surcharge` decimal(16,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `name`, `enable`, `key1`, `key2`, `currency`, `dev_mode`, `ord`, `surcharge`) VALUES
(1, 'Stripe', 'Yes', 'sk_test_secratekey', 'sk_test_publickey', 'USD', 'true', 1, 0.00),
(2, 'Authorize.Net', 'Yes', 'TRANSACTIONKEY', 'LOGINID', 'AUD', 'true', 2, 0.00),
(3, 'Pin Payments', 'Yes', 'TEST', 'none', 'AUD', 'true', 3, 0.00),
(4, 'PayPal', 'Yes', 'MyPayPalClientId', 'MyPayPalSecret', 'USD', 'true', 4, 0.00),
(5, 'SecurePay', 'Yes', 'ABC0001', 'abc123', 'AUD', 'true', 5, 0.00);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `pid` int NOT NULL,
  `pcat` int NOT NULL DEFAULT '1',
  `warehouse` int NOT NULL DEFAULT '1',
  `product_name` varchar(50) NOT NULL,
  `product_code` varchar(255) DEFAULT NULL,
  `product_price` decimal(16,2) DEFAULT '0.00',
  `fproduct_price` decimal(16,2) NOT NULL DEFAULT '0.00',
  `taxrate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `disrate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `qty` int NOT NULL,
  `product_des` text,
  `alert` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `product_cat`
--

CREATE TABLE `product_cat` (
  `id` int NOT NULL,
  `title` varchar(100) NOT NULL,
  `extra` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `product_cat`
--

INSERT INTO `product_cat` (`id`, `title`, `extra`) VALUES
(1, 'General', 'General Product Category');

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

--
-- Table structure for table `product_warehouse`
--

CREATE TABLE `product_warehouse` (
  `id` int NOT NULL,
  `title` varchar(100) NOT NULL,
  `extra` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `product_warehouse`
--

INSERT INTO `product_warehouse` (`id`, `title`, `extra`) VALUES
(1, 'Main Warehouse', 'Main Warehouse D');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int 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 NOT NULL,
  `cid` int 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 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `project_meta`
--

CREATE TABLE `project_meta` (
  `id` int NOT NULL,
  `pid` int NOT NULL,
  `meta_key` int NOT NULL,
  `meta_data` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `key3` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `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 NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` int NOT NULL,
  `taxstatus` enum('yes','no') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT NULL,
  `refer` varchar(20) DEFAULT NULL,
  `term` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `purchase_items`
--

CREATE TABLE `purchase_items` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `pid` int NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `qty` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `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') DEFAULT 'pending',
  `csd` int NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `pamnt` decimal(16,2) NOT NULL,
  `items` int NOT NULL,
  `taxstatus` enum('yes','no') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT '%',
  `refer` varchar(20) DEFAULT NULL,
  `term` int NOT NULL,
  `proposal` text,
  `multi` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `quotes_items`
--

CREATE TABLE `quotes_items` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `pid` int NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `qty` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `rec_invoices`
--

CREATE TABLE `rec_invoices` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `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 NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` int NOT NULL,
  `taxstatus` enum('yes','no') DEFAULT 'yes',
  `discstatus` tinyint(1) DEFAULT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT '%',
  `refer` varchar(20) DEFAULT NULL,
  `term` int NOT NULL,
  `rec` varchar(10) NOT NULL,
  `ron` enum('Recurring','Stopped') DEFAULT 'Recurring',
  `multi` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `rec_invoice_items`
--

CREATE TABLE `rec_invoice_items` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `pid` int NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `qty` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `reports`
--

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

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

--
-- Table structure for table `stock_return`
--

CREATE TABLE `stock_return` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `invoicedate` date NOT NULL,
  `invoiceduedate` date NOT NULL,
  `subtotal` decimal(16,2) DEFAULT '0.00',
  `shipping` decimal(16,2) DEFAULT '0.00',
  `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 NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `pamnt` decimal(16,2) DEFAULT '0.00',
  `items` int NOT NULL,
  `taxstatus` enum('yes','no') DEFAULT 'yes',
  `discstatus` tinyint(1) NOT NULL,
  `format_discount` enum('%','flat','b_p','bflat') DEFAULT NULL,
  `refer` varchar(20) DEFAULT NULL,
  `term` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `stock_return_items`
--

CREATE TABLE `stock_return_items` (
  `id` int NOT NULL,
  `tid` int NOT NULL,
  `pid` int NOT NULL,
  `product` varchar(255) DEFAULT NULL,
  `qty` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `id` int 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 NOT NULL DEFAULT '1',
  `company` varchar(100) DEFAULT NULL,
  `taxid` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `sys_smtp`
--

CREATE TABLE `sys_smtp` (
  `id` int NOT NULL,
  `host` varchar(100) NOT NULL,
  `port` int NOT NULL,
  `auth` enum('true','false') NOT NULL,
  `auth_type` enum('none','tls','ssl') NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sender` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sys_smtp`
--

INSERT INTO `sys_smtp` (`id`, `host`, `port`, `auth`, `auth_type`, `username`, `password`, `sender`) VALUES
(1, 'smtp-relay.brevo.com', 587, 'true', 'tls', '85e886001@smtp-brevo.com', 'xsmtpsib-17fac0f022da8790b6f56c1ff95c491df6626bd58607f847f84a1ee39383aa0f-8ELb9BSyMw0zK5jO', 'admin@aicodestudio.net');

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

--
-- Table structure for table `tickets`
--

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

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

--
-- Table structure for table `tickets_th`
--

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

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

--
-- Table structure for table `todolist`
--

CREATE TABLE `todolist` (
  `id` int 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 NOT NULL,
  `aid` int NOT NULL,
  `related` int NOT NULL,
  `priority` enum('Low','Medium','High','Urgent') NOT NULL,
  `rid` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `acid` int 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 NOT NULL DEFAULT '0',
  `method` varchar(200) DEFAULT NULL,
  `date` date NOT NULL,
  `tid` int NOT NULL DEFAULT '0',
  `eid` int NOT NULL,
  `note` varchar(255) DEFAULT NULL,
  `ext` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `acid`, `account`, `type`, `cat`, `debit`, `credit`, `payer`, `payerid`, `method`, `date`, `tid`, `eid`, `note`, `ext`) VALUES
(1, 1, 'Company Sales Account', 'Income', 'Sales', 0.00, 1500.00, 'Prof. Dr. Ashraf Md Hashim', 1, 'Bank', '2024-04-23', 1215, 8, 'Partial payment for web development services', 0),
(4, 1, 'Company Sales Account', 'Income', 'Sales', 0.00, 124.11, 'The Nahrayn Sdn Bhd', 1, 'Cash', '2024-04-22', 1215, 8, 'Payment for Domain Registration', 0),
(5, 1, 'MayBank Berhad', 'Income', 'Sales', 0.00, 1500.00, 'The Nahrayn Sdn Bhd', 1, 'Bank', '2025-02-21', 1215, 8, 'Payment for invoice #1215', 0),
(6, 1, 'MayBank Berhad', 'Income', 'Sales', 0.00, 500.00, 'Nikmat Mujur Sdn Bhd', 2, 'Bank', '2025-03-14', 1216, 8, 'Payment for invoice #1216', 0),
(7, 1, 'MayBank Berhad', 'Income', 'Sales', 0.00, 1500.00, 'The Nahrayn Sdn Bhd', 1, 'Bank', '2025-05-17', 1215, 8, 'Payment for invoice #1215', 0);

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

--
-- Table structure for table `transactions_cat`
--

CREATE TABLE `transactions_cat` (
  `id` int NOT NULL,
  `name` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `transactions_cat`
--

INSERT INTO `transactions_cat` (`id`, `name`) VALUES
(1, 'Sales'),
(2, 'Purchase');

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

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

CREATE TABLE `univarsal_api` (
  `id` int 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 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 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', NULL, NULL),
(5, 'Exchange', 'key1', 'key2', 'USD', NULL, NULL, 1),
(6, 'New Invoice Notification', '[{Company}] Invoice #{BillNumber} Generated', NULL, NULL, NULL, 'Dear Client,\r\nWe are contacting you in regard to a payment received for invoice # {BillNumber} that has been created on your account. You may find the invoice with below link.\r\n\r\nView Invoice\r\n{URL}\r\n\r\nWe look forward to conducting future business with you.\r\n\r\nKind Regards,\r\nTeam\r\n{CompanyDetails}', NULL),
(7, 'Invoice Payment Reminder', '[{Company}] Invoice #{BillNumber} Payment Reminder', NULL, NULL, NULL, '<p>Dear Client,</p><p>We are contacting you in regard to a payment reminder of invoice # {BillNumber} that has been created on your account. You may find the invoice with below link. Please pay the balance of {Amount} due by {DueDate}.</p><p>\r\n\r\n<b>View Invoice</b></p><p><span style=\"font-size: 1rem;\">{URL}\r\n</span></p><p><span style=\"font-size: 1rem;\">\r\nWe look forward to conducting future business with you.</span></p><p><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></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 Client,</p><p>\r\nWe are contacting you in regard to a refund request processed for invoice # {BillNumber} that has been created on your account. You may find the invoice with below link. Please pay the balance of {Amount}  by {DueDate}.\r\n</p><p>\r\nView Invoice\r\n</p><p>{URL}\r\n</p><p>\r\nWe look forward to conducting future business with you.\r\n</p><p>\r\nKind Regards,\r\n</p><p>\r\nTeam\r\n\r\n{CompanyDetails}</p>', NULL),
(9, 'Invoice payment Received', '{Company} Payment Received for Invoice #{BillNumber}', NULL, NULL, NULL, '<p>Dear Client,\r\n</p><p>We are contacting you in regard to a payment received for invoice  # {BillNumber} that has been created on your account. You can find the invoice with below link.\r\n</p><p>\r\nView Invoice</p><p>\r\n{URL}\r\n</p><p>\r\nWe look forward to conducting future business with you.\r\n</p><p>\r\nKind 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 Client,</p><p>\r\nWe are contacting you in regard to an Overdue Notice for invoice # {BillNumber} that has been created on your account. You may find the invoice with below link.\r\nPlease pay the balance of {Amount} due by {DueDate}.\r\n</p><p>View Invoice\r\n</p><p>{URL}\r\n</p><p>\r\nWe look forward to conducting future business with you.\r\n</p><p>\r\nKind Regards,\r\n</p><p>\r\nTeam</p><p>\r\n\r\n{CompanyDetails}</p>', NULL),
(11, 'Quote Proposal', '{Company} Quote #{BillNumber} Generated for you', NULL, NULL, NULL, '<p>Dear Client,</p><p>\r\nWe are contacting you in regard to a new quote # {BillNumber} that has been created on your account. You 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 to conducting future business with you.</p><p>\r\n\r\nKind Regards,</p><p>\r\n\r\nTeam</p><p>\r\n\r\n{CompanyDetails}</p>', NULL),
(12, 'Purchase Order Request', '{Company} Purchase Order #{BillNumber} Requested', NULL, NULL, NULL, '<p>Dear Client,\r\n</p><p>We are contacting you in regard to a new purchase # {BillNumber} that has been requested 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>\r\n\r\nWe look forward to conducting future business with you.</p><p>\r\n\r\nKind Regards,\r\n</p><p>\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),
(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#', 'REC#', 'SR#', 'TRN#', 'SRN#', 1);

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

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

CREATE TABLE `users` (
  `users_id` int 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 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 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`) VALUES
(1, '1', NULL, 'active', '0', 'The Nahrayn Sdn Bhd', '$2y$10$Ee2Qe3IpvvQPbelhA1SOY.rWgs7e7NWmbKoJlWjin2pZ9tFwLyvEC', 'admin@thenahrayn.com', NULL, 'Member', 1),
(2, '1', NULL, 'active', '0', 'Nikmat Mujur Sdn Bhd', '$2y$10$DGzUr7VJxcuB/QuwfTaFlOYKaDiiByU7rhgPOaP3HztO2cqXIy9vG', 'admin@nikmatmujur.com.my', NULL, 'Member', 2);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `aauth_user_variables`
--
ALTER TABLE `aauth_user_variables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_index` (`user_id`);

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

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

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

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

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

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

--
-- Indexes for table `conf`
--
ALTER TABLE `conf`
  ADD UNIQUE KEY `id_2` (`id`),
  ADD KEY `id` (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `transactions_cat`
--
ALTER TABLE `transactions_cat`
  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`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aauth_login_attempts`
--
ALTER TABLE `aauth_login_attempts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `aauth_pms`
--
ALTER TABLE `aauth_pms`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aauth_users`
--
ALTER TABLE `aauth_users`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `aauth_user_variables`
--
ALTER TABLE `aauth_user_variables`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `api_keys`
--
ALTER TABLE `api_keys`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_accounts`
--
ALTER TABLE `bank_accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `billing_terms`
--
ALTER TABLE `billing_terms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `customers_group`
--
ALTER TABLE `customers_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_profile`
--
ALTER TABLE `employee_profile`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `invoice_items`
--
ALTER TABLE `invoice_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `meta_data`
--
ALTER TABLE `meta_data`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `milestones`
--
ALTER TABLE `milestones`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `pid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_cat`
--
ALTER TABLE `product_cat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `product_warehouse`
--
ALTER TABLE `product_warehouse`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `project_meta`
--
ALTER TABLE `project_meta`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_items`
--
ALTER TABLE `purchase_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotes`
--
ALTER TABLE `quotes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotes_items`
--
ALTER TABLE `quotes_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rec_invoices`
--
ALTER TABLE `rec_invoices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rec_invoice_items`
--
ALTER TABLE `rec_invoice_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_return`
--
ALTER TABLE `stock_return`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_return_items`
--
ALTER TABLE `stock_return_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tickets_th`
--
ALTER TABLE `tickets_th`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `todolist`
--
ALTER TABLE `todolist`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `transactions_cat`
--
ALTER TABLE `transactions_cat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `univarsal_api`
--
ALTER TABLE `univarsal_api`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

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

