source: EDIS/tags/ed/tracking-autologin-files/SiteMapperTableData/SiteMapperTable_SQL.txt@ 1240

DROP TABLE EDP.SiteMapper

CREATE TABLE EDP.SiteMapper(
siteCode VARCHAR(30) NOT NULL, 
sitePrefix VARCHAR(100) NOT NULL UNIQUE
)

DELETE FROM EDP.SiteMapper
DELETE FROM EDP.SiteMapper where sitePrefix='ISL'


INSERT INTO EDP.SiteMapper VALUES('442','ISL-DHARS1-LT.vha.med.va.gov')

UPDATE EDP.SiteMapper SET sitePrefix='ISL' WHERE siteCode='442'

select siteCode from EDP.SiteMapper where sitePrefix='ISL-DHARS1-LT.vha.med.va.gov'












DROP TABLE EDP.SiteMapper

CREATE TABLE EDP.SiteMapper(
siteCode VARCHAR(30) NOT NULL, 
sitePrefix VARCHAR(100) NOT NULL UNIQUE
)


INSERT INTO EDP.SiteMapper VALUES('442','ISL')
INSERT INTO EDP.SiteMapper VALUES('660','MOC')