Changes related to make dist.

git-svn-id: svn://svn.zabbix.com/trunk@3938 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 19 insertions, 0 deletions

diff --git a/upgrades/dbpatches/1.4/mysql/patch/users.sql b/upgrades/dbpatches/1.4/mysql/patch/users.sql
new file mode 100644
index 00000000..c2a31e17
--- /dev/null
+++ b/upgrades/dbpatches/1.4/mysql/patch/users.sql
@@ -0,0 +1,19 @@
+CREATE TABLE users_tmp (
+	userid		bigint unsigned		DEFAULT '0'	NOT NULL,
+	alias		varchar(100)		DEFAULT ''	NOT NULL,
+	name		varchar(100)		DEFAULT ''	NOT NULL,
+	surname		varchar(100)		DEFAULT ''	NOT NULL,
+	passwd		char(32)		DEFAULT ''	NOT NULL,
+	url		varchar(255)		DEFAULT ''	NOT NULL,
+	autologout		integer		DEFAULT '900'	NOT NULL,
+	lang		varchar(5)		DEFAULT 'en_gb'	NOT NULL,
+	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,1 from users;
+update users_tmp set type=3 where name='Admin';
+drop table users;
+alter table users_tmp rename users;