per42

-- Create tables --
DROP TABLE IF EXISTS wp_posts;
CREATE TABLE wp_posts (
    ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    post_type VARCHAR(255) NOT NULL DEFAULT 'hso_product',
    post_status VARCHAR(255) NOT NULL DEFAULT 'publish',
    menu_order INT NOT NULL DEFAULT 0
);