CREATE TABLE ALLOWEDLINK (
       AllowedLinkId        int IDENTITY,
       LinkTypeId           int NULL,
       ObjectTypeId_1       int NULL,
       ObjectTypeId_2       int NULL
)
go


ALTER TABLE ALLOWEDLINK
       ADD PRIMARY KEY NONCLUSTERED (AllowedLinkId)
go


CREATE TABLE ALLOWEDMOVEMENT (
       AllowedMovementId    int IDENTITY,
       ObjectTypeId_Container int NULL,
       ObjectTypeId_Content int NULL
)
go


ALTER TABLE ALLOWEDMOVEMENT
       ADD PRIMARY KEY NONCLUSTERED (AllowedMovementId)
go


CREATE TABLE ATTRIBUTE (
       AttributeId          int IDENTITY,
       AttributeTypeId      int NULL,
       ObjectId             int NULL,
       AttributeValue       sql_variant NULL
)
go


ALTER TABLE ATTRIBUTE
       ADD PRIMARY KEY NONCLUSTERED (AttributeId)
go


CREATE TABLE ATTRIBUTETYPE (
       AttributeTypeId      int IDENTITY,
       ObjectTypeId         int NULL,
       AttributeTypeAbbr    char( 10 ) NULL,
       AttributeTypeName    char( 30 ) NULL,
       DataTypeId           int NULL
)
go


ALTER TABLE ATTRIBUTETYPE
       ADD PRIMARY KEY NONCLUSTERED (AttributeTypeId)
go


CREATE TABLE DATATYPE (
       DataTypeId           int IDENTITY,
       DataTypeAbbr         char( 10 ) NULL,
       DataTypeName         char( 30 ) NULL,
       DataTypeSQL          char( 16 ) NULL
)
go


ALTER TABLE DATATYPE
       ADD PRIMARY KEY NONCLUSTERED (DataTypeId)
go


CREATE TABLE ENUMDATATYPE (
       EnumDataTypeId       int IDENTITY
)
go


ALTER TABLE ENUMDATATYPE
       ADD PRIMARY KEY NONCLUSTERED (EnumDataTypeId)
go


CREATE TABLE LINK (
       LinkId               int IDENTITY,
       LinkTypeId           int NULL,
       ObjectId_1           int NULL,
       ObjectId_2           int NULL
)
go


ALTER TABLE LINK
       ADD PRIMARY KEY NONCLUSTERED (LinkId)
go


CREATE TABLE LINKTYPE (
       LinkTypeId           int IDENTITY,
       LinkTypeAbbr         char( 10 ) NULL,
       LinkTypeName         char( 30 ) NULL
)
go


ALTER TABLE LINKTYPE
       ADD PRIMARY KEY NONCLUSTERED (LinkTypeId)
go


CREATE TABLE MOVEMENT (
       MovementId           int IDENTITY,
       ObjectId_Operation   int NULL,
       ObjectId_Container   int NULL,
       ObjectId_Content     int NULL,
       MovementDate         datetime NULL
)
go


ALTER TABLE MOVEMENT
       ADD PRIMARY KEY NONCLUSTERED (MovementId)
go


CREATE TABLE OBJECT (
       ObjectId             int IDENTITY,
       ObjectTypeId         int NULL,
       ObjectName           char( 50 ) NULL
)
go


ALTER TABLE OBJECT
       ADD PRIMARY KEY NONCLUSTERED (ObjectId)
go


CREATE TABLE OBJECTTYPE (
       ObjectTypeId         int IDENTITY,
       ObjectTypeAbbr       char( 10 ) NOT NULL,
       ObjectTypeName       char( 30 ) NULL,
       ObjectTypeId_Parent  int NULL
)
go

CREATE UNIQUE INDEX XAK1OBJECTTYPE ON OBJECTTYPE
(
       ObjectTypeAbbr
)
go


ALTER TABLE OBJECTTYPE
       ADD PRIMARY KEY NONCLUSTERED (ObjectTypeId)
go


ALTER TABLE ALLOWEDLINK
       ADD FOREIGN KEY (ObjectTypeId_2)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE ALLOWEDLINK
       ADD FOREIGN KEY (ObjectTypeId_1)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE ALLOWEDLINK
       ADD FOREIGN KEY (LinkTypeId)
                             REFERENCES LINKTYPE
go


ALTER TABLE ALLOWEDMOVEMENT
       ADD FOREIGN KEY (ObjectTypeId_Content)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE ALLOWEDMOVEMENT
       ADD FOREIGN KEY (ObjectTypeId_Container)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE ATTRIBUTE
       ADD FOREIGN KEY (ObjectId)
                             REFERENCES OBJECT
go


ALTER TABLE ATTRIBUTE
       ADD FOREIGN KEY (AttributeTypeId)
                             REFERENCES ATTRIBUTETYPE
go


ALTER TABLE ATTRIBUTETYPE
       ADD FOREIGN KEY (DataTypeId)
                             REFERENCES DATATYPE
go


ALTER TABLE ATTRIBUTETYPE
       ADD FOREIGN KEY (ObjectTypeId)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE LINK
       ADD FOREIGN KEY (ObjectId_2)
                             REFERENCES OBJECT
go


ALTER TABLE LINK
       ADD FOREIGN KEY (ObjectId_1)
                             REFERENCES OBJECT
go


ALTER TABLE LINK
       ADD FOREIGN KEY (LinkTypeId)
                             REFERENCES LINKTYPE
go


ALTER TABLE MOVEMENT
       ADD FOREIGN KEY (ObjectId_Content)
                             REFERENCES OBJECT
go


ALTER TABLE MOVEMENT
       ADD FOREIGN KEY (ObjectId_Container)
                             REFERENCES OBJECT
go


ALTER TABLE MOVEMENT
       ADD FOREIGN KEY (ObjectId_Operation)
                             REFERENCES OBJECT
go


ALTER TABLE OBJECT
       ADD FOREIGN KEY (ObjectTypeId)
                             REFERENCES OBJECTTYPE
go


ALTER TABLE OBJECTTYPE
       ADD FOREIGN KEY (ObjectTypeId_Parent)
                             REFERENCES OBJECTTYPE
go




create trigger tI_ALLOWEDLINK on ALLOWEDLINK for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* INSERT trigger on ALLOWEDLINK */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the second in ALLOWEDLINK ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId_2) */ 
    update(ObjectTypeId_2)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_2 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_2 = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_2 = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_2 = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the first in ALLOWEDLINK ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId_1) */ 
    update(ObjectTypeId_1)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_1 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_1 = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_1 = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_1 = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* LINKTYPE will give semantic value of ALLOWEDLINK ON CHILD INSERT SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.LinkTypeId = NULL */ 
        ALLOWEDLINK.LinkTypeId = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from LINKTYPE
          where
             /* inserted.LinkTypeId = LINKTYPE.LinkTypeId */ 
            inserted.LinkTypeId = LINKTYPE.LinkTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_ALLOWEDLINK on ALLOWEDLINK for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* UPDATE trigger on ALLOWEDLINK */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAllowedLinkId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the second in ALLOWEDLINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId_2) */ 
    update(ObjectTypeId_2)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_2 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_2 = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_2 = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_2 = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the first in ALLOWEDLINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId_1) */ 
    update(ObjectTypeId_1)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_1 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_1 = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_1 = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_1 = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* LINKTYPE will give semantic value of ALLOWEDLINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.LinkTypeId = NULL */ 
        ALLOWEDLINK.LinkTypeId = NULL
      from ALLOWEDLINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from LINKTYPE
          where
             /* inserted.LinkTypeId = LINKTYPE.LinkTypeId */ 
            inserted.LinkTypeId = LINKTYPE.LinkTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_ALLOWEDMOVEMENT on ALLOWEDMOVEMENT for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* INSERT trigger on ALLOWEDMOVEMENT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the content of ALLOWEDMOVEMENT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId_Content) */ 
    update(ObjectTypeId_Content)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL
      from ALLOWEDMOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Content = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Content = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the container ALLOWEDMOVEMENT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId_Container) */ 
    update(ObjectTypeId_Container)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL
      from ALLOWEDMOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Container = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Container = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_ALLOWEDMOVEMENT on ALLOWEDMOVEMENT for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* UPDATE trigger on ALLOWEDMOVEMENT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAllowedMovementId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the content of ALLOWEDMOVEMENT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId_Content) */ 
    update(ObjectTypeId_Content)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL
      from ALLOWEDMOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Content = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Content = OBJECTTYPE.ObjectTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE will be the container ALLOWEDMOVEMENT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId_Container) */ 
    update(ObjectTypeId_Container)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL
      from ALLOWEDMOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Container = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Container = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_ATTRIBUTE on ATTRIBUTE for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* INSERT trigger on ATTRIBUTE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECT has ATTRIBUTE ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.ObjectId = NULL */ 
        ATTRIBUTE.ObjectId = NULL
      from ATTRIBUTE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId = OBJECT.ObjectId */ 
            inserted.ObjectId = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* ATTRIBUTETYPE is filled with the data in ATTRIBUTE ON CHILD INSERT SET NULL */ 
  if
     /* update(AttributeTypeId) */ 
    update(AttributeTypeId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.AttributeTypeId = NULL */ 
        ATTRIBUTE.AttributeTypeId = NULL
      from ATTRIBUTE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from ATTRIBUTETYPE
          where
             /* inserted.AttributeTypeId = ATTRIBUTETYPE.AttributeTypeId */ 
            inserted.AttributeTypeId = ATTRIBUTETYPE.AttributeTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_ATTRIBUTE on ATTRIBUTE for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* UPDATE trigger on ATTRIBUTE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAttributeId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECT has ATTRIBUTE ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.ObjectId = NULL */ 
        ATTRIBUTE.ObjectId = NULL
      from ATTRIBUTE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId = OBJECT.ObjectId */ 
            inserted.ObjectId = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* ATTRIBUTETYPE is filled with the data in ATTRIBUTE ON CHILD UPDATE SET NULL */ 
  if
     /* update(AttributeTypeId) */ 
    update(AttributeTypeId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.AttributeTypeId = NULL */ 
        ATTRIBUTE.AttributeTypeId = NULL
      from ATTRIBUTE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from ATTRIBUTETYPE
          where
             /* inserted.AttributeTypeId = ATTRIBUTETYPE.AttributeTypeId */ 
            inserted.AttributeTypeId = ATTRIBUTETYPE.AttributeTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_ATTRIBUTETYPE on ATTRIBUTETYPE for DELETE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* DELETE trigger on ATTRIBUTETYPE */ 
begin
  declare  @errno   int,
           @errmsg  varchar( 255 )
     /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
     /* ATTRIBUTETYPE is filled with the data in ATTRIBUTE ON PARENT DELETE SET NULL */ 
    update ATTRIBUTE
      set
         /* ATTRIBUTE.AttributeTypeId = NULL */ 
        ATTRIBUTE.AttributeTypeId = NULL
      from ATTRIBUTE,deleted
      where
         /* ATTRIBUTE.AttributeTypeId = deleted.AttributeTypeId */ 
        ATTRIBUTE.AttributeTypeId = deleted.AttributeTypeId


     /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_ATTRIBUTETYPE on ATTRIBUTETYPE for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* INSERT trigger on ATTRIBUTETYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* DATATYPE is used at creation of ATTRIBUTETYPE ON CHILD INSERT SET NULL */ 
  if
     /* update(DataTypeId) */ 
    update(DataTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.DataTypeId = NULL */ 
        ATTRIBUTETYPE.DataTypeId = NULL
      from ATTRIBUTETYPE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from DATATYPE
          where
             /* inserted.DataTypeId = DATATYPE.DataTypeId */ 
            inserted.DataTypeId = DATATYPE.DataTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE allows to keep ATTRIBUTETYPE ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.ObjectTypeId = NULL */ 
        ATTRIBUTETYPE.ObjectTypeId = NULL
      from ATTRIBUTETYPE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_ATTRIBUTETYPE on ATTRIBUTETYPE for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* UPDATE trigger on ATTRIBUTETYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insAttributeTypeId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* ATTRIBUTETYPE is filled with the data in ATTRIBUTE ON PARENT UPDATE SET NULL */ 
  if
     /* update(AttributeTypeId) */ 
    update(AttributeTypeId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.AttributeTypeId = NULL */ 
        ATTRIBUTE.AttributeTypeId = NULL
      from ATTRIBUTE,deleted
      where
         /* ATTRIBUTE.AttributeTypeId = deleted.AttributeTypeId */ 
        ATTRIBUTE.AttributeTypeId = deleted.AttributeTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* DATATYPE is used at creation of ATTRIBUTETYPE ON CHILD UPDATE SET NULL */ 
  if
     /* update(DataTypeId) */ 
    update(DataTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.DataTypeId = NULL */ 
        ATTRIBUTETYPE.DataTypeId = NULL
      from ATTRIBUTETYPE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from DATATYPE
          where
             /* inserted.DataTypeId = DATATYPE.DataTypeId */ 
            inserted.DataTypeId = DATATYPE.DataTypeId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* OBJECTTYPE allows to keep ATTRIBUTETYPE ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.ObjectTypeId = NULL */ 
        ATTRIBUTETYPE.ObjectTypeId = NULL
      from ATTRIBUTETYPE,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_DATATYPE on DATATYPE for DELETE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* DELETE trigger on DATATYPE */ 
begin
  declare  @errno   int,
           @errmsg  varchar( 255 )
     /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
     /* DATATYPE is used at creation of ATTRIBUTETYPE ON PARENT DELETE SET NULL */ 
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.DataTypeId = NULL */ 
        ATTRIBUTETYPE.DataTypeId = NULL
      from ATTRIBUTETYPE,deleted
      where
         /* ATTRIBUTETYPE.DataTypeId = deleted.DataTypeId */ 
        ATTRIBUTETYPE.DataTypeId = deleted.DataTypeId


     /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_DATATYPE on DATATYPE for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
 /* UPDATE trigger on DATATYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insDataTypeId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
   /* DATATYPE is used at creation of ATTRIBUTETYPE ON PARENT UPDATE SET NULL */ 
  if
     /* update(DataTypeId) */ 
    update(DataTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.DataTypeId = NULL */ 
        ATTRIBUTETYPE.DataTypeId = NULL
      from ATTRIBUTETYPE,deleted
      where
         /* ATTRIBUTETYPE.DataTypeId = deleted.DataTypeId */ 
        ATTRIBUTETYPE.DataTypeId = deleted.DataTypeId
  end


   /* ERwin Builtin Fri Jul 26 12:38:23 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_LINK on LINK for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* INSERT trigger on LINK */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the second in LINK ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId_2) */ 
    update(ObjectId_2)
  begin
    update LINK
      set
         /* LINK.ObjectId_2 = NULL */ 
        LINK.ObjectId_2 = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_2 = OBJECT.ObjectId */ 
            inserted.ObjectId_2 = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the first in LINK ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId_1) */ 
    update(ObjectId_1)
  begin
    update LINK
      set
         /* LINK.ObjectId_1 = NULL */ 
        LINK.ObjectId_1 = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_1 = OBJECT.ObjectId */ 
            inserted.ObjectId_1 = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* LINKTYPE gives semantic value of LINK ON CHILD INSERT SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update LINK
      set
         /* LINK.LinkTypeId = NULL */ 
        LINK.LinkTypeId = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from LINKTYPE
          where
             /* inserted.LinkTypeId = LINKTYPE.LinkTypeId */ 
            inserted.LinkTypeId = LINKTYPE.LinkTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_LINK on LINK for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* UPDATE trigger on LINK */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insLinkId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the second in LINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId_2) */ 
    update(ObjectId_2)
  begin
    update LINK
      set
         /* LINK.ObjectId_2 = NULL */ 
        LINK.ObjectId_2 = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_2 = OBJECT.ObjectId */ 
            inserted.ObjectId_2 = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the first in LINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId_1) */ 
    update(ObjectId_1)
  begin
    update LINK
      set
         /* LINK.ObjectId_1 = NULL */ 
        LINK.ObjectId_1 = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_1 = OBJECT.ObjectId */ 
            inserted.ObjectId_1 = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* LINKTYPE gives semantic value of LINK ON CHILD UPDATE SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update LINK
      set
         /* LINK.LinkTypeId = NULL */ 
        LINK.LinkTypeId = NULL
      from LINK,inserted
      where
         /*  */ 
		 
        not exists (
          select * from LINKTYPE
          where
             /* inserted.LinkTypeId = LINKTYPE.LinkTypeId */ 
            inserted.LinkTypeId = LINKTYPE.LinkTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_LINKTYPE on LINKTYPE for DELETE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* DELETE trigger on LINKTYPE */ 
begin
  declare  @errno   int,
           @errmsg  varchar( 255 )
     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* LINKTYPE will give semantic value of ALLOWEDLINK ON PARENT DELETE SET NULL */ 
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.LinkTypeId = NULL */ 
        ALLOWEDLINK.LinkTypeId = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.LinkTypeId = deleted.LinkTypeId */ 
        ALLOWEDLINK.LinkTypeId = deleted.LinkTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* LINKTYPE gives semantic value of LINK ON PARENT DELETE SET NULL */ 
    update LINK
      set
         /* LINK.LinkTypeId = NULL */ 
        LINK.LinkTypeId = NULL
      from LINK,deleted
      where
         /* LINK.LinkTypeId = deleted.LinkTypeId */ 
        LINK.LinkTypeId = deleted.LinkTypeId


     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_LINKTYPE on LINKTYPE for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* UPDATE trigger on LINKTYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insLinkTypeId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* LINKTYPE will give semantic value of ALLOWEDLINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.LinkTypeId = NULL */ 
        ALLOWEDLINK.LinkTypeId = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.LinkTypeId = deleted.LinkTypeId */ 
        ALLOWEDLINK.LinkTypeId = deleted.LinkTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* LINKTYPE gives semantic value of LINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(LinkTypeId) */ 
    update(LinkTypeId)
  begin
    update LINK
      set
         /* LINK.LinkTypeId = NULL */ 
        LINK.LinkTypeId = NULL
      from LINK,deleted
      where
         /* LINK.LinkTypeId = deleted.LinkTypeId */ 
        LINK.LinkTypeId = deleted.LinkTypeId
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_MOVEMENT on MOVEMENT for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* INSERT trigger on MOVEMENT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the content of MOVEMENT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId_Content) */ 
    update(ObjectId_Content)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Content = NULL */ 
        MOVEMENT.ObjectId_Content = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Content = OBJECT.ObjectId */ 
            inserted.ObjectId_Content = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the container MOVEMENT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId_Container) */ 
    update(ObjectId_Container)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Container = NULL */ 
        MOVEMENT.ObjectId_Container = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Container = OBJECT.ObjectId */ 
            inserted.ObjectId_Container = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the operation MOVEMENT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectId_Operation) */ 
    update(ObjectId_Operation)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Operation = NULL */ 
        MOVEMENT.ObjectId_Operation = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Operation = OBJECT.ObjectId */ 
            inserted.ObjectId_Operation = OBJECT.ObjectId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_MOVEMENT on MOVEMENT for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* UPDATE trigger on MOVEMENT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insMovementId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the content of MOVEMENT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId_Content) */ 
    update(ObjectId_Content)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Content = NULL */ 
        MOVEMENT.ObjectId_Content = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Content = OBJECT.ObjectId */ 
            inserted.ObjectId_Content = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the container MOVEMENT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId_Container) */ 
    update(ObjectId_Container)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Container = NULL */ 
        MOVEMENT.ObjectId_Container = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Container = OBJECT.ObjectId */ 
            inserted.ObjectId_Container = OBJECT.ObjectId
        )
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the operation MOVEMENT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectId_Operation) */ 
    update(ObjectId_Operation)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Operation = NULL */ 
        MOVEMENT.ObjectId_Operation = NULL
      from MOVEMENT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECT
          where
             /* inserted.ObjectId_Operation = OBJECT.ObjectId */ 
            inserted.ObjectId_Operation = OBJECT.ObjectId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_OBJECT on OBJECT for DELETE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* DELETE trigger on OBJECT */ 
begin
  declare  @errno   int,
           @errmsg  varchar( 255 )
     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT is the content of MOVEMENT ON PARENT DELETE SET NULL */ 
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Content = NULL */ 
        MOVEMENT.ObjectId_Content = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Content = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Content = deleted.ObjectId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT is the container MOVEMENT ON PARENT DELETE SET NULL */ 
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Container = NULL */ 
        MOVEMENT.ObjectId_Container = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Container = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Container = deleted.ObjectId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT is the operation MOVEMENT ON PARENT DELETE SET NULL */ 
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Operation = NULL */ 
        MOVEMENT.ObjectId_Operation = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Operation = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Operation = deleted.ObjectId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT is the second in LINK ON PARENT DELETE SET NULL */ 
    update LINK
      set
         /* LINK.ObjectId_2 = NULL */ 
        LINK.ObjectId_2 = NULL
      from LINK,deleted
      where
         /* LINK.ObjectId_2 = deleted.ObjectId */ 
        LINK.ObjectId_2 = deleted.ObjectId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT is the first in LINK ON PARENT DELETE SET NULL */ 
    update LINK
      set
         /* LINK.ObjectId_1 = NULL */ 
        LINK.ObjectId_1 = NULL
      from LINK,deleted
      where
         /* LINK.ObjectId_1 = deleted.ObjectId */ 
        LINK.ObjectId_1 = deleted.ObjectId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECT has ATTRIBUTE ON PARENT DELETE SET NULL */ 
    update ATTRIBUTE
      set
         /* ATTRIBUTE.ObjectId = NULL */ 
        ATTRIBUTE.ObjectId = NULL
      from ATTRIBUTE,deleted
      where
         /* ATTRIBUTE.ObjectId = deleted.ObjectId */ 
        ATTRIBUTE.ObjectId = deleted.ObjectId


     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_OBJECT on OBJECT for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* INSERT trigger on OBJECT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is realized by OBJECT ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update OBJECT
      set
         /* OBJECT.ObjectTypeId = NULL */ 
        OBJECT.ObjectTypeId = NULL
      from OBJECT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_OBJECT on OBJECT for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* UPDATE trigger on OBJECT */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insObjectId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the content of MOVEMENT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Content = NULL */ 
        MOVEMENT.ObjectId_Content = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Content = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Content = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the container MOVEMENT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Container = NULL */ 
        MOVEMENT.ObjectId_Container = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Container = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Container = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the operation MOVEMENT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update MOVEMENT
      set
         /* MOVEMENT.ObjectId_Operation = NULL */ 
        MOVEMENT.ObjectId_Operation = NULL
      from MOVEMENT,deleted
      where
         /* MOVEMENT.ObjectId_Operation = deleted.ObjectId */ 
        MOVEMENT.ObjectId_Operation = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the second in LINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update LINK
      set
         /* LINK.ObjectId_2 = NULL */ 
        LINK.ObjectId_2 = NULL
      from LINK,deleted
      where
         /* LINK.ObjectId_2 = deleted.ObjectId */ 
        LINK.ObjectId_2 = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT is the first in LINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update LINK
      set
         /* LINK.ObjectId_1 = NULL */ 
        LINK.ObjectId_1 = NULL
      from LINK,deleted
      where
         /* LINK.ObjectId_1 = deleted.ObjectId */ 
        LINK.ObjectId_1 = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECT has ATTRIBUTE ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectId) */ 
    update(ObjectId)
  begin
    update ATTRIBUTE
      set
         /* ATTRIBUTE.ObjectId = NULL */ 
        ATTRIBUTE.ObjectId = NULL
      from ATTRIBUTE,deleted
      where
         /* ATTRIBUTE.ObjectId = deleted.ObjectId */ 
        ATTRIBUTE.ObjectId = deleted.ObjectId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is realized by OBJECT ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update OBJECT
      set
         /* OBJECT.ObjectTypeId = NULL */ 
        OBJECT.ObjectTypeId = NULL
      from OBJECT,inserted
      where
         /*  */ 
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tD_OBJECTTYPE on OBJECTTYPE for DELETE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* DELETE trigger on OBJECTTYPE */ 
begin
  declare  @errno   int,
           @errmsg  varchar( 255 )
     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE will be the content of ALLOWEDMOVEMENT ON PARENT DELETE SET NULL */ 
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL
      from ALLOWEDMOVEMENT,deleted
      where
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = deleted.ObjectTypeId */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE will be the container ALLOWEDMOVEMENT ON PARENT DELETE SET NULL */ 
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL
      from ALLOWEDMOVEMENT,deleted
      where
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = deleted.ObjectTypeId */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE will be the second in ALLOWEDLINK ON PARENT DELETE SET NULL */ 
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_2 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_2 = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.ObjectTypeId_2 = deleted.ObjectTypeId */ 
        ALLOWEDLINK.ObjectTypeId_2 = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE will be the first in ALLOWEDLINK ON PARENT DELETE SET NULL */ 
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_1 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_1 = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.ObjectTypeId_1 = deleted.ObjectTypeId */ 
        ALLOWEDLINK.ObjectTypeId_1 = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE allows to keep ATTRIBUTETYPE ON PARENT DELETE SET NULL */ 
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.ObjectTypeId = NULL */ 
        ATTRIBUTETYPE.ObjectTypeId = NULL
      from ATTRIBUTETYPE,deleted
      where
         /* ATTRIBUTETYPE.ObjectTypeId = deleted.ObjectTypeId */ 
        ATTRIBUTETYPE.ObjectTypeId = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE is realized by OBJECT ON PARENT DELETE SET NULL */ 
    update OBJECT
      set
         /* OBJECT.ObjectTypeId = NULL */ 
        OBJECT.ObjectTypeId = NULL
      from OBJECT,deleted
      where
         /* OBJECT.ObjectTypeId = deleted.ObjectTypeId */ 
        OBJECT.ObjectTypeId = deleted.ObjectTypeId

     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
     /* OBJECTTYPE is inherited by OBJECTTYPE ON PARENT DELETE SET NULL */ 
    update OBJECTTYPE
      set
         /* OBJECTTYPE.ObjectTypeId_Parent = NULL */ 
        OBJECTTYPE.ObjectTypeId_Parent = NULL
      from OBJECTTYPE,deleted
      where
         /* OBJECTTYPE.ObjectTypeId_Parent = deleted.ObjectTypeId */ 
        OBJECTTYPE.ObjectTypeId_Parent = deleted.ObjectTypeId


     /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
    return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tI_OBJECTTYPE on OBJECTTYPE for INSERT as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* INSERT trigger on OBJECTTYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is inherited by OBJECTTYPE ON CHILD INSERT SET NULL */ 
  if
     /* update(ObjectTypeId_Parent) */ 
    update(ObjectTypeId_Parent)
  begin
    update OBJECTTYPE
      set
         /* OBJECTTYPE.ObjectTypeId_Parent = NULL */ 
        OBJECTTYPE.ObjectTypeId_Parent = NULL
      from OBJECTTYPE,inserted
      where
         /* OBJECTTYPE.ObjectTypeId = inserted.ObjectTypeId */ 
		OBJECTTYPE.ObjectTypeId = inserted.ObjectTypeId and
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Parent = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Parent = OBJECTTYPE.ObjectTypeId
        )
  end


   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go

create trigger tU_OBJECTTYPE on OBJECTTYPE for UPDATE as
 /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
 /* UPDATE trigger on OBJECTTYPE */ 
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insObjectTypeId int,
           @errno   int,
           @errmsg  varchar( 255 )

  select @numrows = @@rowcount
   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE will be the content of ALLOWEDMOVEMENT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = NULL
      from ALLOWEDMOVEMENT,deleted
      where
         /* ALLOWEDMOVEMENT.ObjectTypeId_Content = deleted.ObjectTypeId */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Content = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE will be the container ALLOWEDMOVEMENT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ALLOWEDMOVEMENT
      set
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = NULL
      from ALLOWEDMOVEMENT,deleted
      where
         /* ALLOWEDMOVEMENT.ObjectTypeId_Container = deleted.ObjectTypeId */ 
        ALLOWEDMOVEMENT.ObjectTypeId_Container = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE will be the second in ALLOWEDLINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_2 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_2 = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.ObjectTypeId_2 = deleted.ObjectTypeId */ 
        ALLOWEDLINK.ObjectTypeId_2 = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE will be the first in ALLOWEDLINK ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ALLOWEDLINK
      set
         /* ALLOWEDLINK.ObjectTypeId_1 = NULL */ 
        ALLOWEDLINK.ObjectTypeId_1 = NULL
      from ALLOWEDLINK,deleted
      where
         /* ALLOWEDLINK.ObjectTypeId_1 = deleted.ObjectTypeId */ 
        ALLOWEDLINK.ObjectTypeId_1 = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE allows to keep ATTRIBUTETYPE ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update ATTRIBUTETYPE
      set
         /* ATTRIBUTETYPE.ObjectTypeId = NULL */ 
        ATTRIBUTETYPE.ObjectTypeId = NULL
      from ATTRIBUTETYPE,deleted
      where
         /* ATTRIBUTETYPE.ObjectTypeId = deleted.ObjectTypeId */ 
        ATTRIBUTETYPE.ObjectTypeId = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is realized by OBJECT ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update OBJECT
      set
         /* OBJECT.ObjectTypeId = NULL */ 
        OBJECT.ObjectTypeId = NULL
      from OBJECT,deleted
      where
         /* OBJECT.ObjectTypeId = deleted.ObjectTypeId */ 
        OBJECT.ObjectTypeId = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is inherited by OBJECTTYPE ON PARENT UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId) */ 
    update(ObjectTypeId)
  begin
    update OBJECTTYPE
      set
         /* OBJECTTYPE.ObjectTypeId_Parent = NULL */ 
        OBJECTTYPE.ObjectTypeId_Parent = NULL
      from OBJECTTYPE,deleted
      where
         /* OBJECTTYPE.ObjectTypeId_Parent = deleted.ObjectTypeId */ 
        OBJECTTYPE.ObjectTypeId_Parent = deleted.ObjectTypeId
  end

   /* ERwin Builtin Fri Jul 26 12:38:24 2002 */ 
   /* OBJECTTYPE is inherited by OBJECTTYPE ON CHILD UPDATE SET NULL */ 
  if
     /* update(ObjectTypeId_Parent) */ 
    update(ObjectTypeId_Parent)
  begin
    update OBJECTTYPE
      set
         /* OBJECTTYPE.ObjectTypeId_Parent = NULL */ 
        OBJECTTYPE.ObjectTypeId_Parent = NULL
      from OBJECTTYPE,inserted
      where
         /* OBJECTTYPE.ObjectTypeId = inserted.ObjectTypeId */ 
		OBJECTTYPE.ObjectTypeId = inserted.ObjectTypeId and
		 
        not exists (
          select * from OBJECTTYPE
          where
             /* inserted.ObjectTypeId_Parent = OBJECTTYPE.ObjectTypeId */ 
            inserted.ObjectTypeId_Parent = OBJECTTYPE.ObjectTypeId
        )
  end


  return
error:
    raiserror @errno @errmsg
    rollback transaction
end
go