INSERT INTO Category (Name) VALUES ('Category 1')
INSERT INTO Category (Name) VALUES ('Category 2')
INSERT INTO Category (Name) VALUES ('Category 3')

INSERT INTO Tag (Name) VALUES ('Tag 1')
INSERT INTO Tag (Name) VALUES ('Tag 2')
INSERT INTO Tag (Name) VALUES ('Tag 3')

INSERT INTO [User] (Email, DisplayName, FirstName, Surname) VALUES ('User1@Test.Com', 'User 1', 'Jill', 'Smith')
INSERT INTO [User] (Email, DisplayName, FirstName, Surname) VALUES ('User2@Test.Com', 'User 2', 'Fred', 'Black')
INSERT INTO [User] (Email, DisplayName, FirstName, Surname) VALUES ('User3@Test.Com', 'User 3', 'Bob', 'Baker')
INSERT INTO [User] (Email, DisplayName, FirstName, Surname) VALUES ('User4@Test.Com', 'User 4', 'James', 'Long')

INSERT INTO Post (Title, Content, PublishedAt, UserId) VALUES ('Post 1', 'Content....', '2009-10-15', 1)
INSERT INTO Post (Title, Content, PublishedAt, UserId) VALUES ('Post 2', 'Content....', '2009-10-20', 1)
INSERT INTO Post (Title, Content, PublishedAt, UserId) VALUES ('Post 3', 'Content....', '2009-10-25', 1)

INSERT INTO PostCategories VALUES (1, 1)
INSERT INTO PostCategories VALUES (1, 3)
INSERT INTO PostCategories VALUES (2, 2)
INSERT INTO PostCategories VALUES (3, 1)
INSERT INTO PostCategories VALUES (3, 2)
INSERT INTO PostCategories VALUES (3, 3)

INSERT INTO PostTags VALUES (1, 1)
INSERT INTO PostTags VALUES (1, 2)
INSERT INTO PostTags VALUES (1, 3)
INSERT INTO PostTags VALUES (2, 1)
INSERT INTO PostTags VALUES (2, 3)
INSERT INTO PostTags VALUES (3, 2)

INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 2, 1)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 4, 1)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 3, 1)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 1, 2)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 2, 2)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 1, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 2, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 3, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 4, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 4, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 3, 3)
INSERT INTO Comment (Content, UserId, PostId) VALUES ('Comment....', 4, 3)