ALTER TABLE group_join_request ADD CONSTRAINT group_join_request_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id);
ALTER TABLE groups ADD CONSTRAINT groups_license FOREIGN KEY (license) REFERENCES licenses(license_id) MATCH FULL;
ALTER TABLE groups ALTER COLUMN unix_box SET DEFAULT 'shell'::character varying;
+ALTER TABLE users ALTER COLUMN unix_box SET DEFAULT 'shell'::character varying;
DROP INDEX plugins_plugin_name_key;
ALTER TABLE plugins ADD CONSTRAINT plugins_plugin_name_key UNIQUE (plugin_name);
ALTER TABLE user_preferences DROP COLUMN dead1;
ALTER TABLE user_group ALTER COLUMN artifact_flags SET DEFAULT 0;
+
+DROP TABLE IF EXISTS project_metric_tmp1;
+
+ALTER TABLE user_preferences ADD COLUMN set_date_new integer DEFAULT 0 NOT NULL;
+UPDATE user_preferences SET set_date_new = set_date;
+ALTER TABLE user_preferences DROP COLUMN set_date;
+ALTER TABLE user_preferences ALTER COLUMN set_date_new RENAME TO set_date;
ALTER TABLE project_task ALTER COLUMN hours SET DEFAULT 0::double precision;
ALTER TABLE survey_rating_aggregate ALTER COLUMN response SET DEFAULT 0::double precision;
+
+ALTER TABLE user_metric ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
+ALTER TABLE user_metric ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN metric SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN percentile SET DEFAULT 0::double precision;
-ALTER TABLE user_metric ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
+ALTER TABLE user_metric0 ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN metric SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN percentile SET DEFAULT 0::double precision;
-ALTER TABLE user_metric0 ALTER COLUMN importance_factor SET DEFAULT 0::double precision;