**變更大額訂單表，增加已經領取狀態** alter table T_SPECIAL_RECHARGE add "PULL_DOWN" VARCHAR2(2 BYTE) DEFAULT 0 ; COMMENT ON COLUMN T_SPECIAL_RECHARGE.PULL_DOWN IS '0是沒有,1是領取'; **處理之前得訂單，默認之前成功得全部已經領取** update T_SPECIAL_RECHARGE set PULL_DOWN='1' where STATUS='3'; CREATE TABLE "TONGBAO"."T_REMI_RULE" ( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "AMOUNT" NUMBER(10,2) NOT NULL ENABLE, "LESSRATE" NUMBER(10,3), "GREATERRATE" NUMBER(10,3), "DAY" NUMBER(10,0), "USERNAME" VARCHAR2(200 BYTE), "USERID" VARCHAR2(20 BYTE), "MAXAMOUNT" NUMBER(10,2), "DATETIME" VARCHAR2(20 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."AMOUNT" IS '金額'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."LESSRATE" IS '贈送最小利率'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."GREATERRATE" IS '贈送最大利率'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."DAY" IS '天數'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."USERNAME" IS '姓名'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."USERID" IS '用戶ID'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."MAXAMOUNT" IS '最大贈送限額'; COMMENT ON COLUMN "TONGBAO"."T_REMI_RULE"."DATETIME" IS '更改時間';