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 populate-entities-for-default-psml-mysql.sql
Date Wed, 05 May 2004 20:16:44 GMT
taylor      2004/05/05 13:16:44

  Added:       src/sql  populate-entities-for-default-psml-mysql.sql
  Log:
  ugly patch since My SQL doesn't support this simple syntax:
  
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
    VALUES (15, (SELECT ID FROM PORTLET_DEFINITION WHERE NAME = 'StrutsPortletDemo'), '15');
  
  in particular the nested select statement 
  
  This SQL file is not guaranteed to execute since the primary id for the PortletDefintion
are generated
  
  
  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.1                  jakarta-jetspeed-2/src/sql/populate-entities-for-default-psml-mysql.sql
  
  Index: populate-entities-for-default-psml-mysql.sql
  ===================================================================
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (1, 1, '1');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (2, 2, '2');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (3, 21, '3');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (4, 22, '4');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (5, 23, '5');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (6, 24, '6');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (7, 25, '7');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (8, 26, '8');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (9, 27, '9');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (10, 28, '10');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (11, 29, '11');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (12, 61, '12');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (13, 3, '13');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID) 
    VALUES (14, 4, '14');
  INSERT INTO PORTLET_ENTITY (OID, PORTLET_DEFINITION_ID, ID)
    VALUES (15, 41, '15');
  
  
  

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