1. USE [Tobeto]
2. GO
3. /****** Object:  Table [dbo].[Classes]    Script Date: 12.12.2023 00:05:38 ******/
4. SET ANSI_NULLS ON
5. GO
6. SET QUOTED_IDENTIFIER ON
7. GO
8. CREATE TABLE [dbo].[Classes](
9.  [Id] [int] IDENTITY(1,1) NOT NULL,
10.  [Name] [nvarchar](50) NOT NULL,
11.  [Classroom] [nvarchar](50) NOT NULL,
12.  [CreatedDate] [datetime] NOT NULL,
13.  [UpdatedDate] [datetime] NULL,
14.  [DeletedDate] [datetime] NULL,
15.  CONSTRAINT [PK_Classes] PRIMARY KEY CLUSTERED
16. (
17.  [Id] ASC
18. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
19. ) ON [PRIMARY]
20. GO
21. /****** Object:  Table [dbo].[Courses]    Script Date: 12.12.2023 00:05:38 ******/
22. SET ANSI_NULLS ON
23. GO
24. SET QUOTED_IDENTIFIER ON
25. GO
26. CREATE TABLE [dbo].[Courses](
27.  [Id] [int] IDENTITY(1,1) NOT NULL,
28.  [Img_Id] [int] NOT NULL,
29.  [Name] [nvarchar](50) NOT NULL,
30.  [StartedDate] [datetime] NOT NULL,
31.  [CreatedDate] [datetime] NOT NULL,
32.  [UpdatedDate] [datetime] NULL,
33.  [DeletedDate] [datetime] NULL,
34.  CONSTRAINT [PK_Courses] PRIMARY KEY CLUSTERED
35. (
36.  [Id] ASC
37. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
38. ) ON [PRIMARY]
39. GO
40. /****** Object:  Table [dbo].[Images]    Script Date: 12.12.2023 00:05:38 ******/
41. SET ANSI_NULLS ON
42. GO
43. SET QUOTED_IDENTIFIER ON
44. GO
45. CREATE TABLE [dbo].[Images](
46.  [Id] [int] IDENTITY(1,1) NOT NULL,
47.  [Path] [nvarchar](max) NOT NULL,
48.  [CreatedDate] [datetime] NOT NULL,
49.  [DeletedDate] [datetime] NULL,
50.  [UpdatedDate] [datetime] NULL,
51.  CONSTRAINT [PK_Images] PRIMARY KEY CLUSTERED
52. (
53.  [Id] ASC
54. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
55. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
56. GO
57. /****** Object:  Table [dbo].[Instructors]    Script Date: 12.12.2023 00:05:38 ******/
58. SET ANSI_NULLS ON
59. GO
60. SET QUOTED_IDENTIFIER ON
61. GO
62. CREATE TABLE [dbo].[Instructors](
63.  [Id] [int] IDENTITY(1,1) NOT NULL,
64.  [UserId] [int] NOT NULL,
65.  [CourseId] [int] NOT NULL,
66.  [CreatedDate] [datetime] NOT NULL,
67.  [UpdatedDate] [datetime] NULL,
68.  [DeletedDate] [datetime] NULL,
69.  CONSTRAINT [PK_Instructors] PRIMARY KEY CLUSTERED
70. (
71.  [Id] ASC
72. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
73. ) ON [PRIMARY]
74. GO
75. /****** Object:  Table [dbo].[Lessons]    Script Date: 12.12.2023 00:05:38 ******/
76. SET ANSI_NULLS ON
77. GO
78. SET QUOTED_IDENTIFIER ON
79. GO
80. CREATE TABLE [dbo].[Lessons](
81.  [Id] [int] IDENTITY(1,1) NOT NULL,
82.  [ClassId] [int] NOT NULL,
83.  [CourseId] [int] NOT NULL,
84.  [CreatedDate] [datetime] NOT NULL,
85.  [DeletedDate] [datetime] NULL,
86.  [UpdatedDate] [datetime] NULL,
87.  CONSTRAINT [PK_Lessons] PRIMARY KEY CLUSTERED
88. (
89.  [Id] ASC
90. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
91. ) ON [PRIMARY]
92. GO
93. /****** Object:  Table [dbo].[Roles]    Script Date: 12.12.2023 00:05:38 ******/
94. SET ANSI_NULLS ON
95. GO
96. SET QUOTED_IDENTIFIER ON
97. GO
98. CREATE TABLE [dbo].[Roles](
99.  [Id] [int] IDENTITY(1,1) NOT NULL,
100.  [Name] [nvarchar](max) NOT NULL,
101.  [CreatedDate] [datetime] NOT NULL,
102.  [UpdatedDate] [datetime] NULL,
103.  [DeletedDate] [datetime] NULL,
104.  CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED
105. (
106.  [Id] ASC
107. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
108. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
109. GO
110. /****** Object:  Table [dbo].[Students]    Script Date: 12.12.2023 00:05:38 ******/
111. SET ANSI_NULLS ON
112. GO
113. SET QUOTED_IDENTIFIER ON
114. GO
115. CREATE TABLE [dbo].[Students](
116.  [Id] [int] IDENTITY(1,1) NOT NULL,
117.  [UserId] [int] NOT NULL,
118.  [ClassId] [int] NOT NULL,
119.  [CreatedDate] [datetime] NOT NULL,
120.  [DeletedDate] [datetime] NULL,
121.  [UpdatedDate] [datetime] NULL,
122.  CONSTRAINT [PK_Students] PRIMARY KEY CLUSTERED
123. (
124.  [Id] ASC
125. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
126. ) ON [PRIMARY]
127. GO
128. /****** Object:  Table [dbo].[Users]    Script Date: 12.12.2023 00:05:38 ******/
129. SET ANSI_NULLS ON
130. GO
131. SET QUOTED_IDENTIFIER ON
132. GO
133. CREATE TABLE [dbo].[Users](
134.  [Id] [int] IDENTITY(1,1) NOT NULL,
135.  [RoleId] [int] NOT NULL,
136.  [FirstName] [nvarchar](50) NOT NULL,
137.  [LastName] [nvarchar](50) NOT NULL,
138.  [Email] [nvarchar](50) NOT NULL,
139.  [CreatedDate] [datetime] NOT NULL,
140.  [UpdatedDate] [datetime] NULL,
141.  [DeletedDate] [datetime] NULL,
142.  CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
143. (
144.  [Id] ASC
145. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
146. ) ON [PRIMARY]
147. GO
148.