Yurttas/PL/DBL/mysql/F/01/00/SPJ/Shipments-ins.sql

  1/*
  2REM
  3REM
  4REM Shipments-ins.sql
  5REM
  6REM
  7*/
  8
  9\. set-db.sql
 10
 11INSERT INTO Shipments
 12  VALUES('S01', 'P01', 'J01', 100);
 13
 14INSERT INTO Shipments
 15  VALUES('S01', 'P01', 'J03', 200);
 16
 17INSERT INTO Shipments  
 18  VALUES('S01', 'P01', 'J04', 200);
 19
 20INSERT INTO Shipments 
 21  VALUES('S01', 'P01', 'J07', 200);
 22
 23INSERT INTO Shipments 
 24  VALUES('S01', 'P01', 'J08', 400);
 25
 26INSERT INTO Shipments
 27  VALUES('S01', 'P01', 'J09', 300);
 28
 29INSERT INTO Shipments 
 30  VALUES('S01', 'P01', 'J10', 200);
 31
 32INSERT INTO Shipments
 33  VALUES('S01', 'P02', 'J01', 200);
 34
 35INSERT INTO Shipments
 36  VALUES('S01', 'P02', 'J02', 400);
 37
 38INSERT INTO Shipments
 39  VALUES('S01', 'P03', 'J01', 200);
 40
 41INSERT INTO Shipments
 42  VALUES('S01', 'P05', 'J02', 100);
 43
 44INSERT INTO Shipments
 45  VALUES('S01', 'P06', 'J10', 100);
 46
 47INSERT INTO Shipments
 48  VALUES('S02', 'P01', 'J01', 200);
 49
 50INSERT INTO Shipments
 51  VALUES('S02', 'P01', 'J02', 200);
 52
 53INSERT INTO Shipments
 54  VALUES('S02', 'P02', 'J01', 300);
 55
 56INSERT INTO Shipments
 57  VALUES('S02', 'P04', 'J01', 500);
 58
 59INSERT INTO Shipments
 60  VALUES('S03', 'P01', 'J01', 100);
 61
 62INSERT INTO Shipments
 63  VALUES('S03', 'P02', 'J01', 100);
 64
 65INSERT INTO Shipments
 66  VALUES('S03', 'P02', 'J02', 200);
 67
 68INSERT INTO Shipments
 69  VALUES('S03', 'P02', 'J03', 200);
 70
 71INSERT INTO Shipments
 72  VALUES('S03', 'P02', 'J04', 200);
 73
 74INSERT INTO Shipments
 75  VALUES('S03', 'P02', 'J05', 200);
 76
 77INSERT INTO Shipments
 78  VALUES('S03', 'P02', 'J06', 100);
 79
 80INSERT INTO Shipments
 81  VALUES('S03', 'P02', 'J07', 200);
 82
 83INSERT INTO Shipments
 84  VALUES('S03', 'P02', 'J08', 400);
 85
 86INSERT INTO Shipments
 87  VALUES('S03', 'P02', 'J09', 300);
 88
 89INSERT INTO Shipments
 90  VALUES('S03', 'P02', 'J10', 200);
 91
 92INSERT INTO Shipments
 93  VALUES('S03', 'P02', 'J11', 200);
 94
 95INSERT INTO Shipments
 96  VALUES('S04', 'P02', 'J03', 200);
 97
 98INSERT INTO Shipments
 99  VALUES('S05', 'P01', 'J01', 200);
100
101INSERT INTO Shipments
102  VALUES('S05', 'P06', 'J04', 200);
103
104INSERT INTO Shipments
105  VALUES('S05', 'P07', 'J04', 200);
106
107INSERT INTO Shipments
108  VALUES('S06', 'P01', 'J04', 200);
109
110INSERT INTO Shipments
111  VALUES('S06', 'P01', 'J11', 200);
112
113INSERT INTO Shipments
114  VALUES('S07', 'P03', 'J02', 100);