|
DATABASE CREATION (MySQL)
PBM Client supports two database systems. The first is a database file system
which is labeled "DBFILE". The DBFILE system does not require any external
database systems and is very user friendly. The second database system supported
by PBM Client is MySQL. Using MySQL requires that MySQL be installed on the computer
that PBM Client resides on or that the PBM Client computer has access to a network
computer with MySQL.
Database creation is accomplished by using the Database Creation Wizard. The
database wizard is only available until a database and connection have been
established. The wizard is launched by selecting the Database Builder menu item.
as seen in the following picture.
If the database builder menu item is not available, then a database has already
been created in which case there will be a menu item titled "Open Database", or
the environment has not yet been set. See "Setting The Environment" for further
instructions.
Selecting the Database Builder menu item will launch the database creation wizard
as pictured below.
After selecting "Powerball" from the available lotteries and selecting MySQL
as the database system, the user must enter the following details which are
specific to MySQL. The user must define the "Host Name" which is the network
location where the MySQL server resides, a user defined database name, and a
user name and password for a MySQL user account that has been granted the privilege
of creating databases.
If there are any associated files used to create the database such as
running scripts that configure tables etc. etc. they will be listed in the "Related
Files" window. The user can also view the database tables and the associated table
fields by selecting a table from the "Table" drop down menu.
The final step in the database creation process is to click on the "Create"
button. The database creation wizard will create the database file, store the
database connection details, and automatically close. PBM Client is now ready
to open a database connection and update the database tables.
|
|
