------------- Checking for existing user  ----------------
SELECT UID FROM UserAccounts WHERE Uname = 'rcompton@contactpoint.com.au'
------------- New User Account Creation on 2009-11-24 ----------------
INSERT INTO UserAccounts (Type, Uname, Pwd, PWDQuestion, PWDQAnswer, DateCreated) VALUES (1,'rcompton@contactpoint.com.au','password','boss','heather','2009-11-24')
------------- New User ID 1 ----------------
INSERT INTO UserDetails (UID, Firstname, Initial, Surname, Phonenumber, Mobile, AlternativeEmailAddress,BillingAddressLine1, BillingAddressLine2, BASuburb, BAState, BAPostcode, BACountry,ShippingAddressLine1, ShippingAddressLine2, SASuburb, SAState, SAPostcode, SACountry,DirectMailOptIn) VALUES (1,'Robert','','Compton','03 5555 5555','','','PO Box 89','','Gordon','VIC','3345','Australia','','','','','','',0)
------------- Checking for existing user  ----------------
SELECT UID FROM UserAccounts WHERE Uname = 'hmaloney@contactpoint.com.au'
------------- Checking for existing user  ----------------
SELECT UID FROM UserAccounts WHERE Uname = 'hmaloney@contactpoint.com.au'
------------- New User Account Creation on 2009-11-26 ----------------
INSERT INTO UserAccounts (Type, Uname, Pwd, PWDQuestion, PWDQAnswer, DateCreated) VALUES (1,'hmaloney@contactpoint.com.au','password','what is my mother\'s maiden name?','Woodhouse','2009-11-26')
------------- New User ID 3 ----------------
INSERT INTO UserDetails (UID, Firstname, Initial, Surname, Phonenumber, Mobile, AlternativeEmailAddress,BillingAddressLine1, BillingAddressLine2, BASuburb, BAState, BAPostcode, BACountry,ShippingAddressLine1, ShippingAddressLine2, SASuburb, SAState, SAPostcode, SACountry,DirectMailOptIn) VALUES (3,'Heather','','Maloney','03 8525 2082','','','PO Box 89','','Gordon','VIC','3345','Australia','','','','','','',0)