--
-- Database: Derby
-- Schema for JDBC Realm
-- start
CREATE TABLE usertable (userid VARCHAR(15) NOT NULL, 
                        password varchar(32) NOT NULL, 
                        PRIMARY KEY(userid));
CREATE TABLE grouptable(userid VARCHAR(15)NOT NULL, 
                        groupid VARCHAR(20) NOT NULL,
                        PRIMARY KEY(userid));
ALTER TABLE grouptable ADD CONSTRAINT fk_userid 
                        FOREIGN KEY(userid) REFERENCES usertable(userid)
                        ON DELETE CASCADE;
INSERT INTO usertable VALUES('venu','venu123');
INSERT INTO usertable VALUES('testuser','testpassword');
INSERT INTO usertable VALUES('j2ee','j2ee');
INSERT INTO grouptable VALUES('venu','Management');
INSERT INTO grouptable VALUES('testuser','Management');

-- end