Need a Developer?
Taking work, any size or scope, and your imagination is the only limit. Contact me for a free consultation at [email protected].
ERROR: TESTING The special HTML tag 'theme section="whats_new.tpl"' is not supported.
Subscribe to the low traffic mailing list to stay updated on Apex.
Apex Training - Create Database Tables
Many of you will probably groan, but at Apex we strongly believe that SQL database schemas should be written in, well... SQL. If you do not know SQL, it is an extremely easy language to learn the basics, and can dramatically improve the architecture, performance, and stability of your software. You will notice there is a blank file at /etc/training/install.sql, and this file is executed against the database upon installation of the package.
Open the /etc/training/install.sql file, and enter the following contents:
Now simply connect to mySQL via terminal, and copy and paste the above SQL into the mySQL prompt to create the necessary tables.
Now that we have a small database structure, let's move on to Creating a Library.