Acegi驗證授權(quán)的數(shù)據(jù)庫設(shè)計

CREATE DATABASE acegi;



USE acegi;







CREATE TABLE USERS(  



USERNAME VARCHAR(50) NOT NULL PRIMARY KEY,  



PASSWORD VARCHAR(50) NOT NULL,  



ENABLED BIT NOT NULL



);







INSERT INTO USERS(username,password,enabled) values('caterpillar' ,'123456', 1);



INSERT INTO USERS(username,password,enabled) values('user1' ,'user1pwd', 1);



INSERT INTO USERS(username,password,enabled) values('user2' ,'user2pwd', 0);







CREATE TABLE AUTHORITIES(  



USERNAME VARCHAR( 50 ) NOT NULL,  



AUTHORITY VARCHAR( 50 ) NOT NULL,  



CONSTRAINT FK_AUTHORITIES_USERS FOREIGN KEY(USERNAME) REFERENCES USERS(USERNAME)  



);  







INSERT INTO AUTHORITIES(USERNAME,AUTHORITY) values( 'caterpillar' , 'ROLE_SUPERVISOR');



INSERT INTO AUTHORITIES(USERNAME,AUTHORITY) values( 'user1', 'ROLE_USER');  



INSERT INTO AUTHORITIES(USERNAME,AUTHORITY) values( 'user2', 'ROLE_USER');

posted on 2008-09-26 17:24 劉錚 閱讀(346) 評論(0)  編輯  收藏 所屬分類: Acegi