Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
USE [master]
GO
/****** Object: Database [DapperExample] Script Date: 3/08/2019 3:26:01 PM ******/
CREATE DATABASE [DapperExample]
GO
USE [DapperExample]
GO
/****** Object: Table [dbo].[Event] Script Date: 3/08/2019 3:26:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Event](
[Id] [int] IDENTITY(1,1) NOT NULL,
[EventLocationId] [int] NOT NULL,
[EventName] [nvarchar](200) NOT NULL,
[EventDate] [datetime] NOT NULL,
[DateCreated] [datetime] NOT NULL,
CONSTRAINT [PK_Event] 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].[EventLocation] Script Date: 3/08/2019 3:26:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EventLocation](
[Id] [int] IDENTITY(1,1) NOT NULL,
[LocationName] [nvarchar](max) NOT NULL,
[DateCreated] [datetime] NOT NULL,
CONSTRAINT [PK_EventLocation] 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 IDENTITY_INSERT [dbo].[Event] ON
GO
INSERT [dbo].[Event] ([Id], [EventLocationId], [EventName], [EventDate], [DateCreated]) VALUES (1, 1, N'David Bowie', CAST(N'2019-01-11T00:00:00.000' AS DateTime), CAST(N'2019-01-20T02:11:46.453' AS DateTime))
GO
INSERT [dbo].[Event] ([Id], [EventLocationId], [EventName], [EventDate], [DateCreated]) VALUES (2, 1, N'Iggy Pop', CAST(N'2019-01-12T00:00:00.000' AS DateTime), CAST(N'2019-01-20T02:12:14.153' AS DateTime))
GO
INSERT [dbo].[Event] ([Id], [EventLocationId], [EventName], [EventDate], [DateCreated]) VALUES (3, 2, N'The Smiths', CAST(N'2019-01-11T00:00:00.000' AS DateTime), CAST(N'2019-01-20T02:12:24.850' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[Event] OFF
GO
SET IDENTITY_INSERT [dbo].[EventLocation] ON
GO
INSERT [dbo].[EventLocation] ([Id], [LocationName], [DateCreated]) VALUES (1, N'Superdome', CAST(N'2019-01-20T02:10:51.593' AS DateTime))
GO
INSERT [dbo].[EventLocation] ([Id], [LocationName], [DateCreated]) VALUES (2, N'Vector Arena', CAST(N'2019-01-20T02:11:31.073' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[EventLocation] OFF
GO
ALTER TABLE [dbo].[Event] ADD CONSTRAINT [DF_Event_DateCreated] DEFAULT (getutcdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[EventLocation] ADD CONSTRAINT [DF_EventLocation_DateCreated] DEFAULT (getutcdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[Event] WITH CHECK ADD CONSTRAINT [FK_Event_EventLocation] FOREIGN KEY([EventLocationId])
REFERENCES [dbo].[EventLocation] ([Id])
GO
ALTER TABLE [dbo].[Event] CHECK CONSTRAINT [FK_Event_EventLocation]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.