Made pilab database script

very rough bit of code.
put the script in C: and called using C:/pilab.sql through the mysql
terminal in windows.

the code currently returns the following errors:
ERROR 1064 (42000): syntax error
ERROR 1007 (HY000): Can't create database 'pilab'; database exists
ERROR 1050 (42S01): table 'users' already exists
ERROR 1064 (42000): syntax error
ERROR 1075 (42000); incorrect table defintion