163 | | INSERT INTO customer (id, first_name, last_name, email) VALUES (7, 'Bisera', 'Peshevska', 'pesevskab1997@gmail.com'); |
164 | | |
165 | | }}} |
166 | | // |
167 | | |
168 | | // |
169 | | |
170 | | {{{ |
171 | | #!python |
172 | | |
173 | | |
174 | | INSERT INTO address (id, street, city, country, zip_code) VALUES (16, 'Floris Burgwal', 'Rotterdam', 'Netherlands', '7233'); |
175 | | |
176 | | INSERT INTO address (id, street, city, country, zip_code) VALUES (17, 'Egejska Makedonija', 'Kumanovo', 'Macedonia', '1300'); |
177 | | |
178 | | }}} |
179 | | |
180 | | // |
181 | | |
182 | | {{{ |
183 | | #!python |
184 | | |
185 | | INSERT INTO orders(id, order_tracking_number, total_price, total_quantity, date_created, last_updated, customer_id, billing_address_id, shipping_address_id) VALUES (8, 'e769b2d6-8d7a-4574-8c39-45f0ced7a374', 82.4, 3, 2021-08-02 22:26:17, 2021-08-02 22:26:17, 7, 16, 17); |
186 | | |
187 | | |
188 | | }}} |
189 | | // |
190 | | |
191 | | {{{ |
192 | | #!python |
193 | | |
194 | | INSERT INTO order_item(o_id, order_id, image_url, quantity, unit_price, product_id) VALUES (13, 8, 'assets/images/products/vitamins/VITAMINS-1002.png', 2, 29.9, 3); |
195 | | |
196 | | INSERT INTO order_item(o_id, order_id, image_url, quantity, unit_price, product_id) VALUES (14, 8, 'assets/images/products/vitamins/VITAMINS-1010.png', 1, 22.6, 11); |
| 163 | INSERT INTO customer (first_name, last_name, email) VALUES ('Bisera', 'Peshevska', 'pesevskab1997@gmail.com'); |
| 164 | |
| 165 | }}} |
| 166 | // |
| 167 | |
| 168 | // |
| 169 | |
| 170 | {{{ |
| 171 | #!python |
| 172 | |
| 173 | |
| 174 | INSERT INTO address (street, city, country, zip_code) VALUES ('Floris Burgwal', 'Rotterdam', 'Netherlands', '7233'); |
| 175 | |
| 176 | INSERT INTO address (street, city, country, zip_code) VALUES ('Egejska Makedonija', 'Kumanovo', 'Macedonia', '1300'); |
| 177 | |
| 178 | }}} |
| 179 | |
| 180 | // |
| 181 | |
| 182 | {{{ |
| 183 | #!python |
| 184 | |
| 185 | INSERT INTO orders (order_tracking_number, total_price, total_quantity, date_created, last_updated, customer_id, billing_address_id, shipping_address_id) VALUES ('e769b2d6-8d7a-4574-8c39-45f0ced7a374', 82.4, 3, 2021-08-02 22:26:17, 2021-08-02 22:26:17, 7, 1, 2); |
| 186 | |
| 187 | |
| 188 | }}} |
| 189 | // |
| 190 | |
| 191 | {{{ |
| 192 | #!python |
| 193 | |
| 194 | INSERT INTO order_item (image_url, quantity, unit_price, product_id) VALUES ('assets/images/products/vitamins/VITAMINS-1002.png', 2, 29.9, 3); |
| 195 | |
| 196 | INSERT INTO order_item (image_url, quantity, unit_price, product_id) VALUES ('assets/images/products/vitamins/VITAMINS-1010.png', 1, 22.6, 11); |