CREATE TABLE HIGHWAY_EXCHANGE.T_SALESPROMOTE
(
    SALESPROMOTE_ID                NUMBER(9,0) NOT NULL,
    SERVERPARTCODE                 VARCHAR2(10),
    SHOPCODE                       VARCHAR2(6),
    MACHINECODE                    VARCHAR2(6),
    SALESPROMOTE_STARTDATE         TIMESTAMP(7),
    SALESPROMOTE_ENDDATE           TIMESTAMP(7),
    SALESPROMOTE_TYPE              NUMBER(8,0),
    SALESPROMOTE_NAME              VARCHAR2(2000),
    THRESHOLD_AMOUNT               NUMBER(16,2),
    DISCOUNT_RATE                  NUMBER(16,2),
    SALESPROMOTE_VIP               NUMBER(1,0),
    FLAG                           NUMBER(4,0),
    TICKET_PREFIX                  VARCHAR2(50),
    SALESPROMOTE_DATE              TIMESTAMP(7),
    SALESPROMOTE_DESC              VARCHAR2(2000)
)
PCTFREE 10
MAXTRANS 255
TABLESPACE HIGHWAY_EXCHANGE
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
/
CREATE TABLE HIGHWAY_EXCHANGE.T_CONFIGURATION
(
    CONFIGURATION_ID               NUMBER(9,0) NOT NULL,
    CONFIGURATION_DATE             TIMESTAMP(7),
    SERVERPARTCODE                 VARCHAR2(10),
    SHOPCODE                       VARCHAR2(6),
    MACHINECODE                    VARCHAR2(6),
    MACADDRESS                     VARCHAR2(50),
    CONFIGURATION_NAME             VARCHAR2(2000),
    CONFIGURATION_VALUES           VARCHAR2(2000),
    CONFIGURATION_DESC             VARCHAR2(2000),
    FLAG                           NUMBER(1,0),
    CONSTRAINT PK_CONFIGURATION UNIQUE (MACADDRESS, CONFIGURATION_NAME) USING INDEX
        PCTFREE 10
        INITRANS 2
        MAXTRANS 255
        TABLESPACE HIGHWAY_EXCHANGE
        STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
        LOGGING
)
PCTFREE 10
MAXTRANS 255
TABLESPACE HIGHWAY_EXCHANGE
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
/