-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathaudit_triggers.sql
More file actions
196 lines (185 loc) · 5.21 KB
/
Copy pathaudit_triggers.sql
File metadata and controls
196 lines (185 loc) · 5.21 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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
-- Auto-generated: AFTER INSERT / AFTER UPDATE triggers for every table
-- that has CreatedAt_Ticks and UpdatedAt_Ticks columns.
-- Tables found: FilesDb (FileClassification, FileClassificationKeyword)
-- AppDb (ConnectionStrings, FileClassificationCategories, ModelToIgnore,
-- ScrapeConfiguration, ScrapeDirectories, SearchCategories,
-- SearchConfiguration, TagToIgnore, UserConfiguration)
-- FilesDb
CREATE TRIGGER IF NOT EXISTS tr_FileClassification_update
AFTER UPDATE
ON FileClassification
BEGIN
UPDATE FileClassification
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_FileClassification_insert
AFTER INSERT
ON FileClassification
BEGIN
UPDATE FileClassification
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_FileClassificationKeyword_update
AFTER UPDATE
ON FileClassificationKeyword
BEGIN
UPDATE FileClassificationKeyword
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_FileClassificationKeyword_insert
AFTER INSERT
ON FileClassificationKeyword
BEGIN
UPDATE FileClassificationKeyword
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
-- AppDb
CREATE TRIGGER IF NOT EXISTS tr_ConnectionStrings_update
AFTER UPDATE
ON ConnectionStrings
BEGIN
UPDATE ConnectionStrings
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ConnectionStrings_insert
AFTER INSERT
ON ConnectionStrings
BEGIN
UPDATE ConnectionStrings
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_FileClassificationCategories_update
AFTER UPDATE
ON FileClassificationCategories
BEGIN
UPDATE FileClassificationCategories
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_FileClassificationCategories_insert
AFTER INSERT
ON FileClassificationCategories
BEGIN
UPDATE FileClassificationCategories
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ModelToIgnore_update
AFTER UPDATE
ON ModelToIgnore
BEGIN
UPDATE ModelToIgnore
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ModelToIgnore_insert
AFTER INSERT
ON ModelToIgnore
BEGIN
UPDATE ModelToIgnore
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ScrapeConfiguration_update
AFTER UPDATE
ON ScrapeConfiguration
BEGIN
UPDATE ScrapeConfiguration
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ScrapeConfiguration_insert
AFTER INSERT
ON ScrapeConfiguration
BEGIN
UPDATE ScrapeConfiguration
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ScrapeDirectories_update
AFTER UPDATE
ON ScrapeDirectories
BEGIN
UPDATE ScrapeDirectories
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_ScrapeDirectories_insert
AFTER INSERT
ON ScrapeDirectories
BEGIN
UPDATE ScrapeDirectories
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
-- SearchCategories has a composite PK (SearchConfigurationId, Id)
CREATE TRIGGER IF NOT EXISTS tr_SearchCategories_update
AFTER UPDATE
ON SearchCategories
BEGIN
UPDATE SearchCategories
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE SearchConfigurationId = NEW.SearchConfigurationId AND Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_SearchCategories_insert
AFTER INSERT
ON SearchCategories
BEGIN
UPDATE SearchCategories
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE SearchConfigurationId = NEW.SearchConfigurationId AND Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_SearchConfiguration_update
AFTER UPDATE
ON SearchConfiguration
BEGIN
UPDATE SearchConfiguration
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_SearchConfiguration_insert
AFTER INSERT
ON SearchConfiguration
BEGIN
UPDATE SearchConfiguration
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_TagToIgnore_update
AFTER UPDATE
ON TagToIgnore
BEGIN
UPDATE TagToIgnore
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_TagToIgnore_insert
AFTER INSERT
ON TagToIgnore
BEGIN
UPDATE TagToIgnore
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_UserConfiguration_update
AFTER UPDATE
ON UserConfiguration
BEGIN
UPDATE UserConfiguration
SET UpdatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;
CREATE TRIGGER IF NOT EXISTS tr_UserConfiguration_insert
AFTER INSERT
ON UserConfiguration
BEGIN
UPDATE UserConfiguration
SET CreatedAt_Ticks = unixepoch('now','subsec')
WHERE Id = NEW.Id;
END;