tg-bot-golang

1
-- +goose Up
2
-- +goose StatementBegin
3
create table if not exists usercategories
4
(
5
    id      integer generated by default as identity primary key,
6
    user_id integer not null references users (id) on delete cascade,
7
    name    text    not null
8
        constraint usercategories_name_check
9
            check (name <> ''::text)
10
);
11

12
comment on table usercategories is 'Категории расходов пользователей';
13

14
-- Индекс по пользователю и наименованию категории (lower для регистронезависимого поиска).
15
create unique index if not exists usercategories_user_id_lower_name
16
    on usercategories (user_id, lower(name));
17
-- +goose StatementEnd
18

19
-- +goose Down
20
-- +goose StatementBegin
21
drop index usercategories_user_id_lower_name;
22
DROP TABLE IF EXISTS "usercategories";
23
-- +goose StatementEnd