API tools faq
paste
Advertisement
Guest User

Final Script

a guest
Oct 25th, 2016
3,790
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.28 KB | None | 0 0
raw download clone embed print report
  1. -- AspNetRoles
  2. INSERT INTO [dbo].[AspNetRoles] ([Id], [ConcurrencyStamp], [Name], [NormalizedName]) VALUES (N'1', N'3cd7bf81-4eaf-4405-ab15-cb4f2db17456', N'Administrator', N'Administrator')
  3.  
  4. -- AspNetUsers
  5. INSERT INTO [dbo].[AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName]) VALUES (N'3ca6b4fb-432c-40d7-a30f-224787f58dc6', 0, N'5ff1d981-5aef-4db2-87ef-0c6ff257b4d8', N'alice@gmail.com', 0, 1, NULL, N'ALICE@GMAIL.COM', N'ALICE@GMAIL.COM', N'AQAAAAEAACcQAAAAENKi/jmssWZOfCqbkLDvgX/0Hc70qmtXhYkmSDhGuURYXfbQDCukhSFFOGIf3TGAiw==', NULL, 0, N'280e0977-59a8-465c-bd71-5cd5bc591ec4', 0, N'alice@gmail.com')
  6. INSERT INTO [dbo].[AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName]) VALUES (N'4b85ab0f-c152-4a71-a9c5-62e21fdeda47', 0, N'd671d056-e454-4521-a427-e43005fea2ed', N'bob@gmail.com', 0, 1, NULL, N'BOB@GMAIL.COM', N'BOB@GMAIL.COM', N'AQAAAAEAACcQAAAAEJ44CRteEgrI86lrgfYzF8dN00EtWe7T4Pw71Qi/H1qj9ODHtOES15xSUBAJOrfakg==', NULL, 0, N'f164ea0d-789a-4fdd-864f-e0fe4f82891c', 0, N'bob@gmail.com')
  7. INSERT INTO [dbo].[AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName]) VALUES (N'52385453-dade-4ccd-a04f-f0d287cb56eb', 0, N'5751a8b5-f97f-4513-b6d7-48618a6f8aa7', N'eva@gmail.com', 0, 1, NULL, N'EVA@GMAIL.COM', N'EVA@GMAIL.COM', N'AQAAAAEAACcQAAAAENTlvCpszfjWk8OXQ45uCRTDv40UN+hJ7GCfMwyXKjdeMWeOTRpi5naBvfAt6xsw2g==', NULL, 0, N'654cbee6-7ad4-4ae6-9827-d6f622e8caff', 0, N'eva@gmail.com')
  8. INSERT INTO [dbo].[AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName]) VALUES (N'58c78e6a-a944-4a75-8c30-2c8097fcfbaa', 0, N'32fb0e22-7920-4cd6-9c10-b54414929e74', N'admin@admin.com', 0, 1, NULL, N'ADMIN@ADMIN.COM', N'ADMIN@ADMIN.COM', N'AQAAAAEAACcQAAAAEOCIPXE/HnTo7XWjfzgDar7KjGZIeRAnyEAtceeO2h5oMQA9ai7UgWfyAvFJLxEdEA==', NULL, 0, N'09cf70b9-c5bf-461e-baf9-e25f2afc70a7', 0, N'admin@admin.com')
  9.  
  10. -- AspNetUserRoles
  11. INSERT INTO [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'58c78e6a-a944-4a75-8c30-2c8097fcfbaa', N'1')
  12.  
  13. -- GameConsoles
  14. SET IDENTITY_INSERT [dbo].[GameConsoles] ON
  15. INSERT INTO [dbo].[GameConsoles] ([ConsoleID], [Name], [Developer], [ReleaseDate], [ImageUrl]) VALUES (2, N'PS3', N'Sony', N'2006-11-11 00:00:00', N'https://he.wikipedia.org/wiki/%D7%A7%D7%95%D7%91%D7%A5:PS3Versions.png')
  16. INSERT INTO [dbo].[GameConsoles] ([ConsoleID], [Name], [Developer], [ReleaseDate], [ImageUrl]) VALUES (3, N'Wii', N'Nintendo', N'2006-12-02 00:00:00', N'https://upload.wikimedia.org/wikipedia/commons/thumb/f/f3/Wii-Console.png/260px-Wii-Console.png')
  17. INSERT INTO [dbo].[GameConsoles] ([ConsoleID], [Name], [Developer], [ReleaseDate], [ImageUrl]) VALUES (4, N'Xbox 360', N'Microsoft', N'2005-11-22 00:00:00', N'https://en.wikipedia.org/wiki/File:Xbox-360-Pro-wController.png')
  18. SET IDENTITY_INSERT [dbo].[GameConsoles] OFF
  19.  
  20. -- Games
  21. SET IDENTITY_INSERT [dbo].[Games] ON
  22. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (3, N'http://img.gamefaqs.net/box/2/2/0/71220_front.jpg', 128, N'Assassin''s Creed', CAST(60.00 AS Decimal(18, 2)), N'Altair does some stuff', N'Ubisoft Montreal', N'Ubisoft', N'2007-11-02 00:00:00', 2)
  23. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (4, N'https://upload.wikimedia.org/wikipedia/en/7/76/SuperMarioGalaxy.jpg', 1077, N'Super Mario Galaxy', CAST(30.00 AS Decimal(18, 2)), N'Help evil Luigi conquer the galaxy', N'Nintendo EAD Tokyo', N'Nintendo', N'2007-01-11 00:00:00', 3)
  24. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (6, N'https://upload.wikimedia.org/wikipedia/en/thumb/8/80/Halo_-_Combat_Evolved_%28XBox_version_-_box_art%29.jpg/250px-Halo_-_Combat_Evolved_%28XBox_version_-_box_art%29.jpg', 740, N'Halo: Combat Evolved', CAST(30.00 AS Decimal(18, 2)), N'Master Cheif and Cortana win', N'Bungie', N'Microsoft Game Studios', N'2001-11-15 00:00:00', 4)
  25. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (8, N'https://upload.wikimedia.org/wikipedia/en/thumb/0/0e/The_Legend_of_Zelda_Twilight_Princess_Game_Cover.jpg/250px-The_Legend_of_Zelda_Twilight_Princess_Game_Cover.jpg', 1036, N'The Legend of Zelda: Twilight Princess', CAST(50.00 AS Decimal(18, 2)), N'Ganon is evil', N'Nintendo EAD', N'Nintendo', N'2006-11-19 00:00:00', 3)
  26. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (9, N'https://upload.wikimedia.org/wikipedia/en/5/5f/Dishonored_2_cover_art.jpg', 11118, N'Dishonoured 2', CAST(60.00 AS Decimal(18, 2)), N'Corvo is an assassin', N'Arkane Studios', N'Bethesda Softworks', N'2016-11-11 00:00:00', 2)
  27. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (10, N'https://upload.wikimedia.org/wikipedia/en/thumb/4/48/Batman_Arkham_series_logo.png/250px-Batman_Arkham_series_logo.png', 19245, N'Batman: Return to Arkham', CAST(60.00 AS Decimal(18, 2)), N'Nanananana Batman', N'Rocksteady Studios', N'Warner Bros.', N'2016-10-11 00:00:00', 4)
  28. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (11, N'https://upload.wikimedia.org/wikipedia/en/thumb/d/da/Super_Mario_Maker_Artwork.jpg/250px-Super_Mario_Maker_Artwork.jpg', 7339, N'Super Mario Maker', CAST(60.00 AS Decimal(18, 2)), N'Mario is now a builder!', N'Nintendo EAD', N'Nintendo', N'2015-09-10 00:00:00', 3)
  29. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (12, N'https://upload.wikimedia.org/wikipedia/en/thumb/5/5f/Tf2_standalonebox.jpg/250px-Tf2_standalonebox.jpg', 891, N'Team Fortress 2', CAST(30.00 AS Decimal(18, 2)), N'Pick Spy, trust me', N'Valve', N'Valve', N'2007-10-09 00:00:00', 4)
  30. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (13, N'https://upload.wikimedia.org/wikipedia/en/thumb/9/9e/Life_Is_Strange_cover.jpg/250px-Life_Is_Strange_cover.jpg', 7599, N'Life is Strange', CAST(100.00 AS Decimal(18, 2)), N'You... won''t regret it', N'Dontnod Entertainment', N'Square Enix', N'2015-01-30 00:00:00', 2)
  31. INSERT INTO [dbo].[Games] ([ID], [CoverUrl], [IgdbID], [Name], [Price], [Summary], [Developer], [Publisher], [ReleaseDate], [ConsoleID]) VALUES (14, N'https://upload.wikimedia.org/wikipedia/commons/thumb/5/52/StarWars_Battlefront_logo.PNG/256px-StarWars_Battlefront_logo.PNG', 2113, N'Star Wars: Battlefront', CAST(60.00 AS Decimal(18, 2)), N'I am not your father', N'EA DICE', N'Electronic Arts', N'2015-11-17 00:00:00', 2)
  32. SET IDENTITY_INSERT [dbo].[Games] OFF
  33.  
  34. -- Orders
  35. SET IDENTITY_INSERT [dbo].[Orders] ON
  36. INSERT INTO [dbo].[Orders] ([ID], [DateCreated], [UserID]) VALUES (9, N'2016-10-25 21:31:30', N'4b85ab0f-c152-4a71-a9c5-62e21fdeda47')
  37. INSERT INTO [dbo].[Orders] ([ID], [DateCreated], [UserID]) VALUES (10, N'2016-10-25 21:31:59', N'3ca6b4fb-432c-40d7-a30f-224787f58dc6')
  38. INSERT INTO [dbo].[Orders] ([ID], [DateCreated], [UserID]) VALUES (11, N'2016-10-25 21:32:49', N'52385453-dade-4ccd-a04f-f0d287cb56eb')
  39. SET IDENTITY_INSERT [dbo].[Orders] OFF
  40.  
  41. -- OrderItems
  42. SET IDENTITY_INSERT [dbo].[OrderItems] ON
  43. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (14, 4, 9, 1)
  44. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (15, 13, 9, 1)
  45. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (16, 8, 9, 1)
  46. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (17, 9, 10, 1)
  47. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (18, 3, 10, 1)
  48. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (19, 4, 11, 1)
  49. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (20, 11, 11, 1)
  50. INSERT INTO [dbo].[OrderItems] ([ID], [GameID], [OrderID], [Quantity]) VALUES (21, 14, 11, 1)
  51. SET IDENTITY_INSERT [dbo].[OrderItems] OFF
  52.  
  53. -- Shops
  54. SET IDENTITY_INSERT [dbo].[Shops] ON
  55. INSERT INTO [dbo].[Shops] ([ID], [Location], [Name]) VALUES (2, N'College of Management,Rishon Lezion,Israel', N'Rishon Snif')
  56. INSERT INTO [dbo].[Shops] ([ID], [Location], [Name]) VALUES (4, N'Bialik 28,Petah Tikva,Israel', N'Main Branch')
  57. SET IDENTITY_INSERT [dbo].[Shops] OFF
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!