/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50626
Source Host           : localhost:3306
Source Database       : t_wholesaler

Target Server Type    : MYSQL
Target Server Version : 50626
File Encoding         : 65001

Date: 2017-04-07 16:13:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `yz_bank`
-- ----------------------------
DROP TABLE IF EXISTS `yz_bank`;
CREATE TABLE `yz_bank` (
  `BankID` int(11) NOT NULL AUTO_INCREMENT COMMENT '账户ID',
  `BankName` varchar(255) DEFAULT NULL COMMENT '账户名',
  `BankAccount` varchar(255) DEFAULT NULL COMMENT '账户号',
  `BankBalance` decimal(10,3) DEFAULT '0.000' COMMENT '账户余额',
  `Currency` tinyint(4) DEFAULT NULL COMMENT '币种 1rmb 2usd',
  `CreateTime` datetime DEFAULT NULL COMMENT '启用时间',
  `UpdateTime` datetime DEFAULT NULL COMMENT '上一次结余更新时间',
  `CheckResult` tinyint(4) DEFAULT NULL COMMENT '对账记录 0不符 1相符 空-未对账',
  `CheckTime` datetime DEFAULT NULL COMMENT '上一次对账时间',
  `UserID` int(11) DEFAULT NULL COMMENT '对账人',
  `Status` tinyint(4) DEFAULT '1' COMMENT '1启用 0禁用',
  `Comments` varchar(255) DEFAULT NULL COMMENT '备注',
  `Type` tinyint(4) DEFAULT '0' COMMENT '账户类型 1虚拟账户-仅1个；真实账户',
  PRIMARY KEY (`BankID`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_bank
-- ----------------------------
INSERT INTO `yz_bank` VALUES ('7', 'HK-$货款1', '71', '200.000', '2', '2016-12-23 14:57:10', '2017-03-23 16:24:28', '1', '2017-01-10 14:24:22', '712', '1', '货款1', '1');
INSERT INTO `yz_bank` VALUES ('11', 'HK-$支出', '11', '0.000', '2', '2016-12-29 13:47:44', '2017-03-22 13:00:49', '1', '2017-03-21 18:26:54', '712', '1', '实际支出USD', '2');
INSERT INTO `yz_bank` VALUES ('12', 'RMB-￥支出', '12', '0.000', '1', '2017-01-05 16:08:02', '2017-03-06 10:38:18', '1', '2017-01-06 17:16:50', '712', '1', '实际支出RMB', '3');
INSERT INTO `yz_bank` VALUES ('18', '中国银行', '6228', '0.000', '1', '2016-12-23 12:33:01', '2017-03-23 16:24:15', '1', '2017-01-09 16:14:11', '712', '1', 'k', '0');
INSERT INTO `yz_bank` VALUES ('19', '民生银行', '6229', '0.000', '1', '2016-12-23 12:33:16', '2017-03-23 16:15:59', '1', '2017-03-22 17:03:00', '712', '1', 'k', '0');
INSERT INTO `yz_bank` VALUES ('20', '建设', '6221', '0.000', '1', '2016-12-23 12:33:28', '2017-03-22 13:10:23', '1', '2017-01-09 15:56:10', '712', '1', 'k', '0');
INSERT INTO `yz_bank` VALUES ('21', '工商', '6229', '56.000', '1', '2016-12-23 12:39:42', '2017-03-03 15:34:47', '1', '2017-01-04 18:36:34', '712', '1', '多带点', '0');
INSERT INTO `yz_bank` VALUES ('22', '北京银行', '6239', '0.000', '2', '2017-01-10 14:25:30', null, '1', '2017-01-10 14:38:36', '712', '0', '美金账户', '0');

-- ----------------------------
-- Table structure for `yz_cart`
-- ----------------------------
DROP TABLE IF EXISTS `yz_cart`;
CREATE TABLE `yz_cart` (
  `CartID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '购物车ID',
  `CustomerID` int(11) DEFAULT NULL COMMENT '客户ID',
  `UserID` int(11) DEFAULT NULL COMMENT '团队ID',
  `InventoryID` bigint(20) NOT NULL DEFAULT '-1' COMMENT '库存ID',
  `CartType` int(11) DEFAULT NULL COMMENT '购物车类型',
  `CreateTime` datetime DEFAULT NULL COMMENT '加入时间',
  PRIMARY KEY (`CartID`),
  KEY `CustomerID` (`CustomerID`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='购物车';

-- ----------------------------
-- Records of yz_cart
-- ----------------------------
INSERT INTO `yz_cart` VALUES ('1', '155', '821', '6171277', '1', '2017-03-29 15:24:32');
INSERT INTO `yz_cart` VALUES ('2', '155', '821', '5805212', '1', '2017-03-29 15:24:33');
INSERT INTO `yz_cart` VALUES ('3', '155', '821', '6171277', '1', '2017-03-30 16:47:35');
INSERT INTO `yz_cart` VALUES ('4', '155', '821', '6171277', '1', '2017-03-31 10:57:51');
INSERT INTO `yz_cart` VALUES ('5', '155', '821', '6171277', '1', '2017-03-31 11:03:08');
INSERT INTO `yz_cart` VALUES ('6', '155', '821', '6171277', '1', '2017-03-31 11:06:22');
INSERT INTO `yz_cart` VALUES ('7', '155', '821', '6171277', '1', '2017-03-31 11:07:48');
INSERT INTO `yz_cart` VALUES ('8', '155', '821', '6171277', '1', '2017-03-31 11:18:34');
INSERT INTO `yz_cart` VALUES ('9', '155', '821', '6171277', '1', '2017-03-31 11:19:57');
INSERT INTO `yz_cart` VALUES ('10', '155', '821', '6171277', '1', '2017-03-31 11:22:08');
INSERT INTO `yz_cart` VALUES ('11', '155', '821', '6171277', '1', '2017-03-31 11:23:00');
INSERT INTO `yz_cart` VALUES ('12', '155', '821', '6171277', '1', '2017-03-31 11:24:02');
INSERT INTO `yz_cart` VALUES ('13', '155', '821', '6171277', '1', '2017-03-31 13:45:39');
INSERT INTO `yz_cart` VALUES ('14', '155', '821', '4916698', '1', '2017-03-31 18:06:40');
INSERT INTO `yz_cart` VALUES ('19', '193', '821', '5686000', '1', '2017-04-06 15:26:19');

-- ----------------------------
-- Table structure for `yz_cart_parcel`
-- ----------------------------
DROP TABLE IF EXISTS `yz_cart_parcel`;
CREATE TABLE `yz_cart_parcel` (
  `CartID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '购物车ID',
  `CustomerID` int(11) DEFAULT NULL COMMENT '客户ID',
  `UserID` int(11) DEFAULT NULL COMMENT '团队ID',
  `ParcelID` bigint(20) NOT NULL DEFAULT '-1' COMMENT '统包ID',
  `CartType` int(11) DEFAULT NULL COMMENT '购物车类型',
  `CreateTime` datetime DEFAULT NULL COMMENT '加入时间',
  PRIMARY KEY (`CartID`),
  KEY `CustomerID` (`CustomerID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='购物车';

-- ----------------------------
-- Records of yz_cart_parcel
-- ----------------------------
INSERT INTO `yz_cart_parcel` VALUES ('5', '155', '821', '241', '1', '2017-03-13 15:28:45');
INSERT INTO `yz_cart_parcel` VALUES ('6', '155', '821', '162', '1', '2017-03-22 16:53:34');
INSERT INTO `yz_cart_parcel` VALUES ('7', '155', '821', '154', '1', '2017-03-22 16:55:46');
INSERT INTO `yz_cart_parcel` VALUES ('8', '155', '821', '154', '1', '2017-03-23 11:14:14');
INSERT INTO `yz_cart_parcel` VALUES ('9', '155', '821', '155', '1', '2017-03-23 11:14:22');
INSERT INTO `yz_cart_parcel` VALUES ('10', '155', '821', '209', '1', '2017-03-23 11:14:58');
INSERT INTO `yz_cart_parcel` VALUES ('11', '155', '821', '154', '1', '2017-03-24 10:12:38');
INSERT INTO `yz_cart_parcel` VALUES ('12', '155', '821', '154', '1', '2017-03-24 17:00:33');
INSERT INTO `yz_cart_parcel` VALUES ('13', '155', '821', '154', '1', '2017-03-29 15:11:43');

-- ----------------------------
-- Table structure for `yz_cart_ring`
-- ----------------------------
DROP TABLE IF EXISTS `yz_cart_ring`;
CREATE TABLE `yz_cart_ring` (
  `CartID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '购物车ID',
  `CustomerID` int(11) DEFAULT NULL COMMENT '客户ID',
  `UserID` int(11) DEFAULT NULL COMMENT '团队ID',
  `RingID` bigint(20) NOT NULL DEFAULT '-1' COMMENT '成品ID',
  `CartType` int(11) DEFAULT NULL COMMENT '购物车类型',
  `CreateTime` datetime DEFAULT NULL COMMENT '加入时间',
  PRIMARY KEY (`CartID`),
  KEY `CustomerID` (`CustomerID`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='购物车';

-- ----------------------------
-- Records of yz_cart_ring
-- ----------------------------
INSERT INTO `yz_cart_ring` VALUES ('17', '155', '821', '22', '1', '2017-03-23 12:05:14');
INSERT INTO `yz_cart_ring` VALUES ('18', '155', '821', '22', '1', '2017-03-23 16:11:24');
INSERT INTO `yz_cart_ring` VALUES ('20', '155', '821', '46', '1', '2017-03-23 16:40:14');
INSERT INTO `yz_cart_ring` VALUES ('22', '155', '821', '22', '1', '2017-03-24 12:00:31');
INSERT INTO `yz_cart_ring` VALUES ('25', '155', '821', '46', '1', '2017-03-24 16:08:57');
INSERT INTO `yz_cart_ring` VALUES ('26', '155', '821', '46', '1', '2017-03-24 16:09:15');
INSERT INTO `yz_cart_ring` VALUES ('29', '155', '821', '45', '1', '2017-03-27 11:52:10');
INSERT INTO `yz_cart_ring` VALUES ('30', '155', '821', '22', '1', '2017-03-28 14:42:53');
INSERT INTO `yz_cart_ring` VALUES ('31', '155', '821', '22', '1', '2017-03-28 14:53:06');
INSERT INTO `yz_cart_ring` VALUES ('32', '155', '821', '22', '1', '2017-03-29 14:26:28');
INSERT INTO `yz_cart_ring` VALUES ('33', '155', '821', '22', '1', '2017-03-29 14:26:31');
INSERT INTO `yz_cart_ring` VALUES ('34', '155', '821', '71', '1', '2017-03-29 14:55:26');
INSERT INTO `yz_cart_ring` VALUES ('35', '155', '821', '55', '1', '2017-03-29 14:55:42');
INSERT INTO `yz_cart_ring` VALUES ('36', '155', '821', '22', '1', '2017-03-30 16:25:30');
INSERT INTO `yz_cart_ring` VALUES ('37', '155', '821', '45', '1', '2017-03-30 16:25:55');

-- ----------------------------
-- Table structure for `yz_customer`
-- ----------------------------
DROP TABLE IF EXISTS `yz_customer`;
CREATE TABLE `yz_customer` (
  `CustomerID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) DEFAULT NULL,
  `UserPassword` varchar(32) DEFAULT NULL,
  `SalesUserID` int(11) DEFAULT NULL,
  `PurchaseUserID` int(11) DEFAULT NULL,
  `RealName` varchar(50) DEFAULT ' ' COMMENT '真实姓名',
  `NickName` varchar(45) DEFAULT NULL COMMENT '昵称',
  `CompanyName` varchar(100) DEFAULT NULL,
  `Rebate` decimal(11,2) DEFAULT '0.00' COMMENT '白钻折扣',
  `FancyRebate` decimal(11,2) DEFAULT '0.00' COMMENT '彩钻折扣',
  `Sex` tinyint(4) DEFAULT NULL COMMENT '性别：0.女,1.男',
  `QQ` varchar(12) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Mobile` varchar(15) DEFAULT NULL,
  `LoginCount` int(11) NOT NULL DEFAULT '0' COMMENT '登陆次数',
  `Comments` varchar(255) DEFAULT NULL,
  `LastActiveTime` datetime DEFAULT NULL,
  `ActiveIP` varchar(45) DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `CreateTime` datetime DEFAULT NULL,
  `ActiveArea` varchar(100) DEFAULT NULL,
  `Introducer` varchar(45) DEFAULT NULL COMMENT '介绍人',
  `Balance` decimal(11,3) unsigned zerofill DEFAULT '00000000.000' COMMENT '人民币账户余额',
  `USDBalance` decimal(10,3) unsigned zerofill DEFAULT '0000000.000' COMMENT '美金账户余额',
  `CustomerKey` varchar(45) DEFAULT NULL,
  `ValidDate` datetime DEFAULT NULL,
  `SysStatus` tinyint(4) DEFAULT NULL COMMENT '账号状态：-1.已逻辑删除，0.禁用，1.正常，2.待审核',
  `Url` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`CustomerID`),
  KEY `PurchaseUserID` (`PurchaseUserID`),
  KEY `SalesUserID` (`SalesUserID`)
) ENGINE=InnoDB AUTO_INCREMENT=196 DEFAULT CHARSET=utf8 COMMENT='客户表';

-- ----------------------------
-- Records of yz_customer
-- ----------------------------
INSERT INTO `yz_customer` VALUES ('155', 'shaofeng', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', '张9', 'SF', '9', '2.00', '5.00', '0', '9', '9', '18948797698', '867', '1234569', '2017-04-07 15:42:13', '::1', '2017-02-15 14:36:49', '2014-12-12 19:44:34', null, '9', '00000000.000', '0000000.000', 'B8C3B1F5D75ABA7383DC7C76F13D487B', '2017-05-28 00:00:00', '1', 'http://localhost:333/');
INSERT INTO `yz_customer` VALUES ('156', 'shunyi', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '821', '义', 'LSY', '', '2.00', '5.00', '2', '', '', '', '16', '', '2016-12-16 16:23:09', '::1', '2017-02-15 14:37:16', '2016-11-17 11:13:28', null, '', '00000111.000', '0000000.000', '11111', '2017-03-31 00:00:00', '-1', '');
INSERT INTO `yz_customer` VALUES ('178', 'lisili', '827CCB0EEA8A706C4C34A16891F84E7B', '821', '820', ' 丽', 'lisili', '', '0.00', '0.00', '0', 'j', '', '', '279', '', '2017-02-07 11:25:26', '::1', '2017-02-14 14:09:50', '2016-12-12 15:35:14', null, '', '00000000.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('186', 'liuxia', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', '刘霞', 'lx', '', '0.50', '1.50', '2', '', '', '18948797698', '0', 'a', null, null, '2017-02-14 14:03:26', '2016-12-24 14:46:07', null, '', '00000000.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('187', 'lisi', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', '刘霞', 'lx', 'ok', '2.00', '3.00', '2', '', '', '18948797698', '0', '刘霞liux', null, null, '2017-02-14 14:04:25', '2016-12-24 14:48:12', null, 'none', '00000111.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('188', 'liusy', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', ' Shine', 'lisili', '刘霞', '0.00', '0.00', '2', '', '', '18948797698', '0', 'shienlau', null, null, '2017-02-14 14:19:25', '2016-12-24 14:50:19', null, '刘健', '00000000.000', '0000011.000', 'AA65819F-B836FAAA-BB4D1024-65E7B6FB', '2017-12-15 00:00:00', '0', '');
INSERT INTO `yz_customer` VALUES ('189', 'rrr', 'EB9279982226A42AFDF2860DBDC29B45', '821', '820', 'rrr', 'rrr', '444', '5.00', '4.00', '2', '4', '4', '44', '0', '4444', null, null, null, '2017-01-11 17:27:33', null, null, '00000000.000', '0000111.000', null, null, '1', '444');
INSERT INTO `yz_customer` VALUES ('190', '1', 'C4CA4238A0B923820DCC509A6F75849B', '821', '821', '1', '1', '1', '1.00', '1.00', '2', '1', '1', '1', '0', '1', null, null, '2017-02-14 14:27:26', '2017-01-11 17:29:00', null, null, '00000000.000', '0000000.000', '1111111111111', '2017-02-25 00:00:00', '1', '1');
INSERT INTO `yz_customer` VALUES ('191', 'daxiong', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', '大熊', 'DX', '', '1.00', '2.00', '2', '', '', '18948797698', '0', '', null, null, null, '2017-02-20 10:29:38', null, null, '00000000.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('192', 'angular', 'E10ADC3949BA59ABBE56E057F20F883E', null, null, ' ', 'rose', null, '0.00', '0.00', '2', null, null, '15581246553', '0', null, null, null, null, '2017-03-15 09:47:19', null, null, '00000000.000', '0000000.000', null, null, '2', null);
INSERT INTO `yz_customer` VALUES ('193', 'testtest', 'E10ADC3949BA59ABBE56E057F20F883E', '821', '820', 'test', 'test', '', '0.00', '0.00', '2', '', '', '1852', '48', '', '2017-04-06 17:20:32', '::1', '2017-03-28 11:02:03', '2017-03-17 16:51:49', null, '', '00000000.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('194', 'king', 'E10ADC3949BA59ABBE56E057F20F883E', '910', '910', '金King', '金', '', '0.00', '1.00', '2', '', '', '456123', '0', '6艾米', null, null, null, '2017-03-30 11:36:15', null, null, '00000000.000', '0000000.000', null, null, '1', '');
INSERT INTO `yz_customer` VALUES ('195', 'gold', 'E10ADC3949BA59ABBE56E057F20F883E', '910', '820', '金gold', '金gold', '', '1.00', '0.50', '2', '', '', '5632', '0', '', null, null, null, '2017-03-30 11:36:58', null, null, '00000000.000', '0000000.000', null, null, '1', '');

-- ----------------------------
-- Table structure for `yz_exchange`
-- ----------------------------
DROP TABLE IF EXISTS `yz_exchange`;
CREATE TABLE `yz_exchange` (
  `ExID` int(11) NOT NULL AUTO_INCREMENT,
  `Exchange` decimal(10,5) unsigned DEFAULT NULL COMMENT '本次兑换汇率',
  `ExBalance` decimal(10,3) unsigned DEFAULT NULL COMMENT '本次兑换美金',
  `BankID` int(11) DEFAULT NULL COMMENT '支出账户ID',
  `ExAmount` decimal(10,3) unsigned DEFAULT NULL COMMENT '本次实际支出金额',
  `Amount` decimal(10,3) DEFAULT NULL,
  `Remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `CreateTime` date DEFAULT NULL COMMENT '兑换时间',
  `UserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ExID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_exchange
-- ----------------------------

-- ----------------------------
-- Table structure for `yz_flow`
-- ----------------------------
DROP TABLE IF EXISTS `yz_flow`;
CREATE TABLE `yz_flow` (
  `ID` int(10) NOT NULL AUTO_INCREMENT COMMENT '收支标识',
  `OrderIDs` varchar(800) DEFAULT NULL COMMENT '订单号',
  `CustomerID` int(4) DEFAULT NULL COMMENT '客户ID',
  `Account` tinyint(4) DEFAULT NULL COMMENT '银行账户 1工商 2建设 3中国 4农业 5支付宝 6微信 7HK美元账户',
  `Amount` decimal(10,3) unsigned DEFAULT NULL COMMENT '交易金额',
  `Currency` tinyint(4) DEFAULT NULL COMMENT '币种 1人民币 2美元',
  `Receivable` decimal(10,3) unsigned DEFAULT NULL COMMENT '记账金额',
  `Balance` decimal(10,3) DEFAULT NULL COMMENT '银行账户结余',
  `CustomerBalance` decimal(10,3) unsigned zerofill DEFAULT NULL COMMENT '客户余额',
  `ArrivalTime` date DEFAULT NULL COMMENT '到账日期',
  `Type` tinyint(4) DEFAULT NULL COMMENT '交易类型 收入 1 出货款 2 退回供应商 支出 3 自留现货 4到货',
  `Abstract` tinyint(4) DEFAULT NULL COMMENT '摘要 1充值 2消费 3退款 4提现',
  `Purpose` tinyint(4) DEFAULT NULL COMMENT '用途 1 裸钻 2换美金 3杂项 4借款 5还款',
  `Others` varchar(255) DEFAULT NULL COMMENT '他人',
  `Remarks` varchar(255) DEFAULT NULL COMMENT '申请备注',
  `ReviewID` int(4) DEFAULT NULL COMMENT '审核人ID',
  `UpdateTime` datetime DEFAULT NULL COMMENT '审核时间',
  `ApplyID` int(11) DEFAULT NULL COMMENT '申请人ID',
  `CreateTime` datetime DEFAULT NULL COMMENT '申请时间',
  `Status` tinyint(4) DEFAULT NULL COMMENT '状态 1正常 0待审 -1作废',
  `Comments` varchar(255) DEFAULT NULL COMMENT '审核备注',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_flow
-- ----------------------------
INSERT INTO `yz_flow` VALUES ('1', '41,23,16', null, '21', '1833.000', '1', null, '167.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 17:54:18', '712', '2017-03-27 17:54:18', '1', null);
INSERT INTO `yz_flow` VALUES ('2', '52', null, '7', '500.000', '2', null, '1500.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 17:59:02', '712', '2017-03-27 17:59:02', '1', null);
INSERT INTO `yz_flow` VALUES ('3', '52', null, '7', '77.000', '2', null, '1423.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 17:59:28', '712', '2017-03-27 17:59:28', '1', null);
INSERT INTO `yz_flow` VALUES ('4', '52', null, '7', '23.000', '2', null, '1400.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 17:59:51', '712', '2017-03-27 17:59:51', '1', null);
INSERT INTO `yz_flow` VALUES ('5', '50', null, '7', '600.000', '2', null, '800.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:00:13', '712', '2017-03-27 18:00:13', '1', null);
INSERT INTO `yz_flow` VALUES ('6', '51', null, '7', '500.000', '2', null, '300.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:00:29', '712', '2017-03-27 18:00:29', '1', null);
INSERT INTO `yz_flow` VALUES ('7', '51', null, '7', '88.000', '2', null, '212.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:01:18', '712', '2017-03-27 18:01:18', '1', null);
INSERT INTO `yz_flow` VALUES ('8', '51', null, '7', '10.000', '2', null, '202.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:02:45', '712', '2017-03-27 18:02:45', '1', null);
INSERT INTO `yz_flow` VALUES ('9', '51', null, '7', '0.550', '2', null, '201.450', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:02:57', '712', '2017-03-27 18:02:57', '1', null);
INSERT INTO `yz_flow` VALUES ('10', '51', null, '7', '1.450', '2', null, '200.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:03:28', '712', '2017-03-27 18:03:28', '1', null);
INSERT INTO `yz_flow` VALUES ('11', '18', null, '21', '167.000', '1', null, '0.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:03:51', '712', '2017-03-27 18:03:51', '1', null);
INSERT INTO `yz_flow` VALUES ('12', '18', null, '21', '99.000', '1', null, '456.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:04:29', '712', '2017-03-27 18:04:29', '1', null);
INSERT INTO `yz_flow` VALUES ('13', '18', null, '21', '399.500', '1', null, '56.500', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:04:46', '712', '2017-03-27 18:04:46', '1', null);
INSERT INTO `yz_flow` VALUES ('14', '18', null, '21', '0.500', '1', null, '56.000', null, '2017-03-27', '2', '0', '1', null, null, '712', '2017-03-27 18:05:04', '712', '2017-03-27 18:05:04', '1', null);

-- ----------------------------
-- Table structure for `yz_notice`
-- ----------------------------
DROP TABLE IF EXISTS `yz_notice`;
CREATE TABLE `yz_notice` (
  `NoticeID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL COMMENT '发布者',
  `Title` varchar(100) DEFAULT NULL COMMENT '标题',
  `Content` varchar(500) DEFAULT NULL COMMENT '正文',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `Status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `Reader` tinyint(4) DEFAULT NULL COMMENT '受众 0不限 1客户 2团队',
  `PageView` int(11) DEFAULT '0' COMMENT '浏览量',
  PRIMARY KEY (`NoticeID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_notice
-- ----------------------------
INSERT INTO `yz_notice` VALUES ('1', '712', 'WAP版上线', '手机浏览器输入eegia.com将自动跳转到WAP版wap.eegia.com，仅供客户使用。', '2016-12-26 17:10:42', '1', '0', '7');
INSERT INTO `yz_notice` VALUES ('2', '712', '333', '2324324234', '2016-12-30 14:38:57', '1', '1', null);
INSERT INTO `yz_notice` VALUES ('3', '712', '333', '333gfgfgfg', '2016-12-30 14:51:32', '1', '2', '2');
INSERT INTO `yz_notice` VALUES ('4', '712', 'q', 'q', '2016-12-30 14:58:41', '0', '2', '4');
INSERT INTO `yz_notice` VALUES ('5', '712', 'test', 'testete', '2017-01-05 11:23:46', '1', '2', '4');
INSERT INTO `yz_notice` VALUES ('6', null, null, null, null, null, null, '0');

-- ----------------------------
-- Table structure for `yz_order`
-- ----------------------------
DROP TABLE IF EXISTS `yz_order`;
CREATE TABLE `yz_order` (
  `OrderID` bigint(20) NOT NULL AUTO_INCREMENT,
  `OrderStatus` int(11) DEFAULT NULL COMMENT '订单状态：0.已逻辑删除,1.待确认,2.采购中,3.未付款,4.待发货,5.已出货,6.已完成,7,已取消 8,已退货,9,已作废',
  `CurType` tinyint(4) DEFAULT NULL COMMENT '到货结算币种',
  `PaymentStatus` int(11) DEFAULT NULL COMMENT '收款状态：0未收 1已收',
  `PayTime` datetime DEFAULT NULL COMMENT '收款时间',
  `ReceiptPrice` decimal(10,2) DEFAULT NULL COMMENT '未清金额',
  `ReceiptStatus` int(11) DEFAULT NULL COMMENT '付款状态 0 未付 1已付',
  `RecTime` datetime DEFAULT NULL COMMENT '付款时间',
  `InventoryID` bigint(20) DEFAULT NULL,
  `SN` varchar(20) DEFAULT NULL COMMENT '货号',
  `CustomerID` bigint(20) DEFAULT NULL,
  `SalesUserID` int(11) DEFAULT NULL COMMENT '销售员ID',
  `PurchaseUserID` int(11) DEFAULT NULL COMMENT '采购员ID',
  `SupplierCode` varchar(20) DEFAULT NULL,
  `OrderType` int(11) NOT NULL DEFAULT '0' COMMENT '订单类别（1、客户自己下单2 代下单）',
  `CreateTime` datetime DEFAULT NULL COMMENT '下单时间',
  `DeliveryTime` datetime DEFAULT NULL COMMENT '发货时间',
  `ArrivalTime` datetime DEFAULT NULL COMMENT '入库时间',
  `Arrival` int(11) DEFAULT '0' COMMENT '入库(0 待入库 1已入库)',
  `Freight` decimal(10,0) DEFAULT NULL COMMENT '运费',
  `SalesExchangerate` decimal(10,3) DEFAULT '1.000' COMMENT '销售汇率',
  `PurchaseExchangerate` decimal(10,5) DEFAULT '1.00000' COMMENT '采购汇率',
  `DiscountReturn` decimal(10,3) DEFAULT NULL COMMENT '买入退点',
  `PriceUSD` decimal(10,3) DEFAULT NULL COMMENT '买入美金总价',
  `PurchaseRMB` decimal(10,3) DEFAULT NULL COMMENT '采购RMB',
  `Confirmdiscount` double(10,3) DEFAULT NULL COMMENT '卖出退点',
  `ConfirmPrice` decimal(10,3) DEFAULT NULL COMMENT '卖出人民币总价',
  `ConfirmUSD` decimal(10,3) DEFAULT NULL COMMENT '卖出usd',
  `OriginSN` varchar(255) DEFAULT NULL COMMENT '原货号',
  `Remarks` varchar(255) DEFAULT NULL COMMENT '客户备注',
  `SalesRemarks` varchar(255) DEFAULT NULL COMMENT '销售员备注',
  `PurchaseRemarks` varchar(255) DEFAULT NULL COMMENT '采购员备注',
  `GoodsRemark` varchar(255) DEFAULT NULL COMMENT '取货员备注',
  `Shape` int(11) DEFAULT NULL,
  `Weight` double DEFAULT NULL,
  `CertType` varchar(10) DEFAULT NULL,
  `CertNo` varchar(255) DEFAULT NULL,
  `Clarity` varchar(10) DEFAULT NULL,
  `IsFancy` int(4) DEFAULT NULL,
  `Color` varchar(255) DEFAULT NULL,
  `Cut` varchar(12) DEFAULT NULL,
  `Place` varchar(50) DEFAULT NULL,
  `Polish` varchar(10) DEFAULT NULL,
  `Symmetry` varchar(10) DEFAULT NULL,
  `Fluorescence` varchar(20) DEFAULT NULL,
  `Measurement` varchar(255) DEFAULT NULL,
  `Rapnet` decimal(11,0) DEFAULT NULL,
  `Milky` varchar(50) DEFAULT NULL,
  `Hue` varchar(100) DEFAULT NULL,
  `HA` varchar(10) DEFAULT NULL,
  `BlackDefect` varchar(255) DEFAULT NULL,
  `OtherDefect` varchar(255) DEFAULT NULL,
  `EyeClean` varchar(10) DEFAULT NULL,
  `GoodsStatus` int(11) DEFAULT NULL COMMENT '货品状态',
  `ShipNo` varchar(255) DEFAULT NULL COMMENT '出货单号',
  `ShipTime` datetime DEFAULT NULL,
  `ShipRemarks` varchar(255) DEFAULT NULL COMMENT '出货备注',
  `Online` int(11) DEFAULT NULL COMMENT '回库状态 1已回库',
  PRIMARY KEY (`OrderID`),
  KEY `InventoryID` (`InventoryID`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='订单表';

-- ----------------------------
-- Records of yz_order
-- ----------------------------
INSERT INTO `yz_order` VALUES ('1', '5', null, '1', '2017-03-22 11:48:05', null, '0', '2017-03-21 00:00:00', '5862553', '5862553', '187', '821', '820', 'C.D', '1', '2017-02-28 17:10:02', null, null, '0', null, '7.020', '6.98000', '-14.375', '600.000', null, '-10.375', '500.000', '650.000', 'L550019101', '', 'ddd', null, null, '1', '0.2', 'NN', '', 'SI2', null, 'L', 'EX', 'IND', 'VG', 'VG', 'F', '3.78x3.77x2.30', '480', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '20150518', '2017-03-20 15:05:19', '34234324', '0');
INSERT INTO `yz_order` VALUES ('2', '3', null, '1', null, null, '0', '2017-03-21 14:58:34', '5975535', 'G6232798300', '155', '821', '820', 'LAXMI', '4', '2017-03-01 16:03:42', '2017-03-01 00:00:00', '2017-03-29 00:00:00', '1', null, '7.020', '6.98000', '0.000', '600.000', '4444.000', null, '500.000', '650.000', 'LD16092946', '测试', '435435', 'test4', null, '10', '0.34', 'GIA', '6232798300', 'SI1', '1', 'Fancy Deep Green-Yellow', 'NN', 'IND', 'VG', 'GD', 'M', '4.02-4.06x2.53', '0', 'ML0', 'BR0 GR0', 'Y', 'TB0 SB0', 'OI1', null, null, '20150437', '2017-03-20 15:04:38', '佛挡杀佛的发3', '0');
INSERT INTO `yz_order` VALUES ('3', '3', null, '1', null, null, '0', '2017-03-21 14:58:34', '4694045', '4694045', '155', '821', '820', 'DiamondstarInc', '4', '2017-03-01 16:08:59', null, null, '0', null, '7.020', '6.98000', '-18.000', '600.000', null, '-14.000', '500.000', '650.000', '1874P', '测试', 'rff', null, null, '6', '0.23', 'NN', '', 'I1', null, 'E', 'NN', 'USA', 'VG', 'GD', 'NN', '5.11x3.25x2.2', '600', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:05:39', '发佛挡杀佛', '0');
INSERT INTO `yz_order` VALUES ('4', '6', null, '1', '2017-03-22 17:08:52', null, '0', '2017-03-21 14:58:34', '4916741', 'I119459164', '188', '821', '820', 'JanamCorporation', '4', '2017-03-01 16:40:48', null, null, '0', null, '7.020', '6.98000', '-15.070', '600.000', null, '-11.070', '500.000', '650.000', 'JPR3710', '3333;测试', '435435', '333;', '333;', '2', '0.22', 'IGI', '119459164', 'SI2', null, 'F', 'VG', 'IND', 'GD', 'GD', 'N', '3.31x3.29x2.3', '710', 'NA', 'NA', 'NA', '', '', null, null, '20145915', '2017-03-20 14:59:16', '制单+出货二合一', '0');
INSERT INTO `yz_order` VALUES ('5', '3', null, '1', null, null, '0', '2017-03-21 14:58:34', '4694197', '4694197', '187', '821', '820', 'DiamondstarInc', '4', '2017-03-01 16:43:04', null, null, '0', null, '7.020', '6.98000', '-48.000', '600.000', null, '-44.000', '500.000', '650.000', '1393E', '测试', 'rff', null, null, '3', '0.31', 'NN', '', 'SI3', null, 'K', 'NN', 'USA', 'VG', 'VG', 'N', '4.54x3.1x2.34', '700', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:05:19', '34234324', '0');
INSERT INTO `yz_order` VALUES ('6', '3', null, '0', null, null, '1', '2017-03-21 14:58:34', '6157684', 'G2237760934', '155', '821', '820', 'SJuwalCo', '4', '2017-03-01 16:43:11', null, null, '0', null, '7.020', '6.98000', '-40.000', '600.000', null, '-36.000', '500.000', '650.000', '20169B20D', '测试', null, null, null, '6', '0.23', 'GIA', '2237760934', 'SI2', null, 'E', 'NN', 'CHN', 'VG', 'FR', 'M', '5.97x3.01x1.96', '840', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:04:38', '佛挡杀佛的发3', '0');
INSERT INTO `yz_order` VALUES ('7', '4', null, '1', '2017-03-23 16:41:22', null, '1', '2017-03-27 00:00:00', '4694867', '4694867', '188', '821', '820', 'DiamondstarInc', '4', '2017-03-01 16:44:13', '2017-03-23 00:00:00', null, '0', null, '7.020', '6.98000', '-63.000', '600.000', '332.000', '-59.000', '500.000', '650.000', '5082M', '测试', '5', 'Test', null, '7', '0.4', 'NN', '56743', 'I2', null, 'F', 'NN', 'USA', 'VG', 'VG', 'N', '7.05x3.81x2.44', '800', 'NA', 'NA', 'NA', '', '', null, null, '22165128', '2017-03-22 16:51:29', 'bv', '0');
INSERT INTO `yz_order` VALUES ('8', '3', null, '0', null, null, '1', '2017-03-21 14:58:34', '4916253', 'G2227431111', '155', '821', '820', 'JanamCorporation', '4', '2017-03-01 16:44:14', '2017-03-01 00:00:00', null, '0', null, '7.020', '6.98000', '-20.000', '600.000', '8520.000', '14.000', '500.000', '650.000', 'JMQ10009', '测试', 'dd', '修改4C', null, '7', '0.258', 'GIA', '2227431111', 'SI2', null, 'N', 'NN', 'IND', 'VG', 'VG', 'F', '6.31x3.27x2.09', '430', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 14:59:16', '制单+出货二合一', '0');
INSERT INTO `yz_order` VALUES ('9', '7', null, '0', null, null, '1', '2017-03-21 14:27:27', '4694751', '4694751', '155', '821', '820', 'DiamondstarInc', '4', '2017-03-01 16:59:10', null, null, '0', null, '7.020', '6.98000', '-34.941', '600.000', null, '-30.941', '500.000', '650.000', '4214R', '测试', null, null, null, '1', '0.23', 'NN', '', 'VS2', null, 'K', 'NN', 'USA', 'VG', 'VG', 'N', '3.87x3.79x2.46', '850', 'NA', 'NA', 'NA', '', '', null, null, '20152738', '2017-03-20 15:27:38', '费大幅度', '0');
INSERT INTO `yz_order` VALUES ('10', '7', null, '0', null, null, '1', '2017-03-21 14:31:27', '4653110', 'I3054542B', '187', '821', '820', 'Pluczenik', '4', '2017-03-01 16:59:33', '2017-03-01 00:00:00', null, '0', null, '7.020', '6.98000', '-30.000', '600.000', '111.000', '-26.000', '500.000', '650.000', '1346327', '测试', 'dd', '白 -30', null, '2', '0.379', 'IGI', '3054542B', 'I2', null, 'J', 'NN', 'CHN', 'GD', 'NN', 'N', '4.21x3.77x2.89', '500', 'NA', 'NA', 'NA', '', '', null, null, '20152728', '2017-03-20 15:27:28', '范德萨发生的34234', '0');
INSERT INTO `yz_order` VALUES ('11', '3', null, '0', null, null, '1', '2017-03-21 14:39:47', '4695020', '4695020', '155', '821', '820', 'DiamondstarInc', '4', '2017-03-01 16:59:33', '2017-03-01 00:00:00', null, '0', null, '7.020', '6.98000', '-30.000', '600.000', null, '-26.000', '500.000', '650.000', '674E', '测试;测试', '5', '324234234', null, '3', '0.27', 'NN', '56543434', 'SI3', null, 'E', 'NN', 'USA', 'VG', 'VG', 'N', '4.82x3.08x1.95', '710', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:48:27', '34234234', '0');
INSERT INTO `yz_order` VALUES ('12', '3', null, '0', null, null, '0', null, '4915600', 'I108443213', '155', '821', '820', 'JanamCorporation', '4', '2017-03-01 16:59:33', null, null, '0', null, '7.020', '6.98000', '-16.056', '600.000', null, '-12.056', '500.000', '650.000', 'JEM2702', '测试', '5', null, null, '3', '0.22', 'IGI', '108443213', 'VVS2', null, 'L', 'GD', 'IND', 'FR', 'FR', 'VSL', '3.91x2.96x2.18', '710', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:17:17', '4', '0');
INSERT INTO `yz_order` VALUES ('13', '4', null, '0', '2017-03-23 16:41:22', null, '0', '2017-03-27 00:00:00', '873400', 'G7216964987', '188', '821', '820', 'RIJIYA', '1', '2017-03-02 11:47:59', '2017-03-29 00:00:00', null, '0', null, '7.020', '6.98000', '-78.000', '110.880', '111.000', '-73.000', '500.000', '650.000', '7216964987', 'fdsfsdf', '5', 'test', null, '1', '0.42', 'GIA', '7216964987', 'SI1', null, 'Q-R', 'VG', 'IND', 'EX', 'VG', 'N', '4.74-4.70x2.98', '1200', 'ML0', 'BR2', 'N', 'BK0', 'I0 TO0 SO0', null, null, '22165504', '2017-03-22 16:55:05', 'ty', '0');
INSERT INTO `yz_order` VALUES ('14', '3', null, '0', null, null, '0', '2017-03-21 14:39:52', '4916573', 'I159541844', '155', '821', '820', 'JanamCorporation', '1', '2017-03-02 11:47:59', null, null, '0', null, '7.020', '6.98000', '-15.000', '600.000', null, '-11.000', '500.000', '650.000', 'JPS6755', 'fdsfsdf', 'rff', null, null, '6', '0.27', 'IGI', '159541844', 'SI2', null, 'K', 'VG', 'IND', 'GD', 'GD', 'N', '5.31x3.61x2.29', '520', 'NA', 'NA', 'NA', '', '', null, null, '29141043', '2017-03-20 15:17:17', '4', '0');
INSERT INTO `yz_order` VALUES ('15', '3', null, '0', null, null, '0', null, '5930121', '-', '155', '821', '820', 'HST', '3', '2017-03-03 00:00:00', null, null, '0', null, '7.020', '6.98000', '-34.505', '600.000', null, '-20.000', '500.000', '650.000', '1119', null, 'fdfdf', null, null, '1', '11.08', 'GIA', '124930490', 'VS2', null, 'Q-R', 'EX', null, 'EX', 'EX', 'N', null, '16000', null, null, null, null, null, null, null, '29141043', '2017-03-20 15:27:38', '费大幅度', '0');
INSERT INTO `yz_order` VALUES ('16', '4', '1', '0', '2017-03-23 16:41:47', null, '1', '2017-03-27 00:00:00', '5930121', '-', '188', '821', '820', 'HST', '3', '2017-03-03 00:00:00', '2017-03-23 00:00:00', null, '0', null, '7.020', '6.98000', '-34.505', '600.000', '888.000', '-22.000', '500.000', '650.000', '1119', null, 'fdfsdf', 'test', null, '1', '11.08', 'GIA', '124930491', 'VS2', null, 'Q-R', 'EX', null, 'EX', 'EX', 'N', null, '16000', null, null, null, null, null, null, null, '29135324', '2017-03-22 16:51:29', 'bv', '0');
INSERT INTO `yz_order` VALUES ('17', '5', null, '0', null, null, '0', null, '4916958', '-', '155', '821', '820', '', '3', '2017-03-03 00:00:00', null, null, '0', null, '7.020', '6.98000', '-14.000', '600.000', null, '-20.000', '500.000', '650.000', 'JMQ7119', '', 'test', null, null, '7', '0.24', 'GIA', '2206111622', 'I1', null, 'D', 'NN', null, 'VG', 'GD', 'N', null, '600', null, null, null, null, null, null, null, '20151653', '2017-03-20 15:16:54', '3订单', '0');
INSERT INTO `yz_order` VALUES ('18', '4', '1', '0', '2017-03-23 16:41:47', null, '1', '2017-03-27 00:00:00', null, '-', '188', '821', '820', 'DIAMTRADE', '3', '2017-03-03 00:00:00', '2017-03-03 00:00:00', null, '0', null, '7.020', '6.98000', '0.000', '600.000', '666.000', '-20.000', '500.000', '650.000', '666', '', 'fdf', '66666', null, '9', '0.32', 'HRD', 'sdfsdfd3323', 'SI1', null, 'S-T', 'VG', null, 'VG', 'VG', 'F', null, '700', null, null, null, null, null, null, null, '29135324', '2017-03-22 16:50:54', '确认出货', '0');
INSERT INTO `yz_order` VALUES ('19', '3', null, '0', null, null, '0', '2017-03-21 15:12:24', null, '-', '155', '821', '820', 'SZ', '3', '2017-03-03 00:00:00', '2017-03-21 00:00:00', null, '0', null, '7.020', '6.98000', '-30.000', '600.000', '853.000', '-20.000', '500.000', '650.000', '5263', null, null, '853', null, '8', '0.56', 'EGL', '0', 'I2', null, 'S-T', 'EX', null, 'EX', 'NN', 'VS', null, '600', null, null, null, null, null, null, null, '29141043', '2017-03-20 15:27:22', '法第三方第三方', '0');
INSERT INTO `yz_order` VALUES ('20', '3', null, '0', null, null, '0', '2017-03-21 15:12:33', null, '-', '155', '821', '820', 'SZ', '3', '2017-03-03 00:00:00', '2017-03-23 00:00:00', null, '0', null, '7.020', '6.98000', '-30.000', '600.000', '888.000', '-20.001', '500.000', '650.000', '', null, '5', '888 rmb', null, '1', '0.23', 'HRD', '32323', 'I3', null, 'S-T', 'VG', null, 'VG', 'FR', 'F', null, '180', null, null, null, null, null, null, null, '29141043', '2017-03-20 15:16:54', '3订单', '0');
INSERT INTO `yz_order` VALUES ('21', '3', null, '0', null, null, '0', '2017-03-22 00:00:00', null, '-', '155', '821', '820', '', '3', '2017-03-03 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '-20.001', '500.000', '650.000', '', null, '退回', null, null, '1', '0.2', 'HRD', '12', 'I3', null, 'S-T', 'NN', null, 'FR', 'FR', 'F', null, '160', null, null, null, null, null, null, null, '29141043', '2017-03-20 15:17:17', '4', '0');
INSERT INTO `yz_order` VALUES ('22', '5', null, '0', null, null, '0', null, null, '-', '187', '821', '820', '', '3', '2017-03-03 00:00:00', null, null, '0', null, '7.020', '6.98000', '-29.060', '600.000', null, '69.083', '500.000', '650.000', '526', '', 'fdfsdf', null, null, '9', '0.52', 'GIA', '234', 'SI3', null, 'Y-Z', 'GD', null, 'FR', 'FR', 'F', null, '900', null, null, null, null, null, null, null, '20152728', '2017-03-20 15:27:28', '范德萨发生的34234', '0');
INSERT INTO `yz_order` VALUES ('23', '4', '1', '0', '2017-03-23 16:41:22', null, '1', '2017-03-27 00:00:00', null, '-', '188', '821', '820', 'HEAVENST', '3', '2017-03-03 00:00:00', '2017-03-24 00:00:00', null, '0', null, '7.020', '6.98000', '-20.000', '600.000', '400.000', '-20.000', '500.000', '650.000', '', null, null, 'a', null, '1', '1', 'NGTC', '123232', 'SI1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '8200', null, null, null, null, null, null, null, '22165054', '2017-03-22 16:50:54', '确认出货', '0');
INSERT INTO `yz_order` VALUES ('24', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', '', '3', '2017-03-03 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, null, null, null, '1', '2', 'GIA', '', 'SI1', null, 'S-T', 'VG', null, 'VG', 'VG', 'N', null, '5000', null, null, null, null, null, null, null, '29141043', '2017-03-20 14:26:18', 'fdsfsdf', '0');
INSERT INTO `yz_order` VALUES ('25', '3', null, '0', null, null, '0', '2017-03-21 15:12:39', null, '-', '155', '821', '820', 'SZ', '3', '2017-03-07 00:00:00', '2017-03-05 00:00:00', null, '0', null, '7.100', '6.98000', '-33.438', '600.000', '3700.000', '-31.849', '500.000', '650.000', '', null, 'xy', '3700 rmb', null, '1', '0.5', 'GIA', '5246921598', 'SI1', null, 'G', 'EX', null, 'EX', 'EX', 'N', null, '3100', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('26', '5', null, '0', null, null, '1', '2017-03-21 15:12:45', null, '-', '155', '821', '909', 'SZ', '3', '2017-03-07 00:00:00', '2017-03-06 00:00:00', null, '0', null, '7.020', '6.98000', '-28.970', '600.000', '520.000', '-20.000', '500.000', '650.000', '454', '', 'fdfsdf', '520', null, '1', '0.6', 'GIA', '5171830004', 'VVS1', null, 'E', 'EX', null, 'EX', 'EX', 'N', null, '5500', null, null, null, null, null, null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('27', '3', null, '0', '2017-03-22 17:08:52', null, '0', '2017-03-22 13:06:56', null, '-', '188', '821', '820', 'SZ', '3', '2017-03-07 00:00:00', '2017-03-21 00:00:00', null, '0', null, '7.020', '6.98000', '0.000', '600.000', '850.000', null, '500.000', '650.000', '', 'j,', 'd', '600 850', null, '9', '0.11', 'NN', 'ddd', 'SI1', '1', 'FDY', 'EX', null, 'EX', 'EX', 'N', null, '0', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('28', '5', null, '1', null, null, '1', '2017-03-22 13:07:07', null, '-', '155', '821', '910', 'SZ', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '23.000', '500.000', '650.000', '', '', '42343242a', null, null, '9', '0.11', 'HRD', '11113434', 'SI1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '0', null, null, null, null, null, null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('29', '3', null, '0', null, null, '0', '2017-03-21 14:58:34', null, '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '2.000', '500.000', '650.000', '', '', 'sfdf', null, null, '9', '0.11', 'GIA', '3323', 'SI1', null, 'S-T', 'EX', null, 'EX', 'EX', 'N', null, '0', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('30', '5', null, '0', '2017-03-21 17:40:33', null, '0', null, null, '-', '187', '821', '909', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '1.000', '600.000', null, '-20.000', '500.000', '650.000', '', '', 'test', null, null, '1', '0.23', 'GIA', '3243', 'SI1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '1030', null, null, null, null, null, null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('31', '3', null, '0', '2017-03-21 17:40:43', null, '0', null, null, '-', '187', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '1.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, 'h', null, null, '1', '0.23', 'GIA', '3243', 'SI1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '1030', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('32', '5', null, '0', null, null, '0', null, null, '-', '187', '821', '910', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', null, '600.000', null, null, '500.000', '650.000', '', '', '42343242a', null, null, '9', '0.12', 'GIA', '44342', 'SI2', null, 'S-T', 'EX', null, 'EX', 'EX', 'N', null, '0', null, null, null, null, null, null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('33', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, 'xy', null, null, '5', '1', 'GIA', '5246921598', 'SI1', null, 'S-T', 'EX', null, 'EX', 'EX', 'N', null, '2100', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('34', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', null, '600.000', null, null, '500.000', '650.000', '', null, 'd', null, null, '9', '0.11', 'HRD', '324324', 'I2', null, 'S-T', 'NN', null, 'NN', 'NN', 'NN', null, '0', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('35', '6', null, '0', '2017-03-22 17:11:59', null, '0', null, null, '-', '188', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, 'zl', null, null, '2', '0.52', 'GIA', '5246921598', 'SI1', null, 'Q-R', 'EX', null, 'EX', 'EX', 'N', null, '1100', null, null, null, null, null, null, null, '22165054', '2017-03-22 16:50:54', '确认出货', '0');
INSERT INTO `yz_order` VALUES ('36', '3', null, '0', null, null, '0', null, null, '-', '187', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '1.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, '的', null, null, '1', '0.521', 'GIA', '0419', 'VVS1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '6400', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('37', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '0.000', '600.000', null, '-20.000', '500.000', '650.000', '', null, 'g', null, null, '1', '0.52', 'GIA', '11', 'SI1', null, 'D', 'EX', null, 'EX', 'EX', 'N', null, '3600', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('38', '3', null, '0', null, null, '0', '2017-03-21 14:58:34', '4982544', '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '-56.000', '600.000', null, '-53.000', '500.000', '650.000', 'JRD6219', '', 'dd', null, null, '1', '0.3', 'IGI', '146467763', 'SI2', null, 'U-V', 'VG', null, 'GD', 'GD', 'VSL', null, '900', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('39', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', 'HEAVENST', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.080', '6.98000', '-22.000', '600.000', null, '-18.393', '500.000', '650.000', 'sr1', null, 'xy', null, null, '1', '0.5', 'GIA', '72487454412', 'SI2', null, 'K', 'VG', null, 'EX', 'EX', 'N', null, '1800', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('40', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', 'HEAVENST', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.080', '6.98000', '-22.000', '600.000', null, '-19.993', '500.000', '650.000', 'sr2', '', 'dfsdfsdfsdf', null, null, '1', '0.51', 'IGI', '5246921598', 'SI2', null, 'K', 'EX', null, 'EX', 'EX', 'N', null, '1800', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('41', '4', '1', '0', '2017-03-22 17:11:59', null, '1', '2017-03-27 00:00:00', null, '-', '188', '821', '820', 'DIAMTRADE', '3', '2017-03-07 00:00:00', '2017-03-27 00:00:00', null, '0', null, '7.080', '6.98000', '-22.000', '600.000', '545.000', '-21.532', '500.000', '650.000', 'sr3', null, null, 'test', null, '1', '0.52', 'NGTC', '62425894972', 'SI2', null, 'K', 'EX', null, 'VG', 'VG', 'N', null, '1800', null, null, null, null, null, null, null, '29135434', '2017-03-22 16:55:05', 'ty', '0');
INSERT INTO `yz_order` VALUES ('42', '3', null, '0', '2017-03-21 17:42:58', null, '0', null, null, '-', '187', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.080', '6.98000', '-22.000', '600.000', null, '-18.393', '500.000', '650.000', 'sr5', null, null, null, null, '1', '0.5', 'EGL', '3245849948', 'SI2', null, 'K', 'EX', null, 'EX', 'VG', 'N', null, '1800', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('43', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.080', '6.98000', '-22.000', '600.000', null, '-30.051', '500.000', '650.000', 'sr6', null, 'xy', null, null, '1', '0.5', 'GIA', '1245358557', 'VS1', null, 'K', 'GD', null, 'VG', 'EX', 'N', null, '2100', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('44', '3', null, '0', null, null, '0', null, null, '-', '155', '821', '820', 'HEAVENST', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.080', '6.98000', '-22.000', '600.000', null, '-19.993', '500.000', '650.000', 'sr2', null, '发', null, null, '1', '0.51', 'IGI', '62427818652', 'SI2', null, 'K', 'EX', null, 'EX', 'EX', 'N', null, '1800', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('45', '3', null, '0', null, null, '0', null, '4916387', '-', '155', '821', '820', '', '3', '2017-03-07 00:00:00', null, null, '0', null, '7.020', '6.98000', '-2.083', '600.000', null, '-20.000', '500.000', '650.000', 'JRD6752', '', '2', null, null, '1', '0.25', 'IGI', '159541851', 'SI2', null, 'M', 'VG', null, 'VG', 'GD', 'VSL', null, '480', null, null, null, null, null, null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('46', '5', null, '0', null, null, '0', null, '4884013', 'IF6G63642', '155', '821', '820', 'AMC', '1', '2017-03-09 11:50:04', null, null, '0', null, '7.020', '6.98000', '-37.000', '600.000', null, '-33.000', '500.000', '650.000', '576763', '', 'test', null, null, '1', '0.6', 'IGI', 'F6G63642', 'VVS2', null, 'H', 'EX', 'BEL', 'EX', 'EX', 'F', '5.35x5.38x3.33', '3800', 'NA', 'NA', 'NA', '', '', null, null, '29141043', null, null, '0');
INSERT INTO `yz_order` VALUES ('47', '5', null, '0', '2017-03-21 15:59:04', null, '0', null, '6212582', '6212582', '155', '821', '820', 'C.D', '1', '2017-03-09 11:50:04', null, null, '0', null, '7.020', '6.98000', '2.083', '600.000', null, '6.083', '500.000', '650.000', 'L430009202', '', 'fdsfs', null, null, '1', '0.21', 'NN', '', 'SI1', null, 'M', 'EX', 'IND', 'VG', 'VG', 'N', '3.93x3.89x2.31', '480', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '0329142058', null, null, '0');
INSERT INTO `yz_order` VALUES ('48', '3', null, '0', '2017-03-21 15:59:04', null, '0', null, '6235466', '6235466', '155', '821', '820', 'C.D', '1', '2017-03-15 15:00:23', null, '2017-03-29 00:00:00', '1', null, '7.020', '6.98000', '-1.458', '600.000', null, '2.542', '500.000', '650.000', 'L610009301', '阿凡达根深蒂固发', '1500rmb1950usd3pcs', null, null, '1', '0.21', 'NN', '', 'SI2', null, 'K', 'VG', 'IND', 'VG', 'VG', 'M', '3.92x3.88x2.29', '480', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '0329142058', null, null, '0');
INSERT INTO `yz_order` VALUES ('49', '3', null, '0', '2017-03-21 15:59:04', null, '0', null, '5605254', '5605254', '155', '821', '820', 'C.D', '1', '2017-03-20 17:21:57', null, '2017-03-29 00:00:00', '1', null, '7.020', '6.98000', '-31.646', '600.000', null, '-27.646', '500.000', '650.000', '161000902', '', '1500rmb1950usd3pcs', null, null, '1', '0.2', 'NN', '', 'VVS2', null, 'L', 'EX', 'IND', 'VG', 'VG', 'M', '3.81x3.78x2.34', '790', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '0329142058', null, null, '0');
INSERT INTO `yz_order` VALUES ('50', '4', '2', '0', null, null, '1', '2017-03-27 00:00:00', '5798950', '5798950', '155', '821', '820', 'C.D', '2', '2017-03-22 15:13:40', null, null, '0', '5', '7.020', '6.98000', '-32.152', '600.000', null, '-28.152', '500.000', '650.000', 'L390047301', 'dsadasd', '查', null, null, '1', '0.21', 'NN', '', 'VVS2', null, 'L', 'EX', 'IND', 'VG', 'VG', 'N', '3.84x3.81x2.39', '790', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '29141205', '2017-03-29 14:12:05', '0329141145', '0');
INSERT INTO `yz_order` VALUES ('51', '4', '2', '0', null, null, '1', '2017-03-27 00:00:00', '6137972', '6137972', '155', '821', '820', 'C.D', '2', '2017-03-22 15:13:40', null, null, '0', '4', '7.020', '6.98000', '-8.393', '600.000', null, '-4.393', '500.000', '650.000', '164000201', 'dsadasd', '1500rmb1950usd3pcs', null, null, '1', '0.21', 'NN', '', 'SI1', null, 'K', 'EX', 'IND', 'VG', 'VG', 'N', '3.83x3.81x2.34', '560', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '29141205', '2017-03-29 14:12:05', '0329141145', '0');
INSERT INTO `yz_order` VALUES ('52', '4', '2', '0', null, null, '1', '2017-03-27 00:00:00', '6334883', '6334883', '155', '821', '820', 'C.D', '2', '2017-03-22 15:13:40', null, null, '0', '5', '7.020', '6.98000', '28.947', '600.000', null, '32.947', '500.000', '650.000', '166101301', 'dsadasd', 'th', null, null, '1', '0.21', 'NN', '', 'SI2', null, 'M', 'EX', 'IND', 'VG', 'VG', 'N', '3.88x3.84x2.33', '380', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, '29141205', '2017-03-29 14:12:05', '0329141145', '0');
INSERT INTO `yz_order` VALUES ('53', '6', null, '0', null, null, '0', null, '6382437', 'G5246921598', '155', '821', '820', 'YDT', '2', '2017-03-23 18:03:53', '2017-03-23 18:03:53', null, '0', null, '7.020', '6.98000', '4.895', '600.000', null, '8.895', '500.000', '650.000', '#32', 'fdsfsfdsf', 'tuihuo', null, null, '2', '0.52', 'GIA', '5246921598', 'SI1', null, 'Q-R', 'EX', 'HK', 'EX', 'EX', 'N', '', '1100', 'ML1', 'BR1', '', '', '', null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('54', '6', null, '0', null, null, '0', null, '6382438', 'I119459164', '155', '821', '820', 'YDT', '2', '2017-03-23 18:03:53', '2017-03-23 18:03:53', null, '0', null, '7.020', '6.98000', '284.123', '600.000', null, '288.123', '500.000', '650.000', 'JPR3710', 'fdsfsfdsf', 'tuihuo', null, null, '2', '0.22', 'IGI', '119459164', 'SI2', null, 'F', 'VG', 'IND', 'GD', 'GD', 'N', '', '710', 'NA', 'NA', 'NA', '', '', null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('55', '6', null, '0', null, null, '0', null, '6383198', '6383198', '155', '821', '820', 'YDT', '2', '2017-03-23 18:03:53', '2017-03-23 18:03:53', null, '0', null, '7.020', '6.98000', '334.783', '600.000', null, '338.783', '500.000', '650.000', '1874P', 'fdsfsfdsf', 'tuihuo', null, null, '6', '0.23', 'NN', '', 'I1', null, 'E', 'NN', 'USA', 'VG', 'GD', 'NN', '', '600', 'NA', 'NA', 'NA', '', '', null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('56', '6', null, '0', null, null, '0', null, '6383199', '6383199', '155', '821', '820', 'YDT', '2', '2017-03-23 18:03:53', '2017-03-23 18:03:53', null, '0', null, '7.020', '6.98000', '525.000', '600.000', null, '529.000', '500.000', '650.000', 'L550019101', 'fdsfsfdsf', 'tuihuo', null, null, '1', '0.2', 'NN', '', 'SI2', null, 'L', 'EX', 'IND', 'VG', 'VG', 'F', '', '480', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, '0');
INSERT INTO `yz_order` VALUES ('57', '5', null, '0', null, null, '0', null, '5131496', '5131496', '195', '910', '910', 'C.D', '2', '2017-03-30 11:43:37', null, null, '0', null, '7.020', '6.98000', '-47.368', '120.000', null, '-44.368', '890.424', '126.841', 'L290014202', '', 'test', null, null, '1', '0.24', 'NN', '', 'VVS2', null, 'L', 'EX', 'IND', 'VG', 'VG', 'N', '4.07x4.01x2.43', '950', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('58', '5', null, '0', null, null, '0', null, '5587497', '5587497', '195', '910', '820', 'C.D', '2', '2017-03-30 11:43:37', '2017-03-31 00:00:00', null, '0', null, '7.020', '6.98000', '-20.149', '117.700', '666.000', '-17.149', '857.299', '122.122', 'L390025701', '', 'fdfsd', '6', null, '1', '0.22', 'NN', '7', 'VS1', null, 'K', 'EX', 'IND', 'VG', 'VG', 'N', '3.86x3.82x2.40', '670', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('59', '5', null, '0', null, null, '0', null, '6128767', '6128767', '195', '910', '820', 'C.D', '2', '2017-03-30 11:43:37', null, null, '0', null, '7.020', '6.98000', '-30.633', '115.080', null, '-27.633', '842.799', '120.057', 'L610009002', '', 'test', null, null, '1', '0.21', 'NN', '', 'VVS1', null, 'L', 'EX', 'IND', 'VG', 'VG', 'N', '3.85x3.82x2.40', '790', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('60', '5', null, '0', null, null, '0', null, '5638833', 'G1248660305', '194', '910', '910', 'C.D', '2', '2017-03-30 11:44:02', null, null, '0', null, '7.020', '6.98000', '-62.333', '180.800', null, null, '1313.956', '187.173', 'L390033601', '', 'test', null, null, '1', '0.4', 'GIA', '1248660305', 'SI1', '1', 'Fancy', 'GD', 'IND', 'EX', 'VG', 'M', '4.59x4.54x3.03', '1200', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('61', '5', null, '0', null, null, '0', null, '6137800', 'G6252048325', '194', '910', '910', 'C.D', '2', '2017-03-30 11:44:02', '2017-03-30 00:00:00', null, '0', null, '7.020', '6.98000', '0.000', '189.200', null, null, '1375.002', '195.869', 'L560023001', '', 'fdsfs', '6', null, '1', '0.4', 'GIA', '6252048325', 'VS1', '1', 'Fancy', 'GD', 'IND', 'EX', 'VG', 'F', '4.53x4.50x2.95', '0', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('62', '5', null, '0', null, null, '0', null, '5753814', '5753814', '193', '821', '820', 'C.D', '1', '2017-04-01 22:22:14', null, null, '0', null, '7.020', '6.98000', '9.818', '120.800', null, '11.818', '863.459', '123.000', 'L440003901', '', 'test', null, null, '1', '0.2', 'NN', '', 'I1', null, 'D', 'EX', 'IND', 'VG', 'VG', 'N', '3.77x3.75x2.37', '550', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('63', '5', null, '0', null, null, '0', null, '6133820', 'G2254011055', '193', '821', '820', 'C.D', '1', '2017-04-01 22:22:14', null, null, '0', null, '7.020', '6.98000', '-37.182', '207.300', null, null, '1491.627', '212.483', 'L550019801', '', 'test', null, null, '1', '0.3', 'GIA', '2254011055', 'SI1', '1', 'Fancy', 'EX', 'IND', 'EX', 'EX', 'N', '4.28x4.27x2.68', '1100', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('64', '5', null, '0', null, null, '0', null, '4570550', '4570550', '193', '821', '820', 'C.D', '1', '2017-04-01 22:26:57', null, null, '0', null, '7.020', '6.98000', '-9.167', '117.720', null, '-7.167', '844.587', '120.312', '158502001', '', 'test', null, null, '1', '0.27', 'NN', '', 'SI2', null, 'M', 'EX', 'IND', 'VG', 'VG', 'M', '4.21x4.18x2.55', '480', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('65', '5', null, '0', null, null, '0', null, '4915569', 'I116424559', '193', '821', '820', 'JanamCorporation', '1', '2017-04-06 16:43:50', null, null, '0', null, '2.000', '1.50000', '-17.121', '120.340', null, '-15.121', '246.489', '123.244', 'JPR3338', '', 'test', null, null, '2', '0.22', 'IGI', '116424559', 'SI2', null, 'G', 'VG', 'IND', 'GD', 'GD', 'VSL', '3.27x3.26x2.37', '660', 'NA', 'NA', 'NA', '', '', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('66', '5', null, '0', null, null, '0', null, '5638872', 'G1243653062', '193', '821', '820', 'C.D', '1', '2017-04-06 16:43:50', null, null, '0', null, '2.000', '1.50000', '-53.615', '198.990', null, null, '407.930', '203.965', 'L380009301', '', 'test', null, null, '1', '0.33', 'GIA', '1243653062', 'VS1', '1', 'Fancy', 'EX', 'IND', 'VG', 'VG', 'N', '4.42x4.40x2.76', '1300', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('67', '3', null, '0', null, null, '0', null, '6478831', 'G6242862341', '193', '821', '820', 'YDT', '1', '2017-04-06 17:19:01', '2017-04-06 17:19:01', '2017-04-06 17:19:01', '1', null, '2.000', '1.50000', '-26.000', '4440.000', null, '-24.000', '9120.000', '4560.000', 'TBM10748', 't', null, null, null, '1', '0.8', 'GIA', '6242862341', 'VVS1', null, 'D', 'EX', 'HK', 'EX', 'EX', 'N', '', '7500', 'ML0', 'BR0 GR0', 'N', 'NA NA', 'NA NA NA NA', null, null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('68', '3', null, '0', null, null, '0', null, '6478802', 'G6242700537', '193', '821', '820', 'YDT', '1', '2017-04-06 17:43:33', '2017-04-06 17:43:33', '2017-04-06 17:43:33', '1', null, '2.000', '1.50000', '-39.500', '1185.800', null, '-37.500', '2450.000', '1225.000', 'TBJ10275', '554564', null, null, null, '1', '0.7', 'GIA', '6242700537', 'SI2', null, 'I', 'VG', 'HK', 'EX', 'VG', 'N', '', '2800', 'ML0', 'BR0 GR0', '', 'NA NA', 'NA NA NA NA', 'EC0', null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('69', '3', null, '0', null, null, '0', null, '6480132', 'G3235630562', '193', '821', '820', 'YDT', '1', '2017-04-06 17:43:33', '2017-04-06 17:43:33', '2017-04-06 17:43:33', '1', null, '2.000', '1.50000', '-34.136', '579.600', null, '-32.136', '1194.406', '597.203', '70209014', '554564', null, null, null, '1', '0.4', 'GIA', '3235630562', 'SI1', null, 'H', 'EX', 'GZ', 'EX', 'EX', 'N', '', '2200', 'ML4', 'YE', 'N', '', '', 'EC1', null, null, null, null, null);
INSERT INTO `yz_order` VALUES ('70', '1', null, '0', null, null, '0', null, '6512517', '6512517', '193', '821', '820', 'C.D', '1', '2017-04-06 17:43:33', null, null, '0', null, '2.000', '1.50000', '-16.269', '112.200', null, '-14.269', '229.759', '114.880', 'L730019201', '554564', null, null, null, '1', '0.2', 'NN', '', 'VVS2', null, 'M', 'EX', 'IND', 'VG', 'VG', 'F', '3.85x3.81x2.29', '670', 'NA', 'NA', 'NA', 'NA NA', 'NA NA NA NA', '', null, null, null, null, null);

-- ----------------------------
-- Table structure for `yz_order_parcel`
-- ----------------------------
DROP TABLE IF EXISTS `yz_order_parcel`;
CREATE TABLE `yz_order_parcel` (
  `OrderID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单序列号',
  `UserID` int(11) DEFAULT NULL COMMENT '代下单用户',
  `CustomerID` int(11) DEFAULT NULL COMMENT '所属用户id',
  `OrderStatus` int(11) DEFAULT NULL COMMENT '订单状态：1待出货，2已出货，3已作废，4，已退货',
  `PaymentStatus` int(11) DEFAULT NULL COMMENT '付款状态：0未支付 1已支付',
  `OrderType` int(11) DEFAULT NULL COMMENT '订单类型（1、客户自己下单2 代下单）',
  `Remarks` varchar(255) DEFAULT NULL COMMENT '客户备注',
  `SalesRemarks` varchar(255) DEFAULT NULL COMMENT '销售员备注',
  `PurchaseRemarks` varchar(255) DEFAULT NULL COMMENT '采购员备注',
  `GoodsRemark` varchar(255) DEFAULT NULL COMMENT '取货员备注',
  `ConfirmPer` decimal(10,3) DEFAULT NULL COMMENT '每卡',
  `ConfirmPrice` decimal(10,3) DEFAULT NULL COMMENT '卖出人民币总价',
  `CreateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `EditTime` datetime DEFAULT NULL COMMENT '创建时间',
  `InventoryID` int(11) DEFAULT NULL,
  `Category` tinyint(2) DEFAULT '0' COMMENT '类别',
  `Supplier` varchar(20) DEFAULT NULL COMMENT '供应商',
  `Place` varchar(10) DEFAULT NULL COMMENT '所在地',
  `Descript` varchar(300) DEFAULT NULL COMMENT '描述',
  `OriginSN` varchar(20) DEFAULT NULL COMMENT '货号',
  `Shape` tinyint(2) DEFAULT NULL COMMENT '形状',
  `Size` varchar(30) DEFAULT NULL COMMENT '尺寸',
  `SizeDesc` varchar(300) DEFAULT NULL COMMENT '大小描述',
  `Color` varchar(20) DEFAULT NULL,
  `ColorDesc` varchar(300) DEFAULT NULL,
  `Intensity` varchar(20) DEFAULT NULL COMMENT '强度',
  `IntensityDesc` varchar(300) DEFAULT NULL COMMENT '强度描述',
  `Clarity` varchar(10) DEFAULT NULL COMMENT '净度',
  `ClarityDesc` varchar(300) DEFAULT NULL COMMENT '净度描述',
  `Weight` decimal(12,3) DEFAULT '0.000' COMMENT '总重',
  `WeightDesc` varchar(300) DEFAULT NULL COMMENT '重量描述',
  PRIMARY KEY (`OrderID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_order_parcel
-- ----------------------------
INSERT INTO `yz_order_parcel` VALUES ('1', null, '155', '3', '1', null, '高富帅鬼斧神工', '', null, null, null, '358.000', null, '2017-03-13 13:03:19', null, '1', '13922831904', 'SZ', 'vx/imdoor', '1/2', '1', '0.01-0.02', '', 'G-H', '', '', '', 'SI1-SI2', '', '10.000', '');
INSERT INTO `yz_order_parcel` VALUES ('2', null, '155', '2', '0', null, '3ge ', null, null, null, '520.000', '310.000', '2017-03-13 14:19:03', null, null, '1', '13922831904', 'SZ', '2100元/克拉vx/imdoor', '0.3/0.8', '3', '0.001-0.009', '', 'G-H', '', '', '', 'SI2-SI3', '', '20.000', '');
INSERT INTO `yz_order_parcel` VALUES ('3', null, '155', '3', '1', null, '3ge ', null, null, null, null, '358.000', null, null, null, '1', '13922831904', 'SZ', 'si1/2gh 可用于大牌产品镶嵌', '1/2', '1', '0.01-0.02', '', 'G-H', '', '', '', 'SI1-SI2', '', '20.000', '');
INSERT INTO `yz_order_parcel` VALUES ('4', null, '155', '1', '0', null, '单个直接购买', null, null, null, null, '1323.530', '2017-03-13 16:44:51', null, '202', '1', '18898799918', 'shenzhen', '', '303', '4', '0.30-0.39', '', 'D-E-F', '', '', '', 'VVS', '', '330.000', '');
INSERT INTO `yz_order_parcel` VALUES ('5', null, '155', '4', '0', null, '单个直接购买', null, null, null, null, '1029.410', null, null, '203', '1', '18898799918', 'shenzhen', '', '304', '2', '0.30-0.39', '', 'I-J', '', '', '', 'VVS', '', '50.000', '');
INSERT INTO `yz_order_parcel` VALUES ('6', null, '155', '3', '0', null, '发大水发斯蒂芬', '', null, null, null, '1015.000', '2017-03-13 16:44:45', null, '236', '1', '13418541808', 'SZ', 'wechat:zh506508', 'Ghsi1', '1', '0.30-0.39', 'Si1', 'G-H', 'Gh ', '', '', 'SI1-SI2', '套现货', '1.880', '');
INSERT INTO `yz_order_parcel` VALUES ('7', null, '155', '1', '0', null, '单个直接购买', null, null, null, null, '1764.000', null, null, '240', '2', '13510803271', 'CHN', '', 'VVD-06-24', '1', '0.70-0.99', '0.7-0.71', 'YELLOW', 'KL', 'FAINT', '', 'SI1-SI2', 'SI', '0.728', '');
INSERT INTO `yz_order_parcel` VALUES ('8', null, '155', '1', '0', null, '单个直接购买', null, null, null, null, '853.000', null, null, '169', '2', '13430459517', 'shenzhen', '', 'jyh10', '8', '0.08-0.12', '干净', 'YELLOW', '漂亮的心钻', 'fancy', '', 'VS2-S1', '', '5.000', '');
INSERT INTO `yz_order_parcel` VALUES ('9', null, '155', '1', '0', null, '单个直接购买', null, null, null, null, '2520.000', '2017-03-13 16:44:48', null, '409', '2', '18627805463', 'CHN', '', 'FPP06-10', '1', '0.08-0.12', '0.08', 'PINK', 'FPP', 'FANCY', 'FANCY', 'SI1-SI2', 'SI', '1.110', '');
INSERT INTO `yz_order_parcel` VALUES ('10', null, '155', '1', '0', null, '单个直接购买', null, null, null, null, '1060.000', null, null, '170', '2', '13430459517', 'shenzhen', '', 'lyh20', '8', '0.18-0.22', '漂亮的石头', 'YELLOW', '', 'fancy', '', 'VS2-S1', '', '10.000', '');

-- ----------------------------
-- Table structure for `yz_order_ring`
-- ----------------------------
DROP TABLE IF EXISTS `yz_order_ring`;
CREATE TABLE `yz_order_ring` (
  `OrderID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单序列号',
  `UserID` int(11) DEFAULT NULL COMMENT '代下单用户',
  `CustomerID` int(11) DEFAULT NULL COMMENT '所属用户id',
  `OrderStatus` int(11) DEFAULT NULL COMMENT '订单状态：1待出货，2已出货，3已作废，4，已退货',
  `PaymentStatus` int(11) DEFAULT NULL COMMENT '付款状态：0未支付 1已支付',
  `OrderType` int(11) DEFAULT NULL COMMENT '订单类型（1、客户自己下单2 代下单）',
  `Remarks` varchar(255) DEFAULT NULL COMMENT '客户备注',
  `SalesRemarks` varchar(255) DEFAULT NULL COMMENT '销售员备注',
  `GoodsRemark` varchar(255) DEFAULT NULL COMMENT '取货员备注',
  `ConfirmPrice` decimal(10,3) DEFAULT NULL COMMENT '卖出人民币总价',
  `AddTime` datetime DEFAULT NULL COMMENT '创建时间',
  `EditTime` datetime DEFAULT NULL COMMENT '修改时间',
  `Category` tinyint(2) DEFAULT '0' COMMENT '类别',
  `Style` tinyint(2) DEFAULT '0' COMMENT '风格',
  `CertNo` varchar(20) DEFAULT NULL COMMENT '成品证书号码',
  `Supplier` varchar(20) DEFAULT NULL COMMENT '供应商',
  `MainColor` varchar(20) DEFAULT NULL COMMENT '主石颜色',
  `IsStock` tinyint(1) DEFAULT '0' COMMENT '是否现货',
  `MainCertNo` varchar(20) DEFAULT NULL COMMENT '主石证书号码',
  `Weight` decimal(12,3) DEFAULT '0.000' COMMENT '总重',
  `Place` varchar(10) DEFAULT NULL COMMENT '所在地',
  `CertType` varchar(10) DEFAULT NULL COMMENT '成品证书类型',
  `MainType` tinyint(2) DEFAULT NULL COMMENT '主石类型',
  `MainWeight` decimal(12,3) DEFAULT '0.000' COMMENT '主石重量',
  `MainClarity` varchar(10) DEFAULT NULL COMMENT '主石净度',
  `MainCertType` varchar(10) DEFAULT NULL COMMENT '主石证书类型',
  `SideType` tinyint(2) DEFAULT NULL COMMENT '副石类型',
  `SideWeight` decimal(12,3) DEFAULT '0.000' COMMENT '副石重量',
  `Descript` varchar(300) DEFAULT NULL COMMENT '描述',
  `Size` varchar(30) DEFAULT NULL COMMENT '尺寸',
  `Quality` varchar(30) DEFAULT NULL COMMENT '材质',
  `OnShelves` tinyint(1) DEFAULT NULL COMMENT '是否上架',
  `Series` varchar(20) DEFAULT NULL COMMENT '系列',
  `OriginSN` varchar(20) DEFAULT NULL COMMENT '货号',
  `Status` tinyint(2) DEFAULT NULL COMMENT '产品状态',
  `Price` decimal(12,3) DEFAULT '0.000' COMMENT '价格',
  `ID` int(11) DEFAULT NULL COMMENT '货品id',
  PRIMARY KEY (`OrderID`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_order_ring
-- ----------------------------
INSERT INTO `yz_order_ring` VALUES ('1', null, '155', '3', '0', '1', '非官方的个', '', null, '1558.000', '2017-03-01 16:30:13', '2017-02-28 12:23:54', '3', '2', '', '18476541263', 'F-G', '2', '15588', '1600.000', 'IND', 'GIC', '1', '1588.000', 'SI', 'GIC', null, '12.000', '', '125', '-', null, null, '155', null, '1558.000', '21');
INSERT INTO `yz_order_ring` VALUES ('2', null, '155', '3', '0', '1', '单个直接购买', null, null, '19.000', null, '2017-02-28 12:23:58', '1', '1', '16543', 'YDT', 'I-J', '1', '443222', '10.000', 'SZ', 'NGTC', '2', '0.980', 'VS', 'GIA', '2', '1.000', '1', '1', '3', '1', null, 'acb1', '1', '19.000', '40');
INSERT INTO `yz_order_ring` VALUES ('3', '906', '155', '4', '1', '1', '单个直接购买', null, null, '5.000', null, '2017-02-28 12:24:01', '1', '1', '', 'YDT', 'F-G', '1', '', '5.000', 'SZ', 'NGTC', '1', '5.000', '<P', 'IGI', '1', '5.000', '', '', '1', '1', null, '5', '1', '5.000', '42');
INSERT INTO `yz_order_ring` VALUES ('4', null, '155', '1', '0', '1', '单个直接购买', null, null, '3000.000', null, '2017-02-28 12:24:05', '1', '1', '', 'YDT', 'K-L', '1', '', '1.110', 'BEL', 'AGS', '1', '1.000', '<P', 'GIA', null, '0.100', 'test', '2', '2', '1', null, 'test', '1', '3000.000', '52');
INSERT INTO `yz_order_ring` VALUES ('5', null, '155', '1', '0', '1', '单个直接购买', null, null, '34.000', null, '2017-02-28 12:24:09', '5', '4', '', '18807551941', 'I-J', '1', '', '234.000', 'TL', '', '1', '34.000', 'SI', '', null, '0.000', '', '', '3', '1', null, '3', '5', '34.000', '65');
INSERT INTO `yz_order_ring` VALUES ('6', '907', '155', '2', '1', '1', '单个直接购买', null, null, '1555.000', null, null, '2', '2', '', '18476541263', 'D-E', '0', '5555', '22.000', 'CHN', 'NJQSIC', '1', '12.000', 'VVS', 'NJQSIC', null, '10.000', '', '12355', '2', '1', null, '12355', null, '1555.000', '22');
INSERT INTO `yz_order_ring` VALUES ('7', null, '155', '1', '0', '1', '单个直接购买', null, null, '24.000', null, null, '5', '5', '', '18807551941', 'H', '0', '', '565676.000', 'HK', 'AGS', '3', '34.000', 'VS', 'HRD', null, '5567.000', '345345', '234', '3', '1', null, '67567', '5', '24.000', '47');
INSERT INTO `yz_order_ring` VALUES ('8', null, '155', '1', '0', '1', '单个直接购买', null, null, '456.000', '2017-02-28 12:27:25', null, '4', '5', '', '18807551941', 'I-J', '1', '', '1111111.000', 'USA', 'Cubelin', '2', '51.000', 'SI', 'AGS', null, '1111111.000', '48484', '444', '3', '1', null, '151', '4', '456.000', '25');
INSERT INTO `yz_order_ring` VALUES ('9', null, '155', '2', '0', '1', '单个直接购买', null, null, '3.000', '2017-02-28 12:27:28', null, '6', '6', '', '13068529256', 'M-N', '1', '', '14455.000', 'ISR', 'IGI', '1', '14.000', 'P', 'AGS', null, '14455.000', '呼呼', '1组', '3', '1', null, '的', '5', '3.000', '50');
INSERT INTO `yz_order_ring` VALUES ('10', null, '155', '3', '0', '1', 'test', '', null, '7.000', '2017-02-28 12:27:31', null, '5', '4', '', '18807551941', '黑色', '1', '', '4.000', 'BEL', 'CCGTC', '2', '48.000', 'SI', 'GRS', null, '4.000', '84', '4', '3', '1', null, '86', '3', '7.000', '64');
INSERT INTO `yz_order_ring` VALUES ('11', '908', '155', '1', '0', '1', '单个直接购买', null, null, '1558.000', '2017-02-28 12:30:33', null, '3', '2', '442434', '18476541263', 'F-G', '1', '15588', '1600.000', 'IND', 'GIC', '1', '1588.000', 'SI', 'IGI', null, '12.000', '', '125', '2', null, 'yz', '155', null, '1558.000', '21');
INSERT INTO `yz_order_ring` VALUES ('12', null, '821', '3', '0', '1', '单个直接购买', null, null, '1.000', '2017-02-28 12:31:30', null, '1', '1', '12344345454', 'YDT', '<N', '0', '', '1.087', 'IND', 'CCGTC', '1', '18.000', 'VVS', 'EGL', '1', '1.000', '1555', '1', '2', '1', null, '1132-f', '1', '1.000', '38');
INSERT INTO `yz_order_ring` VALUES ('13', null, '821', '1', '0', '1', '单个直接购买', null, null, '1666.000', '2017-02-28 12:31:32', null, '1', '5', '12345678', 'YDT', 'F-G', '1', '43434343', '8.000', 'SZ', 'NGTC', '1', '2.950', 'VS', 'NGTC', '1', '1.090', '白钻豪华戒指', '1', '1', '1', 'k', '1132-f', '2', '888.000', '39');
INSERT INTO `yz_order_ring` VALUES ('14', null, '821', '4', '0', '1', '单个直接购买', null, null, '1444.000', '2017-02-28 12:31:36', null, '1', '1', '166664432', 'YDT', 'H', '1', 'HRD520', '1.000', 'CHN', 'NGTC', '2', '0.450', 'I1', 'HRD', '2', '1.000', '1', '1', '4', '1', null, '1132-f', '1', '1444.000', '41');
INSERT INTO `yz_order_ring` VALUES ('15', '821', '155', '1', '0', '1', '单个直接购买', null, null, '456.000', '2017-02-28 12:33:40', null, '4', '5', '', '18807551941', 'I-J', '1', '', '1111111.000', 'USA', 'Cubelin', '2', '51.000', 'SI', 'AGS', null, '1111111.000', '48484', '444', '3', '1', null, '151', '4', '456.000', '25');
INSERT INTO `yz_order_ring` VALUES ('16', '821', '155', '1', '0', '1', '单个直接购买', null, null, '3.000', '2017-02-28 12:33:44', null, '6', '6', '223323', '13068529256', 'M-N', '1', '32323233', '14455.000', 'ISR', '其他', '1', '14.000', 'P', 'NGTC', null, '14455.000', '呼呼', '1组', '3', '1', 'BL', '的', '5', '3.000', '50');
INSERT INTO `yz_order_ring` VALUES ('17', '821', '155', '1', '0', '1', '单个直接购买', null, null, '34.000', '2017-02-28 12:33:49', null, '5', '4', '443223G', '18807551941', 'I-J', '1', 'nn3223', '234.000', 'TL', 'CCGTC', '4', '34.000', 'SI', 'NN', null, '0.520', '', '34#', '3', '1', null, '3', '5', '34.000', '65');
INSERT INTO `yz_order_ring` VALUES ('18', '821', '155', '1', '0', '1', '单个直接购买', null, null, '1.000', '2017-02-28 12:39:28', null, '6', '5', '123443', 'YDT', 'F-G', '1', '66666', '1.087', 'IND', '北大', '6', '1.530', '<P', 'GIA', '1', '10.600', '1555', '15#', '4', '1', 'cartier', '1132-fa', '1', '10000.000', '38');
INSERT INTO `yz_order_ring` VALUES ('19', '821', '155', '3', '0', '1', '测试', '', null, '1444.000', '2017-03-10 11:42:00', null, '1', '1', '166664432', 'YDT', 'H', '1', 'HRD520', '1.000', 'CHN', 'NGTC', '2', '0.450', 'I1', 'HRD', '2', '1.000', '1', '1', '4', '1', null, '1132-f', '1', '1444.000', '41');
INSERT INTO `yz_order_ring` VALUES ('20', '821', '155', '1', '0', '1', '测试', null, null, '150000.000', '2017-03-10 11:42:40', null, '2', '2', '', '18476541263', 'F-G', '0', '12', '22.000', 'CHN', 'NGTC', '1', '12.000', 'VS', 'NGTC', null, '8.000', '155555', '123', '3', '1', null, '125555', null, '150000.000', '45');
INSERT INTO `yz_order_ring` VALUES ('21', '821', '155', '3', '0', '1', '测试', '', null, '3.000', '2017-03-10 11:44:32', null, '6', '6', '', '13068529256', 'M-N', '1', '', '14455.000', 'ISR', 'IGI', '1', '14.000', 'P', 'AGS', null, '14455.000', '呼呼', '1组', '3', '1', null, '的', '5', '3.000', '50');
INSERT INTO `yz_order_ring` VALUES ('22', '821', '155', '1', '0', '1', '单个直接购买', null, null, '1555.000', '2017-03-13 10:56:48', null, '2', '2', '', '18476541263', 'D-E', '0', '5555', '22.000', 'CHN', 'NJQSIC', '1', '12.000', 'VVS', 'NJQSIC', null, '10.000', '', '12355', '2', '1', null, '12355', null, '1555.000', '22');
INSERT INTO `yz_order_ring` VALUES ('23', '821', '155', '3', '0', '1', 'test', '', null, '1.000', '2017-03-13 10:57:08', null, '1', '1', '12344345454', 'YDT', '<N', '0', '', '1.087', 'IND', 'CCGTC', '1', '18.000', 'VVS', 'EGL', '1', '1.000', '1555', '1', '2', '1', null, '1132-f', '1', '1.000', '38');
INSERT INTO `yz_order_ring` VALUES ('24', '821', '155', '1', '0', '1', '单个直接购买', null, null, '3.000', '2017-03-14 11:47:44', null, '6', '6', '', '13068529256', 'M-N', '1', '', '14455.000', 'ISR', 'IGI', '1', '14.000', 'P', 'AGS', null, '14455.000', '呼呼', '1组', '3', '1', null, '的', '5', '3.000', '50');
INSERT INTO `yz_order_ring` VALUES ('25', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:34', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('26', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:37', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('27', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:40', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('28', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:40', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('29', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:41', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('30', '821', '155', '1', '0', '1', 'sfd', null, null, '120.000', '2017-03-24 11:11:41', null, '1', '1', '', '18900000003', 'D-E', '1', '156666', '14.000', 'CHN', 'GIA', '1', '2.000', 'VVS', 'GIA', null, '12.000', '', '12_12', '1', '1', null, '1236687', null, '120.000', '142');
INSERT INTO `yz_order_ring` VALUES ('31', '821', '155', '1', '0', '1', '', null, null, '3.000', '2017-03-24 14:19:27', null, '6', '6', '', '13068529256', 'M-N', '1', '', '14455.000', 'ISR', 'IGI', '1', '14.000', 'P', 'AGS', null, '14455.000', '呼呼', '1组', '3', '1', null, '的', '5', '3.000', '50');

-- ----------------------------
-- Table structure for `yz_recharge`
-- ----------------------------
DROP TABLE IF EXISTS `yz_recharge`;
CREATE TABLE `yz_recharge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_id` int(11) DEFAULT NULL COMMENT '业务',
  `customer_id` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT NULL COMMENT '审核人',
  `PaymentModel` varchar(50) DEFAULT NULL COMMENT '付款方式',
  `AmountOfMoney` decimal(11,2) DEFAULT '0.00' COMMENT '金额',
  `AdddateTime` datetime DEFAULT NULL COMMENT '到款时间',
  `Remarks` varchar(200) DEFAULT NULL COMMENT '备注',
  `OperationModel` int(11) DEFAULT NULL COMMENT '操作类型(1:充值 2 ：消费 3:退款)',
  `UpdateTime` datetime DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yz_recharge
-- ----------------------------

-- ----------------------------
-- Table structure for `yz_supplier`
-- ----------------------------
DROP TABLE IF EXISTS `yz_supplier`;
CREATE TABLE `yz_supplier` (
  `SupplierID` int(11) NOT NULL AUTO_INCREMENT,
  `UserID` int(11) DEFAULT NULL COMMENT '记录添加供应商的用户',
  `SupplierCode` varchar(20) DEFAULT NULL COMMENT '供应商代码',
  `SupplierName` varchar(50) DEFAULT NULL COMMENT '供应商名称',
  `RapnetID` varchar(20) DEFAULT NULL,
  `Skype` varchar(255) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Country` varchar(20) DEFAULT NULL,
  `FancyRebate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `Rebate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '销售折扣(目的：用来系统加价的)',
  `DeliveryAddress` varchar(100) DEFAULT NULL COMMENT '香港取货地址',
  `Url` varchar(100) DEFAULT NULL,
  `UserName` varchar(255) DEFAULT NULL,
  `Password` varchar(255) DEFAULT NULL,
  `SysStatus` int(11) DEFAULT '1' COMMENT '状态：-1.已逻辑删除, 1.正常, 2.黑名单',
  `Sort` int(11) DEFAULT NULL,
  `Datastate` int(11) DEFAULT '1' COMMENT '数据开关 1开 0 关',
  `Introduction` text,
  `CreateTime` datetime DEFAULT NULL,
  `Spotdata` int(11) DEFAULT '0',
  `UpdateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`SupplierID`),
  KEY `idx_Supplier` (`SupplierCode`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='供应商表';

-- ----------------------------
-- Records of yz_supplier
-- ----------------------------
INSERT INTO `yz_supplier` VALUES ('1', '712', 'YD', 'yiyidiamond', '', '', '', 'IND', '5.00', '0.55', 'HK', '', '', '', '1', '2', '1', '2-5', '2016-12-23 17:18:53', '1', '2017-01-10 18:14:24');
INSERT INTO `yz_supplier` VALUES ('2', '712', 'YDT', 'YDT', '', '', '', 'IND', '0.00', '0.00', 'SZ', '', '', '', '1', '2', '1', '', '2016-12-23 17:19:04', '0', '2017-01-10 16:55:40');
INSERT INTO `yz_supplier` VALUES ('3', '712', 'HST', 'HST Diamond', '', '', '', 'IND', '0.00', '0.00', 'HH', '', '', '', '1', '1', '1', 'test', '2016-12-29 15:51:49', '0', '2017-01-10 18:12:47');
INSERT INTO `yz_supplier` VALUES ('4', '712', 'DIAMTRADE', 'DiamTrade', '', '', '', 'IND', '0.00', '2.00', 'tst', '', '', '', '1', '1', '1', '', '2017-01-10 17:24:53', '0', '2017-01-10 18:28:22');
INSERT INTO `yz_supplier` VALUES ('5', '712', 'NICE', 'nice diamond', '', '', '', 'IND', '0.00', '0.00', 'hh', '', '', '', '1', '3', '1', '', '2017-01-10 18:04:52', '0', null);
INSERT INTO `yz_supplier` VALUES ('6', '712', 'SZ', 'Shenzhen', '', '', '', 'CHN', '0.00', '0.00', '田贝', '', '', '', '1', '4', '1', 'SZ深圳', '2017-01-11 12:09:21', '0', '2017-02-20 17:22:27');
INSERT INTO `yz_supplier` VALUES ('7', '712', 'C.D', 'cdinesh', '', '', '', 'IND', '0.00', '0.00', 'TST1111233434多发点胆大都铎范德萨发生的', '', '', '', '1', '3', '1', '', '2017-01-12 14:32:34', '0', '2017-01-12 14:38:13');
INSERT INTO `yz_supplier` VALUES ('8', '712', 'HEAVENST', 'heavenst', '', '', '', 'IND', '0.00', '0.00', 'TST', '', '', '', '1', '1', '1', '', '2017-02-11 14:24:02', '0', null);
INSERT INTO `yz_supplier` VALUES ('9', '712', 'MIRANSH', 'Miransh', '', '', '', 'IND', '0.00', '0.00', 'HK', '', '', '', '1', '2', '1', '', '2017-02-11 14:24:14', '0', null);
INSERT INTO `yz_supplier` VALUES ('10', '712', 'CD', 'cd', '', '', '', 'IND', '0.00', '0.00', 'hh', '', '', '', '1', '4', '1', '', '2017-02-11 14:24:24', '0', null);
INSERT INTO `yz_supplier` VALUES ('11', '712', 'A.R. IMPEX', 'a.r. impex', '', '', '', 'IND', '0.00', '0.00', 'hk', '', '', '', '1', '2', '1', '', '2017-02-11 14:24:42', '0', null);
INSERT INTO `yz_supplier` VALUES ('12', '712', 'RAYS', 'rays diamond', '', '', '', 'IND', '0.00', '0.00', 'cen', '', '', '', '1', '5', '1', '', '2017-02-11 14:25:01', '0', null);
INSERT INTO `yz_supplier` VALUES ('13', '712', 'JBB', 'jbbrother', '', '', '', 'IND', '0.00', '0.00', 'HK', '', '', '', '1', '1', '1', '', '2017-02-11 14:25:13', '0', null);

-- ----------------------------
-- Table structure for `yz_syssetting`
-- ----------------------------
DROP TABLE IF EXISTS `yz_syssetting`;
CREATE TABLE `yz_syssetting` (
  `SysSettingID` int(11) NOT NULL AUTO_INCREMENT,
  `Rate` decimal(10,3) DEFAULT '1.000' COMMENT '销售汇率',
  `PurchaseExchangerate` decimal(10,5) DEFAULT '1.00000' COMMENT '采购汇率',
  `GlobalDiscountReturn` decimal(10,2) DEFAULT '0.00' COMMENT '全局白钻折扣',
  `GlobalFancyDiscountReturn` decimal(10,2) DEFAULT '0.00' COMMENT '全局彩钻折扣',
  `Notice` varchar(255) DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`SysSettingID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='系统设置';

-- ----------------------------
-- Records of yz_syssetting
-- ----------------------------
INSERT INTO `yz_syssetting` VALUES ('1', '2.000', '1.50000', '2.00', '2.50', '裸钻加点', '2017-04-01 23:01:00');
INSERT INTO `yz_syssetting` VALUES ('2', '7.000', '6.95000', '1.25', '1.35', '统包倍率', '2016-11-18 12:36:48');
INSERT INTO `yz_syssetting` VALUES ('3', '1.000', '1.00000', '0.00', '0.00', '戒托倍率', '2017-02-16 14:23:23');
INSERT INTO `yz_syssetting` VALUES ('4', '1.000', '1.00000', '0.00', '0.00', '成品倍率', '2017-02-16 14:23:29');

-- ----------------------------
-- Table structure for `yz_user`
-- ----------------------------
DROP TABLE IF EXISTS `yz_user`;
CREATE TABLE `yz_user` (
  `UserID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(20) DEFAULT NULL,
  `UserPassword` varchar(32) DEFAULT NULL,
  `RoleID` varchar(200) DEFAULT NULL,
  `Sex` tinyint(4) DEFAULT NULL COMMENT '性别：0.女, 1.男',
  `Mobile` varchar(20) DEFAULT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `Qq` varchar(12) DEFAULT NULL,
  `Skype` varchar(50) DEFAULT NULL,
  `RealName` varchar(20) DEFAULT NULL,
  `LoginCount` int(11) NOT NULL DEFAULT '0',
  `Discount` decimal(10,2) DEFAULT '0.00',
  `FancyDiscount` decimal(10,2) DEFAULT '0.00',
  `ActiveIP` varchar(100) DEFAULT NULL,
  `ActiveArea` varchar(100) DEFAULT NULL,
  `Department` varchar(100) DEFAULT NULL COMMENT '员工所属部门',
  `RapnetAccount` varchar(30) DEFAULT '',
  `Comments` varchar(255) DEFAULT NULL,
  `LastActiveTime` datetime DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  `SysStatus` int(11) DEFAULT NULL COMMENT '账号状态：-1.已逻辑删除，0.禁止访问，1.正常访问',
  `UpdateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`UserID`)
) ENGINE=MyISAM AUTO_INCREMENT=911 DEFAULT CHARSET=utf8 COMMENT='员工表';

-- ----------------------------
-- Records of yz_user
-- ----------------------------
INSERT INTO `yz_user` VALUES ('712', 'admin', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '1', '18948797698', 'ddd', 'ddd', 'ddd', 'admin', '1472', '0.00', '0.00', '::1', '::1', '', '', '123456', '2017-04-06 18:01:51', '2016-08-31 21:59:18', '1', '2017-04-06 16:46:28');
INSERT INTO `yz_user` VALUES ('757', 'li', 'E10ADC3949BA59ABBE56E057F20F883E', '5', '1', '', '', '', '', '李', '130', '0.00', '0.00', '::1', null, '', '', '', '2017-03-30 17:39:54', '2016-09-01 10:23:36', '1', '2017-03-28 18:33:43');
INSERT INTO `yz_user` VALUES ('820', 'qiao', 'E10ADC3949BA59ABBE56E057F20F883E', '4', '0', '', '', '', '', '巧', '158', '0.00', '0.00', '::1', null, '', '', '1', '2017-03-30 17:39:19', '2016-09-01 10:23:50', '1', '2017-03-28 18:34:58');
INSERT INTO `yz_user` VALUES ('821', 'jian', 'E10ADC3949BA59ABBE56E057F20F883E', '3', '1', '', '288099@qq.com', '288099', 'ffd', '健', '132', '0.00', '0.00', '::1', null, '', '', '2', '2017-03-30 17:38:35', '2016-09-01 10:23:52', '1', '2017-03-23 12:45:43');
INSERT INTO `yz_user` VALUES ('906', 'xie', 'E10ADC3949BA59ABBE56E057F20F883E', '2', '0', '', '', '', '', '谢', '39', '0.00', '0.00', '::1', null, '', '', '', '2017-03-30 17:38:08', '2016-09-02 18:28:34', '1', null);
INSERT INTO `yz_user` VALUES ('907', 'test', 'E10ADC3949BA59ABBE56E057F20F883E', '2', '2', '', '', '', '', 'test', '0', '0.00', '0.00', null, null, '', '', 'add user', null, '2017-01-12 14:08:04', '0', '2017-03-23 12:44:56');
INSERT INTO `yz_user` VALUES ('908', 'sdfd 3', 'FA125080FE7E9A39F957CCB3788957C6', '2', '2', '', '', '', '', 'f  fdf', '0', '0.00', '0.00', null, null, '', '', '', null, '2017-02-16 11:17:24', '-1', '2017-03-23 12:44:46');
INSERT INTO `yz_user` VALUES ('909', 'shine', 'E10ADC3949BA59ABBE56E057F20F883E', '4', '2', '', '', '', '', 'Shine', '0', '0.00', '0.00', null, null, '', '', '', null, '2017-03-29 10:30:50', '1', null);
INSERT INTO `yz_user` VALUES ('910', 'aimee', 'E10ADC3949BA59ABBE56E057F20F883E', '6', '2', '', '', '', '', '艾米', '16', '0.00', '0.00', '::1', null, '', '', 'AE6', '2017-03-30 17:52:54', '2017-03-30 11:01:42', '1', null);