CREATE TABLE [dbo].[StoresFixtures]
(
[StoresFixturesID] [int] NOT NULL IDENTITY(1, 1),
[JobsID] [int] NOT NULL,
[FixtureTypesID] [int] NOT NULL,
[Quantity] [decimal] (18, 0) NULL,
[Installed] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveredToStore] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FixtureDamage] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActionTaken] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstallationCharge] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StoresFixtures] ADD CONSTRAINT [PK_StoresFixtures] PRIMARY KEY CLUSTERED  ([StoresFixturesID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StoresFixtures] ADD CONSTRAINT [FK_StoresFixtures_FixtureTypes] FOREIGN KEY ([FixtureTypesID]) REFERENCES [dbo].[FixtureTypes] ([FixtureTypesID])
GO
ALTER TABLE [dbo].[StoresFixtures] ADD CONSTRAINT [FK_StoresFixtures_Jobs] FOREIGN KEY ([JobsID]) REFERENCES [dbo].[Jobs] ([JobsID])
GO
GRANT SELECT ON  [dbo].[StoresFixtures] TO [MssExec]
GRANT INSERT ON  [dbo].[StoresFixtures] TO [MssExec]
GRANT DELETE ON  [dbo].[StoresFixtures] TO [MssExec]
GRANT UPDATE ON  [dbo].[StoresFixtures] TO [MssExec]
GO