6月9日2.24版本數據庫變動情況 · 通寶+平臺

alter table t_customs add lv VARCHAR2(200); alter table t_buried_point add source_code VARCHAR2(20) DEFAULT 1001; alter table t_control_role modify node_id varchar2(2000); alter table t_customs add tags VARCHAR2(2000); create sequence seq_order_score_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_welfare_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_goods_type_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_custom_class_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_welfare_custom_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_tags_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_white_list_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_ORDER_SCORE" ( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE, "NUM" VARCHAR2(50 BYTE), "TYPE" VARCHAR2(20 BYTE), "PAYTYPE" VARCHAR2(20 BYTE), "CUSTOMID" CHAR(8 BYTE), "AMOUNT" NUMBER(12,2), "ORDERNO" VARCHAR2(50 BYTE), "DATETIME" VARCHAR2(20 BYTE), "SOURCE_TYPE" VARCHAR2(20 BYTE), "SOURCE_CODE" VARCHAR2(20 BYTE), CONSTRAINT "TABLE1_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."NUM" IS '流水號'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."TYPE" IS '類型1:贈送 2 :退款'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."PAYTYPE" IS '渠道類型:默認404'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."CUSTOMID" IS '會員ID'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."AMOUNT" IS '金額'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."ORDERNO" IS '外部訂單號'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."DATETIME" IS '時間'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."SOURCE_TYPE" IS '類型1.活動贈送 2.消費贈送'; COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."SOURCE_CODE" IS '渠道號(app:1001 洛陽小程序:2001 物業霸王餐:9001)'; CREATE TABLE "TONGBAO"."T_GOODS_TYPE" ( "ID" NUMBER(12,0) NOT NULL ENABLE, "NAME" VARCHAR2(2000 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "T_GOODS_TYPE_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."NAME" IS '商品名稱'; COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."DATETIME" IS '創建時間'; CREATE TABLE "TONGBAO"."T_WELFARE" ( "ID" NUMBER(20,0) NOT NULL ENABLE, "TYPE" VARCHAR2(20 BYTE), "AMOUNT" NUMBER(12,2), "GID" NUMBER(20,0), "FREQUENCY" NUMBER(10,2), "USERNAME" VARCHAR2(200 BYTE), "USERID" CHAR(8 BYTE), "STATUS" CHAR(8 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "T_WELFARE_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."TYPE" IS '類型1:折扣 2 :減免'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."AMOUNT" IS '(1.累計金額)(2.減免金額)'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."GID" IS '福利類型ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."STATUS" IS '1:啟用2:禁用'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."FREQUENCY" IS '減免次數或者折扣力度'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."USERNAME" IS '創建者名稱'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."USERID" IS '創建者ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."DATETIME" IS '添加時間'; CREATE TABLE "TONGBAO"."T_CUSTOM_CLASS" ( "ID" NUMBER(20,0) NOT NULL ENABLE, "TITLE" VARCHAR2(500 BYTE), "IMG" VARCHAR2(2000 BYTE), "WID" VARCHAR2(2000 BYTE), "COUTENT" VARCHAR2(2000 BYTE), "USERNAME" VARCHAR2(2000 BYTE), "USERID" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "T_CUSTOM_CLASS_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."TITLE" IS '標題'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."IMG" IS '圖標地址'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."WID" IS '會員福利編號'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."COUTENT" IS '等級描述'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."USERNAME" IS '創建者'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."USERID" IS '創建ID'; COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."DATETIME" IS '創建時間'; CREATE TABLE "TONGBAO"."T_WELFARE_CUSTOM" ( "ID" NUMBER(20,0), "TYPE" VARCHAR2(2 BYTE), "AMOUNT" NUMBER(20,2), "END_AMOUNT" NUMBER(20,2), "WID" VARCHAR2(2000 BYTE), "CUSTOMID" CHAR(8 BYTE), "LV" VARCHAR2(200 BYTE), "GID" VARCHAR2(20 BYTE), "FREQUENCY" VARCHAR2(20 BYTE), "END_FREQUENCY" VARCHAR2(20 BYTE), "ENABLE" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), "ENDTIME" VARCHAR2(20 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."TYPE" IS '類型1:折扣 2 :減免'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."AMOUNT" IS '(1.累計金額)(2.減免金額)'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."END_AMOUNT" IS '(剩余累計金額)'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."WID" IS '福利ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."CUSTOMID" IS '會員ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."LV" IS '會員等級 '; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."GID" IS '福利類型ID'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."FREQUENCY" IS '次數或者折扣力度'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."END_FREQUENCY" IS '剩余次數'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ENABLE" IS '1.啟用 2.關閉'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."DATETIME" IS '添加時間'; COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ENDTIME" IS '關閉時間'; CREATE TABLE "TONGBAO"."T_TAGS" ( "ID" NUMBER(20,0), "COUTENT" VARCHAR2(2000 BYTE), "TITLE" VARCHAR2(2000 BYTE), "NUMBERS" NUMBER(14,0), "USERNAME" VARCHAR2(200 BYTE), "USERID" NUMBER(20,0), "DATETIME" VARCHAR2(20 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."COUTENT" IS '內容描述'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."TITLE" IS '標題'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."NUMBERS" IS '人數'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."USERNAME" IS '創建人'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."USERID" IS '創建人ID'; COMMENT ON COLUMN "TONGBAO"."T_TAGS"."DATETIME" IS '創建時間'; alter table t_tags add status VARCHAR2(20) DEFAULT 1; CREATE TABLE "TONGBAO"."T_WHITE_LIST" ( "ID" NUMBER(20,0) NOT NULL ENABLE, "CUSTOMID" CHAR(8 BYTE) NOT NULL ENABLE, "LARGE_STATUS" VARCHAR2(20 BYTE), "TEST_STATUS" VARCHAR2(20 BYTE), "RANSOM_STATUS" VARCHAR2(20 BYTE), "USERID" VARCHAR2(20 BYTE), "USERNAME" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE), CONSTRAINT "T_WHITE_LIST_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."CUSTOMID" IS '會員ID'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."LARGE_STATUS" IS '大額狀態 1:啟用2:禁用'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."TEST_STATUS" IS '測試狀態 1:啟用2:禁用'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."RANSOM_STATUS" IS '贖回狀態 1:啟用2:禁用'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."USERID" IS '創建人ID'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."USERNAME" IS '創建人姓名'; COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."DATETIME" IS '添加時間'; alter table t_custom_class add numbers NUMBER(12) DEFAULT 0; CREATETABLE"TONGBAO"."T_FREE_ORDER" ???( "ID"CHAR(10?BYTE)?NOTNULLENABLE, "OUT_ORDER"VARCHAR2(100?BYTE)?DEFAULT?0,? "FREE_NUM"VARCHAR2(50?BYTE)?NOTNULLENABLE,? "AMOUNT"NUMBER(10,2)?DEFAULT?0,? "TYPE"VARCHAR2(20?BYTE)?NOTNULLENABLE,? "PANTERID"CHAR(8?BYTE)?NOTNULLENABLE,? "CUSTOMID"CHAR(8?BYTE)?NOTNULLENABLE, "FREE_LV"VARCHAR2(100?BYTE),? "FREE_AMOUNT"NUMBER(10,2)?DEFAULT?0, "STATUS"VARCHAR2(20?BYTE)?NOTNULLENABLE,? "ORDERTIME"VARCHAR2(20?BYTE)?NOTNULLENABLE,? "DATETIME"VARCHAR2(20?BYTE)?NOTNULLENABLE,? "UPDATETIME"VARCHAR2(20?BYTE)?NOTNULLENABLE,? CONSTRAINT"T_FREE_ORDER_PK"PRIMARYKEY?("ID") USING?INDEX?PCTFREE?10?INITRANS?2?MAXTRANS?255?COMPUTE?STATISTICS ??STORAGE(INITIAL?65536NEXT1048576?MINEXTENTS?1?MAXEXTENTS?2147483645 ??PCTINCREASE?0?FREELISTS?1?FREELIST?GROUPS?1?BUFFER_POOL?DEFAULT?FLASH_CACHE?DEFAULT?CELL_FLASH_CACHE?DEFAULT) ??TABLESPACE?"JYCARD"ENABLE ???)?SEGMENT?CREATION?IMMEDIATE ??PCTFREE?10?PCTUSED?40?INITRANS?1?MAXTRANS?255?NOCOMPRESS?LOGGING ??STORAGE(INITIAL?65536NEXT1048576?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_FREE_ORDER"."OUT_ORDER"?IS?'消費訂單號'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."FREE_NUM"?IS?'免單訂單號'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."AMOUNT"?IS?'消費金額'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."TYPE"?IS?'免單的類型?1:?自有資金??2:?備付金（至尊卡）3?通寶?4?通寶+'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."PANTERID"?IS?'商戶id'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."CUSTOMID"?IS?'會員id'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."FREE_LV"?IS?'免單等級'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."FREE_AMOUNT"?IS?'免單金額'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."ID"?IS?'ID'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."STATUS"?IS?'類型?1?申請免單，2免單成功?3，免單失敗?'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."ORDERTIME"?IS?'消費訂單的時間'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."DATETIME"?IS?'下單的時間'; ???COMMENT?ON?COLUMN?"TONGBAO"."T_FREE_ORDER"."UPDATETIME"?IS?'更新的時間'; createsequence?seq_free_order_id increment?by1 startwith1 NOMAXVALUE NOMINVALUE NOCACHE; alter table T_CONSUME add SUBSIDY VARCHAR2(100 BYTE); COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."SUBSIDY" IS '補貼'; alter table T_CONSUME add ORIGINAL_PRICEVARCHAR2(100 BYTE); COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."ORIGINAL_PRICE" IS '折扣前訂單金額'; alter table T_CONSUME_BACK add SUBSIDY VARCHAR2(100 BYTE); COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."SUBSIDY" IS '補貼';