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/authorize.sql.template | 4 + slips/build/sql/Data/boat.sql.template | 5 + slips/build/sql/Data/customer.sql.template | 4 + slips/build/sql/Data/dock.sql.template | 6 ++ slips/build/sql/Data/lease.sql.template | 4 + slips/build/sql/Data/leasetype.sql.template | 7 ++ slips/build/sql/Data/location.sql.template | 5 + slips/build/sql/Data/slip.sql.template | 157 ++++++++++++++++++++++++++++ 8 files changed, 192 insertions(+) create mode 100644 slips/build/sql/Data/authorize.sql.template create mode 100644 slips/build/sql/Data/boat.sql.template create mode 100644 slips/build/sql/Data/customer.sql.template create mode 100644 slips/build/sql/Data/dock.sql.template create mode 100644 slips/build/sql/Data/lease.sql.template create mode 100644 slips/build/sql/Data/leasetype.sql.template create mode 100644 slips/build/sql/Data/location.sql.template create mode 100644 slips/build/sql/Data/slip.sql.template (limited to 'slips/build/sql/Data') 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 -- cgit v1.2.3