summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql b/upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql
new file mode 100644
index 00000000..7f99fbfc
--- /dev/null
+++ b/upgrades/dbpatches/1.4/postgresql/patch/httpstep.sql
@@ -0,0 +1,12 @@
+CREATE TABLE httpstep (
+ httpstepid bigint DEFAULT '0' NOT NULL,
+ httptestid bigint DEFAULT '0' NOT NULL,
+ name varchar(64) DEFAULT '' NOT NULL,
+ no integer DEFAULT '0' NOT NULL,
+ url varchar(128) DEFAULT '' NOT NULL,
+ timeout integer DEFAULT '30' NOT NULL,
+ posts text DEFAULT '' NOT NULL,
+ required varchar(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (httpstepid)
+);
+CREATE INDEX httpstep_httpstep_1 on httpstep (httptestid);