mirror of
https://github.com/retailcrm/mg-bot-helper.git
synced 2025-04-18 08:20:59 +00:00
17 lines
514 B
SQL
17 lines
514 B
SQL
create table connection
|
|
(
|
|
id serial not null constraint connection_pkey primary key,
|
|
client_id varchar(70) not null,
|
|
api_key varchar(100) not null,
|
|
api_url varchar(255) not null,
|
|
mg_url varchar(255) not null,
|
|
mg_token varchar(100) not null,
|
|
commands jsonb,
|
|
created_at timestamp with time zone,
|
|
updated_at timestamp with time zone,
|
|
active boolean,
|
|
lang varchar(2) not null
|
|
);
|
|
|
|
alter table connection
|
|
add constraint connection_key unique (client_id, mg_token);
|