From 2ce54b139a7e55f5266432380600db4b36e27a93 Mon Sep 17 00:00:00 2001 From: Roland Mas Date: Thu, 17 Nov 2011 19:54:13 +0000 Subject: [PATCH] More convergence SQL --- src/db/20111017-schema-convergence-src-1.sql | 13 +++++++++++++ src/db/schema-convergence-deb-1.sql | 6 ++++++ 2 files changed, 19 insertions(+) diff --git a/src/db/20111017-schema-convergence-src-1.sql b/src/db/20111017-schema-convergence-src-1.sql index 85e6c3ba09..7fe28625ec 100644 --- a/src/db/20111017-schema-convergence-src-1.sql +++ b/src/db/20111017-schema-convergence-src-1.sql @@ -18,6 +18,8 @@ ALTER SEQUENCE project_messa_project_messa_seq RENAME TO project_messages_projec ALTER TABLE activity_log ALTER COLUMN ver SET DEFAULT 0::double precision; ALTER TABLE artifact_extra_field_data ALTER COLUMN data_id SET DEFAULT nextval('artifact_extra_field_data_data_id_seq'::regclass); ALTER TABLE artifact_extra_field_list ALTER COLUMN extra_field_id SET DEFAULT nextval('artifact_extra_field_list_extra_field_id_seq'::regclass); +ALTER TABLE artifact_extra_field_elements ALTER COLUMN element_id SET DEFAULT nextval('artifact_extra_field_elements_element_id_seq'::regclass); + ALTER TABLE db_images ALTER COLUMN upload_date SET DEFAULT 0; ALTER TABLE db_images ALTER COLUMN version SET DEFAULT 0; @@ -43,3 +45,14 @@ ALTER TABLE role ADD CONSTRAINT role_group_id_fkey FOREIGN KEY (group_id) REFERE ALTER TABLE ONLY themes ADD CONSTRAINT themes_pkey PRIMARY KEY (theme_id); ALTER TABLE project_messages ALTER COLUMN project_message_id SET DEFAULT nextval('project_messages_project_message_id_seq'::regclass); + +DROP SEQUENCE themes_pk_seq; +ALTER SEQUENCE themes_theme_id_seq RENAME TO themes_pk_seq; + +DROP SEQUENCE trove_treesums_pk_seq; +ALTER SEQUENCE trove_treesum_trove_treesum_seq RENAME TO trove_treesums_pk_seq; + +ALTER SEQUENCE group_cvs_history_pk_seq MAXVALUE 2147483647; +ALTER SEQUENCE supported_languages_pk_seq MAXVALUE 2147483647; + +ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass); diff --git a/src/db/schema-convergence-deb-1.sql b/src/db/schema-convergence-deb-1.sql index 88d44e403e..cf7b907836 100644 --- a/src/db/schema-convergence-deb-1.sql +++ b/src/db/schema-convergence-deb-1.sql @@ -16,3 +16,9 @@ ALTER TABLE ONLY project_task_external_order ADD CONSTRAINT project_task_externa DROP SEQUENCE foundry_projects_pk_seq; DROP SEQUENCE foundry_preferred_projec_pk_seq; +DROP SEQUENCE artifact_perm_id_seq; + +ALTER TABLE forum_attachment ALTER COLUMN mimetype SET NOT NULL; +ALTER TABLE forum_pending_attachment ALTER COLUMN mimetype SET NOT NULL; + +ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass); -- 2.30.2