CREATE TABLE news_categories (
	id TINYINT NOT NULL,
	code VARCHAR(16) NOT NULL UNIQUE,
	name VARCHAR(255) NOT NULL
) ENGINE=InnoDB;

CREATE TABLE news_types (
	id TINYINT NOT NULL,
	code VARCHAR(16) NOT NULL UNIQUE,
	name VARCHAR(255) NOT NULL
) ENGINE=InnoDB;

INSERT INTO news_categories (id, code, name) VALUES
	(1, 'corporate', 'Corporate'),
	(2, 'local', 'Local');

INSERT INTO news_types (id, code, name) VALUES
	(1, 'news_only', 'News Only'),
	(2, 'document_only', 'Docuemnt Only'),
	(3, 'both', 'Both');

ALTER TABLE news ADD COLUMN news_category_id TINYINT NOT NULL;
ALTER TABLE news ADD COLUMN news_type_id TINYINT DEFAULT NULL;
