-- Dieses Update hebt die Datenbank auf DK Verarbeitung an ( Version 3.5)
-- Version 4.0 sind dann die Änderungen für NSW 2017

PRINT N'Altering [dbo].[NOA_NOD]...';
GO
ALTER TABLE [dbo].[NOA_NOD] ADD [IsAnchored] BIT NULL;
GO

PRINT N'Altering [dbo].[INFO]...';
GO
ALTER TABLE [dbo].[INFO] ADD [PortFacility] NVARCHAR(10) NULL;
GO

PRINT N'Altering [dbo].[PRE72H]...';
GO
ALTER TABLE [dbo].[PRE72H] ADD [IsDueToInspection] BIT NULL;
ALTER TABLE [dbo].[PRE72H] ADD [PossibleAnchorage] BIT NULL;
GO

PRINT N'Altering [dbo].[BPOL]...';
GO
ALTER TABLE [dbo].[BPOL] ADD [CruiseShip] BIT NULL;
GO

PRINT N'Altering [dbo].[PortOfItinerary]...';
GO
ALTER TABLE [dbo].[PortOfItinerary] ADD [PortOfItineraryLocode] CHAR(5) NULL;
GO

PRINT N'Altering [dbo].[WAS]...';
GO
ALTER TABLE [dbo].[WAS] ADD [ConfirmationOfSufficiency] BIT NULL;
GO

PRINT N'Altering [dbo].[SEC]...';
GO
ALTER TABLE [dbo].[SEC] ADD [MatterToReport] NVARCHAR(1024) NULL;
GO

PRINT N'Altering [dbo].[STAT]...';
GO
ALTER TABLE [dbo].[STAT] ADD NetTonnage [FLOAT] NULL;
ALTER TABLE [dbo].[STAT] ADD RegistryDate [DATETIME] NULL;
ALTER TABLE [dbo].[STAT] ADD CertificateOfRegistryNumber NVARCHAR(64) NULL;
GO

PRINT N'Creating [dbo].[STO]..';
GO
CREATE TABLE [dbo].[STO] (
    [Id] UNIQUEIDENTIFIER CONSTRAINT [PK_STO_Id] DEFAULT (newid()) ROWGUIDCOL NOT NULL  ,
	[MessageHeaderId] [uniqueidentifier] NULL,
	[Name] [NVARCHAR] (255) NULL,
	[Quantity] [INT] NULL,
	[QuantityUnit] [NVARCHAR] (16) NULL,
	[LocationOnBoard] [NVARCHAR] (64) NULL,
	[OfficialUse] [NVARCHAR] (16) NULL,
	[Identifier] [NVARCHAR] (50) NULL
);
GO

PRINT N'Update complete.';
GO