Posts: 100
Threads: 35
Joined: Jan 2012
Quote:
Originally Posted by Lirbo
I didn't really get what are those ER diagrams are doing.
another question; I'll have to do something like this in my pawn or?
PHP код:
CREATE TABLE Player_Database(id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER);
INSERT INTO Player_Database VALUES (1, "Money", 10000);
if no, where i'll supposed to do that?
|
You don't need to insert an ID as you would make it AUTO Increment. If you are trying to store player data the table should be called 'Accounts' with rows consisting of say.. Username,Password,Money,X,Y,Z,Weapon1 and so forth.
ER Diagrams are basic pre-models you can create to make sure you have everything correct, If you look at the link theres a more indepth explanation.