-- Crear tabla DYNAMICITEM en Asurnet e índice sobre la clave primaria
CREATE TABLE asurnet.dbo.DYNAMICITEM (
	DYI_Id int IDENTITY(1,1) NOT NULL,
	DYI_Content varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	DYI_ListType int NULL,
	DYI_Index int NULL,
	AUX_Id int NULL,
	DYI_Fixed tinyint NULL,
	CONSTRAINT PK_DYNAMICITEM PRIMARY KEY (DYI_Id)
);
 CREATE NONCLUSTERED INDEX IND_DYNAMICITEM ON asurnet.dbo.DYNAMICITEM (  DYI_Id ASC  )
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ];