just before adding authorization service.

[photos] / todo.txt

diff --git a/todo.txt b/todo.txt
new file mode 100644 (file)
index 0000000..35231be
--- /dev/null
+++ b/todo.txt
@@ -0,0 +1,97 @@
+
+- 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 |
+
+
+