Untitled
unknown
plain_text
a year ago
48 kB
39
Indexable
USE [master]
GO
/****** Object: Database [SufyStylesShop] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE DATABASE [SufyStylesShop]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'SufyStylesShop', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\SufyStylesShop.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'SufyStylesShop_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\SufyStylesShop_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [SufyStylesShop] SET COMPATIBILITY_LEVEL = 160
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SufyStylesShop].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SufyStylesShop] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [SufyStylesShop] SET ANSI_NULLS OFF
GO
ALTER DATABASE [SufyStylesShop] SET ANSI_PADDING OFF
GO
ALTER DATABASE [SufyStylesShop] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [SufyStylesShop] SET ARITHABORT OFF
GO
ALTER DATABASE [SufyStylesShop] SET AUTO_CLOSE ON
GO
ALTER DATABASE [SufyStylesShop] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [SufyStylesShop] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [SufyStylesShop] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [SufyStylesShop] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [SufyStylesShop] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [SufyStylesShop] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [SufyStylesShop] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [SufyStylesShop] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [SufyStylesShop] SET ENABLE_BROKER
GO
ALTER DATABASE [SufyStylesShop] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [SufyStylesShop] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [SufyStylesShop] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [SufyStylesShop] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [SufyStylesShop] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [SufyStylesShop] SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE [SufyStylesShop] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [SufyStylesShop] SET RECOVERY SIMPLE
GO
ALTER DATABASE [SufyStylesShop] SET MULTI_USER
GO
ALTER DATABASE [SufyStylesShop] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [SufyStylesShop] SET DB_CHAINING OFF
GO
ALTER DATABASE [SufyStylesShop] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [SufyStylesShop] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [SufyStylesShop] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [SufyStylesShop] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [SufyStylesShop] SET QUERY_STORE = ON
GO
ALTER DATABASE [SufyStylesShop] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
GO
USE [SufyStylesShop]
GO
/****** Object: Table [dbo].[Addresses] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Addresses](
[AddressId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[Fullname] [nvarchar](255) NOT NULL,
[Phone] [nvarchar](max) NOT NULL,
[AddressName] [nvarchar](255) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Addresses] PRIMARY KEY CLUSTERED
(
[AddressId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Admins] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Admins](
[AdminId] [uniqueidentifier] NOT NULL,
[FullName] [nvarchar](100) NOT NULL,
[Email] [nvarchar](256) NOT NULL,
[Password] [nvarchar](100) NOT NULL,
[RoleId] [uniqueidentifier] NOT NULL,
[Phone] [nvarchar](15) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Admins] PRIMARY KEY CLUSTERED
(
[AdminId] 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
/****** Object: Table [dbo].[CartItems] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CartItems](
[CartItemId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[VariantId] [uniqueidentifier] NOT NULL,
[UrlImage] [nvarchar](max) NOT NULL,
[ProductName] [nvarchar](100) NOT NULL,
[Price] [nvarchar](max) NOT NULL,
[Quantity] [int] NOT NULL,
[SalePricePercent] [float] NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_CartItems] PRIMARY KEY CLUSTERED
(
[CartItemId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Collections] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Collections](
[CollectionId] [uniqueidentifier] NOT NULL,
[Title] [nvarchar](100) NOT NULL,
[Description] [nvarchar](500) NULL,
[UrlImage] [nvarchar](max) NULL,
[IsVisible] [bit] NOT NULL,
[UrlHandle] [nvarchar](max) NULL,
[CreatedDate] [datetime2](7) NOT NULL,
[UpdatedDate] [datetime2](7) NULL,
CONSTRAINT [PK_Collections] PRIMARY KEY CLUSTERED
(
[CollectionId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Follows] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Follows](
[FollowingId] [uniqueidentifier] NOT NULL,
[FollowerId] [uniqueidentifier] NOT NULL,
[FollowDate] [datetime2](7) NULL,
[IsFriend] [bit] NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Follows] PRIMARY KEY CLUSTERED
(
[FollowingId] ASC,
[FollowerId] 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
/****** Object: Table [dbo].[OrderedProducts] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderedProducts](
[OrderedProductId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[VariantId] [uniqueidentifier] NOT NULL,
[OrderId] [uniqueidentifier] NOT NULL,
[ProductName] [nvarchar](100) NOT NULL,
[Quantity] [int] NULL,
[ProductPrice] [decimal](18, 2) NULL,
[ProductVariantVariantId] [uniqueidentifier] NULL,
CONSTRAINT [PK_OrderedProducts] PRIMARY KEY CLUSTERED
(
[OrderedProductId] 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
/****** Object: Table [dbo].[Orders] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Orders](
[OrderId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[PaymentMethodId] [uniqueidentifier] NOT NULL,
[Address] [nvarchar](255) NOT NULL,
[ComfirmUserId] [uniqueidentifier] NOT NULL,
[CreatedDate] [datetime2](7) NULL,
[PaymentStatus] [nvarchar](50) NOT NULL,
[Fullname] [nvarchar](100) NOT NULL,
[OrderStatus] [int] NOT NULL,
[OrderShippingFee] [float] NULL,
[SubTotal] [float] NULL,
[CancelDate] [datetime2](7) NULL,
[OrderTotalPrice] [float] NULL,
[ComfirmDate] [datetime2](7) NULL,
[Phone] [nvarchar](max) NULL,
[ReasonCancel] [nvarchar](255) NULL,
CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED
(
[OrderId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[PaymentMethods] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PaymentMethods](
[PaymentMethodId] [uniqueidentifier] NOT NULL,
[PaymentName] [nvarchar](100) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_PaymentMethods] PRIMARY KEY CLUSTERED
(
[PaymentMethodId] 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
/****** Object: Table [dbo].[PostCommentLikes] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostCommentLikes](
[UserId] [uniqueidentifier] NOT NULL,
[CommentId] [uniqueidentifier] NOT NULL,
[LikedDate] [datetime2](7) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_PostCommentLikes] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[CommentId] 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
/****** Object: Table [dbo].[PostComments] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostComments](
[PostCommentId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[Content] [nvarchar](1000) NOT NULL,
[CreateDate] [datetime2](7) NOT NULL,
[UpdateDate] [datetime2](7) NOT NULL,
[LikeNumber] [bigint] NOT NULL,
[IsDeleted] [bit] NOT NULL,
[IsReported] [bit] NOT NULL,
CONSTRAINT [PK_PostComments] PRIMARY KEY CLUSTERED
(
[PostCommentId] 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
/****** Object: Table [dbo].[PostImages] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostImages](
[ImagePostId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NULL,
[AspectRatio] [nvarchar](50) NULL,
[AltImage] [nvarchar](100) NULL,
[UrlImage] [nvarchar](255) NOT NULL,
CONSTRAINT [PK_PostImages] PRIMARY KEY CLUSTERED
(
[ImagePostId] 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
/****** Object: Table [dbo].[PostLikes] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostLikes](
[UserId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_PostLikes] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[PostId] 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
/****** Object: Table [dbo].[PostProductTag] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostProductTag](
[PostProductTagId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NOT NULL,
[ProductTagId] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_PostProductTag] PRIMARY KEY CLUSTERED
(
[PostProductTagId] 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
/****** Object: Table [dbo].[Posts] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Posts](
[PostId] [uniqueidentifier] NOT NULL,
[AuthorId] [uniqueidentifier] NOT NULL,
[Title] [nvarchar](255) NOT NULL,
[Content] [nvarchar](max) NOT NULL,
[PageTitle] [nvarchar](255) NULL,
[MetaDescription] [nvarchar](255) NULL,
[ViewNumber] [int] NOT NULL,
[ShareNumber] [int] NOT NULL,
[UrlVideo] [nvarchar](255) NULL,
[UrlHandle] [nvarchar](255) NULL,
[CreateDate] [datetime2](7) NOT NULL,
[UpdateDate] [datetime2](7) NOT NULL,
[IsVisible] [bit] NOT NULL,
[IsDeleted] [bit] NOT NULL,
[IsReported] [bit] NOT NULL,
CONSTRAINT [PK_Posts] PRIMARY KEY CLUSTERED
(
[PostId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[ProductCollections] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductCollections](
[ProductCollectionId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[CollectionId] [uniqueidentifier] NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_ProductCollections] PRIMARY KEY CLUSTERED
(
[ProductCollectionId] 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
/****** Object: Table [dbo].[ProductComments] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductComments](
[CommentId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[Content] [nvarchar](2000) NOT NULL,
[Rating] [int] NOT NULL,
[CreatedDate] [datetime2](7) NOT NULL,
[IsDeleted] [bit] NOT NULL,
[IsReported] [bit] NOT NULL,
CONSTRAINT [PK_ProductComments] PRIMARY KEY CLUSTERED
(
[CommentId] 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
/****** Object: Table [dbo].[ProductImages] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductImages](
[ImageId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[UrlImage] [nvarchar](max) NOT NULL,
[AltText] [nvarchar](255) NULL,
[IsFeatured] [bit] NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_ProductImages] PRIMARY KEY CLUSTERED
(
[ImageId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Products] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Products](
[ProductId] [uniqueidentifier] NOT NULL,
[ProductName] [nvarchar](255) NOT NULL,
[Description] [nvarchar](1000) NULL,
[PageTitle] [nvarchar](255) NULL,
[MetaDescription] [nvarchar](1000) NULL,
[ProductTypeName] [nvarchar](100) NULL,
[ProductVendorId] [uniqueidentifier] NOT NULL,
[ProductUrl] [nvarchar](200) NOT NULL,
[IsVisible] [bit] NOT NULL,
[CreateDate] [datetime2](7) NULL,
[UpdateDate] [datetime2](7) NULL,
[SalePricePercent] [float] NULL,
[IsDeleted] [bit] NOT NULL,
[AdminId] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED
(
[ProductId] 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
/****** Object: Table [dbo].[ProductTags] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductTags](
[ProductTagId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[ProductName] [nvarchar](255) NOT NULL,
[Price] [decimal](18, 2) NOT NULL,
[UrlImage] [nvarchar](2083) NOT NULL,
[ProductUrl] [nvarchar](2083) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_ProductTags] PRIMARY KEY CLUSTERED
(
[ProductTagId] 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
/****** Object: Table [dbo].[ProductVariants] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductVariants](
[VariantId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[Price] [decimal](18, 2) NOT NULL,
[Quantity] [bigint] NOT NULL,
[UrlImage] [nvarchar](2083) NOT NULL,
[Option1] [nvarchar](100) NULL,
[Option2] [nvarchar](100) NULL,
[Option3] [nvarchar](100) NULL,
[OptionValue1] [nvarchar](100) NULL,
[OptionValue2] [nvarchar](100) NULL,
[OptionValue3] [nvarchar](100) NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_ProductVariants] PRIMARY KEY CLUSTERED
(
[VariantId] 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
/****** Object: Table [dbo].[ProductVendors] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductVendors](
[ProductVendorId] [uniqueidentifier] NOT NULL,
[ProductVendorName] [nvarchar](255) NOT NULL,
[SaveDate] [datetime2](7) NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_ProductVendors] PRIMARY KEY CLUSTERED
(
[ProductVendorId] 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
/****** Object: Table [dbo].[Roles] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Roles](
[RoleId] [uniqueidentifier] NOT NULL,
[RoleName] [nvarchar](100) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED
(
[RoleId] 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
/****** Object: Table [dbo].[SaveLists] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SaveLists](
[UserId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NOT NULL,
[SaveDate] [datetime2](7) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_SaveLists] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[PostId] 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
/****** Object: Table [dbo].[UserActions] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserActions](
[ActionId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[PostId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NULL,
[ActionType] [nvarchar](50) NOT NULL,
[ActionDate] [datetime2](7) NOT NULL,
CONSTRAINT [PK_UserActions] PRIMARY KEY CLUSTERED
(
[ActionId] 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
/****** Object: Table [dbo].[Users] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
[UserId] [uniqueidentifier] NOT NULL,
[RoleId] [uniqueidentifier] NOT NULL,
[Username] [nvarchar](50) NOT NULL,
[ProfileName] [nvarchar](100) NOT NULL,
[Email] [nvarchar](max) NOT NULL,
[Password] [nvarchar](255) NOT NULL,
[UrlImage] [nvarchar](1000) NULL,
[Bio] [nvarchar](500) NULL,
[Phone] [nvarchar](max) NOT NULL,
[Lastname] [nvarchar](50) NULL,
[Firstname] [nvarchar](50) NULL,
[Birthday] [date] NULL,
[Gender] [bit] NULL,
[State] [nvarchar](100) NULL,
[CreatedDate] [datetime2](7) NULL,
[UpdatedDate] [datetime2](7) NULL,
[IsAcceptMarketing] [bit] NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserId] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WishLists] Script Date: 20/12/2024 6:04:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WishLists](
[UserId] [uniqueidentifier] NOT NULL,
[ProductId] [uniqueidentifier] NOT NULL,
[SaveDate] [datetime2](7) NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_WishLists] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[ProductId] 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
/****** Object: Index [IX_Addresses_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Addresses_UserId] ON [dbo].[Addresses]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Admins_RoleId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Admins_RoleId] ON [dbo].[Admins]
(
[RoleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_CartItems_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_CartItems_ProductId] ON [dbo].[CartItems]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_CartItems_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_CartItems_UserId] ON [dbo].[CartItems]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Follows_FollowerId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Follows_FollowerId] ON [dbo].[Follows]
(
[FollowerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_OrderedProducts_OrderId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_OrderedProducts_OrderId] ON [dbo].[OrderedProducts]
(
[OrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_OrderedProducts_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_OrderedProducts_ProductId] ON [dbo].[OrderedProducts]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_OrderedProducts_ProductVariantVariantId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_OrderedProducts_ProductVariantVariantId] ON [dbo].[OrderedProducts]
(
[ProductVariantVariantId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Orders_ComfirmUserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Orders_ComfirmUserId] ON [dbo].[Orders]
(
[ComfirmUserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Orders_PaymentMethodId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Orders_PaymentMethodId] ON [dbo].[Orders]
(
[PaymentMethodId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Orders_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Orders_UserId] ON [dbo].[Orders]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostCommentLikes_CommentId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostCommentLikes_CommentId] ON [dbo].[PostCommentLikes]
(
[CommentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostComments_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostComments_PostId] ON [dbo].[PostComments]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostComments_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostComments_UserId] ON [dbo].[PostComments]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostImages_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostImages_PostId] ON [dbo].[PostImages]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostLikes_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostLikes_PostId] ON [dbo].[PostLikes]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostProductTag_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostProductTag_PostId] ON [dbo].[PostProductTag]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_PostProductTag_ProductTagId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_PostProductTag_ProductTagId] ON [dbo].[PostProductTag]
(
[ProductTagId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Posts_AuthorId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Posts_AuthorId] ON [dbo].[Posts]
(
[AuthorId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductCollections_CollectionId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductCollections_CollectionId] ON [dbo].[ProductCollections]
(
[CollectionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductCollections_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductCollections_ProductId] ON [dbo].[ProductCollections]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductComments_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductComments_ProductId] ON [dbo].[ProductComments]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductComments_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductComments_UserId] ON [dbo].[ProductComments]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductImages_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductImages_ProductId] ON [dbo].[ProductImages]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Products_AdminId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Products_AdminId] ON [dbo].[Products]
(
[AdminId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Products_ProductVendorId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Products_ProductVendorId] ON [dbo].[Products]
(
[ProductVendorId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductTags_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductTags_ProductId] ON [dbo].[ProductTags]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_ProductVariants_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_ProductVariants_ProductId] ON [dbo].[ProductVariants]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_SaveLists_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_SaveLists_PostId] ON [dbo].[SaveLists]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_UserActions_PostId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_UserActions_PostId] ON [dbo].[UserActions]
(
[PostId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_UserActions_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_UserActions_ProductId] ON [dbo].[UserActions]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_UserActions_UserId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_UserActions_UserId] ON [dbo].[UserActions]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_Users_RoleId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_Users_RoleId] ON [dbo].[Users]
(
[RoleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
/****** Object: Index [IX_WishLists_ProductId] Script Date: 20/12/2024 6:04:45 PM ******/
CREATE NONCLUSTERED INDEX [IX_WishLists_ProductId] ON [dbo].[WishLists]
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PostCommentLikes] ADD DEFAULT (getutcdate()) FOR [LikedDate]
GO
ALTER TABLE [dbo].[PostCommentLikes] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[PostComments] ADD DEFAULT (getutcdate()) FOR [CreateDate]
GO
ALTER TABLE [dbo].[PostComments] ADD DEFAULT (getutcdate()) FOR [UpdateDate]
GO
ALTER TABLE [dbo].[PostComments] ADD DEFAULT (CONVERT([bigint],(0))) FOR [LikeNumber]
GO
ALTER TABLE [dbo].[PostComments] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[PostLikes] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT ((0)) FOR [ViewNumber]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT ((0)) FOR [ShareNumber]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT (getdate()) FOR [CreateDate]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT (getdate()) FOR [UpdateDate]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT (CONVERT([bit],(1))) FOR [IsVisible]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[Posts] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsReported]
GO
ALTER TABLE [dbo].[ProductTags] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[SaveLists] ADD DEFAULT (getdate()) FOR [SaveDate]
GO
ALTER TABLE [dbo].[SaveLists] ADD DEFAULT (CONVERT([bit],(0))) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[Addresses] WITH CHECK ADD CONSTRAINT [FK_Addresses_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Addresses] CHECK CONSTRAINT [FK_Addresses_Users_UserId]
GO
ALTER TABLE [dbo].[Admins] WITH CHECK ADD CONSTRAINT [FK_Admins_Roles_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[Roles] ([RoleId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Admins] CHECK CONSTRAINT [FK_Admins_Roles_RoleId]
GO
ALTER TABLE [dbo].[CartItems] WITH CHECK ADD CONSTRAINT [FK_CartItems_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CartItems] CHECK CONSTRAINT [FK_CartItems_Products_ProductId]
GO
ALTER TABLE [dbo].[CartItems] WITH CHECK ADD CONSTRAINT [FK_CartItems_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CartItems] CHECK CONSTRAINT [FK_CartItems_Users_UserId]
GO
ALTER TABLE [dbo].[Follows] WITH CHECK ADD CONSTRAINT [FK_Follows_Users_FollowerId] FOREIGN KEY([FollowerId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[Follows] CHECK CONSTRAINT [FK_Follows_Users_FollowerId]
GO
ALTER TABLE [dbo].[Follows] WITH CHECK ADD CONSTRAINT [FK_Follows_Users_FollowingId] FOREIGN KEY([FollowingId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[Follows] CHECK CONSTRAINT [FK_Follows_Users_FollowingId]
GO
ALTER TABLE [dbo].[OrderedProducts] WITH CHECK ADD CONSTRAINT [FK_OrderedProducts_Orders_OrderId] FOREIGN KEY([OrderId])
REFERENCES [dbo].[Orders] ([OrderId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[OrderedProducts] CHECK CONSTRAINT [FK_OrderedProducts_Orders_OrderId]
GO
ALTER TABLE [dbo].[OrderedProducts] WITH CHECK ADD CONSTRAINT [FK_OrderedProducts_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[OrderedProducts] CHECK CONSTRAINT [FK_OrderedProducts_Products_ProductId]
GO
ALTER TABLE [dbo].[OrderedProducts] WITH CHECK ADD CONSTRAINT [FK_OrderedProducts_ProductVariants_ProductVariantVariantId] FOREIGN KEY([ProductVariantVariantId])
REFERENCES [dbo].[ProductVariants] ([VariantId])
GO
ALTER TABLE [dbo].[OrderedProducts] CHECK CONSTRAINT [FK_OrderedProducts_ProductVariants_ProductVariantVariantId]
GO
ALTER TABLE [dbo].[Orders] WITH CHECK ADD CONSTRAINT [FK_Orders_Admins_ComfirmUserId] FOREIGN KEY([ComfirmUserId])
REFERENCES [dbo].[Admins] ([AdminId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_Admins_ComfirmUserId]
GO
ALTER TABLE [dbo].[Orders] WITH CHECK ADD CONSTRAINT [FK_Orders_PaymentMethods_PaymentMethodId] FOREIGN KEY([PaymentMethodId])
REFERENCES [dbo].[PaymentMethods] ([PaymentMethodId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_PaymentMethods_PaymentMethodId]
GO
ALTER TABLE [dbo].[Orders] WITH CHECK ADD CONSTRAINT [FK_Orders_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_Users_UserId]
GO
ALTER TABLE [dbo].[PostCommentLikes] WITH CHECK ADD CONSTRAINT [FK_PostCommentLikes_PostComments_CommentId] FOREIGN KEY([CommentId])
REFERENCES [dbo].[PostComments] ([PostCommentId])
GO
ALTER TABLE [dbo].[PostCommentLikes] CHECK CONSTRAINT [FK_PostCommentLikes_PostComments_CommentId]
GO
ALTER TABLE [dbo].[PostCommentLikes] WITH CHECK ADD CONSTRAINT [FK_PostCommentLikes_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[PostCommentLikes] CHECK CONSTRAINT [FK_PostCommentLikes_Users_UserId]
GO
ALTER TABLE [dbo].[PostComments] WITH CHECK ADD CONSTRAINT [FK_PostComments_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
GO
ALTER TABLE [dbo].[PostComments] CHECK CONSTRAINT [FK_PostComments_Posts_PostId]
GO
ALTER TABLE [dbo].[PostComments] WITH CHECK ADD CONSTRAINT [FK_PostComments_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[PostComments] CHECK CONSTRAINT [FK_PostComments_Users_UserId]
GO
ALTER TABLE [dbo].[PostImages] WITH CHECK ADD CONSTRAINT [FK_PostImages_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
ON DELETE SET NULL
GO
ALTER TABLE [dbo].[PostImages] CHECK CONSTRAINT [FK_PostImages_Posts_PostId]
GO
ALTER TABLE [dbo].[PostLikes] WITH CHECK ADD CONSTRAINT [FK_PostLikes_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
GO
ALTER TABLE [dbo].[PostLikes] CHECK CONSTRAINT [FK_PostLikes_Posts_PostId]
GO
ALTER TABLE [dbo].[PostLikes] WITH CHECK ADD CONSTRAINT [FK_PostLikes_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[PostLikes] CHECK CONSTRAINT [FK_PostLikes_Users_UserId]
GO
ALTER TABLE [dbo].[PostProductTag] WITH CHECK ADD CONSTRAINT [FK_PostProductTag_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
GO
ALTER TABLE [dbo].[PostProductTag] CHECK CONSTRAINT [FK_PostProductTag_Posts_PostId]
GO
ALTER TABLE [dbo].[PostProductTag] WITH CHECK ADD CONSTRAINT [FK_PostProductTag_ProductTags_ProductTagId] FOREIGN KEY([ProductTagId])
REFERENCES [dbo].[ProductTags] ([ProductTagId])
GO
ALTER TABLE [dbo].[PostProductTag] CHECK CONSTRAINT [FK_PostProductTag_ProductTags_ProductTagId]
GO
ALTER TABLE [dbo].[Posts] WITH CHECK ADD CONSTRAINT [FK_Posts_Users_AuthorId] FOREIGN KEY([AuthorId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[Posts] CHECK CONSTRAINT [FK_Posts_Users_AuthorId]
GO
ALTER TABLE [dbo].[ProductCollections] WITH CHECK ADD CONSTRAINT [FK_ProductCollections_Collections_CollectionId] FOREIGN KEY([CollectionId])
REFERENCES [dbo].[Collections] ([CollectionId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductCollections] CHECK CONSTRAINT [FK_ProductCollections_Collections_CollectionId]
GO
ALTER TABLE [dbo].[ProductCollections] WITH CHECK ADD CONSTRAINT [FK_ProductCollections_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductCollections] CHECK CONSTRAINT [FK_ProductCollections_Products_ProductId]
GO
ALTER TABLE [dbo].[ProductComments] WITH CHECK ADD CONSTRAINT [FK_ProductComments_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductComments] CHECK CONSTRAINT [FK_ProductComments_Products_ProductId]
GO
ALTER TABLE [dbo].[ProductComments] WITH CHECK ADD CONSTRAINT [FK_ProductComments_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductComments] CHECK CONSTRAINT [FK_ProductComments_Users_UserId]
GO
ALTER TABLE [dbo].[ProductImages] WITH CHECK ADD CONSTRAINT [FK_ProductImages_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductImages] CHECK CONSTRAINT [FK_ProductImages_Products_ProductId]
GO
ALTER TABLE [dbo].[Products] WITH CHECK ADD CONSTRAINT [FK_Products_Admins_AdminId] FOREIGN KEY([AdminId])
REFERENCES [dbo].[Admins] ([AdminId])
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_Admins_AdminId]
GO
ALTER TABLE [dbo].[Products] WITH CHECK ADD CONSTRAINT [FK_Products_ProductVendors_ProductVendorId] FOREIGN KEY([ProductVendorId])
REFERENCES [dbo].[ProductVendors] ([ProductVendorId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_ProductVendors_ProductVendorId]
GO
ALTER TABLE [dbo].[ProductTags] WITH CHECK ADD CONSTRAINT [FK_ProductTags_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
GO
ALTER TABLE [dbo].[ProductTags] CHECK CONSTRAINT [FK_ProductTags_Products_ProductId]
GO
ALTER TABLE [dbo].[ProductVariants] WITH CHECK ADD CONSTRAINT [FK_ProductVariants_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ProductVariants] CHECK CONSTRAINT [FK_ProductVariants_Products_ProductId]
GO
ALTER TABLE [dbo].[SaveLists] WITH CHECK ADD CONSTRAINT [FK_SaveLists_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
GO
ALTER TABLE [dbo].[SaveLists] CHECK CONSTRAINT [FK_SaveLists_Posts_PostId]
GO
ALTER TABLE [dbo].[SaveLists] WITH CHECK ADD CONSTRAINT [FK_SaveLists_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[SaveLists] CHECK CONSTRAINT [FK_SaveLists_Users_UserId]
GO
ALTER TABLE [dbo].[UserActions] WITH CHECK ADD CONSTRAINT [FK_UserActions_Posts_PostId] FOREIGN KEY([PostId])
REFERENCES [dbo].[Posts] ([PostId])
GO
ALTER TABLE [dbo].[UserActions] CHECK CONSTRAINT [FK_UserActions_Posts_PostId]
GO
ALTER TABLE [dbo].[UserActions] WITH CHECK ADD CONSTRAINT [FK_UserActions_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
GO
ALTER TABLE [dbo].[UserActions] CHECK CONSTRAINT [FK_UserActions_Products_ProductId]
GO
ALTER TABLE [dbo].[UserActions] WITH CHECK ADD CONSTRAINT [FK_UserActions_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[UserActions] CHECK CONSTRAINT [FK_UserActions_Users_UserId]
GO
ALTER TABLE [dbo].[Users] WITH CHECK ADD CONSTRAINT [FK_Users_Roles_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[Roles] ([RoleId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Roles_RoleId]
GO
ALTER TABLE [dbo].[WishLists] WITH CHECK ADD CONSTRAINT [FK_WishLists_Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
GO
ALTER TABLE [dbo].[WishLists] CHECK CONSTRAINT [FK_WishLists_Products_ProductId]
GO
ALTER TABLE [dbo].[WishLists] WITH CHECK ADD CONSTRAINT [FK_WishLists_Users_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[Users] ([UserId])
GO
ALTER TABLE [dbo].[WishLists] CHECK CONSTRAINT [FK_WishLists_Users_UserId]
GO
USE [master]
GO
ALTER DATABASE [SufyStylesShop] SET READ_WRITE
GO
Editor is loading...
Leave a Comment