diff options
| author | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
|---|---|---|
| committer | mokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219> | 2009-02-21 21:44:27 +0000 |
| commit | 1dfdccb8118aeaa3cd844ac8de2a672c93312166 (patch) | |
| tree | 4b19e7f816ab1019f180a46b68572af4b66fe4bc /slips/build/sql/Data/slip.sql.template | |
| parent | 42d66bcab8262c7b8b2452615df535e694a3ec1c (diff) | |
git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219
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
|
