install.mysql.utf8.sql

DROP TABLE IF EXISTS `#__mycomp_posts`;
 
CREATE TABLE `#__mycomp_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `body` TEXT NOT NULL DEFAULT '',
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

manifest.xml

<extension
	type="component"
	version="2.5.0"
	client="site"
	method="upgrade">
	<name>com_mycomp</name>
	<author>branchito</author>
	<creationDate>Thu 05 Sep 2013 08:27:43 PM CEST</creationDate>
	<copyright>All rights reserved by whoooom!?.</copyright>
	<license>GPL 2.0</license>
	<authorEmail>[email protected]</authorEmail>
	<authorUrl>sonikete</authorUrl>
	<version>1.0.0</version>
	<description>COM_MYCOMP_DESC</description>


	<media destination="com_mycomp" folder="media">
		<folder>images</folder>
		<folder>css</folder>
		<folder>js</folder>
		<filename>index.html</filename>
	</media>

	<files folder="components/com_mycomp">
		<filename>mycomp.php</filename>
		<filename>index.html</filename>
		<filename>controller.php</filename>
	</files>

	<languages folder="language/en-GB">
		<language tag="en-GB">en-GB.com_mycomp.ini</language>
	</languages>
	<install>
		<sql>
			<file charset="utf8" driver="mysql">install.mysql.utf8.sql</file>
		</sql>
	</install>
	<update>
		<sql>
			<file charset="utf8" driver="mysql">update.sql</file>
		</sql>
	</update>
	<uninstall>
		<sql>
			<file charset="utf8" driver="mysql">uninstall.mysql.utf8.sql</file>
		</sql>
	</uninstall>

	<administration>
	<files folder="administrator/components/com_mycomp">
		<filename>mycomp.php</filename>
		<filename>index.html</filename>
		<filename>controller.php</filename>
		<filename>install.mysql.utf8.sql</filename>
		<filename>update.sql</filename>
		<filename>uninstall.mysql.utf8.sql</filename>
	</files>

	<languages folder="administrator/language/en-GB">
		<language tag="en-GB">en-GB.com_mycomp.ini</language>
		<language tag="en-GB">en-GB.com_mycomp.sys.ini</language>
	</languages>

	<menu link="option=com_mycomp" img="../media/com_mycomp/images/com_mycomp-icon16x16.png">COM_MYCOMP_MENU</menu>
	<submenu>
		<menu link="option=com_mycomp&amp;task=create" img="../media/com_mycomp/images/com_mycomp-create-icon16x16.png">COM_MYCOMP_MENU_CREATE</menu>
		<menu link="option=com_mycomp&amp;task=listtask" img="../media/com_mycomp/images/com_mycomp-list-icon16x16.png">COM_MYCOMP_MENU_LISTTASK</menu>
		<menu link="option=com_mycomp&amp;task=help" img="../media/com_mycomp/images/com_mycomp-help-icon16x16.png">COM_MYCOMP_MENU_HELP</menu>
	</submenu>

	</administration>

</extension>