| | |
| | | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
| | | GO
|
| | |
|
| | | CREATE TABLE [dbo].[system] (
|
| | | [name] [varchar] (64) COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [value] [text] COLLATE Latin1_General_CI_AI NOT NULL |
| | | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
| | | GO
|
| | |
|
| | | ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD
|
| | | PRIMARY KEY CLUSTERED
|
| | | (
|
| | |
| | | CONSTRAINT [PK_searches_search_id] PRIMARY KEY CLUSTERED
|
| | | (
|
| | | [search_id]
|
| | | ) ON [PRIMARY] |
| | | GO
|
| | |
|
| | | ALTER TABLE [dbo].[system] WITH NOCHECK ADD |
| | | CONSTRAINT [PK_system_name] PRIMARY KEY CLUSTERED |
| | | (
|
| | | [name]
|
| | | ) ON [PRIMARY]
|
| | | GO
|
| | |
|
| | |
| | | WHERE [contact_id] IN (SELECT [contact_id] FROM deleted)
|
| | | GO
|
| | |
|
| | | INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2013011700.sql')
|
| | | GO
|
| | |
|