fake_data_borrowers.sql

INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'123456',
	'Maria Piao',
	'1234 Main Street, Vancouver, BC V1B3R8',
	'6041231212',
	'piao.maria@gmail.com',
	'12913075',
	'2014-02-13',
	'stu'
);

INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'YOLOSWAG',
	'Redmond Tran',
	'5678 First Avenue, Vancouver, BC V2A3T8',
	'6047892313',
	'redmond.tran@gmail.com',
	'32453103',
	'2016-08-31',
	'stu'
);

INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'kaur',
	'Takdeer Jawanda',
	'90-4331 Oak Street, Vancouver, BC V6F4F3',
	'7781323011',
	'takdeerkaur@gmail.com',
	'12345678',
	'2016-04-20',
	'sta'
);


INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'jae-hwan',
	'Jeff Jung',
	'4421 Park Drive, Vancouver, BC V3D9R1',
	'7781214434',
	'midlife83@gmail.com',
	'09876543',
	'2015-10-10',
	'fal'
);


INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'password',
	'John Doe',
	'4243 Nowhere Plaza, Vancouver, BC V1C8Y2',
	'7789723543',
	'testing@test.com',
	'123242113',
	'2013-09-01',
	'stu'
);

INSERT INTO Borrower VALUES(
	bid_counter.nextVal,
	'blah',
	'Expired User',
	'meow',
	'7789723543',
	'testing@test.com',
	'753453333',
	'2012-03-29',
	'stu'
);