### 需更新sql #### 規則 alter table t_deposit_rule add type varchar(3); alter table t_deposit_rule add pid varchar(3) default 1; alter table t_amount add wy_score number(10,2) default 0; alter table t_orders add pid varchar(3) ; INSERT INTO "TONGBAO"."T_DEPOSIT_TIME" (ID, MIN_TIME, MAX_TIME, TYPE, USERID, USERNAME, DATETIME, RATE) VALUES ('2', '2', '12', '2', '1', 'tb_admin', '1583200329', '15') 注意刪除利率表ostart: DELETE FROM t_deposit_rule; end; 創建分類表 CREATE TABLE "TONGBAO"."T_DEPOSIT_AREA" ( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(2000 BYTE), "TYPE" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "T_DEPOSIT_AREA_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_AREA"."NAME" IS '名稱'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_AREA"."TYPE" IS '類型:1商品霸王餐2物業霸王餐'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_AREA"."DATETIME" IS '創建時間'; create sequence seq_deposit_area_id increment by 1 start with 1 nomaxvalue nominvalue nocache; #### 商品訂單表 CREATE TABLE "TONGBAO"."T_DEPOSIT_SHOP" ( "ID" CHAR(10 BYTE) NOT NULL ENABLE, "SORDER" VARCHAR2(50 BYTE), "DEPOSIT_AMOUNT" VARCHAR2(200 BYTE), "DEPOSIT_SCORE" VARCHAR2(20 BYTE), "DEPOSIT_DATE" VARCHAR2(200 BYTE), "DEPOSIT_RULE" VARCHAR2(200 BYTE), "DEPOSIT_DETAILS" VARCHAR2(200 BYTE), "CUSTOMID" VARCHAR2(50 BYTE), "DATETIME" VARCHAR2(200 BYTE), "UPDATETIME" VARCHAR2(200 BYTE), "DEPOSIT_TYPE" VARCHAR2(20 BYTE) DEFAULT 0, "STATUS" VARCHAR2(20 BYTE) DEFAULT 0, "PAID_AMOUNT" VARCHAR2(20 BYTE), CONSTRAINT "T_DEPOSIT_SHOP_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 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" ENABLE ) 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_DEPOSIT_SHOP"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."SORDER" IS '商品訂單'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_AMOUNT" IS '定存的金額'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_SCORE" IS '定存計息'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_DATE" IS '定存日期'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_RULE" IS '定存規則'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_DETAILS" IS '定存信息'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."CUSTOMID" IS '會員id'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DATETIME" IS '添加時間'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."UPDATETIME" IS '修改時間'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."DEPOSIT_TYPE" IS '支付方式 1 pos 2 大額 0未選擇支付方式'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_SHOP"."STATUS" IS '0 創建中 1確定支付方式 2進行中 3支付完成 4失效 5 退款'; #### 分筆支付記錄表 CREATE TABLE "TONGBAO"."T_DEPOSIT_POINTPEN" ( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "SORDER" VARCHAR2(20 BYTE), "PAY_AMOUNT" NUMBER(10,2), "DEPOSIT_TYPE" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "PAYORDERS_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_POINTPEN"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_POINTPEN"."SORDER" IS '商品訂單'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_POINTPEN"."PAY_AMOUNT" IS '支付金額'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_POINTPEN"."DEPOSIT_TYPE" IS '支付方式 pos充值（301）302 銀行卡 303 支付寶 304 微信'; COMMENT ON COLUMN "TONGBAO"."T_DEPOSIT_POINTPEN"."DATETIME" IS '支付時間'; create sequence seq_deposit_pointpen_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_deposit_shop_id increment by 1 start with 1 nomaxvalue nominvalue nocache;