diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-01 14:46:14 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-02-01 14:46:14 +0000 |
| commit | c516c57fc707c8078edc2938b35e1bc5934637d3 (patch) | |
| tree | c7649a7e09bd38878fed72af317a67dcdaf74a80 /upgrades/dbpatches/1.3/mysql/patch/users.sql | |
| parent | 8d6e9646fb189323340a61e6dcf614ee4b1bc43b (diff) | |
| download | zabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.tar.gz zabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.tar.xz zabbix-c516c57fc707c8078edc2938b35e1bc5934637d3.zip | |
Improvements of WEB monitoring and MySQL upgrade patches.
git-svn-id: svn://svn.zabbix.com/trunk@3784 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/users.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/users.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/users.sql b/upgrades/dbpatches/1.3/mysql/patch/users.sql index 9d15cb91..fcad30a5 100644 --- a/upgrades/dbpatches/1.3/mysql/patch/users.sql +++ b/upgrades/dbpatches/1.3/mysql/patch/users.sql @@ -10,7 +10,7 @@ CREATE TABLE users_tmp ( refresh integer DEFAULT '30' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (userid) -); +) ENGINE=InnoDB; CREATE INDEX users_1 on users_tmp (alias); insert into users_tmp select userid,alias,name,surname,passwd,url,autologout,lang,refresh,3 from users; |