-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinitialization.sql
78 lines (70 loc) · 2.87 KB
/
initialization.sql
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
77
78
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 1', 'Description 1')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 2', 'Description 2')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 3', 'Description 3')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 4', 'Description 4')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 5', 'Description 5')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 6', 'Description 6')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 7', 'Description 7')
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (1, 'Person 1','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (2, 'Person 2','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (3, 'Person 3','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (4, 'Person 4','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (5, 'Person 5','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (6, 'Person 6','LastName', GETDATE(), 0)
GO
INSERT INTO [Person] ([id], [FirstName],[LastName],[BirthDate],[Gender])
VALUES (7, 'Person 7','LastName', GETDATE(), 0)
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 8', 'Description 8')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 9', 'Description 9')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 10', 'Description 10')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 11', 'Description 11')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 12', 'Description 12')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 13', 'Description 13')
GO
INSERT INTO ContentObject ([Name],[Description]) VALUES ('name 14', 'Description 14')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (8, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (9, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (10, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (11, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (12, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (13, 1, GETDATE(), 'Copyright © 2012')
GO
INSERT INTO Book ([Id],[AuthorId],[Published],[Copyright])
VALUES (14, 1, GETDATE(), 'Copyright © 2012')
GO