diff options
| author | Aleksander Machniak <alec@alec.pl> | 2012-08-06 10:32:37 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2012-08-06 10:32:37 +0200 |
| commit | 83121ece3348bfe09bb1026eace79a74a5ccf2c9 (patch) | |
| tree | 9f64f143b8a859db3930a649a404cdcc46434660 /SQL/mssql.initial.sql | |
| parent | a025cddbc5643d1e8c9d2bf733a101417213d91b (diff) | |
- Removed redundant cache.cache_id column (#1488528)
Diffstat (limited to 'SQL/mssql.initial.sql')
| -rw-r--r-- | SQL/mssql.initial.sql | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql index 2ac6aa63e..9aa6e6321 100644 --- a/SQL/mssql.initial.sql +++ b/SQL/mssql.initial.sql @@ -1,5 +1,4 @@ CREATE TABLE [dbo].[cache] (
- [cache_id] [int] IDENTITY (1, 1) NOT NULL ,
[user_id] [int] NOT NULL ,
[cache_key] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
[created] [datetime] NOT NULL ,
@@ -117,13 +116,6 @@ CREATE TABLE [dbo].[searches] ( ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
-ALTER TABLE [dbo].[cache] WITH NOCHECK ADD
- PRIMARY KEY CLUSTERED
- (
- [cache_id]
- ) ON [PRIMARY]
-GO
-
ALTER TABLE [dbo].[cache_index] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
|