USE [LOGO_BAKI2018]
GO

/****** Object:  Table [dbo].[MS_B2B_ITEMBRANDS]    Script Date: 17.01.2026 01:01:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MS_B2B_ITEMBRANDS](
	[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
	[BRAND_NAME] [nvarchar](100) NOT NULL,
	[BRAND_CODE] [nvarchar](50) NOT NULL,
	[BRAND_IMAGE] [nvarchar](255) NULL,
	[STATUS] [tinyint] NULL,
	[CREATED_DATE] [datetime] NULL,
	[UPDATED_DATE] [datetime] NULL,
	[SORT_ORDER] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[BRAND_CODE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MS_B2B_ITEMBRANDS] ADD  DEFAULT ((0)) FOR [STATUS]
GO

ALTER TABLE [dbo].[MS_B2B_ITEMBRANDS] ADD  DEFAULT (getdate()) FOR [CREATED_DATE]
GO

ALTER TABLE [dbo].[MS_B2B_ITEMBRANDS] ADD  DEFAULT (getdate()) FOR [UPDATED_DATE]
GO

ALTER TABLE [dbo].[MS_B2B_ITEMBRANDS] ADD  DEFAULT ((0)) FOR [SORT_ORDER]
GO