diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-01-30 15:36:09 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-01-30 15:36:09 +0000 |
| commit | 042eb9179036479789a63b7eda13c84734a741e7 (patch) | |
| tree | 51eb0eb3a06a23da3fcc18dc4fe06cc73c50dc71 /upgrades/dbpatches/1.3/mysql/1.3/httpstepitem.sql | |
| parent | fbc8b79bea9d0fb7547b930ed382f98e7e083499 (diff) | |
| download | zabbix-042eb9179036479789a63b7eda13c84734a741e7.tar.gz zabbix-042eb9179036479789a63b7eda13c84734a741e7.tar.xz zabbix-042eb9179036479789a63b7eda13c84734a741e7.zip | |
MySQL database upgrade scripts.
git-svn-id: svn://svn.zabbix.com/trunk@3771 97f52cf1-0a1b-0410-bd0e-c28be96e8082
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); |