4UDEaTtq

1-- ----------------------------
2-- Table structure for auditlog_log_line
3-- ----------------------------
4DROP TABLE IF EXISTS "public"."auditlog_log_line";
5CREATE TABLE "public"."auditlog_log_line" (
6  "id" int4 NOT NULL,
7  "field_id" int4 NOT NULL,
8  "log_id" int4,
9  "old_value" text COLLATE "pg_catalog"."default",
10  "new_value" text COLLATE "pg_catalog"."default",
11  "old_value_text" text COLLATE "pg_catalog"."default",
12  "new_value_text" text COLLATE "pg_catalog"."default",
13  "create_uid" int4,
14  "create_date" timestamp(6),
15  "write_uid" int4,
16  "write_date" timestamp(6)
17)
18;
19COMMENT ON COLUMN "public"."auditlog_log_line"."field_id" IS 'Field';
20COMMENT ON COLUMN "public"."auditlog_log_line"."log_id" IS 'Log';
21COMMENT ON COLUMN "public"."auditlog_log_line"."old_value" IS 'Old Value';
22COMMENT ON COLUMN "public"."auditlog_log_line"."new_value" IS 'New Value';
23COMMENT ON COLUMN "public"."auditlog_log_line"."old_value_text" IS 'Old value Text';
24COMMENT ON COLUMN "public"."auditlog_log_line"."new_value_text" IS 'New value Text';
25COMMENT ON COLUMN "public"."auditlog_log_line"."create_uid" IS 'Created by';
26COMMENT ON COLUMN "public"."auditlog_log_line"."create_date" IS 'Created on';
27COMMENT ON COLUMN "public"."auditlog_log_line"."write_uid" IS 'Last Updated by';
28COMMENT ON COLUMN "public"."auditlog_log_line"."write_date" IS 'Last Updated on';
29COMMENT ON TABLE "public"."auditlog_log_line" IS 'Auditlog - Log details (fields updated)';
30
31-- ----------------------------
32-- Indexes structure for table auditlog_log_line
33-- ----------------------------
34CREATE INDEX "auditlog_log_line_log_id_index" ON "public"."auditlog_log_line" USING btree (
35  "log_id" "pg_catalog"."int4_ops" ASC NULLS LAST
36);
37
38-- ----------------------------
39-- Primary Key structure for table auditlog_log_line
40-- ----------------------------
41ALTER TABLE "public"."auditlog_log_line" ADD CONSTRAINT "auditlog_log_line_pkey" PRIMARY KEY ("id");
42
43-- ----------------------------
44-- Foreign Keys structure for table auditlog_log_line
45-- ----------------------------
46ALTER 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;