Add importer role that can be associated with higher rate limits

[rails.git] / db / structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 467d5143cc427a0a9ad45190b9c260a7c6b7ee10..f7f3293265b2602523a1be18fdea1cf6bdbde681 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -91,7 +91,8 @@ CREATE TYPE public.nwr_enum AS ENUM (
 
 CREATE TYPE public.user_role_enum AS ENUM (
     'administrator',
 
 CREATE TYPE public.user_role_enum AS ENUM (
     'administrator',

-    'moderator'
+    'moderator',
+    'importer'

 );
 
 
 );
 
 


@@ -1883,7 +1884,7 @@ ALTER TABLE ONLY public.current_nodes
 --
 
 ALTER TABLE ONLY public.current_relation_members
 --
 
 ALTER TABLE ONLY public.current_relation_members

-    ADD CONSTRAINT current_relation_members_pkey PRIMARY KEY (relation_id, member_type, member_id, member_role, sequence_id);
+    ADD CONSTRAINT current_relation_members_pkey PRIMARY KEY (relation_id, sequence_id);

 
 
 --
 
 
 --


@@ -2107,7 +2108,7 @@ ALTER TABLE ONLY public.redactions
 --
 
 ALTER TABLE ONLY public.relation_members
 --
 
 ALTER TABLE ONLY public.relation_members

-    ADD CONSTRAINT relation_members_pkey PRIMARY KEY (relation_id, version, member_type, member_id, member_role, sequence_id);
+    ADD CONSTRAINT relation_members_pkey PRIMARY KEY (relation_id, version, sequence_id);

 
 
 --
 
 
 --


@@ -3437,6 +3438,8 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('23'),
 ('22'),
 ('21'),
 ('23'),
 ('22'),
 ('21'),

+('20231029151516'),
+('20231010194809'),

 ('20231007141103'),
 ('20230830115220'),
 ('20230830115219'),
 ('20231007141103'),
 ('20230830115220'),
 ('20230830115219'),