00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028 class Mage_Sales_Model_Entity_Setup extends Mage_Eav_Model_Entity_Setup
00029 {
00030 public function getDefaultEntities()
00031 {
00032 return array(
00033 'quote'=>array(
00034 'entity_model' => 'sales/quote',
00035 'table' => 'sales/quote',
00036 'attributes' => array(
00037 'entity_id' => array('type'=>'static'),
00038 'is_active' => array('type'=>'static'),
00039 'store_id' => array('type'=>'static'),
00040 'remote_ip' => array('type'=>'static'),
00041 'checkout_method' => array('type'=>'static'),
00042 'password_hash' => array('type'=>'static'),
00043 'quote_status_id' => array('type'=>'static'),
00044 'billing_address_id'=> array('type'=>'static'),
00045 'orig_order_id' => array('type'=>'static'),
00046 'converted_at' => array('type'=>'static'),
00047 'reserved_order_id' => array('type'=>'static'),
00048
00049 'coupon_code' => array('type'=>'static'),
00050 'global_currency_code' => array('type'=>'static'),
00051 'base_currency_code' => array('type'=>'static'),
00052 'store_currency_code' => array('type'=>'static'),
00053 'quote_currency_code' => array('type'=>'static'),
00054 'store_to_base_rate' => array('type'=>'static'),
00055 'store_to_quote_rate' => array('type'=>'static'),
00056 'base_to_global_rate' => array('type'=>'static'),
00057 'base_to_quote_rate' => array('type'=>'static'),
00058
00059 'items_count'=> array('type'=>'static'),
00060 'items_qty'=> array('type'=>'static'),
00061
00062 'custbalance_amount'=> array('type'=>'static'),
00063 'grand_total' => array('type'=>'static'),
00064 'base_grand_total' => array('type'=>'static'),
00065
00066 'applied_rule_ids' => array('type'=>'static'),
00067
00068 'is_virtual' => array('type'=>'static'),
00069 'is_multi_shipping' => array('type'=>'static'),
00070 'is_multi_payment' => array('type'=>'static'),
00071
00072 'customer_id' => array('type'=>'static'),
00073 'customer_tax_class_id' => array('type'=>'static'),
00074 'customer_group_id' => array('type'=>'static'),
00075 'customer_email' => array('type'=>'static'),
00076 'customer_prefix' => array('type'=>'static'),
00077 'customer_firstname'=> array('type'=>'static'),
00078 'customer_middlename'=>array('type'=>'static'),
00079 'customer_lastname' => array('type'=>'static'),
00080 'customer_suffix' => array('type'=>'static'),
00081 'customer_note' => array('type'=>'static'),
00082 'customer_note_notify' => array('type'=>'static'),
00083 'customer_is_guest' => array('type'=>'static'),
00084 ),
00085 ),
00086
00087 'quote_item' => array(
00088 'entity_model' => 'sales/quote_item',
00089 'table' => 'sales/quote_item',
00090 'attributes' => array(
00091 'parent_id' => array('type'=>'static'),
00092 'product_id' => array('type'=>'static'),
00093 'super_product_id' => array('type'=>'static'),
00094 'parent_product_id' => array('type'=>'static'),
00095 'sku' => array('type'=>'static'),
00096 'name' => array('type'=>'static'),
00097 'description' => array('type'=>'static'),
00098
00099 'weight' => array('type'=>'static'),
00100 'free_shipping' => array('type'=>'static'),
00101 'qty' => array('type'=>'static'),
00102 'is_qty_decimal'=> array('type'=>'static'),
00103
00104 'price' => array('type'=>'static'),
00105 'custom_price' => array('type'=>'static'),
00106 'discount_percent' => array('type'=>'static'),
00107 'discount_amount' => array('type'=>'static'),
00108 'no_discount' => array('type'=>'static'),
00109 'tax_percent' => array('type'=>'static'),
00110 'tax_amount' => array('type'=>'static'),
00111 'row_total' => array('type'=>'static'),
00112 'row_total_with_discount' => array('type'=>'static'),
00113
00114 'base_price' => array('type'=>'static'),
00115 'base_discount_amount' => array('type'=>'static'),
00116 'base_tax_amount' => array('type'=>'static'),
00117 'base_row_total' => array('type'=>'static'),
00118
00119 'row_weight' => array('type'=>'static'),
00120 'applied_rule_ids' => array('type'=>'static'),
00121 'additional_data' => array('type'=>'static'),
00122
00123 'tax_string' => array('type'=>'text'),
00124 ),
00125 ),
00126
00127 'quote_address' => array(
00128 'entity_model' => 'sales/quote_address',
00129 'table' => 'sales/quote_address',
00130 'attributes' => array(
00131 'entity_id' => array('type'=>'static'),
00132 'parent_id' => array('type'=>'static'),
00133 'address_type' => array('type'=>'static'),
00134
00135 'customer_id' => array('type'=>'static'),
00136 'customer_address_id' => array('type'=>'static'),
00137 'save_in_address_book' => array('type'=>'static'),
00138 'email' => array('type'=>'static'),
00139 'prefix' => array('type'=>'static'),
00140 'firstname' => array('type'=>'static'),
00141 'middlename'=> array('type'=>'static'),
00142 'lastname' => array('type'=>'static'),
00143 'suffix' => array('type'=>'static'),
00144 'company' => array('type'=>'static'),
00145 'street' => array('type'=>'static'),
00146 'city' => array('type'=>'static'),
00147 'region' => array('type'=>'static'),
00148 'region_id' => array('type'=>'static'),
00149 'postcode' => array('type'=>'static'),
00150 'country_id'=> array('type'=>'static'),
00151 'telephone' => array('type'=>'static'),
00152 'fax' => array('type'=>'static'),
00153
00154 'same_as_billing' => array('type'=>'static'),
00155 'free_shipping' => array('type'=>'static'),
00156 'weight' => array('type'=>'static'),
00157 'collect_shipping_rates' => array('type'=>'static'),
00158
00159 'shipping_method' => array('type'=>'static'),
00160 'shipping_description' => array('type'=>'static'),
00161
00162 'subtotal' => array('type'=>'static'),
00163 'subtotal_with_discount' => array('type'=>'static'),
00164 'tax_amount' => array('type'=>'static'),
00165 'shipping_amount' => array('type'=>'static'),
00166 'discount_amount' => array('type'=>'static'),
00167 'custbalance_amount'=> array('type'=>'static'),
00168 'grand_total' => array('type'=>'static'),
00169
00170 'base_subtotal' => array('type'=>'static'),
00171 'base_subtotal_with_discount' => array('type'=>'static'),
00172 'base_tax_amount' => array('type'=>'static'),
00173 'base_shipping_amount' => array('type'=>'static'),
00174 'base_discount_amount' => array('type'=>'static'),
00175 'base_custbalance_amount' => array('type'=>'static'),
00176 'base_grand_total' => array('type'=>'static'),
00177
00178 'customer_notes' => array('type'=>'static'),
00179
00180 'tax_string' => array('type'=>'text'),
00181 ),
00182 ),
00183 'quote_address_item' => array(
00184 'entity_model' => 'sales/quote_address_item',
00185 'table' =>'sales/quote_entity',
00186 'attributes' => array(
00187 'parent_id' => array('type'=>'static'),
00188 'quote_item_id' => array('type'=>'int'),
00189 'product_id' => array('type'=>'int'),
00190 'super_product_id' => array('type'=>'int'),
00191 'parent_product_id' => array('type'=>'int'),
00192 'sku' => array(),
00193 'image' => array(),
00194 'name' => array(),
00195 'description' => array('type'=>'text'),
00196
00197 'weight' => array('type'=>'decimal'),
00198 'free_shipping' => array('type'=>'int'),
00199 'qty' => array('type'=>'decimal'),
00200 'is_qty_decimal'=> array('type'=>'int'),
00201
00202 'price' => array('type'=>'decimal'),
00203 'discount_percent' => array('type'=>'decimal'),
00204 'discount_amount' => array('type'=>'decimal'),
00205 'no_discount' => array('type'=>'int'),
00206 'tax_percent' => array('type'=>'decimal'),
00207 'tax_amount' => array('type'=>'decimal'),
00208 'row_total' => array('type'=>'decimal'),
00209 'row_total_with_discount' => array('type'=>'decimal'),
00210
00211 'base_price' => array('type'=>'decimal'),
00212 'base_discount_amount' => array('type'=>'decimal'),
00213 'base_tax_amount' => array('type'=>'decimal'),
00214 'base_row_total' => array('type'=>'decimal'),
00215
00216 'row_weight' => array('type'=>'decimal'),
00217 'applied_rule_ids' => array(),
00218 'additional_data' => array('type'=>'text'),
00219 ),
00220 ),
00221 'quote_address_rate' => array(
00222 'entity_model' => 'sales/quote_address_rate',
00223 'table' => 'sales/quote_entity',
00224 'attributes' => array(
00225 'parent_id' => array('type'=>'static'),
00226 'code' => array(),
00227 'carrier' => array(),
00228 'carrier_title' => array(),
00229 'method' => array(),
00230 'method_description' => array('type'=>'text'),
00231 'price' => array('type'=>'decimal'),
00232 'error_message' => array('type'=>'text'),
00233 ),
00234 ),
00235 'quote_payment' => array(
00236 'entity_model' => 'sales/quote_payment',
00237 'table' =>'sales/quote_entity',
00238 'attributes' => array(
00239 'parent_id' => array('type'=>'static'),
00240 'method' => array(),
00241 'additional_data' => array('type'=>'text'),
00242 'po_number' => array(),
00243 'cc_type' => array(),
00244 'cc_number_enc' => array(),
00245 'cc_last4' => array(),
00246 'cc_owner' => array(),
00247 'cc_exp_month' => array('type'=>'int'),
00248 'cc_exp_year' => array('type'=>'int'),
00249 'cc_cid_enc' => array(),
00250 'cc_ss_issue' => array(),
00251 'cc_ss_start_month' => array('type'=>'int'),
00252 'cc_ss_start_year' => array('type'=>'int'),
00253 ),
00254 ),
00255
00256 'order' => array(
00257 'entity_model' => 'sales/order',
00258 'table'=>'sales/order',
00259 'increment_model'=>'eav/entity_increment_numeric',
00260 'increment_per_store'=>true,
00261 'backend_prefix'=>'sales_entity/order_attribute_backend',
00262 'attributes' => array(
00263 'entity_id' => array(
00264 'type'=>'static',
00265 'backend'=>'sales_entity/order_attribute_backend_parent'
00266 ),
00267 'store_id' => array('type'=>'static'),
00268 'store_name' => array('type'=>'varchar'),
00269 'remote_ip' => array(),
00270
00271 'status' => array('type'=>'varchar'),
00272 'state' => array('type'=>'varchar'),
00273 'hold_before_status' => array('type'=>'varchar'),
00274 'hold_before_state' => array('type'=>'varchar'),
00275
00276 'relation_parent_id' => array('type'=>'varchar'),
00277 'relation_parent_real_id' => array('type'=>'varchar'),
00278 'relation_child_id' => array('type'=>'varchar'),
00279 'relation_child_real_id' => array('type'=>'varchar'),
00280 'original_increment_id' => array('type'=>'varchar'),
00281 'edit_increment' => array('type'=>'int'),
00282
00283 'ext_order_id' => array('type'=>'varchar'),
00284 'ext_customer_id' => array('type'=>'varchar'),
00285
00286 'quote_id' => array('type'=>'int'),
00287 'quote_address_id' => array('type'=>'int'),
00288 'billing_address_id' => array('type'=>'int', 'backend'=>'_billing'),
00289 'shipping_address_id' => array('type'=>'int', 'backend'=>'_shipping'),
00290
00291 'coupon_code' => array(),
00292 'applied_rule_ids' => array(),
00293 'giftcert_code' => array(),
00294
00295 'global_currency_code' => array(),
00296 'base_currency_code' => array(),
00297 'store_currency_code' => array(),
00298 'order_currency_code' => array(),
00299 'store_to_base_rate' => array('type'=>'decimal'),
00300 'store_to_order_rate' => array('type'=>'decimal'),
00301 'base_to_global_rate' => array('type'=>'decimal'),
00302 'base_to_order_rate' => array('type'=>'decimal'),
00303
00304 'is_virtual' => array('type'=>'int'),
00305 'is_multi_payment' => array('type'=>'int'),
00306
00307 'shipping_method' => array(),
00308 'shipping_description' => array(),
00309 'weight' => array('type'=>'decimal'),
00310
00311 'tax_amount' => array('type'=>'static'),
00312 'shipping_amount' => array('type'=>'static'),
00313 'discount_amount' => array('type'=>'static'),
00314 'giftcert_amount' => array('type'=>'decimal'),
00315 'custbalance_amount'=> array('type'=>'decimal'),
00316
00317 'subtotal' => array('type'=>'static'),
00318 'grand_total' => array('type'=>'static'),
00319 'total_paid' => array('type'=>'static'),
00320 'total_due' => array('type'=>'decimal'),
00321 'total_refunded' => array('type'=>'static'),
00322 'total_qty_ordered' => array('type'=>'static'),
00323 'total_canceled' => array('type'=>'static'),
00324 'total_invoiced' => array('type'=>'static'),
00325 'total_online_refunded' => array('type'=>'static'),
00326 'total_offline_refunded'=> array('type'=>'static'),
00327 'adjustment_positive' => array('type'=>'decimal'),
00328 'adjustment_negative' => array('type'=>'decimal'),
00329
00330 'base_tax_amount' => array('type'=>'static'),
00331 'base_shipping_amount' => array('type'=>'static'),
00332 'base_discount_amount' => array('type'=>'static'),
00333 'base_giftcert_amount' => array('type'=>'decimal'),
00334 'base_custbalance_amount'=> array('type'=>'decimal'),
00335
00336 'base_subtotal' => array('type'=>'static'),
00337 'base_grand_total' => array('type'=>'static'),
00338 'base_total_paid' => array('type'=>'static'),
00339 'base_total_due' => array('type'=>'decimal'),
00340 'base_total_refunded' => array('type'=>'static'),
00341 'base_total_qty_ordered' => array('type'=>'static'),
00342 'base_total_canceled' => array('type'=>'static'),
00343 'base_total_invoiced' => array('type'=>'static'),
00344 'base_total_online_refunded' => array('type'=>'static'),
00345 'base_total_offline_refunded'=> array('type'=>'static'),
00346 'base_adjustment_positive' => array('type'=>'decimal'),
00347 'base_adjustment_negative' => array('type'=>'decimal'),
00348
00349 'subtotal_refunded' => array('type'=>'static'),
00350 'subtotal_canceled' => array('type'=>'static'),
00351 'discount_refunded' => array('type'=>'static'),
00352 'discount_canceled' => array('type'=>'static'),
00353 'discount_invoiced' => array('type'=>'static'),
00354 'subtotal_invoiced' => array('type'=>'static'),
00355 'tax_refunded' => array('type'=>'static'),
00356 'tax_canceled' => array('type'=>'static'),
00357 'tax_invoiced' => array('type'=>'static'),
00358 'shipping_refunded' => array('type'=>'static'),
00359 'shipping_canceled' => array('type'=>'static'),
00360 'shipping_invoiced' => array('type'=>'static'),
00361 'base_subtotal_refunded' => array('type'=>'static'),
00362 'base_subtotal_canceled' => array('type'=>'static'),
00363 'base_discount_refunded' => array('type'=>'static'),
00364 'base_discount_canceled' => array('type'=>'static'),
00365 'base_discount_invoiced' => array('type'=>'static'),
00366 'base_subtotal_invoiced' => array('type'=>'static'),
00367 'base_tax_refunded' => array('type'=>'static'),
00368 'base_tax_canceled' => array('type'=>'static'),
00369 'base_tax_invoiced' => array('type'=>'static'),
00370 'base_shipping_refunded' => array('type'=>'static'),
00371 'base_shipping_canceled' => array('type'=>'static'),
00372 'base_shipping_invoiced' => array('type'=>'static'),
00373
00374 'customer_id' => array('type'=>'static', 'visible'=>false),
00375 'customer_group_id' => array('type'=>'int', 'visible'=>false),
00376 'customer_email' => array('type'=>'varchar', 'visible'=>false),
00377 'customer_prefix' => array('type'=>'varchar', 'visible'=>false),
00378 'customer_firstname'=> array('type'=>'varchar', 'visible'=>false),
00379 'customer_middlename' => array('type'=>'varchar', 'visible'=>false),
00380 'customer_lastname' => array('type'=>'varchar', 'visible'=>false),
00381 'customer_suffix' => array('type'=>'varchar', 'visible'=>false),
00382 'customer_note' => array('type'=>'text', 'visible'=>false),
00383 'customer_note_notify' => array('type'=>'int', 'visible'=>false),
00384 'customer_is_guest' => array('type'=>'int', 'visible'=>false),
00385 'email_sent' => array('type'=>'int', 'visible'=>false),
00386 ),
00387 ),
00388 'order_address' => array(
00389 'entity_model' => 'sales/order_address',
00390 'table'=>'sales/order_entity',
00391 'attributes' => array(
00392 'parent_id' => array('type'=>'static', 'backend'=>'sales_entity/order_attribute_backend_child'),
00393 'quote_address_id' => array('type'=>'int'),
00394 'address_type' => array(),
00395 'customer_id' => array('type'=>'int'),
00396 'customer_address_id' => array('type'=>'int'),
00397 'email' => array(),
00398 'prefix' => array(),
00399 'firstname' => array(),
00400 'middlename'=> array(),
00401 'lastname' => array(),
00402 'suffix' => array(),
00403 'company' => array(),
00404 'street' => array(),
00405 'city' => array(),
00406 'region' => array(),
00407 'region_id' => array('type'=>'int'),
00408 'postcode' => array(),
00409 'country_id'=> array('type'=>'varchar'),
00410 'telephone' => array(),
00411 'fax' => array(),
00412 'tax_string' => array('type'=>'text'),
00413 ),
00414 ),
00415 'order_item' => array(
00416 'entity_model' => 'sales/order_item',
00417 'table'=>'sales/order_entity',
00418 'attributes' => array(
00419 'parent_id' => array(
00420 'type'=>'static',
00421 'backend'=>'sales_entity/order_attribute_backend_child'
00422 ),
00423
00424 'quote_item_id' => array('type'=>'int'),
00425 'product_id' => array('type'=>'int'),
00426 'super_product_id' => array('type'=>'int'),
00427 'parent_product_id' => array('type'=>'int'),
00428 'sku' => array(),
00429 'name' => array(),
00430 'description' => array('type'=>'text'),
00431 'weight' => array('type'=>'decimal'),
00432
00433 'is_qty_decimal' => array('type'=>'int'),
00434 'qty_ordered' => array('type'=>'decimal'),
00435 'qty_backordered' => array('type'=>'decimal'),
00436 'qty_invoiced' => array('type'=>'decimal'),
00437 'qty_canceled' => array('type'=>'decimal'),
00438 'qty_shipped' => array('type'=>'decimal'),
00439 'qty_refunded' => array('type'=>'decimal'),
00440
00441 'original_price' => array('type'=>'decimal'),
00442 'price' => array('type'=>'decimal'),
00443 'cost' => array('type'=>'decimal'),
00444
00445 'discount_percent' => array('type'=>'decimal'),
00446 'discount_amount' => array('type'=>'decimal'),
00447 'discount_invoiced' => array('type'=>'decimal'),
00448
00449 'tax_percent' => array('type'=>'decimal'),
00450 'tax_amount' => array('type'=>'decimal'),
00451 'tax_invoiced' => array('type'=>'decimal'),
00452 'tax_string' => array('type'=>'text'),
00453
00454 'row_total' => array('type'=>'decimal'),
00455 'row_weight' => array('type'=>'decimal'),
00456 'row_invoiced' => array('type'=>'decimal'),
00457 'invoiced_total' => array('type'=>'decimal'),
00458 'amount_refunded' => array('type'=>'decimal'),
00459
00460 'base_price' => array('type'=>'decimal'),
00461 'base_original_price' => array('type'=>'decimal'),
00462 'base_discount_amount' => array('type'=>'decimal'),
00463 'base_discount_invoiced' => array('type'=>'decimal'),
00464 'base_tax_amount' => array('type'=>'decimal'),
00465 'base_tax_invoiced' => array('type'=>'decimal'),
00466 'base_row_total' => array('type'=>'decimal'),
00467 'base_row_invoiced' => array('type'=>'decimal'),
00468 'base_invoiced_total' => array('type'=>'decimal'),
00469 'base_amount_refunded' => array('type'=>'decimal'),
00470
00471 'applied_rule_ids' => array(),
00472 'additional_data' => array('type'=>'text'),
00473 ),
00474 ),
00475 'order_payment' => array(
00476 'entity_model' => 'sales/order_payment',
00477 'table'=>'sales/order_entity',
00478 'attributes' => array(
00479 'parent_id' => array(
00480 'type'=>'static',
00481 'backend'=>'sales_entity/order_attribute_backend_child'
00482 ),
00483 'quote_payment_id' => array('type'=>'int'),
00484 'method' => array(),
00485 'additional_data' => array('type'=>'text'),
00486 'last_trans_id' => array(),
00487 'po_number' => array(),
00488
00489 'cc_type' => array(),
00490 'cc_number_enc' => array(),
00491 'cc_last4' => array(),
00492 'cc_owner' => array(),
00493 'cc_exp_month' => array(),
00494 'cc_exp_year' => array(),
00495
00496 'cc_ss_issue' => array(),
00497 'cc_ss_start_month' => array(),
00498 'cc_ss_start_year' => array(),
00499
00500 'cc_status' => array(),
00501 'cc_status_description' => array(),
00502 'cc_trans_id' => array(),
00503 'cc_approval' => array(),
00504 'cc_avs_status' => array(),
00505 'cc_cid_status' => array(),
00506
00507 'cc_debug_request_body' => array(),
00508 'cc_debug_response_body'=> array(),
00509 'cc_debug_response_serialized' => array(),
00510
00511 'anet_trans_method' => array(),
00512 'echeck_routing_number' => array(),
00513 'echeck_bank_name' => array(),
00514 'echeck_account_type' => array(),
00515 'echeck_account_name' => array(),
00516 'echeck_type' => array(),
00517
00518 'amount_ordered' => array('type'=>'decimal'),
00519 'amount_authorized' => array('type'=>'decimal'),
00520 'amount_paid' => array('type'=>'decimal'),
00521 'amount_canceled' => array('type'=>'decimal'),
00522 'amount_refunded' => array('type'=>'decimal'),
00523 'shipping_amount' => array('type'=>'decimal'),
00524 'shipping_captured' => array('type'=>'decimal'),
00525 'shipping_refunded' => array('type'=>'decimal'),
00526
00527 'base_amount_ordered' => array('type'=>'decimal'),
00528 'base_amount_authorized' => array('type'=>'decimal'),
00529 'base_amount_paid' => array('type'=>'decimal'),
00530 'base_amount_canceled' => array('type'=>'decimal'),
00531 'base_amount_refunded' => array('type'=>'decimal'),
00532 'base_shipping_amount' => array('type'=>'decimal'),
00533 'base_shipping_captured' => array('type'=>'decimal'),
00534 'base_shipping_refunded' => array('type'=>'decimal'),
00535 ),
00536 ),
00537
00538 'order_status_history' => array(
00539 'entity_model' => 'sales/order_status_history',
00540 'table'=>'sales/order_entity',
00541 'attributes' => array(
00542 'parent_id' => array(
00543 'type'=>'static',
00544 'backend'=>'sales_entity/order_attribute_backend_child'
00545 ),
00546 'status' => array('type'=>'varchar'),
00547 'comment' => array('type'=>'text'),
00548 'is_customer_notified' => array('type'=>'int'),
00549 ),
00550 ),
00551
00552 'invoice' => array(
00553 'entity_model' => 'sales/order_invoice',
00554 'table' =>'sales/order_entity',
00555 'increment_model' =>'eav/entity_increment_numeric',
00556 'increment_per_store'=>true,
00557 'backend_prefix' =>'sales_entity/order_attribute_backend',
00558 'attributes' => array(
00559 'entity_id' => array(
00560 'type'=>'static',
00561 'backend'=>'sales_entity/order_invoice_attribute_backend_parent'
00562 ),
00563
00564 'state' => array('type'=>'int'),
00565 'is_used_for_refund' => array('type'=>'int'),
00566 'transaction_id' => array(),
00567
00568
00569 'order_id' => array(
00570 'type'=>'int',
00571 'backend'=>'sales_entity/order_invoice_attribute_backend_order'
00572 ),
00573
00574 'billing_address_id' => array('type'=>'int'),
00575 'shipping_address_id' => array('type'=>'int'),
00576
00577 'global_currency_code' => array(),
00578 'base_currency_code' => array(),
00579 'store_currency_code' => array(),
00580 'order_currency_code' => array(),
00581 'store_to_base_rate' => array('type'=>'decimal'),
00582 'store_to_order_rate' => array('type'=>'decimal'),
00583 'base_to_global_rate' => array('type'=>'decimal'),
00584 'base_to_order_rate' => array('type'=>'decimal'),
00585
00586 'subtotal' => array('type'=>'decimal'),
00587 'discount_amount' => array('type'=>'decimal'),
00588 'tax_amount' => array('type'=>'decimal'),
00589 'shipping_amount' => array('type'=>'decimal'),
00590 'grand_total' => array('type'=>'decimal'),
00591 'total_qty' => array('type'=>'decimal'),
00592
00593 'can_void_flag' => array('type'=>'int'),
00594
00595 'base_subtotal' => array('type'=>'decimal'),
00596 'base_discount_amount' => array('type'=>'decimal'),
00597 'base_tax_amount' => array('type'=>'decimal'),
00598 'base_shipping_amount' => array('type'=>'decimal'),
00599 'base_grand_total' => array('type'=>'decimal'),
00600 'email_sent' => array('type'=>'int'),
00601 ),
00602 ),
00603
00604 'invoice_item' => array(
00605 'entity_model' => 'sales/order_invoice_item',
00606
00607 'table'=>'sales/order_entity',
00608 'attributes' => array(
00609 'parent_id' => array(
00610 'type'=>'static',
00611 'backend'=>'sales_entity/order_invoice_attribute_backend_child'
00612 ),
00613 'order_item_id' => array('type'=>'int'),
00614 'product_id' => array('type'=>'int'),
00615 'name' => array(),
00616 'description' => array('type'=>'text'),
00617 'sku' => array(),
00618 'qty' => array('type'=>'decimal'),
00619 'cost' => array('type'=>'decimal'),
00620 'price' => array('type'=>'decimal'),
00621 'discount_amount' => array('type'=>'decimal'),
00622 'tax_amount' => array('type'=>'decimal'),
00623 'row_total' => array('type'=>'decimal'),
00624
00625 'base_price' => array('type'=>'decimal'),
00626 'base_discount_amount' => array('type'=>'decimal'),
00627 'base_tax_amount' => array('type'=>'decimal'),
00628 'base_row_total' => array('type'=>'decimal'),
00629
00630 'additional_data' => array('type'=>'text'),
00631 ),
00632 ),
00633
00634 'invoice_comment' => array(
00635 'entity_model' => 'sales/order_invoice_comment',
00636 'table'=>'sales/order_entity',
00637 'attributes' => array(
00638 'parent_id' => array(
00639 'type'=>'static',
00640 'backend'=>'sales_entity/order_invoice_attribute_backend_child'
00641 ),
00642 'comment' => array('type'=>'text'),
00643 'is_customer_notified' => array('type'=>'int'),
00644 ),
00645 ),
00646
00647
00648
00649 'shipment' => array(
00650 'entity_model' => 'sales/order_shipment',
00651
00652 'table'=>'sales/order_entity',
00653 'increment_model'=>'eav/entity_increment_numeric',
00654 'increment_per_store'=>true,
00655 'backend_prefix'=>'sales_entity/order_attribute_backend',
00656 'attributes' => array(
00657 'entity_id' => array(
00658 'type'=>'static',
00659 'backend'=>'sales_entity/order_shipment_attribute_backend_parent'
00660 ),
00661
00662 'customer_id' => array('type'=>'int'),
00663 'order_id' => array('type'=>'int'),
00664 'shipment_status' => array('type'=>'int'),
00665 'billing_address_id' => array('type'=>'int'),
00666 'shipping_address_id' => array('type'=>'int'),
00667
00668 'total_qty' => array('type'=>'decimal'),
00669 'total_weight' => array('type'=>'decimal'),
00670 'email_sent' => array('type'=>'int'),
00671 ),
00672 ),
00673
00674 'shipment_item' => array(
00675 'entity_model' => 'sales/order_shipment_item',
00676
00677 'table'=>'sales/order_entity',
00678 'attributes' => array(
00679 'parent_id' => array(
00680 'type'=>'static',
00681 'backend'=>'sales_entity/order_shipment_attribute_backend_child'
00682 ),
00683 'order_item_id' => array('type'=>'int'),
00684 'product_id' => array('type'=>'int'),
00685 'name' => array(),
00686 'description' => array('type'=>'text'),
00687 'sku' => array(),
00688 'qty' => array('type'=>'decimal'),
00689 'price' => array('type'=>'decimal'),
00690 'weight' => array('type'=>'decimal'),
00691 'row_total' => array('type'=>'decimal'),
00692
00693 'additional_data' => array('type'=>'text'),
00694 ),
00695 ),
00696
00697 'shipment_comment' => array(
00698 'entity_model' => 'sales/order_shipment_comment',
00699 'table'=>'sales/order_entity',
00700 'attributes' => array(
00701 'parent_id' => array(
00702 'type'=>'static',
00703 'backend'=>'sales_entity/order_shipment_attribute_backend_child'
00704 ),
00705 'comment' => array('type'=>'text'),
00706 'is_customer_notified' => array('type'=>'int'),
00707 ),
00708 ),
00709
00710 'shipment_track' => array(
00711 'entity_model' => 'sales/order_shipment_track',
00712 'table'=>'sales/order_entity',
00713 'attributes' => array(
00714 'parent_id' => array(
00715 'type'=>'static',
00716 'backend'=>'sales_entity/order_shipment_attribute_backend_child'
00717 ),
00718 'order_id' => array('type'=>'int'),
00719 'number' => array('type'=>'text'),
00720 'carrier_code' => array('type'=>'varchar'),
00721 'title' => array('type'=>'varchar'),
00722 'description' => array('type'=>'text'),
00723 'qty' => array('type'=>'decimal'),
00724 'weight' => array('type'=>'decimal'),
00725 ),
00726 ),
00727
00728 'creditmemo' => array(
00729 'entity_model' => 'sales/order_creditmemo',
00730
00731 'table'=>'sales/order_entity',
00732 'increment_model'=>'eav/entity_increment_numeric',
00733 'increment_per_store'=>true,
00734 'backend_prefix'=>'sales_entity/order_attribute_backend',
00735 'attributes' => array(
00736 'entity_id' => array(
00737 'type'=>'static',
00738 'backend'=>'sales_entity/order_creditmemo_attribute_backend_parent'
00739 ),
00740 'state' => array('type'=>'int'),
00741 'invoice_id' => array('type'=>'int'),
00742 'transaction_id'=> array(),
00743
00744 'order_id' => array('type'=>'int'),
00745 'creditmemo_status' => array('type'=>'int'),
00746 'billing_address_id' => array('type'=>'int'),
00747 'shipping_address_id' => array('type'=>'int'),
00748
00749 'global_currency_code' => array(),
00750 'base_currency_code' => array(),
00751 'store_currency_code' => array(),
00752 'order_currency_code' => array(),
00753 'store_to_base_rate' => array('type'=>'decimal'),
00754 'store_to_order_rate' => array('type'=>'decimal'),
00755 'base_to_global_rate' => array('type'=>'decimal'),
00756 'base_to_order_rate' => array('type'=>'decimal'),
00757
00758 'subtotal' => array('type'=>'decimal'),
00759 'discount_amount' => array('type'=>'decimal'),
00760 'tax_amount' => array('type'=>'decimal'),
00761 'shipping_amount' => array('type'=>'decimal'),
00762 'adjustment' => array('type'=>'decimal'),
00763 'adjustment_positive' => array('type'=>'decimal'),
00764 'adjustment_negative' => array('type'=>'decimal'),
00765 'grand_total' => array('type'=>'decimal'),
00766
00767 'base_subtotal' => array('type'=>'decimal'),
00768 'base_discount_amount' => array('type'=>'decimal'),
00769 'base_tax_amount' => array('type'=>'decimal'),
00770 'base_shipping_amount' => array('type'=>'decimal'),
00771 'base_adjustment' => array('type'=>'decimal'),
00772 'base_adjustment_positive' => array('type'=>'decimal'),
00773 'base_adjustment_negative' => array('type'=>'decimal'),
00774 'base_grand_total' => array('type'=>'decimal'),
00775 'email_sent' => array('type'=>'int'),
00776 ),
00777 ),
00778
00779 'creditmemo_item' => array(
00780 'entity_model' => 'sales/order_creditmemo_item',
00781
00782 'table'=>'sales/order_entity',
00783 'attributes' => array(
00784 'parent_id' => array(
00785 'type'=>'static',
00786 'backend'=>'sales_entity/order_creditmemo_attribute_backend_child'
00787 ),
00788 'order_item_id' => array('type'=>'int'),
00789 'product_id' => array('type'=>'int'),
00790 'name' => array(),
00791 'description' => array('type'=>'text'),
00792 'sku' => array(),
00793 'qty' => array('type'=>'decimal'),
00794 'cost' => array('type'=>'decimal'),
00795 'price' => array('type'=>'decimal'),
00796 'discount_amount' => array('type'=>'decimal'),
00797 'tax_amount' => array('type'=>'decimal'),
00798 'row_total' => array('type'=>'decimal'),
00799
00800 'base_price' => array('type'=>'decimal'),
00801 'base_discount_amount' => array('type'=>'decimal'),
00802 'base_tax_amount' => array('type'=>'decimal'),
00803 'base_row_total' => array('type'=>'decimal'),
00804
00805 'additional_data' => array('type'=>'text'),
00806 ),
00807 ),
00808
00809 'creditmemo_comment' => array(
00810 'entity_model' => 'sales/order_creditmemo_comment',
00811 'table'=>'sales/order_entity',
00812 'attributes' => array(
00813 'parent_id' => array(
00814 'type'=>'static',
00815 'backend'=>'sales_entity/order_creditmemo_attribute_backend_child'
00816 ),
00817 'comment' => array('type'=>'text'),
00818 'is_customer_notified' => array('type'=>'int'),
00819 ),
00820 ),
00821
00822 );
00823 }
00824 }
