forked from nDmitry/web-benchmarks
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinit.sql
executable file
·230 lines (229 loc) · 13.8 KB
/
init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
CREATE TABLE public."user" (
id SERIAL PRIMARY KEY,
username VARCHAR NOT NULL,
name VARCHAR NOT NULL,
sex VARCHAR NOT NULL,
address VARCHAR NOT NULL,
mail VARCHAR NOT NULL,
birthdate TIMESTAMP NOT NULL
);
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('erica81','Donald Walker','M','38908 Debra Neck
New Lisatown, OH 45098','[email protected]','1956-01-09 00:00:00.000')
,('amanda61','Lindsey Roman','F','5931 Jeremy Glens Apt. 316
New Michael, GA 35494','[email protected]','1977-01-04 00:00:00.000')
,('angela50','James Mayo','M','41395 Victor Tunnel
Douglasland, NE 98413','[email protected]','1923-02-21 00:00:00.000')
,('laura69','Anthony Rodriguez','M','848 Smith Roads
Amandaburgh, CO 57486','[email protected]','1972-06-11 00:00:00.000')
,('kromero','Brian Garrett','M','809 Andrew Viaduct
Deckerburgh, UT 10823','[email protected]','2008-07-17 00:00:00.000')
,('catherine38','Theresa Martin','F','657 Hayes Forge Apt. 098
East Chadstad, VA 43810','[email protected]','1922-04-28 00:00:00.000')
,('richarddavis','Kenneth Sanchez','M','0106 Mcbride Court
South Donaldville, UT 10381','[email protected]','1977-11-20 00:00:00.000')
,('jasonmorales','Dr. Samuel Martin','M','474 Susan Well
Jenniferland, WI 76415','[email protected]','1969-03-16 00:00:00.000')
,('lopezbrooke','Christopher Yu','M','93990 Barnes Passage
Sarahville, ID 52377','[email protected]','1914-03-10 00:00:00.000')
,('william25','Kristine Garcia','F','2784 Archer Ports Apt. 841
Taylorland, NV 36198','[email protected]','1940-03-29 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('maria00','Terry Williams','M','278 Hoffman Courts
Vazquezland, LA 72921','[email protected]','2012-08-31 00:00:00.000')
,('michael86','Hunter Fleming','M','Unit 2322 Box 6025
DPO AP 54465','[email protected]','2011-06-23 00:00:00.000')
,('sellersmichael','Andrew Ruiz','M','36541 Ramirez Port Apt. 850
Port Gregoryshire, CO 57460','[email protected]','1920-01-20 00:00:00.000')
,('frostamanda','Dawn Fletcher','F','561 Mccall Plaza Suite 148
West Richard, CT 55609','[email protected]','1959-08-01 00:00:00.000')
,('diana77','Dustin Jordan','M','2148 Harvey Corner
Youngburgh, DE 06558','[email protected]','1960-09-19 00:00:00.000')
,('dylanwatts','Nathan Cruz','M','632 Dominguez Lodge Suite 172
Contrerasshire, WV 58509','[email protected]','1978-11-17 00:00:00.000')
,('olarsen','Shannon Cole','F','71434 Patricia Cliffs
West Ericberg, KS 61570','[email protected]','1983-10-22 00:00:00.000')
,('sherrievans','Spencer Johnston','M','889 Freeman Garden Apt. 656
Maryside, NE 52146','[email protected]','1967-02-25 00:00:00.000')
,('nicholeramirez','Erin Gibson','F','USNS Conley
FPO AA 98677','[email protected]','2010-08-22 00:00:00.000')
,('mhowell','Andre Wright','M','745 Catherine Shoals
Lake Tamiland, IA 89282','[email protected]','1984-11-24 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('gburke','Brian Barton','M','Unit 0586 Box 5185
DPO AE 55558','[email protected]','2017-02-06 00:00:00.000')
,('christina87','Casey Boyd','F','5314 Sanchez Lodge Suite 650
West Tony, IL 37156','[email protected]','1930-04-26 00:00:00.000')
,('debbie77','Katherine Chang','F','34957 Cooper Wells
Michaelview, HI 95041','[email protected]','1929-07-06 00:00:00.000')
,('ycarlson','Destiny Lawrence','F','4082 Terri Oval
Davidhaven, UT 75744','[email protected]','1938-09-04 00:00:00.000')
,('sotobrian','Rodney Morales','M','31869 Montgomery Springs Apt. 749
Torresstad, OR 27736','[email protected]','1979-06-10 00:00:00.000')
,('jessemann','Joanna Wheeler','F','493 Amy Port
Serranoton, IA 98668','[email protected]','1945-09-13 00:00:00.000')
,('williamsryan','Jonathan Snyder','M','99049 Katelyn Loop
Sabrinaville, NY 64952','[email protected]','1918-07-20 00:00:00.000')
,('ccervantes','Michael Roberts','M','68087 Jacob Island
Garrettmouth, NV 38253','[email protected]','1987-03-08 00:00:00.000')
,('jeffreyskinner','Eric Smith','M','2748 Perry Manors Apt. 782
Port William, UT 36709','[email protected]','1940-09-04 00:00:00.000')
,('hburns','Edwin Matthews','M','8675 Pollard Fords
Lake Robert, MS 50469','[email protected]','1971-09-23 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('kirkcory','Vincent Rivera','M','PSC 0262, Box 1745
APO AA 52599','[email protected]','1989-08-15 00:00:00.000')
,('welchsamantha','Shane Johnson','M','Unit 1611 Box 7240
DPO AE 07856','[email protected]','1981-05-03 00:00:00.000')
,('feliciajimenez','Christopher Lynch','M','7407 Byrd Dam
West Briana, MA 33281','[email protected]','1918-10-30 00:00:00.000')
,('tiffanybarrett','Laura Haney','F','097 Leach Springs Apt. 533
Ericachester, TN 82846','[email protected]','1908-11-08 00:00:00.000')
,('gregory28','Brandon Phillips','M','4247 Phillips Track
Mcdonaldton, HI 89148','[email protected]','1958-01-06 00:00:00.000')
,('brenda51','Jordan Chambers','F','8593 Reid Lodge
Debraland, AK 65070','[email protected]','1954-10-23 00:00:00.000')
,('eric61','Tracy Barnes','M','405 Sean Fords Apt. 585
East Tammyshire, CA 28302','[email protected]','1937-06-18 00:00:00.000')
,('brenda35','Daniel Gallegos','M','4228 Greg Prairie Apt. 053
Alfredburgh, MA 15397','[email protected]','1965-10-31 00:00:00.000')
,('xboyd','Andrew Logan','M','USS Mendoza
FPO AA 90429','[email protected]','1948-02-26 00:00:00.000')
,('mark98','Donald Schultz','M','1836 Jeremy Hills Apt. 615
New Nicholas, WA 09300','[email protected]','1955-01-12 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('davidgomez','Kevin Hoffman','M','049 Dale Mission Apt. 731
South Danny, HI 56745','[email protected]','1991-10-14 00:00:00.000')
,('nelsonkathryn','Matthew Steele','M','PSC 5022, Box 9612
APO AP 04519','[email protected]','1925-09-26 00:00:00.000')
,('williamseric','Paula Bradley','F','67976 Kari Courts Apt. 497
Kyleberg, AZ 27295','[email protected]','1948-12-21 00:00:00.000')
,('jerry85','Jessica Anderson','F','07159 Richard Port Apt. 605
Port Stevechester, MI 14376','[email protected]','1946-07-17 00:00:00.000')
,('alyssa35','Richard Jones','M','2312 Glenn Dale Suite 127
South Bethany, UT 84779','[email protected]','1968-02-19 00:00:00.000')
,('lance70','Denise Brown','F','19986 Angela Square Suite 793
South Edward, CO 45516','[email protected]','2000-08-15 00:00:00.000')
,('justinortiz','Kelly Moore','F','515 Erika Gateway Suite 925
New Sabrinaburgh, NC 17402','[email protected]','2012-01-22 00:00:00.000')
,('egaines','Michele Valentine','F','42357 Zoe Dale Apt. 188
Stephensontown, RI 17677','[email protected]','1926-11-04 00:00:00.000')
,('nbishop','Jackson Ball','M','73597 Juan Isle
Tammyfort, DE 33269','[email protected]','2001-02-18 00:00:00.000')
,('rebeccahernandez','Dustin Hines','M','75060 Nathaniel Junction Apt. 305
Combsfurt, DE 38102','[email protected]','1968-02-28 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('ldunn','Angela Scott','F','41036 Dean Centers
Portermouth, NH 94682','[email protected]','1961-01-03 00:00:00.000')
,('ostephens','Kelly Ward','F','065 Allen Square
Lake Courtney, OR 44084','[email protected]','2017-04-30 00:00:00.000')
,('obrown','Michael Welch','M','30548 Lisa Mall
New Justinhaven, NC 36312','[email protected]','1956-12-08 00:00:00.000')
,('eadams','Melissa Richardson','F','284 Christopher Prairie
New Ronald, KY 06052','[email protected]','2012-01-13 00:00:00.000')
,('xshelton','Mark Cox','M','021 Deanna Island Suite 092
Stacybury, NH 69898','[email protected]','1907-11-04 00:00:00.000')
,('jorgegriffin','James Hoffman','M','Unit 4731 Box 2172
DPO AP 58842','[email protected]','1995-03-17 00:00:00.000')
,('wjoseph','Kimberly Vance','F','1323 Johnson Oval Apt. 829
Jonesbury, MS 54344','[email protected]','1991-09-26 00:00:00.000')
,('earnold','Kelly Anderson','F','0182 Fernando View
Port Aprilburgh, GA 72700','[email protected]','1991-07-21 00:00:00.000')
,('cassie90','Brittany Hopkins','F','94396 Johnson Tunnel
Dawnburgh, SD 53728','[email protected]','1970-03-22 00:00:00.000')
,('vanessareed','Briana Hensley','F','1537 Shannon Crossing Apt. 696
Port Erikborough, IA 21386','[email protected]','1907-06-21 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('brandon47','Joyce Allen','F','480 Jordan Trail Suite 650
South James, AR 66594','[email protected]','1987-06-24 00:00:00.000')
,('kfischer','Mrs. Rebecca Morgan','F','25787 Patricia Crossing Suite 526
Stevensonburgh, TN 70275','[email protected]','1949-05-25 00:00:00.000')
,('anthony74','Kevin Robles DDS','M','Unit 9930 Box 9728
DPO AA 81731','[email protected]','1982-03-29 00:00:00.000')
,('vaughnrobert','Albert Edwards','M','028 Mark Prairie Suite 527
Petersonborough, OK 84820','[email protected]','1942-04-15 00:00:00.000')
,('jaredbush','William Evans','M','441 Daniels Turnpike
West Kendra, AZ 94104','[email protected]','1933-06-09 00:00:00.000')
,('gilbertbrenda','Taylor Horton','F','3016 Thomas Rapid Apt. 826
Nicoleport, PA 38150','[email protected]','1982-06-15 00:00:00.000')
,('rbutler','Sarah Johnson','F','USS Huff
FPO AP 24921','[email protected]','1905-07-29 00:00:00.000')
,('daniellewarren','Tanya Rogers','F','4315 Stephen Fork
Lake Krystalmouth, DC 84220','[email protected]','1995-05-26 00:00:00.000')
,('seanadams','Karen Boyle MD','F','4530 Marshall Dam Suite 414
East Susan, MN 79896','[email protected]','2013-06-19 00:00:00.000')
,('xmiller','David Fischer','M','0883 Hernandez Heights
Darrenville, CA 67396','[email protected]','1981-01-23 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('lisareese','Renee Cummings','F','1801 Kennedy Glen
North Darlenechester, ME 50633','[email protected]','1994-05-20 00:00:00.000')
,('glong','Scott Wilson','M','Unit 0047 Box 8686
DPO AP 32942','[email protected]','2008-06-30 00:00:00.000')
,('ksmith','Jennifer Miranda','F','0306 Amber Shore
Taylorshire, VA 76012','[email protected]','1945-05-20 00:00:00.000')
,('brittany26','Joseph Gutierrez III','M','6856 Kevin Estates
Johnberg, DE 61190','[email protected]','1922-07-25 00:00:00.000')
,('nathannichols','Erin Miller','F','9901 Kathleen Roads
Timothyhaven, WV 02510','[email protected]','2006-12-23 00:00:00.000')
,('oarnold','Lindsey Harris','F','4587 Leah Roads Suite 535
North Michelle, AL 73024','[email protected]','1949-03-17 00:00:00.000')
,('nmorgan','Danielle Pierce','F','725 Jennifer Meadow Suite 808
Lake Sierrafurt, MA 83168','[email protected]','1955-02-08 00:00:00.000')
,('alfred88','Taylor Durham','F','840 Wolfe Lane
Whiteside, ID 81736','[email protected]','1959-07-29 00:00:00.000')
,('zmiller','Melissa Evans','F','6870 Warner Cliffs
Newmanborough, WI 69727','[email protected]','1981-06-14 00:00:00.000')
,('belliott','Angela Frost','F','USNS Ali
FPO AA 99100','[email protected]','1981-01-25 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('karlataylor','Jasmine Mosley','F','Unit 1850 Box 1631
DPO AA 80961','[email protected]','1941-07-07 00:00:00.000')
,('jacobwillis','Darren Tran','M','31142 Kristen Dale Apt. 511
West Michaelburgh, FL 59331','[email protected]','1979-09-29 00:00:00.000')
,('paulmiller','Erika Cruz','F','PSC 3982, Box 6224
APO AE 65135','[email protected]','2010-11-01 00:00:00.000')
,('james12','Danielle Weber','F','96575 Madison Ports Suite 459
Harrisburgh, WI 38701','[email protected]','1942-06-18 00:00:00.000')
,('amy80','Brian Elliott','M','USNS Erickson
FPO AA 38686','[email protected]','1995-11-27 00:00:00.000')
,('kristina17','Dana Hopkins','F','Unit 7968 Box 8680
DPO AP 47625','[email protected]','1938-02-05 00:00:00.000')
,('ubyrd','Matthew Williams','M','0143 Stone Pass Suite 756
New Hannah, WY 63778','[email protected]','2003-09-08 00:00:00.000')
,('thomaskim','Jordan Clark','F','10512 Yang Motorway
Markview, SC 83044','[email protected]','1987-11-23 00:00:00.000')
,('ramirezjane','Jeffrey Smith','M','825 Stephen Fort Suite 859
West Danny, MN 23114','[email protected]','1915-11-07 00:00:00.000')
,('donaldprice','David Wilson','M','7828 Keith Expressway Suite 905
Washingtonville, NV 86100','[email protected]','1970-10-29 00:00:00.000')
;
INSERT INTO public."user" (username,"name",sex,address,mail,birthdate) VALUES
('walkerkeith','Rebecca Walker','F','788 Danny Springs Suite 580
Alexanderberg, OR 86179','[email protected]','1951-10-03 00:00:00.000')
,('mclark','Sean Wilson','M','6292 Li Station Suite 849
Mariochester, IL 67926','[email protected]','2011-03-31 00:00:00.000')
,('david25','Destiny Rios','F','729 Burton Isle Apt. 168
Heatherhaven, MS 76779','[email protected]','1966-09-16 00:00:00.000')
,('tammysummers','Samuel Flynn','M','89297 Shannon Skyway
New Marytown, DC 60337','[email protected]','1922-04-08 00:00:00.000')
,('wardchristopher','Shannon Mcdowell','M','43611 Thomas Crescent Apt. 700
Lisashire, CT 09784','[email protected]','1954-05-04 00:00:00.000')
,('haneydouglas','Raymond Mullins','M','7532 Jensen Loaf
Port Donaldland, KY 56781','[email protected]','1979-08-19 00:00:00.000')
,('boonenancy','Dustin Pugh','M','64037 John Points Apt. 055
Port Ashleyborough, PA 10068','[email protected]','1912-07-17 00:00:00.000')
,('uhenderson','Dustin Marquez','M','14183 Moore Heights Suite 146
Meghanton, MI 59925','[email protected]','1922-12-27 00:00:00.000')
,('ile','Troy Mills','M','10564 Baker Walks Suite 778
South Ashley, IL 13988','[email protected]','1904-08-30 00:00:00.000')
,('edwardvelazquez','Dana Ruiz','F','635 Ruth Harbors Suite 951
Rachelville, WY 53051','[email protected]','1948-11-10 00:00:00.000')
;