load-data.sql

用struts hibernate 开发的论坛源码! 开发平台:eclipese 3.1.2 web服务器: tomcat 5 数据库: mysql5.0

INSERT INTO USERS(name,login_name,password,email) VALUES ('lzpeng','lzpeng','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('bk','bk','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('kate','kate','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lulu','lulu','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('cavin','cavin','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('rod','rod','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ruby','ruby','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('quake','quake','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lzpeng1','lzpeng1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('bk1','bk1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('kate1','kate1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lulu1','lulu1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('cavin1','cavin1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('rod1','rod1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ruby1','ruby1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('quake1','quake1','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lzpeng2','lzpeng2','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('bk2','b2k','1234526','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ka2te','ka2te','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lu2lu','lul2u','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('cavi2n','ca2vin','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ro2d','r2od','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ruby2','ruby3','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('quak3e','quake4','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lzpen8g','lz7eng','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('b-k','b9k','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ka9e','kat0e','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('lu9lu','lul8u','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('ca7vin','cav7in','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('r5od','r6od','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('rub4y','rub4y','123456','[e-mail]');
INSERT INTO USERS(name,login_name,password,email) VALUES ('quak2e','qua3ke','123456','[e-mail]');



INSERT INTO ROLES(name) VALUES('管理员');
INSERT INTO ROLES(name) VALUES('学生');

INSERT INTO USERS_ROLES(user_id,role_id) VALUES(1,1);
INSERT INTO USERS_ROLES(user_id,role_id) VALUES(2,2);
INSERT INTO USERS_ROLES(user_id,role_id) VALUES(3,2);
INSERT INTO USERS_ROLES(user_id,role_id) VALUES(4,2);
INSERT INTO USERS_ROLES(user_id,role_id) VALUES(5,2);

INSERT INTO BOOKS(title) VALUES ('spring refercnce');
INSERT INTO BOOKS(title) VALUES ('ruby on rails');
INSERT INTO BOOKS(title) VALUES ('struts2 ru men');