You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2004/05/06 19:30:04 UTC
cvs commit: jakarta-jetspeed-2/src/sql/mysql populate-entities-for-default-psml.sql
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