GUS-3.6-SQL-Other

GUS-3.6-SQL-Other

Other Object Changes for GUS 3.6

Sequences

TESS:

CREATE SEQUENCE TESS.ANALYSIS_SQ start with 1;
CREATE SEQUENCE TESS.ANALYSISINPUT_SQ start with 1;
CREATE SEQUENCE TESS.ANALYSISPARAM_SQ start with 1;
CREATE SEQUENCE TESS.ANALYSISQCPARAM_SQ start with 1;
CREATE SEQUENCE TESS.ARCHIPELAGOOFINTEREST_SQ start with 1;
CREATE SEQUENCE TESS.ISLANDOFINTEREST_SQ start with 1;
CREATE SEQUENCE TESS.LOGICALGROUP_SQ start with 1;
CREATE SEQUENCE TESS.LOGICALGROUPLINK_SQ start with 1;
CREATE SEQUENCE TESS.MODELPREDECESSORGRAPH_SQ start with 1;
CREATE SEQUENCE TESS.MODELRELATION_SQ start with 1;
CREATE SEQUENCE TESS.PERFORMANCEPOINT_SQ start with 1;
CREATE SEQUENCE TESS.PERFORMANCEPTPARAMVALUE_SQ start with 1;
CREATE SEQUENCE TESS.PERFORMANCERESULT_SQ start with 1;
CREATE SEQUENCE TESS.PERFORMANCESUMMARYSTAT_SQ start with 1;
CREATE SEQUENCE TESS.PREDICTEDBINDINGSITE_SQ start with 1;
CREATE SEQUENCE TESS.REGIONOFINTEREST_SQ start with 1;
CREATE SEQUENCE TESS.SBCGRECOGMULTIOBS_SQ start with 1;
CREATE SEQUENCE TESS.SEQUENCEFEATURE_SQ start with 1;
CREATE SEQUENCE TESS.SEQUENCEFEATURERELATION_SQ start with 1;
CREATE SEQUENCE TESS.TRAININGSET_SQ start with 1;

DOTS

Verify this first:

CREATE OR REPLACE VIEW DoTSVer.stsver AS
SELECT
NA_Feature_ID,
NA_SEQUENCE_ID,
SUBCLASS_VIEW,
NAME,
SEQUENCE_ONTOLOGY_ID,
PARENT_ID,
EXTERNAL_DATABASE_RELEASE_ID,
SOURCE_ID,
PREDICTION_ALGORITHM_ID,
IS_PREDICTED,
REVIEW_STATUS_ID,
STRING1 AS CITATION,
STRING2 AS EVIDENCE,
STRING3 AS GENE,
STRING4 AS LABEL,
STRING5 AS MAP,
STRING6 AS PARTIAL,
STRING7 AS STANDARD_NAME,
STRING8 AS USEDIN,
tinyint1 AS IS_PARTIAL,
MODIFICATION_DATE,
USER_READ,
USER_WRITE,
GROUP_READ,
GROUP_WRITE,
OTHER_READ,
OTHER_WRITE,
ROW_USER_ID,
ROW_GROUP_ID,
ROW_PROJECT_ID,
ROW_ALG_INVOCATION_ID,
VERSION_ALG_INVOCATION_ID,
VERSION_DATE,
VERSION_TRANSACTION_ID
FROM DoTSVer.NAFeatureImpVer
WHERE subclass_view='STS'
WITH CHECK OPTION;