Rough upgrade notes for Lighthouse pro - version 2.1.006 to 2.3
I've just upgraded Ray Camdens Lighthouse Pro project from version 2.1.006 to 2.3 and here are some rough notes:
Alter all tables to have prefix lh_
CREATE TABLE [dbo].[lh_issuetypes] (
[id] [nvarchar] (35) NOT NULL ,
[name] [nvarchar] (50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lh_issuetypes] WITH NOCHECK ADD
CONSTRAINT [PK_lh_issuetypes] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
[id] [nvarchar] (35) NOT NULL ,
[name] [nvarchar] (50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[lh_issuetypes] WITH NOCHECK ADD
CONSTRAINT [PK_lh_issuetypes] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
Add default bugs (Bug, Enhancement) to table lh_issuetypes
Add columns to table lh_issues
issuetypeidfk nvarchar 35
creatoridfk nvarchar 35
allow isBug to have null values
Add columns to table lh_projects
[mailserver] [nvarchar] (255) NOT NULL,
[mailusername] [nvarchar] (255) NOT NULL,
[mailpassword] [nvarchar] (255) NOT NULL,
[mailemailaddress] [nvarchar] (255) NOT NULL
Run update page: /install/update2.2.cfm
Make sure that the collation is correct on the new table.
