-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2014 年 11 月 25 日 04:04
-- 伺服器版本: 5.6.12-log
-- PHP 版本: 5.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 資料庫: `4e350_20123`
--
CREATE DATABASE IF NOT EXISTS `4e350_20123` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `4e350_20123`;

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

--
-- 表的結構 `account`
--

CREATE TABLE IF NOT EXISTS `account` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `acctext` text,
  `accrate` text,
  `accnote` text,
  `accmoney` int(11) DEFAULT NULL,
  `accsort` int(11) DEFAULT NULL,
  `accpic` int(11) DEFAULT NULL,
  `accinit` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qcust`
--

CREATE TABLE IF NOT EXISTS `qcust` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `CUSTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CUSTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `CREATEDATE` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `CREATETIME` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `BIRTHDAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `C1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `C2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `C3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `M3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `S3` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `qcust`
--

INSERT INTO `qcust` (`UID`, `XID`, `TR`, `CUSTNO`, `CUSTNAME`, `MOBIL`, `EMAIL`, `MSN`, `GMAIL`, `GPSLA`, `GPSLO`, `DEPTNO`, `EMPID`, `DISCOUNT`, `ADDRESS`, `PS`, `BANKNO`, `BANKNAME`, `COUNTRY`, `TRADETYPE`, `STATE`, `PIC`, `CREATEDATE`, `CREATETIME`, `BIRTHDAY`, `C1`, `C2`, `C3`, `M1`, `M2`, `M3`, `S1`, `S2`, `S3`) VALUES
('3G009_20123', 123456789, '30', 'root001', 'webRoot', '0987654321', 'root001@gmail.com', '0987654321', NULL, NULL, NULL, 'AA', NULL, 100, NULL, NULL, NULL, NULL, '1', '4', NULL, NULL, '2014-01-01', '140101000000', '1010', NULL, '5', '0', NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- 表的結構 `qc_color`
--

CREATE TABLE IF NOT EXISTS `qc_color` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `NO1` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `TXT` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_country`
--

CREATE TABLE IF NOT EXISTS `qc_country` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `NAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `RATE` double DEFAULT NULL,
  `PIC` text,
  `LAMIN` double DEFAULT NULL,
  `LAMAX` double DEFAULT NULL,
  `LOMIN` double DEFAULT NULL,
  `LOMAX` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_default`
--

CREATE TABLE IF NOT EXISTS `qc_default` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BATCH` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `PRODUCT` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ITEMFIRST` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `SEASON` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `YEAR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `EMPLOY` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `ACCOUNT` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `BAROUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `FILEOUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PRINTOUT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CA3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CB3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CC3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CD3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `HID` varchar(1) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_defpri`
--

CREATE TABLE IF NOT EXISTS `qc_defpri` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `DEFPRI` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_quality`
--

CREATE TABLE IF NOT EXISTS `qc_quality` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `QUA10` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA11` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA20` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA21` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA30` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA31` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA40` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA41` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA50` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA51` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `QUA60` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `QUA61` varchar(4) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_size`
--

CREATE TABLE IF NOT EXISTS `qc_size` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `SIZES` varchar(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_type`
--

CREATE TABLE IF NOT EXISTS `qc_type` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `ID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `GOODTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `PIC` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qc_wash`
--

CREATE TABLE IF NOT EXISTS `qc_wash` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `WASH10` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH11` text,
  `WASH20` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH21` text,
  `WASH30` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH31` text,
  `WASH40` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH41` text,
  `WASH50` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH51` text,
  `WASH60` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `WASH61` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qdept`
--

CREATE TABLE IF NOT EXISTS `qdept` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `DEPTID` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADTYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qdetail`
--

CREATE TABLE IF NOT EXISTS `qdetail` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BILL` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `PICTURE` text,
  `QUALITY_ID` int(11) DEFAULT NULL,
  `WASH_ID` int(11) DEFAULT NULL,
  `COLORNO` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `COLOR` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `INLIST` text CHARACTER SET utf8,
  `IMPO` double DEFAULT NULL,
  `IMPOS` double DEFAULT NULL,
  `OUTPO` double DEFAULT NULL,
  `OUTPOS` double DEFAULT NULL,
  `SPOS` double DEFAULT NULL,
  `SPOSS` double DEFAULT NULL,
  `IM_OUTSTK` double DEFAULT NULL,
  `IM_POSSTK` double DEFAULT NULL,
  `ORD` double DEFAULT NULL,
  `ACCOUNT` varchar(3) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qemp`
--

CREATE TABLE IF NOT EXISTS `qemp` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `XID` int(11) DEFAULT NULL,
  `QEMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `QEMPNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `BIRTHDAY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qfact`
--

CREATE TABLE IF NOT EXISTS `qfact` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `FACTNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `MOBIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `MSN` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GMAIL` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `GPSLA` double DEFAULT NULL,
  `GPSLO` double DEFAULT NULL,
  `DEPTNO` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ADDRESS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `BIRTHDAY` datetime DEFAULT NULL,
  `CREATEDATETIME` varchar(12) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qhead`
--

CREATE TABLE IF NOT EXISTS `qhead` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `QKIND` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `FORMNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `HANDNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `FORMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `ISCONFIRM` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISCHECK` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISLIST` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `EMPNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USER` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `ORDCASH` double DEFAULT NULL,
  `ORDCARD` double DEFAULT NULL,
  `CASH` double DEFAULT NULL,
  `CARD` double DEFAULT NULL,
  `ATOT` double DEFAULT NULL,
  `ORDDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `FINEDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `ASUM` double DEFAULT NULL,
  `BSUM` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `COSTS` double DEFAULT NULL,
  `TURESUM` double DEFAULT NULL,
  `DISMONEY` double DEFAULT NULL,
  `BANKNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `BANKNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qitems`
--

CREATE TABLE IF NOT EXISTS `qitems` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `QKIND` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `FORMNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `HANDNO` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `FORMDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(12) DEFAULT NULL,
  `ISCONFIRM` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `ISCHECK` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `EMPID` varchar(3) CHARACTER SET utf8 DEFAULT NULL,
  `EMPNAME` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USER` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `USERNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `TRADETYPE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `DEPTNO` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNOS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `UNITPRICE` double DEFAULT NULL,
  `DISCOUNT` double DEFAULT NULL,
  `ACOST` double DEFAULT NULL,
  `RATE` double DEFAULT NULL,
  `RATEPRICE` double DEFAULT NULL,
  `REALSUM` double DEFAULT NULL,
  `SUBPRICE` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `COLOR` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `ORDDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `FINEDATE` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COLORS` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `SIZES` varchar(256) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT10` double DEFAULT NULL,
  `UNIT20` double DEFAULT NULL,
  `UNIT30` double DEFAULT NULL,
  `UNIT40` double DEFAULT NULL,
  `PIC` tinytext,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `SEASON` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `YEAR` varchar(4) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qmtrm`
--

CREATE TABLE IF NOT EXISTS `qmtrm` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `SUPPLY` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `COUNTRY` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `SOURCENO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSTYPE` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNAME` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT1` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT2` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `UNIT` double DEFAULT NULL,
  `BATCH` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `BILL` double DEFAULT NULL,
  `BILLRATE` double DEFAULT NULL,
  `ADDCOST` double DEFAULT NULL,
  `P0` double DEFAULT NULL,
  `P1` double DEFAULT NULL,
  `P2` double DEFAULT NULL,
  `P3` double DEFAULT NULL,
  `P4` double DEFAULT NULL,
  `P5` double DEFAULT NULL,
  `SEASON` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `PS` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `COLORS` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(16) DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `PIC` text,
  `PICTURE` text,
  `QUALITY_ID` int(11) DEFAULT NULL,
  `WASH_ID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `qmtrs`
--

CREATE TABLE IF NOT EXISTS `qmtrs` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `TR` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `MID` int(11) DEFAULT NULL,
  `ID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNO` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `GOODSNOS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `COLORNO` varchar(2) CHARACTER SET utf8 DEFAULT NULL,
  `COLOR` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `SIZE` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
  `IMPO` double DEFAULT NULL,
  `IMPOS` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `OUTPO` double DEFAULT NULL,
  `OUTPOS` double DEFAULT NULL,
  `SPOS` double DEFAULT NULL,
  `SPOSS` double DEFAULT NULL,
  `IM_OUTSTK` double DEFAULT NULL,
  `IM_POSSTK` double DEFAULT NULL,
  `ORD` double DEFAULT NULL,
  `STATE` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `CREATEDATETIME` varchar(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- 表的結構 `update_yn`
--

CREATE TABLE IF NOT EXISTS `update_yn` (
  `UID` varchar(12) CHARACTER SET utf8 DEFAULT NULL,
  `Q1` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q2` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q3` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q4` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q5` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q6` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q7` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q8` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q9` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q10` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q11` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q12` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q13` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q14` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q15` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q16` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q17` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q18` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q19` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q20` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q21` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q22` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q23` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q24` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q25` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q26` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q27` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q28` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q29` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `Q30` varchar(16) CHARACTER SET utf8 DEFAULT NULL,
  `DEVISE` varchar(12) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 轉存資料表中的資料 `update_yn`
--

INSERT INTO `update_yn` (`UID`, `Q1`, `Q2`, `Q3`, `Q4`, `Q5`, `Q6`, `Q7`, `Q8`, `Q9`, `Q10`, `Q11`, `Q12`, `Q13`, `Q14`, `Q15`, `Q16`, `Q17`, `Q18`, `Q19`, `Q20`, `Q21`, `Q22`, `Q23`, `Q24`, `Q25`, `Q26`, `Q27`, `Q28`, `Q29`, `Q30`, `DEVISE`) VALUES
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA0'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA1'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA2'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'AA3'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'A11'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'B11'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'C11'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'D11'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'E11'),
('4E350_20123', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', '100000000000', 'F11');

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

--
-- 表的結構 `web_info`
--

CREATE TABLE IF NOT EXISTS `web_info` (
  `web_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `web_mode` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'footer模式選擇',
  `web_content` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'footer內容',
  `web_extension` text COLLATE utf8_unicode_ci COMMENT '保留_用於延伸功能',
  PRIMARY KEY (`web_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 轉存資料表中的資料 `web_info`
--

INSERT INTO `web_info` (`web_id`, `web_mode`, `web_content`, `web_extension`) VALUES
(6, 'index', '20141125040127.jpg', '2'),
(7, 'index', '20141125040118.jpg', '1'),
(8, 'index', '20141125040106.jpg', '3');

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

--
-- 表的結構 `web_msg_board`
--

CREATE TABLE IF NOT EXISTS `web_msg_board` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `msg_userNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '使用者編號',
  `msg_content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '留言內容',
  `msg_reply` text COLLATE utf8_unicode_ci COMMENT '回覆內容',
  `msg_createTime` datetime NOT NULL COMMENT '留言時間',
  `msg_replyTime` datetime DEFAULT NULL COMMENT '回覆時間',
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- 表的結構 `web_prod_introduction`
--

CREATE TABLE IF NOT EXISTS `web_prod_introduction` (
  `prod_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水編號',
  `BATCH` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT '批號',
  `GOODSNO` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品編號',
  `prod_detail` text COLLATE utf8_unicode_ci NOT NULL COMMENT '線上編輯器內容',
  `PIC1` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC2` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC3` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC4` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  `PIC5` text COLLATE utf8_unicode_ci COMMENT '預留欄位',
  PRIMARY KEY (`prod_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
