CREATE TABLE IF NOT EXISTS account ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    acctext  TEXT,
    accrate  TEXT,
    accnote  TEXT,
    accmoney INTEGER,
    accsort  INTEGER,
    accpic   INTEGER,
    accinit  INTEGER
);


CREATE TABLE IF NOT EXISTS qc_color ( 
    UID  VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    NO1 VARCHAR( 2 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TXT  VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC  VARCHAR( 10 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
);

CREATE TABLE IF NOT EXISTS qc_country ( 
    UID   VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID   INTEGER,
    NAME  VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    RATE  DOUBLE,
    PIC   TEXT,
    LAMIN DOUBLE,
    LAMAX DOUBLE,
    LOMIN DOUBLE,
    LOMAX DOUBLE 
);


CREATE TABLE IF NOT EXISTS qc_default ( 
    UID        VARCHAR( 12 )CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    BILLRATE  DOUBLE,
    COUNTRY   VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BATCH     VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FACTNO    VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    STATE     VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SOURCENO  VARCHAR( 2 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRODUCT   VARCHAR( 2 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ITEMFIRST VARCHAR( 2 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SEASON    VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    YEAR      VARCHAR( 2 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMPLOY    VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ACCOUNT   VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BAROUT    VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FILEOUT   VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRINTOUT  VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CA1       VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CA2       VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CA3       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CB1       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CB2       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CB3       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CC1       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CC2       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CC3       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CD1       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CD2       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CD3       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    HID       VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qc_defpri ( 
    UID     VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    DEFPRI  VARCHAR( 8 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    P0      DOUBLE,
    P1      DOUBLE,
    P2      DOUBLE,
    P3      DOUBLE,
    P4      DOUBLE,
    P5      DOUBLE 
);

CREATE TABLE IF NOT EXISTS qc_quality ( 
    UID   VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    QUA10 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA11 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA20 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA21 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA30 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA31 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA40 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA41 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA50 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA51 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA60 VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QUA61 VARCHAR( 4 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qc_size ( 
    UID      VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    SIZES VARCHAR( 80 ) 
);

CREATE TABLE IF NOT EXISTS qc_type ( 
    UID      VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    ID       VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODTYPE VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY  VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SEASON   VARCHAR( 6 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ADDCOST  DOUBLE,
    PIC      TEXT 
);

CREATE TABLE IF NOT EXISTS qc_wash ( 
    UID    VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    WASH10 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH11 TEXT,
    WASH20 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH21 TEXT,
    WASH30 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH31 TEXT,
    WASH40 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH41 TEXT,
    WASH50 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH51 TEXT,
    WASH60 VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    WASH61 TEXT 
);

CREATE TABLE IF NOT EXISTS qcust ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    TR         VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CUSTNO     VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CUSTNAME   VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MOBIL      VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMAIL      VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MSN        VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GMAIL      VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GPSLA      DOUBLE,
    GPSLO      DOUBLE,
    DEPTNO     VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMPID      VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    DISCOUNT   DOUBLE,
    ADDRESS    VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS         VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BANKNO     VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BANKNAME   VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY    VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TRADETYPE  VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    STATE      VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC        TEXT,
    CREATEDATE VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATETIME VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BIRTHDAY   VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    C1         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    C2         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    C3         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    M1         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    M2         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    M3         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    S1         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    S2         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    S3         VARCHAR( 1 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qdept ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    DEPTID   VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    DEPTNAME VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TRADTYPE VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GPSLA    DOUBLE,
    GPSLO    DOUBLE 
);

CREATE TABLE IF NOT EXISTS qdetail ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TR             VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MID            INTEGER,
    SUPPLY         VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SOURCENO       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNO        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSTYPE      VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNAME      VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT1          VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT2          VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT           DOUBLE,
    BATCH          VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BILL           DOUBLE,
    BILLRATE       DOUBLE,
    ADDCOST        DOUBLE,
    P0             DOUBLE,
    P1             DOUBLE,
    P2             DOUBLE,
    P3             DOUBLE,
    P4             DOUBLE,
    P5             DOUBLE,
    SEASON         VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS             VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATEDATETIME VARCHAR( 12 ),
    STATE          VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC            TEXT,
    PICTURE        TEXT,
    QUALITY_ID     INT,
    WASH_ID        INT,
    COLORNO        VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COLOR          VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SIZE           VARCHAR( 256 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    INLIST         TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    IMPO           DOUBLE,
    IMPOS          DOUBLE,
    OUTPO          DOUBLE,
    OUTPOS         DOUBLE,
    SPOS           DOUBLE,
    SPOSS          DOUBLE,
    IM_OUTSTK      DOUBLE,
    IM_POSSTK      DOUBLE,
    ORD            DOUBLE,
    ACCOUNT        VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, 
    ATLIST         TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qemp ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    XID      INTEGER,
    QEMPID         VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    QEMPNAME       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MOBIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMAIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MSN            VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GMAIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GPSLA          DOUBLE,
    GPSLO          DOUBLE,
    DEPTNO         VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ADDRESS        VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS             VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    STATE          VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC            TEXT,
    BIRTHDAY       VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATEDATETIME VARCHAR( 20 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qfact ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TR             VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FACTNO         VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FACTNAME       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MOBIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMAIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MSN            VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GMAIL          VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GPSLA          DOUBLE,
    GPSLO          DOUBLE,
    DEPTNO         VARCHAR( 8 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMPID          VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    DISCOUNT       DOUBLE,
    ADDRESS        VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS             VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BANKNO         VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BANKNAME       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TRADETYPE      VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    STATE          VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC            TEXT,
    BIRTHDAY       DATETIME,
    CREATEDATETIME VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS qhead ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TR             VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ID             INTEGER,
    QKIND          VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FORMNO         VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    HANDNO         VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FORMDATE       VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATEDATETIME VARCHAR( 12 ),
    ISCONFIRM      VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ISCHECK        VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ISLIST         VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMPID          VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    EMPNAME        VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    USER           VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    USERNAME       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TRADETYPE      VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    DEPTNO         VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ORDCASH        DOUBLE,
    ORDCARD        DOUBLE,
    CASH           DOUBLE,
    CARD           DOUBLE,
    ATOT           DOUBLE,
    ORDDATE        VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    FINEDATE       VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ASUM           DOUBLE,
    BSUM           DOUBLE,
    BILLRATE       DOUBLE,
    COSTS          DOUBLE,
    TURESUM        DOUBLE,
    DISMONEY       DOUBLE,
    BANKNO         VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BANKNAME       VARCHAR( 20 )  CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    ATM            DOUBLE,
    ATMDATE        VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TRCASH         DOUBLE,
    PS             VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS1            VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS2            VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

);

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

CREATE TABLE IF NOT EXISTS qmtrm ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TR             VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MID            INTEGER,
    SUPPLY         VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COUNTRY        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SOURCENO       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNO        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSTYPE      VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNAME      VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT1          VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT2          VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    UNIT           DOUBLE,
    BATCH          VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    BILL           DOUBLE,
    BILLRATE       DOUBLE,
    ADDCOST        DOUBLE,
    P0             DOUBLE,
    P1             DOUBLE,
    P2             DOUBLE,
    P3             DOUBLE,
    P4             DOUBLE,
    P5             DOUBLE,
    SEASON         VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PS             VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COLORS         VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATEDATETIME VARCHAR( 16 ),
    STATE          VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PIC            TEXT,
    PICTURE        TEXT,
    QUALITY_ID     INTEGER,
    WASH_ID        INTEGER 
);

CREATE TABLE IF NOT EXISTS qmtrs ( 
    UID        VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    TR             VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    MID            INTEGER,
    ID             VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNO        VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    GOODSNOS       VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COLORNO        VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    COLOR          VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    SIZE           VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    IMPO           DOUBLE,
    IMPOS          VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    OUTPO          DOUBLE,
    OUTPOS         DOUBLE,
    SPOS           DOUBLE,
    SPOSS          DOUBLE,
    IM_OUTSTK      DOUBLE,
    IM_POSSTK      DOUBLE,
    ORD            DOUBLE,
    STATE          VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    CREATEDATETIME VARCHAR( 16 )
);

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

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 AUTO_INCREMENT=1 ;

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 AUTO_INCREMENT=6 ;

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 AUTO_INCREMENT=1 ;