[Scofield11]

Quote:

Originally Posted by Storm94 It probably isn't a Windows vs Linux thing, rather it is the configuration of the specific MySQL server.

Quote:

Originally Posted by Vince On your Windows machine, can you execute: PHP код: SHOW CREATE TABLE players;  If the output of that query does show default values then your table setup is different. Also that SQL script is horribly unoptimized. A single table shouldn't contain more than 30 fields or so, much less 300. That whole "accessory" section especially can and should be moved to a different table that has 13 columns rather than 84. Each new accessory constitutes a new row, not a new set of columns. Same thing with guns, licenses, times, inventory item, bans and whatever.

Quote:

Originally Posted by Storm94 It probably isn't a Windows vs Linux thing, rather it is the configuration of the specific MySQL server.

Alright thanks men, but can you show me how can I properly set a default value or do it for me please? bacause and I tried adding NOT NULL DEFAULT ‘0’ but it gives me error.

Also, shall I set it for every field or what?