63 lines
1.6 KiB
Transact-SQL
63 lines
1.6 KiB
Transact-SQL
-- 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
|