Tech Notes:

SQL Server Scripts:

OPSROOT

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

FACILITY DATABASES

ALTER TABLE MDE ADD STARTHOUR numeric (18, 0) NULL

ALTER TABLE SPFORMS ADD AUTOEXPORT numeric (18, 0) NULL

ALTER TABLE SPFORMS ADD AUTOEXPORTOPTIONS [nvarchar](2000) NULL

CREATE TABLE [dbo].[VGROUP]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[VGROUPNAME] [nvarchar](255) NULL,[PARENTID] [int] NULL,) ON [PRIMARY]

CREATE TABLE [dbo].[VGROUPACCESS]([AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[VGROUPID] [numeric](18, 0) NOT NULL,[USERID] [numeric](18, 0) NOT NULL,[ACCESSLEVEL] [numeric](18, 0),) ON [PRIMARY]

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

CREATE TABLE [dbo].[SAMPLEREQDETAIL]([AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[ID] [int] IDENTITY(1,1) NOT NULL,[SRID] [numeric](18, 0) NOT NULL,[STARTDATE] [datetime] NOT NULL,[ENDDATE] [datetime] NOT NULL,[NUMREQ] [numeric](18, 0) NOT NULL,[GROUPING] [nvarchar](50) NOT NULL) ON [PRIMARY]

ORACLE:

OPSROOT

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

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

CREATE TRIGGER "T_LIB_PARM" BEFORE INSERT ON "LIB_PARM" FOR EACH ROW BEGIN SELECT "A_LIB_PARM".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LIB_PARM;

FACILITY DATABASES

ALTER TABLE MDE ADD STARTHOUR NUMBER NULL

ALTER TABLE SPFORMS ADD AUTOEXPORT NUMBER NULL

ALTER TABLE SPFORMS ADD AUTOEXPORTOPTIONS NVARCHAR2(2000) NULL

CREATE TABLE "VGROUP" ("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "VGROUPNAME" NVARCHAR2 (255) NULL,"PARENTID" NUMBER NULL)

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

CREATE TRIGGER "T_VGROUP" BEFORE INSERT ON "VGROUP" FOR EACH ROW BEGIN SELECT "A_VGROUP".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_VGROUP;

CREATE TABLE "VGROUPACCESS" ("AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "VGROUPID" NUMBER NOT NULL,"USERID" NUMBER NOT NULL,"ACCESSLEVEL" NUMBER NOT NULL)

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

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

CREATE TRIGGER "T_SAMPLEREQ" BEFORE INSERT ON "SAMPLEREQ" FOR EACH ROW BEGIN SELECT "A_SAMPLEREQ".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_SAMPLEREQ;

CREATE TABLE "SAMPLEREQDETAIL" ("ID" NUMBER NOT NULL, "SRID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "STARTDATE" DATE DEFAULT NULL, "ENDDATE" DATE DEFAULT NULL, "NUMREQ" NUMBER NOT NULL,"GROUPING" NVARCHAR2 (50) NULL)

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

CREATE TRIGGER "T_SAMPLEREQDETAIL" BEFORE INSERT ON "SAMPLEREQDETAIL" FOR EACH ROW BEGIN SELECT "A_SAMPLEREQDETAIL".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_SAMPLEREQDETAIL;