CREATE TABLE [dbo].[Users](
		[UID] [int] IDENTITY(1,1) NOT NULL CONSTRAINT UPKCL_UID PRIMARY KEY CLUSTERED,
		[Fname] [varchar](256) NOT NULL,
		[Lname] [varchar](256) NOT NULL,
		[Email] [varchar](256) NOT NULL,
		[EmpID] [int] NOT NULL,
		[EmpDep] [int] NOT NULL
	)
	
	CREATE TABLE [dbo].[Login](
		[UID] [int] NOT NULL,
		[UsrN] [varchar](256) NOT NULL,
		[Pswd] [varchar](256) NOT NULL,
		[Ulevel] [bit] NOT NULL DEFAULT((0)),
		[Ltype] [bit] NOT NULL DEFAULT((0)),
		[FIP] [varchar](16) NOT NULL,
		[LIP] [varchar](16) NOT NULL,
		[Llog] [datetime] NOT NULL
	)
	
	GO
	ALTER TABLE [dbo].[Login]  WITH CHECK ADD FOREIGN KEY([UID])
	REFERENCES [dbo].[Users] ([UID])
	GO
	
	CREATE TABLE [dbo].[Tests](
		[TID] [int] IDENTITY(1,1) NOT NULL CONSTRAINT UPKCL_TID PRIMARY KEY CLUSTERED,
		[Ttitle] [varchar](1024) NOT NULL
	)
	
	CREATE TABLE [dbo].[Questions](
		[QID] [int] IDENTITY(1,1) NOT NULL CONSTRAINT UPKCL_QID PRIMARY KEY CLUSTERED,
		[TID] [int] NOT NULL,
		[Qtitle] [varchar](1024) NOT NULL
	)
	
	GO
	ALTER TABLE [dbo].[Questions]  WITH CHECK ADD FOREIGN KEY([TID])
	REFERENCES [dbo].[Tests] ([TID])
	GO
	
	CREATE TABLE [dbo].[QuestionsOpt](
		[QID] [int] NULL,
		[Qop1] [varchar](1024) NOT NULL,
		[Qop2] [varchar](1024) NOT NULL,
		[Qop3] [varchar](1024) NOT NULL,
		[Qop4] [varchar](1024) NOT NULL,
		[Qop5] [varchar](1024) NOT NULL,
		[Qop6] [varchar](1024) NOT NULL,
		[Qop7] [varchar](1024) NOT NULL,
		[Qop8] [varchar](1024) NOT NULL,
		[Qop9] [varchar](1024) NOT NULL,
		[Qop10] [varchar](1024) NOT NULL
	)
	
	GO
	ALTER TABLE [dbo].[QuestionOpt]  WITH CHECK ADD FOREIGN KEY([QID])
	REFERENCES [dbo].[Questions] ([QID])
	GO
	
	CREATE TABLE [dbo].[Responses](
		[UID] [int] NULL,
		[QID] [int] NULL,
		[Ransw] [varchar](1024) NOT NULL
	)

	GO
	ALTER TABLE [dbo].[Responses]  WITH CHECK ADD FOREIGN KEY([QID])
	REFERENCES [dbo].[Questions] ([QID])
	GO
	ALTER TABLE [dbo].[Responses]  WITH CHECK ADD FOREIGN KEY([UID])
	REFERENCES [dbo].[Users] ([UID])
	GO