CREATE TABLE public.dwd_platform_login_m (
    game_id integer NOT NULL,
    user_id integer NOT NULL,
    user_account text,
    promote_id integer,
    platform_id integer,
    login_time integer,
    login_ip text,
    ds date NOT NULL
    ,PRIMARY KEY (game_id, user_id, ds)
)
  LOGICAL  PARTITION BY LIST (ds)
 WITH (
    orientation = 'column',
    distribution_key = 'game_id',
    partition_expiration_time = '138 day',
    partition_require_filter = TRUE

);


CREATE TABLE public.dwd_user_profile_lt (
    account text NOT NULL,
    game_id integer NOT NULL,
    ds date NOT NULL,
    total_order bigint,
    total_payment bigint,
    total_played integer,
    first_login timestamp with time zone,
    last_login timestamp with time zone,
    gd integer,
    sd integer,
    ld integer,
    score numeric(10,2)
    ,PRIMARY KEY (account, game_id, ds)
)
  LOGICAL  PARTITION BY LIST (ds)
 WITH (
    orientation = 'column',
    distribution_key = 'game_id',
    partition_expiration_time = '180 day',
    partition_require_filter = TRUE

);




CREATE TABLE public.ods_rollserv_user (
    game_id integer,
    server_id integer,
    user_account text,
    role_id text,
    role_name text,
    job integer,
    level integer,
    exp bigint,
    relevel integer,
    platform_id text,
    create_time timestamp with time zone,
    ds date NOT NULL
)

  LOGICAL  PARTITION BY LIST (ds)
 WITH (
    orientation = 'column',
    distribution_key = 'game_id',
    partition_expiration_time = '180 day',
    partition_require_filter = TRUE

);



