DROP TABLE wiki_received_pages;
DROP TABLE wiki_tags;
DROP TABLE wiki_ext;

ALTER TABLE liberty_content_history ALTER COLUMN user_id TYPE INTEGER;
ALTER TABLE wiki_footnotes ALTER COLUMN user_id TYPE INTEGER;
--pgsql use:
ALTER TABLE liberty_content_history ALTER COLUMN user_id TYPE INTEGER USING user_id::int;
ALTER TABLE wiki_footnotes ALTER COLUMN user_id TYPE INTEGER USING user_id::int;
--mysql use:
ALTER TABLE `liberty_content_history` CHANGE `user_id` `user_id` INTEGER;
ALTER TABLE `wiki_footnotes` CHANGE `user_id` `user_id` INTEGER;

ALTER TABLE gmaps_maptypes ALTER COLUMN description TYPE TEXT;
--mysql use:
ALTER TABLE gmaps_maptypes CHANGE description description TEXT;

ALTER TABLE gmaps_icon_styles ADD COLUMN theme_id INT4 NOT NULL;
 
-- NOTE: You must run the installer step 4 "Resolve Conflicts" to also add a new gmaps_icon_themes table before trying to add this constraint.
ALTER TABLE gmaps_icon_styles ADD CONSTRAINT gmaps_icon_theme_ref FOREIGN KEY (theme_id) REFERENCES gmaps_icon_themes(theme_id);

-- remove unused meta tables
DROP TABLE liberty_meta_content_map;
DROP TABLE liberty_meta_data;
DROP TABLE liberty_meta_types;
 
-- add new meta tables
-- Expand TEXT as appropriate ( FB -> BLOB SUB_TYPE TEXT )
CREATE TABLE liberty_attachment_meta_data (
	attachment_id INT NOT NULL,
	meta_type_id INT NOT NULL,
	meta_title_id INT NOT NULL,
	meta_value TEXT
);
CREATE TABLE liberty_meta_types (
	meta_type_id INT PRIMARY KEY,
	meta_type VARCHAR(250) NOT NULL
);
CREATE TABLE liberty_meta_titles (
	meta_title_id INT PRIMARY KEY,
	meta_title VARCHAR(250) NOT NULL
);
ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_id_ref FOREIGN KEY (attachment_id) REFERENCES liberty_attachments(attachment_id);
ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_type_ref FOREIGN KEY (meta_type_id) REFERENCES liberty_meta_types(meta_type_id);
ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_title_ref FOREIGN KEY (meta_title_id) REFERENCES liberty_meta_titles(meta_title_id);
CREATE UNIQUE INDEX lib_attachment_meta_idx ON liberty_attachment_meta_data(attachment_id,meta_type_id,meta_title_id);

CREATE TABLE liberty_attachment_prefs (
    attachment_id INT,
    pref_name VARCHAR(40),
    pref_value VARCHAR(250)
);
CREATE UNIQUE INDEX liberty_att_prefs_att_name_idx ON liberty_attachment_prefs(attachment_id,pref_name);
CREATE INDEX liberty_att_prefs_att_idx ON liberty_attachment_prefs(attachment_id);
ALTER TABLE liberty_attachment_prefs ADD CONSTRAINT lib_att_prefs_content_ref FOREIGN KEY (attachment_id) REFERENCES liberty_attachments(attachment_id);