SOSOS Database change Log

The database for version 3.x is not compatible with the 2.x database.  User of
previous versions should consider a side-by-side migration to the new database.

v3.2.0	5 Jul 09
	The following changes are required from the v3.1.0 release

	Add a column to the Devices table:
		Alter table Devices add Device_PnPDeviceID nvarchar(150) null

	Add a column to the Services table:
		Alter table Services add Service_AcctName nvarchar(100) null

v3.1.0	18 Jun 07
	The following changes are required from the v3.0.0 release

	Add a column to the Email table:
		Alter table Email add Email_ExchangeServer nvarchar(100) null

	Add a column to the PC table:
		Alter table PC add PC_SystemType nvarchar(50) null

	Add a column to the Devices table:
		Alter table Devices add Device_Status nvarchar(50) null

v3.0.0	3 Jul 06
	The following changes required from the v.0.9.9 Beta Release:

	Add a column to the PC table:
		Alter table PC add PC_JoinedDomain datetime null

	Add a new EventLogSettings table:
		CREATE TABLE EventLogSettings(
			ID_EventSettings nvarchar(50) NOT NULL,
			EventSettings_Logfile nvarchar(100) NOT NULL,
			EventSettings_CurrentSize int NULL DEFAULT ((0)),
			EventSettings_MaxSize int NULL DEFAULT ((0)),
			EventSettings_Retension int NULL DEFAULT ((0)),
			EventSettings_NumEntries int NULL DEFAULT ((0)),
			EventSettings_OldestEntry datetime NULL,
		CONSTRAINT EventLogSettings_PK PRIMARY KEY NONCLUSTERED 
		(
			ID_EventSettings ASC,
			EventSettings_Logfile ASC
		) ON [PRIMARY]
		) ON [PRIMARY]

	Add the foriegn key constraints for the new table:
		ALTER TABLE EventLogSettings WITH CHECK ADD CONSTRAINT [FK_EventLogSettings_SOS] FOREIGN KEY(ID_EventSettings)
		REFERENCES SOS (ID)
		ON DELETE CASCADE

V0.9.9	21 Jun 06
	Beta Release