ALTER TABLE user_group ALTER COLUMN artifact_flags SET DEFAULT 0;
DROP TABLE IF EXISTS project_metric_tmp1;
+DROP SEQUENCE IF EXISTS project_metric_tmp1_pk_seq;
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 RENAME COLUMN set_date_new TO set_date;
+
+DROP INDEX project_categor_category_id_key;
+DROP INDEX themes_theme_id_key;
\ No newline at end of file
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;
+
+DROP INDEX group_unix_uniq;
+CREATE UNIQUE INDEX group_unix_uniq ON groups USING btree (unix_group_name);
+
+CREATE UNIQUE INDEX project_messa_project_messa_key ON project_messages USING btree (project_message_id);
projects / fusionforge / fusionforge.git / commitdiff