Creating a database

[speccy]

Hi, i m not so new in SQL but I cannot see which Name to set for the database MySQL...and how to start
I ve read all documentation but cannot find HOW TO START from the beginning in creating database and setting tables for my game...

My FTP is OK with files required in it and The project is created in Control Panel/Manage Game.....

The questions :
After connectiong to MySQL using my login+password ,
I got a database called "Information_Schema"

1) how to create my own Game database ?

2) Which name to use?

3) It seems that I have't the rights to CREATE database (Aucun privilege)

Thanx for my early beggining...

Jean Marc

[Kennyyy]

Hi,

you can create a table (or more precisely: request for the creation of a new (or several new) table(s) at the creation of a game table). To do that just go in your project folder and edit the dbmodel.sql file. In it you will see that you can describe the table(s) you need to be created at the beginning of a new game table. The table(s) you have described in this file will thus be created at the game initialization and you will be able to access it during the game in all your php files. I don't know if you can create a table directly through the MySQL interface and not sure that's really useful since every table you need you will need it for each game table(s).

[sourisdudesert]

Hi,

Kenny is absolutely right.

You can find all documentation here:
http://en.doc.boardgamearena.com/Game_d ... bmodel.sql

To conclude: you don't need to create a database: a database will be created for your game each time you start a new game. Then, you can click on the "access game database" link below the game area to access your game database.

Cheers,

[speccy]

Thank you! I understand betteR... But there was a lot of pb when I ve launched a game for the first time....

Messages concerning the database with no access I think....

i try again and will be reporting the pb here..... See you!