[Zzed]

Today at 06:40 AM TonTon said this in Post #172
SQL-query :

ALTER TABLE user ADD miserable smallint( 5 ) unsignedDEFAULT0 NOT NULL

MySQL said:


You have an error in your SQL syntax near 'DEFAULT0 NOT NULL ' at line 1

Change this: ALTER TABLE user ADD miserable smallint( 5 ) unsignedDEFAULT0 NOT NULL

To this: ALTER TABLE user ADD miserable smallint( 5 ) unsigned DEFAULT 0 NOT NULL

I added a space before and after DEFAULT.