alter table T_GIVE add "GIVESTATUS" VARCHAR2(20 BYTE) DEFAULT 1 ; COMMENT ON COLUMN "TONGBAO"."T_GIVE"."GIVESTATUS" IS '1是領取，2是未領取'; alter table t_customs add binding_time varchar2(20) ; comment on column t_customs.binding_time is '綁定時間'; alter table T_ACCOUNTDETAILS add "GIVESTATUS" VARCHAR2(20 BYTE) DEFAULT 1 ; COMMENT ON COLUMN T_ACCOUNTDETAILS.GIVESTATUS IS '1是領取，2是未領取'; update T_ACCOUNTDETAILS set GIVESTATUS='1'; update t_give set GIVESTATUS='1'; alter table T_CUSTOMS add "FIRSTSHARE" VARCHAR2(20 BYTE) DEFAULT 0 ; COMMENT ON COLUMN "TONGBAO"."T_CUSTOMS"."FIRSTSHARE" IS '0是首次分享未領取，1是領取'; alter table t_white_list add share_status VARCHAR2(200) DEFAULT 2; INSERT INTO "TONGBAO"."T_STEWARD_SHARE" (ID, NUMBERS, AMOUNT, STATUS) VALUES ('1', '10', '10', '1') alter table t_amount add brokerage_amount number(10,4) DEFAULT 0; comment on column t_amount.brokerage_amount is '傭金'; alter table t_custom_class add setting_img VARCHAR2(2000); comment on column t_custom_class.setting_img is '背景圖片'; alter table t_customs add nnt number(12,0) DEFAULT 0; comment on column t_customs.nnt is '人數'; create sequence seq_day_brokerage_detail_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_day_brokerage_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_arguments_id increment by 1 start with 1 nomaxvalue nominvalue nocache; CREATE TABLE "TONGBAO"."T_STEWARD_SHARE" ( "ID" NUMBER(10,0), "NUMBERS" NUMBER(10,2), "AMOUNT" NUMBER(10,2), "STATUS" VARCHAR2(2 BYTE), "IMG_URL" VARCHAR2(4000 BYTE), "CONTENT" CLOB, "USERID" VARCHAR2(20 BYTE), "USERNAME" VARCHAR2(2000 BYTE), "DATETIME" VARCHAR2(200 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" LOB ("CONTENT") STORE AS BASICFILE ( TABLESPACE "TONGBAO" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE 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)) ; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."NUMBERS" IS '分傭利率'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."AMOUNT" IS '首次分享獎勵'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."STATUS" IS '狀態'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."IMG_URL" IS '圖片地址'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."CONTENT" IS '協議內容'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."USERID" IS 'userID'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."USERNAME" IS '創建人姓名'; COMMENT ON COLUMN "TONGBAO"."T_STEWARD_SHARE"."DATETIME" IS '創建時間'; CREATE TABLE "TONGBAO"."T_DAY_BROKERAGE_DETAIL" ( "ID" NUMBER(12,0), "CUSTOMID" CHAR(8 BYTE), "SUPERIOR" CHAR(8 BYTE), "SCORE" NUMBER(12,4), "AMOUNT" NUMBER(10,4), "DATEYMD" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."CUSTOMID" IS '會員ID'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."SUPERIOR" IS '管家ID'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."SCORE" IS '贈送積分'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."AMOUNT" IS '應得積分(傭金)'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."DATEYMD" IS '日期'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE_DETAIL"."DATETIME" IS '時間戳'; CREATE TABLE "TONGBAO"."T_DAY_BROKERAGE" ( "ID" NUMBER(12,0), "SUPERIOR" CHAR(8 BYTE), "AMOUNT" NUMBER(12,4), "DATEYMD" VARCHAR2(20 BYTE), "DATETIME" VARCHAR2(20 BYTE) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING TABLESPACE "TONGBAO" ; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE"."SUPERIOR" IS '管家ID'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE"."AMOUNT" IS '當日傭金'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE"."DATEYMD" IS '日期'; COMMENT ON COLUMN "TONGBAO"."T_DAY_BROKERAGE"."DATETIME" IS '時間戳'; CREATE TABLE "TONGBAO"."T_ARGUMENTS" ( "ID" NUMBER(12,0) NOT NULL ENABLE, "TITLE" VARCHAR2(4000 BYTE), "TEST" VARCHAR2(4000 BYTE), "PRE" VARCHAR2(4000 BYTE), "MASTER" VARCHAR2(4000 BYTE), "USERID" VARCHAR2(2000 BYTE), "USERNAME" VARCHAR2(2000 BYTE), "DATETIME" VARCHAR2(200 BYTE), CONSTRAINT "T_ARGUMENTS_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_ARGUMENTS"."ID" IS 'ID'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."TITLE" IS '標題'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."TEST" IS '測試'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."PRE" IS '預生產'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."MASTER" IS '生產'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."USERID" IS '創建人ID'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."USERNAME" IS '創建人姓名'; COMMENT ON COLUMN "TONGBAO"."T_ARGUMENTS"."DATETIME" IS '創建時間';