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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
