CREATE TABLE public.notifications_notification
(
  id INTEGER NOT NULL DEFAULT NEXTVAL('notifications_notification_id_seq'::regclass),
  level CHARACTER VARYING(20) NOT NULL,
  unread BOOLEAN NOT NULL,
  actor_object_id CHARACTER VARYING(255) NOT NULL,
  verb CHARACTER VARYING(255) NOT NULL,
  description text,
  target_object_id CHARACTER VARYING(255),
  action_object_object_id CHARACTER VARYING(255),
  "timestamp" TIMESTAMP WITH TIME zone NOT NULL,
  public BOOLEAN NOT NULL,
  action_object_content_type_id INTEGER,
  actor_content_type_id INTEGER NOT NULL,
  recipient_id INTEGER NOT NULL,
  target_content_type_id INTEGER,
  deleted BOOLEAN NOT NULL,
  emailed BOOLEAN NOT NULL,
  DATA text,
  CONSTRAINT notifications_notification_pkey PRIMARY KEY (id),
  CONSTRAINT notifications_notifi_action_object_conten_7d2b8ee9_fk_django_co FOREIGN KEY (action_object_content_type_id)
      REFERENCES public.django_content_type (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT notifications_notifi_actor_content_type_i_0c69d7b7_fk_django_co FOREIGN KEY (actor_content_type_id)
      REFERENCES public.django_content_type (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT notifications_notifi_recipient_id_d055f3f0_fk_auth_user FOREIGN KEY (recipient_id)
      REFERENCES public.auth_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
  CONSTRAINT notifications_notifi_target_content_type__ccb24d88_fk_django_co FOREIGN KEY (target_content_type_id)
      REFERENCES public.django_content_type (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.notifications_notification
  OWNER TO oscar;

-- Index: public.notifications_notification_action_object_content_type_7d2b8ee9

-- DROP INDEX public.notifications_notification_action_object_content_type_7d2b8ee9;

CREATE INDEX notifications_notification_action_object_content_type_7d2b8ee9
  ON public.notifications_notification
  USING btree
  (action_object_content_type_id);

-- Index: public.notifications_notification_actor_content_type_id_0c69d7b7

-- DROP INDEX public.notifications_notification_actor_content_type_id_0c69d7b7;

CREATE INDEX notifications_notification_actor_content_type_id_0c69d7b7
  ON public.notifications_notification
  USING btree
  (actor_content_type_id);

-- Index: public.notifications_notification_recipient_id_d055f3f0

-- DROP INDEX public.notifications_notification_recipient_id_d055f3f0;

CREATE INDEX notifications_notification_recipient_id_d055f3f0
  ON public.notifications_notification
  USING btree
  (recipient_id);

-- Index: public.notifications_notification_target_content_type_id_ccb24d88

-- DROP INDEX public.notifications_notification_target_content_type_id_ccb24d88;

CREATE INDEX notifications_notification_target_content_type_id_ccb24d88
  ON public.notifications_notification
  USING btree
  (target_content_type_id);