You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
307 B
Transact-SQL
10 lines
307 B
Transact-SQL
ALTER TABLE [dbo].[filestore] ADD COLUMN [context] [varchar] (32) COLLATE Latin1_General_CI_AI NOT NULL
|
|
GO
|
|
|
|
UPDATE [dbo].[filestore] SET [dbo].[context] = 'enigma'
|
|
GO
|
|
|
|
CREATE UNIQUE INDEX [IX_filestore_user_id_context_filename] ON [dbo].[filestore]([user_id],[context],[filename]) ON [PRIMARY]
|
|
GO
|
|
|