File: 1.0.3.sql

package info (click to toggle)
icingaweb2-module-reporting 1.0.5-1
  • links: PTS, VCS
  • area: main
  • in suites: experimental
  • size: 552 kB
  • sloc: php: 3,469; sql: 289; sh: 54; xml: 18; makefile: 15
file content (7 lines) | stat: -rw-r--r-- 491 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
 
UPDATE timeframe SET "end" = 'now' WHERE name = 'Current Week';

INSERT INTO reporting_schema (version, timestamp, success, reason)
  VALUES ('1.0.3', unix_timestamp() * 1000, 'y', NULL)
  ON CONFLICT ON CONSTRAINT idx_reporting_schema_version DO UPDATE SET success   = EXCLUDED.success,
                                                                       reason    = EXCLUDED.reason,
                                                                       timestamp = EXCLUDED.timestamp;