tumtum / oxid-schema-expander
该软件包最新版本(v1.0.1)没有可用的许可证信息。
库,用于修改OXID eShop数据库。适用于需要自己表单的OXID模块。
v1.0.1
2021-09-16 14:51 UTC
Requires (Dev)
This package is auto-updated.
Last update: 2024-09-16 21:43:01 UTC
README
库,用于修改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
- 发布