src/test/sql/derby/derby.ddl.securityapi.sql

 DROP TABLE caller ;
 DROP TABLE caller_groups ;

 CREATE TABLE caller(name VARCHAR(64) PRIMARY KEY, password VARCHAR(1024)) ;
 CREATE TABLE caller_groups(caller_name VARCHAR(64), group_name VARCHAR(64)) ;

 INSERT INTO caller VALUES('tom', 'secret1') ;
 INSERT INTO caller VALUES('emma', 'secret2') ;
 INSERT INTO caller VALUES('bob', 'secret3') ;
 INSERT INTO caller VALUES('tom_hash512_saltsize16', 'PBKDF2WithHmacSHA512:1024:DbjXqT9p8VhJ7OtU6DrqDw==:p/qihG8IZKkz03JzKd6XXA==') ;
 INSERT INTO caller VALUES('tom_hash256_saltsize32', 'PBKDF2WithHmacSHA256:2048:suVayUIJMQMc6wCgckvAIgKRlo1UkxyFXhXbTxX6C7s=:cvdHkBXVUCN2WL3LRAYodeCdNZxEM4RLlNCCYP68Kmg=') ;
 INSERT INTO caller VALUES('tom_hash512_saltsize32', 'PBKDF2WithHmacSHA512:2048:dPTjUfiklfyg2bas/KOQKqEfdtoXK8YvbBscIxA8tNg=:ixBg0wr3ySBI86y8HP7+Yw==') ;
 
 INSERT INTO caller_groups VALUES('tom', 'Administrator') ;
 INSERT INTO caller_groups VALUES('tom', 'Manager') ;

 INSERT INTO caller_groups VALUES('tom_hash512_saltsize16', 'Administrator') ;
 INSERT INTO caller_groups VALUES('tom_hash512_saltsize16', 'Manager') ;
 
 INSERT INTO caller_groups VALUES('tom_hash256_saltsize32', 'Administrator') ;
 INSERT INTO caller_groups VALUES('tom_hash256_saltsize32', 'Manager') ;

 INSERT INTO caller_groups VALUES('tom_hash512_saltsize32', 'Administrator') ;
 INSERT INTO caller_groups VALUES('tom_hash512_saltsize32', 'Manager') ;

 INSERT INTO caller_groups VALUES('emma', 'Administrator') ;
 INSERT INTO caller_groups VALUES('emma', 'Employee') ;

 INSERT INTO caller_groups VALUES('bob', 'Administrator') ;