rattlesnake_schema.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

--
-- Name: addbbox(geometry); Type: FUNCTION; Schema: public; Owner: postgres
--

--
-- Name: accum(geometry); Type: AGGREGATE; Schema: public; Owner: postgres
--


CREATE TABLE accounts_accountsignup (
    id integer NOT NULL,
    user_id integer NOT NULL,
    last_active timestamp with time zone,
    activation_key character varying(40) NOT NULL,
    activation_notification_send boolean NOT NULL,
    email_unconfirmed character varying(75) NOT NULL,
    email_confirmation_key character varying(40) NOT NULL,
    email_confirmation_key_created timestamp with time zone
);


ALTER TABLE public.accounts_accountsignup OWNER TO globalmet;

--
-- Name: accounts_accountsignup_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_accountsignup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_accountsignup_id_seq OWNER TO globalmet;

--
-- Name: accounts_accountsignup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_accountsignup_id_seq OWNED BY accounts_accountsignup.id;


--
-- Name: accounts_clientprofile; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE accounts_clientprofile (
    id integer NOT NULL,
    mugshot character varying(100) NOT NULL,
    privacy character varying(15) NOT NULL,
    user_id integer NOT NULL,
    numero_celular character varying(128),
    allowed_num_viewers integer NOT NULL,
    tos boolean NOT NULL,
    CONSTRAINT accounts_clientprofile_allowed_num_viewers_check CHECK ((allowed_num_viewers >= 0))
);


ALTER TABLE public.accounts_clientprofile OWNER TO globalmet;

--
-- Name: accounts_clientprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_clientprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_clientprofile_id_seq OWNER TO globalmet;

--
-- Name: accounts_clientprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_clientprofile_id_seq OWNED BY accounts_clientprofile.id;


--
-- Name: accounts_domicilio; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE accounts_domicilio (
    id integer NOT NULL,
    direccion character varying(200) NOT NULL,
    colonia character varying(200) NOT NULL,
    ciudad character varying(200) NOT NULL,
    codigo_postal character varying(10) NOT NULL,
    telefono character varying(30) NOT NULL,
    telefono2 character varying(30) NOT NULL,
    content_type_id integer NOT NULL,
    object_id integer NOT NULL,
    CONSTRAINT accounts_domicilio_object_id_check CHECK ((object_id >= 0))
);


ALTER TABLE public.accounts_domicilio OWNER TO globalmet;

--
-- Name: accounts_domicilio_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_domicilio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_domicilio_id_seq OWNER TO globalmet;

--
-- Name: accounts_domicilio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_domicilio_id_seq OWNED BY accounts_domicilio.id;


--
-- Name: accounts_meteorologoprofile; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE accounts_meteorologoprofile (
    id integer NOT NULL,
    mugshot character varying(100) NOT NULL,
    privacy character varying(15) NOT NULL,
    user_id integer NOT NULL,
    activo boolean NOT NULL,
    is_admin boolean NOT NULL
);


ALTER TABLE public.accounts_meteorologoprofile OWNER TO globalmet;

--
-- Name: accounts_meteorologoprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_meteorologoprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_meteorologoprofile_id_seq OWNER TO globalmet;

--
-- Name: accounts_meteorologoprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_meteorologoprofile_id_seq OWNED BY accounts_meteorologoprofile.id;


--
-- Name: accounts_vendedor; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE accounts_vendedor (
    id integer NOT NULL,
    nombre character varying(120) NOT NULL,
    apellidos character varying(120) NOT NULL,
    telefono character varying(30) NOT NULL,
    movil character varying(12) NOT NULL,
    email character varying(254) NOT NULL,
    modified timestamp with time zone NOT NULL,
    created timestamp with time zone NOT NULL,
    principal boolean NOT NULL,
    titulo character varying(160) NOT NULL
);


ALTER TABLE public.accounts_vendedor OWNER TO globalmet;

--
-- Name: accounts_vendedor_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_vendedor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_vendedor_id_seq OWNER TO globalmet;

--
-- Name: accounts_vendedor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_vendedor_id_seq OWNED BY accounts_vendedor.id;


--
-- Name: accounts_viewerprofile; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE accounts_viewerprofile (
    id integer NOT NULL,
    mugshot character varying(100) NOT NULL,
    privacy character varying(15) NOT NULL,
    user_id integer NOT NULL,
    numero_celular character varying(128),
    cliente_id integer NOT NULL
);


ALTER TABLE public.accounts_viewerprofile OWNER TO globalmet;

--
-- Name: accounts_viewerprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE accounts_viewerprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accounts_viewerprofile_id_seq OWNER TO globalmet;

--
-- Name: accounts_viewerprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE accounts_viewerprofile_id_seq OWNED BY accounts_viewerprofile.id;


--
-- Name: alertas_acuseenvioaviso; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_acuseenvioaviso (
    id integer NOT NULL,
    created timestamp with time zone,
    correo_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.alertas_acuseenvioaviso OWNER TO globalmet;

--
-- Name: alertas_acuseenvioaviso_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_acuseenvioaviso_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_acuseenvioaviso_id_seq OWNER TO globalmet;

--
-- Name: alertas_acuseenvioaviso_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_acuseenvioaviso_id_seq OWNED BY alertas_acuseenvioaviso.id;


--
-- Name: alertas_avisocorreo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_avisocorreo (
    id integer NOT NULL,
    titulo character varying(160) NOT NULL,
    mensaje text NOT NULL,
    created timestamp with time zone,
    created_by_id integer NOT NULL
);


ALTER TABLE public.alertas_avisocorreo OWNER TO globalmet;

--
-- Name: alertas_avisocorreo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_avisocorreo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_avisocorreo_id_seq OWNER TO globalmet;

--
-- Name: alertas_avisocorreo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_avisocorreo_id_seq OWNED BY alertas_avisocorreo.id;


--
-- Name: alertas_condicionmeteorologica; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_condicionmeteorologica (
    id integer NOT NULL,
    variable_meteorologica_id integer NOT NULL,
    comparador integer NOT NULL,
    valor numeric(16,4) NOT NULL,
    fecha_inicio date NOT NULL,
    fecha_fin date NOT NULL,
    duracion integer NOT NULL,
    campo_id integer NOT NULL,
    activo boolean NOT NULL,
    siempre boolean NOT NULL
);


ALTER TABLE public.alertas_condicionmeteorologica OWNER TO globalmet;

--
-- Name: alertas_condicionmeteorologica_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_condicionmeteorologica_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_condicionmeteorologica_id_seq OWNER TO globalmet;

--
-- Name: alertas_condicionmeteorologica_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_condicionmeteorologica_id_seq OWNED BY alertas_condicionmeteorologica.id;


--
-- Name: alertas_evento; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_evento (
    id integer NOT NULL,
    fecha_deteccion timestamp with time zone NOT NULL,
    fecha_primera_ocasion timestamp with time zone NOT NULL,
    condicion_meteorologica_id integer NOT NULL,
    detonador numeric(16,2)
);


ALTER TABLE public.alertas_evento OWNER TO globalmet;

--
-- Name: alertas_evento_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_evento_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_evento_id_seq OWNER TO globalmet;

--
-- Name: alertas_evento_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_evento_id_seq OWNED BY alertas_evento.id;


--
-- Name: alertas_notificacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_notificacion (
    id integer NOT NULL,
    user_id integer NOT NULL,
    titulo character varying(160) NOT NULL,
    mensaje text NOT NULL,
    evento_id integer,
    tipo_id integer NOT NULL,
    clasificacion integer,
    identificador integer
);


ALTER TABLE public.alertas_notificacion OWNER TO globalmet;

--
-- Name: alertas_notificacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_notificacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_notificacion_id_seq OWNER TO globalmet;

--
-- Name: alertas_notificacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_notificacion_id_seq OWNED BY alertas_notificacion.id;


--
-- Name: alertas_notificacionpersonalizada; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_notificacionpersonalizada (
    id integer NOT NULL,
    titulo character varying(160) NOT NULL,
    mensaje text NOT NULL,
    user_id integer NOT NULL,
    tipo_id integer NOT NULL,
    created timestamp with time zone
);


ALTER TABLE public.alertas_notificacionpersonalizada OWNER TO globalmet;

--
-- Name: alertas_notificacionpersonalizada_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_notificacionpersonalizada_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_notificacionpersonalizada_id_seq OWNER TO globalmet;

--
-- Name: alertas_notificacionpersonalizada_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_notificacionpersonalizada_id_seq OWNED BY alertas_notificacionpersonalizada.id;


--
-- Name: alertas_preferencianotificacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_preferencianotificacion (
    id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.alertas_preferencianotificacion OWNER TO globalmet;

--
-- Name: alertas_preferencianotificacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_preferencianotificacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_preferencianotificacion_id_seq OWNER TO globalmet;

--
-- Name: alertas_preferencianotificacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_preferencianotificacion_id_seq OWNED BY alertas_preferencianotificacion.id;


--
-- Name: alertas_preferencianotificacion_tipos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_preferencianotificacion_tipos (
    id integer NOT NULL,
    preferencianotificacion_id integer NOT NULL,
    tiponotificacion_id integer NOT NULL
);


ALTER TABLE public.alertas_preferencianotificacion_tipos OWNER TO globalmet;

--
-- Name: alertas_preferencianotificacion_tipos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_preferencianotificacion_tipos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_preferencianotificacion_tipos_id_seq OWNER TO globalmet;

--
-- Name: alertas_preferencianotificacion_tipos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_preferencianotificacion_tipos_id_seq OWNED BY alertas_preferencianotificacion_tipos.id;


--
-- Name: alertas_tiponotificacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE alertas_tiponotificacion (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    tipo integer NOT NULL
);


ALTER TABLE public.alertas_tiponotificacion OWNER TO globalmet;

--
-- Name: alertas_tiponotificacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE alertas_tiponotificacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alertas_tiponotificacion_id_seq OWNER TO globalmet;

--
-- Name: alertas_tiponotificacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE alertas_tiponotificacion_id_seq OWNED BY alertas_tiponotificacion.id;


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO globalmet;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO globalmet;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO globalmet;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO globalmet;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO globalmet;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO globalmet;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(255) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(75) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO globalmet;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO globalmet;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_groups_id_seq OWNER TO globalmet;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_id_seq OWNER TO globalmet;

--
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO globalmet;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO globalmet;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- Name: authtoken_token; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE authtoken_token (
    key character varying(40) NOT NULL,
    user_id integer NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.authtoken_token OWNER TO globalmet;

--
-- Name: banners_anuncio; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE banners_anuncio (
    id integer NOT NULL,
    titulo character varying(100) NOT NULL,
    small character varying(100) NOT NULL,
    "full" character varying(100),
    activo boolean NOT NULL,
    vigencia date NOT NULL,
    created timestamp with time zone NOT NULL,
    modified timestamp with time zone NOT NULL,
    url character varying(200) NOT NULL,
    campaign_id character varying(50) NOT NULL
);


ALTER TABLE public.banners_anuncio OWNER TO globalmet;

--
-- Name: banners_anuncio_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE banners_anuncio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.banners_anuncio_id_seq OWNER TO globalmet;

--
-- Name: banners_anuncio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE banners_anuncio_id_seq OWNED BY banners_anuncio.id;


--
-- Name: banners_anuncio_regiones; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE banners_anuncio_regiones (
    id integer NOT NULL,
    anuncio_id integer NOT NULL,
    region_id integer NOT NULL
);


ALTER TABLE public.banners_anuncio_regiones OWNER TO globalmet;

--
-- Name: banners_anuncio_regiones_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE banners_anuncio_regiones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.banners_anuncio_regiones_id_seq OWNER TO globalmet;

--
-- Name: banners_anuncio_regiones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE banners_anuncio_regiones_id_seq OWNED BY banners_anuncio_regiones.id;


--
-- Name: banners_reproduccion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE banners_reproduccion (
    id integer NOT NULL,
    times_seen integer NOT NULL,
    modified timestamp with time zone NOT NULL,
    anuncio_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.banners_reproduccion OWNER TO globalmet;

--
-- Name: banners_reproduccion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE banners_reproduccion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.banners_reproduccion_id_seq OWNER TO globalmet;

--
-- Name: banners_reproduccion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE banners_reproduccion_id_seq OWNED BY banners_reproduccion.id;


--
-- Name: campos_asignacioncampo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_asignacioncampo (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    meteorologo_id integer NOT NULL
);


ALTER TABLE public.campos_asignacioncampo OWNER TO globalmet;

--
-- Name: campos_asignacioncampo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_asignacioncampo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_asignacioncampo_id_seq OWNER TO globalmet;

--
-- Name: campos_asignacioncampo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_asignacioncampo_id_seq OWNED BY campos_asignacioncampo.id;


--
-- Name: campos_campo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_campo (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    empresa_id integer NOT NULL,
    meteorologo_id integer NOT NULL,
    region_id integer NOT NULL,
    latitud double precision NOT NULL,
    longitud double precision NOT NULL,
    geofence geography(Polygon,4326) NOT NULL,
    timezone character varying(100),
    activo boolean NOT NULL,
    coeficiente_etp double precision NOT NULL,
    observaciones text,
    climatologia_id integer,
    modelo_pronostico integer NOT NULL
);


ALTER TABLE public.campos_campo OWNER TO globalmet;

--
-- Name: campos_campo_cultivos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_campo_cultivos (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    cultivo_id integer NOT NULL
);


ALTER TABLE public.campos_campo_cultivos OWNER TO globalmet;

--
-- Name: campos_campo_cultivos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_campo_cultivos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_campo_cultivos_id_seq OWNER TO globalmet;

--
-- Name: campos_campo_cultivos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_campo_cultivos_id_seq OWNED BY campos_campo_cultivos.id;


--
-- Name: campos_campo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_campo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_campo_id_seq OWNER TO globalmet;

--
-- Name: campos_campo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_campo_id_seq OWNED BY campos_campo.id;


--
-- Name: campos_campo_usuarios; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_campo_usuarios (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.campos_campo_usuarios OWNER TO globalmet;

--
-- Name: campos_campo_usuarios_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_campo_usuarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_campo_usuarios_id_seq OWNER TO globalmet;

--
-- Name: campos_campo_usuarios_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_campo_usuarios_id_seq OWNED BY campos_campo_usuarios.id;


--
-- Name: campos_categoriacultivo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_categoriacultivo (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL
);


ALTER TABLE public.campos_categoriacultivo OWNER TO globalmet;

--
-- Name: campos_categoriacultivo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_categoriacultivo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_categoriacultivo_id_seq OWNER TO globalmet;

--
-- Name: campos_categoriacultivo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_categoriacultivo_id_seq OWNED BY campos_categoriacultivo.id;


--
-- Name: campos_cultivo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE campos_cultivo (
    id integer NOT NULL,
    nombre character varying(100) NOT NULL,
    categoria_id integer NOT NULL
);


ALTER TABLE public.campos_cultivo OWNER TO globalmet;

--
-- Name: campos_cultivo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE campos_cultivo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campos_cultivo_id_seq OWNER TO globalmet;

--
-- Name: campos_cultivo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE campos_cultivo_id_seq OWNED BY campos_cultivo.id;


--
-- Name: celery_taskmeta; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE celery_taskmeta (
    id integer NOT NULL,
    task_id character varying(255) NOT NULL,
    status character varying(50) NOT NULL,
    result text,
    date_done timestamp with time zone NOT NULL,
    traceback text,
    hidden boolean NOT NULL,
    meta text
);


ALTER TABLE public.celery_taskmeta OWNER TO globalmet;

--
-- Name: celery_taskmeta_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE celery_taskmeta_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.celery_taskmeta_id_seq OWNER TO globalmet;

--
-- Name: celery_taskmeta_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE celery_taskmeta_id_seq OWNED BY celery_taskmeta.id;


--
-- Name: celery_tasksetmeta; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE celery_tasksetmeta (
    id integer NOT NULL,
    taskset_id character varying(255) NOT NULL,
    result text NOT NULL,
    date_done timestamp with time zone NOT NULL,
    hidden boolean NOT NULL
);


ALTER TABLE public.celery_tasksetmeta OWNER TO globalmet;

--
-- Name: celery_tasksetmeta_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE celery_tasksetmeta_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.celery_tasksetmeta_id_seq OWNER TO globalmet;

--
-- Name: celery_tasksetmeta_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE celery_tasksetmeta_id_seq OWNED BY celery_tasksetmeta.id;


--
-- Name: clientes_comentario; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE clientes_comentario (
    id integer NOT NULL,
    comentario text NOT NULL,
    editado timestamp with time zone NOT NULL,
    prospecto_id integer NOT NULL
);


ALTER TABLE public.clientes_comentario OWNER TO globalmet;

--
-- Name: clientes_comentario_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE clientes_comentario_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clientes_comentario_id_seq OWNER TO globalmet;

--
-- Name: clientes_comentario_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE clientes_comentario_id_seq OWNED BY clientes_comentario.id;


--
-- Name: clientes_historialprospeccion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE clientes_historialprospeccion (
    id integer NOT NULL,
    comentario text NOT NULL,
    fecha timestamp with time zone NOT NULL,
    prospecto_id integer NOT NULL,
    estado character varying(50) NOT NULL
);


ALTER TABLE public.clientes_historialprospeccion OWNER TO globalmet;

--
-- Name: clientes_historialprospeccion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE clientes_historialprospeccion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clientes_historialprospeccion_id_seq OWNER TO globalmet;

--
-- Name: clientes_historialprospeccion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE clientes_historialprospeccion_id_seq OWNED BY clientes_historialprospeccion.id;


--
-- Name: clientes_prospecto; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE clientes_prospecto (
    id integer NOT NULL,
    nombre character varying(200) NOT NULL,
    apellidos character varying(200) NOT NULL,
    empresa character varying(200) NOT NULL,
    razon_social character varying(200) NOT NULL,
    rfc character varying(200) NOT NULL,
    giro character varying(50) NOT NULL,
    direccion character varying(200) NOT NULL,
    telefono_fijo character varying(200) NOT NULL,
    telefono_celular character varying(200) NOT NULL,
    ciudad character varying(200) NOT NULL,
    estado character varying(200) NOT NULL,
    contactado boolean NOT NULL,
    contratado boolean NOT NULL,
    fecha_contacto timestamp with time zone NOT NULL,
    email character varying(300) NOT NULL,
    web boolean NOT NULL,
    origen character varying(200),
    telefono_celular_2 character varying(200)
);


ALTER TABLE public.clientes_prospecto OWNER TO globalmet;

--
-- Name: clientes_prospecto_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE clientes_prospecto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clientes_prospecto_id_seq OWNER TO globalmet;

--
-- Name: clientes_prospecto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE clientes_prospecto_id_seq OWNED BY clientes_prospecto.id;


--
-- Name: dispositivos_dispositivo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE dispositivos_dispositivo (
    id integer NOT NULL,
    device_id character varying(200) NOT NULL,
    tipo character varying(20) NOT NULL,
    user_id integer DEFAULT 1 NOT NULL,
    modified timestamp with time zone NOT NULL,
    registration_id text,
    endpoint_arn text
);


ALTER TABLE public.dispositivos_dispositivo OWNER TO globalmet;

--
-- Name: dispositivos_dispositivo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE dispositivos_dispositivo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dispositivos_dispositivo_id_seq OWNER TO globalmet;

--
-- Name: dispositivos_dispositivo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE dispositivos_dispositivo_id_seq OWNED BY dispositivos_dispositivo.id;


--
-- Name: dispositivos_versionandroid; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE dispositivos_versionandroid (
    id integer NOT NULL,
    version integer NOT NULL,
    descripcion text NOT NULL,
    created timestamp with time zone NOT NULL,
    modified timestamp with time zone NOT NULL,
    CONSTRAINT dispositivos_versionandroid_version_check CHECK ((version >= 0))
);


ALTER TABLE public.dispositivos_versionandroid OWNER TO globalmet;

--
-- Name: dispositivos_versionandroid_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE dispositivos_versionandroid_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dispositivos_versionandroid_id_seq OWNER TO globalmet;

--
-- Name: dispositivos_versionandroid_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE dispositivos_versionandroid_id_seq OWNED BY dispositivos_versionandroid.id;


--
-- Name: divemex_latestsecretcode; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE divemex_latestsecretcode (
    id integer NOT NULL,
    codigo text NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.divemex_latestsecretcode OWNER TO globalmet;

--
-- Name: divemex_latestsecretcode_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE divemex_latestsecretcode_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.divemex_latestsecretcode_id_seq OWNER TO globalmet;

--
-- Name: divemex_latestsecretcode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE divemex_latestsecretcode_id_seq OWNED BY divemex_latestsecretcode.id;


--
-- Name: divemex_unidadesfotoperm; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE divemex_unidadesfotoperm (
    id integer NOT NULL,
    created timestamp with time zone NOT NULL,
    modified timestamp with time zone NOT NULL
);


ALTER TABLE public.divemex_unidadesfotoperm OWNER TO globalmet;

--
-- Name: divemex_unidadesfotoperm_campos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE divemex_unidadesfotoperm_campos (
    id integer NOT NULL,
    unidadesfotoperm_id integer NOT NULL,
    campo_id integer NOT NULL
);


ALTER TABLE public.divemex_unidadesfotoperm_campos OWNER TO globalmet;

--
-- Name: divemex_unidadesfotoperm_campos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE divemex_unidadesfotoperm_campos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.divemex_unidadesfotoperm_campos_id_seq OWNER TO globalmet;

--
-- Name: divemex_unidadesfotoperm_campos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE divemex_unidadesfotoperm_campos_id_seq OWNED BY divemex_unidadesfotoperm_campos.id;


--
-- Name: divemex_unidadesfotoperm_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE divemex_unidadesfotoperm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.divemex_unidadesfotoperm_id_seq OWNER TO globalmet;

--
-- Name: divemex_unidadesfotoperm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE divemex_unidadesfotoperm_id_seq OWNED BY divemex_unidadesfotoperm.id;


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    content_type_id integer,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO globalmet;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_admin_log_id_seq OWNER TO globalmet;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO globalmet;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_content_type_id_seq OWNER TO globalmet;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO globalmet;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_migrations_id_seq OWNER TO globalmet;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO globalmet;

--
-- Name: django_site; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE django_site (
    id integer NOT NULL,
    domain character varying(100) NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.django_site OWNER TO globalmet;

--
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE django_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_site_id_seq OWNER TO globalmet;

--
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE django_site_id_seq OWNED BY django_site.id;


--
-- Name: djcelery_crontabschedule; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_crontabschedule (
    id integer NOT NULL,
    minute character varying(64) NOT NULL,
    hour character varying(64) NOT NULL,
    day_of_week character varying(64) NOT NULL,
    day_of_month character varying(64) NOT NULL,
    month_of_year character varying(64) NOT NULL
);


ALTER TABLE public.djcelery_crontabschedule OWNER TO globalmet;

--
-- Name: djcelery_crontabschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE djcelery_crontabschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.djcelery_crontabschedule_id_seq OWNER TO globalmet;

--
-- Name: djcelery_crontabschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE djcelery_crontabschedule_id_seq OWNED BY djcelery_crontabschedule.id;


--
-- Name: djcelery_intervalschedule; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_intervalschedule (
    id integer NOT NULL,
    every integer NOT NULL,
    period character varying(24) NOT NULL
);


ALTER TABLE public.djcelery_intervalschedule OWNER TO globalmet;

--
-- Name: djcelery_intervalschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE djcelery_intervalschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.djcelery_intervalschedule_id_seq OWNER TO globalmet;

--
-- Name: djcelery_intervalschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE djcelery_intervalschedule_id_seq OWNED BY djcelery_intervalschedule.id;


--
-- Name: djcelery_periodictask; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_periodictask (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    task character varying(200) NOT NULL,
    interval_id integer,
    crontab_id integer,
    args text NOT NULL,
    kwargs text NOT NULL,
    queue character varying(200),
    exchange character varying(200),
    routing_key character varying(200),
    expires timestamp with time zone,
    enabled boolean NOT NULL,
    last_run_at timestamp with time zone,
    total_run_count integer NOT NULL,
    date_changed timestamp with time zone NOT NULL,
    description text NOT NULL,
    CONSTRAINT djcelery_periodictask_total_run_count_check CHECK ((total_run_count >= 0))
);


ALTER TABLE public.djcelery_periodictask OWNER TO globalmet;

--
-- Name: djcelery_periodictask_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE djcelery_periodictask_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.djcelery_periodictask_id_seq OWNER TO globalmet;

--
-- Name: djcelery_periodictask_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE djcelery_periodictask_id_seq OWNED BY djcelery_periodictask.id;


--
-- Name: djcelery_periodictasks; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_periodictasks (
    ident smallint NOT NULL,
    last_update timestamp with time zone NOT NULL
);


ALTER TABLE public.djcelery_periodictasks OWNER TO globalmet;

--
-- Name: djcelery_taskstate; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_taskstate (
    id integer NOT NULL,
    state character varying(64) NOT NULL,
    task_id character varying(36) NOT NULL,
    name character varying(200),
    tstamp timestamp with time zone NOT NULL,
    args text,
    kwargs text,
    eta timestamp with time zone,
    expires timestamp with time zone,
    result text,
    traceback text,
    runtime double precision,
    retries integer NOT NULL,
    worker_id integer,
    hidden boolean NOT NULL
);


ALTER TABLE public.djcelery_taskstate OWNER TO globalmet;

--
-- Name: djcelery_taskstate_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE djcelery_taskstate_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.djcelery_taskstate_id_seq OWNER TO globalmet;

--
-- Name: djcelery_taskstate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE djcelery_taskstate_id_seq OWNED BY djcelery_taskstate.id;


--
-- Name: djcelery_workerstate; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE djcelery_workerstate (
    id integer NOT NULL,
    hostname character varying(255) NOT NULL,
    last_heartbeat timestamp with time zone
);


ALTER TABLE public.djcelery_workerstate OWNER TO globalmet;

--
-- Name: djcelery_workerstate_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE djcelery_workerstate_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.djcelery_workerstate_id_seq OWNER TO globalmet;

--
-- Name: djcelery_workerstate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE djcelery_workerstate_id_seq OWNED BY djcelery_workerstate.id;


--
-- Name: easy_thumbnails_source; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE easy_thumbnails_source (
    id integer NOT NULL,
    storage_hash character varying(40) NOT NULL,
    name character varying(255) NOT NULL,
    modified timestamp with time zone NOT NULL
);


ALTER TABLE public.easy_thumbnails_source OWNER TO globalmet;

--
-- Name: easy_thumbnails_source_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE easy_thumbnails_source_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.easy_thumbnails_source_id_seq OWNER TO globalmet;

--
-- Name: easy_thumbnails_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE easy_thumbnails_source_id_seq OWNED BY easy_thumbnails_source.id;


--
-- Name: easy_thumbnails_thumbnail; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE easy_thumbnails_thumbnail (
    id integer NOT NULL,
    storage_hash character varying(40) NOT NULL,
    name character varying(255) NOT NULL,
    modified timestamp with time zone NOT NULL,
    source_id integer NOT NULL
);


ALTER TABLE public.easy_thumbnails_thumbnail OWNER TO globalmet;

--
-- Name: easy_thumbnails_thumbnail_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE easy_thumbnails_thumbnail_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.easy_thumbnails_thumbnail_id_seq OWNER TO globalmet;

--
-- Name: easy_thumbnails_thumbnail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE easy_thumbnails_thumbnail_id_seq OWNED BY easy_thumbnails_thumbnail.id;


--
-- Name: empresas_anotacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_anotacion (
    id integer NOT NULL,
    empresa_id integer NOT NULL,
    anotacion text NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.empresas_anotacion OWNER TO globalmet;

--
-- Name: empresas_anotacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_anotacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_anotacion_id_seq OWNER TO globalmet;

--
-- Name: empresas_anotacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_anotacion_id_seq OWNED BY empresas_anotacion.id;


--
-- Name: empresas_categoriaempresa; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_categoriaempresa (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL
);


ALTER TABLE public.empresas_categoriaempresa OWNER TO globalmet;

--
-- Name: empresas_categoriaempresa_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_categoriaempresa_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_categoriaempresa_id_seq OWNER TO globalmet;

--
-- Name: empresas_categoriaempresa_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_categoriaempresa_id_seq OWNED BY empresas_categoriaempresa.id;


--
-- Name: empresas_correocontacto; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_correocontacto (
    id integer NOT NULL,
    empresa_id integer NOT NULL,
    email character varying(256) NOT NULL,
    nombre character varying(256) NOT NULL,
    modified timestamp with time zone NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.empresas_correocontacto OWNER TO globalmet;

--
-- Name: empresas_correocontacto_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_correocontacto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_correocontacto_id_seq OWNER TO globalmet;

--
-- Name: empresas_correocontacto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_correocontacto_id_seq OWNED BY empresas_correocontacto.id;


--
-- Name: empresas_datocontacto; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_datocontacto (
    id integer NOT NULL,
    empresa_id integer NOT NULL,
    nombre character varying(256) NOT NULL,
    telefono character varying(30) NOT NULL,
    telefono2 character varying(30),
    ciudad character varying(100) NOT NULL,
    notas text,
    modified timestamp with time zone NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.empresas_datocontacto OWNER TO globalmet;

--
-- Name: empresas_datocontacto_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_datocontacto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_datocontacto_id_seq OWNER TO globalmet;

--
-- Name: empresas_datocontacto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_datocontacto_id_seq OWNED BY empresas_datocontacto.id;


--
-- Name: empresas_datosfacturacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_datosfacturacion (
    id integer NOT NULL,
    razon_social character varying(200) NOT NULL,
    rfc character varying(20) NOT NULL,
    direccion character varying(200) NOT NULL,
    ciudad character varying(100) NOT NULL,
    estado character varying(100) NOT NULL,
    codigo_postal character varying(10) NOT NULL,
    telefono character varying(30) NOT NULL,
    email character varying(256) NOT NULL,
    content_type_id integer NOT NULL,
    object_id integer NOT NULL,
    modified timestamp with time zone NOT NULL,
    CONSTRAINT empresas_datosfacturacion_object_id_check CHECK ((object_id >= 0))
);


ALTER TABLE public.empresas_datosfacturacion OWNER TO globalmet;

--
-- Name: empresas_datosfacturacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_datosfacturacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_datosfacturacion_id_seq OWNER TO globalmet;

--
-- Name: empresas_datosfacturacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_datosfacturacion_id_seq OWNED BY empresas_datosfacturacion.id;


--
-- Name: empresas_empresa; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE empresas_empresa (
    id integer NOT NULL,
    nombre character varying(100) NOT NULL,
    categoria_id integer NOT NULL,
    cliente_id integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.empresas_empresa OWNER TO globalmet;

--
-- Name: empresas_empresa_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE empresas_empresa_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.empresas_empresa_id_seq OWNER TO globalmet;

--
-- Name: empresas_empresa_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE empresas_empresa_id_seq OWNED BY empresas_empresa.id;


--
-- Name: encuestas_encuestasatisfaccionrecomendacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE encuestas_encuestasatisfaccionrecomendacion (
    id integer NOT NULL,
    calificacion integer NOT NULL,
    editado timestamp with time zone NOT NULL,
    usuario_id integer NOT NULL
);


ALTER TABLE public.encuestas_encuestasatisfaccionrecomendacion OWNER TO globalmet;

--
-- Name: encuestas_encuestasatisfaccionrecomendacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE encuestas_encuestasatisfaccionrecomendacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.encuestas_encuestasatisfaccionrecomendacion_id_seq OWNER TO globalmet;

--
-- Name: encuestas_encuestasatisfaccionrecomendacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE encuestas_encuestasatisfaccionrecomendacion_id_seq OWNED BY encuestas_encuestasatisfaccionrecomendacion.id;


--
-- Name: encuestas_encuestasatisfacciontoken; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE encuestas_encuestasatisfacciontoken (
    id integer NOT NULL,
    token character varying(200) NOT NULL,
    usuario_id integer NOT NULL
);


ALTER TABLE public.encuestas_encuestasatisfacciontoken OWNER TO globalmet;

--
-- Name: encuestas_encuestasatisfacciontoken_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE encuestas_encuestasatisfacciontoken_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.encuestas_encuestasatisfacciontoken_id_seq OWNER TO globalmet;

--
-- Name: encuestas_encuestasatisfacciontoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE encuestas_encuestasatisfacciontoken_id_seq OWNED BY encuestas_encuestasatisfacciontoken.id;


--
-- Name: estaciones_estacion; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE estaciones_estacion (
    id integer NOT NULL,
    nombre character varying(200) NOT NULL,
    descripcion text,
    estacion_id character varying(200) NOT NULL,
    campo_id integer NOT NULL,
    principal boolean NOT NULL,
    origen integer NOT NULL,
    portal_url character varying(200) NOT NULL,
    nombre_corto character varying(100),
    tipo integer NOT NULL,
    prof_sensor_1 character varying(40),
    prof_sensor_2 character varying(40),
    prof_sensor_3 character varying(40)
);


ALTER TABLE public.estaciones_estacion OWNER TO globalmet;

--
-- Name: estaciones_estacion_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE estaciones_estacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.estaciones_estacion_id_seq OWNER TO globalmet;

--
-- Name: estaciones_estacion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE estaciones_estacion_id_seq OWNED BY estaciones_estacion.id;


--
-- Name: guardian_groupobjectpermission; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE guardian_groupobjectpermission (
    id integer NOT NULL,
    permission_id integer NOT NULL,
    content_type_id integer NOT NULL,
    object_pk character varying(255) NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.guardian_groupobjectpermission OWNER TO globalmet;

--
-- Name: guardian_groupobjectpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE guardian_groupobjectpermission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.guardian_groupobjectpermission_id_seq OWNER TO globalmet;

--
-- Name: guardian_groupobjectpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE guardian_groupobjectpermission_id_seq OWNED BY guardian_groupobjectpermission.id;


--
-- Name: guardian_userobjectpermission; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE guardian_userobjectpermission (
    id integer NOT NULL,
    permission_id integer NOT NULL,
    content_type_id integer NOT NULL,
    object_pk character varying(255) NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.guardian_userobjectpermission OWNER TO globalmet;

--
-- Name: guardian_userobjectpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE guardian_userobjectpermission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.guardian_userobjectpermission_id_seq OWNER TO globalmet;

--
-- Name: guardian_userobjectpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE guardian_userobjectpermission_id_seq OWNED BY guardian_userobjectpermission.id;


--
-- Name: historiales_historialmeteorologocampo; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE historiales_historialmeteorologocampo (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    meteorologo_id integer NOT NULL,
    fecha_inicio timestamp with time zone NOT NULL
);


ALTER TABLE public.historiales_historialmeteorologocampo OWNER TO globalmet;

--
-- Name: historiales_historialmeteorologocampo_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE historiales_historialmeteorologocampo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.historiales_historialmeteorologocampo_id_seq OWNER TO globalmet;

--
-- Name: historiales_historialmeteorologocampo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE historiales_historialmeteorologocampo_id_seq OWNED BY historiales_historialmeteorologocampo.id;


--
-- Name: image_uploads_imageupload; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE image_uploads_imageupload (
    id integer NOT NULL,
    descripcion character varying(100) NOT NULL,
    imagen character varying(100) NOT NULL,
    modified timestamp with time zone NOT NULL
);


ALTER TABLE public.image_uploads_imageupload OWNER TO globalmet;

--
-- Name: image_uploads_imageupload_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE image_uploads_imageupload_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.image_uploads_imageupload_id_seq OWNER TO globalmet;

--
-- Name: image_uploads_imageupload_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE image_uploads_imageupload_id_seq OWNED BY image_uploads_imageupload.id;


--
-- Name: instancias_campoencola; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE instancias_campoencola (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    procesado boolean NOT NULL,
    estado integer NOT NULL
);


ALTER TABLE public.instancias_campoencola OWNER TO globalmet;

--
-- Name: instancias_campoencola_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE instancias_campoencola_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.instancias_campoencola_id_seq OWNER TO globalmet;

--
-- Name: instancias_campoencola_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE instancias_campoencola_id_seq OWNED BY instancias_campoencola.id;


--
-- Name: instancias_colacampos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE instancias_colacampos (
    id integer NOT NULL,
    fecha_creada timestamp with time zone NOT NULL
);


ALTER TABLE public.instancias_colacampos OWNER TO globalmet;

--
-- Name: instancias_colacampos_campos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE instancias_colacampos_campos (
    id integer NOT NULL,
    colacampos_id integer NOT NULL,
    campoencola_id integer NOT NULL
);


ALTER TABLE public.instancias_colacampos_campos OWNER TO globalmet;

--
-- Name: instancias_colacampos_campos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE instancias_colacampos_campos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.instancias_colacampos_campos_id_seq OWNER TO globalmet;

--
-- Name: instancias_colacampos_campos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE instancias_colacampos_campos_id_seq OWNED BY instancias_colacampos_campos.id;


--
-- Name: instancias_colacampos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE instancias_colacampos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.instancias_colacampos_id_seq OWNER TO globalmet;

--
-- Name: instancias_colacampos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE instancias_colacampos_id_seq OWNED BY instancias_colacampos.id;


--
-- Name: pagos_pago; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pagos_pago (
    id integer NOT NULL,
    fecha timestamp with time zone,
    notas text,
    metodo_pago integer NOT NULL,
    procesado boolean NOT NULL,
    empresa_id integer NOT NULL,
    monto numeric(16,2) NOT NULL,
    created timestamp with time zone NOT NULL,
    ref_transaccion character varying(10)
);


ALTER TABLE public.pagos_pago OWNER TO globalmet;

--
-- Name: pagos_pago_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pagos_pago_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pagos_pago_id_seq OWNER TO globalmet;

--
-- Name: pagos_pago_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pagos_pago_id_seq OWNED BY pagos_pago.id;


--
-- Name: preferencias_preferenciasresumendiario; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE preferencias_preferenciasresumendiario (
    id integer NOT NULL,
    usuario_id integer NOT NULL,
    slot1 integer NOT NULL,
    slot2 integer NOT NULL,
    slot3 integer NOT NULL,
    slot4 integer NOT NULL
);


ALTER TABLE public.preferencias_preferenciasresumendiario OWNER TO globalmet;

--
-- Name: preferencias_preferenciasresumendiario_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE preferencias_preferenciasresumendiario_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.preferencias_preferenciasresumendiario_id_seq OWNER TO globalmet;

--
-- Name: preferencias_preferenciasresumendiario_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE preferencias_preferenciasresumendiario_id_seq OWNED BY preferencias_preferenciasresumendiario.id;


--
-- Name: preferencias_preferenciasunidades; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE preferencias_preferenciasunidades (
    id integer NOT NULL,
    temperatura integer NOT NULL,
    velocidad integer NOT NULL,
    precipitacion integer NOT NULL,
    user_id integer NOT NULL,
    CONSTRAINT preferencias_preferenciasunidades_precipitacion_check CHECK ((precipitacion >= 0)),
    CONSTRAINT preferencias_preferenciasunidades_temperatura_check CHECK ((temperatura >= 0)),
    CONSTRAINT preferencias_preferenciasunidades_velocidad_check CHECK ((velocidad >= 0))
);


ALTER TABLE public.preferencias_preferenciasunidades OWNER TO globalmet;

--
-- Name: preferencias_preferenciasunidades_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE preferencias_preferenciasunidades_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.preferencias_preferenciasunidades_id_seq OWNER TO globalmet;

--
-- Name: preferencias_preferenciasunidades_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE preferencias_preferenciasunidades_id_seq OWNED BY preferencias_preferenciasunidades.id;


--
-- Name: pronosticos_capturahorasfrio; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_capturahorasfrio (
    id integer NOT NULL,
    fecha_captura timestamp with time zone NOT NULL,
    horas_frio numeric(16,4) NOT NULL,
    registro_id integer NOT NULL
);


ALTER TABLE public.pronosticos_capturahorasfrio OWNER TO globalmet;

--
-- Name: pronosticos_capturahorasfrio_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_capturahorasfrio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_capturahorasfrio_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_capturahorasfrio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_capturahorasfrio_id_seq OWNED BY pronosticos_capturahorasfrio.id;


--
-- Name: pronosticos_climatologia; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_climatologia (
    id integer NOT NULL,
    estacion character varying(200) NOT NULL,
    variables character varying(200) NOT NULL,
    datos character varying(200) NOT NULL,
    temporada character varying(200) NOT NULL,
    fecha_inicio date NOT NULL,
    fecha_final date NOT NULL,
    latitude double precision NOT NULL,
    longitude double precision NOT NULL
);


ALTER TABLE public.pronosticos_climatologia OWNER TO globalmet;

--
-- Name: pronosticos_climatologia_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_climatologia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_climatologia_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_climatologia_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_climatologia_id_seq OWNED BY pronosticos_climatologia.id;


--
-- Name: pronosticos_climatologiadia; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_climatologiadia (
    id integer NOT NULL,
    fecha date NOT NULL,
    tmin double precision NOT NULL,
    tmax double precision NOT NULL,
    climatologia_id integer NOT NULL
);


ALTER TABLE public.pronosticos_climatologiadia OWNER TO globalmet;

--
-- Name: pronosticos_climatologiadia_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_climatologiadia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_climatologiadia_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_climatologiadia_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_climatologiadia_id_seq OWNED BY pronosticos_climatologiadia.id;


--
-- Name: pronosticos_discusiondiaria; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_discusiondiaria (
    id integer NOT NULL,
    discusion_id integer NOT NULL,
    icono_clima integer NOT NULL,
    fecha date NOT NULL,
    comentarios text NOT NULL,
    prob_helada integer,
    comentarios_template text NOT NULL
);


ALTER TABLE public.pronosticos_discusiondiaria OWNER TO globalmet;

--
-- Name: pronosticos_discusiondiaria_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_discusiondiaria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_discusiondiaria_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_discusiondiaria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_discusiondiaria_id_seq OWNED BY pronosticos_discusiondiaria.id;


--
-- Name: pronosticos_discusiongrafica; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_discusiongrafica (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    tipo_variable character varying(20) NOT NULL,
    plazo integer NOT NULL,
    editado timestamp with time zone NOT NULL,
    comentarios text NOT NULL,
    vigencia timestamp with time zone NOT NULL
);


ALTER TABLE public.pronosticos_discusiongrafica OWNER TO globalmet;

--
-- Name: pronosticos_discusiongrafica_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_discusiongrafica_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_discusiongrafica_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_discusiongrafica_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_discusiongrafica_id_seq OWNED BY pronosticos_discusiongrafica.id;


--
-- Name: pronosticos_discusionmeteorologica; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_discusionmeteorologica (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    comentarios text NOT NULL,
    editado timestamp with time zone NOT NULL,
    vigencia date NOT NULL,
    activo boolean NOT NULL,
    enviado boolean NOT NULL,
    adjuntar_resumen boolean NOT NULL,
    incluir_encuesta boolean NOT NULL,
    comentarios_template text NOT NULL
);


ALTER TABLE public.pronosticos_discusionmeteorologica OWNER TO globalmet;

--
-- Name: pronosticos_discusionmeteorologica_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_discusionmeteorologica_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_discusionmeteorologica_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_discusionmeteorologica_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_discusionmeteorologica_id_seq OWNED BY pronosticos_discusionmeteorologica.id;


--
-- Name: pronosticos_pronostico; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_pronostico (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    fecha_calculo timestamp with time zone NOT NULL,
    fecha_pronostico timestamp with time zone NOT NULL,
    modelo_pronostico integer NOT NULL,
    "PRMSL" numeric(16,4),
    "VIS" numeric(16,4),
    "PRES" numeric(16,4),
    "TMP" numeric(16,4),
    "RH" numeric(16,4),
    "DPT" numeric(16,4),
    "UGRD" numeric(16,4),
    "VGRD" numeric(16,4),
    "APCP" numeric(16,4),
    "ACPCP" numeric(16,4),
    "CSNOW" numeric(16,4),
    "CAPE" numeric(16,4),
    "CIN" numeric(16,4),
    "PWAT" numeric(16,4),
    "HGT" numeric(16,4),
    "TMP850" numeric(16,4),
    "RH700" numeric(16,4),
    "NCPCP" numeric(16,4),
    "LCDC" numeric(16,4),
    "MCDC" numeric(16,4),
    "HCDC" numeric(16,4),
    "TCDC" numeric(16,4),
    "GUST" numeric(16,4),
    "LTNG" numeric(16,4),
    "WIND" numeric(16,9),
    "WINDDIR" numeric(16,9),
    meteorologo_id integer NOT NULL,
    "DSWRF" numeric(16,4),
    "DLWRF" numeric(16,4),
    "TSOIL1" numeric(16,4),
    "TSOIL2" numeric(16,4),
    "TSOIL3" numeric(16,4),
    "TSOIL4" numeric(16,4),
    "TSOIL5" numeric(16,4)
);


ALTER TABLE public.pronosticos_pronostico OWNER TO globalmet;

--
-- Name: pronosticos_pronostico_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_pronostico_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_pronostico_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_pronostico_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_pronostico_id_seq OWNED BY pronosticos_pronostico.id;


--
-- Name: pronosticos_pronosticobase; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_pronosticobase (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    fecha_calculo timestamp with time zone NOT NULL,
    fecha_pronostico date NOT NULL,
    variable_meteorologica_id integer NOT NULL,
    maximo numeric(16,1) NOT NULL,
    minimo numeric(16,1) NOT NULL,
    meteorologo_id integer NOT NULL
);


ALTER TABLE public.pronosticos_pronosticobase OWNER TO globalmet;

--
-- Name: pronosticos_pronosticobase_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_pronosticobase_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_pronosticobase_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_pronosticobase_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_pronosticobase_id_seq OWNED BY pronosticos_pronosticobase.id;


--
-- Name: pronosticos_pronosticoclimatologico; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_pronosticoclimatologico (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    fecha_calculo timestamp with time zone NOT NULL,
    fecha_pronostico timestamp with time zone NOT NULL,
    modelo_pronostico integer NOT NULL,
    "TMP_CLI_MEAN" numeric(8,4),
    "TMP_CLI_NORMAL" numeric(8,4),
    meteorologo_id integer NOT NULL
);


ALTER TABLE public.pronosticos_pronosticoclimatologico OWNER TO globalmet;

--
-- Name: pronosticos_pronosticoclimatologico_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_pronosticoclimatologico_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_pronosticoclimatologico_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_pronosticoclimatologico_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_pronosticoclimatologico_id_seq OWNED BY pronosticos_pronosticoclimatologico.id;


--
-- Name: pronosticos_pronosticodia; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_pronosticodia (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    fecha_calculo timestamp with time zone NOT NULL,
    fecha_pronostico date NOT NULL,
    meteorologo_id integer NOT NULL,
    icono_clima integer NOT NULL,
    descripcion character varying(50) NOT NULL,
    prob_lluvia integer
);


ALTER TABLE public.pronosticos_pronosticodia OWNER TO globalmet;

--
-- Name: pronosticos_pronosticodia_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_pronosticodia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_pronosticodia_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_pronosticodia_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_pronosticodia_id_seq OWNED BY pronosticos_pronosticodia.id;


--
-- Name: pronosticos_pronosticodiariolluvia; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_pronosticodiariolluvia (
    id integer NOT NULL,
    campo_id integer NOT NULL,
    fecha_calculo timestamp with time zone NOT NULL,
    fecha_pronostico date NOT NULL,
    meteorologo_id integer NOT NULL,
    "DAILY_RAIN" numeric(16,4),
    posibilidad integer NOT NULL,
    hora_probable time without time zone,
    daily_rain_char character varying(16)
);


ALTER TABLE public.pronosticos_pronosticodiariolluvia OWNER TO globalmet;

--
-- Name: pronosticos_pronosticodiariolluvia_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_pronosticodiariolluvia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_pronosticodiariolluvia_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_pronosticodiariolluvia_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_pronosticodiariolluvia_id_seq OWNED BY pronosticos_pronosticodiariolluvia.id;


--
-- Name: pronosticos_registrohorasfrio; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_registrohorasfrio (
    id integer NOT NULL,
    fecha_inicio timestamp with time zone NOT NULL,
    comentarios text,
    campo_id integer NOT NULL
);


ALTER TABLE public.pronosticos_registrohorasfrio OWNER TO globalmet;

--
-- Name: pronosticos_registrohorasfrio_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_registrohorasfrio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_registrohorasfrio_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_registrohorasfrio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_registrohorasfrio_id_seq OWNED BY pronosticos_registrohorasfrio.id;


--
-- Name: pronosticos_tip; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_tip (
    id integer NOT NULL,
    titulo character varying(200) NOT NULL,
    descripcion text NOT NULL,
    modified timestamp with time zone NOT NULL
);


ALTER TABLE public.pronosticos_tip OWNER TO globalmet;

--
-- Name: pronosticos_tip_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_tip_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_tip_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_tip_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_tip_id_seq OWNED BY pronosticos_tip.id;


--
-- Name: pronosticos_variablemeteorologica; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE pronosticos_variablemeteorologica (
    id integer NOT NULL,
    nombre character varying(200) NOT NULL,
    tipo_variable character varying(20) NOT NULL,
    unidad character varying(50) DEFAULT ' '::character varying NOT NULL,
    unidad_safe character varying(50) DEFAULT ' '::character varying NOT NULL
);


ALTER TABLE public.pronosticos_variablemeteorologica OWNER TO globalmet;

--
-- Name: pronosticos_variablemeteorologica_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE pronosticos_variablemeteorologica_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pronosticos_variablemeteorologica_id_seq OWNER TO globalmet;

--
-- Name: pronosticos_variablemeteorologica_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE pronosticos_variablemeteorologica_id_seq OWNED BY pronosticos_variablemeteorologica.id;


--
-- Name: push_notifications_apnsdevice; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE push_notifications_apnsdevice (
    id integer NOT NULL,
    name character varying(255),
    active boolean NOT NULL,
    user_id integer,
    device_id uuid,
    registration_id character varying(64) NOT NULL,
    date_created timestamp with time zone
);


ALTER TABLE public.push_notifications_apnsdevice OWNER TO globalmet;

--
-- Name: push_notifications_apnsdevice_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE push_notifications_apnsdevice_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.push_notifications_apnsdevice_id_seq OWNER TO globalmet;

--
-- Name: push_notifications_apnsdevice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE push_notifications_apnsdevice_id_seq OWNED BY push_notifications_apnsdevice.id;


--
-- Name: push_notifications_gcmdevice; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE push_notifications_gcmdevice (
    id integer NOT NULL,
    name character varying(255),
    active boolean NOT NULL,
    user_id integer,
    device_id bigint,
    registration_id text NOT NULL,
    date_created timestamp with time zone
);


ALTER TABLE public.push_notifications_gcmdevice OWNER TO globalmet;

--
-- Name: push_notifications_gcmdevice_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE push_notifications_gcmdevice_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.push_notifications_gcmdevice_id_seq OWNER TO globalmet;

--
-- Name: push_notifications_gcmdevice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE push_notifications_gcmdevice_id_seq OWNED BY push_notifications_gcmdevice.id;


--
-- Name: south_migrationhistory; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE south_migrationhistory (
    id integer NOT NULL,
    app_name character varying(255) NOT NULL,
    migration character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.south_migrationhistory OWNER TO globalmet;

--
-- Name: south_migrationhistory_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE south_migrationhistory_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.south_migrationhistory_id_seq OWNER TO globalmet;

--
-- Name: south_migrationhistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE south_migrationhistory_id_seq OWNED BY south_migrationhistory.id;


--
-- Name: suscripciones_acuserecibofactura; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_acuserecibofactura (
    id integer NOT NULL,
    factura_id integer NOT NULL,
    recibida boolean NOT NULL,
    created timestamp with time zone NOT NULL
);


ALTER TABLE public.suscripciones_acuserecibofactura OWNER TO globalmet;

--
-- Name: suscripciones_acuserecibofactura_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_acuserecibofactura_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_acuserecibofactura_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_acuserecibofactura_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_acuserecibofactura_id_seq OWNED BY suscripciones_acuserecibofactura.id;


--
-- Name: suscripciones_contrato; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_contrato (
    id integer NOT NULL,
    tipo_contrato_id integer NOT NULL,
    meses integer NOT NULL,
    fecha_contratacion date NOT NULL,
    pago_mensual numeric(16,2) NOT NULL,
    activo boolean NOT NULL,
    empresa_id integer NOT NULL,
    fecha_expiracion date
);


ALTER TABLE public.suscripciones_contrato OWNER TO globalmet;

--
-- Name: suscripciones_contrato_campos; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_contrato_campos (
    id integer NOT NULL,
    contrato_id integer NOT NULL,
    campo_id integer NOT NULL
);


ALTER TABLE public.suscripciones_contrato_campos OWNER TO globalmet;

--
-- Name: suscripciones_contrato_campos_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_contrato_campos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_contrato_campos_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_contrato_campos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_contrato_campos_id_seq OWNED BY suscripciones_contrato_campos.id;


--
-- Name: suscripciones_contrato_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_contrato_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_contrato_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_contrato_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_contrato_id_seq OWNED BY suscripciones_contrato.id;


--
-- Name: suscripciones_factura; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_factura (
    id integer NOT NULL,
    pdf character varying(100) NOT NULL,
    xml character varying(100) NOT NULL,
    created timestamp with time zone NOT NULL,
    empresa_id integer,
    total numeric(11,2),
    uuid uuid NOT NULL
);


ALTER TABLE public.suscripciones_factura OWNER TO globalmet;

--
-- Name: suscripciones_factura_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_factura_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_factura_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_factura_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_factura_id_seq OWNED BY suscripciones_factura.id;


--
-- Name: suscripciones_referenciabancaria; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_referenciabancaria (
    id integer NOT NULL,
    numero character varying(256) NOT NULL,
    empresa_id integer NOT NULL,
    created timestamp with time zone NOT NULL,
    modified timestamp with time zone NOT NULL,
    banco integer NOT NULL
);


ALTER TABLE public.suscripciones_referenciabancaria OWNER TO globalmet;

--
-- Name: suscripciones_referenciabancaria_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_referenciabancaria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_referenciabancaria_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_referenciabancaria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_referenciabancaria_id_seq OWNED BY suscripciones_referenciabancaria.id;


--
-- Name: suscripciones_serviciomensual; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_serviciomensual (
    id integer NOT NULL,
    contrato_id integer NOT NULL,
    month integer NOT NULL,
    year integer NOT NULL,
    factura_id integer
);


ALTER TABLE public.suscripciones_serviciomensual OWNER TO globalmet;

--
-- Name: suscripciones_serviciomensual_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_serviciomensual_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_serviciomensual_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_serviciomensual_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_serviciomensual_id_seq OWNED BY suscripciones_serviciomensual.id;


--
-- Name: suscripciones_tipocontrato; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE suscripciones_tipocontrato (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    descripcion text,
    pago_mensual numeric(16,2) NOT NULL,
    minimo_meses integer NOT NULL
);


ALTER TABLE public.suscripciones_tipocontrato OWNER TO globalmet;

--
-- Name: suscripciones_tipocontrato_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE suscripciones_tipocontrato_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suscripciones_tipocontrato_id_seq OWNER TO globalmet;

--
-- Name: suscripciones_tipocontrato_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE suscripciones_tipocontrato_id_seq OWNED BY suscripciones_tipocontrato.id;


--
-- Name: ubicaciones_estado; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE ubicaciones_estado (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    pais_id integer NOT NULL,
    geofence geometry NOT NULL,
    CONSTRAINT enforce_dims_geofence CHECK ((st_ndims(geofence) = 2)),
    CONSTRAINT enforce_geotype_geofence CHECK (((geometrytype(geofence) = 'POLYGON'::text) OR (geofence IS NULL))),
    CONSTRAINT enforce_srid_geofence CHECK ((st_srid(geofence) = 4326))
);


ALTER TABLE public.ubicaciones_estado OWNER TO globalmet;

--
-- Name: ubicaciones_estado_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE ubicaciones_estado_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ubicaciones_estado_id_seq OWNER TO globalmet;

--
-- Name: ubicaciones_estado_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE ubicaciones_estado_id_seq OWNED BY ubicaciones_estado.id;


--
-- Name: ubicaciones_municipio; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE ubicaciones_municipio (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    estado_id integer NOT NULL,
    geofence geometry NOT NULL,
    CONSTRAINT enforce_dims_geofence CHECK ((st_ndims(geofence) = 2)),
    CONSTRAINT enforce_geotype_geofence CHECK (((geometrytype(geofence) = 'POLYGON'::text) OR (geofence IS NULL))),
    CONSTRAINT enforce_srid_geofence CHECK ((st_srid(geofence) = 4326))
);


ALTER TABLE public.ubicaciones_municipio OWNER TO globalmet;

--
-- Name: ubicaciones_municipio_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE ubicaciones_municipio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ubicaciones_municipio_id_seq OWNER TO globalmet;

--
-- Name: ubicaciones_municipio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE ubicaciones_municipio_id_seq OWNED BY ubicaciones_municipio.id;


--
-- Name: ubicaciones_pais; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE ubicaciones_pais (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    geofence geometry NOT NULL,
    CONSTRAINT enforce_dims_geofence CHECK ((st_ndims(geofence) = 2)),
    CONSTRAINT enforce_geotype_geofence CHECK (((geometrytype(geofence) = 'MULTIPOLYGON'::text) OR (geofence IS NULL))),
    CONSTRAINT enforce_srid_geofence CHECK ((st_srid(geofence) = 4326))
);


ALTER TABLE public.ubicaciones_pais OWNER TO globalmet;

--
-- Name: ubicaciones_pais_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE ubicaciones_pais_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ubicaciones_pais_id_seq OWNER TO globalmet;

--
-- Name: ubicaciones_pais_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE ubicaciones_pais_id_seq OWNED BY ubicaciones_pais.id;


--
-- Name: ubicaciones_region; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE ubicaciones_region (
    id integer NOT NULL,
    nombre character varying(50) NOT NULL,
    geofence geometry NOT NULL,
    CONSTRAINT enforce_dims_geofence CHECK ((st_ndims(geofence) = 2)),
    CONSTRAINT enforce_geotype_geofence CHECK (((geometrytype(geofence) = 'POLYGON'::text) OR (geofence IS NULL))),
    CONSTRAINT enforce_srid_geofence CHECK ((st_srid(geofence) = 4326))
);


ALTER TABLE public.ubicaciones_region OWNER TO globalmet;

--
-- Name: ubicaciones_region_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE ubicaciones_region_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ubicaciones_region_id_seq OWNER TO globalmet;

--
-- Name: ubicaciones_region_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE ubicaciones_region_id_seq OWNED BY ubicaciones_region.id;


--
-- Name: userena_userenasignup; Type: TABLE; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE TABLE userena_userenasignup (
    id integer NOT NULL,
    user_id integer NOT NULL,
    last_active timestamp with time zone,
    activation_key character varying(40) NOT NULL,
    activation_notification_send boolean NOT NULL,
    email_unconfirmed character varying(75) NOT NULL,
    email_confirmation_key character varying(40) NOT NULL,
    email_confirmation_key_created timestamp with time zone
);


ALTER TABLE public.userena_userenasignup OWNER TO globalmet;

--
-- Name: userena_userenasignup_id_seq; Type: SEQUENCE; Schema: public; Owner: globalmet
--

CREATE SEQUENCE userena_userenasignup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.userena_userenasignup_id_seq OWNER TO globalmet;

--
-- Name: userena_userenasignup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: globalmet
--

ALTER SEQUENCE userena_userenasignup_id_seq OWNED BY userena_userenasignup.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_accountsignup ALTER COLUMN id SET DEFAULT nextval('accounts_accountsignup_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_clientprofile ALTER COLUMN id SET DEFAULT nextval('accounts_clientprofile_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_domicilio ALTER COLUMN id SET DEFAULT nextval('accounts_domicilio_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_meteorologoprofile ALTER COLUMN id SET DEFAULT nextval('accounts_meteorologoprofile_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_vendedor ALTER COLUMN id SET DEFAULT nextval('accounts_vendedor_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_viewerprofile ALTER COLUMN id SET DEFAULT nextval('accounts_viewerprofile_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_acuseenvioaviso ALTER COLUMN id SET DEFAULT nextval('alertas_acuseenvioaviso_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_avisocorreo ALTER COLUMN id SET DEFAULT nextval('alertas_avisocorreo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_condicionmeteorologica ALTER COLUMN id SET DEFAULT nextval('alertas_condicionmeteorologica_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_evento ALTER COLUMN id SET DEFAULT nextval('alertas_evento_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacion ALTER COLUMN id SET DEFAULT nextval('alertas_notificacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacionpersonalizada ALTER COLUMN id SET DEFAULT nextval('alertas_notificacionpersonalizada_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_preferencianotificacion ALTER COLUMN id SET DEFAULT nextval('alertas_preferencianotificacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_preferencianotificacion_tipos ALTER COLUMN id SET DEFAULT nextval('alertas_preferencianotificacion_tipos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_tiponotificacion ALTER COLUMN id SET DEFAULT nextval('alertas_tiponotificacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_anuncio ALTER COLUMN id SET DEFAULT nextval('banners_anuncio_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_anuncio_regiones ALTER COLUMN id SET DEFAULT nextval('banners_anuncio_regiones_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_reproduccion ALTER COLUMN id SET DEFAULT nextval('banners_reproduccion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_asignacioncampo ALTER COLUMN id SET DEFAULT nextval('campos_asignacioncampo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo ALTER COLUMN id SET DEFAULT nextval('campos_campo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_cultivos ALTER COLUMN id SET DEFAULT nextval('campos_campo_cultivos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_usuarios ALTER COLUMN id SET DEFAULT nextval('campos_campo_usuarios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_categoriacultivo ALTER COLUMN id SET DEFAULT nextval('campos_categoriacultivo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_cultivo ALTER COLUMN id SET DEFAULT nextval('campos_cultivo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY celery_taskmeta ALTER COLUMN id SET DEFAULT nextval('celery_taskmeta_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY celery_tasksetmeta ALTER COLUMN id SET DEFAULT nextval('celery_tasksetmeta_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY clientes_comentario ALTER COLUMN id SET DEFAULT nextval('clientes_comentario_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY clientes_historialprospeccion ALTER COLUMN id SET DEFAULT nextval('clientes_historialprospeccion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY clientes_prospecto ALTER COLUMN id SET DEFAULT nextval('clientes_prospecto_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY dispositivos_dispositivo ALTER COLUMN id SET DEFAULT nextval('dispositivos_dispositivo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY dispositivos_versionandroid ALTER COLUMN id SET DEFAULT nextval('dispositivos_versionandroid_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY divemex_latestsecretcode ALTER COLUMN id SET DEFAULT nextval('divemex_latestsecretcode_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY divemex_unidadesfotoperm ALTER COLUMN id SET DEFAULT nextval('divemex_unidadesfotoperm_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY divemex_unidadesfotoperm_campos ALTER COLUMN id SET DEFAULT nextval('divemex_unidadesfotoperm_campos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_site ALTER COLUMN id SET DEFAULT nextval('django_site_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_crontabschedule ALTER COLUMN id SET DEFAULT nextval('djcelery_crontabschedule_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_intervalschedule ALTER COLUMN id SET DEFAULT nextval('djcelery_intervalschedule_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_periodictask ALTER COLUMN id SET DEFAULT nextval('djcelery_periodictask_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_taskstate ALTER COLUMN id SET DEFAULT nextval('djcelery_taskstate_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_workerstate ALTER COLUMN id SET DEFAULT nextval('djcelery_workerstate_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY easy_thumbnails_source ALTER COLUMN id SET DEFAULT nextval('easy_thumbnails_source_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY easy_thumbnails_thumbnail ALTER COLUMN id SET DEFAULT nextval('easy_thumbnails_thumbnail_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_anotacion ALTER COLUMN id SET DEFAULT nextval('empresas_anotacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_categoriaempresa ALTER COLUMN id SET DEFAULT nextval('empresas_categoriaempresa_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_correocontacto ALTER COLUMN id SET DEFAULT nextval('empresas_correocontacto_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_datocontacto ALTER COLUMN id SET DEFAULT nextval('empresas_datocontacto_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_datosfacturacion ALTER COLUMN id SET DEFAULT nextval('empresas_datosfacturacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_empresa ALTER COLUMN id SET DEFAULT nextval('empresas_empresa_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY encuestas_encuestasatisfaccionrecomendacion ALTER COLUMN id SET DEFAULT nextval('encuestas_encuestasatisfaccionrecomendacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY encuestas_encuestasatisfacciontoken ALTER COLUMN id SET DEFAULT nextval('encuestas_encuestasatisfacciontoken_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY estaciones_estacion ALTER COLUMN id SET DEFAULT nextval('estaciones_estacion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_groupobjectpermission ALTER COLUMN id SET DEFAULT nextval('guardian_groupobjectpermission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_userobjectpermission ALTER COLUMN id SET DEFAULT nextval('guardian_userobjectpermission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY historiales_historialmeteorologocampo ALTER COLUMN id SET DEFAULT nextval('historiales_historialmeteorologocampo_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY image_uploads_imageupload ALTER COLUMN id SET DEFAULT nextval('image_uploads_imageupload_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_campoencola ALTER COLUMN id SET DEFAULT nextval('instancias_campoencola_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_colacampos ALTER COLUMN id SET DEFAULT nextval('instancias_colacampos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_colacampos_campos ALTER COLUMN id SET DEFAULT nextval('instancias_colacampos_campos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pagos_pago ALTER COLUMN id SET DEFAULT nextval('pagos_pago_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY preferencias_preferenciasresumendiario ALTER COLUMN id SET DEFAULT nextval('preferencias_preferenciasresumendiario_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY preferencias_preferenciasunidades ALTER COLUMN id SET DEFAULT nextval('preferencias_preferenciasunidades_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_capturahorasfrio ALTER COLUMN id SET DEFAULT nextval('pronosticos_capturahorasfrio_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_climatologia ALTER COLUMN id SET DEFAULT nextval('pronosticos_climatologia_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_climatologiadia ALTER COLUMN id SET DEFAULT nextval('pronosticos_climatologiadia_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusiondiaria ALTER COLUMN id SET DEFAULT nextval('pronosticos_discusiondiaria_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusiongrafica ALTER COLUMN id SET DEFAULT nextval('pronosticos_discusiongrafica_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusionmeteorologica ALTER COLUMN id SET DEFAULT nextval('pronosticos_discusionmeteorologica_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronostico ALTER COLUMN id SET DEFAULT nextval('pronosticos_pronostico_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticobase ALTER COLUMN id SET DEFAULT nextval('pronosticos_pronosticobase_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticoclimatologico ALTER COLUMN id SET DEFAULT nextval('pronosticos_pronosticoclimatologico_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodia ALTER COLUMN id SET DEFAULT nextval('pronosticos_pronosticodia_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodiariolluvia ALTER COLUMN id SET DEFAULT nextval('pronosticos_pronosticodiariolluvia_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_registrohorasfrio ALTER COLUMN id SET DEFAULT nextval('pronosticos_registrohorasfrio_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_tip ALTER COLUMN id SET DEFAULT nextval('pronosticos_tip_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_variablemeteorologica ALTER COLUMN id SET DEFAULT nextval('pronosticos_variablemeteorologica_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY push_notifications_apnsdevice ALTER COLUMN id SET DEFAULT nextval('push_notifications_apnsdevice_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY push_notifications_gcmdevice ALTER COLUMN id SET DEFAULT nextval('push_notifications_gcmdevice_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY south_migrationhistory ALTER COLUMN id SET DEFAULT nextval('south_migrationhistory_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_acuserecibofactura ALTER COLUMN id SET DEFAULT nextval('suscripciones_acuserecibofactura_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato ALTER COLUMN id SET DEFAULT nextval('suscripciones_contrato_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato_campos ALTER COLUMN id SET DEFAULT nextval('suscripciones_contrato_campos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_factura ALTER COLUMN id SET DEFAULT nextval('suscripciones_factura_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_referenciabancaria ALTER COLUMN id SET DEFAULT nextval('suscripciones_referenciabancaria_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_serviciomensual ALTER COLUMN id SET DEFAULT nextval('suscripciones_serviciomensual_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_tipocontrato ALTER COLUMN id SET DEFAULT nextval('suscripciones_tipocontrato_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_estado ALTER COLUMN id SET DEFAULT nextval('ubicaciones_estado_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_municipio ALTER COLUMN id SET DEFAULT nextval('ubicaciones_municipio_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_pais ALTER COLUMN id SET DEFAULT nextval('ubicaciones_pais_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_region ALTER COLUMN id SET DEFAULT nextval('ubicaciones_region_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY userena_userenasignup ALTER COLUMN id SET DEFAULT nextval('userena_userenasignup_id_seq'::regclass);


--
-- Name: accounts_accountsignup_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_accountsignup
    ADD CONSTRAINT accounts_accountsignup_pkey PRIMARY KEY (id);


--
-- Name: accounts_accountsignup_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_accountsignup
    ADD CONSTRAINT accounts_accountsignup_user_id_key UNIQUE (user_id);


--
-- Name: accounts_clientprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_pkey PRIMARY KEY (id);


--
-- Name: accounts_clientprofile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_user_id_key UNIQUE (user_id);


--
-- Name: accounts_domicilio_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_domicilio
    ADD CONSTRAINT accounts_domicilio_pkey PRIMARY KEY (id);


--
-- Name: accounts_meteorologoprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_meteorologoprofile
    ADD CONSTRAINT accounts_meteorologoprofile_pkey PRIMARY KEY (id);


--
-- Name: accounts_meteorologoprofile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_meteorologoprofile
    ADD CONSTRAINT accounts_meteorologoprofile_user_id_key UNIQUE (user_id);


--
-- Name: accounts_vendedor_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_vendedor
    ADD CONSTRAINT accounts_vendedor_pkey PRIMARY KEY (id);


--
-- Name: accounts_viewerprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_viewerprofile
    ADD CONSTRAINT accounts_viewerprofile_pkey PRIMARY KEY (id);


--
-- Name: accounts_viewerprofile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY accounts_viewerprofile
    ADD CONSTRAINT accounts_viewerprofile_user_id_key UNIQUE (user_id);


--
-- Name: alertas_acuseenvioaviso_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_acuseenvioaviso
    ADD CONSTRAINT alertas_acuseenvioaviso_pkey PRIMARY KEY (id);


--
-- Name: alertas_avisocorreo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_avisocorreo
    ADD CONSTRAINT alertas_avisocorreo_pkey PRIMARY KEY (id);


--
-- Name: alertas_condicionmeteorologica_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_condicionmeteorologica
    ADD CONSTRAINT alertas_condicionmeteorologica_pkey PRIMARY KEY (id);


--
-- Name: alertas_evento_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_evento
    ADD CONSTRAINT alertas_evento_pkey PRIMARY KEY (id);


--
-- Name: alertas_notificacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_notificacion
    ADD CONSTRAINT alertas_notificacion_pkey PRIMARY KEY (id);


--
-- Name: alertas_notificacionpersonalizada_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_notificacionpersonalizada
    ADD CONSTRAINT alertas_notificacionpersonalizada_pkey PRIMARY KEY (id);


--
-- Name: alertas_preferencianotificaci_preferencianotificacion_id_ti_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_preferencianotificacion_tipos
    ADD CONSTRAINT alertas_preferencianotificaci_preferencianotificacion_id_ti_key UNIQUE (preferencianotificacion_id, tiponotificacion_id);


--
-- Name: alertas_preferencianotificacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_preferencianotificacion
    ADD CONSTRAINT alertas_preferencianotificacion_pkey PRIMARY KEY (id);


--
-- Name: alertas_preferencianotificacion_tipos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_preferencianotificacion_tipos
    ADD CONSTRAINT alertas_preferencianotificacion_tipos_pkey PRIMARY KEY (id);


--
-- Name: alertas_preferencianotificacion_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_preferencianotificacion
    ADD CONSTRAINT alertas_preferencianotificacion_user_id_key UNIQUE (user_id);


--
-- Name: alertas_tiponotificacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY alertas_tiponotificacion
    ADD CONSTRAINT alertas_tiponotificacion_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_key UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission_content_type_id_codename_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_key UNIQUE (content_type_id, codename);


--
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups_user_id_group_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_key UNIQUE (user_id, group_id);


--
-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions_user_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_key UNIQUE (user_id, permission_id);


--
-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: authtoken_token_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY authtoken_token
    ADD CONSTRAINT authtoken_token_pkey PRIMARY KEY (key);


--
-- Name: authtoken_token_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY authtoken_token
    ADD CONSTRAINT authtoken_token_user_id_key UNIQUE (user_id);


--
-- Name: banners_anuncio_campaign_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_anuncio
    ADD CONSTRAINT banners_anuncio_campaign_id_key UNIQUE (campaign_id);


--
-- Name: banners_anuncio_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_anuncio
    ADD CONSTRAINT banners_anuncio_pkey PRIMARY KEY (id);


--
-- Name: banners_anuncio_regiones_anuncio_id_region_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_anuncio_regiones
    ADD CONSTRAINT banners_anuncio_regiones_anuncio_id_region_id_key UNIQUE (anuncio_id, region_id);


--
-- Name: banners_anuncio_regiones_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_anuncio_regiones
    ADD CONSTRAINT banners_anuncio_regiones_pkey PRIMARY KEY (id);


--
-- Name: banners_reproduccion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_reproduccion
    ADD CONSTRAINT banners_reproduccion_pkey PRIMARY KEY (id);


--
-- Name: banners_reproduccion_user_id_ced6455f259c8a_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY banners_reproduccion
    ADD CONSTRAINT banners_reproduccion_user_id_ced6455f259c8a_uniq UNIQUE (user_id, anuncio_id);


--
-- Name: campos_asignacioncampo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_asignacioncampo
    ADD CONSTRAINT campos_asignacioncampo_pkey PRIMARY KEY (id);


--
-- Name: campos_campo_cultivos_campo_id_cultivo_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_campo_cultivos
    ADD CONSTRAINT campos_campo_cultivos_campo_id_cultivo_id_key UNIQUE (campo_id, cultivo_id);


--
-- Name: campos_campo_cultivos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_campo_cultivos
    ADD CONSTRAINT campos_campo_cultivos_pkey PRIMARY KEY (id);


--
-- Name: campos_campo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_campo
    ADD CONSTRAINT campos_campo_pkey PRIMARY KEY (id);


--
-- Name: campos_campo_usuarios_campo_id_53daa403fa283791_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_campo_usuarios
    ADD CONSTRAINT campos_campo_usuarios_campo_id_53daa403fa283791_uniq UNIQUE (campo_id, user_id);


--
-- Name: campos_campo_usuarios_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_campo_usuarios
    ADD CONSTRAINT campos_campo_usuarios_pkey PRIMARY KEY (id);


--
-- Name: campos_categoriacultivo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_categoriacultivo
    ADD CONSTRAINT campos_categoriacultivo_pkey PRIMARY KEY (id);


--
-- Name: campos_cultivo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY campos_cultivo
    ADD CONSTRAINT campos_cultivo_pkey PRIMARY KEY (id);


--
-- Name: celery_taskmeta_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY celery_taskmeta
    ADD CONSTRAINT celery_taskmeta_pkey PRIMARY KEY (id);


--
-- Name: celery_taskmeta_task_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY celery_taskmeta
    ADD CONSTRAINT celery_taskmeta_task_id_key UNIQUE (task_id);


--
-- Name: celery_tasksetmeta_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY celery_tasksetmeta
    ADD CONSTRAINT celery_tasksetmeta_pkey PRIMARY KEY (id);


--
-- Name: celery_tasksetmeta_taskset_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY celery_tasksetmeta
    ADD CONSTRAINT celery_tasksetmeta_taskset_id_key UNIQUE (taskset_id);


--
-- Name: clientes_comentario_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY clientes_comentario
    ADD CONSTRAINT clientes_comentario_pkey PRIMARY KEY (id);


--
-- Name: clientes_historialprospeccion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY clientes_historialprospeccion
    ADD CONSTRAINT clientes_historialprospeccion_pkey PRIMARY KEY (id);


--
-- Name: clientes_prospecto_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY clientes_prospecto
    ADD CONSTRAINT clientes_prospecto_pkey PRIMARY KEY (id);


--
-- Name: dispositivos_dispositivo_device_id_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY dispositivos_dispositivo
    ADD CONSTRAINT dispositivos_dispositivo_device_id_uniq UNIQUE (device_id);


--
-- Name: dispositivos_dispositivo_endpoint_arn_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY dispositivos_dispositivo
    ADD CONSTRAINT dispositivos_dispositivo_endpoint_arn_key UNIQUE (endpoint_arn);


--
-- Name: dispositivos_dispositivo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY dispositivos_dispositivo
    ADD CONSTRAINT dispositivos_dispositivo_pkey PRIMARY KEY (id);


--
-- Name: dispositivos_dispositivo_registration_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY dispositivos_dispositivo
    ADD CONSTRAINT dispositivos_dispositivo_registration_id_key UNIQUE (registration_id);


--
-- Name: dispositivos_versionandroid_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY dispositivos_versionandroid
    ADD CONSTRAINT dispositivos_versionandroid_pkey PRIMARY KEY (id);


--
-- Name: divemex_latestsecretcode_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY divemex_latestsecretcode
    ADD CONSTRAINT divemex_latestsecretcode_pkey PRIMARY KEY (id);


--
-- Name: divemex_unidadesfotoperm_campo_unidadesfotoperm_id_campo_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY divemex_unidadesfotoperm_campos
    ADD CONSTRAINT divemex_unidadesfotoperm_campo_unidadesfotoperm_id_campo_id_key UNIQUE (unidadesfotoperm_id, campo_id);


--
-- Name: divemex_unidadesfotoperm_campos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY divemex_unidadesfotoperm_campos
    ADD CONSTRAINT divemex_unidadesfotoperm_campos_pkey PRIMARY KEY (id);


--
-- Name: divemex_unidadesfotoperm_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY divemex_unidadesfotoperm
    ADD CONSTRAINT divemex_unidadesfotoperm_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type_app_label_model_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_key UNIQUE (app_label, model);


--
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY django_site
    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);


--
-- Name: djcelery_crontabschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_crontabschedule
    ADD CONSTRAINT djcelery_crontabschedule_pkey PRIMARY KEY (id);


--
-- Name: djcelery_intervalschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_intervalschedule
    ADD CONSTRAINT djcelery_intervalschedule_pkey PRIMARY KEY (id);


--
-- Name: djcelery_periodictask_name_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_periodictask
    ADD CONSTRAINT djcelery_periodictask_name_key UNIQUE (name);


--
-- Name: djcelery_periodictask_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_periodictask
    ADD CONSTRAINT djcelery_periodictask_pkey PRIMARY KEY (id);


--
-- Name: djcelery_periodictasks_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_periodictasks
    ADD CONSTRAINT djcelery_periodictasks_pkey PRIMARY KEY (ident);


--
-- Name: djcelery_taskstate_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_taskstate
    ADD CONSTRAINT djcelery_taskstate_pkey PRIMARY KEY (id);


--
-- Name: djcelery_taskstate_task_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_taskstate
    ADD CONSTRAINT djcelery_taskstate_task_id_key UNIQUE (task_id);


--
-- Name: djcelery_workerstate_hostname_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_workerstate
    ADD CONSTRAINT djcelery_workerstate_hostname_key UNIQUE (hostname);


--
-- Name: djcelery_workerstate_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY djcelery_workerstate
    ADD CONSTRAINT djcelery_workerstate_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_source_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_source
    ADD CONSTRAINT easy_thumbnails_source_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_source_storage_hash_name_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_source
    ADD CONSTRAINT easy_thumbnails_source_storage_hash_name_key UNIQUE (storage_hash, name);


--
-- Name: easy_thumbnails_thumbnail_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_thumbnail_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_thumbnail_storage_hash_name_source_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_thumbnail_storage_hash_name_source_id_key UNIQUE (storage_hash, name, source_id);


--
-- Name: empresas_anotacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_anotacion
    ADD CONSTRAINT empresas_anotacion_pkey PRIMARY KEY (id);


--
-- Name: empresas_categoriaempresa_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_categoriaempresa
    ADD CONSTRAINT empresas_categoriaempresa_pkey PRIMARY KEY (id);


--
-- Name: empresas_correocontacto_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_correocontacto
    ADD CONSTRAINT empresas_correocontacto_pkey PRIMARY KEY (id);


--
-- Name: empresas_datocontacto_empresa_id_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_datocontacto
    ADD CONSTRAINT empresas_datocontacto_empresa_id_uniq UNIQUE (empresa_id);


--
-- Name: empresas_datocontacto_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_datocontacto
    ADD CONSTRAINT empresas_datocontacto_pkey PRIMARY KEY (id);


--
-- Name: empresas_datosfacturacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_datosfacturacion
    ADD CONSTRAINT empresas_datosfacturacion_pkey PRIMARY KEY (id);


--
-- Name: empresas_empresa_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY empresas_empresa
    ADD CONSTRAINT empresas_empresa_pkey PRIMARY KEY (id);


--
-- Name: encuestas_encuestasatisfaccionrecomendacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY encuestas_encuestasatisfaccionrecomendacion
    ADD CONSTRAINT encuestas_encuestasatisfaccionrecomendacion_pkey PRIMARY KEY (id);


--
-- Name: encuestas_encuestasatisfacciontoken_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY encuestas_encuestasatisfacciontoken
    ADD CONSTRAINT encuestas_encuestasatisfacciontoken_pkey PRIMARY KEY (id);


--
-- Name: estaciones_estacion_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY estaciones_estacion
    ADD CONSTRAINT estaciones_estacion_pkey PRIMARY KEY (id);


--
-- Name: guardian_groupobjectpermissio_group_id_permission_id_object_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermissio_group_id_permission_id_object_key UNIQUE (group_id, permission_id, object_pk);


--
-- Name: guardian_groupobjectpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_pkey PRIMARY KEY (id);


--
-- Name: guardian_userobjectpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_pkey PRIMARY KEY (id);


--
-- Name: guardian_userobjectpermission_user_id_permission_id_object__key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_user_id_permission_id_object__key UNIQUE (user_id, permission_id, object_pk);


--
-- Name: historiales_historialmeteorologocampo_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY historiales_historialmeteorologocampo
    ADD CONSTRAINT historiales_historialmeteorologocampo_pkey PRIMARY KEY (id);


--
-- Name: image_uploads_imageupload_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY image_uploads_imageupload
    ADD CONSTRAINT image_uploads_imageupload_pkey PRIMARY KEY (id);


--
-- Name: instancias_campoencola_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY instancias_campoencola
    ADD CONSTRAINT instancias_campoencola_pkey PRIMARY KEY (id);


--
-- Name: instancias_colacampos_campo_colacampos_id_572ef51b48b2e109_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY instancias_colacampos_campos
    ADD CONSTRAINT instancias_colacampos_campo_colacampos_id_572ef51b48b2e109_uniq UNIQUE (colacampos_id, campoencola_id);


--
-- Name: instancias_colacampos_campos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY instancias_colacampos_campos
    ADD CONSTRAINT instancias_colacampos_campos_pkey PRIMARY KEY (id);


--
-- Name: instancias_colacampos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY instancias_colacampos
    ADD CONSTRAINT instancias_colacampos_pkey PRIMARY KEY (id);


--
-- Name: pagos_pago_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pagos_pago
    ADD CONSTRAINT pagos_pago_pkey PRIMARY KEY (id);


--
-- Name: preferencias_preferenciasresumendiario_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY preferencias_preferenciasresumendiario
    ADD CONSTRAINT preferencias_preferenciasresumendiario_pkey PRIMARY KEY (id);


--
-- Name: preferencias_preferenciasresumendiario_usuario_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY preferencias_preferenciasresumendiario
    ADD CONSTRAINT preferencias_preferenciasresumendiario_usuario_id_key UNIQUE (usuario_id);


--
-- Name: preferencias_preferenciasunidades_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY preferencias_preferenciasunidades
    ADD CONSTRAINT preferencias_preferenciasunidades_pkey PRIMARY KEY (id);


--
-- Name: preferencias_preferenciasunidades_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY preferencias_preferenciasunidades
    ADD CONSTRAINT preferencias_preferenciasunidades_user_id_key UNIQUE (user_id);


--
-- Name: pronosticos_capturahorasfrio_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_capturahorasfrio
    ADD CONSTRAINT pronosticos_capturahorasfrio_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_climatologia_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_climatologia
    ADD CONSTRAINT pronosticos_climatologia_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_climatologiadia_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_climatologiadia
    ADD CONSTRAINT pronosticos_climatologiadia_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_discusiondiaria_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_discusiondiaria
    ADD CONSTRAINT pronosticos_discusiondiaria_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_discusiongrafica_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_discusiongrafica
    ADD CONSTRAINT pronosticos_discusiongrafica_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_discusionmeteorologica_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_discusionmeteorologica
    ADD CONSTRAINT pronosticos_discusionmeteorologica_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_pronostico_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_pronostico
    ADD CONSTRAINT pronosticos_pronostico_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_pronosticobase_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_pronosticobase
    ADD CONSTRAINT pronosticos_pronosticobase_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_pronosticoclimatologico_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_pronosticoclimatologico
    ADD CONSTRAINT pronosticos_pronosticoclimatologico_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_pronosticodia_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_pronosticodia
    ADD CONSTRAINT pronosticos_pronosticodia_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_pronosticodiariolluvia_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_pronosticodiariolluvia
    ADD CONSTRAINT pronosticos_pronosticodiariolluvia_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_registrohorasfrio_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_registrohorasfrio
    ADD CONSTRAINT pronosticos_registrohorasfrio_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_tip_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_tip
    ADD CONSTRAINT pronosticos_tip_pkey PRIMARY KEY (id);


--
-- Name: pronosticos_variablemeteorologica_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY pronosticos_variablemeteorologica
    ADD CONSTRAINT pronosticos_variablemeteorologica_pkey PRIMARY KEY (id);


--
-- Name: push_notifications_apnsdevice_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY push_notifications_apnsdevice
    ADD CONSTRAINT push_notifications_apnsdevice_pkey PRIMARY KEY (id);


--
-- Name: push_notifications_apnsdevice_registration_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY push_notifications_apnsdevice
    ADD CONSTRAINT push_notifications_apnsdevice_registration_id_key UNIQUE (registration_id);


--
-- Name: push_notifications_gcmdevice_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY push_notifications_gcmdevice
    ADD CONSTRAINT push_notifications_gcmdevice_pkey PRIMARY KEY (id);


--
-- Name: south_migrationhistory_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY south_migrationhistory
    ADD CONSTRAINT south_migrationhistory_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_acuserecibofactura_factura_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_acuserecibofactura
    ADD CONSTRAINT suscripciones_acuserecibofactura_factura_id_key UNIQUE (factura_id);


--
-- Name: suscripciones_acuserecibofactura_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_acuserecibofactura
    ADD CONSTRAINT suscripciones_acuserecibofactura_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_contrato_campos_contrato_id_705a62a1d52cd7d3_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_contrato_campos
    ADD CONSTRAINT suscripciones_contrato_campos_contrato_id_705a62a1d52cd7d3_uniq UNIQUE (contrato_id, campo_id);


--
-- Name: suscripciones_contrato_campos_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_contrato_campos
    ADD CONSTRAINT suscripciones_contrato_campos_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_contrato_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_contrato
    ADD CONSTRAINT suscripciones_contrato_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_factura_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_factura
    ADD CONSTRAINT suscripciones_factura_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_factura_uuid_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_factura
    ADD CONSTRAINT suscripciones_factura_uuid_key UNIQUE (uuid);


--
-- Name: suscripciones_referenciabancaria_numero_2235fa570c9d337_uniq; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_referenciabancaria
    ADD CONSTRAINT suscripciones_referenciabancaria_numero_2235fa570c9d337_uniq UNIQUE (numero);


--
-- Name: suscripciones_referenciabancaria_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_referenciabancaria
    ADD CONSTRAINT suscripciones_referenciabancaria_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_serviciomensual_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_serviciomensual
    ADD CONSTRAINT suscripciones_serviciomensual_pkey PRIMARY KEY (id);


--
-- Name: suscripciones_tipocontrato_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY suscripciones_tipocontrato
    ADD CONSTRAINT suscripciones_tipocontrato_pkey PRIMARY KEY (id);


--
-- Name: ubicaciones_estado_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY ubicaciones_estado
    ADD CONSTRAINT ubicaciones_estado_pkey PRIMARY KEY (id);


--
-- Name: ubicaciones_municipio_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY ubicaciones_municipio
    ADD CONSTRAINT ubicaciones_municipio_pkey PRIMARY KEY (id);


--
-- Name: ubicaciones_pais_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY ubicaciones_pais
    ADD CONSTRAINT ubicaciones_pais_pkey PRIMARY KEY (id);


--
-- Name: ubicaciones_region_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY ubicaciones_region
    ADD CONSTRAINT ubicaciones_region_pkey PRIMARY KEY (id);


--
-- Name: userena_userenasignup_pkey; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY userena_userenasignup
    ADD CONSTRAINT userena_userenasignup_pkey PRIMARY KEY (id);


--
-- Name: userena_userenasignup_user_id_key; Type: CONSTRAINT; Schema: public; Owner: globalmet; Tablespace: 
--

ALTER TABLE ONLY userena_userenasignup
    ADD CONSTRAINT userena_userenasignup_user_id_key UNIQUE (user_id);


--
-- Name: accounts_domicilio_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX accounts_domicilio_content_type_id ON accounts_domicilio USING btree (content_type_id);


--
-- Name: accounts_viewerprofile_cliente_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX accounts_viewerprofile_cliente_id ON accounts_viewerprofile USING btree (cliente_id);


--
-- Name: alertas_acuseenvioaviso_e8701ad4; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_acuseenvioaviso_e8701ad4 ON alertas_acuseenvioaviso USING btree (user_id);


--
-- Name: alertas_acuseenvioaviso_fd96d347; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_acuseenvioaviso_fd96d347 ON alertas_acuseenvioaviso USING btree (correo_id);


--
-- Name: alertas_avisocorreo_e93cb7eb; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_avisocorreo_e93cb7eb ON alertas_avisocorreo USING btree (created_by_id);


--
-- Name: alertas_condicionmeteorologica_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_condicionmeteorologica_campo_id ON alertas_condicionmeteorologica USING btree (campo_id);


--
-- Name: alertas_condicionmeteorologica_variable_meteorologica_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_condicionmeteorologica_variable_meteorologica_id ON alertas_condicionmeteorologica USING btree (variable_meteorologica_id);


--
-- Name: alertas_evento_condicion_meteorologica_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_evento_condicion_meteorologica_id ON alertas_evento USING btree (condicion_meteorologica_id);


--
-- Name: alertas_notificacion_evento_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_notificacion_evento_id ON alertas_notificacion USING btree (evento_id);


--
-- Name: alertas_notificacion_tipo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_notificacion_tipo_id ON alertas_notificacion USING btree (tipo_id);


--
-- Name: alertas_notificacion_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_notificacion_user_id ON alertas_notificacion USING btree (user_id);


--
-- Name: alertas_notificacionpersonalizada_tipo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_notificacionpersonalizada_tipo_id ON alertas_notificacionpersonalizada USING btree (tipo_id);


--
-- Name: alertas_notificacionpersonalizada_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_notificacionpersonalizada_user_id ON alertas_notificacionpersonalizada USING btree (user_id);


--
-- Name: alertas_preferencianotificacion_tipos_preferencianotificaci9cd6; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_preferencianotificacion_tipos_preferencianotificaci9cd6 ON alertas_preferencianotificacion_tipos USING btree (preferencianotificacion_id);


--
-- Name: alertas_preferencianotificacion_tipos_tiponotificacion_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX alertas_preferencianotificacion_tipos_tiponotificacion_id ON alertas_preferencianotificacion_tipos USING btree (tiponotificacion_id);


--
-- Name: auth_group_name_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_group_name_like ON auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_group_permissions_group_id ON auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_group_permissions_permission_id ON auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_permission_content_type_id ON auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_user_groups_group_id ON auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_user_groups_user_id ON auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_permission_id ON auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_user_id ON auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX auth_user_username_like ON auth_user USING btree (username varchar_pattern_ops);


--
-- Name: authtoken_token_key_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX authtoken_token_key_like ON authtoken_token USING btree (key varchar_pattern_ops);


--
-- Name: banners_anuncio_regiones_0f442f96; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX banners_anuncio_regiones_0f442f96 ON banners_anuncio_regiones USING btree (region_id);


--
-- Name: banners_anuncio_regiones_5dbc91ef; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX banners_anuncio_regiones_5dbc91ef ON banners_anuncio_regiones USING btree (anuncio_id);


--
-- Name: banners_reproduccion_5dbc91ef; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX banners_reproduccion_5dbc91ef ON banners_reproduccion USING btree (anuncio_id);


--
-- Name: banners_reproduccion_e8701ad4; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX banners_reproduccion_e8701ad4 ON banners_reproduccion USING btree (user_id);


--
-- Name: campos_asignacioncampo_89040516; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_asignacioncampo_89040516 ON campos_asignacioncampo USING btree (meteorologo_id);


--
-- Name: campos_asignacioncampo_e40f192a; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_asignacioncampo_e40f192a ON campos_asignacioncampo USING btree (campo_id);


--
-- Name: campos_campo_83f6866b; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_83f6866b ON campos_campo USING btree (climatologia_id);


--
-- Name: campos_campo_cultivos_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_cultivos_campo_id ON campos_campo_cultivos USING btree (campo_id);


--
-- Name: campos_campo_cultivos_cultivo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_cultivos_cultivo_id ON campos_campo_cultivos USING btree (cultivo_id);


--
-- Name: campos_campo_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_empresa_id ON campos_campo USING btree (empresa_id);


--
-- Name: campos_campo_geofence_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_geofence_id ON campos_campo USING gist (geofence);


--
-- Name: campos_campo_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_meteorologo_id ON campos_campo USING btree (meteorologo_id);


--
-- Name: campos_campo_region_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_region_id ON campos_campo USING btree (region_id);


--
-- Name: campos_campo_usuarios_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_usuarios_campo_id ON campos_campo_usuarios USING btree (campo_id);


--
-- Name: campos_campo_usuarios_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_campo_usuarios_user_id ON campos_campo_usuarios USING btree (user_id);


--
-- Name: campos_cultivo_categoria_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX campos_cultivo_categoria_id ON campos_cultivo USING btree (categoria_id);


--
-- Name: celery_taskmeta_hidden; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX celery_taskmeta_hidden ON celery_taskmeta USING btree (hidden);


--
-- Name: celery_taskmeta_task_id_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX celery_taskmeta_task_id_like ON celery_taskmeta USING btree (task_id varchar_pattern_ops);


--
-- Name: celery_tasksetmeta_hidden; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX celery_tasksetmeta_hidden ON celery_tasksetmeta USING btree (hidden);


--
-- Name: celery_tasksetmeta_taskset_id_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX celery_tasksetmeta_taskset_id_like ON celery_tasksetmeta USING btree (taskset_id varchar_pattern_ops);


--
-- Name: clientes_comentario_prospecto_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX clientes_comentario_prospecto_id ON clientes_comentario USING btree (prospecto_id);


--
-- Name: clientes_historialprospeccion_prospecto_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX clientes_historialprospeccion_prospecto_id ON clientes_historialprospeccion USING btree (prospecto_id);


--
-- Name: dispositivos_dispositivo_endpoint_arn_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX dispositivos_dispositivo_endpoint_arn_like ON dispositivos_dispositivo USING btree (endpoint_arn text_pattern_ops);


--
-- Name: dispositivos_dispositivo_registration_id_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX dispositivos_dispositivo_registration_id_like ON dispositivos_dispositivo USING btree (registration_id text_pattern_ops);


--
-- Name: dispositivos_dispositivo_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX dispositivos_dispositivo_user_id ON dispositivos_dispositivo USING btree (user_id);


--
-- Name: divemex_unidadesfotoperm_campos_df2c6b1d; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX divemex_unidadesfotoperm_campos_df2c6b1d ON divemex_unidadesfotoperm_campos USING btree (unidadesfotoperm_id);


--
-- Name: divemex_unidadesfotoperm_campos_e40f192a; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX divemex_unidadesfotoperm_campos_e40f192a ON divemex_unidadesfotoperm_campos USING btree (campo_id);


--
-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX django_admin_log_content_type_id ON django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX django_admin_log_user_id ON django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX django_session_expire_date ON django_session USING btree (expire_date);


--
-- Name: django_session_session_key_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX django_session_session_key_like ON django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: djcelery_periodictask_crontab_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_periodictask_crontab_id ON djcelery_periodictask USING btree (crontab_id);


--
-- Name: djcelery_periodictask_interval_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_periodictask_interval_id ON djcelery_periodictask USING btree (interval_id);


--
-- Name: djcelery_periodictask_name_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_periodictask_name_like ON djcelery_periodictask USING btree (name varchar_pattern_ops);


--
-- Name: djcelery_taskstate_hidden; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_hidden ON djcelery_taskstate USING btree (hidden);


--
-- Name: djcelery_taskstate_name; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_name ON djcelery_taskstate USING btree (name);


--
-- Name: djcelery_taskstate_name_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_name_like ON djcelery_taskstate USING btree (name varchar_pattern_ops);


--
-- Name: djcelery_taskstate_state; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_state ON djcelery_taskstate USING btree (state);


--
-- Name: djcelery_taskstate_state_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_state_like ON djcelery_taskstate USING btree (state varchar_pattern_ops);


--
-- Name: djcelery_taskstate_task_id_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_task_id_like ON djcelery_taskstate USING btree (task_id varchar_pattern_ops);


--
-- Name: djcelery_taskstate_tstamp; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_tstamp ON djcelery_taskstate USING btree (tstamp);


--
-- Name: djcelery_taskstate_worker_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_taskstate_worker_id ON djcelery_taskstate USING btree (worker_id);


--
-- Name: djcelery_workerstate_hostname_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_workerstate_hostname_like ON djcelery_workerstate USING btree (hostname varchar_pattern_ops);


--
-- Name: djcelery_workerstate_last_heartbeat; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX djcelery_workerstate_last_heartbeat ON djcelery_workerstate USING btree (last_heartbeat);


--
-- Name: easy_thumbnails_source_name; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_name ON easy_thumbnails_source USING btree (name);


--
-- Name: easy_thumbnails_source_name_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_name_like ON easy_thumbnails_source USING btree (name varchar_pattern_ops);


--
-- Name: easy_thumbnails_source_storage_hash; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_storage_hash ON easy_thumbnails_source USING btree (storage_hash);


--
-- Name: easy_thumbnails_source_storage_hash_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_storage_hash_like ON easy_thumbnails_source USING btree (storage_hash varchar_pattern_ops);


--
-- Name: easy_thumbnails_thumbnail_name; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_name ON easy_thumbnails_thumbnail USING btree (name);


--
-- Name: easy_thumbnails_thumbnail_name_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_name_like ON easy_thumbnails_thumbnail USING btree (name varchar_pattern_ops);


--
-- Name: easy_thumbnails_thumbnail_source_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_source_id ON easy_thumbnails_thumbnail USING btree (source_id);


--
-- Name: easy_thumbnails_thumbnail_storage_hash; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_storage_hash ON easy_thumbnails_thumbnail USING btree (storage_hash);


--
-- Name: easy_thumbnails_thumbnail_storage_hash_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_storage_hash_like ON easy_thumbnails_thumbnail USING btree (storage_hash varchar_pattern_ops);


--
-- Name: empresas_anotacion_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_anotacion_empresa_id ON empresas_anotacion USING btree (empresa_id);


--
-- Name: empresas_correocontacto_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_correocontacto_empresa_id ON empresas_correocontacto USING btree (empresa_id);


--
-- Name: empresas_datocontacto_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_datocontacto_empresa_id ON empresas_datocontacto USING btree (empresa_id);


--
-- Name: empresas_datosfacturacion_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_datosfacturacion_content_type_id ON empresas_datosfacturacion USING btree (content_type_id);


--
-- Name: empresas_empresa_categoria_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_empresa_categoria_id ON empresas_empresa USING btree (categoria_id);


--
-- Name: empresas_empresa_cliente_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX empresas_empresa_cliente_id ON empresas_empresa USING btree (cliente_id);


--
-- Name: encuestas_encuestasatisfaccionrecomendacion_usuario_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX encuestas_encuestasatisfaccionrecomendacion_usuario_id ON encuestas_encuestasatisfaccionrecomendacion USING btree (usuario_id);


--
-- Name: encuestas_encuestasatisfacciontoken_usuario_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX encuestas_encuestasatisfacciontoken_usuario_id ON encuestas_encuestasatisfacciontoken USING btree (usuario_id);


--
-- Name: estaciones_estacion_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX estaciones_estacion_campo_id ON estaciones_estacion USING btree (campo_id);


--
-- Name: guardian_groupobjectpermission_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_content_type_id ON guardian_groupobjectpermission USING btree (content_type_id);


--
-- Name: guardian_groupobjectpermission_group_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_group_id ON guardian_groupobjectpermission USING btree (group_id);


--
-- Name: guardian_groupobjectpermission_permission_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_permission_id ON guardian_groupobjectpermission USING btree (permission_id);


--
-- Name: guardian_userobjectpermission_content_type_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_content_type_id ON guardian_userobjectpermission USING btree (content_type_id);


--
-- Name: guardian_userobjectpermission_permission_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_permission_id ON guardian_userobjectpermission USING btree (permission_id);


--
-- Name: guardian_userobjectpermission_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_user_id ON guardian_userobjectpermission USING btree (user_id);


--
-- Name: historiales_historialmeteorologocampo_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX historiales_historialmeteorologocampo_campo_id ON historiales_historialmeteorologocampo USING btree (campo_id);


--
-- Name: historiales_historialmeteorologocampo_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX historiales_historialmeteorologocampo_meteorologo_id ON historiales_historialmeteorologocampo USING btree (meteorologo_id);


--
-- Name: instancias_campoencola_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX instancias_campoencola_campo_id ON instancias_campoencola USING btree (campo_id);


--
-- Name: instancias_colacampos_campos_campoencola_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX instancias_colacampos_campos_campoencola_id ON instancias_colacampos_campos USING btree (campoencola_id);


--
-- Name: instancias_colacampos_campos_colacampos_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX instancias_colacampos_campos_colacampos_id ON instancias_colacampos_campos USING btree (colacampos_id);


--
-- Name: pagos_pago_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pagos_pago_empresa_id ON pagos_pago USING btree (empresa_id);


--
-- Name: pronosticos_capturahorasfrio_69162670; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_capturahorasfrio_69162670 ON pronosticos_capturahorasfrio USING btree (registro_id);


--
-- Name: pronosticos_climatologiadia_83f6866b; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_climatologiadia_83f6866b ON pronosticos_climatologiadia USING btree (climatologia_id);


--
-- Name: pronosticos_discusiondiaria_discusion_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_discusiondiaria_discusion_id ON pronosticos_discusiondiaria USING btree (discusion_id);


--
-- Name: pronosticos_discusiondiaria_fecha_29fd9026276fd869_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_discusiondiaria_fecha_29fd9026276fd869_uniq ON pronosticos_discusiondiaria USING btree (fecha);


--
-- Name: pronosticos_discusiongrafica_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_discusiongrafica_campo_id ON pronosticos_discusiongrafica USING btree (campo_id);


--
-- Name: pronosticos_discusionmeteorologi_vigencia_1635cf592478359e_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_discusionmeteorologi_vigencia_1635cf592478359e_uniq ON pronosticos_discusionmeteorologica USING btree (vigencia);


--
-- Name: pronosticos_discusionmeteorologica_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_discusionmeteorologica_campo_id ON pronosticos_discusionmeteorologica USING btree (campo_id);


--
-- Name: pronosticos_pronostico_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronostico_campo_id ON pronosticos_pronostico USING btree (campo_id);


--
-- Name: pronosticos_pronostico_fecha_calculo; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronostico_fecha_calculo ON pronosticos_pronostico USING btree (fecha_calculo);


--
-- Name: pronosticos_pronostico_fecha_pronostico; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronostico_fecha_pronostico ON pronosticos_pronostico USING btree (fecha_pronostico);


--
-- Name: pronosticos_pronostico_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronostico_meteorologo_id ON pronosticos_pronostico USING btree (meteorologo_id);


--
-- Name: pronosticos_pronostico_modelo_pronostico; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronostico_modelo_pronostico ON pronosticos_pronostico USING btree (modelo_pronostico);


--
-- Name: pronosticos_pronosticoba_fecha_pronostico_1aaf8ae2d4738ab2_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticoba_fecha_pronostico_1aaf8ae2d4738ab2_uniq ON pronosticos_pronosticobase USING btree (fecha_pronostico);


--
-- Name: pronosticos_pronosticobase_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticobase_campo_id ON pronosticos_pronosticobase USING btree (campo_id);


--
-- Name: pronosticos_pronosticobase_fecha_calculo_1a4bb734c968be68_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticobase_fecha_calculo_1a4bb734c968be68_uniq ON pronosticos_pronosticobase USING btree (fecha_calculo);


--
-- Name: pronosticos_pronosticobase_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticobase_meteorologo_id ON pronosticos_pronosticobase USING btree (meteorologo_id);


--
-- Name: pronosticos_pronosticobase_variable_meteorologica_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticobase_variable_meteorologica_id ON pronosticos_pronosticobase USING btree (variable_meteorologica_id);


--
-- Name: pronosticos_pronosticoclimatologico_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticoclimatologico_campo_id ON pronosticos_pronosticoclimatologico USING btree (campo_id);


--
-- Name: pronosticos_pronosticoclimatologico_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticoclimatologico_meteorologo_id ON pronosticos_pronosticoclimatologico USING btree (meteorologo_id);


--
-- Name: pronosticos_pronosticodi_fecha_pronostico_1f06c11b5cfecec4_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodi_fecha_pronostico_1f06c11b5cfecec4_uniq ON pronosticos_pronosticodia USING btree (fecha_pronostico);


--
-- Name: pronosticos_pronosticodi_fecha_pronostico_43f67ab1786c7826_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodi_fecha_pronostico_43f67ab1786c7826_uniq ON pronosticos_pronosticodiariolluvia USING btree (fecha_pronostico);


--
-- Name: pronosticos_pronosticodia_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodia_campo_id ON pronosticos_pronosticodia USING btree (campo_id);


--
-- Name: pronosticos_pronosticodia_fecha_calculo_7bfde54ba145fb6a_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodia_fecha_calculo_7bfde54ba145fb6a_uniq ON pronosticos_pronosticodia USING btree (fecha_calculo);


--
-- Name: pronosticos_pronosticodia_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodia_meteorologo_id ON pronosticos_pronosticodia USING btree (meteorologo_id);


--
-- Name: pronosticos_pronosticodiari_fecha_calculo_4bd4ddc9173d38c0_uniq; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodiari_fecha_calculo_4bd4ddc9173d38c0_uniq ON pronosticos_pronosticodiariolluvia USING btree (fecha_calculo);


--
-- Name: pronosticos_pronosticodiariolluvia_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodiariolluvia_campo_id ON pronosticos_pronosticodiariolluvia USING btree (campo_id);


--
-- Name: pronosticos_pronosticodiariolluvia_meteorologo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_pronosticodiariolluvia_meteorologo_id ON pronosticos_pronosticodiariolluvia USING btree (meteorologo_id);


--
-- Name: pronosticos_registrohorasfrio_e40f192a; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX pronosticos_registrohorasfrio_e40f192a ON pronosticos_registrohorasfrio USING btree (campo_id);


--
-- Name: push_notifications_apnsdevice_registration_id_like; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX push_notifications_apnsdevice_registration_id_like ON push_notifications_apnsdevice USING btree (registration_id varchar_pattern_ops);


--
-- Name: push_notifications_apnsdevice_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX push_notifications_apnsdevice_user_id ON push_notifications_apnsdevice USING btree (user_id);


--
-- Name: push_notifications_gcmdevice_user_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX push_notifications_gcmdevice_user_id ON push_notifications_gcmdevice USING btree (user_id);


--
-- Name: suscripciones_contrato_campos_campo_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_contrato_campos_campo_id ON suscripciones_contrato_campos USING btree (campo_id);


--
-- Name: suscripciones_contrato_campos_contrato_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_contrato_campos_contrato_id ON suscripciones_contrato_campos USING btree (contrato_id);


--
-- Name: suscripciones_contrato_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_contrato_empresa_id ON suscripciones_contrato USING btree (empresa_id);


--
-- Name: suscripciones_contrato_tipo_contrato_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_contrato_tipo_contrato_id ON suscripciones_contrato USING btree (tipo_contrato_id);


--
-- Name: suscripciones_factura_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_factura_empresa_id ON suscripciones_factura USING btree (empresa_id);


--
-- Name: suscripciones_referenciabancaria_empresa_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_referenciabancaria_empresa_id ON suscripciones_referenciabancaria USING btree (empresa_id);


--
-- Name: suscripciones_serviciomensual_contrato_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_serviciomensual_contrato_id ON suscripciones_serviciomensual USING btree (contrato_id);


--
-- Name: suscripciones_serviciomensual_factura_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX suscripciones_serviciomensual_factura_id ON suscripciones_serviciomensual USING btree (factura_id);


--
-- Name: ubicaciones_estado_geofence_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_estado_geofence_id ON ubicaciones_estado USING gist (geofence);


--
-- Name: ubicaciones_estado_pais_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_estado_pais_id ON ubicaciones_estado USING btree (pais_id);


--
-- Name: ubicaciones_municipio_estado_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_municipio_estado_id ON ubicaciones_municipio USING btree (estado_id);


--
-- Name: ubicaciones_municipio_geofence_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_municipio_geofence_id ON ubicaciones_municipio USING gist (geofence);


--
-- Name: ubicaciones_pais_geofence_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_pais_geofence_id ON ubicaciones_pais USING gist (geofence);


--
-- Name: ubicaciones_region_geofence_id; Type: INDEX; Schema: public; Owner: globalmet; Tablespace: 
--

CREATE INDEX ubicaciones_region_geofence_id ON ubicaciones_region USING gist (geofence);


--
-- Name: D164fb93560fa573a9ec003a9a5a9001; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_capturahorasfrio
    ADD CONSTRAINT "D164fb93560fa573a9ec003a9a5a9001" FOREIGN KEY (registro_id) REFERENCES pronosticos_registrohorasfrio(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: D9ff91f4161f46a302a87381a93ea499; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_asignacioncampo
    ADD CONSTRAINT "D9ff91f4161f46a302a87381a93ea499" FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_clientprofile_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_domicilio_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_domicilio
    ADD CONSTRAINT accounts_domicilio_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_meteorologoprofile_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_meteorologoprofile
    ADD CONSTRAINT accounts_meteorologoprofile_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_viewerprofile_cliente_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_viewerprofile
    ADD CONSTRAINT accounts_viewerprofile_cliente_id_fkey FOREIGN KEY (cliente_id) REFERENCES accounts_clientprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_viewerprofile_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_viewerprofile
    ADD CONSTRAINT accounts_viewerprofile_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_ac_correo_id_193552c02f964584_fk_alertas_avisocorreo_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_acuseenvioaviso
    ADD CONSTRAINT alertas_ac_correo_id_193552c02f964584_fk_alertas_avisocorreo_id FOREIGN KEY (correo_id) REFERENCES alertas_avisocorreo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_acuseenvioavis_user_id_3d605b18e294658f_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_acuseenvioaviso
    ADD CONSTRAINT alertas_acuseenvioavis_user_id_3d605b18e294658f_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_avisocorr_created_by_id_ef108e6575d34ca_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_avisocorreo
    ADD CONSTRAINT alertas_avisocorr_created_by_id_ef108e6575d34ca_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_condicionmeteorologica_campo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_condicionmeteorologica
    ADD CONSTRAINT alertas_condicionmeteorologica_campo_id_fkey FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_condicionmeteorologica_variable_meteorologica_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_condicionmeteorologica
    ADD CONSTRAINT alertas_condicionmeteorologica_variable_meteorologica_id_fkey FOREIGN KEY (variable_meteorologica_id) REFERENCES pronosticos_variablemeteorologica(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_evento_condicion_meteorologica_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_evento
    ADD CONSTRAINT alertas_evento_condicion_meteorologica_id_fkey FOREIGN KEY (condicion_meteorologica_id) REFERENCES alertas_condicionmeteorologica(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_notificacion_tipo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacion
    ADD CONSTRAINT alertas_notificacion_tipo_id_fkey FOREIGN KEY (tipo_id) REFERENCES alertas_tiponotificacion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_notificacion_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacion
    ADD CONSTRAINT alertas_notificacion_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_preferencianotificacion_tipos_tiponotificacion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_preferencianotificacion_tipos
    ADD CONSTRAINT alertas_preferencianotificacion_tipos_tiponotificacion_id_fkey FOREIGN KEY (tiponotificacion_id) REFERENCES alertas_tiponotificacion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: alertas_preferencianotificacion_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_preferencianotificacion
    ADD CONSTRAINT alertas_preferencianotificacion_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: authtoken_token_user_id_1d10c57f535fb363_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY authtoken_token
    ADD CONSTRAINT authtoken_token_user_id_1d10c57f535fb363_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: banners_anu_region_id_3ae883a16fd6205a_fk_ubicaciones_region_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_anuncio_regiones
    ADD CONSTRAINT banners_anu_region_id_3ae883a16fd6205a_fk_ubicaciones_region_id FOREIGN KEY (region_id) REFERENCES ubicaciones_region(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: banners_anunc_anuncio_id_5785225d82b794f0_fk_banners_anuncio_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_anuncio_regiones
    ADD CONSTRAINT banners_anunc_anuncio_id_5785225d82b794f0_fk_banners_anuncio_id FOREIGN KEY (anuncio_id) REFERENCES banners_anuncio(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: banners_reprod_anuncio_id_7baa58c6ecf45f5_fk_banners_anuncio_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_reproduccion
    ADD CONSTRAINT banners_reprod_anuncio_id_7baa58c6ecf45f5_fk_banners_anuncio_id FOREIGN KEY (anuncio_id) REFERENCES banners_anuncio(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: banners_reproduccion_user_id_301f8197542c98e4_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY banners_reproduccion
    ADD CONSTRAINT banners_reproduccion_user_id_301f8197542c98e4_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: bf3a1ab6235bd861de54fdaad2e6ade5; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_climatologiadia
    ADD CONSTRAINT bf3a1ab6235bd861de54fdaad2e6ade5 FOREIGN KEY (climatologia_id) REFERENCES pronosticos_climatologia(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: c2cc381ec69bf80ccce2202d816ebfc0; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo
    ADD CONSTRAINT c2cc381ec69bf80ccce2202d816ebfc0 FOREIGN KEY (climatologia_id) REFERENCES pronosticos_climatologia(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_2f7493c4; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodiariolluvia
    ADD CONSTRAINT campo_id_refs_id_2f7493c4 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_6caa2baf; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_usuarios
    ADD CONSTRAINT campo_id_refs_id_6caa2baf FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_9de82784; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_cultivos
    ADD CONSTRAINT campo_id_refs_id_9de82784 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_a713aa42; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_campoencola
    ADD CONSTRAINT campo_id_refs_id_a713aa42 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_b464b1e7; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticoclimatologico
    ADD CONSTRAINT campo_id_refs_id_b464b1e7 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_bfd5990b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato_campos
    ADD CONSTRAINT campo_id_refs_id_bfd5990b FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_cbda73e1; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticobase
    ADD CONSTRAINT campo_id_refs_id_cbda73e1 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_cf79cb5c; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusiongrafica
    ADD CONSTRAINT campo_id_refs_id_cf79cb5c FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_eca855cd; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusionmeteorologica
    ADD CONSTRAINT campo_id_refs_id_eca855cd FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campo_id_refs_id_f0bbd966; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY estaciones_estacion
    ADD CONSTRAINT campo_id_refs_id_f0bbd966 FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campoencola_id_refs_id_87caee4c; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_colacampos_campos
    ADD CONSTRAINT campoencola_id_refs_id_87caee4c FOREIGN KEY (campoencola_id) REFERENCES instancias_campoencola(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_asignacionc_campo_id_180b6650f1eb9205_fk_campos_campo_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_asignacioncampo
    ADD CONSTRAINT campos_asignacionc_campo_id_180b6650f1eb9205_fk_campos_campo_id FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_campo_cultivos_cultivo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_cultivos
    ADD CONSTRAINT campos_campo_cultivos_cultivo_id_fkey FOREIGN KEY (cultivo_id) REFERENCES campos_cultivo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_campo_empresa_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo
    ADD CONSTRAINT campos_campo_empresa_id_fkey FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_campo_meteorologo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo
    ADD CONSTRAINT campos_campo_meteorologo_id_fkey FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_campo_region_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo
    ADD CONSTRAINT campos_campo_region_id_fkey FOREIGN KEY (region_id) REFERENCES ubicaciones_region(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campos_cultivo_categoria_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_cultivo
    ADD CONSTRAINT campos_cultivo_categoria_id_fkey FOREIGN KEY (categoria_id) REFERENCES campos_categoriacultivo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: cliente_id_refs_id_01257530; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_empresa
    ADD CONSTRAINT cliente_id_refs_id_01257530 FOREIGN KEY (cliente_id) REFERENCES accounts_clientprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: colacampos_id_refs_id_6e3b1496; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY instancias_colacampos_campos
    ADD CONSTRAINT colacampos_id_refs_id_6e3b1496 FOREIGN KEY (colacampos_id) REFERENCES instancias_colacampos(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: content_type_id_refs_id_d043b34a; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT content_type_id_refs_id_d043b34a FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: contrato_id_refs_id_18b68f26; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato_campos
    ADD CONSTRAINT contrato_id_refs_id_18b68f26 FOREIGN KEY (contrato_id) REFERENCES suscripciones_contrato(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: df4204ac730a13f9d23f2a870cee2166; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY divemex_unidadesfotoperm_campos
    ADD CONSTRAINT df4204ac730a13f9d23f2a870cee2166 FOREIGN KEY (unidadesfotoperm_id) REFERENCES divemex_unidadesfotoperm(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: discusion_id_refs_id_04734f8a; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_discusiondiaria
    ADD CONSTRAINT discusion_id_refs_id_04734f8a FOREIGN KEY (discusion_id) REFERENCES pronosticos_discusionmeteorologica(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: divemex_unidadesfot_campo_id_a940838398817e6_fk_campos_campo_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY divemex_unidadesfotoperm_campos
    ADD CONSTRAINT divemex_unidadesfot_campo_id_a940838398817e6_fk_campos_campo_id FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: djcelery_periodictask_crontab_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_periodictask
    ADD CONSTRAINT djcelery_periodictask_crontab_id_fkey FOREIGN KEY (crontab_id) REFERENCES djcelery_crontabschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: djcelery_periodictask_interval_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_periodictask
    ADD CONSTRAINT djcelery_periodictask_interval_id_fkey FOREIGN KEY (interval_id) REFERENCES djcelery_intervalschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: djcelery_taskstate_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY djcelery_taskstate
    ADD CONSTRAINT djcelery_taskstate_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES djcelery_workerstate(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: easy_thumbnails_thumbnail_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_thumbnail_source_id_fkey FOREIGN KEY (source_id) REFERENCES easy_thumbnails_source(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_070c4cc3; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato
    ADD CONSTRAINT empresa_id_refs_id_070c4cc3 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_1fb56813; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_anotacion
    ADD CONSTRAINT empresa_id_refs_id_1fb56813 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_3d91c348; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_factura
    ADD CONSTRAINT empresa_id_refs_id_3d91c348 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_62620578; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_correocontacto
    ADD CONSTRAINT empresa_id_refs_id_62620578 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_8ce4b612; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_datocontacto
    ADD CONSTRAINT empresa_id_refs_id_8ce4b612 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_9b2ddfb5; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pagos_pago
    ADD CONSTRAINT empresa_id_refs_id_9b2ddfb5 FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresa_id_refs_id_f744035c; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_referenciabancaria
    ADD CONSTRAINT empresa_id_refs_id_f744035c FOREIGN KEY (empresa_id) REFERENCES empresas_empresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresas_datosfacturacion_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_datosfacturacion
    ADD CONSTRAINT empresas_datosfacturacion_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: empresas_empresa_categoria_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY empresas_empresa
    ADD CONSTRAINT empresas_empresa_categoria_id_fkey FOREIGN KEY (categoria_id) REFERENCES empresas_categoriaempresa(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: evento_id_refs_id_32eedfab; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacion
    ADD CONSTRAINT evento_id_refs_id_32eedfab FOREIGN KEY (evento_id) REFERENCES alertas_evento(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: factura_id_refs_id_c640394c; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_serviciomensual
    ADD CONSTRAINT factura_id_refs_id_c640394c FOREIGN KEY (factura_id) REFERENCES suscripciones_factura(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: factura_id_refs_id_f92e36fb; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_acuserecibofactura
    ADD CONSTRAINT factura_id_refs_id_f92e36fb FOREIGN KEY (factura_id) REFERENCES suscripciones_factura(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_id_refs_id_f4b32aac; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT group_id_refs_id_f4b32aac FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_groupobjectpermission_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_groupobjectpermission_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_groupobjectpermission_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_userobjectpermission_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_userobjectpermission_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: guardian_userobjectpermission_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: historiales_historialmeteorologocampo_campo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY historiales_historialmeteorologocampo
    ADD CONSTRAINT historiales_historialmeteorologocampo_campo_id_fkey FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: historiales_historialmeteorologocampo_meteorologo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY historiales_historialmeteorologocampo
    ADD CONSTRAINT historiales_historialmeteorologocampo_meteorologo_id_fkey FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: meteorologo_id_refs_id_1de54e3b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticoclimatologico
    ADD CONSTRAINT meteorologo_id_refs_id_1de54e3b FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: meteorologo_id_refs_id_6871bd3f; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticobase
    ADD CONSTRAINT meteorologo_id_refs_id_6871bd3f FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: meteorologo_id_refs_id_cdc6db2b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodiariolluvia
    ADD CONSTRAINT meteorologo_id_refs_id_cdc6db2b FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: preferencianotificacion_id_refs_id_c412ae66; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_preferencianotificacion_tipos
    ADD CONSTRAINT preferencianotificacion_id_refs_id_c412ae66 FOREIGN KEY (preferencianotificacion_id) REFERENCES alertas_preferencianotificacion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: pronosticos_pronostico_campo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronostico
    ADD CONSTRAINT pronosticos_pronostico_campo_id_fkey FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: pronosticos_pronostico_meteorologo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronostico
    ADD CONSTRAINT pronosticos_pronostico_meteorologo_id_fkey FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: pronosticos_pronosticodia_campo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodia
    ADD CONSTRAINT pronosticos_pronosticodia_campo_id_fkey FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: pronosticos_pronosticodia_meteorologo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticodia
    ADD CONSTRAINT pronosticos_pronosticodia_meteorologo_id_fkey FOREIGN KEY (meteorologo_id) REFERENCES accounts_meteorologoprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: pronosticos_regist_campo_id_6b257ade7b629ef8_fk_campos_campo_id; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_registrohorasfrio
    ADD CONSTRAINT pronosticos_regist_campo_id_6b257ade7b629ef8_fk_campos_campo_id FOREIGN KEY (campo_id) REFERENCES campos_campo(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: prospecto_id_refs_id_03e7e84b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY clientes_historialprospeccion
    ADD CONSTRAINT prospecto_id_refs_id_03e7e84b FOREIGN KEY (prospecto_id) REFERENCES clientes_prospecto(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: prospecto_id_refs_id_c8f40776; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY clientes_comentario
    ADD CONSTRAINT prospecto_id_refs_id_c8f40776 FOREIGN KEY (prospecto_id) REFERENCES clientes_prospecto(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: tipo_contrato_id_refs_id_108bcc82; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY suscripciones_contrato
    ADD CONSTRAINT tipo_contrato_id_refs_id_108bcc82 FOREIGN KEY (tipo_contrato_id) REFERENCES suscripciones_tipocontrato(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: tipo_id_refs_id_2fe8684b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacionpersonalizada
    ADD CONSTRAINT tipo_id_refs_id_2fe8684b FOREIGN KEY (tipo_id) REFERENCES alertas_tiponotificacion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: ubicaciones_estado_pais_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_estado
    ADD CONSTRAINT ubicaciones_estado_pais_id_fkey FOREIGN KEY (pais_id) REFERENCES ubicaciones_pais(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: ubicaciones_municipio_estado_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY ubicaciones_municipio
    ADD CONSTRAINT ubicaciones_municipio_estado_id_fkey FOREIGN KEY (estado_id) REFERENCES ubicaciones_estado(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_0219cc06; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY accounts_accountsignup
    ADD CONSTRAINT user_id_refs_id_0219cc06 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_40c41112; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT user_id_refs_id_40c41112 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_458a85ba; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY push_notifications_apnsdevice
    ADD CONSTRAINT user_id_refs_id_458a85ba FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_4dc23c39; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT user_id_refs_id_4dc23c39 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_4e285096; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY alertas_notificacionpersonalizada
    ADD CONSTRAINT user_id_refs_id_4e285096 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_6f1a328a; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY preferencias_preferenciasunidades
    ADD CONSTRAINT user_id_refs_id_6f1a328a FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_ae20e205; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY push_notifications_gcmdevice
    ADD CONSTRAINT user_id_refs_id_ae20e205 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_e5b6b81b; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY campos_campo_usuarios
    ADD CONSTRAINT user_id_refs_id_e5b6b81b FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_id_refs_id_f2d29f89; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY dispositivos_dispositivo
    ADD CONSTRAINT user_id_refs_id_f2d29f89 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: userena_userenasignup_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY userena_userenasignup
    ADD CONSTRAINT userena_userenasignup_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: usuario_id_refs_id_2edbd359; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY encuestas_encuestasatisfacciontoken
    ADD CONSTRAINT usuario_id_refs_id_2edbd359 FOREIGN KEY (usuario_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: usuario_id_refs_id_821bbd1c; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY encuestas_encuestasatisfaccionrecomendacion
    ADD CONSTRAINT usuario_id_refs_id_821bbd1c FOREIGN KEY (usuario_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: usuario_id_refs_id_c42cda7d; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY preferencias_preferenciasresumendiario
    ADD CONSTRAINT usuario_id_refs_id_c42cda7d FOREIGN KEY (usuario_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: variable_meteorologica_id_refs_id_56cefc49; Type: FK CONSTRAINT; Schema: public; Owner: globalmet
--

ALTER TABLE ONLY pronosticos_pronosticobase
    ADD CONSTRAINT variable_meteorologica_id_refs_id_56cefc49 FOREIGN KEY (variable_meteorologica_id) REFERENCES pronosticos_variablemeteorologica(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: campos_campo; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE campos_campo FROM PUBLIC;
REVOKE ALL ON TABLE campos_campo FROM globalmet;
GRANT ALL ON TABLE campos_campo TO globalmet;
GRANT SELECT ON TABLE campos_campo TO grupocerritos;


--
-- Name: pronosticos_capturahorasfrio; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_capturahorasfrio FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_capturahorasfrio FROM globalmet;
GRANT ALL ON TABLE pronosticos_capturahorasfrio TO globalmet;
GRANT SELECT ON TABLE pronosticos_capturahorasfrio TO grupocerritos;


--
-- Name: pronosticos_discusiondiaria; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_discusiondiaria FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_discusiondiaria FROM globalmet;
GRANT ALL ON TABLE pronosticos_discusiondiaria TO globalmet;
GRANT SELECT ON TABLE pronosticos_discusiondiaria TO grupocerritos;


--
-- Name: pronosticos_discusiongrafica; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_discusiongrafica FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_discusiongrafica FROM globalmet;
GRANT ALL ON TABLE pronosticos_discusiongrafica TO globalmet;
GRANT SELECT ON TABLE pronosticos_discusiongrafica TO grupocerritos;


--
-- Name: pronosticos_discusionmeteorologica; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_discusionmeteorologica FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_discusionmeteorologica FROM globalmet;
GRANT ALL ON TABLE pronosticos_discusionmeteorologica TO globalmet;
GRANT SELECT ON TABLE pronosticos_discusionmeteorologica TO grupocerritos;


--
-- Name: pronosticos_pronostico; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_pronostico FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_pronostico FROM globalmet;
GRANT ALL ON TABLE pronosticos_pronostico TO globalmet;
GRANT SELECT ON TABLE pronosticos_pronostico TO grupocerritos;


--
-- Name: pronosticos_pronosticobase; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_pronosticobase FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_pronosticobase FROM globalmet;
GRANT ALL ON TABLE pronosticos_pronosticobase TO globalmet;
GRANT SELECT ON TABLE pronosticos_pronosticobase TO grupocerritos;


--
-- Name: pronosticos_pronosticoclimatologico; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_pronosticoclimatologico FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_pronosticoclimatologico FROM globalmet;
GRANT ALL ON TABLE pronosticos_pronosticoclimatologico TO globalmet;
GRANT SELECT ON TABLE pronosticos_pronosticoclimatologico TO grupocerritos;


--
-- Name: pronosticos_pronosticodia; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_pronosticodia FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_pronosticodia FROM globalmet;
GRANT ALL ON TABLE pronosticos_pronosticodia TO globalmet;
GRANT SELECT ON TABLE pronosticos_pronosticodia TO grupocerritos;


--
-- Name: pronosticos_pronosticodiariolluvia; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_pronosticodiariolluvia FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_pronosticodiariolluvia FROM globalmet;
GRANT ALL ON TABLE pronosticos_pronosticodiariolluvia TO globalmet;
GRANT SELECT ON TABLE pronosticos_pronosticodiariolluvia TO grupocerritos;


--
-- Name: pronosticos_registrohorasfrio; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_registrohorasfrio FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_registrohorasfrio FROM globalmet;
GRANT ALL ON TABLE pronosticos_registrohorasfrio TO globalmet;
GRANT SELECT ON TABLE pronosticos_registrohorasfrio TO grupocerritos;


--
-- Name: pronosticos_tip; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_tip FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_tip FROM globalmet;
GRANT ALL ON TABLE pronosticos_tip TO globalmet;
GRANT SELECT ON TABLE pronosticos_tip TO grupocerritos;


--
-- Name: pronosticos_variablemeteorologica; Type: ACL; Schema: public; Owner: globalmet
--

REVOKE ALL ON TABLE pronosticos_variablemeteorologica FROM PUBLIC;
REVOKE ALL ON TABLE pronosticos_variablemeteorologica FROM globalmet;
GRANT ALL ON TABLE pronosticos_variablemeteorologica TO globalmet;
GRANT SELECT ON TABLE pronosticos_variablemeteorologica TO grupocerritos;


--
-- PostgreSQL database dump complete
--