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

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