9999-the-final-countdown.sql

DROP TABLE IF EXISTS auth_user_groups;
DROP TABLE IF EXISTS auth_user_user_permissions;
DROP TABLE IF EXISTS django_admin_log;
DROP TABLE IF EXISTS auth_user;
DROP TABLE IF EXISTS addons_categories;
DROP TABLE IF EXISTS categories;


ALTER TABLE files DROP COLUMN is_packaged;
ALTER TABLE addon_payment_account DROP COLUMN set_price;
ALTER TABLE addon_payment_account MODIFY payment_account_id int(11) unsigned NOT NULL AFTER addon_id;

ALTER TABLE abuse_reports MODIFY read tinyint(1) NOT NULL DEFAULT '0' AFTER website_id;
ALTER TABLE abuse_reports MODIFY message longtext NOT NULL AFTER website_id;

ALTER TABLE addon_payment_data MODIFY city varchar(128) NOT NULL AFTER post_code;

ALTER TABLE comm_threads MODIFY addon_id int(11) unsigned NOT NULL AFTER read_permission_staff;
ALTER TABLE comm_threads MODIFY version_id int(11) unsigned DEFAULT NULL AFTER addon_id;

ALTER TABLE editor_subscriptions MODIFY id int(11) NOT NULL AUTO_INCREMENT BEFORE user_id;
ALTER TABLE editor_subscriptions MODIFY user_id int(11) unsigned NOT NULL AFTER modified;
ALTER TABLE editor_subscriptions MODIFY addon_id int(11) unsigned NOT NULL AFTER user_id;

-- email_preview.from_email should this be varchar(255) in django generated schema?

ALTER TABLE file_uploads MODIFY hash varchar(255) DEFAULT NULL BEFORE user_id;
ALTER TABLE file_uploads MODIFY valid tinyint(1) NOT NULL DEFAULT '0' AFTER user_id;