-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathFillDatabase.sql
51 lines (44 loc) · 33.5 KB
/
FillDatabase.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
USE [Concrete.BioscoopModel]
GO
SET IDENTITY_INSERT [dbo].[HallLayouts] ON
INSERT [dbo].[HallLayouts] ([HallLayoutID], [Rows], [SeatsPerRow]) VALUES (1, 10, 10)
INSERT [dbo].[HallLayouts] ([HallLayoutID], [Rows], [SeatsPerRow]) VALUES (2, 5, 15)
INSERT [dbo].[HallLayouts] ([HallLayoutID], [Rows], [SeatsPerRow]) VALUES (3, 10, 20)
SET IDENTITY_INSERT [dbo].[HallLayouts] OFF
SET IDENTITY_INSERT [dbo].[Halls] ON
INSERT [dbo].[Halls] ([HallID], [Capacity], [HallLayoutID]) VALUES (1, 75, 1)
INSERT [dbo].[Halls] ([HallID], [Capacity], [HallLayoutID]) VALUES (2, 75, 2)
INSERT [dbo].[Halls] ([HallID], [Capacity], [HallLayoutID]) VALUES (3, 75, 3)
SET IDENTITY_INSERT [dbo].[Halls] OFF
SET IDENTITY_INSERT [dbo].[Movies] ON
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (1, N'Deadpool', N'Deadpool is een Amerikaanse komische superheldenfilm uit 2016, gebaseerd op het Marvel Comics-personage Deadpool. Het is de achtste film in de X-Men filmserie. De hoofdrollen worden vertolkt door Ryan Reynolds, Morena Baccarin, Ed Skrein, T.J. Miller en Gina Carano. De film ging op 8 februari 2016 in première', 118, 0, N'Nederlands', 1, N'Action, Comedy', N'12', CAST(N'2017-08-20 00:00:00.000' AS DateTime), N'Steven Spielberg', N'Jason Stattham, Sean Vissers', N'http://www.imdb.com/title/tt1431045/', N'https://www.youtube.com/watch?v=I4tFNfROlqk&t=74s', N'http://www.foxmovies.com/movies/deadpool', N'http://t1.gstatic.com/images?q=tbn:ANd9GcR-fLY3Z9Vn28UB-A3X_w0vjmkHcXG89HWwul5w6-sg3IonPXA_')
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (2, N'Lord of the rings', N'Een Ring wordt weer gevonden in het land van Midden-Aarde(Middle-Earth), Gandalf, de tovenaar, komt bij een van zijn bezoeken aan de Hobbits, halflingen, erachter dat het de Ene Ring is, gesmeed door de zwarte heerser zelf, Sauron. Gandalf raadt Frodo aan om het in de vulkanen van Mordor te gooien, in dezelfde vuren waar hij is gesmeed. Het enige probleem is…in Mordor woont Sauron, ook al niet in zijn oorspronkelijke vorm, blijft hij machtig, mededankzij zijn lakeien de Nazgúl.', 160, 0, N'Engels', 1, N'Adventure, Sci-Fi', N'12', CAST(N'2017-06-15 00:00:00.000' AS DateTime), N'Peter Jackson', N'Elijah Wood, Ian McKellen, Orlando Bloom', N'http://www.imdb.com/title/tt0120737/', N'https://www.youtube.com/watch?v=V75dMMIW2B4', N'http://www.theonering.com/', N'http://static.rogerebert.com/uploads/movie/movie_poster/lord-of-the-rings-the-fellowship-of-the-ring-2001/large_9HG6pINW1KoFTAKY3LdybkoOKAm.jpg')
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (3, N'Star wars: Rogue One', N'Rogue One: A Star Wars Story[4], of kortweg Rogue One, is een Amerikaanse sciencefictionfilm uit 2016 en het eerste deel uit de anthologyreeks van de succesvolle filmfranchise Star Wars. De film wordt geregisseerd door Gareth Edwards en geproduceerd door Lucasfilm en Walt Disney Pictures. Het scenario van de film is van de hand van Gary Whitta en Chris Weitz, gebaseerd op een idee van John Knoll. Felicity Jones speelt de hoofdrol in de film.', 163, 0, N'Nederlands', 1, N'Sci-Fi', N'18', CAST(N'2017-07-25 00:00:00.000' AS DateTime), N'George Lucas', N'Mark Hamill, Harrison Ford, Carrie Fisher', N'http://www.imdb.com/title/tt0076759/', N'https://www.youtube.com/watch?v=1g3_CFmnU7k', N'', N'https://lumiere-a.akamaihd.net/v1/images/rogueone_onesheeta_1000_309ed8f6.jpeg?region=0%2C0%2C1000%2C1481&width=480')
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (4, N'Star Trek: The Motion Picture', N'In 2273 wordt het Klingonrijk binnengevallen door een buitenaardse macht, verhuld in een gigantische energiewolk met een diameter van meer dan 10 miljard kilometer. Deze vernietigt drie Klingonschepen en Epsilon 9, een buitenpost van de Federatie. De wolk lijkt op weg naar de Aarde te zijn. De USS Enterprise NCC-1701 wordt er op uitgestuurd om het fenomeen te onderzoeken.', 135, 0, N'Engels', 1, N'Sci-Fi', N'16', CAST(N'2017-09-23 00:00:00.000' AS DateTime), N'Robert Wise', N'William Shatner, Leonard Nimoy, DeForest Kelley', N'http://www.imdb.com/title/tt0079945/', N'https://www.youtube.com/watch?v=ZLlV_JVtO5c', N'', N'http://worldcinemaparadise.com/wp/wp-content/uploads/2015/04/STTMP.jpg')
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (5, N'Logan', N'In de nabije toekomst, een vermoeide Logan zorgt voor een noodlijdende Professor X in een schuilplaats aan de Mexicaanse grens. Maar Logan''s pogingen om te verbergen voor de wereld en zijn erfenis zijn up-eindigde toen een jonge mutant komt, door duistere krachten worden nagestreefd.', 200, 1, N'Engels', 1, N'Sci-Fi, Action', N'18', CAST(N'2017-09-23 00:00:00.000' AS DateTime), N'Mathijs Kors', N'Mathijs Kors', N'http://www.imdb.com/title/tt3315342/?ref_=fn_al_tt_1', N'https://www.youtube.com/watch?v=DekuSxJgpbY', N'', N'http://cdn2-www.superherohype.com/assets/uploads/gallery/untitled-wolverine-sequel/cuaiczwueaaid_w-jpg-large.jpg')
INSERT [dbo].[Movies] ([MovieID], [Title], [Description], [Length], [ThreeD], [Language], [Subtitles], [Genre], [Age], [RunTime], [Director], [Actor], [Imdb], [Trailer], [Site], [ImgUrl]) VALUES (6, N'The Shawshank Redemption', N'In de nabije toekomst, een vermoeide Logan zorgt voor een noodlijdende Professor X in een schuilplaats aan de Mexicaanse grens. Maar Logan''s pogingen om te verbergen voor de wereld en zijn erfenis zijn up-eindigde toen een jonge mutant komt, door duistere krachten worden nagestreefd.', 120, 0, N'Engels', 1, N'Drama', N'18', CAST(N'2017-09-23 00:00:00.000' AS DateTime), N'Stephen King', N'Tim Robbins, Morgan Freeman, Bob Gunton', N'http://www.imdb.com/title/tt0111161/?pf_rd_m=A2FGELUUNOQJNL&pf_rd_p=2398042102&pf_rd_r=0F1RE99KZV45YYAYDWWT&pf_rd_s=center-1&pf_rd_t=15506&pf_rd_i=top&ref_=chttp_tt_1', N'https://www.youtube.com/watch?v=6hB3S9bIaco', N'', N'http://thegalileo.co.za/wp-content/uploads/2015/09/9O7gLzmreU0nGkIB6K3BsJbzvNv.jpg')
SET IDENTITY_INSERT [dbo].[Movies] OFF
SET IDENTITY_INSERT [dbo].[HallMovies] ON
INSERT [dbo].[HallMovies] ([HallMovieID], [MovieID], [HallID], [DateTime], [DateTimeEnd], [LadiesNight]) VALUES (1, 1, 1, CAST(N'2017-04-05 12:24:00.000' AS DateTime), CAST(N'2017-04-05 14:22:00.000' AS DateTime), 0)
INSERT [dbo].[HallMovies] ([HallMovieID], [MovieID], [HallID], [DateTime], [DateTimeEnd], [LadiesNight]) VALUES (2, 3, 2, CAST(N'2017-04-04 12:24:00.000' AS DateTime), CAST(N'2017-04-04 15:07:00.000' AS DateTime), 0)
SET IDENTITY_INSERT [dbo].[HallMovies] OFF
INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201703281642495_d', N'BioscoopB3Web.Domain.Migrations.Configuration', 0x1F8B0800000000000400DD5DDD6EDCB815BE2FD0771074D516598FEDDCA4C67817CED8698DC63FEB71767B1770247A2CAC7EA622E5D828FA647BB18FD45728259112299192484A9AE922409021C5EF1C929FCEE1CFD1C97F7FFD6DF9C36B143A2F304541129FBB2747C7AE03632FF183787BEE66F8E9BB0FEE0FDFFFF10FCB2B3F7A757E62CFBDCF9F232D6374EE3E63BC3B5B2C90F70C23808EA2C04B13943CE1232F8916C04F16A7C7C77F5D9C9C2C2081700996E32C1FB21807112C7E909FAB24F6E00E6720BC497C18225A4E6AD605AA730B228876C083E7EEC720415E92EC3EBEFF196E8E2E930804F1510E90420C5DE7220C00516A0DC327D701719C608089CA675F105CE33489B7EB1D2900E1E3DB0E92E79E408820EDCA59FDF8D05E1D9FE6BD5AD40D199497214C54D3033C794F8769D16C6E34D86E358C6420AFC880E3B7BCD7C5609EBB179E979059709DA6ACB35598E6CF2986BA000A203AA200EF1CD963EF2AAE104AE57FDE39AB2CC4590ACF6398E11484EF9CFB6C1306DE3FE0DB63F20B8CCFE32C0C799589D2A44E282045F769B283297E7B804FB42357445EE83A0BB1E9A2D9B66A29362B7B4AA84108EF3A37E0F5338CB7F899BC0AA71F5CE753F00A7D5642B9F2250EC8FB411AE134233F6F89DA6013C2AA7ED12936FFBB432AF9E720A9DD427E063146B7F01B0A21C63065F23E26490841ACADF36780F02C7ADF0384BE25A93FB920CADD5CCA08B23487F36F30F6EB4999AC8F0418423C9398DB2CDAD47DBA8EF1FB53ED7159110335B2BACB456DF73AADE1DF41187E066F496661106B8CBDDBC45A95EB4B7DD328B6EE9E526E98D638492121374C0186FE3DC84D0F717CD73E2C46BB6FFA1F926FC88E406B0830BA872941D201D222C94DF212403B8E141007419142135386548DE722C84081DD20B9E6B6189744FDC7A0F687F56F43A0ABD8B7C6FA0C7C42B0DB60FB8CB5FDFD2D7809B6C51C4946CB751E605854A2E760572EAD6B1E7F2D1FF99426D14312F2D4286ABEAE932CF5F2914AA4D58F20DDE64E6AA842F4F5EBD4883E2353A9FC5BAD53F9B74C292D2361671F0EC234985A85390DC20A902D21B76830B70843BD9DCE7BC396130AAE7EE59F11B9CA5549B9CAD75B71D5D2991D8623337662B33BB0C700877BD86F5C42E4A5C1AE3C47985B780966F7863E3E932DC6A5FD2E36DE6660BB870958671B9C4F3DB2ED02A15EBA07FD2FF631680F593CCE1A2B48A147DEDB3D0CDB7EC45E47FE66F25DFF630A82708E438C004F7FEC741D6DBFA45D6781931E3DDCA5C56990A9132E9AEFDD09175A9838E1AAE15C4E788DB3FCC9C7C0FB0562CB0387AB90281FBE8D82B57A0E427F14A4DB248D40380AD42319F47190EE939D97A4F1459A12370C2318633B3C711AEFD3C0AB5D05F4023200AE734F2C7F402FB63EB8CEDA0339BCDDD44C2B4924D4B4B2049A4C2BAAA0D1B422DAFC9A581E71129A1BC6C11E619DA52FF0CDDC2594EDF7EE134A354C9C42DD7236AF40C8037FB4334937641C835D0857CF0961DE8F932F5BEE76309E49CA35BA84212403ABB78319CCF8D20A9933BE6CBF77C6976A9830BE6E3917E3358EF07B8CFB3897A8FD573B766A6A5E0A19AF5487F0FF02A1C40B8A69E466833F111435B98A7DA7E778B01C7E76B84866A03446417E3E7AEEFEA5D53935243B516C40B2A34A11F8C46DBE157771692A1CB2FD2DDCEC0A200FF8EDE12563E38B25E4458269CE5E10AE9218915793F8D8F65B17C45EB00361B7FA8D66DAB7A4B98295A866CD25DCE577F831EE9E953174A8443506AF6FAC960B8E64FDDCE3EE72BA7822BBD81169428F94F5E827B910EA21F461F0AEADF7D0291F8170EDB9B0133E2BD34A9AF473A27161371AD7C48B3E0E578A79486C13341F32E38AFB1143BE091362297E74C695DE96B4C1A4054CA9066C5158C4964AD6985F10A4CB4C4417234DFEE4A86B88C5E031E43AB577A7ECA9822A5B1414216AAB2F43E1DDED00A06284553894CF03605408BD8D95F287C92ED655B2E6F460B4A779B95794B567DBE81E80EA78AB05C076250D008E7CE2080A57BADC538A5BDFE6FBD0BFCAAB54AF66ACF552F5AFEB1A20150D9B864BECE6C021E06342E423A05A690C596B345467C4EB1904C9EAA26F20AD7A4F69DFD57D89FB1BE4006D064074791C921CA56308D8B6A632B455DD725106ECD382E54211D9BFBC01BB1DD9297291FEB4C4599761FEABEFD6FA41EF5189B1F09024F6BDD2B6924436D0600B1BB54434D1F45390227C0930D8807C53B7F2A3D663A25B51D81826ABE139DAF3C54C0F6B90FF5B745FD20F1E2A8FD376C514E913E9637E1C5A741772D3AE6CE9E49F5D8010A4F288F955126651DC117BDF85518691F31065C97084566C3B0FD6AA1C8E5B07B9F38075E970A43A8A9D47AA4B87230961EA3C9850311C8F459EF350AC6C380A0B2CE75158992E0A8B1B6F63B19AE18865FC388FB4929C8315ED178D97A3B5346DBD90AD55BDF8820F7AFD79773B9E0550AF28061881AEC6AA71168F2CF8F1EE3ECC502396A1DF3C5259A2C1263EF45B20135F71504CA06E775C224817160379A068DB45836A73D7648172D7A7C6936219E0B0138EA64A7A2875BC118F5397EA231541DE32B0A242C7517181DEA2AFE22A0E8AEA63B3DC90E07ADCB6E7501D9F2C38A5AA548FD36626774FB33EBA7133356C9A466D2C2344437D79145AA46138F8B85DC170F0151A868386E20A36839669F48C06E30A5DA3653A468C05E38A168C956A78FE3AB856F0FB75B1D6FA3885ADE571AAA5CF45B353177AFDA9E25E85E5102BD4604F15F72A50A72AD5D985B4602E7431CAA0541EA22CD1E01D8B381588C70A35F85244940A54294A74FA52868B8ABD29CB0EC600D353D5F10C70791AAB6F8015ED54835BDDB2F3A3AB882EED9CE64698A7B8C114EB86A336033E85B390469DC63A4108FD14D60A428DC6318B18022A9CB788551A2FA0100B2ABC85428DC64189242654383291D49B32804603AA69401F309B3509BAA4DA94671274E90386FC90C0CBEA35992241E5CB6D582281563EA4218745740AB8ACF0600C3BBBEF1ACFB2D37B327DD3AE6AA85EAAB1B04E71A5260F13ED44A2E19A020E2DD3387168066C0A8BFE66E5705C1A982978B0B24813830BBB6C81717507C34DE603C6E326BD82D5E7A6AAA17AC3C60230C53D9B3CA0B30B69EC73B1F6E9BFEEB17F193CD93C15D53CA06D9DCF6AB159735537297F5BD797CD472AE9D53566E3BA7249AF0EFBB395B5EE12CB47F2EF100813FCFC1E71FD86308C8EF2078ED6FF0A5761502C74D80337200E9E20C26564B27B7A7C72DAC872763819C71608F9A1E4EA958BF496DE3ACE97E82B7E01A9F70CD276AA2F8B3C5E0CF44F1178FD338F6491AB6B1360EB3C5D567A357371598149F26D29F10C726859E926E6C91A014ACC8515C4FA13C967C2D250C824DB95C17B387E72A9628C7ABF67D00FF847369320C926D50F63904BCA7006C6CCDD34C9F8CB64B4622FAFC96BFC7AEEFEBB6873E65CFFF32B6DF6CE29960767CEB1F31FCB244F432597ADAC04373343F9E4371E2933943196243354BF77D1CB7764C861FB24439330B79957C8C47A28CDDC4022B2B61A74D44CFB63306763A5DA9964D684EC3A76AB0B49C61C3B40310B8E099FC41C3866AB4331FF8D5D8F5A396D4C5412F2D9D8E9733156C71A7967CC2D7823EF8C65F7C683E2F3C358AD761B3960EC56CE5C9E172B203197CB148B67C985D6BC395226B19EF2B42826964A9E14C5681B2449896282234D8862648425E9504C70D4C9508C362AEA5428FE6CA9504697D4910A657459EA5428A38B6AA742195D444F2A94F1E589A95046DC24CB2E98E6CE3D328DB515D28D98BCF48A642356BEF38E4F28628FD44A1A32E2AE5376BD33778E8E4998A13A9DB148CA61B730E3126F9828A2757A366CE9B387941BECA3CEF97362887A1824FA30FEDC5CF94D89DE89B0A3FB9DF9EF306DC6BCE92C241F7F9AA64E3026CFEC89307E3FC92FDA13367D4E8A7D5366F8148E9ACDE2FF248145FB83E4E6EC49135474E5A728C310C866609390892EBD699DD762D18DCFBB3E69CA08562993D29573402688D24E2A87D6A9C4283E6C974951E6BE5061F7C3AA14EF507AA0C23431460B9996CB9059928D1E649632A305CD2A64D855068E1E70964EA305CE2A64E08AB0E2999270882C6F7E31DBB6084DB7DFFC00AD6589F79D64A357459573907E3B3A66F746C8A2D15655AAE6445DD4C892D10E27233E84FB2F32890743C1B686C8FFC3CC187A82F7A89EB98E9F12E6C51A1AB1479A670910039FB8968B14074FC0C3A4DA830815991C7F0261969FC6451BE85FC77719DE65987419469B50F8823177865DF28B5420A2CECBBBE2860D8DD105A266905FD5DCC51FB320F42BBD3F4976880A88DCCBD28D7C3E9738DFD06FDF2AA4DB241E084487AF5A1C3CC2681712307417AFC10B34D1ED0B829FE116786F2C2A500DD23F11E2B02F2F03B04D41842846DD9EFC241CF6A3D7EFFF074157AD7129760000, N'6.1.3-40302')
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'a', 0, NULL, N'a', N'BackOffice', NULL, NULL, 0, NULL)
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'b', 0, NULL, N'b', N'Cashier', NULL, NULL, 0, NULL)
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'John', 1, N'Doe', NULL, N'NewsMailAccount', N'Female', NULL, 0, NULL)
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'John', 1, N'Doe', NULL, N'NewsMailAccount', N'Male', NULL, 0, NULL)
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'c', 0, NULL, N'c', N'Manager', NULL, NULL, 0, NULL)
INSERT [dbo].[Accounts] ([Email], [Name], [WantsNewsletter], [LastName], [Password], [AccountType], [Gender], [Street], [StreetNumber], [City]) VALUES (N'[email protected]', N'd', 0, NULL, N'd', N'SubscriptionHolder', NULL, N'Sesamstraat', 6, N'Utopia')
SET IDENTITY_INSERT [dbo].[Orders] ON
INSERT [dbo].[Orders] ([OrderID], [StudentTickets], [ElderlyTickets], [ChildTickets], [NormalTickets], [TotalTickets], [PopcornArrangement], [StudentTicketsPrice], [ChildTicketsPrice], [ElderlyTicketsPrice], [NormalTicketsPrice], [TotalPrice], [PopcornArrangementPrice], [PrintID]) VALUES (1, 0, 0, 0, 1, 1, 0, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(9.00 AS Decimal(18, 2)), CAST(9.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), 186917651)
INSERT [dbo].[Orders] ([OrderID], [StudentTickets], [ElderlyTickets], [ChildTickets], [NormalTickets], [TotalTickets], [PopcornArrangement], [StudentTicketsPrice], [ChildTicketsPrice], [ElderlyTicketsPrice], [NormalTicketsPrice], [TotalPrice], [PopcornArrangementPrice], [PrintID]) VALUES (2, 1, 0, 0, 0, 1, 0, CAST(7.50 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(7.50 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), 304375046)
SET IDENTITY_INSERT [dbo].[Orders] OFF
SET IDENTITY_INSERT [dbo].[Surveys] ON
INSERT [dbo].[Surveys] ([SurveyID], [ScoreQ], [MultipleChoiceQ], [OpenQ], [OpenQIsDeleted]) VALUES (1, 3, N'Kan beter', N'Test', 0)
INSERT [dbo].[Surveys] ([SurveyID], [ScoreQ], [MultipleChoiceQ], [OpenQ], [OpenQIsDeleted]) VALUES (2, 3, N'Nog nooit zo slecht gezien', N'Meer kleur', 0)
INSERT [dbo].[Surveys] ([SurveyID], [ScoreQ], [MultipleChoiceQ], [OpenQ], [OpenQIsDeleted]) VALUES (3, 5, N'Het is goed zo!', N'Grotere knoppen', 0)
SET IDENTITY_INSERT [dbo].[Surveys] OFF
SET IDENTITY_INSERT [dbo].[Tickets] ON
INSERT [dbo].[Tickets] ([TicketID], [HallMovieID], [Type], [Seat], [Row], [OrderID]) VALUES (1, 2, N'Standaard', 50, 4, 1)
INSERT [dbo].[Tickets] ([TicketID], [HallMovieID], [Type], [Seat], [Row], [OrderID]) VALUES (2, 2, N'Student', 36, 3, 2)
SET IDENTITY_INSERT [dbo].[Tickets] OFF