| | |
| | | ON DELETE CASCADE ON UPDATE CASCADE
|
| | | GO
|
| | |
|
| | | -- Updates from version 0.7-beta
|
| | |
|
| | | ALTER TABLE [dbo].[session] ALTER COLUMN [sess_id] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL
|
| | | GO
|
| | |
|
| | |
| | | PRIMARY KEY (`user_id`, `mailbox`, `uid`) |
| | | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
| | | |
| | | -- Updates from version 0.7-beta |
| | | |
| | | ALTER TABLE `session` CHANGE `sess_id` `sess_id` varchar(128) NOT NULL; |
| | |
| | | |
| | | CREATE INDEX cache_messages_changed_idx ON cache_messages (changed); |
| | | |
| | | -- Updates from version 0.7-beta |
| | | |
| | | ALTER TABLE "session" ALTER sess_id TYPE varchar(128); |
| | |
| | | |
| | | CREATE INDEX ix_cache_messages_changed ON cache_messages (changed); |
| | | |
| | | -- Updates from version 0.7-beta |
| | | |
| | | DROP TABLE session; |
| | | CREATE TABLE session ( |
| | | sess_id varchar(128) NOT NULL PRIMARY KEY, |