-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathScriptBD.sql
More file actions
76 lines (74 loc) · 3.31 KB
/
ScriptBD.sql
File metadata and controls
76 lines (74 loc) · 3.31 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
CREATE DATABASE [DBExam]
GO
USE [DBExam]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ticket](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserId] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[UpdatedDate] [datetime] NULL,
[Status] [bit] NOT NULL,
CONSTRAINT [PK_Ticket] PRIMARY KEY CLUSTERED
(
[Id] 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
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
[LastName] [varchar](50) NOT NULL,
[Email] [varchar](50) NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[UpdatedDate] [datetime] NULL,
[Status] [bit] 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Ticket] ON
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (1, 1, CAST(N'2021-08-27T10:55:03.253' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (2, 1, CAST(N'2021-08-26T10:56:06.320' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (3, 1, CAST(N'2021-08-26T10:58:11.313' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (4, 1, CAST(N'2021-08-27T10:59:23.690' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (5, 1, CAST(N'2021-08-27T11:50:04.550' AS DateTime), CAST(N'2021-08-27T12:14:04.967' AS DateTime), 0)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (6, 1, CAST(N'2021-08-27T11:58:16.100' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (7, 1, CAST(N'2021-08-27T11:59:18.893' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (8, 2, CAST(N'2021-08-26T12:00:28.807' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (9, 2, CAST(N'2021-08-27T12:05:55.570' AS DateTime), NULL, 1)
GO
INSERT [dbo].[Ticket] ([Id], [UserId], [CreatedDate], [UpdatedDate], [Status]) VALUES (12, 1, CAST(N'2021-08-27T12:17:25.553' AS DateTime), NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[Ticket] OFF
GO
SET IDENTITY_INSERT [dbo].[User] ON
GO
INSERT [dbo].[User] ([Id], [Name], [LastName], [Email], [CreatedDate], [UpdatedDate], [Status]) VALUES (1, N'Alan', N'Rios', N'alanrb92@gmail.com', CAST(N'2021-08-25T00:00:00.000' AS DateTime), NULL, 1)
GO
INSERT [dbo].[User] ([Id], [Name], [LastName], [Email], [CreatedDate], [UpdatedDate], [Status]) VALUES (2, N'Juan', N'Perez', N'jperez@gmail.com', CAST(N'2021-08-25T00:00:00.000' AS DateTime), NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[User] OFF
GO
ALTER TABLE [dbo].[Ticket] WITH CHECK ADD CONSTRAINT [FK_Ticket_User] FOREIGN KEY([UserId])
REFERENCES [dbo].[User] ([Id])
GO
ALTER TABLE [dbo].[Ticket] CHECK CONSTRAINT [FK_Ticket_User]