summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2011-09-29 07:00:34 +0000
committerthomascube <thomas@roundcube.net>2011-09-29 07:00:34 +0000
commit502436dad02293899fb41a8bd9179f1449236136 (patch)
treee5c05a3e4a3e8f00af6f066115f166d485ad5faa /SQL
parentaa1b67aabb4393b4eda861217bdedd0f657ecef1 (diff)
We're on the road towards 0.7 now
Diffstat (limited to 'SQL')
-rw-r--r--SQL/mssql.upgrade.sql4
-rw-r--r--SQL/mysql.update.sql2
-rw-r--r--SQL/postgres.update.sql2
-rw-r--r--SQL/sqlite.update.sql2
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,