-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 15, 2024 at 01:55 AM
-- Server version: 8.2.0
-- PHP Version: 8.3.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `commercial`
--

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

--
-- Table structure for table `btblc`
--

DROP TABLE IF EXISTS `btblc`;
CREATE TABLE IF NOT EXISTS `btblc` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `orderId` int DEFAULT NULL,
  `orderQty` int DEFAULT NULL,
  `poNumber` varchar(50) DEFAULT NULL,
  `itemId` int DEFAULT NULL,
  `supplierId` int DEFAULT NULL,
  `orderDate` date DEFAULT NULL,
  `shipMode` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `lcApplicant` varchar(300) DEFAULT NULL,
  `lienBank` varchar(200) DEFAULT NULL,
  `payTerm` varchar(150) DEFAULT NULL,
  `benificiary` varchar(150) DEFAULT NULL,
  `shipCountryId` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `buyertable`
--

DROP TABLE IF EXISTS `buyertable`;
CREATE TABLE IF NOT EXISTS `buyertable` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `buyer_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `country_id` int NOT NULL,
  `create_date` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `update_date` date DEFAULT NULL,
  `update_by` int DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `buyertable`
--

INSERT INTO `buyertable` (`ID`, `buyer_name`, `email`, `phone`, `address`, `country_id`, `create_date`, `created_by`, `update_date`, `update_by`) VALUES
(1, 'Jone doe', 'dahukpakhi@gmail.com', '12465987', 'assfd', 10, '0000-00-00 00:00:00', 1, NULL, NULL),
(3, 'Shafiqur R', 'shafiq@gmail.com', '5236489', 'llsdojsdiof', 2, '0000-00-00 00:00:00', 1, NULL, NULL),
(4, 'Alekzandar', 'alekjandra@yahoo.com', '987654321', 'pahar, chad', 44, '0000-00-00 00:00:00', 1, '2024-09-14', 1),
(5, 'shafiq', 'shafiq@yahoo.com', '45687', 'besdfrt', 1, '0000-00-00 00:00:00', 1, NULL, NULL),
(6, 'Ashraf Siddiki', 'asraf@hotmail.com', '65248792', 'lkigiejasdf', 5, '0000-00-00 00:00:00', 1, '2024-09-14', 1);

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

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
CREATE TABLE IF NOT EXISTS `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `categoryName` varchar(100) DEFAULT NULL,
  `uom` varchar(15) DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `color`
--

DROP TABLE IF EXISTS `color`;
CREATE TABLE IF NOT EXISTS `color` (
  `id` int NOT NULL AUTO_INCREMENT,
  `colorName` varchar(100) DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `company`
--

DROP TABLE IF EXISTS `company`;
CREATE TABLE IF NOT EXISTS `company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `companyName` varchar(100) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `supplierId` int DEFAULT NULL,
  `buyerId` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
CREATE TABLE IF NOT EXISTS `country` (
  `id` int NOT NULL AUTO_INCREMENT,
  `country_name` varchar(80) NOT NULL,
  `country_code` varchar(50) NOT NULL,
  `created_at` date NOT NULL,
  `created_by` int NOT NULL,
  `update_at` date NOT NULL,
  `update_by` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `country_name`, `country_code`, `created_at`, `created_by`, `update_at`, `update_by`) VALUES
(1, 'United States', 'US', '0000-00-00', 0, '0000-00-00', 0),
(2, 'Canada', 'CA', '0000-00-00', 0, '0000-00-00', 0),
(3, 'Afghanistan', 'AF', '0000-00-00', 0, '0000-00-00', 0),
(4, 'Albania', 'AL', '0000-00-00', 0, '0000-00-00', 0),
(5, 'Algeria', 'DZ', '0000-00-00', 0, '0000-00-00', 0),
(6, 'American Samoa', 'AS', '0000-00-00', 0, '0000-00-00', 0),
(7, 'Andorra', 'AD', '0000-00-00', 0, '0000-00-00', 0),
(8, 'Angola', 'AO', '0000-00-00', 0, '0000-00-00', 0),
(9, 'Anguilla', 'AI', '0000-00-00', 0, '0000-00-00', 0),
(10, 'Antarctica', 'AQ', '0000-00-00', 0, '0000-00-00', 0),
(11, 'Antigua and/or Barbuda', 'AG', '0000-00-00', 0, '0000-00-00', 0),
(12, 'Argentina', 'AR', '0000-00-00', 0, '0000-00-00', 0),
(13, 'Armenia', 'AM', '0000-00-00', 0, '0000-00-00', 0),
(14, 'Aruba', 'AW', '0000-00-00', 0, '0000-00-00', 0),
(15, 'Australia', 'AU', '0000-00-00', 0, '0000-00-00', 0),
(16, 'Austria', 'AT', '0000-00-00', 0, '0000-00-00', 0),
(17, 'Åland Islands', 'AX', '0000-00-00', 0, '0000-00-00', 0),
(18, 'Azerbaijan', 'AZ', '0000-00-00', 0, '0000-00-00', 0),
(19, 'Bahamas', 'BS', '0000-00-00', 0, '0000-00-00', 0),
(20, 'Bahrain', 'BH', '0000-00-00', 0, '0000-00-00', 0),
(21, 'Bangladesh', 'BD', '0000-00-00', 0, '0000-00-00', 0),
(22, 'Barbados', 'BB', '0000-00-00', 0, '0000-00-00', 0),
(23, 'Belarus', 'BY', '0000-00-00', 0, '0000-00-00', 0),
(24, 'Belgium', 'BE', '0000-00-00', 0, '0000-00-00', 0),
(25, 'Belize', 'BZ', '0000-00-00', 0, '0000-00-00', 0),
(26, 'Benin', 'BJ', '0000-00-00', 0, '0000-00-00', 0),
(27, 'Bermuda', 'BM', '0000-00-00', 0, '0000-00-00', 0),
(28, 'Bhutan', 'BT', '0000-00-00', 0, '0000-00-00', 0),
(29, 'Bolivia', 'BO', '0000-00-00', 0, '0000-00-00', 0),
(30, 'Bosnia and Herzegovina', 'BA', '0000-00-00', 0, '0000-00-00', 0),
(31, 'Botswana', 'BW', '0000-00-00', 0, '0000-00-00', 0),
(32, 'Bouvet Island', 'BV', '0000-00-00', 0, '0000-00-00', 0),
(33, 'Brazil', 'BR', '0000-00-00', 0, '0000-00-00', 0),
(34, 'British lndian Ocean Territory', 'IO', '0000-00-00', 0, '0000-00-00', 0),
(35, 'Brunei Darussalam', 'BN', '0000-00-00', 0, '0000-00-00', 0),
(36, 'Bulgaria', 'BG', '0000-00-00', 0, '0000-00-00', 0),
(37, 'Burkina Faso', 'BF', '0000-00-00', 0, '0000-00-00', 0),
(38, 'Burundi', 'BI', '0000-00-00', 0, '0000-00-00', 0),
(39, 'Cambodia', 'KH', '0000-00-00', 0, '0000-00-00', 0),
(40, 'Cameroon', 'CM', '0000-00-00', 0, '0000-00-00', 0),
(41, 'Cape Verde', 'CV', '0000-00-00', 0, '0000-00-00', 0),
(42, 'Cayman Islands', 'KY', '0000-00-00', 0, '0000-00-00', 0),
(43, 'Central African Republic', 'CF', '0000-00-00', 0, '0000-00-00', 0),
(44, 'Chad', 'TD', '0000-00-00', 0, '0000-00-00', 0),
(45, 'Chile', 'CL', '0000-00-00', 0, '0000-00-00', 0),
(46, 'China', 'CN', '0000-00-00', 0, '0000-00-00', 0),
(47, 'Christmas Island', 'CX', '0000-00-00', 0, '0000-00-00', 0),
(48, 'Cocos (Keeling) Islands', 'CC', '0000-00-00', 0, '0000-00-00', 0),
(49, 'Colombia', 'CO', '0000-00-00', 0, '0000-00-00', 0),
(50, 'Comoros', 'KM', '0000-00-00', 0, '0000-00-00', 0),
(51, 'Congo', 'CG', '0000-00-00', 0, '0000-00-00', 0),
(52, 'Cook Islands', 'CK', '0000-00-00', 0, '0000-00-00', 0),
(53, 'Costa Rica', 'CR', '0000-00-00', 0, '0000-00-00', 0),
(54, 'Croatia (Hrvatska)', 'HR', '0000-00-00', 0, '0000-00-00', 0),
(55, 'Cuba', 'CU', '0000-00-00', 0, '0000-00-00', 0),
(56, 'Cyprus', 'CY', '0000-00-00', 0, '0000-00-00', 0),
(57, 'Czech Republic', 'CZ', '0000-00-00', 0, '0000-00-00', 0),
(58, 'Denmark', 'DK', '0000-00-00', 0, '0000-00-00', 0),
(59, 'Djibouti', 'DJ', '0000-00-00', 0, '0000-00-00', 0),
(60, 'Dominica', 'DM', '0000-00-00', 0, '0000-00-00', 0),
(61, 'Dominican Republic', 'DO', '0000-00-00', 0, '0000-00-00', 0),
(62, 'East Timor', 'TP', '0000-00-00', 0, '0000-00-00', 0),
(63, 'Ecuador', 'EC', '0000-00-00', 0, '0000-00-00', 0),
(64, 'Egypt', 'EG', '0000-00-00', 0, '0000-00-00', 0),
(65, 'El Salvador', 'SV', '0000-00-00', 0, '0000-00-00', 0),
(66, 'Equatorial Guinea', 'GQ', '0000-00-00', 0, '0000-00-00', 0),
(67, 'Eritrea', 'ER', '0000-00-00', 0, '0000-00-00', 0),
(68, 'Estonia', 'EE', '0000-00-00', 0, '0000-00-00', 0),
(69, 'Ethiopia', 'ET', '0000-00-00', 0, '0000-00-00', 0),
(70, 'Falkland Islands (Malvinas)', 'FK', '0000-00-00', 0, '0000-00-00', 0),
(71, 'Faroe Islands', 'FO', '0000-00-00', 0, '0000-00-00', 0),
(72, 'Fiji', 'FJ', '0000-00-00', 0, '0000-00-00', 0),
(73, 'Finland', 'FI', '0000-00-00', 0, '0000-00-00', 0),
(74, 'France', 'FR', '0000-00-00', 0, '0000-00-00', 0),
(75, 'France, Metropolitan', 'FX', '0000-00-00', 0, '0000-00-00', 0),
(76, 'French Guiana', 'GF', '0000-00-00', 0, '0000-00-00', 0),
(77, 'French Polynesia', 'PF', '0000-00-00', 0, '0000-00-00', 0),
(78, 'French Southern Territories', 'TF', '0000-00-00', 0, '0000-00-00', 0),
(79, 'Gabon', 'GA', '0000-00-00', 0, '0000-00-00', 0),
(80, 'Gambia', 'GM', '0000-00-00', 0, '0000-00-00', 0),
(81, 'Georgia', 'GE', '0000-00-00', 0, '0000-00-00', 0),
(82, 'Germany', 'DE', '0000-00-00', 0, '0000-00-00', 0),
(83, 'Ghana', 'GH', '0000-00-00', 0, '0000-00-00', 0),
(84, 'Gibraltar', 'GI', '0000-00-00', 0, '0000-00-00', 0),
(85, 'Greece', 'GR', '0000-00-00', 0, '0000-00-00', 0),
(86, 'Greenland', 'GL', '0000-00-00', 0, '0000-00-00', 0),
(87, 'Grenada', 'GD', '0000-00-00', 0, '0000-00-00', 0),
(88, 'Guadeloupe', 'GP', '0000-00-00', 0, '0000-00-00', 0),
(89, 'Guam', 'GU', '0000-00-00', 0, '0000-00-00', 0),
(90, 'Guatemala', 'GT', '0000-00-00', 0, '0000-00-00', 0),
(91, 'Guinea', 'GN', '0000-00-00', 0, '0000-00-00', 0),
(92, 'Guinea-Bissau', 'GW', '0000-00-00', 0, '0000-00-00', 0),
(93, 'Guyana', 'GY', '0000-00-00', 0, '0000-00-00', 0),
(94, 'Haiti', 'HT', '0000-00-00', 0, '0000-00-00', 0),
(95, 'Heard and Mc Donald Islands', 'HM', '0000-00-00', 0, '0000-00-00', 0),
(96, 'Honduras', 'HN', '0000-00-00', 0, '0000-00-00', 0),
(97, 'Hong Kong', 'HK', '0000-00-00', 0, '0000-00-00', 0),
(98, 'Hungary', 'HU', '0000-00-00', 0, '0000-00-00', 0),
(99, 'Iceland', 'IS', '0000-00-00', 0, '0000-00-00', 0),
(100, 'India', 'IN', '0000-00-00', 0, '0000-00-00', 0),
(101, 'Indonesia', 'ID', '0000-00-00', 0, '0000-00-00', 0),
(102, 'Iran (Islamic Republic of)', 'IR', '0000-00-00', 0, '0000-00-00', 0),
(103, 'Iraq', 'IQ', '0000-00-00', 0, '0000-00-00', 0),
(104, 'Ireland', 'IE', '0000-00-00', 0, '0000-00-00', 0),
(105, 'Israel', 'IL', '0000-00-00', 0, '0000-00-00', 0),
(106, 'Italy', 'IT', '0000-00-00', 0, '0000-00-00', 0),
(107, 'Ivory Coast', 'CI', '0000-00-00', 0, '0000-00-00', 0),
(108, 'Jamaica', 'JM', '0000-00-00', 0, '0000-00-00', 0),
(109, 'Japan', 'JP', '0000-00-00', 0, '0000-00-00', 0),
(110, 'Jordan', 'JO', '0000-00-00', 0, '0000-00-00', 0),
(111, 'Kazakhstan', 'KZ', '0000-00-00', 0, '0000-00-00', 0),
(112, 'Kenya', 'KE', '0000-00-00', 0, '0000-00-00', 0),
(113, 'Kiribati', 'KI', '0000-00-00', 0, '0000-00-00', 0),
(114, 'Korea, Democratic People\'s Republic of', 'KP', '0000-00-00', 0, '0000-00-00', 0),
(115, 'Korea, Republic of', 'KR', '0000-00-00', 0, '0000-00-00', 0),
(116, 'Kosovo', 'XK', '0000-00-00', 0, '0000-00-00', 0),
(117, 'Kuwait', 'KW', '0000-00-00', 0, '0000-00-00', 0),
(118, 'Kyrgyzstan', 'KG', '0000-00-00', 0, '0000-00-00', 0),
(119, 'Lao People\'s Democratic Republic', 'LA', '0000-00-00', 0, '0000-00-00', 0),
(120, 'Latvia', 'LV', '0000-00-00', 0, '0000-00-00', 0),
(121, 'Lebanon', 'LB', '0000-00-00', 0, '0000-00-00', 0),
(122, 'Lesotho', 'LS', '0000-00-00', 0, '0000-00-00', 0),
(123, 'Liberia', 'LR', '0000-00-00', 0, '0000-00-00', 0),
(124, 'Libyan Arab Jamahiriya', 'LY', '0000-00-00', 0, '0000-00-00', 0),
(125, 'Liechtenstein', 'LI', '0000-00-00', 0, '0000-00-00', 0),
(126, 'Lithuania', 'LT', '0000-00-00', 0, '0000-00-00', 0),
(127, 'Luxembourg', 'LU', '0000-00-00', 0, '0000-00-00', 0),
(128, 'Macau', 'MO', '0000-00-00', 0, '0000-00-00', 0),
(129, 'Macedonia', 'MK', '0000-00-00', 0, '0000-00-00', 0),
(130, 'Madagascar', 'MG', '0000-00-00', 0, '0000-00-00', 0),
(131, 'Malawi', 'MW', '0000-00-00', 0, '0000-00-00', 0),
(132, 'Malaysia', 'MY', '0000-00-00', 0, '0000-00-00', 0),
(133, 'Maldives', 'MV', '0000-00-00', 0, '0000-00-00', 0),
(134, 'Mali', 'ML', '0000-00-00', 0, '0000-00-00', 0),
(135, 'Malta', 'MT', '0000-00-00', 0, '0000-00-00', 0),
(136, 'Marshall Islands', 'MH', '0000-00-00', 0, '0000-00-00', 0),
(137, 'Martinique', 'MQ', '0000-00-00', 0, '0000-00-00', 0),
(138, 'Mauritania', 'MR', '0000-00-00', 0, '0000-00-00', 0),
(139, 'Mauritius', 'MU', '0000-00-00', 0, '0000-00-00', 0),
(140, 'Mayotte', 'TY', '0000-00-00', 0, '0000-00-00', 0),
(141, 'Mexico', 'MX', '0000-00-00', 0, '0000-00-00', 0),
(142, 'Micronesia, Federated States of', 'FM', '0000-00-00', 0, '0000-00-00', 0),
(143, 'Moldova, Republic of', 'MD', '0000-00-00', 0, '0000-00-00', 0),
(144, 'Monaco', 'MC', '0000-00-00', 0, '0000-00-00', 0),
(145, 'Mongolia', 'MN', '0000-00-00', 0, '0000-00-00', 0),
(146, 'Montenegro', 'ME', '0000-00-00', 0, '0000-00-00', 0),
(147, 'Montserrat', 'MS', '0000-00-00', 0, '0000-00-00', 0),
(148, 'Morocco', 'MA', '0000-00-00', 0, '0000-00-00', 0),
(149, 'Mozambique', 'MZ', '0000-00-00', 0, '0000-00-00', 0),
(150, 'Myanmar', 'MM', '0000-00-00', 0, '0000-00-00', 0),
(151, 'Namibia', 'NA', '0000-00-00', 0, '0000-00-00', 0),
(152, 'Nauru', 'NR', '0000-00-00', 0, '0000-00-00', 0),
(153, 'Nepal', 'NP', '0000-00-00', 0, '0000-00-00', 0),
(154, 'Netherlands', 'NL', '0000-00-00', 0, '0000-00-00', 0),
(155, 'Netherlands Antilles', 'AN', '0000-00-00', 0, '0000-00-00', 0),
(156, 'New Caledonia', 'NC', '0000-00-00', 0, '0000-00-00', 0),
(157, 'New Zealand', 'NZ', '0000-00-00', 0, '0000-00-00', 0),
(158, 'Nicaragua', 'NI', '0000-00-00', 0, '0000-00-00', 0),
(159, 'Niger', 'NE', '0000-00-00', 0, '0000-00-00', 0),
(160, 'Nigeria', 'NG', '0000-00-00', 0, '0000-00-00', 0),
(161, 'Niue', 'NU', '0000-00-00', 0, '0000-00-00', 0),
(162, 'Norfork Island', 'NF', '0000-00-00', 0, '0000-00-00', 0),
(163, 'Northern Mariana Islands', 'MP', '0000-00-00', 0, '0000-00-00', 0),
(164, 'Norway', 'NO', '0000-00-00', 0, '0000-00-00', 0),
(165, 'Oman', 'OM', '0000-00-00', 0, '0000-00-00', 0),
(166, 'Pakistan', 'PK', '0000-00-00', 0, '0000-00-00', 0),
(167, 'Palau', 'PW', '0000-00-00', 0, '0000-00-00', 0),
(168, 'Panama', 'PA', '0000-00-00', 0, '0000-00-00', 0),
(169, 'Papua New Guinea', 'PG', '0000-00-00', 0, '0000-00-00', 0),
(170, 'Paraguay', 'PY', '0000-00-00', 0, '0000-00-00', 0),
(171, 'Peru', 'PE', '0000-00-00', 0, '0000-00-00', 0),
(172, 'Philippines', 'PH', '0000-00-00', 0, '0000-00-00', 0),
(173, 'Pitcairn', 'PN', '0000-00-00', 0, '0000-00-00', 0),
(174, 'Poland', 'PL', '0000-00-00', 0, '0000-00-00', 0),
(175, 'Portugal', 'PT', '0000-00-00', 0, '0000-00-00', 0),
(176, 'Puerto Rico', 'PR', '0000-00-00', 0, '0000-00-00', 0),
(177, 'Qatar', 'QA', '0000-00-00', 0, '0000-00-00', 0),
(178, 'Reunion', 'RE', '0000-00-00', 0, '0000-00-00', 0),
(179, 'Romania', 'RO', '0000-00-00', 0, '0000-00-00', 0),
(180, 'Russian Federation', 'RU', '0000-00-00', 0, '0000-00-00', 0),
(181, 'Rwanda', 'RW', '0000-00-00', 0, '0000-00-00', 0),
(182, 'Saint Kitts and Nevis', 'KN', '0000-00-00', 0, '0000-00-00', 0),
(183, 'Saint Lucia', 'LC', '0000-00-00', 0, '0000-00-00', 0),
(184, 'Saint Vincent and the Grenadines', 'VC', '0000-00-00', 0, '0000-00-00', 0),
(185, 'Samoa', 'WS', '0000-00-00', 0, '0000-00-00', 0),
(186, 'San Marino', 'SM', '0000-00-00', 0, '0000-00-00', 0),
(187, 'Sao Tome and Principe', 'ST', '0000-00-00', 0, '0000-00-00', 0),
(188, 'Saudi Arabia', 'SA', '0000-00-00', 0, '0000-00-00', 0),
(189, 'Senegal', 'SN', '0000-00-00', 0, '0000-00-00', 0),
(190, 'Serbia', 'RS', '0000-00-00', 0, '0000-00-00', 0),
(191, 'Seychelles', 'SC', '0000-00-00', 0, '0000-00-00', 0),
(192, 'Sierra Leone', 'SL', '0000-00-00', 0, '0000-00-00', 0),
(193, 'Singapore', 'SG', '0000-00-00', 0, '0000-00-00', 0),
(194, 'Slovakia', 'SK', '0000-00-00', 0, '0000-00-00', 0),
(195, 'Slovenia', 'SI', '0000-00-00', 0, '0000-00-00', 0),
(196, 'Solomon Islands', 'SB', '0000-00-00', 0, '0000-00-00', 0),
(197, 'Somalia', 'SO', '0000-00-00', 0, '0000-00-00', 0),
(198, 'South Africa', 'ZA', '0000-00-00', 0, '0000-00-00', 0),
(199, 'South Georgia South Sandwich Islands', 'GS', '0000-00-00', 0, '0000-00-00', 0),
(200, 'Spain', 'ES', '0000-00-00', 0, '0000-00-00', 0),
(201, 'Sri Lanka', 'LK', '0000-00-00', 0, '0000-00-00', 0),
(202, 'St. Helena', 'SH', '0000-00-00', 0, '0000-00-00', 0),
(203, 'St. Pierre and Miquelon', 'PM', '0000-00-00', 0, '0000-00-00', 0),
(204, 'Sudan', 'SD', '0000-00-00', 0, '0000-00-00', 0),
(205, 'Suriname', 'SR', '0000-00-00', 0, '0000-00-00', 0),
(206, 'Svalbarn and Jan Mayen Islands', 'SJ', '0000-00-00', 0, '0000-00-00', 0),
(207, 'Swaziland', 'SZ', '0000-00-00', 0, '0000-00-00', 0),
(208, 'Sweden', 'SE', '0000-00-00', 0, '0000-00-00', 0),
(209, 'Switzerland', 'CH', '0000-00-00', 0, '0000-00-00', 0),
(210, 'Syrian Arab Republic', 'SY', '0000-00-00', 0, '0000-00-00', 0),
(211, 'Taiwan', 'TW', '0000-00-00', 0, '0000-00-00', 0),
(212, 'Tajikistan', 'TJ', '0000-00-00', 0, '0000-00-00', 0),
(213, 'Tanzania, United Republic of', 'TZ', '0000-00-00', 0, '0000-00-00', 0),
(214, 'Thailand', 'TH', '0000-00-00', 0, '0000-00-00', 0),
(215, 'Togo', 'TG', '0000-00-00', 0, '0000-00-00', 0),
(216, 'Tokelau', 'TK', '0000-00-00', 0, '0000-00-00', 0),
(217, 'Tonga', 'TO', '0000-00-00', 0, '0000-00-00', 0),
(218, 'Trinidad and Tobago', 'TT', '0000-00-00', 0, '0000-00-00', 0),
(219, 'Tunisia', 'TN', '0000-00-00', 0, '0000-00-00', 0),
(220, 'Turkey', 'TR', '0000-00-00', 0, '0000-00-00', 0),
(221, 'Turkmenistan', 'TM', '0000-00-00', 0, '0000-00-00', 0),
(222, 'Turks and Caicos Islands', 'TC', '0000-00-00', 0, '0000-00-00', 0),
(223, 'Tuvalu', 'TV', '0000-00-00', 0, '0000-00-00', 0),
(224, 'Uganda', 'UG', '0000-00-00', 0, '0000-00-00', 0),
(225, 'Ukraine', 'UA', '0000-00-00', 0, '0000-00-00', 0),
(226, 'United Arab Emirates', 'AE', '0000-00-00', 0, '0000-00-00', 0),
(227, 'United Kingdom', 'GB', '0000-00-00', 0, '0000-00-00', 0),
(228, 'United States minor outlying islands', 'UM', '0000-00-00', 0, '0000-00-00', 0),
(229, 'Uruguay', 'UY', '0000-00-00', 0, '0000-00-00', 0),
(230, 'Uzbekistan', 'UZ', '0000-00-00', 0, '0000-00-00', 0),
(231, 'Vanuatu', 'VU', '0000-00-00', 0, '0000-00-00', 0),
(232, 'Vatican City State', 'VA', '0000-00-00', 0, '0000-00-00', 0),
(233, 'Venezuela', 'VE', '0000-00-00', 0, '0000-00-00', 0),
(234, 'Vietnam', 'VN', '0000-00-00', 0, '0000-00-00', 0),
(235, 'Virgin Islands (British)', 'VG', '0000-00-00', 0, '0000-00-00', 0),
(236, 'Virgin Islands (U.S.)', 'VI', '0000-00-00', 0, '0000-00-00', 0),
(237, 'Wallis and Futuna Islands', 'WF', '0000-00-00', 0, '0000-00-00', 0),
(238, 'Western Sahara', 'EH', '0000-00-00', 0, '0000-00-00', 0),
(239, 'Yemen', 'YE', '0000-00-00', 0, '0000-00-00', 0),
(240, 'Yugoslavia', 'YU', '0000-00-00', 0, '0000-00-00', 0),
(241, 'Mayotte', 'YT', '0000-00-00', 0, '0000-00-00', 0),
(242, 'Zaire', 'ZR', '0000-00-00', 0, '0000-00-00', 0),
(243, 'Zambia', 'ZM', '0000-00-00', 0, '0000-00-00', 0),
(244, 'Zimbabwe', 'ZW', '0000-00-00', 0, '0000-00-00', 0);

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

--
-- Table structure for table `docsubmission`
--

DROP TABLE IF EXISTS `docsubmission`;
CREATE TABLE IF NOT EXISTS `docsubmission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `orderId` int DEFAULT NULL,
  `lcNumber` varchar(50) DEFAULT NULL,
  `invoiceValue` int DEFAULT NULL,
  `buyerId` int DEFAULT NULL,
  `docSubDate` date DEFAULT NULL,
  `certificate` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `exportformnumber` varchar(300) DEFAULT NULL,
  `bankrefnumber` varchar(300) DEFAULT NULL,
  `shipCountryId` int DEFAULT NULL,
  `currency` varchar(50) DEFAULT NULL,
  `exchangeRate` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `exportinvoice`
--

DROP TABLE IF EXISTS `exportinvoice`;
CREATE TABLE IF NOT EXISTS `exportinvoice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `orderId` int DEFAULT NULL,
  `orderQty` int DEFAULT NULL,
  `lcNumber` varchar(50) DEFAULT NULL,
  `invoiceValue` int DEFAULT NULL,
  `invoiceDate` date DEFAULT NULL,
  `shipMode` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `exportformnumber` varchar(300) DEFAULT NULL,
  `shipCountryId` int DEFAULT NULL,
  `buyerid` int NOT NULL,
  `currency` varchar(50) DEFAULT NULL,
  `exchangeRate` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `importinvoice`
--

DROP TABLE IF EXISTS `importinvoice`;
CREATE TABLE IF NOT EXISTS `importinvoice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `orderId` int DEFAULT NULL,
  `orderQty` int DEFAULT NULL,
  `lcNumber` varchar(50) DEFAULT NULL,
  `invoiceValue` int DEFAULT NULL,
  `supplierId` int DEFAULT NULL,
  `invoiceDate` date DEFAULT NULL,
  `shipMode` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `exportformnumber` varchar(300) DEFAULT NULL,
  `shipCountryId` int DEFAULT NULL,
  `currency` varchar(50) DEFAULT NULL,
  `exchangeRate` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
CREATE TABLE IF NOT EXISTS `item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemName` varchar(100) DEFAULT NULL,
  `categoryId` int DEFAULT NULL,
  `uom` varchar(15) DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `ordergmt`
--

DROP TABLE IF EXISTS `ordergmt`;
CREATE TABLE IF NOT EXISTS `ordergmt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `qty` int DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `itemId` int DEFAULT NULL,
  `buyerId` int DEFAULT NULL,
  `orderDate` date DEFAULT NULL,
  `shipMode` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `supplierId` int DEFAULT NULL,
  `categoryId` int DEFAULT NULL,
  `fobPrice` int DEFAULT NULL,
  `smv` int DEFAULT NULL,
  `efficiency` int DEFAULT NULL,
  `shipmentCountryId` int DEFAULT NULL,
  `styleName` int DEFAULT NULL,
  `countryId` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `salescontract`
--

DROP TABLE IF EXISTS `salescontract`;
CREATE TABLE IF NOT EXISTS `salescontract` (
  `id` int NOT NULL AUTO_INCREMENT,
  `systemId` varchar(50) DEFAULT NULL,
  `orderId` int DEFAULT NULL,
  `orderQty` int DEFAULT NULL,
  `poNumber` varchar(50) DEFAULT NULL,
  `itemId` int DEFAULT NULL,
  `buyerId` int DEFAULT NULL,
  `orderDate` date DEFAULT NULL,
  `shipMode` varchar(50) DEFAULT NULL,
  `shipDate` date DEFAULT NULL,
  `lcApplicant` varchar(300) DEFAULT NULL,
  `lienBank` varchar(200) DEFAULT NULL,
  `payTerm` varchar(150) DEFAULT NULL,
  `benificiary` varchar(150) DEFAULT NULL,
  `shipCountryId` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `style`
--

DROP TABLE IF EXISTS `style`;
CREATE TABLE IF NOT EXISTS `style` (
  `id` int NOT NULL AUTO_INCREMENT,
  `styleName` varchar(100) DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `supplier`;
CREATE TABLE IF NOT EXISTS `supplier` (
  `id` int NOT NULL AUTO_INCREMENT,
  `supplierName` varchar(100) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `companyId` int DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `updateBy` int DEFAULT NULL,
  `updateDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `usertable`
--

DROP TABLE IF EXISTS `usertable`;
CREATE TABLE IF NOT EXISTS `usertable` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `update_date` date DEFAULT NULL,
  `update_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
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 */;