--
-- Host: localhost    Database: unitednoodles
-- ------------------------------------------------------


--
-- Current Database: `unitednoodles`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `unitednoodles` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `unitednoodles`;

--
-- Table structure for table `ach`
--

CREATE TABLE `ach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(5) NOT NULL,
  `accountholdername` varchar(30) NOT NULL,
  `accountholdertype` varchar(30) NOT NULL,
  `accountnumber` varchar(50) NOT NULL,
  `routingnumber` bigint(30) NOT NULL,
  `accountstatus` varchar(30) NOT NULL,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  `customerid` varchar(50) NOT NULL,
  `bankaccountid` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ach`
--


--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `announcements` text DEFAULT NULL,
  `links` text DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` VALUES ('Chef Adam has bamboo shoots on sale for $39.99 a case until May 30, 2021!','',1,'2021-05-21 07:19:22'),('Machi Machi Franchisees and Direct Stores: Please provide your orders before Monday at 3:00pm (Central Time) for shipments to sent the same day.\r\n','',2,'2021-05-23 22:45:46');

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `invoiceno` varchar(30) NOT NULL,
  `customerid` int(5) NOT NULL,
  `totalprice` float NOT NULL,
  `invoicedate` datetime NOT NULL DEFAULT current_timestamp(),
  `invoicestatus` varchar(20) DEFAULT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  `createdby` varchar(50) NOT NULL,
  `totalitems` int(5) NOT NULL,
  `paymentid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoiceno` (`invoiceno`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` VALUES (88,'UN110-31819115',9,53.72,'2021-06-28 10:39:16',NULL,'2021-06-28 10:39:16','admin',1,NULL);

--
-- Table structure for table `invoice_item`
--

CREATE TABLE `invoice_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemcode` int(20) NOT NULL,
  `qty` int(10) NOT NULL,
  `priceqty` float NOT NULL,
  `invoiceno` varchar(30) NOT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=176 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `invoice_item`
--

INSERT INTO `invoice_item` VALUES (175,1000023,1,53.72,'UN110-31819115','2021-06-28 10:39:16');

--
-- Table structure for table `invoice_number`
--

CREATE TABLE `invoice_number` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `invoiceyear` int(5) NOT NULL,
  `prefix` varchar(5) NOT NULL,
  `startingno` int(7) NOT NULL,
  `sequenceno` int(7) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `invoice_number`
--

INSERT INTO `invoice_number` VALUES (1,2021,'UN110',31819111,31819130),(2,2022,'UN111',0,2),(3,2023,'UN112',0,10),(4,2024,'UN113',0,5),(5,2025,'UN114',0,27),(6,2026,'UN115',0,0),(7,2027,'UN116',0,0),(8,2028,'UN117',0,0),(9,2029,'UN118',0,0),(10,2030,'UN119',0,0),(11,2031,'UN120',0,0),(12,2032,'UN121',0,0),(13,2033,'UN122',0,0),(14,2034,'UN123',0,0),(15,2035,'UN124',0,0),(16,2036,'UN125',0,0),(17,2037,'UN126',0,0),(18,2038,'UN127',0,0),(19,2039,'UN128',0,0),(20,2040,'UN129',0,0),(21,2041,'UN130',0,0),(22,2042,'UN131',0,0),(23,2043,'UN132',0,0),(24,2044,'UN133',0,0),(25,2045,'UN134',0,0),(26,2046,'UN135',0,0),(27,2047,'UN136',0,0),(28,2048,'UN137',0,0),(29,2049,'UN138',0,0),(30,2050,'UN139',0,0),(31,2051,'UN140',0,0),(32,2052,'UN141',0,0),(33,2053,'UN142',0,0),(34,2054,'UN143',0,0),(35,2055,'UN144',0,0),(36,2056,'UN145',0,0),(37,2057,'UN146',0,0),(38,2058,'UN147',0,0),(39,2059,'UN148',0,0),(40,2060,'UN149',0,0),(41,2061,'UN150',0,0),(42,2062,'UN151',0,0);

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemcode` int(10) NOT NULL,
  `itemname` varchar(300) DEFAULT NULL,
  `packsize` varchar(30) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  `createdby` varchar(30) DEFAULT NULL,
  `updateddate` varchar(30) DEFAULT NULL,
  `updatedby` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` VALUES (157,1000023,'Mikawaya Mochi Ice Cream Kona Coffee','12/9.10 oz',53.72,'2021-05-07 03:37:30','admin',NULL,NULL),(156,1000022,'Mikawaya Mochi Ice Cream Green Tea','12/9.10 oz',53.72,'2021-05-07 03:37:30','admin',NULL,NULL),(110,1000003,'Sriracha Sauce PC','500/7gm',56.67,'2021-05-05 00:07:39','admin','2021-05-07 03:37:30','admin'),(139,1000004,'Menma Bamboo Shoots Seasoned, 10/2.2 lbs ','10/2.2 lbs (22 lbs)',112.5,'2021-05-07 03:37:30','admin',NULL,NULL),(140,1000005,'Noodles - Nagasaki Champon Ramen Noodles,  48/6 oz','48/6 oz (288 oz)',46.8,'2021-05-07 03:37:30','admin',NULL,NULL),(141,1000006,'Noodles - Myojo Udon Single-Pac','30/6.98 oz',30.68,'2021-05-07 03:37:30','admin',NULL,NULL),(142,1000007,'Noodles - Gluten Free Ramen Noodles, 30/cs ','30/case',39,'2021-05-07 03:37:30','admin',NULL,NULL),(143,1000008,'Soup Base - Tonkotsu, 10/2.2 lb','10/2.2 lb (22 lbs)',227,'2021-05-07 03:37:30','admin',NULL,NULL),(144,1000009,'KKM Soy Sauce Low Sodium','5 gal',39.78,'2021-05-07 03:37:30','admin',NULL,NULL),(145,1000010,'KKM Gluten Free Tamari Soy Sauce','6/0.5 gal',88.63,'2021-05-07 03:37:30','admin',NULL,NULL),(146,1000011,'JB Sushi Nori Deluxe Half Sheets','5/200 sht',90,'2021-05-07 03:37:30','admin',NULL,NULL),(119,1000012,'KKM Manjo Aji Mirin','6/60.00 fl',76.7,'2021-05-05 00:07:39','admin','2021-05-07 03:37:30','admin'),(155,1000021,'Mikawaya Mochi Ice Cream Chocolate','12/9.10 oz',53.72,'2021-05-07 03:37:30','admin',NULL,NULL),(154,1000020,'Tasty Joy Dried Shiitake Mushroom','5/5 lbs',88.4,'2021-05-07 03:37:30','admin',NULL,NULL),(153,1000019,'White Miso paste','44.00 lbs',49.5,'2021-05-07 03:37:30','admin',NULL,NULL),(152,1000018,'Sesame Flavored Chili Oil','6/60.87 fl',141.6,'2021-05-07 03:37:30','admin',NULL,NULL),(151,1000017,'Hiyashi Wakame Seaweed Salad','4/4.40 lbs',114.83,'2021-05-07 03:37:30','admin',NULL,NULL),(150,1000016,'Kewpie Mayo Blue Label','4/1 gal',78,'2021-05-07 03:37:30','admin',NULL,NULL),(149,1000015,'Oi Ocha Green Tea PET','12/16.90 fl',20.8,'2021-05-07 03:37:30','admin',NULL,NULL),(148,1000014,'JB Hanakatsuo Bonito flakes','6/16.00 oz',124.8,'2021-05-07 03:37:30','admin',NULL,NULL),(147,1000013,'WP Dried Dashi Konbu Seaweed - FOOOOBAR','10/2.20 lbs',1123,'2021-05-07 03:37:30','admin',NULL,NULL),(138,1000002,'Poly Paper Food Container 32 oz. Combo with Lid, 250/cs','250/case',107.2,'2021-05-07 03:37:30','admin',NULL,NULL),(132,1000025,'Pork Bone Broth','25 gal',220,'2021-05-05 00:07:39','admin','2021-05-07 03:37:30','admin'),(137,1000001,'Poly Paper Food Container 16 oz. Combo with Lid, 250/cs','250/case',89.45,'2021-05-07 03:37:30','admin',NULL,NULL),(159,1000026,'Disposable Dining Asian Soup Spoons Chinese Spoon White Plastic','100 pcs',55,'2021-05-07 03:37:30','admin',NULL,NULL),(158,1000024,'Mikawaya Mochi Ice Cream Plum Wine','12/9.10 oz',53.72,'2021-05-07 03:37:30','admin',NULL,NULL);

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `invoiceno` varchar(30) NOT NULL,
  `email` varchar(50) NOT NULL,
  `acnumber` bigint(30) NOT NULL,
  `acname` varchar(50) NOT NULL,
  `paidby` varchar(20) DEFAULT NULL,
  `payment_status` varchar(20) NOT NULL,
  `amount` varchar(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `transaction_id` varchar(50) NOT NULL,
  `balance_transaction_id` varchar(50) NOT NULL,
  `currency` varchar(5) NOT NULL,
  `payment_date` varchar(20) NOT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  `userid` int(5) NOT NULL,
  `custid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoiceno` (`invoiceno`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment`
--


--
-- Table structure for table `poorder`
--

CREATE TABLE `poorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pono` varchar(30) NOT NULL,
  `customerid` int(5) NOT NULL,
  `totalprice` float NOT NULL,
  `totalitems` int(5) NOT NULL,
  `orderdate` datetime NOT NULL DEFAULT current_timestamp(),
  `orderstatus` varchar(20) NOT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  `paymentid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pono` (`pono`)
) ENGINE=MyISAM AUTO_INCREMENT=164 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `poorder`
--

INSERT INTO `poorder` VALUES (163,'UN110-31819122',5,46.8,1,'2021-08-07 08:12:40','Open','2021-08-07 08:12:40',NULL),(162,'UN110-31819115',9,53.72,1,'2021-06-28 10:38:51','Unpaid','2021-06-28 10:38:51',NULL);

--
-- Table structure for table `poorder_item`
--

CREATE TABLE `poorder_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pono` varchar(30) NOT NULL,
  `itemcode` int(20) NOT NULL,
  `qty` int(10) NOT NULL,
  `priceqty` float NOT NULL,
  `createddate` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=420 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `poorder_item`
--

INSERT INTO `poorder_item` VALUES (419,'UN110-31819122',1000005,1,46.8,'2021-08-07 08:12:40'),(418,'UN110-31819115',1000023,1,53.72,'2021-06-28 10:38:51');


