/* miércoles, 5 de marzo de 202512:57:30 User: CALABRIA2024 Server: SERVER-ALFAVB6 Database: ALFANET Application: */ /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION GO ALTER TABLE dbo.TA_MENU DROP CONSTRAINT DF_TA_Menu_Habilitado GO CREATE TABLE dbo.Tmp_TA_MENU ( id int NOT NULL IDENTITY (1, 1) NOT FOR REPLICATION, Menu nvarchar(50) NOT NULL, Titulo nvarchar(50) NOT NULL, Clave nvarchar(50) NOT NULL, Nombre nvarchar(50) NULL, Imagen nvarchar(50) NULL, Proceso nvarchar(250) NULL, Habilitado bit NOT NULL, ORDEN nvarchar(50) NULL, DESCRIPCION ntext NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE dbo.Tmp_TA_MENU SET (LOCK_ESCALATION = TABLE) GO ALTER TABLE dbo.Tmp_TA_MENU ADD CONSTRAINT DF_TA_Menu_Habilitado DEFAULT (1) FOR Habilitado GO SET IDENTITY_INSERT dbo.Tmp_TA_MENU ON GO IF EXISTS(SELECT * FROM dbo.TA_MENU) EXEC('INSERT INTO dbo.Tmp_TA_MENU (id, Menu, Titulo, Clave, Nombre, Imagen, Proceso, Habilitado, ORDEN, DESCRIPCION) SELECT id, Menu, Titulo, Clave, Nombre, Imagen, Proceso, Habilitado, ORDEN, DESCRIPCION FROM dbo.TA_MENU WITH (HOLDLOCK TABLOCKX)') GO SET IDENTITY_INSERT dbo.Tmp_TA_MENU OFF GO DROP TABLE dbo.TA_MENU GO EXECUTE sp_rename N'dbo.Tmp_TA_MENU', N'TA_MENU', 'OBJECT' GO ALTER TABLE dbo.TA_MENU ADD CONSTRAINT PK_TA_MENU PRIMARY KEY CLUSTERED ( Menu, Titulo, Clave ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE dbo.TA_MENU ADD CONSTRAINT IX_TA_Menu UNIQUE NONCLUSTERED ( Menu, Clave ) WITH( PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO COMMIT