File: gvmd-tables.sql

package info (click to toggle)
pg-gvm 22.6.15-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 444 kB
  • sloc: ansic: 574; sql: 201; sh: 30; makefile: 12
file content (12 lines) | stat: -rw-r--r-- 277 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
 
--
-- Create tables required for testing the extension, normally created by gvmd.
--

CREATE TABLE IF NOT EXISTS meta
  (id SERIAL PRIMARY KEY,
   name text UNIQUE NOT NULL,
   value text);

INSERT INTO meta(name, value) 
  VALUES ('max_hosts', 1024)
  ON CONFLICT DO NOTHING;