diff options
Diffstat (limited to 'upgrades/dbpatches/1.4/mysql/patch/httpstepitem.sql')
| -rw-r--r-- | upgrades/dbpatches/1.4/mysql/patch/httpstepitem.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.4/mysql/patch/httpstepitem.sql b/upgrades/dbpatches/1.4/mysql/patch/httpstepitem.sql new file mode 100644 index 00000000..56b43ff4 --- /dev/null +++ b/upgrades/dbpatches/1.4/mysql/patch/httpstepitem.sql @@ -0,0 +1,8 @@ +CREATE TABLE httpstepitem ( + httpstepitemid bigint unsigned DEFAULT '0' NOT NULL, + httpstepid bigint unsigned DEFAULT '0' NOT NULL, + itemid bigint unsigned DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + PRIMARY KEY (httpstepitemid) +) ENGINE=InnoDB; +CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid); |