File: pgsql_server_alert.sql

package info (click to toggle)
kalkun 0.8.3.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,340 kB
  • sloc: php: 30,659; javascript: 30,443; sql: 961; sh: 766; xml: 105; makefile: 41
file content (12 lines) | stat: -rw-r--r-- 436 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE TABLE IF NOT EXISTS "plugin_server_alert" (
	"id_server_alert" serial PRIMARY KEY,
	"alert_name" varchar(100) NOT NULL,
	"ip_address" varchar(20) NOT NULL,
	"port_number" integer NOT NULL,
	"timeout" integer NOT NULL DEFAULT '30',
	"phone_number" varchar(15) NOT NULL,
	"respond_message" varchar(135) NOT NULL,
	"status" text NOT NULL DEFAULT 'true',
	"release_code" varchar(8) NOT NULL,
	CHECK ("status" IN ('true','false'))
);