CREATE TABLE [dbo].[Brands](
[BrandID] [int] IDENTITY(1,1)
NOT NULL,
[Name] [nvarchar](32) NOT NULL,
[ParentID] [int] NULL DEFAULT
((0))
)
CREATE TABLE [dbo].[Orders](
[OrderID] [int] IDENTITY(1,1)
NOT NULL,
[Date] [datetime] NOT NULL,
[ProductID] [int] NOT NULL,
[Quantity] [int] NOT NULL
DEFAULT ((1))
)
CREATE TABLE [dbo].[Products](
[ProductID] [int] IDENTITY(1,1)
NOT NULL,
[BrandID] [int] NOT NULL,
[Model] [nvarchar](32) NOT
NULL,
[Configuration] [nvarchar](128)
NOT NULL,
[Price] [money] NOT NULL,
[Quantity] [numeric](18, 0) NOT
NULL
)
CREATE TABLE [dbo].[OrdersQueue](
[QueueID] [int] IDENTITY(1,1)
NOT NULL,
[OrderID] [int] NOT NULL
)
|