[mailbox] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
[uid] [int] NOT NULL ,\r
[changed] [datetime] NOT NULL ,\r
- [data] [text] COLLATE Latin1_General_CI_AI NOT NULL \r
- [flags] [int](1) NOT NULL ,\r
+ [data] [text] COLLATE Latin1_General_CI_AI NOT NULL ,\r
+ [flags] [int] NOT NULL\r
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r
GO\r
\r
[changed] [datetime] NOT NULL ,\r
[del] [char] (1) COLLATE Latin1_General_CI_AI NOT NULL ,\r
[name] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
- [email] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,\r
+ [email] [text] COLLATE Latin1_General_CI_AI NOT NULL ,\r
[firstname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
[surname] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,\r
[vcard] [text] COLLATE Latin1_General_CI_AI NULL ,\r
\r
ALTER TABLE [dbo].[cache_messages] ADD \r
CONSTRAINT [DF_cache_messages_changed] DEFAULT (getdate()) FOR [changed],\r
- CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags],\r
+ CONSTRAINT [DF_cache_messages_flags] DEFAULT (0) FOR [flags]\r
GO\r
\r
CREATE INDEX [IX_cache_messages_user_id] ON [dbo].[cache_messages]([user_id]) ON [PRIMARY]\r
\r
ALTER TABLE [dbo].[searches] ADD \r
CONSTRAINT [DF_searches_user] DEFAULT (0) FOR [user_id],\r
- CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type],\r
+ CONSTRAINT [DF_searches_type] DEFAULT (0) FOR [type]\r
GO\r
\r
CREATE UNIQUE INDEX [IX_searches_user_type_name] ON [dbo].[searches]([user_id],[type],[name]) ON [PRIMARY]\r