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 2001/03/28 09:10:00 UTC
cvs commit: jakarta-jetspeed/src/sql/external default_roles_permissions.sql
taylor 01/03/27 23:10:00
Modified: src/sql/external default_roles_permissions.sql
Log:
insert statement invalid, missing primary key
Revision Changes Path
1.6 +1 -1 jakarta-jetspeed/src/sql/external/default_roles_permissions.sql
Index: default_roles_permissions.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/default_roles_permissions.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- default_roles_permissions.sql 2000/12/22 13:28:50 1.5
+++ default_roles_permissions.sql 2001/03/28 07:10:00 1.6
@@ -4,7 +4,7 @@
-- Currently tested with DB2 and Oracle only.
-- Oracle --
-insert into TURBINE_ROLE (ROLE_NAME) values ('authenticated_user');
+insert into TURBINE_ROLE (ROLE_ID, ROLE_NAME) values (TURBINE_ROLE_SEQ.NEXTVAL, 'authenticated_user');
insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, CREATED ) values (turbine_user_seq.nextval, 'turbine', 'turbine', 'Turbine', 'Turbine', 'turbine@apache.org', 'CONFIRMED', SYSDATE );
insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, CREATED ) values (turbine_user_seq.nextval, 'admin', 'jetspeed', 'Admin', 'Admin', 'admin@apache.org', 'CONFIRMED', SYSDATE );
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: cvs commit: jakarta-jetspeed/src/sql/external
default_roles_permissions.sql
Posted by Jon Stevens <jo...@latchkey.com>.
on 3/27/01 11:10 PM, "taylor@apache.org" <ta...@apache.org> wrote:
> 'admin@apache.org'
that is not a good address to use. please change it to be something else.
maybe: foo@bar.com
-jon
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org