Database Upgrade 8.3.6

MS SQL

ALTER TABLE MDE ADD LINKEDCDEID [Numeric](18, 0) NULL DEFAULT (NULL)

CREATE TABLE [dbo].[LC_TEST_ALIAS](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [TESTID] [Numeric](18, 0) NULL DEFAULT NULL,
                [ALIASNAME] [nvarchar](50) NULL DEFAULT (NULL)) ON [PRIMARY]

CREATE TABLE [dbo].[LC_TESTGROUP](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [NAME] [nvarchar](50) NULL,
                [DESCRIPTION] [nvarchar](500) NULL,
                [UD1] [nvarchar](100) NULL DEFAULT (NULL),
                [UD2] [nvarchar](100) NULL DEFAULT (NULL),
                [UD3] [nvarchar](100) NULL DEFAULT (NULL),
                [UD4] [nvarchar](100) NULL DEFAULT (NULL),
                [UD5] [nvarchar](100) NULL DEFAULT (NULL)) ON [PRIMARY]

CREATE TABLE [dbo].[LOCATION_ALIAS](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [LOCID] [Numeric](18, 0) NULL DEFAULT NULL,
                [ALIASNAME] [nvarchar](100) NULL DEFAULT (NULL)) ON [PRIMARY]

Oracle

ALTER TABLE MDE ADD LINKEDCDEID NUMBER NULL

CREATE TABLE "LC_TEST_ALIAS" 
                 ("ID" NUMBER NOT NULL, 
                "AUDITUSER" VARCHAR2(50) NULL, 
                "AUDITTIMESTAMP" DATE DEFAULT NULL, 
                "TESTID" NUMBER DEFAULT NULL,
                "ALIASNAME" NVARCHAR2 (50) NULL)
           

CREATE SEQUENCE "A_LC_TEST_ALIAS" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER

CREATE TRIGGER "T_LC_TEST_ALIAS" BEFORE INSERT ON "LC_TEST_ALIAS" FOR EACH ROW BEGIN SELECT "A_LC_TEST_ALIAS".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_EVENTTRIGGERS;

CREATE TABLE "LC_TESTGROUP" 
                 ("ID" NUMBER NOT NULL,
                "AUDITUSER" VARCHAR2(50) NULL,
                "AUDITTIMESTAMP" DATE DEFAULT NULL,
                "NAME" NVARCHAR2 (50) NULL,
                "DESCRIPTION" NVARCHAR2 (500) NULL,
                "UD1" NVARCHAR2 (100) NULL,
                "UD2" NVARCHAR2 (100) NULL,
                "UD3" NVARCHAR2 (100) NULL,
                "UD4" NVARCHAR2 (100) NULL,
                "UD5" NVARCHAR2 (100) NULL)
                

CREATE SEQUENCE "A_LC_TESTGROUP" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER

CREATE TRIGGER "T_LC_TESTGROUP" BEFORE INSERT ON "LC_TESTGROUP" FOR EACH ROW BEGIN SELECT "A_LC_TESTGROUP".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LC_TESTGROUP;
           

CREATE TABLE "LOCATION_ALIAS"
                " ("ID" NUMBER NOT NULL,
                "AUDITUSER" VARCHAR2(50) NULL,
                "AUDITTIMESTAMP" DATE DEFAULT NULL,
                "LOCID" NUMBER DEFAULT NULL,
                "ALIASNAME" NVARCHAR2 (50) NULL)
             

CREATE SEQUENCE "A_LOCATION_ALIAS" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER

CREATE TRIGGER "T_LOCATION_ALIAS" BEFORE INSERT ON "LOCATION_ALIAS" FOR EACH ROW BEGIN SELECT "A_LC_TEST_ALIAS".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LOCATION_ALIAS;