summaryrefslogtreecommitdiff
path: root/vendor/plugins/thinking-sphinx/spec/fixtures/data.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/plugins/thinking-sphinx/spec/fixtures/data.sql')
-rw-r--r--vendor/plugins/thinking-sphinx/spec/fixtures/data.sql32
1 files changed, 32 insertions, 0 deletions
diff --git a/vendor/plugins/thinking-sphinx/spec/fixtures/data.sql b/vendor/plugins/thinking-sphinx/spec/fixtures/data.sql
new file mode 100644
index 0000000..d5ec579
--- /dev/null
+++ b/vendor/plugins/thinking-sphinx/spec/fixtures/data.sql
@@ -0,0 +1,32 @@
1insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Ellie','K','Ford','38 Mills Street','Eagle Farm Bc','QLD','4009','Ellie.K.Ford@mailinator.com','1970/1/23 00:00:00', 3, 'CricketTeam');
2insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Aaliyah','E','Allen','71 Murphy Street','Wyola West','WA','6407','Aaliyah.E.Allen@dodgit.com','1980/3/23 00:00:00', 3, 'CricketTeam');
3insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('male','Callum','C','Miah','89 Dalgarno Street','Bullawa Creek','NSW','2390','Callum.C.Miah@trashymail.com','1973/3/25 00:00:00', 3, 'CricketTeam');
4insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('male','Finley','L','Buckley','18 Queen Street','Manly Vale','NSW','2093','Finley.L.Buckley@spambob.com','1962/11/20 00:00:00', 3, 'CricketTeam');
5insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Poppy','A','Hilton','36 Nerrigundah Drive','Nyora','VIC','3987','Poppy.A.Hilton@dodgit.com','1972/10/30 00:00:00', 3, 'CricketTeam');
6insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Eloise','Z','Kennedy','18 Mt Berryman Road','Lilydale','QLD','4344','Eloise.Z.Kennedy@spambob.com','1973/9/28 00:00:00', 3, 'CricketTeam');
7insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Shannon','L','Manning','60 Ocean Pde','Greenvale','QLD','4816','Shannon.L.Manning@dodgit.com','1956/6/13 00:00:00', 3, 'CricketTeam');
8insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('male','Oscar','C','Lawson','43 Feather Street','Battery Hill','QLD','4551','Oscar.C.Lawson@spambob.com','1979/10/17 00:00:00', 3, 'CricketTeam');
9insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('female','Sofia','K','Bray','26 Clifton Street','Pental Island','VIC','3586','Sofia.K.Bray@mailinator.com','1970/5/10 00:00:00', 3, 'CricketTeam');
10insert into `people` (gender, first_name, middle_initial, last_name, street_address, city, state, postcode, email, birthday, team_id, team_type) values('male','Andrew','N','Byrne','35 Cecil Street','Monash Park','NSW','2111','Andrew.N.Byrne@spambob.com','1983/2/16 00:00:00', 3, 'CricketTeam');
11
12insert into `alphas` (name) values ('one');
13insert into `alphas` (name) values ('two');
14insert into `alphas` (name) values ('three');
15insert into `alphas` (name) values ('four');
16insert into `alphas` (name) values ('five');
17insert into `alphas` (name) values ('six');
18insert into `alphas` (name) values ('seven');
19insert into `alphas` (name) values ('eight');
20insert into `alphas` (name) values ('nine');
21insert into `alphas` (name) values ('ten');
22
23insert into `betas` (name) values ('one');
24insert into `betas` (name) values ('two');
25insert into `betas` (name) values ('three');
26insert into `betas` (name) values ('four');
27insert into `betas` (name) values ('five');
28insert into `betas` (name) values ('six');
29insert into `betas` (name) values ('seven');
30insert into `betas` (name) values ('eight');
31insert into `betas` (name) values ('nine');
32insert into `betas` (name) values ('ten');