| /trunk/RMH.DataAccess/AdoNet/Scripts/FakeStayData.sql r2 | /trunk/RMH.DataAccess/AdoNet/Scripts/DDL-Update.sql r5 | ||
| 1 | INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate) | 1 | |
|---|---|---|---|
| 2 | VALUES(2,3,'2009-01-05','2009-01-17') | 2 | ALTER TABLE County ALTER COLUMN Name varchar(32) |
| 3 | 3 | ALTER TABLE Diagnosis ALTER COLUMN Name varchar(128) | |
| 4 | INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate) | 4 | ALTER TABLE Note ALTER COLUMN Body varchar(8000) |
| 5 | VALUES(3,3,'2009-01-05','2009-01-17') | 5 | CREATE NONCLUSTERED INDEX IX_DiagnosisName ON dbo.Diagnosis (Name) |
| 6 | 6 | CREATE NONCLUSTERED INDEX IX_PaymentBilling ON dbo.Payment (BillingDate) | |
| 7 | INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate) | 7 | CREATE NONCLUSTERED INDEX IX_PaymentBillingRecievedDate ON dbo.Payment (ReceivedDate) |
| 8 | VALUES(3,3,'2009-01-23','2009-01-27') | 8 | |
| 9 | 9 | ALTER TABLE Person ALTER COLUMN FirstName varchar(128) | |
| 10 | INSERT INTO Stay(Patient_id,Room_id,CheckinDate,CheckoutDate) | 10 | ALTER TABLE Person ALTER COLUMN LastName varchar(128) |
| 11 | VALUES(4,3,'2009-02-11','2009-02-14') | 11 | ALTER TABLE Person ALTER COLUMN MiddleName varchar(128) |
| 12 | ALTER TABLE Person ALTER COLUMN State varchar(2) | ||
| 13 | |||
| 14 | CREATE NONCLUSTERED INDEX IX_PersonFirstName ON dbo.Person (FirstName) | ||
| 15 | CREATE NONCLUSTERED INDEX IX_PersonLastName ON dbo.Person (LastName) | ||
| 16 | |||
| 17 | ALTER TABLE Note ALTER COLUMN Body varchar(8000) | ||
| 18 | |||
| 19 | ALTER TABLE Payment ALTER COLUMN Method varchar(32) | ||
| 20 | ALTER TABLE Payment ALTER COLUMN Type varchar(32) | ||
| 21 | |||
| 22 | |||
| 23 | CREATE NONCLUSTERED INDEX IX_PaymentBillingDate ON dbo.Payment (BillingDate) | ||
| 24 | CREATE NONCLUSTERED INDEX IX_PaymentReceivedDate ON dbo.Payment (ReceivedDate) | ||
