| /*------------------------------------------------------------------------- |
| * |
| * pg_auth_members.h |
| * definition of the system "authorization identifier members" relation |
| * (pg_auth_members) along with the relation's initial contents. |
| * |
| * |
| * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group |
| * Portions Copyright (c) 1994, Regents of the University of California |
| * |
| * $PostgreSQL: pgsql/src/include/catalog/pg_auth_members.h,v 1.2 2006/03/05 15:58:54 momjian Exp $ |
| * |
| * NOTES |
| * the genbki.sh script reads this file and generates .bki |
| * information from the DATA() statements. |
| * |
| *------------------------------------------------------------------------- |
| */ |
| #ifndef PG_AUTH_MEMBERS_H |
| #define PG_AUTH_MEMBERS_H |
| |
| #include "catalog/genbki.h" |
| |
| /* TIDYCAT_BEGINFAKEDEF |
| |
| CREATE TABLE pg_auth_members |
| with (camelcase=AuthMem, shared=true, oid=false, relid=1261) |
| ( |
| roleid oid, |
| member oid, |
| grantor oid, |
| admin_option boolean |
| ); |
| |
| create unique index on pg_auth_members(roleid, member) with (indexid=2694, CamelCase=AuthMemRoleMem, syscacheid=AUTHMEMROLEMEM, syscache_nbuckets=128); |
| |
| create unique index on pg_auth_members(member, roleid) with (indexid=2695, CamelCase=AuthMemMemRole, syscacheid=AUTHMEMMEMROLE, syscache_nbuckets=128); |
| |
| alter table pg_auth_members add fk roleid on pg_authid(oid); |
| alter table pg_auth_members add fk member on pg_authid(oid); |
| |
| TIDYCAT_ENDFAKEDEF |
| |
| NOTE: we don't mark grantor a foreign key since we don't actually |
| do not remove entries when a grantor is dropped. See DropRole(). |
| */ |
| |
| /* ---------------- |
| * pg_auth_members definition. cpp turns this into |
| * typedef struct FormData_pg_auth_members |
| * ---------------- |
| */ |
| #define AuthMemRelationId 1261 |
| |
| CATALOG(pg_auth_members,1261) BKI_SHARED_RELATION BKI_WITHOUT_OIDS |
| { |
| Oid roleid; /* ID of a role */ |
| Oid member; /* ID of a member of that role */ |
| Oid grantor; /* who granted the membership */ |
| bool admin_option; /* granted with admin option? */ |
| } FormData_pg_auth_members; |
| |
| /* ---------------- |
| * Form_pg_auth_members corresponds to a pointer to a tuple with |
| * the format of pg_auth_members relation. |
| * ---------------- |
| */ |
| typedef FormData_pg_auth_members *Form_pg_auth_members; |
| |
| /* ---------------- |
| * compiler constants for pg_auth_members |
| * ---------------- |
| */ |
| #define Natts_pg_auth_members 4 |
| #define Anum_pg_auth_members_roleid 1 |
| #define Anum_pg_auth_members_member 2 |
| #define Anum_pg_auth_members_grantor 3 |
| #define Anum_pg_auth_members_admin_option 4 |
| |
| #endif /* PG_AUTH_MEMBERS_H */ |