-- Script to fill the tables with default roles and permissions
-- The scripts assumes that the ID columns are auto-increment types
--
-- Currently tested with DB2 and Oracle only.

-- Oracle --
insert into TURBINE_ROLE (ROLE_NAME) values ('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 );

-- DB2 --
-- insert into TURBINE_ROLE (ROLE_NAME) values ('authenticated_user');
-- insert into TURBINE_USER (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) values ( 'turbine', 'turbine', 'Turbine', 'Turbine', 'turbine@apache.org', 'CONFIRMED' );
-- insert into TURBINE_USER (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) values ( 'admin', 'jetspeed', 'Admin', 'Admin', 'admin@apache.org', 'CONFIRMED' );

-- Hypersonic --
-- insert into TURBINE_ROLE (ROLE_NAME) values ('authenticated_user');
-- insert into TURBINE_USER (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) values ( 'turbine', 'turbine', 'Turbine', 'Turbine', 'turbine@apache.org', 'CONFIRMED' );
-- insert into TURBINE_USER (LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE ) values ( 'admin', 'jetspeed', 'Admin', 'Admin', 'admin@apache.org', 'CONFIRMED' );


