Files
houston-be/db/migration/000002_add_log_schema.up.sql
Vijay Joshi 842966cb2f TP-40559 : Incident logs (#227) (#244)
* TP-40559 : Incident logs (#227)

* TP-40559 : Adding BeforeUpdate and AfterUpdate hook in Incident Entity

* TP-40936 - Added deep compare util function

* TP-40559 | Added entity and repo for logs

* TP-40559 : Added log entry support for incident level updates

* Fix zero diff issue

* Added lowercase json parameter names

* TP-40559 : Added logs for team level updates

* Initialize log service

* TP-41640 : Added api to fetch logs for particular incident/team

* Before create and after create

* Convert 2 logs to one on incident creation

* Log id populate:

* Add populate for team id

* Branch update changes

* Typo changes

* PR REVIEW CHANGES

* Nil fix

* Fix order issue

* TP-43841 | Updating fetch users from conversation to differentiate memeber and others (#245)

* Build fix

* Added migration script for logs

---------

Co-authored-by: Sriram Bhargav <sriram.bhargav@navi.com>
2023-10-19 15:47:04 +05:30

9 lines
210 B
SQL

CREATE TABLE if not exists log
(
id SERIAL PRIMARY KEY,
relation_name character varying(255),
record_id integer,
created_at timestamp without time zone,
changes jsonb,
user_info jsonb
);