openx -书表添加字段

OpenX的版本是2.8.10。在数据表加完数据库之后,还不能读取和保存字段。

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 = 129
affiliateid = 1
zonename = 130
description = 130
delivery = 129
zonetype = 129
category = 162
width = 129
height = 129
ad_selection = 162
chain = 162
prepend = 162
append = 162
appendtype = 129
forceappend = 2
inventory_forecast_type = 129
comments = 34
cost = 1
cost_type = 1
cost_variable_id = 2
technology_cost = 1
technology_cost_type = 1
updated = 142
block = 129
capping = 129
session_capping = 129
show_capped_no_cookie = 129
what = 162
as_zone_id = 1
is_in_ad_direct = 145
rate = 1
pricing = 130
oac_category_id = 1
ext_adselection = 130
show_capped_no_cookie = 129
priority = 130     // char or varchar
posted @ 2018-01-19 16:14  jason&li  阅读(179)  评论(0编辑  收藏  举报