Django database - how to add this column in raw SQL.

Question

Suppose I have my models set up already.

class books(models.Model):
    title = models.CharField...
    ISBN = models.Integer...

What if I want to add this column to my table?

user = models.ForeignKey(User, unique=True)

How would I write the raw SQL in my database so that this column works?

Answer 1

You should investigate a tool like South, which does all this for you.

However the SQL would be something like (assuming you're using MySQL):

ALTER TABLE `appname_books` ADD COLUMN `user_id` INTEGER NOT NULL UNIQUE;
ALTER TABLE `appname_books` ADD CONSTRAINT `user_id_refs_user` FOREIGN KEY (`user_id`) REFERENCES auth_user (`id`);