From 1dfdccb8118aeaa3cd844ac8de2a672c93312166 Mon Sep 17 00:00:00 2001 From: mokhan Date: Sat, 21 Feb 2009 21:44:27 +0000 Subject: git-svn-id: http://svn.xp-dev.com/svn/mokhan-sait@2 da190166-9cfc-4ee1-ae03-434a172be219 --- slips/build/sql/Data/slip.sql.template | 157 +++++++++++++++++++++++++++++++++ 1 file changed, 157 insertions(+) create mode 100644 slips/build/sql/Data/slip.sql.template (limited to 'slips/build/sql/Data/slip.sql.template') 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 -- cgit v1.2.3