diff options
Diffstat (limited to 'slips/build/sql/Data/slip.sql.template')
| -rw-r--r-- | slips/build/sql/Data/slip.sql.template | 157 |
1 files changed, 157 insertions, 0 deletions
diff --git a/slips/build/sql/Data/slip.sql.template b/slips/build/sql/Data/slip.sql.template new file mode 100644 index 0000000..8b70a03 --- /dev/null +++ b/slips/build/sql/Data/slip.sql.template @@ -0,0 +1,157 @@ +use [@initial.catalog@];
+GO
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,1)
+
+-- Dock B slips
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,16,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,18,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(8,20,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,26,2)
+
+-- Dock C slips
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,22,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(10,24,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+INSERT INTO SLIP(SlipWidth, SlipLength, DockId) VALUES(12,28,3)
+GO
|