From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

OLIVER / App-Netdisco-2.084000 / share / schema_versions / App-Netdisco-DB-77-78-PostgreSQL.sql 

            

              
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

              
BEGIN;
ALTER TABLE admin ALTER entered SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_ip ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_module ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_port ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_port_log ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_port_vlan ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_port_vlan ALTER last_discover SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_vlan ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE device_vlan ALTER last_discover SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE log ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node ALTER time_first SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node ALTER time_recent SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node ALTER time_last SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_ip ALTER time_first SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_ip ALTER time_last SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_monitor ALTER date SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_nbt ALTER time_first SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_nbt ALTER time_last SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE node_wireless ALTER time_last SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE process ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE sessions ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE subnets ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE subnets ALTER last_discover SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE users ALTER creation SET DEFAULT LOCALTIMESTAMP;
ALTER TABLE user_log ALTER creation SET DEFAULT LOCALTIMESTAMP;
COMMIT;