File: 2.12.0.sql

package info (click to toggle)
icingaweb2 2.12.6-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 15,124 kB
  • sloc: php: 73,980; javascript: 5,009; sql: 333; xml: 75; sh: 72; makefile: 5
file content (13 lines) | stat: -rw-r--r-- 504 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
CREATE TYPE boolenum AS ENUM ('n', 'y');

ALTER TABLE icingaweb_schema
  ALTER COLUMN timestamp TYPE bigint,
  ALTER COLUMN version TYPE varchar(64),
  ADD COLUMN success boolenum DEFAULT NULL,
  ADD COLUMN reason text DEFAULT NULL,
  ADD CONSTRAINT idx_icingaweb_schema_version UNIQUE (version);

UPDATE icingaweb_schema SET timestamp = timestamp * 1000, success = 'y';

INSERT INTO icingaweb_schema (version, timestamp, success, reason)
  VALUES('2.12.0', EXTRACT(EPOCH FROM now()) * 1000, 'y', NULL);