CREATE TABLE [dbo].[Item]
(
    Item_ID INT IDENTITY(1,1) NOT NULL,
    Name NVARCHAR(50) NOT NULL,
    CONSTRAINT PK_Item PRIMARY KEY CLUSTERED(Item_ID)
);

CREATE TABLE [dbo].[Zone]
(
    Zone_ID INT IDENTITY(1,1) NOT NULL,
    Name NVARCHAR(50) NOT NULL,
    CONSTRAINT PK_Zone PRIMARY KEY CLUSTERED(Zone_ID)
);

CREATE TABLE [dbo].[Item_Zone_Position]
(
    Item_ID INT NOT NULL,
    Zone_ID INT NOT NULL,
    POSITION INT NOT NULL,
    CONSTRAINT PK_Item_Zone_Position PRIMARY KEY CLUSTERED(Item_ID),
    CONSTRAINT FK_Item_Zone_Position_Item FOREIGN KEY(Item_ID)
        REFERENCES [dbo].[Item](Item_ID),
    CONSTRAINT FK_Item_Zone_Position_Zone FOREIGN KEY(Zone_ID)
        REFERENCES [dbo].[Zone](Zone_ID)
);

CREATE TABLE [dbo].[Item_Zone_Position_V2]
(
    Item_ID INT NOT NULL,
    Zone_ID INT NOT NULL,
    Previous_Item_ID INT NULL,
    CONSTRAINT PK_Item_Zone_Position_V2 PRIMARY KEY CLUSTERED(Item_ID),
    CONSTRAINT FK_Item_Zone_Position_V2_Item FOREIGN KEY(Item_ID)
        REFERENCES [dbo].[Item](Item_ID),
    CONSTRAINT FK_Item_Zone_Position_V2_Zone FOREIGN KEY(Zone_ID)
        REFERENCES [dbo].[Zone](Zone_ID),
    CONSTRAINT FK_Item_Zone_Position_V2_Item2 FOREIGN KEY(Item_ID)
        REFERENCES [dbo].[Item](Item_ID)
);