XN2L4q3m

1# 19.08.2020
2create table if not exists messages_templates
3(
4    id         int auto_increment,
5    conference varchar(255)                 not null,
6    name       varchar(255)                 not null,
7    color      varchar(7) default '#ffffff' not null,
8    background varchar(7) default '#000000' not null,
9    opacity    tinyint    default 0         not null,
10    size       tinyint    default 4        not null,
11    position   tinyint    default 1         not null,
12    speed      tinyint    default 1         not null,
13    `repeat`   tinyint    default 0         not null,
14    message    text       default ''        not null,
15    constraint messages_templates_pk
16        primary key (id)
17) ENGINE InnoDB
18  DEFAULT CHARSET utf8;
19
20# 8.10.2020
21alter table abonents_for_user
22    add `ignore` boolean default false not null;
23alter table participants
24    add `ignore` boolean default false not null;
25
26#15.10.2020
27alter table user_company
28    add four_to_three boolean default false not null;
29
30# 19.10.2020
31alter table schedule
32    add record boolean default false not null;
33
34# 20.10.2020
35create table if not exists ws_groups
36(
37    `id`                bigint(11)   NOT NULL AUTO_INCREMENT,
38    `abonent_id`        varchar(64)  NOT NULL,
39    `name`              varchar(255) NOT NULL,
40    `uuid`              varchar(64)  NOT NULL,
41    `parent_group_uuid` varchar(64)  NULL DEFAULT '',
42    PRIMARY KEY (`id`) USING BTREE
43) ENGINE = InnoDB
44  DEFAULT CHARSET utf8;
45
46alter table ws_groups
47    add unique index `group_uuid_unique` (`uuid`);
48
49create table if not exists ws_contact_groups
50(
51    `id`           bigint(11)  NOT NULL AUTO_INCREMENT,
52    `contact_uuid` varchar(64) NOT NULL,
53    `group_uuid`   varchar(64) NOT NULL,
54    PRIMARY KEY (`id`) USING BTREE
55) ENGINE = InnoDB
56  DEFAULT CHARSET utf8;
57
58alter table ws_contact_groups
59    add unique `unique_ws_group` (`contact_uuid`, `group_uuid`);
60
61# 3.11.2020
62alter table participants
63    add allow_send_h239 boolean default true not null;
64
65alter table user_company
66    add allow_send_h239 boolean default true not null;
67