populate-db2.sql

jetspeed源代码

INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','[e-mail]','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','Tommy','Turbine','[e-mail]','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_USER VALUES(3,'anon','anon','Anonymous','User','[e-mail]','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3);
INSERT INTO COFFEES VALUES(1,'ColombianGrade',5,7.99,1,2);
INSERT INTO COFFEES VALUES(2,'KonaGrade',6,7.99,1,2);
INSERT INTO COFFEES VALUES(3,'FrenchRoastGrade',7,7.99,1,2);
INSERT INTO COFFEES VALUES(4,'HazelNutGrade',8,7.99,1,2);
INSERT INTO COFFEES VALUES(5,'VanillaGrade',9,7.99,1,2);
INSERT INTO COFFEES VALUES(6,'JavaGrade',10,7.99,1,2);
INSERT INTO COFFEES VALUES(7,'IndonesianGrade',11,7.99,1,2);
INSERT INTO COFFEES VALUES(8,'OotyGrade',1,7.99,1,2);
INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99,1,2);
INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99,1,2);
INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99,1,2);