Skip to content

Instantly share code, notes, and snippets.

@enminc

enminc/gbfoxycart.mysql.schema.xml

Created June 28, 2017 21:23
Show Gist options
  • Save enminc/615e618df8bfeb2ff944a4358b67f880 to your computer and use it in GitHub Desktop.
Save enminc/615e618df8bfeb2ff944a4358b67f880 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gbfoxycart.mysql.schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<model package="gbfoxycart" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
<object class="FCartTransactionCustomer" table="gbfoxycart_transaction_customer" extends="xPDOSimpleObject">
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" index="index" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="false" default="CURRENT_TIMESTAMP" index="index" extra="on update current_timestamp" />
<field key="customer_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="is_anonymous" dbtype="tinyint" precision="1" phptype="integer" null="false" />
<field key="customer_first_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_last_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_company" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_address1" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_address2" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_city" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_state" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_postal_code" dbtype="varchar" precision="10" phptype="string" null="false" />
<field key="customer_country" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_phone" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_email" dbtype="varchar" precision="125" phptype="string" null="false" />
<field key="customer_ip" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="customer_password" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_password_salt" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_password_hash_type" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="customer_password_hash_config" dbtype="varchar" precision="25" phptype="string" null="false" />
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="false" />
</index>
<index alias="transid" name="transid" primary="false" unique="false" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<aggregate alias="FCartTrans" class="FCartTransactions" local="transaction_id" foreign="transaction_id" cardinality="one" owner="foreign" />
</object>
<object class="FCartTransactionDetails" table="gbfoxycart_transaction_details" extends="xPDOSimpleObject">
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" index="index" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="true" index="index" />
<field key="product_name" dbtype="varchar" precision="125" phptype="string" null="false" />
<field key="product_price" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="product_quantity" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="product_weight" dbtype="decimal" precision="10,3" phptype="float" null="false" />
<field key="product_code" dbtype="varchar" precision="12" phptype="string" null="false" />
<field key="image" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="url" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="length" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="width" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="height" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="downloadable_url" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="sub_token_url" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="subscription_frequency" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="subscription_startdate" dbtype="timestamp" phptype="timestamp" null="true" default="CURRENT_TIMESTAMP" />
<field key="subscription_nextdate" dbtype="timestamp" phptype="timestamp" null="true" default="0000-00-00 00:00:00" />
<field key="subscription_enddate" dbtype="timestamp" phptype="timestamp" null="true" default="0000-00-00 00:00:00" />
<field key="is_future_line_item" dbtype="tinyint" precision="4" phptype="integer" null="false" />
<field key="shipto" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="category_description" dbtype="text" phptype="string" null="false" />
<field key="category_code" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="product_delivery_type" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="transaction_detail_options" dbtype="text" phptype="string" null="false" />
<index alias="transid" name="transid" primary="false" unique="false" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="true" />
</index>
<aggregate alias="FCartTrans" class="FCartTransactions" local="transaction_id" foreign="transaction_id" cardinality="one" owner="foreign" />
</object>
<object class="FCartTransactionDiscounts" table="gbfoxycart_transaction_discounts" extends="xPDOSimpleObject">
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" index="index" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="true" index="index" />
<field key="code" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="valid_categories" dbtype="text" phptype="string" null="false" />
<field key="name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="amount" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="display" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="coupon_discount_type" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="coupon_discount_details" dbtype="varchar" precision="25" phptype="string" null="false" />
<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE" >
<column key="id" length="" collation="A" null="false" />
</index>
<index alias="transid" name="transid" primary="false" unique="false" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="true" />
</index>
<aggregate alias="FCartTrans" class="FCartTransactions" local="transaction_id" foreign="transaction_id" cardinality="one" owner="foreign" />
</object>
<object class="FCartTransactionShipto" table="gbfoxycart_transaction_shipto" extends="xPDOSimpleObject">
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" index="index" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="true" index="index" />
<field key="address_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="address_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_first_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_last_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_company" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_address1" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_address2" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="shipto_city" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="shipto_state" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="shipto_postal_code" dbtype="varchar" precision="10" phptype="string" null="false" />
<field key="shipto_country" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="shipping_phone" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="date_created" dbtype="timestamp" phptype="timestamp" null="true" />
<field key="date_modified" dbtype="timestamp" phptype="timestamp" null="true" />
<field key="shipto_shipping_service_description" dbtype="text" phptype="string" null="false" />
<field key="shipto_subtotal" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="shipto_tax_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="shipto_shipping_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="shipto_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="shipto_custom_fields" dbtype="text" phptype="string" null="false" />
<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE" >
<column key="id" length="" collation="A" null="false" />
</index>
<index alias="transid" name="transid" primary="false" unique="false" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="true" />
</index>
<aggregate alias="FCartTrans" class="FCartTransactions" local="transaction_id" foreign="transaction_id" cardinality="one" owner="foreign" />
</object>
<object class="FCartTransactionTaxes" table="gbfoxycart_transaction_taxes" extends="xPDOSimpleObject">
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" index="index" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="true" index="index" />
<field key="tax_rate" dbtype="decimal" precision="4,4" phptype="float" null="false" />
<field key="tax_name" dbtype="varchar" precision="50" phptype="string" null="false" />
<field key="tax_amount" dbtype="decimal" precision="4,4" phptype="float" null="false" />
<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true" type="BTREE" >
<column key="id" length="" collation="A" null="false" />
</index>
<index alias="transid" name="transid" primary="false" unique="false" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="true" />
</index>
<aggregate alias="FCartTrans" class="FCartTransactions" local="transaction_id" foreign="transaction_id" cardinality="one" owner="foreign" />
</object>
<object class="FCartTransactions" table="gbfoxycart_transactions" extends="xPDOSimpleObject">
<field key="feed_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="transaction_date" dbtype="timestamp" phptype="timestamp" null="false" default="CURRENT_TIMESTAMP" index="index" extra="on update current_timestamp" />
<field key="store_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="store_version" dbtype="varchar" precision="10" phptype="string" null="false" />
<field key="is_test" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
<field key="is_hidden" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
<field key="data_is_fed" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
<field key="payment_type" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="payment_gateway_type" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="processor_response" dbtype="varchar" precision="125" phptype="string" null="false" />
<field key="processor_response_details" dbtype="text" phptype="string" null="false" />
<field key="purchase_order" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="cc_number_masked" dbtype="varchar" precision="16" phptype="string" null="false" />
<field key="cc_type" dbtype="varchar" precision="12" phptype="string" null="false" />
<field key="cc_exp_month" dbtype="tinyint" precision="2" phptype="integer" null="false" />
<field key="cc_exp_year" dbtype="smallint" precision="4" phptype="integer" null="false" />
<field key="cc_start_date_month" dbtype="tinyint" precision="2" phptype="integer" null="false" />
<field key="cc_start_date_year" dbtype="smallint" precision="4" phptype="integer" null="false" />
<field key="cc_issue_number" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="minfraud_score" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="paypal_payer_id" dbtype="varchar" precision="25" phptype="string" null="false" />
<field key="product_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="tax_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="shipping_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="order_total" dbtype="decimal" precision="10,2" phptype="float" null="false" />
<field key="receipt_url" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="has_taxes" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
<field key="has_discounts" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
<field key="custom_fields" dbtype="varchar" precision="255" phptype="string" null="false" />
<field key="attributes" dbtype="text" phptype="string" null="false" />
<index alias="transdate" name="transdate" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="false" />
</index>
<index alias="transId" name="transdate" primary="false" unique="true" type="BTREE" >
<column key="transaction_id" length="" collation="A" null="false" />
</index>
<composite alias="FCartTransCustomer" class="FCartTransactionCustomer" local="transaction_id" foreign="transaction_id" cardinality="one" owner="local" />
<composite alias="FCartTransDetails" class="FCartTransactionDetails" local="transaction_id" foreign="transaction_id" cardinality="many" owner="local" />
<composite alias="FCartTransDiscounts" class="FCartTransactionDiscounts" local="transaction_id" foreign="transaction_id" cardinality="many" owner="local" />
<composite alias="FCartTransShipto" class="FCartTransactionShipto" local="transaction_id" foreign="transaction_id" cardinality="many" owner="local" />
<composite alias="FCartTransTaxes" class="FCartTransactionTaxes" local="transaction_id" foreign="transaction_id" cardinality="many" owner="local" />
</object>
<object class="FCartXmlDatafeed" table="gbfoxycart_xml_datafeed" extends="xPDOSimpleObject">
<field key="foxyXMLData" dbtype="text" phptype="string" null="false" />
<field key="foxyJsonData" dbtype="text" phptype="string" null="false" />
<field key="foxyDataHash" dbtype="char" precision="32" phptype="string" null="false" index="unique" />
<field key="transaction_id" dbtype="int" precision="11" phptype="integer" null="false" />
<field key="transaction_date" dbtype="datetime" phptype="datetime" null="true" index="index" />
<field key="procFoxyCart" dbtype="datetime" phptype="datetime" null="true" index="index" />
<field key="procBlackbaud" dbtype="datetime" phptype="datetime" null="true" index="index" />
<index alias="foxyDataHash" name="foxyDataHash" primary="false" unique="true" type="BTREE" >
<column key="foxyDataHash" length="" collation="A" null="false" />
</index>
<index alias="transaction_date" name="transaction_date" primary="false" unique="false" type="BTREE" >
<column key="transaction_date" length="" collation="A" null="false" />
</index>
<index alias="procFoxyCart" name="procFoxyCart" primary="false" unique="false" type="BTREE" >
<column key="procFoxyCart" length="" collation="A" null="true" />
</index>
<index alias="procBlackbaud" name="procBlackbaud" primary="false" unique="false" type="BTREE" >
<column key="procBlackbaud" length="" collation="A" null="true" />
</index>
</object>
</model>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment