-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathaudit.sql
More file actions
61 lines (57 loc) · 1.86 KB
/
audit.sql
File metadata and controls
61 lines (57 loc) · 1.86 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
DROP TABLE IF EXISTS `tbl_audit`;
CREATE TABLE `tbl_audit` (
`id` VARCHAR(100) NOT NULL,
`log_date` DATETIME NOT NULL,
`log_event` VARCHAR(20) NOT NULL,
`log_table` VARCHAR(100) NOT NULL,
`log_script` TEXT,
PRIMARY KEY (`id`),
KEY `tbl_audit_001` (`log_date`),
KEY `tbl_audit_002` (`log_event`),
KEY `tbl_audit_003` (`log_table`)
);
DROP TABLE IF EXISTS `tbl_audit_value`;
CREATE TABLE `tbl_audit_value` (
`id` VARCHAR(100) NOT NULL,
`audit_id` VARCHAR(100) NULL,
`field_name` VARCHAR(255) NULL,
`before_value` TEXT,
`after_value` TEXT,
PRIMARY KEY (`id`),
KEY `tbl_audit_value_001` (`audit_id`),
KEY `tbl_audit_value_002` (`field_name`)
);
DROP TABLE IF EXISTS `tbl_proxy`;
CREATE TABLE `tbl_proxy` (
`id` VARCHAR(100) NOT NULL,
`path` VARCHAR(1000) NULL,
`method` VARCHAR(30) NULL,
`accept` VARCHAR(255) NULL,
`request_content_type` VARCHAR(100) NULL,
`request_body` TEXT NULL,
`response_content_type` VARCHAR(100) NULL,
`response_body` TEXT NULL,
`response_status` INT(3) NULL,
`response_status_text` VARCHAR(200) NULL,
`created_datetime` DATETIME NOT NULL,
PRIMARY KEY (`id`),
KEY `001` (`created_datetime`)
);
DROP TABLE IF EXISTS `tbl_proxy_request_header`;
CREATE TABLE `tbl_proxy_request_header` (
`id` VARCHAR(100) NOT NULL,
`proxy_id` VARCHAR(100) NOT NULL,
`h_name` VARCHAR(255) NULL,
`h_value` VARCHAR(255) NULL,
PRIMARY KEY (`id`),
KEY `001` (`proxy_id`)
);
DROP TABLE IF EXISTS `tbl_proxy_response_header`;
CREATE TABLE `tbl_proxy_response_header` (
`id` VARCHAR(100) NOT NULL,
`proxy_id` VARCHAR(100) NOT NULL,
`h_name` VARCHAR(255) NULL,
`h_value` VARCHAR(255) NULL,
PRIMARY KEY (`id`),
KEY `001` (`proxy_id`)
);