-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathinsert into statements
175 lines (160 loc) · 16.7 KB
/
insert into statements
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
insert into user values ('james.smith', 'jsmith123', 'James', 'Smith', 'Approved');
insert into user values ('michael.smith', 'msmith456', 'Michael', 'Smith', 'Approved');
insert into user values ('robert.smith', ' rsmith789', 'Robert', 'Smith', 'Approved');
insert into user values ('maria.garcia', 'mgarcia123', 'Maria', 'Garcia', 'Approved');
insert into user values ('david.smith', 'dsmith456', 'David', 'Smith', 'Approved');
insert into user values ('manager1', 'manager1', 'Manager', 'One', 'Pending');
insert into user values ('manager2', 'manager2', 'Manager', 'Two', 'Approved');
insert into user values ('manager3', 'manager3', 'Manager', 'Three', 'Approved');
insert into user values ('manager4', 'manager4', 'Manager', 'Four', 'Approved');
insert into user values ('manager5', 'manager5', 'Manager', 'Five', 'Approved');
insert into user values ('maria.rodriguez', 'mrodriguez', 'Maria', 'Rodriguez', 'Declined');
insert into user values ('mary.smith', 'msmith789', 'Mary', 'Smith', 'Approved');
insert into user values ('maria.hernandez', 'mhernandez', 'Maria', 'Hernandez', 'Approved');
insert into user values ('staff1', 'staff1234', 'Staff', 'One', 'Approved');
insert into user values ('staff2', 'staff4567', 'Staff', 'Two', 'Approved');
insert into user values ('staff3', 'staff7890', 'Staff', 'Three', 'Approved');
insert into user values ('user1', 'user123456', 'User', 'One', 'Pending');
insert into user values ('visitor1', 'visitor123', 'Visitor', 'One', 'Approved');
insert into visitor values ('michael.smith');
insert into visitor values ('maria.garcia');
insert into visitor values ('manager2');
insert into visitor values ('manager4');
insert into visitor values ('manager5');
insert into visitor values ('maria.rodriguez');
insert into visitor values ('mary.smith');
insert into visitor values ('staff2');
insert into visitor values ('staff3');
insert into visitor values ('visitor1');
insert into USEREMAIL values ('james.smith', '[email protected]');
insert into USEREMAIL values ('james.smith', '[email protected]');
insert into USEREMAIL values ('james.smith', '[email protected]');
insert into USEREMAIL values ('james.smith', '[email protected]');
insert into USEREMAIL values ('michael.smith', '[email protected]');
insert into USEREMAIL values ('robert.smith', '[email protected]');
insert into USEREMAIL values ('maria.garcia', '[email protected]');
insert into USEREMAIL values ('maria.garcia', '[email protected]');
insert into USEREMAIL values ('david.smith', '[email protected]');
insert into USEREMAIL values ('maria.rodriguez', '[email protected]');
insert into USEREMAIL values ('mary.smith', '[email protected]');
insert into USEREMAIL values ('maria.hernandez', '[email protected]');
insert into USEREMAIL values ('maria.hernandez', '[email protected]');
insert into USEREMAIL values ('manager1', '[email protected]');
insert into USEREMAIL values ('manager2', '[email protected]');
insert into USEREMAIL values ('manager3', '[email protected]');
insert into USEREMAIL values ('manager4', '[email protected]');
insert into USEREMAIL values ('manager5', '[email protected]');
insert into USEREMAIL values ('staff1', '[email protected]');
insert into USEREMAIL values ('staff2', '[email protected]');
insert into USEREMAIL values ('staff3', '[email protected]');
insert into USEREMAIL values ('user1', '[email protected]');
insert into USEREMAIL values ('visitor1', '[email protected]');
insert into employee values ('james.smith', 000000001, '4043721234', '123 East Main Street', 'Rochester', 'NY', '14604');
insert into employee values ('michael.smith', 000000002, '4043726789', '350 Ferst Drive', 'Atlanta', 'GA', '30332');
insert into employee values ('robert.smith', 000000003, '1234567890', '123 East Main Street', 'Columbus', 'OH', '43215');
insert into employee values ('maria.garcia', 000000004, '7890123456', '123 East Main Street', 'Richland', 'PA', '17987');
insert into employee values ('david.smith', 000000005, '5124776435', '350 Ferst Drive', 'Atlanta', 'GA', '30332');
insert into employee values ('manager1', 000000006, '8045126767', '123 East Main Street', 'Rochester', 'NY', '14604');
insert into employee values ('manager2', 000000007, '9876543210', '123 East Main Street', 'Rochester', 'NY', '14604');
insert into employee values ('manager3', 000000008, '5432167890', '350 Ferst Drive', 'Atlanta', 'GA', '30332');
insert into employee values ('manager4', 000000009, '8053467565', '123 East Main Street', 'Columbus', 'OH', '43215');
insert into employee values ('manager5', 000000010, '8031446782', '801 Atlantic Drive', 'Atlanta', 'GA', '30332');
insert into employee values ('staff1', 000000011, '8024456765', '266 Ferst Drive Northwest', 'Atlanta', 'GA', '30332');
insert into employee values ('staff2', 000000012, '8888888888', '266 Ferst Drive Northwest', 'Atlanta', 'GA', '30332');
insert into employee values ('staff3', 000000013, '3333333333', '801 Atlantic Drive', 'Atlanta', 'GA', '30332');
insert into administrator values ('james.smith');
insert into staff values ('michael.smith');
insert into staff values ('robert.smith');
insert into staff values ('staff1');
insert into staff values ('staff2');
insert into staff values ('staff3');
insert into manager values ('maria.garcia');
insert into manager values ('david.smith');
insert into manager values ('manager1');
insert into manager values ('manager2');
insert into manager values ('manager3');
insert into manager values ('manager4');
insert into manager values ('manager5');
insert into site values ('Piedmont Park', '400 Park Drive Northeast', '30306', true, 'manager2');
insert into site values ('Atlanta Beltline Center', '112 Krog Street Northeast', '30307', false, 'manager3');
insert into site values ('Historic Fourth Ward Park', '680 Dallas Street Northeast', '30308', true, 'manager4');
insert into site values ('Westview Cemetery', '1680 Westview Drive Southwest', '30310', false, 'manager5');
insert into site values ('Inman Park', '', '30307', true, 'david.smith');
insert into event values ('Piedmont Park', 'Eastside Trail', '2019-02-04', '2019-02-05', 0, 99999, 1, 'A combination of multi-use trail and linear green space, the Eastside Trail was the first finished section of the Atlanta BeltLine trail in the old rail corridor. The Eastside Trail, which was funded by a combination of public and private philanthropic sources, runs from the tip of Piedmont Park to Reynoldstown. More details at https://beltline.org/explore-atlanta-beltline-trails/eastside-trail/');
insert into event values ('Inman Park', 'Eastside Trail', '2019-02-04', '2019-02-05', 0, 99999, 1, 'A combination of multi-use trail and linear green space, the Eastside Trail was the first finished section of the Atlanta BeltLine trail in the old rail corridor. The Eastside Trail, which was funded by a combination of public and private philanthropic sources, runs from the tip of Piedmont Park to Reynoldstown. More details at https://beltline.org/explore-atlanta-beltline-trails/eastside-trail/');
insert into event values ('Inman Park', 'Eastside Trail', '2019-03-01', '2019-03-02', 0, 99999, 1, 'A combination of multi-use trail and linear green space, the Eastside Trail was the first finished section of the Atlanta BeltLine trail in the old rail corridor. The Eastside Trail, which was funded by a combination of public and private philanthropic sources, runs from the tip of Piedmont Park to Reynoldstown. More details at https://beltline.org/explore-atlanta-beltline-trails/eastside-trail/');
insert into event values ('Historic Fourth Ward Park', 'Eastside Trail', '2019-02-13', '2019-02-14', 0, 99999, 1, 'A combination of multi-use trail and linear green space, the Eastside Trail was the first finished section of the Atlanta BeltLine trail in the old rail corridor. The Eastside Trail, which was funded by a combination of public and private philanthropic sources, runs from the tip of Piedmont Park to Reynoldstown. More details at https://beltline.org/explore-atlanta-beltline-trails/eastside-trail/');
insert into event values ('Westview Cemetery', 'Westside Trail', '2019-02-18', '2019-02-21', 0, 99999, 1, 'The Westside Trail is a free amenity that offers a bicycle and pedestrian-safe corridor with a 14-foot-wide multi-use trail surrounded by mature trees and grasses thanks to Trees Atlanta’s Arboretum. With 16 points of entry, 14 of which will be ADA-accessible with ramp and stair systems, the trail provides numerous access points for people of all abilities. More details at: https://beltline.org/explore-atlanta-beltline-trails/westside-trail/');
insert into event values ('Inman Park', 'Bus Tour', '2019-02-01', '2019-02-02', 25, 6, 2, 'The Atlanta BeltLine Partnership’s tour program operates with a natural gas-powered, ADA accessible tour bus funded through contributions from 10th & Monroe, LLC, SunTrust Bank Trusteed Foundations–Florence C. and Harry L. English Memorial Fund and Thomas Guy Woolford Charitable Trust, and AGL Resources');
insert into event values ('Inman Park', 'Bus Tour', '2019-02-08', '2019-02-10', 25, 6, 2, 'The Atlanta BeltLine Partnership’s tour program operates with a natural gas-powered, ADA accessible tour bus funded through contributions from 10th & Monroe, LLC, SunTrust Bank Trusteed Foundations–Florence C. and Harry L. English Memorial Fund and Thomas Guy Woolford Charitable Trust, and AGL Resources');
insert into event values ('Inman Park', 'Private Bus Tour', '2019-02-01', '2019-02-02', 40, 4, 1, 'Private tours are available most days, pending bus and tour guide availability. Private tours can accommodate up to 4 guests per tour, and are subject to a tour fee (nonprofit rates are available). As a nonprofit organization with limited resources, we are unable to offer free private tours. We thank you for your support and your understanding as we try to provide as many private group tours as possible. The Atlanta BeltLine Partnership’s tour program operates with a natural gas-powered, ADA accessible tour bus funded through contributions from 10th & Monroe, LLC, SunTrust Bank Trusteed Foundations–Florence C. and Harry L. English Memorial Fund and Thomas Guy Woolford Charitable Trust, and AGL Resources');
insert into event values ('Inman Park', 'Arboretum Walking Tour', '2019-02-08', '2019-02-11', 5, 5, 1, 'Official Atlanta BeltLine Arboretum Walking Tours provide an up-close view of the Westside Trail and the Atlanta BeltLine Arboretum led by Trees Atlanta Docents. The one and a half hour tours step off at at 10am (Oct thru May), and 9am (June thru September). Departure for all tours is from Rose Circle Park near Brown Middle School. More details at: https://beltline.org/visit/atlanta-beltline-tours/#arboretum-walking');
insert into event values ('Atlanta Beltline Center', 'Official Atlanta BeltLine Bike Tour', '2019-02-09', '2019-02-14', 5, 5, 1, 'These tours will include rest stops highlighting assets and points of interest along the Atlanta BeltLine. Staff will lead the rides, and each group will have a ride sweep to help with any unexpected mechanical difficulties.');
insert into transit values ('MARTA', 'Blue', 2.00);
insert into transit values ('Bus', '152', 2.00);
insert into transit values ('Bike', 'Relay', 1.00);
insert into connect values ('Inman Park', 'MARTA', 'Blue');
insert into connect values ('Piedmont Park', 'MARTA', 'Blue');
insert into connect values ('Historic Fourth Ward Park', 'MARTA', 'Blue');
insert into connect values ('Westview Cemetery', 'MARTA', 'Blue');
insert into connect values ('Inman Park', 'Bus', '152');
insert into connect values ('Piedmont Park', 'Bus', '152');
insert into connect values ('Historic Fourth Ward Park', 'Bus', '152');
insert into connect values ('Piedmont Park', 'Bike', 'Relay');
insert into connect values ('Historic Fourth Ward Park', 'Bike', 'Relay');
insert into taketransit values ('manager2', 'MARTA', 'Blue', '2019-03-20');
insert into taketransit values ('manager2', 'Bus', '152', '2019-03-20');
insert into taketransit values ('manager3', 'Bike', 'Relay', '2019-03-20');
insert into taketransit values ('manager2', 'MARTA', 'Blue', '2019-03-21');
insert into taketransit values ('maria.hernandez', 'Bus', '152', '2019-03-20');
insert into taketransit values ('maria.hernandez', 'Bike', 'Relay', '2019-03-20');
insert into taketransit values ('manager2', 'MARTA', 'Blue', '2019-03-22');
insert into taketransit values ('maria.hernandez', 'Bus', '152', '2019-03-22');
insert into taketransit values ('mary.smith', 'Bike', 'Relay', '2019-03-23');
insert into taketransit values ('visitor1', 'MARTA', 'Blue', '2019-03-21');
insert into assign_to values ('michael.smith', 'Piedmont Park', 'Eastside Trail', '2019-02-04');
insert into assign_to values ('staff1', 'Piedmont Park', 'Eastside Trail', '2019-02-04');
insert into assign_to values ('robert.smith', 'Inman Park', 'Eastside Trail', '2019-02-04');
insert into assign_to values ('staff2', 'Inman Park', 'Eastside Trail', '2019-02-04');
insert into assign_to values ('staff1', 'Inman Park', 'Eastside Trail', '2019-03-01');
insert into assign_to values ('michael.smith', 'Historic Fourth Ward Park', 'Eastside Trail', '2019-02-13');
insert into assign_to values ('staff1', 'Westview Cemetery', 'Westside Trail', '2019-02-18');
insert into assign_to values ('staff3', 'Westview Cemetery', 'Westside Trail', '2019-02-18');
insert into assign_to values ('michael.smith', 'Inman Park', 'Bus Tour', '2019-02-01');
insert into assign_to values ('staff2', 'Inman Park', 'Bus Tour', '2019-02-01');
insert into assign_to values ('robert.smith', 'Inman Park', 'Bus Tour', '2019-02-08');
insert into assign_to values ('michael.smith', 'Inman Park', 'Bus Tour', '2019-02-08');
insert into assign_to values ('robert.smith', 'Inman Park', 'Private Bus Tour', '2019-02-01');
insert into assign_to values ('staff3', 'Inman Park', 'Arboretum Walking Tour', '2019-02-08');
insert into assign_to values ('staff1', 'Atlanta BeltLine Center', 'Official Atlanta BeltLine Bike Tour', '2019-02-09');
insert into visitevent values ('mary.smith', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-01');
insert into visitevent values ('maria.garcia', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-02');
insert into visit_event values ('manager2', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-02');
insert into visit_event values ('manager4', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-01');
insert into visit_event values ('manager5', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-02');
insert into visit_event values ('staff2', 'Inman Park', 'Bus Tour', '2019-02-01', '2019-02-02');
insert into visit_event values ('mary.smith', 'Westview Cemetery', 'Westside Trail', '2019-02-18', '2019-02-19');
insert into visit_event values ('mary.smith', 'Inman Park', 'Private Bus Tour', '2019-02-01', '2019-02-01');
insert into visit_event values ('mary.smith', 'Inman Park', 'Private Bus Tour', '2019-02-01', '2019-02-02');
insert into visit_event values ('mary.smith', 'Atlanta BeltLine Center', 'Official Atlanta BeltLine Bike Tour', '2019-02-09', '2019-02-10');
insert into visit_event values ('mary.smith', 'Inman Park', 'Arboretum Walking Tour', '2019-02-08', '2019-02-10');
insert into visit_event values ('mary.smith', 'Piedmont Park', 'Eastside Trail', '2019-02-04', '2019-02-04');
insert into visit_event values ('mary.smith', 'Historic Fourth Ward Park', 'Eastside Trail', '2019-02-13', '2019-02-13');
insert into visit_event values ('mary.smith', 'Historic Fourth Ward Park', 'Eastside Trail', '2019-02-13', '2019-02-14');
insert into visit_event values ('visitor1', 'Historic Fourth Ward Park', 'Eastside Trail', '2019-02-13', '2019-02-14');
insert into visit_event values ('visitor1', 'Atlanta BeltLine Center', 'Official Atlanta BeltLine Bike Tour', '2019-02-09', '2019-02-10');
insert into visit_event values ('visitor1', 'Westview Cemetery', 'Westside Trail', '2019-02-18', '2019-02-19');
insert into visit_site values ('mary.smith', 'Inman Park', '2019-02-01');
insert into visit_site values ('mary.smith', 'Inman Park', '2019-02-02');
insert into visit_site values ('mary.smith', 'Inman Park', '2019-02-03');
insert into visit_site values ('mary.smith', 'Atlanta BeltLine Center', '2019-02-01');
insert into visit_site values ('mary.smith', 'Atlanta BeltLine Center', '2019-02-10');
insert into visit_site values ('mary.smith', 'Historic Fourth Ward Park', '2019-02-02');
insert into visit_site values ('mary.smith', 'Piedmont Park', '2019-02-02');
insert into visit_site values ('visitor1', 'Piedmont Park', '2019-02-11');
insert into visit_site values ('visitor1', 'Atlanta BeltLine Center', '2019-02-13');
insert into visit_site values ('visitor1', 'Historic Fourth Ward Park', '2019-02-11');
insert into visit_site values ('visitor1', 'Westview Cemetery', '2019-02-06');
insert into visit_site values ('visitor1', 'Inman Park', '2019-02-01');
insert into visit_site values ('visitor1', 'Piedmont Park', '2019-02-01');
insert into visit_site values ('visitor1', 'Atlanta BeltLine Center', '2019-02-09');