doulun0651
2014-07-11 08:10
浏览 45
已采纳

yii用户和权限扩展安装在postgresql上

I have installed users and rights extension of Yii framework and It is working properly.
I want to migrate to postgresql. The rights extension has mysql and sqlite import files (schema.mysql.sql and schema.sqlite.sql files), but It has not postgresql import file. How can I create rights and users tables in my postgresql db?
should I create the tables by hand?

图片转代码服务由CSDN问答提供 功能建议

我已经安装了Yii框架的用户和权限扩展,并且工作正常。< br> 我想迁移到 postgresql rights 扩展名包含 mysql sqlite 导入文件( schema.mysql.sql schema.sqlite .sql 文件),但它没有 postgresql 导入文件。 如何在postgresql数据库中创建权限和用户表?
我应该手动创建表吗?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • duandui5648 2014-07-19 12:16
    已采纳

    I created the tables by hand and It worked properly, but I needed to exchange some code under protected/modules/rights/components/RDbAuthManager.php.
    I replaced these fields in the sql queries in RDbAuthManager class:

    $itemTable = $this->db->quoteTableName($this->itemTable);
    $rightsTable = $this->db->quoteTableName($this->rightsTable);
    $assignmentTable = $this->db->quoteTableName($this->assignmentTable);
    $itemChildTable = $this->db->quoteTableName($this->itemChildTable);
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题