diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql b/upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql new file mode 100644 index 00000000..3a0fa50d --- /dev/null +++ b/upgrades/dbpatches/1.3/mysql/1.3/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) +); +CREATE UNIQUE INDEX httpstepitem_httpstepitem_1 on httpstepitem (httpstepid,itemid); |