/ - Diff - D-Net - D-Net project tracking tool

« Previous | Next »

Revision 61029

Do not prepend PIC to the PIC number, as requested by the EC DG staff member

     BEGIN;
     -- Add constraint to FK
     ALTER TABLE dsm_organizationpids DROP CONSTRAINT dsm_organizationpids_pid_fkey;
     ALTER TABLE dsm_organizationpids ADD CONSTRAINT dsm_organizationpids_pid_fkey
       FOREIGN KEY (pid) REFERENCES dsm_identities (pid)
       ON UPDATE CASCADE;
       -- Update
       UPDATE dsm_identities
       set pid = substring(pid,5)
       where issuertype ='PIC';
       -- Add original FK
       ALTER TABLE dsm_organizationpids DROP CONSTRAINT dsm_organizationpids_pid_fkey;
       ALTER TABLE dsm_organizationpids ADD CONSTRAINT dsm_organizationpids_pid_fkey
         FOREIGN KEY (pid) REFERENCES dsm_identities (pid);
     COMMIT
+    ;

                                     <xsl:value-of select="0.8"/>
                                 </FIELD>
                             </ROW>
                             <xsl:variable name="organizationPIC" select="concat('PIC:', ./OrganisationPIC)"/>
                             <xsl:variable name="organizationPIC" select="./OrganisationPIC"/>
                              <ROW table="dsm_identities">
                                 <FIELD name="_dnet_resource_identifier_">
                                     <xsl:value-of
                                             select="concat(./OrganisationPIC, '@@PIC')"/>
                                             select="concat($organizationPIC, '@@PIC')"/>
                                 </FIELD>
                                 <FIELD name="pid">
                                     <xsl:value-of select="$organizationPIC"/>

     								</FIELD>
     							</ROW>
     						 <xsl:variable name="organizationPIC" select="concat('PIC:', ./OrganisationPIC)"/>
     						 <xsl:variable name="organizationPIC" select="./OrganisationPIC"/>
                              <ROW table="dsm_identities">
                                 <FIELD name="_dnet_resource_identifier_">
                                     <xsl:value-of

Also available in: Unified diff