Create Table Auditlog Line

-- ----------------------------
-- Table structure for auditlog_log_line
-- ----------------------------
DROP TABLE IF EXISTS "public"."auditlog_log_line";
CREATE TABLE "public"."auditlog_log_line" (
  "id" int4 NOT NULL,
  "field_id" int4 NOT NULL,
  "log_id" int4,
  "old_value" text COLLATE "pg_catalog"."default",
  "new_value" text COLLATE "pg_catalog"."default",
  "old_value_text" text COLLATE "pg_catalog"."default",
  "new_value_text" text COLLATE "pg_catalog"."default",
  "create_uid" int4,
  "create_date" timestamp(6),
  "write_uid" int4,
  "write_date" timestamp(6)
)
;
COMMENT ON COLUMN "public"."auditlog_log_line"."field_id" IS 'Field';
COMMENT ON COLUMN "public"."auditlog_log_line"."log_id" IS 'Log';
COMMENT ON COLUMN "public"."auditlog_log_line"."old_value" IS 'Old Value';
COMMENT ON COLUMN "public"."auditlog_log_line"."new_value" IS 'New Value';
COMMENT ON COLUMN "public"."auditlog_log_line"."old_value_text" IS 'Old value Text';
COMMENT ON COLUMN "public"."auditlog_log_line"."new_value_text" IS 'New value Text';
COMMENT ON COLUMN "public"."auditlog_log_line"."create_uid" IS 'Created by';
COMMENT ON COLUMN "public"."auditlog_log_line"."create_date" IS 'Created on';
COMMENT ON COLUMN "public"."auditlog_log_line"."write_uid" IS 'Last Updated by';
COMMENT ON COLUMN "public"."auditlog_log_line"."write_date" IS 'Last Updated on';
COMMENT ON TABLE "public"."auditlog_log_line" IS 'Auditlog - Log details (fields updated)';

-- ----------------------------
-- Indexes structure for table auditlog_log_line
-- ----------------------------
CREATE INDEX "auditlog_log_line_log_id_index" ON "public"."auditlog_log_line" USING btree (
  "log_id" "pg_catalog"."int4_ops" ASC NULLS LAST
);

-- ----------------------------
-- Primary Key structure for table auditlog_log_line
-- ----------------------------
ALTER TABLE "public"."auditlog_log_line" ADD CONSTRAINT "auditlog_log_line_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Foreign Keys structure for table auditlog_log_line
-- ----------------------------
ALTER TABLE "public"."auditlog_log_line" ADD CONSTRAINT "auditlog_log_line_log_id_fkey" FOREIGN KEY ("log_id") REFERENCES "public"."auditlog_log" ("id") ON DELETE CASCADE ON UPDATE NO ACTION;