OpenX数据表添加字段

时间:2021-09-09 12:20:10
OpenX的版本是2.8.9。在数据表加完数据库之后,还不能读取和保存字段。OpenX使用scheme来管理数据库表和字段,修改数据库结构同时也要修改相关schema,一个是etc/tables_core.xml, 另一个是lib/max/Dal/DataObjects/db_schema.ini。在 etc/tables_core.xml 加入<field>结点,用来把数据读出到对象;在 lib/max/Dal/DataObjects/db_schema.ini 相关表声明,等号左边是字段,右边是表示数据类型的代号。具体代号的含义是什么,慢慢研究去。
[zones]zoneid = 129affiliateid = 1zonename = 130description = 130delivery = 129zonetype = 129category = 162width = 129height = 129ad_selection = 162chain = 162prepend = 162append = 162appendtype = 129forceappend = 2inventory_forecast_type = 129comments = 34cost = 1cost_type = 1cost_variable_id = 2technology_cost = 1technology_cost_type = 1updated = 142block = 129capping = 129session_capping = 129show_capped_no_cookie = 129what = 162as_zone_id = 1is_in_ad_direct = 145rate = 1pricing = 130oac_category_id = 1ext_adselection = 130show_capped_no_cookie = 129priority = 130     // char or varchar