tumtum/oxid-schema-expander

该软件包最新版本(v1.0.1)没有可用的许可证信息。

库,用于修改OXID eShop数据库。适用于需要自己表单的OXID模块。

v1.0.1 2021-09-16 14:51 UTC

This package is auto-updated.

Last update: 2024-09-16 21:43:01 UTC


README

Build Status

库,用于修改OXID eShop数据库。适用于需要自己表单的OXID模块。

将审查表并如有必要进行扩展或创建。

示例

     public static function onModuleActivation()
     {
         $desire = new DesireExpander();

         // Simple create new table
         $desire
             ->table('tm_example')
                 ->addFieldOxid()
                 ->addFieldOxactive()
                 ->addFieldOxactiveFrom()
                 ->addFieldOxactiveTo()
                 ->addField('OXHASH', "char(32) COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Hash'")
                 ->addField('OXTIME', "int(11) NOT NULL COMMENT 'Validation time'")
                 ->addFieldOxtimestamp()
                 ->setPrimaryKey('OXID');

         // Extent a oxarticles table
         $desire
             ->table('oxarticles')
                 ->addField('MYCOLUMN', "char(32) NOT NULL DEFAULT 'Wowo' COMMENT 'Extent only one Column'")
                 ->after('oxlang');

         // A standard oxid-ee table
         $desire
             ->table('tm_example_enterprice')
                 ->addFieldOxid()
                 ->addFieldOxshopid()
                 ->addFieldOxlang()
                 ->addField('OXHASH', "char(32) COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Hash'")
                 ->addField('OXTIME', "int(11) NOT NULL COMMENT 'Validation time'")
                 ->addFieldOxtimestamp()
                 ->setPrimaryKey('OXID')
                 ->addKey('FASTFIND', [['OXHASH', 12], 'OXTIME']);

         //Commit all Tables
         $desire->execute();
     }

变更日志

[未发布]

v1.0.1 - 2020-03-05

修复

  • 移除了可能的错误,如果在数据库检索模式更改期间。

v1.0.0 - 2020-02-23

  • 发布