File: test/script_mssql/test.sql

??USE [test]

GO

/****** Object:  Table [dbo].[user]    Script Date: 2023.08.18. 23:05:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[user](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[LoginName] [varchar](100) NULL,

	[Password] [varchar](100) NULL,

	[LastLoginDateTime] [datetime] NULL,

	[IsLogged] [tinyint] NOT NULL,

	[IsDeleted] [tinyint] NOT NULL,

 CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED 

(

	[Id] 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

/****** Object:  Table [dbo].[user_userrolescollection]    Script Date: 2023.08.18. 23:05:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[user_userrolescollection](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[User] [int] NOT NULL,

	[UserRole] [int] NOT NULL,

	[IsDeleted] [tinyint] NOT NULL,

 CONSTRAINT [PK__user_use__3214EC07139C4111] PRIMARY KEY CLUSTERED 

(

	[Id] 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

/****** Object:  Table [dbo].[userrole]    Script Date: 2023.08.18. 23:05:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[userrole](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[Code] [varchar](50) NOT NULL,

	[Name] [varchar](100) NOT NULL,

	[IsDeleted] [tinyint] NOT NULL,

 CONSTRAINT [PK__userrole__3214EC07DE834AB3] PRIMARY KEY CLUSTERED 

(

	[Id] 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

/****** Object:  Table [dbo].[userrole_userrolesettingscollection]    Script Date: 2023.08.18. 23:05:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[userrole_userrolesettingscollection](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[UserRole] [int] NOT NULL,

	[UserRoleSetting] [int] NOT NULL,

	[Value] [varchar](100) NULL,

	[IsDeleted] [tinyint] NOT NULL,

 CONSTRAINT [PK__user_use__3214EC0779CD1A8E] PRIMARY KEY CLUSTERED 

(

	[Id] 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

/****** Object:  Table [dbo].[userrolesetting]    Script Date: 2023.08.18. 23:05:21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[userrolesetting](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[Name] [varchar](100) NOT NULL,

	[DefaultValue] [varchar](100) NULL,

	[IsDeleted] [tinyint] NOT NULL,

 CONSTRAINT [PK__usersett__3214EC07E74868B6] PRIMARY KEY CLUSTERED 

(

	[Id] 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