magento----使用magento机制安装数据表

过程中注意事项：

当安装一个表的时候，就会在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!!!