aXtSmgHT

1# 25.11.2020
2alter table user_company
3    add quiet tinyint default 0 not null;
4
5# 11.01.2021
6alter table abonents_for_user
7    add allow_group_call boolean default false not null;
8
9create table if not exists main_settings
10(
11    id               int auto_increment,
12    allow_group_call boolean default false not null,
13    constraint main_settings_pk
14        primary key (id)
15) ENGINE = InnoDB
16  DEFAULT CHARSET utf8;
17
18# 27.01.2021
19alter table abonents_for_user
20    add interpreter boolean default false not null;
21
22create table if not exists audio_channels
23(
24    id      int auto_increment,
25    channel int                   not null,
26    title   varchar(255)          not null,
27    enabled boolean default false not null,
28    floor   boolean default false not null,
29    constraint audio_channels_pk
30        primary key (id)
31) ENGINE = InnoDB
32  DEFAULT CHARSET utf8;
33
34create unique index audio_channels_channel_uindex
35    on audio_channels (channel);
36
37insert into audio_channels (id, channel, title, enabled, floor)
38values (1, 0, 'Channel 0', true, true);
39insert into audio_channels (id, channel, title, enabled, floor)
40values (2, 1, 'Channel 1', true, false);
41insert into audio_channels (id, channel, title, enabled, floor)
42values (3, 2, 'Channel 2', true, false);
43insert into audio_channels (id, channel, title, enabled, floor)
44values (4, 3, 'Channel 3', true, false);
45insert into audio_channels (id, channel, title, enabled, floor)
46values (5, 4, 'Channel 4', true, false);
47insert into audio_channels (id, channel, title, enabled, floor)
48values (6, 5, 'Channel 5', true, false);
49insert into audio_channels (id, channel, title, enabled, floor)
50values (7, 6, 'Channel 6', true, false);
51insert into audio_channels (id, channel, title, enabled, floor)
52values (8, 7, 'Channel 7', true, false);
53insert into audio_channels (id, channel, title, enabled, floor)
54values (9, 8, 'Channel 8', true, false);
55insert into audio_channels (id, channel, title, enabled, floor)
56values (10, 9, 'Channel 9', true, false);
57insert into audio_channels (id, channel, title, enabled, floor)
58values (11, 10, 'Channel 10', true, false);
59insert into audio_channels (id, channel, title, enabled, floor)
60values (12, 11, 'Channel 11', false, false);
61insert into audio_channels (id, channel, title, enabled, floor)
62values (13, 12, 'Channel 12', false, false);
63insert into audio_channels (id, channel, title, enabled, floor)
64values (14, 13, 'Channel 13', false, false);
65insert into audio_channels (id, channel, title, enabled, floor)
66values (15, 14, 'Channel 14', false, false);
67insert into audio_channels (id, channel, title, enabled, floor)
68values (16, 15, 'Channel 15', false, false);
69insert into audio_channels (id, channel, title, enabled, floor)
70values (17, 16, 'Channel 16', false, false);
71insert into audio_channels (id, channel, title, enabled, floor)
72values (18, 17, 'Channel 17', false, false);
73insert into audio_channels (id, channel, title, enabled, floor)
74values (19, 18, 'Channel 18', false, false);
75insert into audio_channels (id, channel, title, enabled, floor)
76values (20, 19, 'Channel 19', false, false);
77
78alter table abonents_for_user
79    add private_audio_channel int default 10 not null;
80
81alter table user_company
82    add max_participants int default 0 not null;
83
84# 15.03.2021
85alter table abonents_for_user
86    add incoming_number_conversion varchar(255) default '${CALLERIDNUM}' not null;
87
88# 19.03.2021
89alter table user_company
90    alter column operator set default 'deactivated';
91
92# 12.04.2021
93alter table webcast
94    add hls_abs boolean default false not null;
95alter table webcast
96    add hls_time int default 4 not null;
97alter table webcast
98    add hls_list_size int default 4 not null;
99alter table webcast
100    add hls_path varchar(255) null;
101
102# 21.04.2021
103alter table user_company
104    add auto_quiet_channels boolean default false not null;
105
106# 12.05.2021
107alter table user_company
108    add background_img boolean default false not null;
109
110# 01.06.2021
111ALTER TABLE www_access
112    DROP PRIMARY KEY;
113
114ALTER TABLE www_access
115    ADD PRIMARY KEY (username);