-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpetstore_insert.sql
More file actions
95 lines (85 loc) · 11.6 KB
/
petstore_insert.sql
File metadata and controls
95 lines (85 loc) · 11.6 KB
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
protocol 'jdbc:derby:';
connect 'petstore';
INSERT INTO ACCOUNT (ADDR1, ADDR2, CITY, COUNTRY, EMAIL, FIRSTNAME, LASTNAME, PASSWORD, PHONE, STATE, STATUS, USERID, ZIP) VALUES ('901 San Antonio Road' , 'MS UCUP02-206' , 'Palo Alto' , 'USA' , 'yourname@yourdomain.com' , 'WOUser' , 'XYZ' , 'wojava' , '555-555-5555' , 'California' , 'OK' , 'wojava' , '94303');
INSERT INTO ACCOUNT (ADDR1, ADDR2, CITY, COUNTRY, EMAIL, FIRSTNAME, LASTNAME, PASSWORD, PHONE, STATE, STATUS, USERID, ZIP) VALUES ('123 elm' , NULL, 'Seattle' , 'USA' , 'kelly@apple.com' , 'kelly' , 'kazem' , 'kellyk' , '555-1212' , 'New York' , NULL, 'kellyk' , '99999');
INSERT INTO CATEGORY (CATID, DESCN, NAME) VALUES ('FISH' , '<image src=../images/fish_icon.gif><font size=5 color=blue> Fish</font>' , 'Fish');
INSERT INTO CATEGORY (CATID, DESCN, NAME) VALUES ('DOGS' , '<image src=../images/dogs_icon.gif><font size=5 color=blue> Dogs</font>' , 'Dogs');
INSERT INTO CATEGORY (CATID, DESCN, NAME) VALUES ('REPTILES' , '<image src=../images/reptiles_icon.gif><font size=5 color=blue>Reptiles</font>' , 'Reptiles');
INSERT INTO CATEGORY (CATID, DESCN, NAME) VALUES ('CATS' , '<image src=../images/cats_icon.gif><font size=5 color=blue> Cats</font>' , 'Cats');
INSERT INTO CATEGORY (CATID, DESCN, NAME) VALUES ('BIRDS' , '<image src="../images/birds_icon.gif"><font size="5" color="blue"> Birds</font>' , 'Birds');
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-1' , 0);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-2' , 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-3' , 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-4' , 100);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-5', 100);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-6', 99);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-7', 0);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-8', 9);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-9', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-10', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-11', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-12', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-13', 0);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-14', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-15', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-16', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-17', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-18', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-19', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-20', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-21', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-22', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-23', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-24', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-25', 9);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-26', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-27', 10);
INSERT INTO INVENTORY (ITEMID, QTY) VALUES ('EST-28', 9);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Large', NULL, NULL, NULL, NULL, 'EST-1', 16.00, 'FI-SW-01', 'P', 1, 10.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Small', NULL, NULL, NULL, NULL, 'EST-2', 16.00, 'FI-SW-01', 'P', 1, 10.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Toothless', NULL, NULL, NULL, NULL, 'EST-3', 18.00, 'FI-SW-02', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Spotted', NULL, NULL, NULL, NULL, 'EST-4', 18.00, 'FI-FW-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Spotless', NULL, NULL, NULL, NULL, 'EST-5', 18.00, 'FI-FW-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Male Adult', NULL, NULL, NULL, NULL, 'EST-6', 18.00, 'K9-BD-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Female Puppy', NULL, NULL, NULL, NULL, 'EST-7', 18.00, 'K9-BD-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Male Puppy', NULL, NULL, NULL, NULL, 'EST-8', 18.00, 'K9-PO-02', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Spotless Male Puppy', NULL, NULL, NULL, NULL, 'EST-9', 18.00, 'K9-DL-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Spotted Adult Female', NULL, NULL, NULL, NULL, 'EST-10', 18.00, 'K9-DL-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Venomless', NULL, NULL, NULL, NULL, 'EST-11', 18.00, 'RP-SN-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Rattleless', NULL, NULL, NULL, NULL, 'EST-12', 18.00, 'RP-SN-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Green Adult', NULL, NULL, NULL, NULL, 'EST-13', 18.00, 'RP-LI-02', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Tailless', NULL, NULL, NULL, NULL, 'EST-14', 58.00, 'FL-DSH-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('With tail', NULL, NULL, NULL, NULL, 'EST-15', 23.00, 'FL-DSH-01', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-16', 93.00, 'FL-DLH-02', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-17', 93.00, 'FL-DLH-02', 'P', 1, 12.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-18', 193.00, 'AV-CB-01', 'P', 1, 92.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-19', 15.00, 'AV-SB-02', 'P', 1, 2.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-20', 5.00, 'FI-FW-02', 'P', 1, 2.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-21', 5.00, 'FI-FW-02', 'P', 1, 1.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-22', 135.00, 'K9-RT-02', 'P', 1, 100.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-23', 145.00, 'K9-RT-02', 'P', 1, 100.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-24', 255.00, 'K9-RT-02', 'P', 1, 92.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-25', 325.00, 'K9-RT-02', 'P', 1, 90.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Male', NULL, NULL, NULL, NULL, 'EST-26', 125.00, 'K9-CW-01', 'P', 1, 92.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-27', 155.00, 'K9-CW-01', 'P', 1, 90.00);
INSERT INTO ITEM (ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ITEMID, LISTPRICE, PRODUCTID, STATUS, SUPPLIER, UNITCOST) VALUES ('Adult Female', NULL, NULL, NULL, NULL, 'EST-28', 155.00, 'K9-RT-01', 'P', 1, 90.00);
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('FISH', '<image src="../images/fish1.jpg">Salt Water fish from Australia', 'Angelfish', 'FI-SW-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('FISH', '<image src="../images/fish4.gif">Salt Water fish from Australia', 'Tiger Shark', 'FI-SW-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('FISH', '<image src="../images/fish3.gif">Fresh Water fish from Japan', 'Koi', 'FI-FW-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('FISH', '<image src="../images/fish2.gif">Fresh Water fish from China', 'Goldfish', 'FI-FW-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog2.gif">Friendly dog from England', 'Bulldog', 'K9-BD-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog6.gif">Cute dog from France', 'Poodle', 'K9-PO-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog5.gif">Great dog for a Fire Station', 'Dalmation', 'K9-DL-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog1.gif">Great family dog', 'Golden Retriever', 'K9-RT-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog5.gif">Great hunting dog', 'Labrador Retriever', 'K9-RT-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('DOGS', '<image src="../images/dog4.gif">Great companion dog', 'Chihuahua', 'K9-CW-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('REPTILES', '<image src="../images/lizard3.gif">Doubles as a watch dog', 'Rattlesnake', 'RP-SN-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('REPTILES', '<image src="../images/lizard2.gif">Friendly green friend', 'Iguana', 'RP-LI-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('CATS', '<image src="../images/cat3.gif">Great for reducing mouse populations', 'Manx', 'FL-DSH-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('CATS', '<image src="../images/cat1.gif">Friendly house cat,doubles as a princess', 'Persian', 'FL-DLH-02');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('BIRDS', '<image src="../images/bird4.gif">Great companion for up to 75 years', 'Amazon Parrot', 'AV-CB-01');
INSERT INTO PRODUCT (CATEGORY, DESCN, NAME, PRODUCTID) VALUES ('BIRDS', '<image src="../images/bird1.gif">Great stress reliever', 'Finch', 'AV-SB-02');
INSERT INTO PROFILE (BANNEROPT, FAVCATEGORY, LANGPREF, MYLISTOPT, USER_TYPE, USERID) VALUES (1, 'dogs' , 'English' , 1, NULL, 'wojava');
INSERT INTO PROFILE (BANNEROPT, FAVCATEGORY, LANGPREF, MYLISTOPT, USER_TYPE, USERID) VALUES ( 1, 'Fish' , 'English' , 1, NULL, 'kellyk');
INSERT INTO SUPPLIER (ADDR1, ADDR2, CITY, NAME, PHONE, STATE, STATUS, SUPPID, ZIP) VALUES ('600 Avon Way', '', 'Los Angeles', 'XYZ Pets', '212-947-0797', 'CA', 'AC', 1, '94024');
INSERT INTO SUPPLIER (ADDR1, ADDR2, CITY, NAME, PHONE, STATE, STATUS, SUPPID, ZIP) VALUES ('700 Abalone Way', '', 'San Francisco', 'ABC Pets', '415-947-0797', 'CA', 'AC', 2, '94024');