Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [PLAYGROUND]
- GO
- /****** Object: Table [dbo].[USER] ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[USER](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [TYPE__ID] [int] NOT NULL,
- [Enabled] [bit] NOT NULL,
- [Username] [nvarchar](32) NOT NULL,
- [Password] [nchar](32) NOT NULL,
- [Email] [nvarchar](255) 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].[NATURAL_USER] ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[NATURAL_USER](
- [ID] [int] NOT NULL,
- [TYPE] AS ((1)) PERSISTED NOT NULL,
- [BirthDate] [date] NOT NULL,
- CONSTRAINT [PK_NATURAL_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
- SET ANSI_PADDING OFF
- GO
- /****** Object: Table [dbo].[JURIDICAL_USER] ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[JURIDICAL_USER](
- [ID] [int] NOT NULL,
- [TYPE] AS ((2)) PERSISTED NOT NULL,
- [CompanyName] [nvarchar](256) NOT NULL,
- [RegistrationNo] [nvarchar](max) NOT NULL,
- [Description] [nvarchar](max) NOT NULL,
- CONSTRAINT [PK_LEGAL_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] TEXTIMAGE_ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- /****** Object: Table [dbo].[USER_T] ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE [dbo].[USER_T](
- [ID] [int] IDENTITY(1,1) NOT NULL,
- [TYPE] [nvarchar](32) NOT NULL,
- CONSTRAINT [PK_USER_T] 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: Index [IX_USER] ******/
- ALTER TABLE [dbo].[USER] ADD CONSTRAINT [IX_USER] UNIQUE NONCLUSTERED
- (
- [Username] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- GO
- /****** Object: Index [PK_USER_TYPE] ******/
- CREATE UNIQUE NONCLUSTERED INDEX [PK_USER_TYPE] ON [dbo].[USER]
- (
- [ID] ASC,
- [TYPE__ID] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- GO
- SET ANSI_PADDING ON
- GO
- /****** Object: Index [IX_USER_T] ******/
- ALTER TABLE [dbo].[USER_T] ADD CONSTRAINT [IX_USER_T] UNIQUE NONCLUSTERED
- (
- [TYPE] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- GO
- SET ANSI_PADDING ON
- GO
- /****** TYPE DATA ******/
- SET IDENTITY_INSERT [dbo].[USER_T] ON
- GO
- INSERT [dbo].[USER_T] ([ID], [TYPE]) VALUES (2, N'JURIDICAL_USER')
- GO
- INSERT [dbo].[USER_T] ([ID], [TYPE]) VALUES (1, N'NATURAL_USER')
- GO
- SET IDENTITY_INSERT [dbo].[USER_T] OFF
- GO
- /****** Contraints ******/
- ALTER TABLE [dbo].[JURIDICAL_USER] WITH CHECK ADD CONSTRAINT [FK_JURIDICAL_USER___USER] FOREIGN KEY([ID])
- REFERENCES [dbo].[USER] ([ID])
- GO
- ALTER TABLE [dbo].[JURIDICAL_USER] CHECK CONSTRAINT [FK_JURIDICAL_USER___USER]
- GO
- ALTER TABLE [dbo].[JURIDICAL_USER] WITH CHECK ADD CONSTRAINT [FK_JURIDICAL_USER___USER___TYPEVALIDATION] FOREIGN KEY([ID], [TYPE])
- REFERENCES [dbo].[USER] ([ID], [TYPE__ID])
- GO
- ALTER TABLE [dbo].[JURIDICAL_USER] CHECK CONSTRAINT [FK_JURIDICAL_USER___USER___TYPEVALIDATION]
- GO
- ALTER TABLE [dbo].[NATURAL_USER] WITH CHECK ADD CONSTRAINT [FK_NATURAL_USER___USER] FOREIGN KEY([ID])
- REFERENCES [dbo].[USER] ([ID])
- GO
- ALTER TABLE [dbo].[NATURAL_USER] CHECK CONSTRAINT [FK_NATURAL_USER___USER]
- GO
- ALTER TABLE [dbo].[NATURAL_USER] WITH CHECK ADD CONSTRAINT [FK_NATURAL_USER___USER___TYPEVALIDATION] FOREIGN KEY([TYPE])
- REFERENCES [dbo].[USER_T] ([ID])
- GO
- ALTER TABLE [dbo].[NATURAL_USER] CHECK CONSTRAINT [FK_NATURAL_USER___USER___TYPEVALIDATION]
- GO
- ALTER TABLE [dbo].[USER] WITH CHECK ADD CONSTRAINT [FK_USER___USER_T] FOREIGN KEY([TYPE__ID])
- REFERENCES [dbo].[USER_T] ([ID])
- GO
- ALTER TABLE [dbo].[USER] CHECK CONSTRAINT [FK_USER___USER_T]
- GO
- USE [master]
- GO
- ALTER DATABASE [PLAYGROUND] SET READ_WRITE
- GO
- using (PLAYGROUND model = new PLAYGROUND())
- {
- USER user = new USER();
- user.Username = "admin";
- user.Password = "RANDOMHASH#123456";
- user.Email = "admin@example.org";
- user.NATURAL_USER = new NATURAL_USER();
- user.NATURAL_USER.BirthDate = new DateTime(1980, 01, 01);
- model.USER.Add(user);
- model.SaveChanges();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement