- modify database table names. 

rename USERS to SEC_USER;
rename table GROUPS to SEC_GROUP;
rename table USER_GROUPS to SEC_USER_GROUP;

- modify config of flexible jdbc realm. 

  * db query for users 
  * db query for groups
  
- modify database schema.

rename table USER_CONDITIONS to SEC_USER_CONDITION;
update SEC_USER_CONDITION set TYPE = 'ANYUSER' where TYPE = 'ANY';
update SEC_USER_CONDITION set TYPE = 'GROUP' where TYPE = 'URL';

alter table SEC_USER_CONDITION change GROUPNAME GRP varchar(255);
rename table OPERATION_CONDITIONS to SEC_OPERATION_CONDITION;
alter table SEC_OPERATION_CONDITION change OPERATION CLASSNAME varchar(255);
rename table PATH_CONDITIONS to SEC_PATH_CONDITION; 
rename table AUTHORIZATION_RULES to SEC_AUTH_RULE; 
alter table SEC_AUTH_RULE change RESULT AUTH_RESULT varchar(255);
alter table SEC_AUTH_RULE change RESOURCE_CLASSNAME RES_CLASSNAME varchar(255);

alter table SEC_AUTH_RULE drop foreign key FK422045712468C452;
alter table SEC_AUTH_RULE drop foreign key FK42204571FD5B8562;
alter table SEC_AUTH_RULE drop foreign key FK422045712A7093A2;

alter table SEC_AUTH_RULE change USERCONDITION_ID USER_COND_PK bigint(20);
alter table SEC_AUTH_RULE change OPERATIONCONDITION_ID OPER_COND_PK bigint(20);
alter table SEC_AUTH_RULE change PATHCONDITION_ID PATH_COND_PK bigint(20);

alter table SEC_AUTH_RULE drop key FK422045712468C452;
alter table SEC_AUTH_RULE drop key FK42204571FD5B8562;
alter table SEC_AUTH_RULE drop key FK422045712A7093A2;

alter table SEC_AUTH_RULE add foreign key USER_COND_KEY(USER_COND_PK) references SEC_USER_CONDITION (ID);
alter table SEC_AUTH_RULE add foreign key OPER_COND_KEY(OPER_COND_PK) references SEC_OPERATION_CONDITION (ID);
alter table SEC_AUTH_RULE add foreign key PATH_COND_KEY(PATH_COND_PK) references SEC_PATH_CONDITION (ID);

update SEC_AUTH_RULE set RES_CLASSNAME = 'org.wamblee.photos.wicket.BasePage' where RES_CLASSNAME like '%tapestry%';

rename table AUTHORIZATION_SERVICE to SEC_AUTH_SVC;
rename table AUTHORIZATION_SERVICE to SEC_AUTH_SVC;

alter table SEC_AUTH_SVC_RULE drop foreign key FK7DFDBD476CC274C0;
alter table SEC_AUTH_SVC_RULE drop key FK7DFDBD476CC274C0;
alter table SEC_AUTH_SVC_RULE drop foreign key FK7DFDBD47C0669E1B;
alter table SEC_AUTH_SVC_RULE drop key FK7DFDBD47C0669E1B;

alter table SEC_AUTH_SVC_RULE change ID SVC_ID bigint(20);
alter table SEC_AUTH_SVC_RULE change POSITION RULE_INDEX int(11);

alter table SEC_AUTH_SVC_RULE add foreign key SVCKEY(SVC_ID) references SEC_AUTH_SVC(ID);
alter table SEC_AUTH_SVC_RULE add foreign key RULEKEY(RULE_ID) references SEC_AUTH_RULE(ID);



=======================

| SEC_AUTH_RULE | CREATE TABLE `SEC_AUTH_RULE` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE` varchar(255) NOT NULL DEFAULT '',
  `VERSION` int(11) NOT NULL DEFAULT '0',
  `AUTH_RESULT` varchar(255) DEFAULT NULL,
  `RES_CLASSNAME` varchar(255) DEFAULT NULL,
  `USERCONDITION_ID` bigint(20) DEFAULT NULL,
  `PATHCONDITION_ID` bigint(20) DEFAULT NULL,
  `OPERATIONCONDITION_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK422045712468C452` (`OPERATIONCONDITION_ID`),
  KEY `FK42204571FD5B8562` (`USERCONDITION_ID`),
  KEY `FK422045712A7093A2` (`PATHCONDITION_ID`),
  CONSTRAINT `FK422045712468C452` FOREIGN KEY (`OPERATIONCONDITION_ID`) REFERENCES `SEC_OPERATION_CONDITION` (`ID`),
  CONSTRAINT `FK422045712A7093A2` FOREIGN KEY (`PATHCONDITION_ID`) REFERENCES `SEC_PATH_CONDITION` (`ID`),
  CONSTRAINT `FK42204571FD5B8562` FOREIGN KEY (`USERCONDITION_ID`) REFERENCES `SEC_USER_CONDITION` (`ID`)


show create table SEC_AUTH_SVC_RULE;
+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table             | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+-------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| SEC_AUTH_SVC_RULE | CREATE TABLE `SEC_AUTH_SVC_RULE` (
  `ID` bigint(20) NOT NULL DEFAULT '0',
  `RULE_ID` bigint(20) NOT NULL DEFAULT '0',
  `POSITION` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`,`POSITION`),
  KEY `FK7DFDBD476CC274C0` (`ID`),
  KEY `FK7DFDBD47C0669E1B` (`RULE_ID`),
  CONSTRAINT `FK7DFDBD476CC274C0` FOREIGN KEY (`ID`) REFERENCES `SEC_AUTH_SVC` (`ID`),
  CONSTRAINT `FK7DFDBD47C0669E1B` FOREIGN KEY (`RULE_ID`) REFERENCES `SEC_AUTH_RULE` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |