Update bundle

diff --git a/Gemfile.lock b/Gemfile.lock
index 91a24e8c2384da0f97b84a42ba18cf3c46cbb987..f17464c38c8d67230e12155710c8270fb92c3b57 100644 (file)
--- a/Gemfile.lock
+++ b/Gemfile.lock
@@ -92,17 +92,18 @@ GEM
     argon2 (2.3.2)
       ffi (~> 1.15)
       ffi-compiler (~> 1.0)
     argon2 (2.3.2)
       ffi (~> 1.15)
       ffi-compiler (~> 1.0)

-    ast (2.4.2)
+    ast (2.4.3)

     autoprefixer-rails (10.4.19.0)
       execjs (~> 2)
     aws-eventstream (1.3.2)
     autoprefixer-rails (10.4.19.0)
       execjs (~> 2)
     aws-eventstream (1.3.2)

-    aws-partitions (1.1068.0)
-    aws-sdk-core (3.220.1)
+    aws-partitions (1.1073.0)
+    aws-sdk-core (3.221.0)

       aws-eventstream (~> 1, >= 1.3.0)
       aws-partitions (~> 1, >= 1.992.0)
       aws-sigv4 (~> 1.9)
       base64
       jmespath (~> 1, >= 1.6.1)
       aws-eventstream (~> 1, >= 1.3.0)
       aws-partitions (~> 1, >= 1.992.0)
       aws-sigv4 (~> 1.9)
       base64
       jmespath (~> 1, >= 1.6.1)

+      logger

     aws-sdk-kms (1.99.0)
       aws-sdk-core (~> 3, >= 3.216.0)
       aws-sigv4 (~> 1.5)
     aws-sdk-kms (1.99.0)
       aws-sdk-core (~> 3, >= 3.216.0)
       aws-sigv4 (~> 1.5)


@@ -406,7 +407,7 @@ GEM
     net-smtp (0.5.1)
       net-protocol
     nio4r (2.7.4)
     net-smtp (0.5.1)
       net-protocol
     nio4r (2.7.4)

-    nokogiri (1.18.5)
+    nokogiri (1.18.6)

       mini_portile2 (~> 2.8.2)
       racc (~> 1.4)
     oauth (1.1.0)
       mini_portile2 (~> 2.8.2)
       racc (~> 1.4)
     oauth (1.1.0)


@@ -468,7 +469,7 @@ GEM
       iniparse (~> 1.4)
       rexml (>= 3.3.9)
     parallel (1.26.3)
       iniparse (~> 1.4)
       rexml (>= 3.3.9)
     parallel (1.26.3)

-    parser (3.3.7.1)
+    parser (3.3.7.2)

       ast (~> 2.4.1)
       racc
     pg (1.5.9)
       ast (~> 2.4.1)
       racc
     pg (1.5.9)


@@ -476,6 +477,7 @@ GEM
     pp (0.6.2)
       prettyprint
     prettyprint (0.2.0)
     pp (0.6.2)
       prettyprint
     prettyprint (0.2.0)

+    prism (1.4.0)

     progress (3.6.0)
     pstore (0.2.0)
     psych (5.2.3)
     progress (3.6.0)
     pstore (0.2.0)
     psych (5.2.3)


@@ -548,7 +550,7 @@ GEM
     rb-inotify (0.11.1)
       ffi (~> 1.0)
     rchardet (1.9.0)
     rb-inotify (0.11.1)
       ffi (~> 1.0)
     rchardet (1.9.0)

-    rdoc (6.12.0)
+    rdoc (6.13.0)

       psych (>= 4.0.0)
     regexp_parser (2.10.0)
     reline (0.6.0)
       psych (>= 4.0.0)
     regexp_parser (2.10.0)
     reline (0.6.0)


@@ -572,8 +574,9 @@ GEM
       rubocop-ast (>= 1.38.0, < 2.0)
       ruby-progressbar (~> 1.7)
       unicode-display_width (>= 2.4.0, < 4.0)
       rubocop-ast (>= 1.38.0, < 2.0)
       ruby-progressbar (~> 1.7)
       unicode-display_width (>= 2.4.0, < 4.0)

-    rubocop-ast (1.39.0)
-      parser (>= 3.3.1.0)
+    rubocop-ast (1.43.0)
+      parser (>= 3.3.7.2)
+      prism (~> 1.4)

     rubocop-capybara (2.22.1)
       lint_roller (~> 1.1)
       rubocop (~> 1.72, >= 1.72.1)
     rubocop-capybara (2.22.1)
       lint_roller (~> 1.1)
       rubocop (~> 1.72, >= 1.72.1)


@@ -613,7 +616,7 @@ GEM
       addressable (>= 2.3.5)
       faraday (>= 0.17.3, < 3)
     securerandom (0.4.1)
       addressable (>= 2.3.5)
       faraday (>= 0.17.3, < 3)
     securerandom (0.4.1)

-    selenium-webdriver (4.23.0)
+    selenium-webdriver (4.30.1)

       base64 (~> 0.2)
       logger (~> 1.4)
       rexml (~> 3.2, >= 3.2.5)
       base64 (~> 0.2)
       logger (~> 1.4)
       rexml (~> 3.2, >= 3.2.5)


@@ -641,7 +644,7 @@ GEM
       actionpack (>= 6.1)
       activesupport (>= 6.1)
       sprockets (>= 3.0.0)
       actionpack (>= 6.1)
       activesupport (>= 6.1)
       sprockets (>= 3.0.0)

-    stringio (3.1.5)
+    stringio (3.1.6)

     strong_migrations (1.8.0)
       activerecord (>= 5.2)
     teaspoon (1.4.0)
     strong_migrations (1.8.0)
       activerecord (>= 5.2)
     teaspoon (1.4.0)

diff --git a/db/structure.sql b/db/structure.sql
index 9d3af4d001979914fd03e0f051750c40ef8c7070..5b0aecd41dfd7c51fa90b4b3809a813c71c8dd55 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -9,6 +9,12 @@ SET xmloption = content;
 SET client_min_messages = warning;
 SET row_security = off;
 
 SET client_min_messages = warning;
 SET row_security = off;
 

+--
+-- Name: public; Type: SCHEMA; Schema: -; Owner: -
+--
+
+-- *not* creating schema, since initdb creates it
+

 
 --
 -- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: -
 
 --
 -- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: -


@@ -1362,6 +1368,38 @@ CREATE TABLE public.schema_migrations (
 );
 
 
 );
 
 

+--
+-- Name: social_links; Type: TABLE; Schema: public; Owner: -
+--
+
+CREATE TABLE public.social_links (
+    id bigint NOT NULL,
+    user_id bigint NOT NULL,
+    url character varying,
+    created_at timestamp(6) without time zone NOT NULL,
+    updated_at timestamp(6) without time zone NOT NULL
+);
+
+
+--
+-- Name: social_links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
+--
+
+CREATE SEQUENCE public.social_links_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+--
+-- Name: social_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+--
+
+ALTER SEQUENCE public.social_links_id_seq OWNED BY public.social_links.id;
+
+

 --
 -- Name: user_blocks; Type: TABLE; Schema: public; Owner: -
 --
 --
 -- Name: user_blocks; Type: TABLE; Schema: public; Owner: -
 --


@@ -1451,9 +1489,9 @@ CREATE TABLE public.user_preferences (
 CREATE TABLE public.user_roles (
     id integer NOT NULL,
     user_id bigint NOT NULL,
 CREATE TABLE public.user_roles (
     id integer NOT NULL,
     user_id bigint NOT NULL,

-    role public.user_role_enum NOT NULL,

     created_at timestamp without time zone,
     updated_at timestamp without time zone,
     created_at timestamp without time zone,
     updated_at timestamp without time zone,

+    role public.user_role_enum NOT NULL,

     granter_id bigint NOT NULL
 );
 
     granter_id bigint NOT NULL
 );
 


@@ -1756,6 +1794,13 @@ ALTER TABLE ONLY public.redactions ALTER COLUMN id SET DEFAULT nextval('public.r
 ALTER TABLE ONLY public.reports ALTER COLUMN id SET DEFAULT nextval('public.reports_id_seq'::regclass);
 
 
 ALTER TABLE ONLY public.reports ALTER COLUMN id SET DEFAULT nextval('public.reports_id_seq'::regclass);
 
 

+--
+-- Name: social_links id; Type: DEFAULT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.social_links ALTER COLUMN id SET DEFAULT nextval('public.social_links_id_seq'::regclass);
+
+

 --
 -- Name: user_blocks id; Type: DEFAULT; Schema: public; Owner: -
 --
 --
 -- Name: user_blocks id; Type: DEFAULT; Schema: public; Owner: -
 --


@@ -2120,6 +2165,14 @@ ALTER TABLE ONLY public.schema_migrations
     ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
 
 
     ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
 
 

+--
+-- Name: social_links social_links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.social_links
+    ADD CONSTRAINT social_links_pkey PRIMARY KEY (id);
+
+

 --
 -- Name: user_blocks user_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --
 --
 -- Name: user_blocks user_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --


@@ -2646,6 +2699,13 @@ CREATE INDEX index_reports_on_issue_id ON public.reports USING btree (issue_id);
 CREATE INDEX index_reports_on_user_id ON public.reports USING btree (user_id);
 
 
 CREATE INDEX index_reports_on_user_id ON public.reports USING btree (user_id);
 
 

+--
+-- Name: index_social_links_on_user_id; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_social_links_on_user_id ON public.social_links USING btree (user_id);
+
+

 --
 -- Name: index_user_blocks_on_creator_id_and_id; Type: INDEX; Schema: public; Owner: -
 --
 --
 -- Name: index_user_blocks_on_creator_id_and_id; Type: INDEX; Schema: public; Owner: -
 --


@@ -3041,6 +3101,14 @@ ALTER TABLE ONLY public.user_mutes
     ADD CONSTRAINT fk_rails_591dad3359 FOREIGN KEY (owner_id) REFERENCES public.users(id);
 
 
     ADD CONSTRAINT fk_rails_591dad3359 FOREIGN KEY (owner_id) REFERENCES public.users(id);
 
 

+--
+-- Name: social_links fk_rails_6034fd4f62; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.social_links
+    ADD CONSTRAINT fk_rails_6034fd4f62 FOREIGN KEY (user_id) REFERENCES public.users(id);
+
+

 --
 -- Name: oauth_access_tokens fk_rails_732cb83ab7; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 --
 -- Name: oauth_access_tokens fk_rails_732cb83ab7; Type: FK CONSTRAINT; Schema: public; Owner: -
 --


@@ -3449,6 +3517,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20250212160355'),
 ('20250206202905'),
 ('20250121191749'),
 ('20250212160355'),
 ('20250206202905'),
 ('20250121191749'),

+('20250106113207'),

 ('20250105154621'),
 ('20250104140952'),
 ('20241023004427'),
 ('20250105154621'),
 ('20250104140952'),
 ('20241023004427'),