xz0c2mZF

1drop table activity_log_basics;
2create table if not exists activity_log_basics
3(
4	id int auto_increment
5		primary key,
6	user_id int null,
7	client_id int null,
8	organization_id int null,
9	user_type varchar(255) null,
10	user_name varchar(255) null,
11	action varchar(255) null,
12	actioned_user_id int null,
13	actioned_user varchar(255) null,
14	actioned_user_role varchar(255) null,
15	vacancy_id int null,
16	vacancy_role varchar(255) null,
17	vacancy_company varchar(255) null,
18	message varchar(255) null,
19	created_at datetime not null,
20	updated_at datetime not null,
21	constraint activity_log_basics_ibfk_1
22		foreign key (user_id) references users (id),
23	constraint activity_log_basics_ibfk_2
24		foreign key (organization_id) references organizations (id),
25	constraint activity_log_basics_ibfk_3
26		foreign key (actioned_user_id) references users (id),
27	constraint activity_log_basics_ibfk_4
28		foreign key (vacancy_id) references basic_vacancies (id)
29);
30
31create index actioned_user_id
32	on activity_log_basics (actioned_user_id);
33
34create index organization_id
35	on activity_log_basics (organization_id);
36
37create index user_id
38	on activity_log_basics (user_id);
39
40create index vacancy_id
41	on activity_log_basics (vacancy_id);