From 502436dad02293899fb41a8bd9179f1449236136 Mon Sep 17 00:00:00 2001 From: thomascube Date: Thu, 29 Sep 2011 07:00:34 +0000 Subject: We're on the road towards 0.7 now --- SQL/mssql.upgrade.sql | 4 ++-- SQL/mysql.update.sql | 2 +- SQL/postgres.update.sql | 2 +- SQL/sqlite.update.sql | 2 +- 4 files changed, 5 insertions(+), 5 deletions(-) (limited to 'SQL') 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, -- cgit v1.2.3