File: 2.11.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 (10 lines) | stat: -rw-r--r-- 275 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE "icingaweb_schema" (
  "id"          serial,
  "version"     smallint NOT NULL,
  "timestamp"   int NOT NULL,

  CONSTRAINT pk_icingaweb_schema PRIMARY KEY ("id")
);

INSERT INTO icingaweb_schema ("version", "timestamp")
  VALUES (6, extract(epoch from now()));