Staging Database Setup Guide

Staging database is necessary to setup along with SkuVault and QuickBooks connectors. This staging database acts as an intermediate system to map Sales Order and Purchase Order between SkuVault and QuickBooks. By this process, duplication of transactions are eliminated.

Connect to Host

Please provide the following credentials to connect MySQL

MySQL Host Address: Host name or IP address of the database server

Username: Database username

Password: Database password

Port: The port used to connect to database server

Script

Following is the database script that should be run in MySQL as a part of setting up staging database 

/*
SQLyog Ultimate v8.71
MySQL - 5.6.27-log : Database - skuvault_quickbooks
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`skuvault_quickbooks` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `skuvault_quickbooks`;

/*Table structure for table `sku_to_qb_relation` */

DROP TABLE IF EXISTS `sku_to_qb_relation`;

CREATE TABLE `sku_to_qb_relation` (
`sno` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(15) DEFAULT NULL,
`vendor_customer` varchar(100) DEFAULT NULL,
`sku_id` varchar(45) DEFAULT NULL,
`qb_id` varchar(45) DEFAULT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;