Use IssueVision
GO
-- IssueTypes
SET NOCOUNT ON
DELETE FROM [dbo].[IssueTypes]
GO
SET IDENTITY_INSERT [dbo].[IssueTypes] ON
GO
INSERT INTO [dbo].[IssueTypes]
([IssueTypeID], [IssueType])
SELECT 1, 'Telecommunications'
UNION ALL
SELECT 3, 'Computer'
UNION ALL
SELECT 5, 'Printer'
UNION ALL
SELECT 10, 'Network'
GO
SET IDENTITY_INSERT [dbo].[IssueTypes] OFF
SET NOCOUNT OFF
GO
-- Staffers
SET NOCOUNT ON
DELETE FROM [dbo].[Staffers]
GO
SET IDENTITY_INSERT [dbo].[Staffers] ON
GO
-- The unhashed password for all Staffers is 'password', except demo whose password is 'demo'
-- The PasswordHash has been created by taking the salt, appending the unhashed password and hashing it with SHA1
INSERT INTO [dbo].[Staffers]
([StafferID], [UserName], [PasswordHash], [PasswordSalt], [DisplayName], [StafferType])
SELECT 1, 'abarr', 'pWCsj910YW0E/VPjG7NNGkcvOr8=', 'TbWuXSzaVRw=', 'Adam Barr', 'H'
UNION ALL
SELECT 2, 'kabercrombie', 'A0rdUmWr+vx8ZiWuVkLXi+exwHI=', 'Ege0bGeWURU=', 'Kim Abercrombie', 'H'
UNION ALL
SELECT 3, 'ryoung', 'OIX1axF30WrzzwfcTC2+OYsSyhA=', 'VZogD+4seh8=', 'Rob Young', 'T'
UNION ALL
SELECT 4, 'tyoutsey', 'iaUDXfNJQxmnTLhxPdz1bRnYt/g=', 'mzTP0UOEFi0=', 'Tom Youtsey', 'H'
UNION ALL
SELECT 5, 'gyukish', 'XP+47Xfymksyweki/SHFI0T9cvM=', 'SR4FF/JjDMU=', 'Gary W. Yukish', 'T'
UNION ALL
SELECT 6, 'rcaron', 'tsEQw5ZqGTlWeNZtVc7rfJK2Eww=', '4SuuM3aDT2c=', 'Rob Caron', 'T'
UNION ALL
SELECT 7, 'kzimprich', '6mh4Gd4MxQ0BMc/fb5Q9buBpQjw=', 'AiXA1uF2IRo=', 'Karin Zimprich', 'H'
UNION ALL
SELECT 8, 'rboseman', 'BhwJdIw2pfVc9+C9qP2oOB1pSbg=', 'x/KklEUhGTw=', 'Randall Boseman', 'T'
UNION ALL
SELECT 9, 'kkennedy', 'xzSDFNKk9O4VXE+I96R5cSpe9Yc=', '1FLjk5r9gAs=', 'Kevin Kennedy', 'H'
UNION ALL
SELECT 10, 'dtibbott', 'w+XzHeIvQi92iQeo2PV3QI2ZTFE=', 'fex/UMYGwns=', 'Diane Tibbott', 'H'
UNION ALL
SELECT 11, 'gyoung', 'zGbvIP9USKTYM9UrR61R9AkkfEY=', 'KTxCXJMniCM=', 'Garrett Young', 'T'
UNION ALL
SELECT 12, 'demo', 'L0/YuWiMT78xMewOsQlxIUx+E8w=', 'qR9EK6wNB/k=', 'Demo', 'T'
GO
SET IDENTITY_INSERT [dbo].[Staffers] OFF
SET NOCOUNT OFF
GO
-- Issues
SET NOCOUNT ON
DELETE FROM [dbo].[Issues]
GO
SET IDENTITY_INSERT [dbo].[Issues] ON
GO
INSERT INTO [dbo].[Issues]
([IssueID], [StafferID], [IssueTypeID], [Title], [Description], [DateOpened], [DateClosed], [IsOpen], [DateModified])
SELECT 12, 1, 3, 'Computer won''t shut down', 'Computer just hangs after clicking Shut Down. User must manually turn computer off.', '20031229 4:03:42 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 13, 2, 1, 'Voice mail password doesn''t work', 'The user went away on vacation and came back to find that his voice mail password didn''t work.', '20031229 4:07:13 PM', NULL, 1, '20040110 10:09:11 AM'
UNION ALL
SELECT 14, 3, 10, 'User can''t log into network', 'The user gets a message that her account has been locked.', '20031229 4:09:54 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 15, 2, 5, 'HERCULES printer driver not installed', 'The user gets a message that the driver for printer HERCULES is not installed.', '20031229 4:12:33 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 16, 1, 10, 'User''s VPN access not working', 'The user''s home computer can''t connect to the VPN server remotely.', '20031229 4:14:08 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 17, 3, 1, '9 key not working', 'The 9 key on the user''s telephone does not work.', '20031229 4:15:19 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 18, 2, 3, 'Needs an upgrade to Office 2003', 'Authorized and requested by department head.', '20031229 4:17:25 PM', NULL, 1, '20040110 9:50:37 AM'
UNION ALL
SELECT 19, 1, 1, 'Voice mail light does not work', '', '20040111 12:41:55 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 20, 2, 10, 'Laptop in cubicle 119 can''t access the WiFi network', 'The laptop is 802.11a enabled.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 21, 3, 3, 'Docking station in cubicle 37 doesn''t work', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 22, 4, 1, 'Phone at cubicle 217 has an echo when dialing out', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 23, 5, 5, 'Printer Zeus has run out of legal size paper', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 24, 6, 10, 'Network load balancer is not seeing server #9', 'Server #9 was re-imaged last week.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 25, 7, 1, 'People on the other end of the line can''t hear when the speaker phone is turned on', 'It works fine using the handset or a headset.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 26, 8, 3, 'Graphics station in cubicle 79 needs an upgrade to a 20 inch monitor', 'This has already been approved.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 27, 9, 10, 'Firewall is blocking instant messenger', 'Neither Yahoo nor AOL work. MSN does however.', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 28, 10, 5, 'Printer Apollo is low on toner', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 29, 11, 3, 'Cubicle 597 needs a developer workstation', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
UNION ALL
SELECT 30, 12, 5, 'The printer in cubicle 18 needs to be moved to cubicle 67A', '', '20040111 12:41:56 PM', NULL, 1, '20040111 12:41:56 PM'
GO
SET IDENTITY_INSERT [dbo].[Issues] OFF
SET NOCOUNT OFF
GO
-- IssueHistory
SET NOCOUNT ON
DELETE FROM [dbo].[IssueHistory]
GO
SET IDENTITY_INSERT [dbo].[IssueHistory] ON
GO
INSERT INTO [dbo].[IssueHistory]
([IssueHistoryID], [StafferID], [IssueID], [Comment], [DateCreated])
SELECT 11, 1, 12, 'Issue created.', '20031229 4:03:42 PM'
UNION ALL
SELECT 12, 2, 13, 'Issue created.', '20031229 4:07:13 PM'
UNION ALL
SELECT 13, 3, 14, 'Issue created.', '20031229 4:09:54 PM'
UNION ALL
SELECT 14, 2, 15, 'Issue created.', '20031229 4:12:33 PM'
UNION ALL
SELECT 15, 1, 16, 'Issue created.', '20031229 4:14:08 PM'
UNION ALL
SELECT 16, 3, 17, 'Issue created.', '20031229 4:15:19 PM'
UNION ALL
SELECT 17, 2, 18, 'Issue created.', '20031229 4:17:25 PM'
UNION ALL
SELECT 18, 12, 13, 'test', '20040110 10:09:11 AM'
UNION ALL
SELECT 19, 1, 19, 'Issue created.', '20040111 12:41:55 PM'
UNION ALL
SELECT 20, 2, 20, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 21, 3, 21, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 22, 4, 22, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 23, 5, 23, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 24, 6, 24, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 25, 7, 25, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 26, 8, 26, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 27, 9, 27, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 28, 10, 28, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 29, 11, 29, 'Issue created.', '20040111 12:41:56 PM'
UNION ALL
SELECT 30, 12, 30, 'Issue created.', '20040111 12:41:56 PM'
GO
SET IDENTITY_INSERT [dbo].[IssueHistory] OFF
SET NOCOUNT OFF
GO
Submit an article or tip