kz2VGju4

1
2/*
3 Navicat Premium Data Transfer
4
5 Source Server         : local
6 Source Server Type    : PostgreSQL
7 Source Server Version : 90514
8 Source Host           : 192.168.102.25:5432
9 Source Catalog        : wms_local
10 Source Schema         : public
11
12 Target Server Type    : PostgreSQL
13 Target Server Version : 90514
14 File Encoding         : 65001
15
16 Date: 07/08/2019 15:49:44
17*/
18
19
20-- ----------------------------
21-- Table structure for auditlog_log
22-- ----------------------------
23DROP TABLE IF EXISTS "public"."auditlog_log";
24CREATE TABLE "public"."auditlog_log" (
25  "id" int4 NOT NULL,
26  "name" varchar(64) COLLATE "pg_catalog"."default",
27  "model_id" int4,
28  "res_id" int4,
29  "user_id" int4,
30  "method" varchar(64) COLLATE "pg_catalog"."default",
31  "http_session_id" int4,
32  "http_request_id" int4,
33  "log_type" varchar COLLATE "pg_catalog"."default",
34  "create_uid" int4,
35  "create_date" timestamp(6),
36  "write_uid" int4,
37  "write_date" timestamp(6)
38)
39;
40COMMENT ON COLUMN "public"."auditlog_log"."name" IS 'Resource Name';
41COMMENT ON COLUMN "public"."auditlog_log"."model_id" IS 'Model';
42COMMENT ON COLUMN "public"."auditlog_log"."res_id" IS 'Resource ID';
43COMMENT ON COLUMN "public"."auditlog_log"."user_id" IS 'User';
44COMMENT ON COLUMN "public"."auditlog_log"."method" IS 'Method';
45COMMENT ON COLUMN "public"."auditlog_log"."http_session_id" IS 'Session';
46COMMENT ON COLUMN "public"."auditlog_log"."http_request_id" IS 'HTTP Request';
47COMMENT ON COLUMN "public"."auditlog_log"."log_type" IS 'Type';
48COMMENT ON COLUMN "public"."auditlog_log"."create_uid" IS 'Created by';
49COMMENT ON COLUMN "public"."auditlog_log"."create_date" IS 'Created on';
50COMMENT ON COLUMN "public"."auditlog_log"."write_uid" IS 'Last Updated by';
51COMMENT ON COLUMN "public"."auditlog_log"."write_date" IS 'Last Updated on';
52COMMENT ON TABLE "public"."auditlog_log" IS 'Auditlog - Log';
53
54-- ----------------------------
55-- Primary Key structure for table auditlog_log
56-- ----------------------------
57ALTER TABLE "public"."auditlog_log" ADD CONSTRAINT "auditlog_log_pkey" PRIMARY KEY ("id");