-
Notifications
You must be signed in to change notification settings - Fork 5
/
init.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','jasongallagher@gmail.com','1956-01-09 00:00:00.000')
,('amanda61','Lindsey Roman','F','5931 Jeremy Glens Apt. 316
New Michael, GA 35494','frances19@yahoo.com','1977-01-04 00:00:00.000')
,('angela50','James Mayo','M','41395 Victor Tunnel
Douglasland, NE 98413','rachael65@gmail.com','1923-02-21 00:00:00.000')
,('laura69','Anthony Rodriguez','M','848 Smith Roads
Amandaburgh, CO 57486','smithjennifer@hotmail.com','1972-06-11 00:00:00.000')
,('kromero','Brian Garrett','M','809 Andrew Viaduct
Deckerburgh, UT 10823','tuckerchad@hotmail.com','2008-07-17 00:00:00.000')
,('catherine38','Theresa Martin','F','657 Hayes Forge Apt. 098
East Chadstad, VA 43810','youngelizabeth@gmail.com','1922-04-28 00:00:00.000')
,('richarddavis','Kenneth Sanchez','M','0106 Mcbride Court
South Donaldville, UT 10381','michellepierce@gmail.com','1977-11-20 00:00:00.000')
,('jasonmorales','Dr. Samuel Martin','M','474 Susan Well
Jenniferland, WI 76415','bruce50@gmail.com','1969-03-16 00:00:00.000')
,('lopezbrooke','Christopher Yu','M','93990 Barnes Passage
Sarahville, ID 52377','brewerstephen@hotmail.com','1914-03-10 00:00:00.000')
,('william25','Kristine Garcia','F','2784 Archer Ports Apt. 841
Taylorland, NV 36198','jasoncooper@hotmail.com','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','andersonkyle@hotmail.com','2012-08-31 00:00:00.000')
,('michael86','Hunter Fleming','M','Unit 2322 Box 6025
DPO AP 54465','qshields@gmail.com','2011-06-23 00:00:00.000')
,('sellersmichael','Andrew Ruiz','M','36541 Ramirez Port Apt. 850
Port Gregoryshire, CO 57460','kristingraham@hotmail.com','1920-01-20 00:00:00.000')
,('frostamanda','Dawn Fletcher','F','561 Mccall Plaza Suite 148
West Richard, CT 55609','nicholas29@yahoo.com','1959-08-01 00:00:00.000')
,('diana77','Dustin Jordan','M','2148 Harvey Corner
Youngburgh, DE 06558','alvarezmelissa@gmail.com','1960-09-19 00:00:00.000')
,('dylanwatts','Nathan Cruz','M','632 Dominguez Lodge Suite 172
Contrerasshire, WV 58509','jennifer86@hotmail.com','1978-11-17 00:00:00.000')
,('olarsen','Shannon Cole','F','71434 Patricia Cliffs
West Ericberg, KS 61570','jamiefisher@hotmail.com','1983-10-22 00:00:00.000')
,('sherrievans','Spencer Johnston','M','889 Freeman Garden Apt. 656
Maryside, NE 52146','elizabeth16@gmail.com','1967-02-25 00:00:00.000')
,('nicholeramirez','Erin Gibson','F','USNS Conley
FPO AA 98677','zoe53@yahoo.com','2010-08-22 00:00:00.000')
,('mhowell','Andre Wright','M','745 Catherine Shoals
Lake Tamiland, IA 89282','wbrooks@gmail.com','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','xgarcia@yahoo.com','2017-02-06 00:00:00.000')
,('christina87','Casey Boyd','F','5314 Sanchez Lodge Suite 650
West Tony, IL 37156','ohaynes@gmail.com','1930-04-26 00:00:00.000')
,('debbie77','Katherine Chang','F','34957 Cooper Wells
Michaelview, HI 95041','wilsonamanda@hotmail.com','1929-07-06 00:00:00.000')
,('ycarlson','Destiny Lawrence','F','4082 Terri Oval
Davidhaven, UT 75744','timothypeterson@hotmail.com','1938-09-04 00:00:00.000')
,('sotobrian','Rodney Morales','M','31869 Montgomery Springs Apt. 749
Torresstad, OR 27736','joseph12@gmail.com','1979-06-10 00:00:00.000')
,('jessemann','Joanna Wheeler','F','493 Amy Port
Serranoton, IA 98668','wmorse@yahoo.com','1945-09-13 00:00:00.000')
,('williamsryan','Jonathan Snyder','M','99049 Katelyn Loop
Sabrinaville, NY 64952','vharrison@gmail.com','1918-07-20 00:00:00.000')
,('ccervantes','Michael Roberts','M','68087 Jacob Island
Garrettmouth, NV 38253','helenmartinez@hotmail.com','1987-03-08 00:00:00.000')
,('jeffreyskinner','Eric Smith','M','2748 Perry Manors Apt. 782
Port William, UT 36709','rdickerson@hotmail.com','1940-09-04 00:00:00.000')
,('hburns','Edwin Matthews','M','8675 Pollard Fords
Lake Robert, MS 50469','elizabethhoover@hotmail.com','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','melissa86@hotmail.com','1989-08-15 00:00:00.000')
,('welchsamantha','Shane Johnson','M','Unit 1611 Box 7240
DPO AE 07856','nicholasthomas@yahoo.com','1981-05-03 00:00:00.000')
,('feliciajimenez','Christopher Lynch','M','7407 Byrd Dam
West Briana, MA 33281','kevinkidd@hotmail.com','1918-10-30 00:00:00.000')
,('tiffanybarrett','Laura Haney','F','097 Leach Springs Apt. 533
Ericachester, TN 82846','burtonbenjamin@hotmail.com','1908-11-08 00:00:00.000')
,('gregory28','Brandon Phillips','M','4247 Phillips Track
Mcdonaldton, HI 89148','tina85@gmail.com','1958-01-06 00:00:00.000')
,('brenda51','Jordan Chambers','F','8593 Reid Lodge
Debraland, AK 65070','youngamanda@yahoo.com','1954-10-23 00:00:00.000')
,('eric61','Tracy Barnes','M','405 Sean Fords Apt. 585
East Tammyshire, CA 28302','carla00@hotmail.com','1937-06-18 00:00:00.000')
,('brenda35','Daniel Gallegos','M','4228 Greg Prairie Apt. 053
Alfredburgh, MA 15397','thomas58@yahoo.com','1965-10-31 00:00:00.000')
,('xboyd','Andrew Logan','M','USS Mendoza
FPO AA 90429','josephscott@hotmail.com','1948-02-26 00:00:00.000')
,('mark98','Donald Schultz','M','1836 Jeremy Hills Apt. 615
New Nicholas, WA 09300','millerryan@hotmail.com','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','qvillegas@yahoo.com','1991-10-14 00:00:00.000')
,('nelsonkathryn','Matthew Steele','M','PSC 5022, Box 9612
APO AP 04519','morenonicholas@yahoo.com','1925-09-26 00:00:00.000')
,('williamseric','Paula Bradley','F','67976 Kari Courts Apt. 497
Kyleberg, AZ 27295','jasontaylor@gmail.com','1948-12-21 00:00:00.000')
,('jerry85','Jessica Anderson','F','07159 Richard Port Apt. 605
Port Stevechester, MI 14376','chapmanalexandria@yahoo.com','1946-07-17 00:00:00.000')
,('alyssa35','Richard Jones','M','2312 Glenn Dale Suite 127
South Bethany, UT 84779','claudia52@yahoo.com','1968-02-19 00:00:00.000')
,('lance70','Denise Brown','F','19986 Angela Square Suite 793
South Edward, CO 45516','hmiller@gmail.com','2000-08-15 00:00:00.000')
,('justinortiz','Kelly Moore','F','515 Erika Gateway Suite 925
New Sabrinaburgh, NC 17402','sharon48@yahoo.com','2012-01-22 00:00:00.000')
,('egaines','Michele Valentine','F','42357 Zoe Dale Apt. 188
Stephensontown, RI 17677','eric29@hotmail.com','1926-11-04 00:00:00.000')
,('nbishop','Jackson Ball','M','73597 Juan Isle
Tammyfort, DE 33269','castillonathan@hotmail.com','2001-02-18 00:00:00.000')
,('rebeccahernandez','Dustin Hines','M','75060 Nathaniel Junction Apt. 305
Combsfurt, DE 38102','rkennedy@hotmail.com','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','pattersonchristina@gmail.com','1961-01-03 00:00:00.000')
,('ostephens','Kelly Ward','F','065 Allen Square
Lake Courtney, OR 44084','bellmatthew@yahoo.com','2017-04-30 00:00:00.000')
,('obrown','Michael Welch','M','30548 Lisa Mall
New Justinhaven, NC 36312','richardsonpamela@hotmail.com','1956-12-08 00:00:00.000')
,('eadams','Melissa Richardson','F','284 Christopher Prairie
New Ronald, KY 06052','rhonda96@gmail.com','2012-01-13 00:00:00.000')
,('xshelton','Mark Cox','M','021 Deanna Island Suite 092
Stacybury, NH 69898','leonardramirez@hotmail.com','1907-11-04 00:00:00.000')
,('jorgegriffin','James Hoffman','M','Unit 4731 Box 2172
DPO AP 58842','ycochran@hotmail.com','1995-03-17 00:00:00.000')
,('wjoseph','Kimberly Vance','F','1323 Johnson Oval Apt. 829
Jonesbury, MS 54344','dmorrow@hotmail.com','1991-09-26 00:00:00.000')
,('earnold','Kelly Anderson','F','0182 Fernando View
Port Aprilburgh, GA 72700','colleenmendez@gmail.com','1991-07-21 00:00:00.000')
,('cassie90','Brittany Hopkins','F','94396 Johnson Tunnel
Dawnburgh, SD 53728','charlesbrown@yahoo.com','1970-03-22 00:00:00.000')
,('vanessareed','Briana Hensley','F','1537 Shannon Crossing Apt. 696
Port Erikborough, IA 21386','xavierjimenez@gmail.com','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','andreabryan@yahoo.com','1987-06-24 00:00:00.000')
,('kfischer','Mrs. Rebecca Morgan','F','25787 Patricia Crossing Suite 526
Stevensonburgh, TN 70275','annawells@gmail.com','1949-05-25 00:00:00.000')
,('anthony74','Kevin Robles DDS','M','Unit 9930 Box 9728
DPO AA 81731','qjames@gmail.com','1982-03-29 00:00:00.000')
,('vaughnrobert','Albert Edwards','M','028 Mark Prairie Suite 527
Petersonborough, OK 84820','zbaker@hotmail.com','1942-04-15 00:00:00.000')
,('jaredbush','William Evans','M','441 Daniels Turnpike
West Kendra, AZ 94104','bradshawdiana@hotmail.com','1933-06-09 00:00:00.000')
,('gilbertbrenda','Taylor Horton','F','3016 Thomas Rapid Apt. 826
Nicoleport, PA 38150','debbievelez@gmail.com','1982-06-15 00:00:00.000')
,('rbutler','Sarah Johnson','F','USS Huff
FPO AP 24921','whayden@hotmail.com','1905-07-29 00:00:00.000')
,('daniellewarren','Tanya Rogers','F','4315 Stephen Fork
Lake Krystalmouth, DC 84220','awilcox@gmail.com','1995-05-26 00:00:00.000')
,('seanadams','Karen Boyle MD','F','4530 Marshall Dam Suite 414
East Susan, MN 79896','jacquelinedurham@hotmail.com','2013-06-19 00:00:00.000')
,('xmiller','David Fischer','M','0883 Hernandez Heights
Darrenville, CA 67396','briananderson@yahoo.com','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','sallybennett@gmail.com','1994-05-20 00:00:00.000')
,('glong','Scott Wilson','M','Unit 0047 Box 8686
DPO AP 32942','ericlopez@hotmail.com','2008-06-30 00:00:00.000')
,('ksmith','Jennifer Miranda','F','0306 Amber Shore
Taylorshire, VA 76012','carlachambers@gmail.com','1945-05-20 00:00:00.000')
,('brittany26','Joseph Gutierrez III','M','6856 Kevin Estates
Johnberg, DE 61190','yhart@yahoo.com','1922-07-25 00:00:00.000')
,('nathannichols','Erin Miller','F','9901 Kathleen Roads
Timothyhaven, WV 02510','leejudith@hotmail.com','2006-12-23 00:00:00.000')
,('oarnold','Lindsey Harris','F','4587 Leah Roads Suite 535
North Michelle, AL 73024','vriley@gmail.com','1949-03-17 00:00:00.000')
,('nmorgan','Danielle Pierce','F','725 Jennifer Meadow Suite 808
Lake Sierrafurt, MA 83168','mannalbert@yahoo.com','1955-02-08 00:00:00.000')
,('alfred88','Taylor Durham','F','840 Wolfe Lane
Whiteside, ID 81736','lisa46@gmail.com','1959-07-29 00:00:00.000')
,('zmiller','Melissa Evans','F','6870 Warner Cliffs
Newmanborough, WI 69727','uhall@hotmail.com','1981-06-14 00:00:00.000')
,('belliott','Angela Frost','F','USNS Ali
FPO AA 99100','wnicholson@gmail.com','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','osanders@gmail.com','1941-07-07 00:00:00.000')
,('jacobwillis','Darren Tran','M','31142 Kristen Dale Apt. 511
West Michaelburgh, FL 59331','william10@gmail.com','1979-09-29 00:00:00.000')
,('paulmiller','Erika Cruz','F','PSC 3982, Box 6224
APO AE 65135','jacksonjoshua@gmail.com','2010-11-01 00:00:00.000')
,('james12','Danielle Weber','F','96575 Madison Ports Suite 459
Harrisburgh, WI 38701','cynthia93@gmail.com','1942-06-18 00:00:00.000')
,('amy80','Brian Elliott','M','USNS Erickson
FPO AA 38686','sjones@hotmail.com','1995-11-27 00:00:00.000')
,('kristina17','Dana Hopkins','F','Unit 7968 Box 8680
DPO AP 47625','lisa91@gmail.com','1938-02-05 00:00:00.000')
,('ubyrd','Matthew Williams','M','0143 Stone Pass Suite 756
New Hannah, WY 63778','perrysuzanne@gmail.com','2003-09-08 00:00:00.000')
,('thomaskim','Jordan Clark','F','10512 Yang Motorway
Markview, SC 83044','davidsonryan@gmail.com','1987-11-23 00:00:00.000')
,('ramirezjane','Jeffrey Smith','M','825 Stephen Fort Suite 859
West Danny, MN 23114','pmccarthy@yahoo.com','1915-11-07 00:00:00.000')
,('donaldprice','David Wilson','M','7828 Keith Expressway Suite 905
Washingtonville, NV 86100','gailperry@hotmail.com','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','zevans@yahoo.com','1951-10-03 00:00:00.000')
,('mclark','Sean Wilson','M','6292 Li Station Suite 849
Mariochester, IL 67926','eshelton@hotmail.com','2011-03-31 00:00:00.000')
,('david25','Destiny Rios','F','729 Burton Isle Apt. 168
Heatherhaven, MS 76779','schroederjessica@hotmail.com','1966-09-16 00:00:00.000')
,('tammysummers','Samuel Flynn','M','89297 Shannon Skyway
New Marytown, DC 60337','rubiojames@hotmail.com','1922-04-08 00:00:00.000')
,('wardchristopher','Shannon Mcdowell','M','43611 Thomas Crescent Apt. 700
Lisashire, CT 09784','davislinda@gmail.com','1954-05-04 00:00:00.000')
,('haneydouglas','Raymond Mullins','M','7532 Jensen Loaf
Port Donaldland, KY 56781','donaldhill@gmail.com','1979-08-19 00:00:00.000')
,('boonenancy','Dustin Pugh','M','64037 John Points Apt. 055
Port Ashleyborough, PA 10068','jonesjose@gmail.com','1912-07-17 00:00:00.000')
,('uhenderson','Dustin Marquez','M','14183 Moore Heights Suite 146
Meghanton, MI 59925','brian21@gmail.com','1922-12-27 00:00:00.000')
,('ile','Troy Mills','M','10564 Baker Walks Suite 778
South Ashley, IL 13988','fcraig@hotmail.com','1904-08-30 00:00:00.000')
,('edwardvelazquez','Dana Ruiz','F','635 Ruth Harbors Suite 951
Rachelville, WY 53051','marshalljustin@hotmail.com','1948-11-10 00:00:00.000')
;