Mojolicious::Plugin::RoutesAuthDBI::Schema

¡ ¡ ¡ ALL GLORY TO GLORIA ! ! !

NAME

Mojolicious::Plugin::RoutesAuthDBI::Schema - DB schema (PostgreSQL).

DB DESIGN DIAGRAM

See https://github.com/mche/Mojolicious-Plugin-RoutesAuthDBI/blob/master/Diagram.svg

DB design

Default variables for SQL templates

{
schema => "public",
sequence => '"public"."id"',
tables => { # no quotes! one schema!
  routes => 'routes',
  refs=>'refs',
  logins => 'logins',
  profiles => 'profiles',
  roles =>'roles',
  actions => 'actions',
  controllers => 'controllers',
  namespaces => 'namespaces',
  oauth_sites => 'oauth.sites',
  oauth_users => 'oauth.users',
  guests => 'guests',
  logs=>'logs',
  },
}