populate-sqlserver.sql

来自「jetspeed源代码」· SQL 代码 · 共 65 行

SET IDENTITY_INSERT TURBINE_PERMISSION  ON
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(1,'view',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(2,'customize',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(3,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(4,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(5,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(6,'info',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(7,'close',NULL);
INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME, OBJECTDATA) VALUES(8,'detach',NULL);
SET IDENTITY_INSERT TURBINE_PERMISSION OFF

SET IDENTITY_INSERT TURBINE_ROLE  ON
INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME, OBJECTDATA) VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME, OBJECTDATA) VALUES(2,'admin',NULL);
INSERT INTO TURBINE_ROLE (ROLE_ID, ROLE_NAME, OBJECTDATA) VALUES(3,'guest',NULL);
SET IDENTITY_INSERT TURBINE_ROLE  OFF

SET IDENTITY_INSERT TURBINE_GROUP  ON
INSERT INTO TURBINE_GROUP (GROUP_ID, GROUP_NAME, OBJECTDATA) VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP (GROUP_ID, GROUP_NAME, OBJECTDATA) VALUES(2,'apache',NULL);
SET IDENTITY_INSERT TURBINE_GROUP  OFF

SET IDENTITY_INSERT TURBINE_USER  ON
INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN, DISABLED, OBJECTDATA) VALUES(1,'admin','jetspeed','Raphael','Admin','[e-mail]','CONFIRMED',NULL,NULL,NULL,'F',null);
INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN, DISABLED, OBJECTDATA) VALUES(2,'turbine','turbine','David','Turbine','[e-mail]','CONFIRMED',NULL,NULL,NULL,'F',null);
INSERT INTO TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME, EMAIL, CONFIRM_VALUE, MODIFIED, CREATED, LAST_LOGIN, DISABLED, OBJECTDATA) VALUES(3,'anon','anon','Anonymous','User','[e-mail]','CONFIRMED',NULL,NULL,'2001-11-11 18:45:41.671','F',NULL);
SET IDENTITY_INSERT TURBINE_USER  OFF


INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,1);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,2);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,3);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,4);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,5);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(1,6);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,1);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,2);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,3);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,4);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(2,7);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(3,1);
INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID, PERMISSION_ID)  VALUES(3,6);

INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(1,1,2);
INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)  VALUES(3,1,3);

SET IDENTITY_INSERT COFFEES  ON
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(1,'ColombianGrade',5,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(2,'KonaGrade',6,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(3,'FrenchRoastGrade',7,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(4,'HazelNutGrade',8,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(5,'VanillaGrade',9,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(6,'JavaGrade',10,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(7,'IndonesianGrade',11,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(8,'OotyGrade',1,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(9,'KenyanGrade',2,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(10,'JoeGrade',3,7.99E0,1,2)
INSERT INTO COFFEES (COFFEE_ID, COFFEE_NAME, SUPPLIER_ID, PRICE, SALES, TOTAL) VALUES(11,'CantThinkOfAnymoreGrade',4,7.99E0,1,2)
SET IDENTITY_INSERT COFFEES  OFF