Repository navigation
Expand file tree
/
Copy pathADD_DATA_MANUALLY.sql
More file actions
72 lines (65 loc) · 6.38 KB
/
Copy pathADD_DATA_MANUALLY.sql
File metadata and controls
72 lines (65 loc) · 6.38 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
-- =====================================================
-- MANUAL DATA INSERTION SCRIPTS FOR COURIER TRACKING
-- =====================================================
-- 1. CUSTOMERS
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Sarah Wilson', 'sarah.wilson@example.com', '+1112223333');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Michael Brown', 'michael.brown@example.com', '+4445556666');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Emily Davis', 'emily.davis@example.com', '+7778889999');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('David Johnson', 'david.johnson@example.com', '+1234567890');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Sophia Lee', 'sophia.lee@example.com', '+0987654321');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('James Miller', 'james.miller@example.com', '+1122334455');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Olivia Taylor', 'olivia.taylor@example.com', '+5566778899');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('William Anderson', 'william.anderson@example.com', '+6677889900');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Ava Martinez', 'ava.martinez@example.com', '+2233445566');
INSERT INTO CUSTOMERS (NAME, EMAIL, PHONE) VALUES ('Ethan Thomas', 'ethan.thomas@example.com', '+3344556677');
-- 2. ROUTES
INSERT INTO ROUTES (NAME) VALUES ('Premium Route');
INSERT INTO ROUTES (NAME) VALUES ('Local Route');
INSERT INTO ROUTES (NAME) VALUES ('Express Route');
INSERT INTO ROUTES (NAME) VALUES ('Overnight Route');
INSERT INTO ROUTES (NAME) VALUES ('International Route');
-- 3. CHECKPOINTS
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (1, 1, 'Origin Hub');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (1, 2, 'Destination Hub');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (2, 1, 'Local Pickup');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (2, 2, 'Local Delivery');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (3, 1, 'Express Hub');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (3, 2, 'Express Delivery');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (4, 1, 'Overnight Hub');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (4, 2, 'Overnight Delivery');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (5, 1, 'International Hub');
INSERT INTO CHECKPOINTS (ROUTE_ID, SEQUENCE_NO, LOCATION_NAME) VALUES (5, 2, 'International Delivery');
-- 4. PARCELS
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK123456789', 1, 'New York, NY', 'Los Angeles, CA');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK987654321', 2, 'Chicago, IL', 'Houston, TX');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK555666777', 3, 'San Francisco, CA', 'Seattle, WA');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK111222333', 4, 'Miami, FL', 'Atlanta, GA');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK444555666', 5, 'Dallas, TX', 'Denver, CO');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK777888999', 6, 'Boston, MA', 'Philadelphia, PA');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK222333444', 7, 'San Diego, CA', 'Phoenix, AZ');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK333444555', 8, 'Orlando, FL', 'Charlotte, NC');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK666777888', 9, 'Las Vegas, NV', 'Salt Lake City, UT');
INSERT INTO PARCELS (TRACKING_ID, CUSTOMER_ID, ORIGIN, DESTINATION) VALUES ('TRK999000111', 10, 'Portland, OR', 'San Jose, CA');
-- 5. PARCEL STATUS HISTORY
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (1, 1, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (1, 2, 'IN_TRANSIT', 'Package in transit');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (2, 3, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (2, 4, 'DELIVERED', 'Package delivered');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (3, 5, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (3, 6, 'IN_TRANSIT', 'Package in transit');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (4, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (4, 8, 'DELIVERED', 'Package delivered');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (5, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (5, 8, 'IN_TRANSIT', 'Package in transit');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (6, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (6, 8, 'DELIVERED', 'Package delivered');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (7, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (7, 8, 'IN_TRANSIT', 'Package in transit');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (8, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (8, 8, 'DELIVERED', 'Package delivered');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (9, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (9, 8, 'IN_TRANSIT', 'Package in transit');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (10, 7, 'PICKED_UP', 'Package picked up');
INSERT INTO PARCEL_STATUS_HISTORY (PARCEL_ID, CHECKPOINT_ID, STATUS, REMARKS) VALUES (10, 8, 'IN_TRANSIT', 'Package in transit');
COMMIT;
SELECT 'Data insertion completed successfully!' AS STATUS FROM DUAL;