过程中注意事项:

当安装一个表的时候,就会在core_resource中加入一条数据,来记录改数据表的版本情况。

在安装过程中,如果mysql4-install-0.1.0.php有错误,该表不能建立,但是在core_resource表中还是加入了该<setup>的信息,故下次调试的时候记住,到表core_resource中删除对用的那条数据,否则,安装不上~!!!!

2.1

app/ect/modules/

2.2

app/code/community/AQ/Gao/etc/config.xml

app/code/community/AQ/Gao/sql/gao_setup/mysql4-install-0.1.0.php

 

只需要建这两个文件就可以完成,当然是最简单的方式了。

 

2.3

编辑config.xml文件

2.3.1

<modules>

<frontend>

<global>

<models/>

<resources>

<gao_setup>

<setup>

<module />

</setup>

<connection>

<use>core_setup</use>

</connection>

</gao_setup>

</resources>

</global>

 

 

 

 

 

 

2.4

编辑

mysql4-install-0.1.0.php

一定别把`当成',擦!!,,,,`````````,此符号是在英文状态下esc下面的那个键打出来的符号,擦!

 

 

 

 

附文件:

 

app/code/community/AQ/Gao/etc/config.xml

----->

 

<?xml version="1.0"?>

<config>

<modules>

<AQ_Gao>

<version>0.1.0</version>

 

</AQ_Gao>

</modules>

 

<frontend>

<routers>

<gao>

<use>standard</use>

<args>

<module>AQ_Gao</module>

<frontName>gao</frontName>

</args>

</gao>

</routers>

</frontend>

 

 

<global>

<models>

<gao>

<class>AQ_Gao_Model</class>

<resourceModel>gao_mysql4</resourceModel>

</gao>

<gao_mysql4>

<class>AQ_Gao_Model_Mysql4</class>

<entities>

<gao>

<table>aagao</table>

</gao>

</entities>

</gao_mysql4>

</models>

<resources>

<gao_setup>

<setup>

<module>AQ_Gao</module>

</setup>

<connection>

<use>core_setup</use>

</connection>

</gao_setup>

<gao_write>

<connection>

<use>core_write</use>

</connection>

</gao_write>

<gao_read>

<connection>

<use>core_read</use>

</connection>

</gao_read>

 

 

<weblog_setup>

              <setup>

                    <module>AQ_Gao</module>

           

        </setup>

        <connection>

            <use>core_setup</use>

            </connection>

   </weblog_setup>

</resources>

</global>

</config>

 

app/code/community/AQ/Gao/sql/gao_setup/mysql4-install-0.1.0.php

----->

 

<?php

 

$installer = $this;

 

$installer->startSetup();

try{

$installer->run("

 

DROP TABLE IF EXISTS {$this->getTable('gao/gao')};

CREATE TABLE {$this->getTable('gao/gao')} (

`post_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,

`cat_id` smallint( 11 ) NOT NULL default '0',

`title` varchar( 255 ) NOT NULL default '',

`post_content` text NOT NULL ,

`status` smallint( 6 ) NOT NULL default '0',

`created_time` datetime default NULL ,

`update_time` datetime default NULL ,

`identifier` varchar( 255 ) NOT NULL default '',

`user` varchar( 255 ) NOT NULL default '',

`update_user` varchar( 255 ) NOT NULL default '',

`meta_keywords` text NOT NULL ,

`meta_description` text NOT NULL ,

`comments` TINYINT( 11 ) NOT NULL,

PRIMARY KEY ( `post_id` ) ,

UNIQUE KEY `identifier` ( `identifier` )

) ENGINE = InnoDB DEFAULT CHARSET = utf8;

 

INSERT INTO {$this->getTable('gao/gao')} (`post_id` ,`cat_id`, `title` ,`post_content` ,`status` ,`created_time` ,`update_time` ,`identifier` ,`user` ,`update_user` ,`meta_keywords` ,`meta_description`)

VALUES (NULL ,'0', 'Hello World', 'Welcome to Magento Blog by aheadWorks Co. This is your first post. Edit or delete it, then start blogging!', '1', NOW( ) , NOW( ) , 'Hello', 'Joe Blogs', 'Joe Blogs', 'Keywords', 'Description');

 

");

}catch(Exception $e){}

 

$installer->endSetup(); 

------------------------->KO!!!