<commit_before>ALTER TABLE "augur_data"."contributors_aliases" ALTER COLUMN "data_collection_date" SET DEFAULT CURRENT_TIMESTAMP;

CREATE SEQUENCE "spdx"."projects_package_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

ALTER TABLE "spdx"."files" DROP CONSTRAINT "files_project_id_fkey";

ALTER TABLE "spdx"."files" ADD COLUMN "package_id" int4;

ALTER TABLE "spdx"."files" DROP COLUMN "project_id";

ALTER TABLE "spdx"."projects" DROP CONSTRAINT "projects_pkey";

ALTER TABLE "spdx"."projects" ADD COLUMN "package_id" int4 NOT NULL DEFAULT nextval('"spdx".projects_package_id_seq'::regclass);

ALTER TABLE "spdx"."projects" DROP COLUMN "project_id";

ALTER TABLE "spdx"."projects" ADD CONSTRAINT "projects_pkey" PRIMARY KEY ("package_id");

SELECT setval('"spdx"."projects_package_id_seq"', 1, false);

ALTER SEQUENCE "spdx"."projects_package_id_seq"
OWNED BY "spdx"."projects"."package_id";

ALTER SEQUENCE "spdx"."projects_package_id_seq" OWNER TO "augur";<commit_msg>Additional database updates for next release.<commit_after>ALTER TABLE "augur_data"."contributors_aliases" ALTER COLUMN "data_collection_date" SET DEFAULT CURRENT_TIMESTAMP;

CREATE SEQUENCE "spdx"."projects_package_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

ALTER TABLE "spdx"."files" DROP CONSTRAINT "files_project_id_fkey";

ALTER TABLE "spdx"."files" ADD COLUMN "package_id" int4;

ALTER TABLE "spdx"."files" DROP COLUMN "project_id";

ALTER TABLE "spdx"."projects" DROP CONSTRAINT "projects_pkey";

ALTER TABLE "spdx"."projects" ADD COLUMN "package_id" int4 NOT NULL DEFAULT nextval('"spdx".projects_package_id_seq'::regclass);

ALTER TABLE "spdx"."projects" DROP COLUMN "project_id";

ALTER TABLE "spdx"."projects" ADD CONSTRAINT "projects_pkey" PRIMARY KEY ("package_id");

SELECT setval('"spdx"."projects_package_id_seq"', 1, false);

ALTER SEQUENCE "spdx"."projects_package_id_seq"
OWNED BY "spdx"."projects"."package_id";

ALTER SEQUENCE "spdx"."projects_package_id_seq" OWNER TO "augur";

-- Index Update for Performance. 
CREATE INDEX "reponameindex" ON "augur_data"."repo" USING hash (
  "repo_name"
);
{'fraction_non_alphanumeric': 0.11979410388394947, 'fraction_numerical': 0.015910154422087038, 'mean_word_length': 7.1603053435114505, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3090995', 'n_tokens_mistral': 823, 'n_tokens_neox': 758, 'n_words': 194}