| | |
| | | -- RoundCube Webmail update script for SQLite databases |
| | | -- Roundcube Webmail update script for SQLite databases |
| | | -- Updates from version 0.1-stable to 0.1.1 |
| | | |
| | | DROP TABLE messages; |
| | |
| | | INSERT INTO tmp_users (user_id, username, mail_host, alias, created, last_login, language, preferences) |
| | | SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM users; |
| | | |
| | | DROP INDEX ix_users_username ON users(username); |
| | | DROP INDEX ix_users_alias ON users(alias); |
| | | DROP TABLE users; |
| | | |
| | | CREATE TABLE users ( |