user-management icon indicating copy to clipboard operation
user-management copied to clipboard

Published 20 hours ago • verified publisher icon webvimark

Migration not working for OCI

Open M4tho opened this issue 4 years ago • 2 comments

The migration scripts are not working for Oracle Databases.

  1. some dataTypes dont get translated to the oci-equivalents: e.g int should be number(10)

  2. order of default and not null: in oci default is only allowd before the not null instruction

  3. foreign keys cascading oci doesnt support on update cascade and on delete cascade

Installation Specs:

  • Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
  • Yii2: 2.0.35
  • webvimark/module-user-management: 1.0.13

since this is the official user-management extention, and oci is generally supported in yii2, i'd like to know if there is any info about it working with an oracle database or what i can do to get it to run with an oracel db

thanks

M4tho avatar Jul 10 '20 10:07 M4tho

Hi, it's not official and I'm not supporting it for several years already :)

Best way for you is to create a fork with Oracle DB support. It's fast and easy, just change migration files

webvimark avatar Jul 10 '20 14:07 webvimark

@webvimark I'm interested in maintaining this package. Would you transfer its ownership to my company organization https://github.com/congenialbr?

micaelomota avatar Nov 22 '20 16:11 micaelomota