-- --------------------------------------------------------
-- Host:                         148.72.151.64
-- Server version:               5.7.31 - MySQL Community Server (GPL)
-- Server OS:                    Linux
-- HeidiSQL Version:             10.2.0.5599
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping database structure for eightpoint
CREATE DATABASE IF NOT EXISTS `eightpoint` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `eightpoint`;

-- Dumping structure for table eightpoint.allowance_grid
CREATE TABLE IF NOT EXISTS `allowance_grid` (
  `agID` int(11) NOT NULL AUTO_INCREMENT,
  `allow_type` varchar(255) DEFAULT NULL,
  `atcomment` varchar(255) DEFAULT NULL,
  `target_price` varchar(255) DEFAULT NULL,
  `frequency` varchar(255) DEFAULT NULL,
  `regular_unit` varchar(255) DEFAULT NULL,
  `EDLP_OI_allow` varchar(255) DEFAULT NULL,
  `EDLP_scan_allow` varchar(255) DEFAULT NULL,
  `AD_OI_allow` varchar(255) DEFAULT NULL,
  `AD_scan_allow` varchar(255) DEFAULT NULL,
  `net_unit` varchar(255) DEFAULT NULL,
  `retail` varchar(255) DEFAULT NULL,
  `margin` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`agID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.AllowType
CREATE TABLE IF NOT EXISTS `AllowType` (
  `atID` int(11) NOT NULL AUTO_INCREMENT,
  `atValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`atID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.authorized
CREATE TABLE IF NOT EXISTS `authorized` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RetailerName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.authorized_product
CREATE TABLE IF NOT EXISTS `authorized_product` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` varchar(50) DEFAULT NULL,
  `authorized_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.brand
CREATE TABLE IF NOT EXISTS `brand` (
  `bID` int(11) NOT NULL AUTO_INCREMENT,
  `bName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.Case_Cube
CREATE TABLE IF NOT EXISTS `Case_Cube` (
  `ccID` int(11) NOT NULL AUTO_INCREMENT,
  `ccValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ccID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.Case_Dimensions
CREATE TABLE IF NOT EXISTS `Case_Dimensions` (
  `cdID` int(11) NOT NULL AUTO_INCREMENT,
  `cdValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cdID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.Case_Weight
CREATE TABLE IF NOT EXISTS `Case_Weight` (
  `cwID` int(11) NOT NULL AUTO_INCREMENT,
  `cwValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cwID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.category
CREATE TABLE IF NOT EXISTS `category` (
  `iID` int(11) NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `active` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.demo
CREATE TABLE IF NOT EXISTS `demo` (
  `id` int(11) DEFAULT NULL,
  `NAME` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.descrption
CREATE TABLE IF NOT EXISTS `descrption` (
  `dID` int(11) NOT NULL AUTO_INCREMENT,
  `des` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`dID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.island
CREATE TABLE IF NOT EXISTS `island` (
  `islandID` int(11) NOT NULL AUTO_INCREMENT,
  `islandName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`islandID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.item
CREATE TABLE IF NOT EXISTS `item` (
  `iID` int(11) NOT NULL AUTO_INCREMENT,
  `iName` varchar(50) DEFAULT NULL,
  `active` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`iID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.period
CREATE TABLE IF NOT EXISTS `period` (
  `pID` int(11) NOT NULL AUTO_INCREMENT,
  `pName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.period_name
CREATE TABLE IF NOT EXISTS `period_name` (
  `pnID` int(11) NOT NULL AUTO_INCREMENT,
  `pnName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pnID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.period_range
CREATE TABLE IF NOT EXISTS `period_range` (
  `prID` int(11) NOT NULL AUTO_INCREMENT,
  `prFrom` varchar(255) DEFAULT NULL,
  `prTo` varchar(255) DEFAULT NULL,
  `period_name_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`prID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.permission
CREATE TABLE IF NOT EXISTS `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.product
CREATE TABLE IF NOT EXISTS `product` (
  `proID` int(11) NOT NULL AUTO_INCREMENT,
  `EPD_Item_num` int(11) NOT NULL DEFAULT '0',
  `category_group` varchar(50) DEFAULT NULL,
  `item` varchar(50) DEFAULT NULL,
  `unit_upc1` varchar(50) DEFAULT NULL,
  `unit_upc2` varchar(50) DEFAULT NULL,
  `unit_upc3` varchar(50) DEFAULT NULL,
  `case` varchar(50) DEFAULT NULL,
  `pack` varchar(50) DEFAULT NULL,
  `size` varchar(50) DEFAULT NULL,
  `size_value` varchar(50) DEFAULT NULL,
  `supplier_id` varchar(50) DEFAULT NULL,
  `supplier` varchar(50) DEFAULT NULL,
  `brand` varchar(50) DEFAULT NULL,
  `oahu_cs` varchar(50) DEFAULT NULL,
  `oahu_unit` varchar(50) DEFAULT NULL,
  `effective_date1` varchar(50) DEFAULT NULL,
  `hmk_cs` varchar(50) DEFAULT NULL,
  `hmk_unit` varchar(50) DEFAULT NULL,
  `effective_date2` varchar(50) DEFAULT NULL,
  `authorized_retailers` varchar(50) DEFAULT NULL,
  `unit_dim_L` varchar(50) DEFAULT NULL,
  `unit_dim_W` varchar(50) DEFAULT NULL,
  `unit_dim_H` varchar(50) DEFAULT NULL,
  `unit_dim_type` varchar(50) DEFAULT NULL,
  `case_dim_L` varchar(50) DEFAULT NULL,
  `case_dim_W` varchar(50) DEFAULT NULL,
  `case_dim_H` varchar(50) DEFAULT NULL,
  `case_dim_type` varchar(50) DEFAULT NULL,
  `case_wt` varchar(50) DEFAULT NULL,
  `case_wt_type` varchar(50) DEFAULT NULL,
  `case_cube` varchar(50) DEFAULT NULL,
  `case_cube_unit` varchar(50) DEFAULT NULL,
  `pallet_dim_CS` varchar(50) DEFAULT NULL,
  `pallet_dim_TI` varchar(50) DEFAULT NULL,
  `pallet_dim_HI` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`proID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.products
CREATE TABLE IF NOT EXISTS `products` (
  `proID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `EPD_NUM` int(11) DEFAULT NULL,
  `supplierid` varchar(255) DEFAULT NULL,
  `supplier` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `category_group` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `UNIT1_UPC` varchar(255) DEFAULT NULL,
  `UNIT2_UPC` varchar(255) DEFAULT NULL,
  `UNIT3_UPC` varchar(255) DEFAULT NULL,
  `CASE_no` varchar(255) DEFAULT NULL,
  `PACK` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `sizeValue` varchar(255) DEFAULT NULL,
  `case_oahu` varchar(255) DEFAULT NULL,
  `unit_oahu` varchar(255) DEFAULT NULL,
  `hmk_cs` varchar(255) DEFAULT NULL,
  `hmk_unit` varchar(255) DEFAULT NULL,
  `planfrom` varchar(255) DEFAULT NULL,
  `planto` varchar(255) DEFAULT NULL,
  `authorized` varchar(255) DEFAULT NULL,
  `udl` varchar(255) DEFAULT NULL,
  `udw` varchar(255) DEFAULT NULL,
  `udh` varchar(255) DEFAULT NULL,
  `udd` varchar(255) DEFAULT NULL,
  `cdl` varchar(255) DEFAULT NULL,
  `cdw` varchar(255) DEFAULT NULL,
  `cdh` varchar(255) DEFAULT NULL,
  `cdd` varchar(255) DEFAULT NULL,
  `cww` varchar(255) DEFAULT NULL,
  `cds` varchar(255) DEFAULT NULL,
  `ccw` varchar(255) DEFAULT NULL,
  `ccs` varchar(255) DEFAULT NULL,
  `pdcs` varchar(255) DEFAULT NULL,
  `pdti` varchar(255) DEFAULT NULL,
  `pdhi` varchar(255) DEFAULT NULL,
  `is_hide` int(11) unsigned NOT NULL DEFAULT '0',
  `timecreated` varchar(50) DEFAULT NULL,
  `timecreated_end` varchar(50) DEFAULT NULL,
  `timeupdated` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`proID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.promotions
CREATE TABLE IF NOT EXISTS `promotions` (
  `promoID` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(255) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT '0',
  `Island` varchar(255) DEFAULT NULL,
  `period_name1` varchar(255) DEFAULT NULL,
  `datefrom` varchar(255) DEFAULT NULL,
  `dateto` varchar(255) DEFAULT NULL,
  `promotion_notes` varchar(255) DEFAULT NULL,
  `allowancegrid` varchar(255) DEFAULT NULL,
  `allowType` varchar(255) DEFAULT NULL,
  `Comment` varchar(255) DEFAULT NULL,
  `TargetPrc` varchar(255) DEFAULT NULL,
  `frequency` varchar(255) DEFAULT NULL,
  `RegularUnit` varchar(255) DEFAULT NULL,
  `EDLP_OI_allow` varchar(255) DEFAULT NULL,
  `EDLP_scan_allow` varchar(255) DEFAULT NULL,
  `AD_OI_allow` varchar(255) DEFAULT NULL,
  `AD_scan_allow` varchar(255) DEFAULT NULL,
  `NET_NET` varchar(255) DEFAULT NULL,
  `Rwq_retail` varchar(255) DEFAULT NULL,
  `Margin` varchar(255) DEFAULT NULL,
  `authorized` varchar(255) DEFAULT NULL,
  `timeupdated` varchar(255) DEFAULT NULL,
  `timecreated` varchar(255) DEFAULT NULL,
  `is_hide` int(11) DEFAULT NULL,
  PRIMARY KEY (`promoID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.retailer
CREATE TABLE IF NOT EXISTS `retailer` (
  `rID` int(11) NOT NULL AUTO_INCREMENT,
  `rName` varchar(255) DEFAULT NULL,
  `active` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.role
CREATE TABLE IF NOT EXISTS `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.role_permission
CREATE TABLE IF NOT EXISTS `role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(50) NOT NULL DEFAULT '0',
  `permission` varchar(50) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.size
CREATE TABLE IF NOT EXISTS `size` (
  `sizeID` int(11) NOT NULL AUTO_INCREMENT,
  `sizeValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sizeID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.supplier
CREATE TABLE IF NOT EXISTS `supplier` (
  `sID` int(11) NOT NULL AUTO_INCREMENT,
  `sName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.Unit_Dimensions
CREATE TABLE IF NOT EXISTS `Unit_Dimensions` (
  `udID` int(11) NOT NULL AUTO_INCREMENT,
  `udValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`udID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

-- Dumping structure for table eightpoint.users
CREATE TABLE IF NOT EXISTS `users` (
  `ID` int(11) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `uname` varchar(255) DEFAULT NULL,
  `passwrd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
