25.11.2012, 07:51
Quote:
ALTER TABLE `<table name>` ADD COLUMN `<column name>` <type INTEGER/TEXT> <optional DEFAULT(value)>
example: ALTER TABLE `users` ADD COLUMN `kills` INTEGER DEFAULT(0) I recommend using slice's BUD for sqlite, it makes it a lot easier to use without having to worry about so much things. In BUD you could just do BUD::VerifyColumn("kills", BUD::TYPE_NUMBER ); |