pDXsqnnj

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