Настройка и установка PostgreSQL

Необходимо выполнить если вы используете НЕ локальную базу данных

Скачать последнюю версию ПГадмин тут - https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

При установке - запрашивает пароль, пароль надо запомнить и сохранить, это ваш доступ к базе.

при установке, уберите чекбокс Stack Builder

ВАЖНО!!!!!

При установке - запрашивает пароль, пароль надо запомнить и сохранить, это ваш доступ к базе.

Если у вас нету спец порта, оставьте дефолт значение.

Опционально!

Смените дефолт локацию на ru-Ru (Москва)

После установки базы данных открыть консоль:

В открывшимся окне ввести:

create table public.profiles_old
(
    name            varchar(150),
    path            varchar(255),
    cookies         integer     default 0                     not null,
    proxy           varchar(255),
    login_yandex    varchar(50),
    number_of_uses  integer     default 0,
    now_in_work     timestamp,
    last_use        timestamp   default now()                 not null,
    status          varchar(50) default ''::character varying not null,
    create_date     timestamp   default now()                 not null,
    useragent       varchar(255),
    device          varchar(50),
    group_name      varchar(50),
    id              integer generated by default as identity
        constraint profiles_pkey
            primary key,
    warming_repeat  integer     default 0                     not null,
    geo_name        varchar(64),
    warming_counter integer     default 0,
    last_warm       timestamp,
    geo_google      varchar(64),
    end_of_work     timestamp,
    last_promotion  timestamp,
    used_domains    text        default ''::text              not null,
    cookies_text    text,
    local_storage   text,
    fingerprint     text,
    geo_coord       varchar(50),
    yandex_account  bigint
);

comment on column public.profiles_old.geo_name is 'Гео (название)';

comment on column public.profiles_old.geo_google is 'Гео (google)';

alter table public.profiles_old
    owner to postgres;

create index profiles_device_index
    on public.profiles_old (device);

create index profiles_path_index
    on public.profiles_old (path);

create index profiles_status_index
    on public.profiles_old (status);

create index profiles_useragent_index
    on public.profiles_old (useragent);

create index profiles_group_name_index
    on public.profiles_old (group_name);

create index profiles_group_index
    on public.profiles_old (group_name);

create table public.accounts
(
    id            serial
        constraint id
            primary key,
    login         varchar(50)             not null,
    password      varchar(50),
    recovery_code varchar(50),
    cookies       text,
    phone         varchar(50),
    first_name    varchar(100),
    last_name     varchar(100),
    code_question varchar(100),
    stolen        boolean,
    status        varchar(50),
    date_create   timestamp default now() not null,
    site          varchar(30),
    constraint accounts_pk
        unique (login, site)
);

comment on column public.accounts.login is 'Логин';

comment on column public.accounts.password is 'Пароль';

comment on column public.accounts.recovery_code is 'Кодовое слово';

comment on column public.accounts.cookies is 'COOKIES';

comment on column public.accounts.phone is 'Телефон';

comment on column public.accounts.first_name is 'Имя';

comment on column public.accounts.last_name is 'Фамилия';

comment on column public.accounts.code_question is 'Вопрос кодового слова';

comment on column public.accounts.stolen is 'Украденый';

comment on column public.accounts.status is 'Статус';

comment on column public.accounts.date_create is 'Дата создания';

alter table public.accounts
    owner to postgres;

create unique index accounts_login_uindex
    on public.accounts (login);

create table public.dzen
(
    id            serial
        constraint dzen_pk
            primary key,
    login         varchar(50),
    psevdonim     varchar(50),
    url_channel   varchar(255),
    dashboard     varchar(255),
    article_count integer   default 0     not null,
    status        varchar(50),
    date_create   timestamp default now() not null
);

comment on column public.dzen.login is 'Логин';

comment on column public.dzen.psevdonim is 'Псевдоним для профиля';

comment on column public.dzen.url_channel is 'Ссылка на канал';

comment on column public.dzen.dashboard is 'Панель управления каналом';

comment on column public.dzen.article_count is 'Количество статей';

comment on column public.dzen.status is 'Статус';

comment on column public.dzen.date_create is 'Дата создания';

alter table public.dzen
    owner to postgres;

create table public.tasks
(
    id          serial
        constraint tasks_pk
            primary key,
    project     varchar(64),
    query       varchar(255),
    target      text,
    "limit"     integer   default 1 not null,
    used        integer   default 0 not null,
    success     integer   default 0 not null,
    failed      integer   default 0 not null,
    last_used   timestamp,
    create_date timestamp default now(),
    soft        varchar(30),
    geo         varchar(32)
);

alter table public.tasks
    owner to postgres;

create index tasks_geo_index
    on public.tasks (geo);

create index tasks_project_index
    on public.tasks (project);

create index tasks_soft_index
    on public.tasks (soft);

create table public.marketplaces
(
    id   serial
        constraint marketplaces_pk
            primary key,
    type varchar(30)
);

alter table public.marketplaces
    owner to postgres;

create table public.dzen_articles
(
    id     serial
        constraint dzen_articles_pk
            primary key,
    chanel integer
        constraint dzen_articles_dzen_id_fk
            references public.dzen,
    title  varchar(128),
    url    varchar(255)
);

alter table public.dzen_articles
    owner to postgres;

create table public.test
(
    id serial
        constraint test_pk
            primary key,
    x  integer
);

alter table public.test
    owner to postgres;

create table public.uses
(
    profile bigint,
    task    bigint
        constraint uses_tasks_id_fk
            references public.tasks,
    project varchar(128),
    date    timestamp default CURRENT_TIMESTAMP not null
);

alter table public.uses
    owner to postgres;

create index uses_profile_index
    on public.uses (profile);

create index uses_project_index
    on public.uses (project);

create table public.fingerprints
(
    text text,
    hash varchar(32)
        constraint fingerprints_pk_2
            unique
);

alter table public.fingerprints
    owner to postgres;

create table public.profiles_data
(
    id            bigint
        constraint profiles_data_profiles_id_fk
            references public.profiles_old
            on delete cascade,
    cookies       text,
    local_storage text,
    fingerprint   text
);

alter table public.profiles_data
    owner to postgres;

create table public.profiles
(
    id              integer generated by default as identity
        constraint profiles_pkey1
            primary key,
    name            varchar(150),
    group_name      varchar(50),
    path            varchar(255) default ''::character varying,
    cookies         integer      default 0                     not null,
    proxy           varchar(255),
    status          varchar(50)  default ''::character varying not null,
    warming_counter integer      default 0,
    number_of_uses  integer      default 0,
    warming_repeat  integer      default 0                     not null,
    now_in_work     timestamp,
    last_use        timestamp    default now()                 not null,
    create_date     timestamp    default now()                 not null,
    last_warm       timestamp,
    end_of_work     timestamp,
    last_promotion  timestamp,
    useragent       varchar(255),
    device          varchar(50),
    geo_name        varchar(64)  default ''::character varying,
    geo_coord       varchar(50)  default ''::character varying,
    geo_google      varchar(64)  default ''::character varying,
    login_yandex    varchar(50),
    yandex_account  bigint,
    used_domains    text         default ''::text              not null,
    cookies_text    text         default ''::text              not null,
    local_storage   text         default ''::text              not null,
    fingerprint     text         default ''::text              not null
);

alter table public.profiles
    owner to postgres;

Далее нажать кнопку "плей":