how do you set negative integers?

[Kran]

I heard you have to make the integers signed, but I don't know how, in specific I'm trying to make the post count negative. Anyone know how?

[Marco van Herwaarden]

You could try (untested, backup your database first!!!):
[sql]ALTER TABLE user CHANGE COLUMN post posts int(10) NOT NULL default 0;[/sql]

[Kran]

Alright, trying

EDIT: I got this

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'post' in 'user'

[Marco van Herwaarden]

Oops the first one should have been posts also:
[sql]ALTER TABLE user CHANGE COLUMN posts posts int(10) NOT NULL default 0;[/sql]

[Kran]

trying

EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead.

[Paul M]

I've got to ask - why do you want negative post counts ?

[Kran]

Originally Posted by Paul M

I've got to ask - why do you want negative post counts ?

Spammers, they don't deserve to be banned, but I don't think 0 is enough of a set back.

[Kran]

bump

[Hellcat]

Originally Posted by Kran

trying

EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead.

What happens if you set it to.... say "-9"?
Do you still get "0"?

Can you determine of what kind your posts column in the DB is?

I tried this myself a week ago and worked perfectely....

Man, without your bump I would have totally missed this

[Kran]

Originally Posted by Hellcat

What happens if you set it to.... say "-9"?
Do you still get "0"?

Can you determine of what kind your posts column in the DB is?

I tried this myself a week ago and worked perfectely....

Man, without your bump I would have totally missed this

same thing if -9...

I can't find the posts column, what's it under?