First we’re going to add excerpt, post, and password functionality...
WordPress database error: [Duplicate column name 'post_excerpt']
ALTER TABLE mampress_posts ADD COLUMN post_excerpt text NOT NULL;
WordPress database error: [Duplicate column name 'post_status']
ALTER TABLE mampress_posts ADD post_status ENUM('publish','draft','private') NOT NULL,
ADD comment_status ENUM('open','closed') NOT NULL,
ADD ping_status ENUM('open','closed') NOT NULL,
ADD post_password varchar(20) NOT NULL;
That went well! Now let's clean up the b2 database structure a bit...
WordPress database error: [Can't DROP INDEX `ID`; check that it exists]
ALTER TABLE mampress_posts DROP INDEX ID
One down, two to go...
So far so good.
WordPress database error: [Can't DROP COLUMN `post_karma`; check that it exists]
ALTER TABLE mampress_posts DROP post_karma
Almost there...
WordPress database error: [Can't DROP INDEX `ID`; check that it exists]
ALTER TABLE mampress_users DROP INDEX ID
Welcome to the family. Have fun!