-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.sql
45 lines (32 loc) · 2.85 KB
/
data.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
insert into store (name) values ('costco');
insert into store (name) values ('Best Buy');
insert into location (address,storeid) values ('heartland-costco',1);
insert into location (address,storeid) values ('dixie-costco',1);
insert into location (address,storeid) values ('bramlea-bestbuy',2);
insert into location (address,storeid) values ('heartland-bestbuy',2);
insert into category (name ) values('electronic');
insert into category (name ) values('appliance');
insert into category (name ) values('food');
insert into product (name ) values('S7');
insert into product (name ) values('iPhone');
insert into product (name ) values('LG');
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('A','Extreme right', 1,1);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('B','Middle', 1,2);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('C','Extreme left', 1,3);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('A','Center', 2,1);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('B','Left', 2,2);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('C','Right', 2,3);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('1','Front', 3,1);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('1','Front', 3,2);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('2','Front left', 4,1);
insert into aisle_category_at_location (aisle_name,description,locationid,categoryid) values('2','Back', 4,2);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('A','Extreme right', 1,1);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('B','Middle', 1,2);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('C','Extreme left', 1,3);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('A','Center', 2,1);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('B','Left', 2,2);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('C','Right', 2,3);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('1','Front', 3,1);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('1','Front', 3,2);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('2','Front left', 4,1);
insert into aisle_product_at_location (aisle_name,description,locationid,productid) values('2','Back', 4,2);