Create a Database
In this step we will create a database which will store room and user information. If you want to use your own database, just note that the table names will not be the same as in the tutorial. The following instructions, also, only apply to phpMyAdmin. However, the steps should be similar to other database managers.
Create New Database
OpenSelect the tab. If the tab does not appear, click the button on the left. Create a new database called The default will work for the character set.
After creating a new database, select it in the left pane.
Set Up Tables
In this sample, we will use three database tables:, , and You can manually create the tables or use the SQL scripts provided. To insert SQL scripts, click the tab to open the input window. The tables are described below:
is used to store user information, such as phone numbers and email addresses. Copy the following code into the window and select to create the following table:
is used to store room information, such as room number and room size.
is used to store room reservation information, such as meeting rooms and times.
Add Initial Data
Once the tables are created, you can populate them with some initial data. Replace thedata with your own information. Then, run the following SQL statement: