Mercurial > ~darius > hgwebdir.cgi > SCS_DB

annotate test_data.sql @ 2:791e87929f83 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added tag RELENG_1_0 for changeset d95e74cd12f4
author darius@midget.dons.net.au
date Tue, 23 Oct 2007 10:07:21 +0930
parents d95e74cd12f4
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
1 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');
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
2
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
3 insert into members values (nextval('member_id'), 'Joe', 'Bloggs',
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
4 'Gryphen', '5678', 23, '+12345566', 'yes', '+9982312', 'no',
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
5 'joe@foo.net', 'yes', '18 Flibble St', 'Flub Park', 'XYZ 9999', 'no', 'Pleb', '1998-04-29', '2.00', '1998-04-29');
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
6
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
7 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');
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
8
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
9 insert into mem_ev_lnk values (1, 1, 'yes');
d95e74cd12f4 Initial commit
darius
parents:
diff changeset
10 insert into mem_ev_lnk values (2, 1, 'no');