Database 0.3 to 0.2

Pietia · Mar 25, 2009

fixxxxeeddd

Pietia · Mar 26, 2009

Colandus said:
hmmm what about....

UPDATE accounts AS a SET a.account_id = a.account_name

same error.
btw
account_id=id
and accountname=name

Cykotitan · Mar 26, 2009

About the account names; am I close enough? :S

PHP:

ALTER TABLE `accounts`
RENAME `name` to `id`
MODIFY `id` INT NOT NULL AUTO_INCREMENT

Pietia · Mar 27, 2009

Cykotitan said:
About the account names; am I close enough? :S

PHP:

ALTER TABLE `accounts` RENAME `name` to `id` MODIFY `id` INT NOT NULL AUTO_INCREMENT

thanks all i have doned it.

Database 0.3 to 0.2

Pietia

Active Member

Pietia

Active Member

Cykotitan

Experienced G'

Pietia

Active Member