role-permission-polymorphic

CREATE TABLE roles
(
  id integer NOT NULL DEFAULT nextval('roles_id_seq'::regclass),
  name character varying(255) NOT NULL,
  guard_name character varying(255) NOT NULL,
  created_at timestamp(0) without time zone,
  updated_at timestamp(0) without time zone,
  CONSTRAINT roles_pkey PRIMARY KEY (id)
)

CREATE TABLE permissions
(
  id integer NOT NULL DEFAULT nextval('permissions_id_seq'::regclass),
  name character varying(255) NOT NULL,
  guard_name character varying(255) NOT NULL,
  created_at timestamp(0) without time zone,
  updated_at timestamp(0) without time zone,
  CONSTRAINT permissions_pkey PRIMARY KEY (id)
)


CREATE TABLE model_has_permissions
(
  permission_id integer NOT NULL,
  model_id integer NOT NULL,
  model_type character varying(255) NOT NULL,
  CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type),
  CONSTRAINT model_has_permissions_permission_id_foreign FOREIGN KEY (permission_id)
      REFERENCES public.permissions (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)


CREATE TABLE public.model_has_roles
(
  role_id integer NOT NULL,
  model_id integer NOT NULL,
  model_type character varying(255) NOT NULL,
  CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type),
  CONSTRAINT model_has_roles_role_id_foreign FOREIGN KEY (role_id)
      REFERENCES public.roles (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)