query " ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false" = error

You need to remove the =:

ALTER TABLE test_posts ADD sticky boolean NOT NULL default false