insert into CMPFCOStorage
  select t.* from CMPFCOClasses t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
--gggraham: Bug 5691039: Only seed meta-metamodel data into snapshot storage by global workspaceid
--gggraham: Bug 6519987: CMPMMMClasses/CMPMMMStorage obsoleted, seeded meta-metamodel data no longer stored there.
--insert into CMPMMMStorage
--  select t.* from CMPMMMClasses t
--  where workspaceID = 1;
insert into CMPSCOStorage
  select t.* from CMPSCOClasses t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
insert into CMPSCOCfgStorage
  select t.* from CMPSCOCfgClasses t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
insert into CMPSCOMapStorage
  select t.* from CMPSCOMapClasses t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
insert into CMPSCOPrpStorage
  select t.* from CMPSCOPrpClasses t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
--gggraham: Bug 5691039: Only seed CMPSYSClasses data into snapshot storage by global workspaceid
insert into CMPSYSStorage
  select t.* from CMPSYSClasses t
  where workspaceID = 1;

delete from cmpwbproject_x where name = 'MY_PROJECT';
delete from cmpwbproject_x where name = 'PUBLIC_PROJECT';
delete from cmpruntimelocation_x where name = 'DEFAULT_CONTROL_CENTER';
delete from cmpsharedinstalledmodule_x where name = 'Global-Shared-Library';

update CMPFCOStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
--gggraham: Bug 6519987: CMPMMMClasses/CMPMMMStorage obsoleted, seeded meta-metamodel data no longer stored there.
--update CMPMMMStorage set snapshotid = 0,compuoid = '',isseed = 0
--  where workspaceID = 1;
update CMPSCOStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
update CMPSCOCfgStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
update CMPSCOMapStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
update CMPSCOPrpStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);
update CMPSYSStorage set snapshotid = 0,compuoid = '',isseed = 0
  where workspaceID = 1;

insert into FCOFOLDERNamespaceStorage
  select t.* from FCOFOLDERNamespace t
  where workspaceID = (select sys_context('owb_workspace','workspaceID') from dual);

delete from cmpallfolderfconames_x where name = 'MY_PROJECT' or name = 'My Project';
delete from cmpallfolderfconames_x where name = 'PUBLIC_PROJECT';
delete from cmpallfolderfconames_x where name = 'DEFAULT_CONTROL_CENTER' or name = 'Default Control Center';
delete from cmpallfolderfconames_x where name = 'Global-Shared-Library';

update FCOFOLDERNamespaceStorage set snapshotid = 0,isseed = 0;

insert into pctree (workspaceId,parentId,childId,parentRole,childRole) 
  select workspaceId,parentId,childId,parentRole,childRole from pctree_v where parentId = 0;

commit;


--sochen: aug 23, 06: need to enable these triggers otherwise, mcm restore will fail..
alter trigger dmlfcotrigger enable;
--alter trigger dmlmmmtrigger enable;
alter trigger dmlscotrigger enable;
alter trigger dmlscocfgtrigger enable;
alter trigger dmlscomaptrigger enable;
alter trigger dmlscoprptrigger enable;
alter trigger dmlsystrigger enable;

commit;

alter trigger dmlfcotrigger compile;
--alter trigger dmlmmmtrigger compile;
alter trigger dmlscotrigger compile;
alter trigger dmlscocfgtrigger compile;
alter trigger dmlscomaptrigger compile;
alter trigger dmlscoprptrigger compile;
alter trigger dmlsystrigger compile;