wagtailcore_grouppagepermission
Data license: MIT
5 rows where group_id = 1
This data as json, CSV (advanced)
| id ▼ | group_id | page_id | permission_id |
|---|---|---|---|
| 1 | Moderators 1 | Root 1 | Can add page 70 |
| 2 | Moderators 1 | Root 1 | Can change page 71 |
| 3 | Moderators 1 | Root 1 | Publish any page 76 |
| 6 | Moderators 1 | Root 1 | Lock/unlock pages you've locked 75 |
| 7 | Moderators 1 | Root 1 | Unlock any page 77 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "wagtailcore_grouppagepermission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id") DEFERRABLE INITIALLY DEFERRED, "page_id" integer NOT NULL REFERENCES "wagtailcore_page" ("id") DEFERRABLE INITIALLY DEFERRED, "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id") DEFERRABLE INITIALLY DEFERRED, CONSTRAINT "unique_permission" UNIQUE ("group_id", "page_id", "permission_id"));
CREATE INDEX "wagtailcore_grouppagepermission_group_id_fc07e671" ON "wagtailcore_grouppagepermission" ("group_id");
CREATE INDEX "wagtailcore_grouppagepermission_page_id_710b114a" ON "wagtailcore_grouppagepermission" ("page_id");
CREATE INDEX "wagtailcore_grouppagepermission_permission_id_05acb22e" ON "wagtailcore_grouppagepermission" ("permission_id");