summaryrefslogtreecommitdiff
path: root/slips/build/sql/Data/slip.sql.template
diff options
context:
space:
mode:
authormokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219>2009-02-21 21:44:27 +0000
committermokhan <mokhan@da190166-9cfc-4ee1-ae03-434a172be219>2009-02-21 21:44:27 +0000
commit1dfdccb8118aeaa3cd844ac8de2a672c93312166 (patch)
tree4b19e7f816ab1019f180a46b68572af4b66fe4bc /slips/build/sql/Data/slip.sql.template
parent42d66bcab8262c7b8b2452615df535e694a3ec1c (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.template157
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