109 lines
3.5 KiB
Transact-SQL
Vendored
109 lines
3.5 KiB
Transact-SQL
Vendored
USE [MK_IW_MK_Student5]
|
|
GO
|
|
|
|
--The test data that will occupy our database
|
|
|
|
|
|
--test data for User_login
|
|
INSERT INTO User_Login (User_ID_Num, User_Email, User_Password)
|
|
|
|
Values ( NEWID(), 'thisisafake_email@gmail.com', '12345')
|
|
GO
|
|
|
|
INSERT INTO User_Login (User_ID_Num, User_Email, User_Password)
|
|
|
|
Values ( NEWID(), 'theregoodtestdatabraunt@weratedogs.com', 'he*k')
|
|
GO
|
|
|
|
INSERT INTO User_Login (User_ID_Num, User_Email, User_Password)
|
|
|
|
Values ( NEWID(), 'janiceformaccounting@lastweektonight.com', 'shegaveaf*ck')
|
|
GO
|
|
|
|
--Test Data for User_info
|
|
|
|
DECLARE @TempID1 as uniqueidentifier
|
|
|
|
SELECT @TempID1 = User_ID_Num FROM User_Login WHERE User_Email = 'thisisafake_email@gmail.com'
|
|
|
|
INSERT INTO User_Info ( User_Id_Num, User_First_Name, User_Last_Name, User_Phone_Num )
|
|
|
|
VALUES ( @TempID1 , 'Edith', 'Lux' , '1804737856' )
|
|
GO
|
|
|
|
DECLARE @TempID1 as uniqueidentifier
|
|
|
|
SELECT @TempID1 = User_ID_Num FROM User_Login WHERE User_Email = 'theregoodtestdatabraunt@weratedogs.com'
|
|
|
|
INSERT INTO User_Info ( User_Id_Num, User_First_Name, User_Last_Name, User_Phone_Num )
|
|
|
|
VALUES ( @TempID1 , 'Brent', 'Dog' , '1334674456' )
|
|
GO
|
|
|
|
|
|
DECLARE @TempID1 as uniqueidentifier
|
|
|
|
SELECT @TempID1 = User_ID_Num FROM User_Login WHERE User_Email = 'janiceformaccounting@lastweektonight.com'
|
|
|
|
INSERT INTO User_Info ( User_Id_Num, User_First_Name, User_Last_Name, User_Phone_Num )
|
|
|
|
VALUES ( @TempID1 , 'Janice', 'FromAccounting' , '66666666' )
|
|
GO
|
|
|
|
|
|
--Test Data for contact_Info
|
|
|
|
INSERT INTO Contact_Info ( Contact_ID, Contact_First_Name, Coantact_Last_Name, Contact_Email, Contact_Phone_Num )
|
|
|
|
VALUES ( NEWID(), 'Tim', 'Gun', 'timgunemail@email.com', '21566768970')
|
|
|
|
GO
|
|
|
|
|
|
INSERT INTO Contact_Info ( Contact_ID, Contact_First_Name, Coantact_Last_Name, Contact_Email, Contact_Phone_Num )
|
|
|
|
VALUES ( NEWID(), 'Jim', 'Smith', 'jimsmith@email.com', '215646753')
|
|
|
|
GO
|
|
|
|
|
|
INSERT INTO Contact_Info ( Contact_ID, Contact_First_Name, Coantact_Last_Name, Contact_Email, Contact_Phone_Num )
|
|
|
|
VALUES ( NEWID(), 'John', 'Doe', 'cadaver@email.com', '0000000000')
|
|
|
|
GO
|
|
|
|
INSERT INTO Contact_Info ( Contact_ID, Contact_First_Name, Coantact_Last_Name, Contact_Email, Contact_Phone_Num )
|
|
|
|
VALUES ( NEWID(), 'Jane', 'Doe', 'mrs.cadaver@email.com', '1000000001')
|
|
|
|
GO
|
|
|
|
INSERT INTO Contact_Info ( Contact_ID, Contact_First_Name, Coantact_Last_Name, Contact_Email, Contact_Phone_Num )
|
|
|
|
VALUES ( NEWID(), 'Janice', 'FromAccounting', 'janiceformaccounting@lastweektonight.com', '66666666')
|
|
|
|
GO
|
|
|
|
--Contact list test Data
|
|
|
|
DECLARE @TempID1 as uniqueidentifier
|
|
DECLARE @TempID2 as uniqueidentifier
|
|
DECLARE @TempID3 as uniqueidentifier
|
|
DECLARE @TempID4 as uniqueidentifier
|
|
DECLARE @TempID5 as uniqueidentifier
|
|
DECLARE @TempID6 as uniqueidentifier
|
|
|
|
SELECT @TempID1 = User_ID_Num FROM User_Login WHERE User_Email = 'theregoodtestdatabraunt@weratedogs.com'
|
|
SELECT @TempID2 = Contact_ID FROM Contact_Info WHERE Contact_Email = 'janiceformaccounting@lastweektonight.com'
|
|
SELECT @TempID3 = Contact_ID FROM Contact_Info WHERE Contact_Email = 'cadaver@email.com'
|
|
SELECT @TempID4 = Contact_ID FROM Contact_Info WHERE Contact_Email = 'jimsmith@email.com'
|
|
SELECT @TempID5 = Contact_ID FROM Contact_Info WHERE Contact_Email = 'timgunemail@email.com'
|
|
SELECT @TempID6 = Contact_ID FROM Contact_Info WHERE Contact_Email = 'mrs.cadaver@email.com'
|
|
|
|
INSERT INTO Contact_List ( User_ID_Num, Contact_List_ID, Contact_ID_1, Contact_ID_2, Contact_ID_3, Contact_ID_4, Contact_ID_5 )
|
|
|
|
VALUES ( @TempID1, NEWID(), @TempID2, @TempID3, @TempID4, @TempID5, @TempID6 )
|
|
GO
|
|
|