Staniell

Untitled

Jan 19th, 2021
1,925
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [Test2]/**your db name**/
  2. GO
  3. /****** Object:  Table [dbo].[class_activities]    Script Date: 1/20/2021 1:52:38 AM ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. CREATE TABLE [dbo].[class_activities](
  9.     [activity_id] [NCHAR](10) NULL,
  10.     [activity_name] [nvarchar](50) NULL
  11. ) ON [PRIMARY]
  12. GO
  13. /****** Object:  Table [dbo].[scores]    Script Date: 1/20/2021 1:52:38 AM ******/
  14. SET ANSI_NULLS ON
  15. GO
  16. SET QUOTED_IDENTIFIER ON
  17. GO
  18. CREATE TABLE [dbo].[scores](
  19.     [activity_id] [NCHAR](10) NULL,
  20.     [student_id] [NCHAR](10) NULL,
  21.     [activity_score] [INT] NULL
  22. ) ON [PRIMARY]
  23. GO
  24. /****** Object:  Table [dbo].[users]    Script Date: 1/20/2021 1:52:38 AM ******/
  25. SET ANSI_NULLS ON
  26. GO
  27. SET QUOTED_IDENTIFIER ON
  28. GO
  29. CREATE TABLE [dbo].[users](
  30.     [user_id] [NCHAR](10) NULL,
  31.     [username] [NCHAR](10) NULL,
  32.     [password] [NCHAR](10) NULL,
  33.     [user_type] [NCHAR](10) NULL
  34. ) ON [PRIMARY]
  35. GO
  36. INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'1         ', N'Oral Spanish')
  37. GO
  38. INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'2         ', N'Oral English')
  39. GO
  40. INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'3         ', N'Written Espanyol')
  41. GO
  42. INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'4         ', N'Integral Exercise')
  43. GO
  44. INSERT [dbo].[class_activities] ([activity_id], [activity_name]) VALUES (N'5         ', N'Oral French')
  45. GO
  46. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'1         ', N'3         ', 28)
  47. GO
  48. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'2         ', N'3         ', 28)
  49. GO
  50. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'2         ', N'2         ', 30)
  51. GO
  52. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'3         ', N'3         ', 40)
  53. GO
  54. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'4         ', N'3         ', 40)
  55. GO
  56. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'4         ', N'2         ', 28)
  57. GO
  58. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'2         ', 28)
  59. GO
  60. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'3         ', 20)
  61. GO
  62. INSERT [dbo].[scores] ([activity_id], [student_id], [activity_score]) VALUES (N'5         ', N'4         ', 25)
  63. GO
  64. INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'1         ', N'villavon  ', N'12345     ', N'Teacher   ')
  65. GO
  66. INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'2         ', N'warlow    ', N'undercover', N'Student   ')
  67. GO
  68. INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'3         ', N'bbdantsy  ', N'killer69  ', N'Student   ')
  69. GO
  70. INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'4         ', N'king56    ', N'55tuna55  ', N'Student   ')
  71. GO
  72. INSERT [dbo].[users] ([user_id], [username], [password], [user_type]) VALUES (N'5         ', N'spiderman ', N'xxtenasyon', N'Student   ')
  73. GO
  74.  
RAW Paste Data