CREATE TABLE [dbo].[Devices](
	[DeviceID] [uniqueidentifier] NOT NULL,
	[DeviceType] [tinyint] NOT NULL,
	[DeviceName] [nvarchar](100) NOT NULL,
	[SyncHost] [binary](4) NOT NULL,
	[SyncPort] [int] NOT NULL,
 CONSTRAINT [PK_Devices] PRIMARY KEY CLUSTERED 
(
	[DeviceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Settings](
	[Key] [varchar](30) NOT NULL,
	[Value] [nvarchar](100) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[smBarcodes](
	[Barcode] [varchar](50) NOT NULL,
	[ProductCode] [varchar](6) NOT NULL,
 CONSTRAINT [PK_Barcodes_1] PRIMARY KEY CLUSTERED 
(
	[Barcode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[smProducts](
	[ProductCode] [varchar](6) NOT NULL,
	[Description] [nvarchar](30) NOT NULL,
	[Price] [decimal](6, 2) NOT NULL,
	[Condition] [char](1) NULL,
	[PriceFlag] [char](1) NULL,
	[CurrentPrice] [decimal](6, 2) NULL,
	[PromoEndDate] [datetime] NULL,
	[InfoFlags] [nvarchar](20) NULL,
 CONSTRAINT [PK_Products_1] PRIMARY KEY CLUSTERED 
(
	[ProductCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[stStockCodes](
	[CodeID] [int] IDENTITY(1,1) NOT NULL,
	[ItemID] [int] NOT NULL,
	[Code] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_StockCodes] PRIMARY KEY CLUSTERED 
(
	[CodeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[stStockItems](
	[ItemID] [int] IDENTITY(1,1) NOT NULL,
	[StocktakeID] [uniqueidentifier] NOT NULL,
	[Code] [nvarchar](20) NOT NULL,
	[Description] [nvarchar](30) NOT NULL,
	[Price] [money] NOT NULL,
	[IsPromotion] [bit] NOT NULL,
	[FreezeQuantity] [int] NOT NULL,
 CONSTRAINT [PK_StockItems] PRIMARY KEY CLUSTERED 
(
	[ItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[stStockLevels](
	[LevelID] [uniqueidentifier] NOT NULL,
	[User] [nvarchar](20) NOT NULL,
	[ItemID] [int] NOT NULL,
	[Location] [nvarchar](3) NOT NULL,
	[Timestamp] [datetime] NOT NULL,
	[Count] [int] NOT NULL,
	[IsAdjustment] [bit] NOT NULL,
 CONSTRAINT [PK_StockLevels] PRIMARY KEY CLUSTERED 
(
	[LevelID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[stStocktakes](
	[StocktakeID] [uniqueidentifier] NOT NULL,
	[ImportTimestamp] [datetime] NOT NULL,
	[FreezeDate] [date] NOT NULL,
	[StocktakeCode] [nvarchar](20) NOT NULL,
	[StoreCode] [nvarchar](20) NOT NULL,
	[Active] [bit] NOT NULL,
	[Completed] [bit] NOT NULL,
	[ExportTimestamp] [datetime] NULL,
 CONSTRAINT [PK_Stocktakes] PRIMARY KEY CLUSTERED 
(
	[StocktakeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO