INSERT INTO ValueListGroup ([Name],[Description]) VALUES
	('TimeZones','TimeZones'),
	('Status','Status')
GO

INSERT INTO ValueList ([GroupID], [Value],[AltValue],[SortOrder]) VALUES
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'Hawaiian Standard Time','(UTC-10:00) Hawaii', 9),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'UTC-08','(UTC-08:00) Coordinated Universal Time-08',8),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'Pacific Standard Time','(UTC-08:00) Pacific Time (US & Canada)',7),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'US Mountain Standard Time','(UTC-07:00) Arizona',6),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'Mountain Standard Time','(UTC-07:00) Mountain Time (US & Canada)',5),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'Central Standard Time','(UTC-06:00) Central Time (US & Canada)',4),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'Eastern Standard Time','(UTC-05:00) Eastern Time (US & Canada)',3),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'US Eastern Standard Time','(UTC-05:00) Indiana (East)',2),
((SELECT ID FROM ValueListGroup WHERE Name = 'TimeZones'),'UTC','(UTC) Coordinated Universal Time',1),
((SELECT ID FROM ValueListGroup WHERE Name = 'Status'),'Active',NULL,1),
((SELECT ID FROM ValueListGroup WHERE Name = 'Status'),'Retired',NULL,1),
((SELECT ID FROM ValueListGroup WHERE Name = 'Status'),'Planned',NULL,1),
((SELECT ID FROM ValueListGroup WHERE Name = 'Status'),'Repair',NULL,1)
GO