USE cgt4562b



-- DROP user Table --

IF OBJECT_ID('users') IS NOT NULL

  DROP TABLE users;

GO



-- Create users Table Structure --

CREATE TABLE users (

  UserID int IDENTITY(1,1) NOT NULL,

  Username varchar(50) NOT NULL,

  Password varchar(50) NOT NULL,

  FirstName varchar(50) NOT NULL,

  LastName varchar(50) NOT NULL,

  Email varchar(50) NOT NULL,

  Image varchar(50) NOT NULL,

  PRIMARY KEY (UserID)

)



-- INSERT USERS --

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('gwindes', 'B081DBE85E1EC3FFC3D4E7D0227400CD', 'Grant', 'Windes', 'gwindes@gmail.com', 'gwindes.png')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('gambino', 'B081DBE85E1EC3FFC3D4E7D0227400CD', 'Childish', 'Gambino', 'gambino@gmail.com', 'gambino.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('dpudi', 'ECF28337B0C54CE830C84740FC8D06EC', 'Abed', 'Nadir', 'abed@gmail.com', 'dpudi.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('eksmith', 'ECF28337B0C54CE830C84740FC8D06EC', 'Emma', 'Smith', 'esmith@purdue.edu', 'eksmith.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('brianfu', 'ECF28337B0C54CE830C84740FC8D06EC', 'Abed', 'Nadir', 'abed@gmail.com', 'brianfu.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('mwilson', 'ECF28337B0C54CE830C84740FC8D06EC', 'Matthew', 'Wilson', 'mwilson@purdue.edu', 'mwilson.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('purduepete', '95A29080EC07F2149C417206DD0A0271', 'Purdue', 'Pete', 'purduepete@gmail.com', 'purduepete.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('rjglotzbach', 'ECF28337B0C54CE830C84740FC8D06EC', 'Ronald', 'Glotzbach', 'rjglotzbach@purdue.edu', 'rjglotzbach.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('petdetective', '33022456AFA49952B460CD741D6AB8F5', 'Ace', 'Ventura (Pet Detective)', 'pets@gmail.com', 'petdetective.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('trent', '33022456AFA49952B460CD741D6AB8F5', 'Trent', 'Windes', 'tdizzle@gmail.com', 'trent.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('mikeW', 'C84DA545D20C59C141D03AB811BE34E9', 'Mike', 'Windes', 'snob@usc.edu', 'mikeW.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('timhoward', 'C5B5C220E3C0406171A27340AD00A118', 'Tim', 'Howard', 'pets@gmail.com', 'timhoward.jpeg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('rodgers', 'D25223BE694E4E62AD97D82CF86EFCA1', 'Aaron', 'Rodgers', 'pets@gmail.com', 'rodgers.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('favre', 'D25223BE694E4E62AD97D82CF86EFCA1', 'Brett', 'Favre', 'pets@gmail.com', 'favre.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('billmurray', '33022456AFA49952B460CD741D6AB8F5', 'Bill', 'Murray', 'pets@gmail.com', 'billmurray.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('sentry', 'B081DBE85E1EC3FFC3D4E7D0227400CD', 'Baby', 'Sentry', 'pets@gmail.com', 'sentry.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('cube', '33022456AFA49952B460CD741D6AB8F5', 'Companion', 'Cube', 'pets@gmail.com', 'cube.png')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('kyle', 'AC47AAC0D8F293A2D04183D250ED1227', 'Kyle', 'Bowen', 'pets@gmail.com', 'kyle.jpg')

INSERT INTO users (Username, Password, FirstName, LastName, Email, Image)

VALUES ('robot', 'AC47AAC0D8F293A2D04183D250ED1227', 'Robot', 'Skleton', 'robot@gmail.com', 'robot.gif')