use conservation_resources

BEGIN TRANSACTION updateGRAS_PCI_Indicator_ratings
ALTER TABLE gras.d_pci_indicator_ratings
	ALTER COLUMN choice_label VarChar(5) NOT NULL;
GO

INSERT INTO gras.d_pci_indicator_ratings VALUES(61, 12, 'Wind erosion', 6, -1, 'NA', 'Not applicable', 0);
INSERT INTO gras.d_pci_indicator_ratings VALUES(67, 13, 'Streambank and shoreline erosion', 6, -1, 'NA', 'Not applicable', 0);
INSERT INTO gras.d_pci_indicator_ratings VALUES(73, 14, 'Gully erosion', 6, -1, 'NA', 'Not applicable', 0);

COMMIT TRANSACTION updateGRAS_PCI_Indicator_ratings