Skip to content

Instantly share code, notes, and snippets.

@gnu-user

gnu-user/gist:5691987

Created June 1, 2013 22:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gnu-user/5691987 to your computer and use it in GitHub Desktop.
Save gnu-user/5691987 to your computer and use it in GitHub Desktop.
Download ZIP
Add 10 test accounts for testing the elections website
Raw
gistfile1.sql
INSERT INTO ucsc_members VALUES ('Bobby', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test1', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-01-23', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Timmy', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test2', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2013-01-23', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Jimmy', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test3', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2013-01-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Harry', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test4', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2013-01-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Larry', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test5', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Fairy', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test6', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Mary', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test7', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Terry', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test8', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Jerry', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test9', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
INSERT INTO ucsc_members VALUES ('Barry', 'Tables', AES_ENCRYPT('100123456', 'test123'), 'test@gmail.com', 'test10', AES_ENCRYPT('DEADBEEFtest123', 'test123'), NULL, '2012-05-03', CURDATE(), TRUE);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment