· 8 years ago · Jun 06, 2018, 12:12 AM
1CREATE SCHEMA IF NOT EXISTS SG;
2USE SG;
3
4DROP TABLE IF EXISTS s_customer;
5CREATE TABLE s_customer
6 (id VARCHAR(3) NOT NULL,
7 name VARCHAR(20) NOT NULL,
8 phone VARCHAR(20) NOT NULL,
9 address VARCHAR(20),
10 city VARCHAR(20),
11 state VARCHAR(15),
12 country VARCHAR(20),
13 zip_code VARCHAR(15),
14 credit_rating VARCHAR(9),
15 sales_rep_id VARCHAR(3),
16 region_id VARCHAR(3),
17 comments VARCHAR(255),
18 CONSTRAINT s_customer_id_pk PRIMARY KEY (id),
19 CONSTRAINT s_customer_credit_rating_ck
20 CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR'))
21 );
22
23
24INSERT INTO s_customer VALUES ('301', 'Sports,Inc', '540-123-4567','72 High St',
25'Harrisonburg', 'VA','US', '22809','EXCELLENT', '12', '1', NULL);
26INSERT INTO s_customer VALUES ('302', 'Toms Sporting Goods', '540-987-6543','6741 Main St',
27'Harrisonburg', 'VA','US', '22809','POOR', '14', '1', NULL);
28INSERT INTO s_customer VALUES ('303', 'Athletic Attire', '540-123-6789','54 Market St',
29'Harrisonburg', 'VA','US', '22808','GOOD', '14', '1', NULL);
30INSERT INTO s_customer
31VALUES ('304', 'Athletics For All', '540-987-1234','286 Main St', 'Harrisonburg', 'VA',
32'US', '22808','EXCELLENT', '12', '1', NULL);
33INSERT INTO s_customer VALUES ('305', 'Shoes for Sports', '540-123-9876','538 High St',
34'Harrisonburg', 'VA','US', '22809','EXCELLENT', '14', '1', NULL);
35INSERT INTO s_customer VALUES ('306', 'BJ Athletics', '540-987-9999','632 Water St',
36'Harrisonburg', 'VA','US', '22810','POOR', '12', '1', NULL);
37
38INSERT INTO s_customer VALUES ('403', 'Athletics One', '717-234-6786','912 Columbia Rd',
39'Lancaster', 'PA','US', '17601','GOOD', '14', '1', NULL);
40INSERT INTO s_customer VALUES ('404', 'Great Athletes', '717-987-2341','121 Litiz Pike',
41'Lancaster', 'PA','US', '17602','EXCELLENT', '12', '1', NULL);
42INSERT INTO s_customer VALUES ('405', 'Athletics Two', '717-987-9875','435 High Rd',
43'Lancaster', 'PA','US', '17602','EXCELLENT', '14', '1', NULL);
44INSERT INTO s_customer VALUES ('406', 'Athletes Attic', '717-234-9888','101 Greenfield Rd',
45'Lancaster', 'PA','US', '17601','POOR', '12', '1', NULL);
46
47INSERT INTO s_customer VALUES ('201', 'One Sport', '55-112066222','82 Via Bahia', 'Sao Paolo',
48NULL, 'Brazil', NULL,'EXCELLENT', '12', '2', NULL);
49INSERT INTO s_customer VALUES ('202', 'Deportivo Caracas', '58-28066222','31 Sabana Grande',
50'Caracas', NULL, 'Venezuela', NULL,'EXCELLENT', '12', '2', NULL);
51INSERT INTO s_customer VALUES ('203', 'New Delhi Sports', '91-11903338','11368 Chanakya',
52'New Delhi', NULL, 'India', NULL,'GOOD', '11', '4', NULL);
53INSERT INTO s_customer VALUES ('204', 'Ladysport', '1-206-104-0111','281 Queen Street',
54'Seattle', 'Washington', 'US', NULL,'EXCELLENT', '11', '1', NULL);
55INSERT INTO s_customer VALUES ('205', 'Kim''s Sporting Goods', '852-3693888','15 Henessey Road',
56'Hong Kong', NULL, NULL, NULL,'EXCELLENT', '11', '4', NULL);
57INSERT INTO s_customer VALUES ('206', 'Sportique', '33-93425722253','172 Rue de Place',
58'Cannes', NULL, 'France', NULL,'EXCELLENT', '13', '5', NULL);
59INSERT INTO s_customer VALUES ('207', 'Tall Rock Sports', '234-16036222','10 Saint Antoine',
60'Lagos', NULL, 'Nigeria', NULL,'GOOD', NULL, '3', NULL);
61INSERT INTO s_customer VALUES ('208', 'Muench Sports', '49-895274449','435 Gruenestrasse',
62'Munich', NULL, 'Germany', NULL,'GOOD', '13', '5', NULL);
63
64INSERT INTO s_customer VALUES ('209', 'Beisbol Si!', '809-352666','415 Playa Del Mar',
65 'San Pedro de Macoris', NULL, 'Dominican Republic', NULL, 'EXCELLENT', '11', '6', NULL);
66INSERT INTO s_customer VALUES ('210', 'Futbol Sonora', '52-404555','5 Via Saguaro', 'Nogales',
67NULL, 'Mexico', NULL,'EXCELLENT', '12', '2', NULL);
68INSERT INTO s_customer VALUES ('211', 'Helmut''s Sports', '42-2111222','45 Modrany', 'Prague',
69NULL, 'Czechoslovakia', NULL,'EXCELLENT', '11', '5', NULL);
70INSERT INTO s_customer VALUES ('212', 'Hamada Sport', '20-31209222','47A Corniche',
71'Alexandria', NULL, 'Egypt', NULL,'EXCELLENT', '13', '3', NULL);
72INSERT INTO s_customer VALUES ('213', 'Sports Emporium', '1-415-555-6281','4783 168th Street',
73'San Francisco', 'CA', 'US', NULL,'EXCELLENT', '11', '1', NULL);
74INSERT INTO s_customer VALUES ('214', 'Sports Retail', '1-716-555-7777','115 Main Street',
75'Buffalo', 'NY', 'US', NULL, 'POOR', '11', '1', NULL);
76INSERT INTO s_customer VALUES ('215', 'Sports Russia', '7-0953892444','7070 Yekatamina',
77'Saint Petersburg', NULL, 'Russia', NULL,'POOR', '11', '5', NULL);
78COMMIT;