portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed-2/src/sql/mysql populate-entities-for-default-psml.sql
Date Thu, 06 May 2004 17:30:04 GMT
taylor      2004/05/06 10:30:04

  Modified:    src/sql/mysql populate-entities-for-default-psml.sql
  Log:
  My original script was not retrieving the foreign key correctly.
  Modified the script to get the foreign key per Tim Reilly's example
  
  PR:
  Obtained from:
  Submitted by:	
  Reviewed by:	
  CVS: ----------------------------------------------------------------------
  CVS: PR:
  CVS:   If this change addresses a PR in the problem report tracking
  CVS:   database, then enter the PR number(s) here.
  CVS: Obtained from:
  CVS:   If this change has been taken from another system, such as NCSA,
  CVS:   then name the system in this line, otherwise delete it.
  CVS: Submitted by:
  CVS:   If this code has been contributed to Apache by someone else; i.e.,
  CVS:   they sent us a patch or a new module, then include their name/email
  CVS:   address here. If this is your work then delete this line.
  CVS: Reviewed by:
  CVS:   If we are doing pre-commit code reviews and someone else has
  CVS:   reviewed your changes, include their name(s) here.
  CVS:   If you have not had it reviewed then delete this line.
  
  Revision  Changes    Path
  1.2       +16 -15    jakarta-jetspeed-2/src/sql/mysql/populate-entities-for-default-psml.sql
  
  Index: populate-entities-for-default-psml.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/mysql/populate-entities-for-default-psml.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- populate-entities-for-default-psml.sql	5 May 2004 23:10:23 -0000	1.1
  +++ populate-entities-for-default-psml.sql	6 May 2004 17:30:04 -0000	1.2
  @@ -1,30 +1,31 @@
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (1, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'TwoColumns\'", '1');
  +  SELECT 1, PD.ID, '1' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'TwoColumns';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (2, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'VelocityTwoColumns\'", '2');
  +  SELECT 2, PD.ID, '2' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'VelocityTwoColumns';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (3, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'HelloPortlet\'", '3');
  +  SELECT 3, PD.ID, '3' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'HelloPortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (4, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'JMXPortlet\'", '4');
  +  SELECT 4, PD.ID, '4' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'JMXPortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (5, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'PreferencePortlet\'", '5');
  +  SELECT 5, PD.ID, '5' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'PreferencePortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (6, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'DisplayRequestPortlet\'",
'6');
  +  SELECT 6, PD.ID, '6' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'DisplayRequestPortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (7, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'PickANumberPortlet\'", '7');
  +  SELECT 7, PD.ID, '7' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'PickANumberPortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (8, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'AttributeScopePortlet\'",
'8');
  +  SELECT 8, PD.ID, '8' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'AttributeScopePortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (9, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'CustomerList\'", '9');
  +  SELECT 9, PD.ID, '9' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'CustomerList';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (10, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'CustomerInfo\'", '10');
  +  SELECT 10, PD.ID, '10' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'CustomerInfo';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (11, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'CustomerDetail\'", '11');
  +  SELECT 11, PD.ID, '11' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'CustomerDetail';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (12, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'LoginPortlet\'", '12');
  +  SELECT 12, PD.ID, '12' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'LoginPortlet';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (13, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'PortletApplicationBrowser\'",
'13');
  +  SELECT 13, PD.ID, '13' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'PortletApplicationBrowser';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (14, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'PortletApplicationDetail\'",
'14');
  +  SELECT 14, PD.ID, '14' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'PortletApplicationDetail';
   INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
  -  VALUES (15, "SELECT ID FROM PORTLET_DEFINITION WHERE NAME = \'StrutsPortletDemo\'", '15');
  +  SELECT 15, PD.ID, '15' FROM PORTLET_DEFINITION PD WHERE PD.NAME = 'StrutsPortletDemo';
  +
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message