--
--    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.
--    


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

ALTER TABLE NC_AGGREGATE_RULE_TREE
   DROP CONSTRAINT F2N_AGGREGATE_RULE
go

ALTER TABLE NC_AGGREGATE_RULE_TREE
   DROP CONSTRAINT F1N_AGGREGATE_RULE
go

ALTER TABLE NC_BIETOPIC
   DROP CONSTRAINT F5N_BIETOPIC
go

ALTER TABLE NC_BIETOPIC
   DROP CONSTRAINT F2N_BIETOPIC
go

ALTER TABLE NC_DATAMAPPING
   DROP CONSTRAINT F9N_DATAMAPPING
go

ALTER TABLE NC_DATAMAPPING
   DROP CONSTRAINT F5N_DATAMAPPING
go

ALTER TABLE NC_DYN_DELIVERY_INFO_STRUCT
   DROP CONSTRAINT F2N_DYN_DELIVERY_I
go

ALTER TABLE NC_EXECUTABLE
   DROP CONSTRAINT F7N_EXECUTABLE
go

ALTER TABLE NC_MESSAGESTRUCT
   DROP CONSTRAINT F2N_MESSAGESTRUCT
go

ALTER TABLE NC_MESSAGE_ATTACHMENT
   DROP CONSTRAINT F2N_MESSAGE_ATTACH
go

ALTER TABLE R_AGENT_ESCALATIONAGENT
   DROP CONSTRAINT F2R_AGENT_ESCALATI
go

ALTER TABLE R_DS_MACHINE_DSPOOL
   DROP CONSTRAINT F3R_DS_MACHINE_DSP
go

ALTER TABLE R_DS_MACHINE_DSPOOL
   DROP CONSTRAINT F2R_DS_MACHINE_DSP
go

ALTER TABLE R_MSGSTRUCT_AVOIDTOPICS
   DROP CONSTRAINT F1R_MSGSTRUCT_AVOI
go

ALTER TABLE R_NEWSVIEWS_NCOBJECTS
   DROP CONSTRAINT F2R_NEWSVIEWS_NCOB
go

ALTER TABLE R_RECIPIENT_ACCMANUSERID
   DROP CONSTRAINT F1R_RECIPIENT_ACCM
go

ALTER TABLE R_RULE_PARAMETER
   DROP CONSTRAINT F1R_RULE_PARAMETER
go

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

DROP VIEW V_ACCMANUSER
go

DROP VIEW V_NC_TASK_LINK
go

DROP VIEW V_BIECALC_LINK
go

DROP VIEW V_BIE_COMPLETE
go

DROP VIEW V_NC_AGENT_LOG
go

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


DROP TABLE NC_ACCMAN_TEMP_STORE
go

DROP TABLE NC_ADMINISTRATOR
go

DROP TABLE NC_AGENT_MESSAGE
go

DROP TABLE NC_AGGREGATE_RULE_TREE
go

DROP TABLE NC_BIE
go

DROP TABLE NC_BIECALC
go

DROP TABLE NC_BIETOPIC
go

DROP TABLE NC_COGNOS_DS
go

DROP TABLE NC_CONFIG_DS
go

DROP TABLE NC_DATAMAPPING
go

DROP TABLE NC_DMTOPIC
go

DROP TABLE NC_DMT_LINK
go

DROP TABLE NC_DSITEM_L1
go

DROP TABLE NC_DSITEM_L2
go

DROP TABLE NC_DSPOOL
go

DROP TABLE NC_DYNAMIC_RECIPIENT_STRUCT
go

DROP TABLE NC_DYN_DELIVERY_INFO_STRUCT
go

DROP TABLE NC_EXECUTABLE
go

DROP TABLE NC_MACHINE_CONFIG
go

DROP TABLE NC_MESSAGE_ATTACHMENT
go

DROP TABLE NC_MSGDUPLICATION_STORE
go

DROP TABLE NC_MSGDUPLICATION_TEMP_STORE
go

DROP TABLE NC_OBJECT_PERMISSIONS
go

DROP TABLE NC_RECIPIENTSCHEDULE
go

DROP TABLE NC_RULE
go

DROP TABLE NC_RUNTIME_TICKET
go

DROP TABLE NC_TASK_LOG
go

DROP TABLE NC_USER_SESSION
go

DROP TABLE R_AGENT_ESCALATIONAGENT
go

DROP TABLE R_BIECALC_RHSTOPIC
go

DROP TABLE R_DS_MACHINE_DSPOOL
go

DROP TABLE R_MSGSTRUCT_AVOIDTOPICS
go

DROP TABLE R_NEWSVIEWS_NCOBJECTS
go

DROP TABLE R_RECIPIENT_ACCMANUSERID
go

DROP TABLE R_RULE_PARAMETER
go

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

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

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