CREATE TABLE public.push_notifications_apnsdevice ( id integer NOT NULL, name character varying(255), active boolean NOT NULL, date_created timestamp with time zone, device_id uuid, registration_id character varying(200) NOT NULL, user_id integer, application_id character varying(64) ); ALTER TABLE public.push_notifications_apnsdevice OWNER TO chuckaguilar; CREATE SEQUENCE public.push_notifications_apnsdevice_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.push_notifications_apnsdevice_id_seq OWNER TO chuckaguilar; ALTER SEQUENCE public.push_notifications_apnsdevice_id_seq OWNED BY public.push_notifications_apnsdevice.id; ALTER TABLE ONLY public.push_notifications_apnsdevice ALTER COLUMN id SET DEFAULT nextval('public.push_notifications_apnsdevice_id_seq'::regclass); ALTER TABLE ONLY public.push_notifications_apnsdevice ADD CONSTRAINT push_notifications_apnsdevice_pkey PRIMARY KEY (id); ALTER TABLE ONLY public.push_notifications_apnsdevice ADD CONSTRAINT push_notifications_apnsdevice_registration_id_key UNIQUE (registration_id); CREATE INDEX push_notifications_apnsdevice_device_id_0ac3cde3 ON public.push_notifications_apnsdevice USING btree (device_id); CREATE INDEX push_notifications_apnsdevice_registration_id_5502bc8c_like ON public.push_notifications_apnsdevice USING btree (registration_id varchar_pattern_ops); CREATE INDEX push_notifications_apnsdevice_user_id_44cc44d2 ON public.push_notifications_apnsdevice USING btree (user_id); ALTER TABLE ONLY public.push_notifications_apnsdevice ADD CONSTRAINT push_notifications_a_user_id_44cc44d2_fk_mapcapp_u FOREIGN KEY (user_id) REFERENCES public.mapcapp_user(id) DEFERRABLE INITIALLY DEFERRED; -- Name: push_notifications_gcmdevice; Type: TABLE; Schema: public; Owner: chuckaguilar CREATE TABLE public.push_notifications_gcmdevice ( id integer NOT NULL, name character varying(255), active boolean NOT NULL, date_created timestamp with time zone, device_id bigint, registration_id text NOT NULL, user_id integer, cloud_message_type character varying(3) NOT NULL, application_id character varying(64) ); ALTER TABLE public.push_notifications_gcmdevice OWNER TO chuckaguilar; CREATE SEQUENCE public.push_notifications_gcmdevice_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.push_notifications_gcmdevice_id_seq OWNER TO chuckaguilar; ALTER SEQUENCE public.push_notifications_gcmdevice_id_seq OWNED BY public.push_notifications_gcmdevice.id; ALTER TABLE ONLY public.push_notifications_gcmdevice ALTER COLUMN id SET DEFAULT nextval('public.push_notifications_gcmdevice_id_seq'::regclass); ALTER TABLE ONLY public.push_notifications_gcmdevice ADD CONSTRAINT push_notifications_gcmdevice_pkey PRIMARY KEY (id); CREATE INDEX push_notifications_gcmdevice_device_id_0b22a9c4 ON public.push_notifications_gcmdevice USING btree (device_id); CREATE INDEX push_notifications_gcmdevice_user_id_f3752f1b ON public.push_notifications_gcmdevice USING btree (user_id); ALTER TABLE ONLY public.push_notifications_gcmdevice ADD CONSTRAINT push_notifications_g_user_id_f3752f1b_fk_mapcapp_u FOREIGN KEY (user_id) REFERENCES public.mapcapp_user(id) DEFERRABLE INITIALLY DEFERRED;