diff options
Diffstat (limited to 'SQL')
-rw-r--r-- | SQL/mssql.upgrade.sql | 4 | ||||
-rw-r--r-- | SQL/mysql.update.sql | 2 | ||||
-rw-r--r-- | SQL/postgres.update.sql | 2 | ||||
-rw-r--r-- | SQL/sqlite.update.sql | 2 |
4 files changed, 5 insertions, 5 deletions
diff --git a/SQL/mssql.upgrade.sql b/SQL/mssql.upgrade.sql index b506e5d96..70cf34d36 100644 --- a/SQL/mssql.upgrade.sql +++ b/SQL/mssql.upgrade.sql @@ -111,7 +111,7 @@ GO DELETE FROM [dbo].[cache]
GO
--- Updates from version 0.6-stable
+-- Updates from version 0.6
CREATE TABLE [dbo].[dictionary] (
[user_id] [int] ,
@@ -238,4 +238,4 @@ ALTER TABLE [dbo].[cache_messages] ADD CONSTRAINT [FK_cache_messages_user_id] FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
ON DELETE CASCADE ON UPDATE CASCADE
GO
-
\ No newline at end of file +
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 6181622e7..66045392d 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -145,7 +145,7 @@ ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` TRUNCATE TABLE `messages`; TRUNCATE TABLE `cache`; --- Updates from version 0.6-stable +-- Updates from version 0.6 ALTER TABLE `users` CHANGE `alias` `alias` varchar(128) BINARY NOT NULL; ALTER TABLE `users` CHANGE `username` `username` varchar(128) BINARY NOT NULL; diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index 7e650af7a..2935cd483 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -101,7 +101,7 @@ CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_ TRUNCATE messages; TRUNCATE cache; --- Updates from version 0.6-stable +-- Updates from version 0.6 CREATE TABLE dictionary ( user_id integer DEFAULT NULL diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql index f7fd168af..0193c7c39 100644 --- a/SQL/sqlite.update.sql +++ b/SQL/sqlite.update.sql @@ -228,7 +228,7 @@ DELETE FROM messages; DELETE FROM cache; CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id); --- Updates from version 0.6-stable +-- Updates from version 0.6 CREATE TABLE dictionary ( user_id integer DEFAULT NULL, |