View source for Developing an MVC Component/Setting up the Database

== Required Changes == <!--T:6-->

<!--T:7-->
We'll need to make files to install and uninstall the component, and one upgrade file. As our component is already installed, an upgrade file is needed to make the necessary changes.</translate>

{|border=1
 | 1
 | Create: [[#admin/sql/install.mysql.utf8.sql|admin/sql/install.mysql.utf8.sql]]
 | An SQL file that is run when the component is installed on a MySQL database
 |-
 | 2
 | Create: [[#admin/sql/uninstall.mysql.utf8.sql|admin/sql/uninstall.mysql.utf8.sql]]
 | An SQL file that is run when the component is uninstalled on a MySQL database
 |-
 | 3
 | Create: [[#admin/sql/updates/mysql/0.0.7.sql|admin/sql/updates/mysql/0.0.7.sql]]
 | An SQL file that is run when the component is updated to/beyond version 0.0.7 on a MySQL database
 |-
 | 4
 | Update: [[#helloworld.xml|helloworld.xml]]
 | We'll need to add the new <tt>sql</tt> directory to our file copy list, and add instructions for Joomla! on where to find our scripts
 |}

<translate>