Chakratos / mhf-save-manager

A Webapplication to manage Character saves used by the MHF Server emulator Erupe
53 stars 10 forks source link

distribution error: TableNotFoundException #2

Closed jenkshi closed 2 years ago

jenkshi commented 2 years ago

hi, I run into this issue can you help me please, I know I need to creat a distribution table but can it be empty ? image image

Chakratos commented 2 years ago

Greetings, the Schema for the Distribution table will be released when the Erupe update launches, can't tell you when its ready for release and sadly one thing won't work without the other.

But i can post you the Schema here so you can look over the feature in the meantime:

create table distribution
(
    id               serial
        primary key,
    character_id     integer,
    type             integer                                          not null,
    deadline         timestamp,
    event_name       text    default 'GM Gift!'::text                 not null,
    description      text    default '~C05You received a gift!'::text not null,
    times_acceptable integer default 1                                not null,
    min_hr           integer default 65535                            not null,
    max_hr           integer default 65535                            not null,
    min_sr           integer default 65535                            not null,
    max_sr           integer default 65535                            not null,
    min_gr           integer default 65535                            not null,
    max_gr           integer default 65535                            not null,
    data             bytea                                            not null
);

alter table distribution
    owner to postgres;

create table distributions_accepted
(
    distribution_id integer,
    character_id    integer
);

alter table distributions_accepted
    owner to postgres;