77 |
77 |
78 -- ########################################################################### |
78 -- ########################################################################### |
79 -- 2 up |
79 -- 2 up |
80 -- ########################################################################### |
80 -- ########################################################################### |
81 |
81 |
|
82 DROP INDEX crash_report_datas_idx_extract_crashing_functions; |
|
83 SELECT set_limit(0.1); |
82 CREATE TABLE "crash_groups" ( |
84 CREATE TABLE "crash_groups" ( |
83 "id" serial NOT NULL, |
85 "id" serial NOT NULL, |
84 "uuid" uuid NOT NULL, |
86 "uuid" uuid NOT NULL, |
85 "title" character varying NOT NULL, |
87 "title" character varying NOT NULL, |
86 "crash_thread_signature_bt" text NOT NULL, |
88 "crash_thread_signature_bt" text NOT NULL, |
|
89 |
|
90 EXCLUDE USING gist (crash_thread_signature_bt gist_trgm_ops WITH %), |
87 CONSTRAINT "crash_groups_uuid_idx" UNIQUE ("uuid"), |
91 CONSTRAINT "crash_groups_uuid_idx" UNIQUE ("uuid"), |
88 PRIMARY KEY ("id") |
92 PRIMARY KEY ("id") |
89 ); |
|
90 |
|
91 DROP INDEX crash_report_datas_idx_extract_crashing_functions; |
|
92 CREATE INDEX crash_groups_idx_crash_thread_signature_bt ON crash_groups USING gist ( |
|
93 crash_thread_signature_bt gist_trgm_ops |
|
94 ); |
93 ); |
95 |
94 |
96 ALTER TABLE "crash_reports" ADD COLUMN crash_group_id integer; |
95 ALTER TABLE "crash_reports" ADD COLUMN crash_group_id integer; |
97 ALTER TABLE "crash_reports" ADD COLUMN crash_group_distance real; |
96 ALTER TABLE "crash_reports" ADD COLUMN crash_group_distance real; |
98 ALTER TABLE "crash_reports" ADD CONSTRAINT "crash_reports_fk_crash_group_id" FOREIGN KEY ("crash_group_id") |
97 ALTER TABLE "crash_reports" ADD CONSTRAINT "crash_reports_fk_crash_group_id" FOREIGN KEY ("crash_group_id") |