diff options
| -rw-r--r-- | SQL/mssql.upgrade.sql | 5 | ||||
| -rw-r--r-- | SQL/mysql.update.sql | 5 | ||||
| -rw-r--r-- | SQL/postgres.update.sql | 5 | ||||
| -rw-r--r-- | SQL/sqlite.update.sql | 5 | ||||
| -rw-r--r-- | UPGRADING | 3 | ||||
| -rwxr-xr-x | bin/update.sh | 4 |
6 files changed, 22 insertions, 5 deletions
diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql index c9909ef4a..606db6046 100644 --- a/SQL/mssql.upgrade.sql +++ b/SQL/mssql.upgrade.sql @@ -97,7 +97,10 @@ GO ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL
GO
--- Updates from version 0.5.X
+-- Updates from version 0.5.1
+-- Updates from version 0.5.2
+-- Updates from version 0.5.3
+-- Updates from version 0.5.4
ALTER TABLE [dbo].[contacts] ADD [words] [text] COLLATE Latin1_General_CI_AI NULL
GO
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 3843bd73e..ed21bda2e 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -133,7 +133,10 @@ ALTER TABLE `contacts` MODIFY `email` varchar(255) NOT NULL; TRUNCATE TABLE `messages`; --- Updates from version 0.5.X +-- Updates from version 0.5.1 +-- Updates from version 0.5.2 +-- Updates from version 0.5.3 +-- Updates from version 0.5.4 ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`; ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER SET utf8 */ NULL DEFAULT NULL; diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index d1bf824c3..94513c53f 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -90,7 +90,10 @@ ALTER TABLE contacts ALTER email TYPE varchar(255); TRUNCATE messages; --- Updates from version 0.5.X +-- Updates from version 0.5.1 +-- Updates from version 0.5.2 +-- Updates from version 0.5.3 +-- Updates from version 0.5.4 ALTER TABLE contacts ADD words TEXT NULL; CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql index 229ed4d96..30c3ae90b 100644 --- a/SQL/sqlite.update.sql +++ b/SQL/sqlite.update.sql @@ -183,7 +183,10 @@ DROP TABLE contacts_tmp; DELETE FROM messages; --- Updates from version 0.5.X +-- Updates from version 0.5.1 +-- Updates from version 0.5.2 +-- Updates from version 0.5.3 +-- Updates from version 0.5.4 CREATE TABLE contacts_tmp ( contact_id integer NOT NULL PRIMARY KEY, @@ -19,7 +19,8 @@ which should be updated. The update script will then copy all new files to the target location and check and update the configuration and database schema. After all is done, the temporary folder with the new Roundcube files can be removed again. -See Post-Upgrade Activities section. + +Please also see Post-Upgrade Activities section. Updating manually diff --git a/bin/update.sh b/bin/update.sh index 9f91c8ecd..52ac63734 100755 --- a/bin/update.sh +++ b/bin/update.sh @@ -162,6 +162,10 @@ if ($RCI->configured) { } } + // index contacts for fulltext searching + if (version_compare($opts['version'], '0.6', '<')) { + system(INSTALL_PATH . 'bin/indexcontacts.sh'); + } if ($success) { echo "This instance of Roundcube is up-to-date.\n"; |