INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'view',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'customize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'info',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'close',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(DEFAULT,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(DEFAULT,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(DEFAULT,'admin',NULL);
INSERT INTO TURBINE_ROLE VALUES(DEFAULT,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(DEFAULT,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(DEFAULT,'apache',NULL);
INSERT INTO TURBINE_USER VALUES(DEFAULT,'admin','jetspeed','Jetspeed','Admin','admin@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER VALUES(DEFAULT,'turbine','turbine','Tommy','Turbine','tommy@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER VALUES(DEFAULT,'anon','anon','Anonymous','User','anon@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'view'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'customize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'maximize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'minimize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'personalize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'info'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'view'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'customize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'maximize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'minimize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'personalize'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'info'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'close'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'guest'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'view'));
INSERT INTO TURBINE_ROLE_PERMISSION VALUES((SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'guest'),(SELECT PERMISSION_ID FROM TURBINE_PERMISSION WHERE PERMISSION_NAME = 'info'));
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES((SELECT USER_ID FROM TURBINE_USER WHERE LOGIN_NAME = 'turbine'),(SELECT GROUP_ID FROM TURBINE_GROUP WHERE GROUP_NAME = 'Jetspeed'),(SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'));
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES((SELECT USER_ID FROM TURBINE_USER WHERE LOGIN_NAME = 'admin'),(SELECT GROUP_ID FROM TURBINE_GROUP WHERE GROUP_NAME = 'Jetspeed'),(SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'user'));
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES((SELECT USER_ID FROM TURBINE_USER WHERE LOGIN_NAME = 'admin'),(SELECT GROUP_ID FROM TURBINE_GROUP WHERE GROUP_NAME = 'Jetspeed'),(SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'admin'));
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES((SELECT USER_ID FROM TURBINE_USER WHERE LOGIN_NAME = 'anon'),(SELECT GROUP_ID FROM TURBINE_GROUP WHERE GROUP_NAME = 'Jetspeed'),(SELECT ROLE_ID FROM TURBINE_ROLE WHERE ROLE_NAME = 'guest'));
INSERT INTO COFFEES VALUES(DEFAULT,'ColombianGrade',5,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'KonaGrade',6,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'FrenchRoastGrade',7,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'HazelNutGrade',8,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'VanillaGrade',9,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'JavaGrade',10,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'IndonesianGrade',11,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'OotyGrade',1,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'KenyanGrade',2,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'JoeGrade',3,7.99,1,2);
INSERT INTO COFFEES VALUES(DEFAULT,'CantThinkOfAnymoreGrade',4,7.99,1,2);

