diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/users.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch/users.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/users.sql b/upgrades/dbpatches/1.3/postgresql/patch/users.sql index fcad30a5..ac094cfe 100644 --- a/upgrades/dbpatches/1.3/postgresql/patch/users.sql +++ b/upgrades/dbpatches/1.3/postgresql/patch/users.sql @@ -1,18 +1,18 @@ CREATE TABLE users_tmp ( - userid bigint unsigned DEFAULT '0' NOT NULL, + userid bigint 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, + 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,3 from users; drop table users; -alter table users_tmp rename users; +alter table users_tmp rename to users; |