Tech Notes:

SQL Server Scripts:

CREATE TABLE [dbo].[IMPORTPASTESETTINGS](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [NAME] [nvarchar](255) NULL,
                [OPTION] [numeric](18, 0) NULL,
                [VARLIST] [nvarchar](4000) NULL,
                ) ON [PRIMARY]

ALTER TABLE MDE ADD DATAJUSTIFY NUMERIC NULL DEFAULT (NULL)
UPDATE MDE SET DATAJUSTIFY=1

ALTER TABLE SPRPTS ALTER COLUMN REPORTDESC NVARCHAR(2000)

ALTER TABLE HDEVARS ADD COLWIDTHTIME [float] NULL DEFAULT (NULL)
ALTER TABLE HDEVARS ADD COLWIDTHVALUE [float] NULL DEFAULT (NULL)

ALTER TABLE LIMITS ADD LIMIT_VALUE_DISPLAY [nvarchar](255) NULL DEFAULT (NULL)
UPDATE LIMITS SET LIMIT_VALUE_DISPLAY = LIMIT_VALUE

ALTER TABLE LC_TESTQC ADD INPUTVARID  [numeric](18, 0) NULL

ALTER TABLE LC_BATCHTEMPLATEQC ADD INPUTVARID  [numeric](18, 0) NULL
SP_RENAME 'LC_BATCHTEMPLATEQC.VARID','QCCALCVARID','COLUMN'

ALTER TABLE LC_SAMPLETEST ADD BATCHQCVARID  [numeric](18, 0) NULL
ALTER TABLE LC_SAMPLETEST ADD BATCHQCTEXTRESULT [nvarchar](255) NULL DEFAULT (NULL)

ALTER TABLE LC_BATCH ADD TEMPLATEID [Numeric](18, 0)  NULL DEFAULT (NULL)

INSERT INTO LC_REJECTIONCODES (AuditUser,AuditTimeStamp,Code,Description,Recorder) VALUES ('UP814',GETDATE(),'ND','No Discharge',17)

Oracle Scripts:

CREATE TABLE "IMPORTPASTESETTINGS"
                ID"  NUMBER NOT NULL, 
                "AUDITUSER" VARCHAR2(50) NULL,                 
                "AUDITTIMESTAMP"  DATE DEFAULT NULL, 
                "NAME" NVARCHAR2 (100) NULL, 
                "OPTION" NUMBER DEFAULT 0 NULL,
                "VARLIST" NVARCHAR2(2000) DEFAULT NULL)

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

CREATE TRIGGER  "T_IMPORTPASTESETTINGS"  BEFORE INSERT ON "IMPORTPASTESETTINGS"  FOR EACH ROW BEGIN SELECT "A_IMPORTPASTESETTINGS" .NEXTVAL INTO :NEW."ID" FROM DUAL; END T_IMPORTPASTESETTINGS;

ALTER TABLE MDE ADD DATAJUSTIFY NUMBER DEFAULT NULL
UPDATE MDE SET DATAJUSTIFY=1

ALTER TABLE SPRPTS MODIFY(REPORTDESC NVARCHAR2(1000))

ALTER TABLE HDEVARS ADD COLWIDTHTIME NUMBER NULL
ALTER TABLE HDEVARS ADD COLWIDTHVALUE NUMBER NULL

UPDATE LIMITS SET LIMIT_VALUE_DISPLAY = LIMIT_VALUE

ALTER TABLE LC_TESTQC ADD INPUTVARID NUMBER NULL

ALTER TABLE LC_BATCHTEMPLATEQC ADD INPUTVARID NUMBER NULL

ALTER TABLE VARDESC RENAME COLUMN VARID to QCCALCVARID

ALTER TABLE LC_SAMPLETEST ADD BATCHQCTEXTRESULT NVARCHAR2(255) NULL

INSERT INTO LC_REJECTIONCODES (AuditUser,AuditTimeStamp,Code,Description,Recorder) VALUES ('UP814',SYSDATE,'ND','No Discharge',17)