加大对Liferay + Alfresco + Apache OFBiz的研究和应用。

对比了6.0和6.1

试着实现扩展原有的核心登录模块,6.1 扩展方便,摸索出一点门道了。而且,6.1的用户界面,更像一个互联网网站。而之前的要传统一些,一看就是portal类型的网站。

以插件、样式、钩子、扩展的方式加载:
  • huihoo-2012-theme-6.1.0.1.war
  • huihoo-liferay-ext-6.1.0.1.war
  • huihoo-login-hook-6.1.0.1.war
  • huihoo-portlet-6.1.0.1.war

select userid,screenname,emailaddress from user_ order by userid desc ;

delete from users_roles where userid > 11501;
delete from user_ where userid > 11501;
delete from contact_ where userid > 11501;
delete from mbmessage where userid > 11501;
delete from assetentry where userid > 11501;

disable重新设置密码:
cp webapps/huihoo-liferay-ext/WEB-INF/ext-web/docroot/WEB-INF/classes/portal-ext.properties to /www/wdlinux/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23/webapps/ROOT/WEB-INF/classes
覆盖已有的

app.server.portal.dir = /www/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23/webapps/ROOT
app.server.lib.global.dir = /www/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23/lib/ext
app.server.deploy.dir = /www/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23/webapps
app.server.type = tomcat
app.server.dir = /www/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23

/www/plugins-sdk/ext/huihoo-liferay-ext
ant direct-deploy

2012年6月27日 微博评论 相关表

添加新表

CREATE TABLE huihoo_app_socialcontent_comment
(
  commentid bigint NOT NULL,
  userid bigint,
  companyid bigint,
  groupid bigint,
  portraiturl character varying(75),
  screenname character varying(75),
  content character varying(140),
  createdat timestamp without time zone,
  socialcontentid bigint,
  CONSTRAINT huihoo_app_socialcontent_comment_pkey PRIMARY KEY (commentid )
)

原表增加字段
huihoo_app_socialcontent 表 
 增加 
commentcount 字段,类型 integer,

alter table huihoo_app_socialcontent add column commentcount integer;
alter table huihoo_app_socialcontent drop column commentcount;

重新部署时,可能会改变content character varying(140)的长度为75,解决这个问题。
alter table huihoo_app_socialcontent alter column content type character varying(140);

@ IBM
https://www.ibm.com/developerworks/mydeveloperworks/profiles/user/openweb