--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: JSM
--    
--    (c) Copyright IBM Corp. 2003, 2010.
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    


-------------------------------------------------------------------------------
-- NC304_UPDATE_ORA.SQL	       *DO NOT EDIT*		Data Store Version: 306		 
-------------------------------------------------------------------------------

ALTER TABLE NC_AGGREGATE_RULE_TREE
   DROP CONSTRAINT F2N_AGGREGATE_RULE;

ALTER TABLE NC_AGGREGATE_RULE_TREE
   DROP CONSTRAINT F1N_AGGREGATE_RULE;

ALTER TABLE NC_BIETOPIC
   DROP CONSTRAINT F5N_BIETOPIC;

ALTER TABLE NC_BIETOPIC
   DROP CONSTRAINT F2N_BIETOPIC;

ALTER TABLE NC_DATAMAPPING
   DROP CONSTRAINT F9N_DATAMAPPING;

ALTER TABLE NC_DATAMAPPING
   DROP CONSTRAINT F5N_DATAMAPPING;

ALTER TABLE NC_DYN_DELIVERY_INFO_STRUCT
   DROP CONSTRAINT F2N_DYN_DELIVERY_I;

ALTER TABLE NC_EXECUTABLE
   DROP CONSTRAINT F7N_EXECUTABLE;

ALTER TABLE NC_MESSAGESTRUCT
   DROP CONSTRAINT F2N_MESSAGESTRUCT;

ALTER TABLE NC_MESSAGE_ATTACHMENT
   DROP CONSTRAINT F2N_MESSAGE_ATTACH;

ALTER TABLE R_AGENT_ESCALATIONAGENT
   DROP CONSTRAINT F2R_AGENT_ESCALATI;

ALTER TABLE R_DS_MACHINE_DSPOOL
   DROP CONSTRAINT F3R_DS_MACHINE_DSP;

ALTER TABLE R_DS_MACHINE_DSPOOL
   DROP CONSTRAINT F2R_DS_MACHINE_DSP;

ALTER TABLE R_MSGSTRUCT_AVOIDTOPICS
   DROP CONSTRAINT F1R_MSGSTRUCT_AVOI;

ALTER TABLE R_NEWSVIEWS_NCOBJECTS
   DROP CONSTRAINT F2R_NEWSVIEWS_NCOB;

ALTER TABLE R_RECIPIENT_ACCMANUSERID
   DROP CONSTRAINT F1R_RECIPIENT_ACCM;

ALTER TABLE R_RULE_PARAMETER
   DROP CONSTRAINT F1R_RULE_PARAMETER;

-------------------------------------------------------------------------------
--$130-- views drop begin
-------------------------------------------------------------------------------

DROP VIEW V_ACCMANUSER;

DROP VIEW V_BIECALC_LINK;

DROP VIEW V_NC_RULE_LINK;

DROP VIEW V_NC_TASK_LINK;

DROP VIEW V_NC_TASK;

DROP VIEW V_NC_AGENT_LOG_BASE;

DROP VIEW V_NC_AGENT_LOG;

DROP VIEW V_BIE_COMPLETE;

-------------------------------------------------------------------------------
--$140-- tables drop begin
-------------------------------------------------------------------------------

DROP TABLE NC_ACCMAN_TEMP_STORE;

DROP TABLE NC_ADMINISTRATOR;

DROP TABLE NC_AGENT_MESSAGE;

DROP TABLE NC_AGGREGATE_RULE_TREE;

DROP TABLE NC_BIE;

DROP TABLE NC_BIECALC;

DROP TABLE NC_BIETOPIC;

DROP TABLE NC_COGNOS_DS;

DROP TABLE NC_CONFIG_DS;

DROP TABLE NC_DATAMAPPING;

DROP TABLE NC_DMTOPIC;

DROP TABLE NC_DMT_LINK;

DROP TABLE NC_DSITEM_L1;

DROP TABLE NC_DSITEM_L2;

DROP TABLE NC_DSPOOL;

DROP TABLE NC_DYNAMIC_RECIPIENT_STRUCT;

DROP TABLE NC_DYN_DELIVERY_INFO_STRUCT;

DROP TABLE NC_EXECUTABLE;

DROP TABLE NC_MACHINE_CONFIG;

DROP TABLE NC_MESSAGE_ATTACHMENT;

DROP TABLE NC_MSGDUPLICATION_STORE;

DROP TABLE NC_MSGDUPLICATION_TEMP_STORE;

DROP TABLE NC_OBJECT_PERMISSIONS;

DROP TABLE NC_RECIPIENTSCHEDULE;

DROP TABLE NC_RULE;

DROP TABLE NC_RUNTIME_TICKET;

DROP TABLE NC_TASK_LOG;

DROP TABLE NC_USER_SESSION;

DROP TABLE R_AGENT_ESCALATIONAGENT;

DROP TABLE R_BIECALC_RHSTOPIC;

DROP TABLE R_DS_MACHINE_DSPOOL;

DROP TABLE R_MSGSTRUCT_AVOIDTOPICS;

DROP TABLE R_NEWSVIEWS_NCOBJECTS;

DROP TABLE R_RECIPIENT_ACCMANUSERID;

DROP TABLE R_RULE_PARAMETER;

-- add missing constraint from JMSQueue table --
ALTER TABLE NC_JMSQUEUE
   ADD CONSTRAINT PN_NC_JMSQUEUE PRIMARY KEY (QUEUE_ENTRY_ID);

-------------------------------------------------------------------------------
--$220-- server data inserts begin
-------------------------------------------------------------------------------

INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(306,'build no.');

-------------------------------------------------------------------------------
--	END NC304_UPDATE_ORA.SQL			*	DO NOT EDIT	 * 		 
-------------------------------------------------------------------------------