[SOLVED] table not created during component installation - Joomla! Forum - community, help and support

hi,

in xml component file have:

code: select all

<install>   <!-- runs on install -->
  <sql>
    <file driver="mysql" charset="utf8">sql/install.mysql.utf8.sql</file>
  </sql>
</install>


in admin part of same xml file, have:

code: select all

<files folder="admin">
  <folder>sql</folder>
</file>


however, when install component using extension > install > package file, no table created if have in "install.mysql.utf8.sql" file following statement:

code: select all

create table if not exists `#__rgtcis_order_sources` (
   `id` int(10) unsigned not null auto_increment comment 'automatic incrementing key field',
   `order_source` varchar(200) not null default '' comment 'source name of order',
   primary key(`id`)
) engine=myisam default charset=utf8 auto_increment=1;

so mistake ?
thx


what did resolve this? i've been fighting 2 days. thanks.