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 | |
| 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')
| -rw-r--r-- | slips/build/sql/Data/authorize.sql.template | 4 | ||||
| -rw-r--r-- | slips/build/sql/Data/boat.sql.template | 5 | ||||
| -rw-r--r-- | slips/build/sql/Data/customer.sql.template | 4 | ||||
| -rw-r--r-- | slips/build/sql/Data/dock.sql.template | 6 | ||||
| -rw-r--r-- | slips/build/sql/Data/lease.sql.template | 4 | ||||
| -rw-r--r-- | slips/build/sql/Data/leasetype.sql.template | 7 | ||||
| -rw-r--r-- | slips/build/sql/Data/location.sql.template | 5 | ||||
| -rw-r--r-- | slips/build/sql/Data/slip.sql.template | 157 |
8 files changed, 192 insertions, 0 deletions
diff --git a/slips/build/sql/Data/authorize.sql.template b/slips/build/sql/Data/authorize.sql.template new file mode 100644 index 0000000..f1af498 --- /dev/null +++ b/slips/build/sql/Data/authorize.sql.template @@ -0,0 +1,4 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Authorize(UserName,Password,CustomerID) VALUES('jdoe','p@ssword',1000)
+GO
diff --git a/slips/build/sql/Data/boat.sql.template b/slips/build/sql/Data/boat.sql.template new file mode 100644 index 0000000..0387b5c --- /dev/null +++ b/slips/build/sql/Data/boat.sql.template @@ -0,0 +1,5 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Boat(RegistrationNumber,Manufacturer,ModelYear,Length,CustomerID)
+VALUES('AR8373-223-2','Yamaha',2005,18,1000)
+GO
\ No newline at end of file diff --git a/slips/build/sql/Data/customer.sql.template b/slips/build/sql/Data/customer.sql.template new file mode 100644 index 0000000..f069fa5 --- /dev/null +++ b/slips/build/sql/Data/customer.sql.template @@ -0,0 +1,4 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Customer(FirstName,LastName,Phone,City) VALUES('John','Doe','555-545-1212','Phoenix');
+GO
\ No newline at end of file diff --git a/slips/build/sql/Data/dock.sql.template b/slips/build/sql/Data/dock.sql.template new file mode 100644 index 0000000..55a4964 --- /dev/null +++ b/slips/build/sql/Data/dock.sql.template @@ -0,0 +1,6 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Dock(DockName, LocationId, WaterService, ElectricalService) VALUES('Dock A', 1, 1, 1)
+INSERT INTO Dock(DockName, LocationId, WaterService, ElectricalService) VALUES('Dock B', 1, 1, 0)
+INSERT INTO Dock(DockName, LocationId, WaterService, ElectricalService) VALUES('Dock C', 1, 0, 1)
+GO
\ No newline at end of file diff --git a/slips/build/sql/Data/lease.sql.template b/slips/build/sql/Data/lease.sql.template new file mode 100644 index 0000000..c85a53d --- /dev/null +++ b/slips/build/sql/Data/lease.sql.template @@ -0,0 +1,4 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Lease(StartDate,EndDate,SlipID,CustomerID,LeaseTypeID) VALUES('09-12-2007','09-12-2008',1030,1000,4)
+GO
\ No newline at end of file diff --git a/slips/build/sql/Data/leasetype.sql.template b/slips/build/sql/Data/leasetype.sql.template new file mode 100644 index 0000000..b3c85b3 --- /dev/null +++ b/slips/build/sql/Data/leasetype.sql.template @@ -0,0 +1,7 @@ +use [@initial.catalog@];
+GO
+INSERT INTO LeaseType(LeaseTypeName, StandardRateAmount) VALUES('Daily', 25.50)
+INSERT INTO LeaseType(LeaseTypeName, StandardRateAmount) VALUES('Weekly', 145.50)
+INSERT INTO LeaseType(LeaseTypeName, StandardRateAmount) VALUES('Monthly', 500.00)
+INSERT INTO LeaseType(LeaseTypeName, StandardRateAmount) VALUES('Yearly', 5000.00)
+GO
diff --git a/slips/build/sql/Data/location.sql.template b/slips/build/sql/Data/location.sql.template new file mode 100644 index 0000000..1e17c16 --- /dev/null +++ b/slips/build/sql/Data/location.sql.template @@ -0,0 +1,5 @@ +use [@initial.catalog@];
+GO
+INSERT INTO Location(LocationName) VALUES('Inland Lake')
+INSERT INTO Location(LocationName) VALUES('Sab Diego')
+GO
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
|