   KEY `subject` (`supplier_id`,`dateline`,`status`),
   KEY `sale_type` (`purchase_type`),
   KEY `user_id` (`user_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
-
---
--- 转存表中的数据 `x_purchase`
---
-
-INSERT INTO `x_purchase` (`id`, `bill_id`, `purchase_type`, `user_id`, `supplier_id`, `quantity`, `total_price`, `total_price_real`, `dateline`, `status`, `memo`) VALUES
-(1, 'CG5367931cbaf46', 1, 1, 5, '0.00', '0.00', '0.00', '1399296131', 0, '12'),
-(2, 'CG536793553d39c', 9, 1, 5, '0.00', '0.00', '0.00', '1399296131', 0, '12'),
-(3, 'CG5367972618ca4', 1, 1, 5, '0.00', '0.00', '0.00', '1399297810', 0, ''),
-(4, 'CG5367974f7ca10', 1, 1, 5, '0.00', '0.00', '0.00', '1399297810', 0, ''),
-(5, 'CG5367977e325ba', 1, 1, 5, '0.00', '0.00', '0.00', '1399297810', 0, ''),
-(6, 'CG5367978785236', 1, 1, 5, '0.00', '0.00', '0.00', '1399297810', 0, ''),
-(7, 'CG536797b1da7c8', 1, 1, 5, '0.00', '0.00', '0.00', '1399297810', 0, ''),
-(8, 'CG5367984e65e27', 1, 1, 5, '0.00', '0.00', '0.00', '1399297995', 0, ''),
-(9, 'CG5367986889818', 1, 1, 5, '0.00', '0.00', '0.00', '1399297995', 0, ''),
-(10, 'CG5367988773cdf', 1, 1, 5, '0.00', '0.00', '0.00', '1399297995', 1, ''),
-(11, 'CG53679c51c9b10', 0, 1, 5, '1.00', '200000.00', '200000.00', '1399298992', 2, ''),
-(12, 'CG536df1be11b4d', 9, 1, 0, '2.00', '400000.00', '400000.00', '1399714210', 1, ''),
-(13, 'CG5373702473fc3', 0, 1, 0, '1.00', '200000.00', '200000.00', '1400074249', 1, '');
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 

  `amount` float(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `voucher_id` (`voucher_id`,`subject_id`,`amount`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 转存表中的数据 `x_accounting_voucher_detail`
--

INSERT INTO `x_accounting_voucher_detail` (`id`, `voucher_id`, `subject_id`, `summary`, `dc`, `amount`) VALUES
(2, 2, 10, '差旅费', 0, 300.00),
(3, 2, 11, '差旅费', 1, 300.00),
(4, 3, 10, '差旅费', 0, 300.00),
(5, 3, 11, '差旅费', 1, 300.00),
(6, 4, 146, '报销吃饭费用', 1, 500.00),
(7, 4, 10, '报销吃饭费用', 0, 500.00),
(8, 5, 10, '出差', 1, 1000.00),
(9, 5, 11, '出差', 0, 1000.00);

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


  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `goods_id` (`goods_id`,`factory_code_all`,`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

