<config>
  <sections>
    <earthfedex translate="label">
      <class>separator-top</class>
      <label>Earth Fedex</label>
      <tab>catalog</tab> <!-- the important one -->
      <sort_order>400</sort_order>
      <show_in_default>1</show_in_default>
      <show_in_website>1</show_in_website>
      <show_in_store>1</show_in_store>
      <groups>
                <settings translate="label">
                    <label>General Settings</label>
                    <frontend_type>text</frontend_type>
                    <sort_order>1</sort_order>
                    <show_in_default>1</show_in_default>
                    <show_in_website>1</show_in_website>
                    <show_in_store>1</show_in_store>
                    <fields>
                        <active translate="label">
                            <label>Enable Fedex Extension</label>
                            <frontend_type>select</frontend_type>
                            <config_path>fedex/fedex_acc/active</config_path>
                          <source_model>adminhtml/system_config_source_yesno</source_model>
                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </active>
                       </fields>
                    </settings>
                     <fedex_acc translate="label">
                    <label>Fedex Account Details</label>
                    <frontend_type>text</frontend_type>
                    <sort_order>2</sort_order>
                    <show_in_default>1</show_in_default>
                    <show_in_website>1</show_in_website>
                    <show_in_store>1</show_in_store>
                    <fields>
                        <key translate="label" >
                            <label>Key</label>
                            <frontend_type>text</frontend_type>
                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>

                    </key>

                      <pass translate="label">

                            <label>Password</label>
                        <frontend_type>password</frontend_type>


                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>

                   </pass>
                     <acc_no translate="label">

                            <label>Account No</label>
                            <frontend_type>text</frontend_type>
                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                          </acc_no>

                      </fields>
                    </fedex_acc>
                <setting translate="label">
                    <label>Shipper Details-(Shipper Address)</label>
                    <frontend_type>text</frontend_type>
                    <sort_order>3</sort_order>
                    <show_in_default>1</show_in_default>
                    <show_in_website>1</show_in_website>
                    <show_in_store>1</show_in_store>


                    <fields>

                        <p_name translate="label">
                            <label>Person Name</label>
                            <frontend_type>text</frontend_type>


                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </p_name>


                      <c_name translate="label">
                            <label>Company Name</label>
                            <frontend_type>text</frontend_type>


                            <sort_order>2</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </c_name>

                         <pno translate="label">
                            <label>Phone Number</label>
                            <frontend_type>text</frontend_type>


                            <sort_order>3</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </pno>

                            <tno translate="label">
                            <label>Tin Type Number</label>
                            <frontend_type>text</frontend_type>


                            <sort_order>4</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </tno>

                            <country translate="label">
                            <label>Country</label>
                            <frontend_type>select</frontend_type>
                             <source_model>adminhtml/system_config_source_country</source_model>

                            <sort_order>5</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </country>
                            <state translate="label">
                            <label>State</label>
                            <frontend_type>select</frontend_type>

                            <sort_order>6</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </state>
                            <city translate="label">
                            <label>City</label>
                            <frontend_type>select</frontend_type>
                            <sort_order>7</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </city>
                            <postal_code translate="label">
                            <label>Postal Code</label>
                            <frontend_type>text</frontend_type>


                            <sort_order>8</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </postal_code>
                       </fields>
                    </setting>
</groups>
    </earthfedex>
  </sections>
</config>

<?php
  $installer = $this;
  $installer->startSetup();

  $installer->run("
    DROP TABLE IF EXISTS {$this->getTable('earth_fedex_settings')};

    CREATE TABLE {$this->getTable('earth_fedex_settings')} (
    `store_id` int(11) NOT NULL AUTO_INCREMENT,
    `fedex_account_key` int(11) NOT NULL '',
    `fedex_status` varchar(30) '0',
    `enable_fedex_extension` TINYINT(1),
    `fedex_account_password` smallint(16),
    `fedex_account_number` int(11),
    `fedex_meter_number` bigint(20) NOT NULL,
    `shipper_person_name` char(50),
    `shipper_company_name` char(50),
    `shipper_phone_number` int (11),
    `shipper_tin_type` varchar(40),
    `shipper_tin_number` int(11),
    `shipper_address_streetline1` varchar(50) '0',
    `shipper_address_streetline2` varchar(50) '0',
    `shipper_address_city` char(30),
    `shipper_address_state_code` int(11),
    `shipper_address_postal_code` int(11),
    `shipper_address_country_code` int(11),
    `shipper_address_country_name` char(30),
    `fedex_volumetric_weight_field` int(11),
    `fedex_volumetric_weight_unit` varchar(30),
        PRIMARY KEY (store_id)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8
  ");

  $installer->endSetup();