API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 7th, 2019
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.05 KB | None | 0 0
raw download clone embed print report
  1. /* MAINTENANCE */
  2. INSERT INTO [dbo].[MaintenanceStatus]
  3. ([MaintenanceStatusID],[Description])
  4. VALUES
  5. ("Complete","Completed"),
  6. ("Working","In the process of being completed"),
  7. ("Waiting","Waiting to be started")
  8. Go
  9.  
  10. INSERT INTO [dbo].[MaintenanceType]
  11. ([MaintenanceTypeID],[Description],[Active])
  12. VALUES
  13. ("Repair","Something needs to be repaired",1),
  14. ("Replace","Something needs to be replaced",1),
  15. ("Install","Something needs to be installed",1),
  16. ("Remove","Something needs to be removed",1)
  17. GO
  18.  
  19. INSERT INTO [dbo].[MaintenanceWorkOrder]
  20. ([MaintenanceTypeID],[DateRequested],[DateCompleted],[RequestingEmployeeID],[WorkingEmployeeID],[Complete],[Description],[Comments],[MaintenanceStatus],[ResortPropertyID])
  21. VALUES
  22. ("Repair","2018-10-10",NULL,100000, {maintenance dude},0,"The toilet is leaking",NULL,"Waiting",{ResortPropertyID}),
  23. ("Replace","2018-01-10",NULL,100001,{maintenance dude},0,"Faucet needs to be replaced",NULL,"Waiting",{ResortPropertyID}),
  24. ("Install","2019-10-05",NULL,100000,{maintenance dude},0,"Ceiling fan is needed",NULL,"Waiting",{ResortPropertyID}),
  25. ("Repair","2018-10-10",NULL,100000, {maintenance dude},0,"Rug has a frayed end",NULL,"Waiting",{ResortPropertyID}),
  26. ("Repair","2018-10-10",NULL,100001, {maintenance dude},0,"Mini Bar is not cold",NULL,"Waiting",{ResortPropertyID}),
  27. ("Remove","2018-10-10",NULL,100002, {maintenance dude},0,"Extra towel rack in bathroom",NULL,"Waiting",{ResortPropertyID}),
  28. ("Install","2018-10-10",NULL,100004,{maintenance dude},0,"New air filter",NULL,"Waiting",{ResortPropertyID}),
  29. ("Repair","2018-10-10",NULL,100000, {maintenance dude},0,"Window is not sealing fully",NULL,"Waiting",{ResortPropertyID})
  30. GO
  31.  
  32. /* INSPECTION */
  33. INSERT INTO [dbo].[Inspection]
  34. ([ResortPropertyID], [Name], [DateInspected], [Rating],
  35. [ResortInspectionAffiliation], [InspectionProblemNotes], [InspectionFixNotes])
  36. VALUES
  37. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  38. "", "", ""),
  39. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  40. "", "", ""),
  41. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  42. "", "", ""),
  43. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  44. "", "", ""),
  45. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  46. "", "", ""),
  47. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  48. "", "", ""),
  49. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  50. "", "", ""),
  51. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  52. "", "", ""),
  53. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  54. "", "", ""),
  55. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  56. "", "", ""),
  57. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  58. "", "", ""),
  59. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  60. "", "", ""),
  61. ({ResortPropertyID}, 'Sprinker Systems' ,'2018-01-01', 'Pass',
  62. "", "", ""),
  63. ({ResortPropertyID}, 'Elevator' ,'2018-08-12', 'Pass',
  64. "", "", "")
  65. GO
  66.  
  67. /* Events */
  68. Concert
  69. Party
  70. Trade Show
  71. Competition
  72. Wedding
  73.  
  74.  
  75. INSERT INTO [Event]
  76. (
  77. [OfferingID],[EventTypeID], [EventStartDate],
  78. [NumGuests], [SeatsRemaining], [PublicEvent], [Description], [KidsAllowed],
  79. [Location], [EventEndDate],
  80. [EventTitle], [Sponsored], [EmployeeID], [Approved], [Cancelled]
  81. )
  82. VALUES
  83. ({OfferingID}, "Party", CURRENT_TIMESTAMP,
  84. 40, 30, 1, "Fire dancing with turtles!", 1,
  85. "On the beach by Frank's nasty shack.", CURRENT_TIMESTAMP,
  86. "FIRE DANCING WITH TURTLES OF DOOM", 0, 100000, 1, 0),
  87.  
  88. ({OfferingID}, "Party", CURRENT_TIMESTAMP,
  89. 40, 30, 1, "Splash and drink and play with foam launchers", 1,
  90. "Main Pool", CURRENT_TIMESTAMP,
  91. "Foam Pool Party", 0, 100000, 1, 0),
  92.  
  93. ({OfferingID}, "Trade Show", CURRENT_TIMESTAMP,
  94. 40, 30, 1, "Comedic Event ", 1,
  95. "Main Ballroom", CURRENT_TIMESTAMP,
  96. "John Mulaney", 0, 100000, 1, 0),
  97.  
  98. ({OfferingID}, "Trade Show", CURRENT_TIMESTAMP,
  99. 40, 30, 1, "Penn and Teller", 1,
  100. "Beach Front Patio", CURRENT_TIMESTAMP,
  101. "Penn and Teller's Famous Magic Show", 0, 100000, 1, 0),
  102.  
  103. ({OfferingID}, "Wedding", "20190606 10:00:00 AM",
  104. 100, 20, 0, "Bob and Jim's Wedding", 1,
  105. "Main Ballroom", "20190606 10:00:00 PM",
  106. "Bob and Jim's Wedding", 0, 100000, 1, 0)
  107. GO
  108.  
  109. /* Sponsor */
  110. INSERT INTO [dbo].[Sponsor]
  111. ([SponsorID],[Name],[Address],[City],[State],[PhoneNumber],[Email],[ContactFirstName],[ContactLastName],[DateAdded],[Active])
  112. VALUES
  113. (100000,"We are happy to Help!","601 Circle St.","Cedar Rapids","IA","13195548876","val@here.com","Val","Walmsley","2019-01-01",1),
  114. (100001,"Coca Cola","559 Riverview Dr.","Fuquay","NC","13191254876","tansy@here.com","Tansy","White","2019-01-01",1),
  115. (100002,"Twitch","754 Fawn Ct.","Harrisonburg","VA","13195548876","rene@here.com","Rene","Spence","2019-01-01",1),
  116. (100003,"Kars4Kids","343 Maple Ave","Santa Clara","CA","13195548876","lucile@here.com","Lucile","Atteberry","2019-01-01",1),
  117. (100004,"Joe Biden","908 Pierce St","Marietta","GA","13195548876","joe@here.com","Joe","Biden","2019-01-01",1),
  118. (100005,"AMC","88 Mayfair Rd.","Champlin","MN","13195548876","honour@here.com","Honour","Constable","2019-01-01",1)
  119. GO
  120.  
  121.  
  122. /* EventSponsor */
  123. INSERT INTO [dbo].[EventSponsor]
  124. ([EventID],[SponsorID])
  125. VALUES
  126. (100000,100000),
  127. (100002, 100001),
  128. (100004, 100004)
  129. GO
  130.  
  131. /* Setup and Setup List */
  132. INSERT INTO [dbo].[Setup]
  133. ([EventID],[DateEntered],[DateRequired],[Comments])
  134. VALUES
  135. (100000,'2019-05-06',CURRENT_TIMESTAMP,'Please do this quickly'),
  136. (100001,'2019-05-06',CURRENT_TIMESTAMP, ''),
  137. (100002,'2019-05-06',CURRENT_TIMESTAMP,'Requires extensive remodeling'),
  138. (100003,'2019-05-06',CURRENT_TIMESTAMP,'Use the forklift')
  139. GO
  140.  
  141. INSERT INTO [dbo].[SetupList]
  142. ([SetupID], [Completed], [Description], [Comments])
  143. VALUES
  144. (100000, 0, ' Prior to Guest Arrival: Registration Desk,signs,banners', 'Banners are not ready yet'),
  145. (100001, 0, ' Display Equipment: Prepares for display boards,tables,chairs,, printed material and names badges','Badges are not ready yet'),
  146. (100002, 1, ' Check Av Equipment: Laptop,projectors :Ensure all cables,leads,laptop,mic and mouse are presented and working', 'Av Equipment is ready'),
  147. (100002, 1, ' Walk through to make sure bathrooms are clean and stocked ', 'Bathrooms are ready'),
  148. (100003, 1, ' Confirm that all decor and linen is in place ', 'Decor and linen are ready')
  149.  
  150. GO
  151.  
  152. /* Performance */
  153. INSERT INTO [dbo].[Performance]
  154. ([PerformanceTitle], [PerformanceDate], [Description],[Cancelled])
  155. VALUES
  156. ('Juggler', '2018-6-27', 'It is a juggler, not much else to say',0),
  157. ('Firebreather', '2018-5-15', 'This one is for Matt LaMarche',0),
  158. ('Sword Swallower', '2018-6-27', 'Try not to cringe',0),
  159. ('Magician', '2018-6-20', 'Come be amazed by magic',0),
  160. ('Michael Jackson', '2018-6-17', 'His hologram will be preforming hit songs by the iconic Michael',0),
  161. ('John Moleny', '2018-6-7', 'You will laugh at this comedic act.',0),
  162. ('Blue Man Group', '2018-6-4', 'World Famous Blue Man Group is coming. You will not want to miss out!',0),
  163. ('Lion King', '2018-5-30', 'Come watch the broadway performance known the world over.',0)
  164. GO
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!