-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema.sql
43 lines (35 loc) · 4.87 KB
/
schema.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
DROP DATABASE IF EXISTS uniqlo_inv;
CREATE DATABASE uniqlo_inv;
USE uniqlo_inv;
CREATE TABLE product(
id INT NOT NULL AUTO_INCREMENT,
product_type VARCHAR (10) NOT NULL,
product_price VARCHAR (65) NOT NULL,
product_image VARCHAR(100) NOT NULL,
product_description VARCHAR (100) NOT NULL,
PRIMARY KEY (id)
);
insert into product (product_type, product_price, product_image, product_description) values ('pants','$39.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants1.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$19.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants2.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants3.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$39.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants4.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$39.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants5.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants6.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$39.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants7.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('pants','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/pants8.jpeg','WOMEN EZY ANKLE-LENGTH PANTS');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt1.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt2.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt3.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt4.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt5.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt6.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt7.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('shirts','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/shirt8.jpeg','shirt');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater1.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater2.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater3.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater4.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater5.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater6.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater7.jpeg','sweater');
insert into product (product_type, product_price, product_image, product_description) values ('sweater','$29.90','https://s3-us-west-1.amazonaws.com/uniqloassets/sweater8.jpeg','sweater');