File: sqlite_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-- 453 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" INTEGER PRIMARY KEY AUTOINCREMENT, 
	"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'))
);