Mercurial > ~darius > hgwebdir.cgi > SCS_DB
diff test_data.sql @ 1:d95e74cd12f4 RELENG_1_0
Initial commit
author | darius |
---|---|
date | Wed, 06 May 1998 14:33:31 +0000 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test_data.sql Wed May 06 14:33:31 1998 +0000 @@ -0,0 +1,10 @@ +insert into members values (nextval('member_id'), 'Daniel', 'O\'Connor', 'Darius', '1234', 21, '+61414835247', 'yes', '+61882972544', 'yes', 'darius@dons.net.au', 'yes', '34 Hill Ave', 'Cumberland Park', 'SA 5041', 'yes', 'SCS President', '1998-04-29', '3.00', '1998-04-29'); + +insert into members values (nextval('member_id'), 'Joe', 'Bloggs', +'Gryphen', '5678', 23, '+12345566', 'yes', '+9982312', 'no', +'joe@foo.net', 'yes', '18 Flibble St', 'Flub Park', 'XYZ 9999', 'no', 'Pleb', '1998-04-29', '2.00', '1998-04-29'); + +insert into events values (nextval('event_id'), 'Games Party', 'Come along to Anchor court at Flinders University and play network games\nsuch as Quake 2, Star Craft, and Total Anihiliation', '1998-05-30 13:00', '16 hours', '$5 for members, $8 for non-members', 'Daniel O\'Connor - darius@dons.net.au, 0414 835 247'); + +insert into mem_ev_lnk values (1, 1, 'yes'); +insert into mem_ev_lnk values (2, 1, 'no'); \ No newline at end of file