| -- |
| -- PostgreSQL database dump |
| -- |
| |
| SET statement_timeout = 0; |
| SET lock_timeout = 0; |
| SET client_encoding = 'SQL_ASCII'; |
| SET standard_conforming_strings = on; |
| SET check_function_bodies = false; |
| SET client_min_messages = warning; |
| |
| -- |
| -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: |
| -- |
| |
| CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; |
| |
| |
| -- |
| -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: |
| -- |
| |
| COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; |
| |
| |
| SET search_path = public, pg_catalog; |
| |
| SET default_tablespace = ''; |
| |
| SET default_with_oids = false; |
| |
| -- |
| -- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE auth_group ( |
| id integer NOT NULL, |
| name character varying(80) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.auth_group OWNER TO postgres; |
| |
| -- |
| -- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id; |
| |
| |
| -- |
| -- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; |
| |
| -- |
| -- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id; |
| |
| |
| -- |
| -- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; |
| |
| -- |
| -- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id; |
| |
| |
| -- |
| -- Name: core_account; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_account ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_account OWNER TO postgres; |
| |
| -- |
| -- Name: core_account_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_account_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_account_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_account_id_seq OWNED BY core_account.id; |
| |
| |
| -- |
| -- Name: core_charge; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_charge ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| kind character varying(30) NOT NULL, |
| state character varying(30) NOT NULL, |
| date timestamp with time zone NOT NULL, |
| amount double precision NOT NULL, |
| "coreHours" double precision NOT NULL, |
| account_id integer NOT NULL, |
| invoice_id integer, |
| object_id integer NOT NULL, |
| slice_id integer |
| ); |
| |
| |
| ALTER TABLE public.core_charge OWNER TO postgres; |
| |
| -- |
| -- Name: core_charge_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_charge_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_charge_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_charge_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_charge_id_seq OWNED BY core_charge.id; |
| |
| |
| -- |
| -- Name: core_controller; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controller ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL, |
| backend_type character varying(200) NOT NULL, |
| version character varying(200) NOT NULL, |
| auth_url character varying(200), |
| admin_user character varying(200), |
| admin_password character varying(200), |
| admin_tenant character varying(200), |
| domain character varying(200), |
| deployment_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controller OWNER TO postgres; |
| |
| -- |
| -- Name: core_controller_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controller_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controller_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controller_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controller_id_seq OWNED BY core_controller.id; |
| |
| |
| -- |
| -- Name: core_controllercredential; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllercredential ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| key_id character varying(1024) NOT NULL, |
| enc_value text NOT NULL, |
| controller_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllercredential OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllercredential_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllercredential_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllercredential_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllercredential_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllercredential_id_seq OWNED BY core_controllercredential.id; |
| |
| |
| -- |
| -- Name: core_controllerdashboardview; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllerdashboardview ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| enabled boolean NOT NULL, |
| url character varying(1024) NOT NULL, |
| controller_id integer NOT NULL, |
| "dashboardView_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllerdashboardview OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerdashboardview_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllerdashboardview_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllerdashboardview_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerdashboardview_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllerdashboardview_id_seq OWNED BY core_controllerdashboardview.id; |
| |
| |
| -- |
| -- Name: core_controllerimages; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllerimages ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| glance_image_id character varying(200), |
| controller_id integer NOT NULL, |
| image_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllerimages OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerimages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllerimages_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllerimages_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerimages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllerimages_id_seq OWNED BY core_controllerimages.id; |
| |
| |
| -- |
| -- Name: core_controllernetwork; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllernetwork ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| net_id character varying(256), |
| router_id character varying(256), |
| subnet_id character varying(256), |
| subnet character varying(32) NOT NULL, |
| controller_id integer NOT NULL, |
| network_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllernetwork OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllernetwork_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllernetwork_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllernetwork_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllernetwork_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllernetwork_id_seq OWNED BY core_controllernetwork.id; |
| |
| |
| -- |
| -- Name: core_controllerrole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllerrole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllerrole OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerrole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllerrole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllerrole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerrole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllerrole_id_seq OWNED BY core_controllerrole.id; |
| |
| |
| -- |
| -- Name: core_controllersite; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllersite ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| tenant_id character varying(200), |
| controller_id integer, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllersite OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersite_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllersite_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllersite_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersite_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllersite_id_seq OWNED BY core_controllersite.id; |
| |
| |
| -- |
| -- Name: core_controllersiteprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllersiteprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id character varying(200), |
| controller_id integer NOT NULL, |
| site_privilege_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllersiteprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersiteprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllersiteprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllersiteprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersiteprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllersiteprivilege_id_seq OWNED BY core_controllersiteprivilege.id; |
| |
| |
| -- |
| -- Name: core_controllerslice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllerslice ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| tenant_id character varying(200), |
| controller_id integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllerslice OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerslice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllerslice_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllerslice_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllerslice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllerslice_id_seq OWNED BY core_controllerslice.id; |
| |
| |
| -- |
| -- Name: core_controllersliceprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controllersliceprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id character varying(200), |
| controller_id integer NOT NULL, |
| slice_privilege_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controllersliceprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersliceprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controllersliceprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controllersliceprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controllersliceprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controllersliceprivilege_id_seq OWNED BY core_controllersliceprivilege.id; |
| |
| |
| -- |
| -- Name: core_controlleruser; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_controlleruser ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| kuser_id character varying(200), |
| controller_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_controlleruser OWNER TO postgres; |
| |
| -- |
| -- Name: core_controlleruser_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_controlleruser_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_controlleruser_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_controlleruser_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_controlleruser_id_seq OWNED BY core_controlleruser.id; |
| |
| |
| -- |
| -- Name: core_dashboardview; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_dashboardview ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL, |
| url character varying(1024) NOT NULL, |
| enabled boolean NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_dashboardview OWNER TO postgres; |
| |
| -- |
| -- Name: core_dashboardview_deployments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_dashboardview_deployments ( |
| id integer NOT NULL, |
| dashboardview_id integer NOT NULL, |
| deployment_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_dashboardview_deployments OWNER TO postgres; |
| |
| -- |
| -- Name: core_dashboardview_deployments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_dashboardview_deployments_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_dashboardview_deployments_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_dashboardview_deployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_dashboardview_deployments_id_seq OWNED BY core_dashboardview_deployments.id; |
| |
| |
| -- |
| -- Name: core_dashboardview_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_dashboardview_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_dashboardview_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_dashboardview_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_dashboardview_id_seq OWNED BY core_dashboardview.id; |
| |
| |
| -- |
| -- Name: core_deployment; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_deployment ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL, |
| "accessControl" text NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_deployment OWNER TO postgres; |
| |
| -- |
| -- Name: core_deployment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_deployment_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_deployment_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_deployment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_deployment_id_seq OWNED BY core_deployment.id; |
| |
| |
| -- |
| -- Name: core_deploymentprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_deploymentprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| deployment_id integer NOT NULL, |
| role_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_deploymentprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_deploymentprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_deploymentprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_deploymentprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_deploymentprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_deploymentprivilege_id_seq OWNED BY core_deploymentprivilege.id; |
| |
| |
| -- |
| -- Name: core_deploymentrole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_deploymentrole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_deploymentrole OWNER TO postgres; |
| |
| -- |
| -- Name: core_deploymentrole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_deploymentrole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_deploymentrole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_deploymentrole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_deploymentrole_id_seq OWNED BY core_deploymentrole.id; |
| |
| |
| -- |
| -- Name: core_flavor; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_flavor ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| description character varying(1024), |
| flavor character varying(32) NOT NULL, |
| "order" integer NOT NULL, |
| "default" boolean NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_flavor OWNER TO postgres; |
| |
| -- |
| -- Name: core_flavor_deployments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_flavor_deployments ( |
| id integer NOT NULL, |
| flavor_id integer NOT NULL, |
| deployment_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_flavor_deployments OWNER TO postgres; |
| |
| -- |
| -- Name: core_flavor_deployments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_flavor_deployments_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_flavor_deployments_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_flavor_deployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_flavor_deployments_id_seq OWNED BY core_flavor_deployments.id; |
| |
| |
| -- |
| -- Name: core_flavor_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_flavor_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_flavor_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_flavor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_flavor_id_seq OWNED BY core_flavor.id; |
| |
| |
| -- |
| -- Name: core_image; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_image ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(256) NOT NULL, |
| disk_format character varying(256) NOT NULL, |
| container_format character varying(256) NOT NULL, |
| path character varying(256) |
| ); |
| |
| |
| ALTER TABLE public.core_image OWNER TO postgres; |
| |
| -- |
| -- Name: core_image_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_image_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_image_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_image_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_image_id_seq OWNED BY core_image.id; |
| |
| |
| -- |
| -- Name: core_imagedeployments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_imagedeployments ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| deployment_id integer NOT NULL, |
| image_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_imagedeployments OWNER TO postgres; |
| |
| -- |
| -- Name: core_imagedeployments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_imagedeployments_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_imagedeployments_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_imagedeployments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_imagedeployments_id_seq OWNED BY core_imagedeployments.id; |
| |
| |
| -- |
| -- Name: core_instance; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_instance ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| instance_id character varying(200), |
| instance_uuid character varying(200), |
| name character varying(200) NOT NULL, |
| instance_name character varying(200), |
| ip inet, |
| "numberCores" integer NOT NULL, |
| "userData" text, |
| creator_id integer, |
| deployment_id integer NOT NULL, |
| flavor_id integer NOT NULL, |
| image_id integer NOT NULL, |
| node_id integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_instance OWNER TO postgres; |
| |
| -- |
| -- Name: core_instance_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_instance_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_instance_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_instance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_instance_id_seq OWNED BY core_instance.id; |
| |
| |
| -- |
| -- Name: core_invoice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_invoice ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| date timestamp with time zone NOT NULL, |
| account_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_invoice OWNER TO postgres; |
| |
| -- |
| -- Name: core_invoice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_invoice_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_invoice_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_invoice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_invoice_id_seq OWNED BY core_invoice.id; |
| |
| |
| -- |
| -- Name: core_network; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_network ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| subnet character varying(32) NOT NULL, |
| ports character varying(1024), |
| labels character varying(1024), |
| guaranteed_bandwidth integer NOT NULL, |
| permit_all_slices boolean NOT NULL, |
| topology_parameters text, |
| controller_url character varying(1024), |
| controller_parameters text, |
| network_id character varying(256), |
| router_id character varying(256), |
| subnet_id character varying(256), |
| autoconnect boolean NOT NULL, |
| owner_id integer NOT NULL, |
| template_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_network OWNER TO postgres; |
| |
| -- |
| -- Name: core_network_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_network_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_network_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_network_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_network_id_seq OWNED BY core_network.id; |
| |
| |
| -- |
| -- Name: core_network_permitted_slices; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_network_permitted_slices ( |
| id integer NOT NULL, |
| network_id integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_network_permitted_slices OWNER TO postgres; |
| |
| -- |
| -- Name: core_network_permitted_slices_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_network_permitted_slices_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_network_permitted_slices_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_network_permitted_slices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_network_permitted_slices_id_seq OWNED BY core_network_permitted_slices.id; |
| |
| |
| -- |
| -- Name: core_networkparameter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_networkparameter ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| value character varying(1024) NOT NULL, |
| object_id integer NOT NULL, |
| content_type_id integer NOT NULL, |
| parameter_id integer NOT NULL, |
| CONSTRAINT core_networkparameter_object_id_check CHECK ((object_id >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.core_networkparameter OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkparameter_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_networkparameter_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_networkparameter_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkparameter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_networkparameter_id_seq OWNED BY core_networkparameter.id; |
| |
| |
| -- |
| -- Name: core_networkparametertype; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_networkparametertype ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| description character varying(1024) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_networkparametertype OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkparametertype_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_networkparametertype_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_networkparametertype_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkparametertype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_networkparametertype_id_seq OWNED BY core_networkparametertype.id; |
| |
| |
| -- |
| -- Name: core_networkslice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_networkslice ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| network_id integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_networkslice OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkslice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_networkslice_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_networkslice_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_networkslice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_networkslice_id_seq OWNED BY core_networkslice.id; |
| |
| |
| -- |
| -- Name: core_networktemplate; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_networktemplate ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| description character varying(1024), |
| guaranteed_bandwidth integer NOT NULL, |
| visibility character varying(30) NOT NULL, |
| translation character varying(30) NOT NULL, |
| shared_network_name character varying(30), |
| shared_network_id character varying(256), |
| topology_kind character varying(30) NOT NULL, |
| controller_kind character varying(30) |
| ); |
| |
| |
| ALTER TABLE public.core_networktemplate OWNER TO postgres; |
| |
| -- |
| -- Name: core_networktemplate_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_networktemplate_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_networktemplate_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_networktemplate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_networktemplate_id_seq OWNED BY core_networktemplate.id; |
| |
| |
| -- |
| -- Name: core_node; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_node ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL, |
| site_id integer, |
| site_deployment_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_node OWNER TO postgres; |
| |
| -- |
| -- Name: core_node_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_node_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_node_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_node_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_node_id_seq OWNED BY core_node.id; |
| |
| |
| -- |
| -- Name: core_payment; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_payment ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| amount double precision NOT NULL, |
| date timestamp with time zone NOT NULL, |
| account_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_payment OWNER TO postgres; |
| |
| -- |
| -- Name: core_payment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_payment_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_payment_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_payment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_payment_id_seq OWNED BY core_payment.id; |
| |
| |
| -- |
| -- Name: core_port; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_port ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| ip inet, |
| port_id character varying(256), |
| mac character varying(256), |
| instance_id integer, |
| network_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_port OWNER TO postgres; |
| |
| -- |
| -- Name: core_port_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_port_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_port_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_port_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_port_id_seq OWNED BY core_port.id; |
| |
| |
| -- |
| -- Name: core_program; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_program ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(30) NOT NULL, |
| description text, |
| kind character varying(30) NOT NULL, |
| command character varying(30), |
| contents text, |
| output text, |
| messages text, |
| status text, |
| owner_id integer |
| ); |
| |
| |
| ALTER TABLE public.core_program OWNER TO postgres; |
| |
| -- |
| -- Name: core_program_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_program_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_program_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_program_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_program_id_seq OWNED BY core_program.id; |
| |
| |
| -- |
| -- Name: core_project; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_project ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_project OWNER TO postgres; |
| |
| -- |
| -- Name: core_project_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_project_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_project_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_project_id_seq OWNED BY core_project.id; |
| |
| |
| -- |
| -- Name: core_reservation; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_reservation ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| "startTime" timestamp with time zone NOT NULL, |
| duration integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_reservation OWNER TO postgres; |
| |
| -- |
| -- Name: core_reservation_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_reservation_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_reservation_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_reservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_reservation_id_seq OWNED BY core_reservation.id; |
| |
| |
| -- |
| -- Name: core_reservedresource; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_reservedresource ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| quantity integer NOT NULL, |
| instance_id integer NOT NULL, |
| "reservationSet_id" integer NOT NULL, |
| resource_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_reservedresource OWNER TO postgres; |
| |
| -- |
| -- Name: core_reservedresource_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_reservedresource_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_reservedresource_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_reservedresource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_reservedresource_id_seq OWNED BY core_reservedresource.id; |
| |
| |
| -- |
| -- Name: core_role; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_role ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_type character varying(80) NOT NULL, |
| role character varying(80), |
| description character varying(120) NOT NULL, |
| content_type_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_role OWNER TO postgres; |
| |
| -- |
| -- Name: core_role_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_role_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_role_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_role_id_seq OWNED BY core_role.id; |
| |
| |
| -- |
| -- Name: core_router; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_router ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| owner_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_router OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_router_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_router_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_router_id_seq OWNED BY core_router.id; |
| |
| |
| -- |
| -- Name: core_router_networks; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_router_networks ( |
| id integer NOT NULL, |
| router_id integer NOT NULL, |
| network_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_router_networks OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_networks_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_router_networks_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_router_networks_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_networks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_router_networks_id_seq OWNED BY core_router_networks.id; |
| |
| |
| -- |
| -- Name: core_router_permittedNetworks; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE "core_router_permittedNetworks" ( |
| id integer NOT NULL, |
| router_id integer NOT NULL, |
| network_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public."core_router_permittedNetworks" OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_permittedNetworks_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE "core_router_permittedNetworks_id_seq" |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public."core_router_permittedNetworks_id_seq" OWNER TO postgres; |
| |
| -- |
| -- Name: core_router_permittedNetworks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE "core_router_permittedNetworks_id_seq" OWNED BY "core_router_permittedNetworks".id; |
| |
| |
| -- |
| -- Name: core_service; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_service ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| description text, |
| enabled boolean NOT NULL, |
| kind character varying(30) NOT NULL, |
| name character varying(30) NOT NULL, |
| "versionNumber" character varying(30) NOT NULL, |
| published boolean NOT NULL, |
| view_url character varying(1024), |
| icon_url character varying(1024), |
| public_key text, |
| service_specific_id character varying(30), |
| service_specific_attribute text |
| ); |
| |
| |
| ALTER TABLE public.core_service OWNER TO postgres; |
| |
| -- |
| -- Name: core_service_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_service_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_service_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_service_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_service_id_seq OWNED BY core_service.id; |
| |
| |
| -- |
| -- Name: core_serviceattribute; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_serviceattribute ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| value character varying(1024) NOT NULL, |
| service_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_serviceattribute OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceattribute_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_serviceattribute_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_serviceattribute_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceattribute_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_serviceattribute_id_seq OWNED BY core_serviceattribute.id; |
| |
| |
| -- |
| -- Name: core_serviceclass; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_serviceclass ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| description character varying(255) NOT NULL, |
| commitment integer NOT NULL, |
| "membershipFee" integer NOT NULL, |
| "membershipFeeMonths" integer NOT NULL, |
| "upgradeRequiresApproval" boolean NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_serviceclass OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceclass_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_serviceclass_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_serviceclass_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_serviceclass_id_seq OWNED BY core_serviceclass.id; |
| |
| |
| -- |
| -- Name: core_serviceclass_upgradeFrom; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE "core_serviceclass_upgradeFrom" ( |
| id integer NOT NULL, |
| from_serviceclass_id integer NOT NULL, |
| to_serviceclass_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public."core_serviceclass_upgradeFrom" OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceclass_upgradeFrom_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE "core_serviceclass_upgradeFrom_id_seq" |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public."core_serviceclass_upgradeFrom_id_seq" OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceclass_upgradeFrom_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE "core_serviceclass_upgradeFrom_id_seq" OWNED BY "core_serviceclass_upgradeFrom".id; |
| |
| |
| -- |
| -- Name: core_serviceprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_serviceprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id integer NOT NULL, |
| service_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_serviceprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_serviceprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_serviceprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_serviceprivilege_id_seq OWNED BY core_serviceprivilege.id; |
| |
| |
| -- |
| -- Name: core_serviceresource; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_serviceresource ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(32) NOT NULL, |
| "maxUnitsDeployment" integer NOT NULL, |
| "maxUnitsNode" integer NOT NULL, |
| "maxDuration" integer NOT NULL, |
| "bucketInRate" integer NOT NULL, |
| "bucketMaxSize" integer NOT NULL, |
| cost integer NOT NULL, |
| "calendarReservable" boolean NOT NULL, |
| "serviceClass_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_serviceresource OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceresource_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_serviceresource_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_serviceresource_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_serviceresource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_serviceresource_id_seq OWNED BY core_serviceresource.id; |
| |
| |
| -- |
| -- Name: core_servicerole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_servicerole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_servicerole OWNER TO postgres; |
| |
| -- |
| -- Name: core_servicerole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_servicerole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_servicerole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_servicerole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_servicerole_id_seq OWNED BY core_servicerole.id; |
| |
| |
| -- |
| -- Name: core_site; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_site ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(200) NOT NULL, |
| site_url character varying(512), |
| enabled boolean NOT NULL, |
| hosts_nodes boolean NOT NULL, |
| hosts_users boolean NOT NULL, |
| location character varying(42) NOT NULL, |
| longitude double precision, |
| latitude double precision, |
| login_base character varying(50) NOT NULL, |
| is_public boolean NOT NULL, |
| abbreviated_name character varying(80) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_site OWNER TO postgres; |
| |
| -- |
| -- Name: core_site_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_site_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_site_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_site_id_seq OWNED BY core_site.id; |
| |
| |
| -- |
| -- Name: core_sitecredential; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_sitecredential ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| key_id character varying(1024) NOT NULL, |
| enc_value text NOT NULL, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_sitecredential OWNER TO postgres; |
| |
| -- |
| -- Name: core_sitecredential_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_sitecredential_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_sitecredential_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_sitecredential_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_sitecredential_id_seq OWNED BY core_sitecredential.id; |
| |
| |
| -- |
| -- Name: core_sitedeployment; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_sitedeployment ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| availability_zone character varying(200), |
| controller_id integer, |
| deployment_id integer NOT NULL, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_sitedeployment OWNER TO postgres; |
| |
| -- |
| -- Name: core_sitedeployment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_sitedeployment_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_sitedeployment_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_sitedeployment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_sitedeployment_id_seq OWNED BY core_sitedeployment.id; |
| |
| |
| -- |
| -- Name: core_siteprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_siteprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id integer NOT NULL, |
| site_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_siteprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_siteprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_siteprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_siteprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_siteprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_siteprivilege_id_seq OWNED BY core_siteprivilege.id; |
| |
| |
| -- |
| -- Name: core_siterole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_siterole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_siterole OWNER TO postgres; |
| |
| -- |
| -- Name: core_siterole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_siterole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_siterole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_siterole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_siterole_id_seq OWNED BY core_siterole.id; |
| |
| |
| -- |
| -- Name: core_slice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_slice ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(80) NOT NULL, |
| enabled boolean NOT NULL, |
| omf_friendly boolean NOT NULL, |
| description text NOT NULL, |
| slice_url character varying(512) NOT NULL, |
| max_instances integer NOT NULL, |
| network character varying(256), |
| mount_data_sets character varying(256), |
| creator_id integer, |
| default_flavor_id integer, |
| default_image_id integer, |
| service_id integer, |
| "serviceClass_id" integer, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_slice OWNER TO postgres; |
| |
| -- |
| -- Name: core_slice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_slice_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_slice_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_slice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_slice_id_seq OWNED BY core_slice.id; |
| |
| |
| -- |
| -- Name: core_slicecredential; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_slicecredential ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| key_id character varying(1024) NOT NULL, |
| enc_value text NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_slicecredential OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicecredential_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_slicecredential_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_slicecredential_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicecredential_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_slicecredential_id_seq OWNED BY core_slicecredential.id; |
| |
| |
| -- |
| -- Name: core_sliceprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_sliceprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id integer NOT NULL, |
| slice_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_sliceprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_sliceprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_sliceprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_sliceprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_sliceprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_sliceprivilege_id_seq OWNED BY core_sliceprivilege.id; |
| |
| |
| -- |
| -- Name: core_slicerole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_slicerole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_slicerole OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicerole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_slicerole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_slicerole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicerole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_slicerole_id_seq OWNED BY core_slicerole.id; |
| |
| |
| -- |
| -- Name: core_slicetag; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_slicetag ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(30) NOT NULL, |
| value character varying(1024) NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_slicetag OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicetag_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_slicetag_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_slicetag_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_slicetag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_slicetag_id_seq OWNED BY core_slicetag.id; |
| |
| |
| -- |
| -- Name: core_tag; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_tag ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| value character varying(1024) NOT NULL, |
| object_id integer NOT NULL, |
| content_type_id integer NOT NULL, |
| service_id integer NOT NULL, |
| CONSTRAINT core_tag_object_id_check CHECK ((object_id >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.core_tag OWNER TO postgres; |
| |
| -- |
| -- Name: core_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_tag_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_tag_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_tag_id_seq OWNED BY core_tag.id; |
| |
| |
| -- |
| -- Name: core_tenant; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_tenant ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| kind character varying(30) NOT NULL, |
| service_specific_id character varying(30), |
| service_specific_attribute text, |
| connect_method character varying(30) NOT NULL, |
| provider_service_id integer NOT NULL, |
| subscriber_root_id integer, |
| subscriber_service_id integer, |
| subscriber_tenant_id integer, |
| subscriber_user_id integer |
| ); |
| |
| |
| ALTER TABLE public.core_tenant OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenant_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_tenant_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_tenant_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_tenant_id_seq OWNED BY core_tenant.id; |
| |
| |
| -- |
| -- Name: core_tenantroot; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_tenantroot ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| kind character varying(30) NOT NULL, |
| name character varying(255), |
| service_specific_attribute text, |
| service_specific_id character varying(30) |
| ); |
| |
| |
| ALTER TABLE public.core_tenantroot OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantroot_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_tenantroot_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_tenantroot_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantroot_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_tenantroot_id_seq OWNED BY core_tenantroot.id; |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_tenantrootprivilege ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role_id integer NOT NULL, |
| tenant_root_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_tenantrootprivilege OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantrootprivilege_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_tenantrootprivilege_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_tenantrootprivilege_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantrootprivilege_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_tenantrootprivilege_id_seq OWNED BY core_tenantrootprivilege.id; |
| |
| |
| -- |
| -- Name: core_tenantrootrole; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_tenantrootrole ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| role character varying(30) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_tenantrootrole OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantrootrole_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_tenantrootrole_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_tenantrootrole_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_tenantrootrole_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_tenantrootrole_id_seq OWNED BY core_tenantrootrole.id; |
| |
| |
| -- |
| -- Name: core_usableobject; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_usableobject ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(1024) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_usableobject OWNER TO postgres; |
| |
| -- |
| -- Name: core_usableobject_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_usableobject_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_usableobject_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_usableobject_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_usableobject_id_seq OWNED BY core_usableobject.id; |
| |
| |
| -- |
| -- Name: core_user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_user ( |
| id integer NOT NULL, |
| password character varying(128) NOT NULL, |
| last_login timestamp with time zone NOT NULL, |
| email character varying(255) NOT NULL, |
| username character varying(255) NOT NULL, |
| firstname character varying(200) NOT NULL, |
| lastname character varying(200) NOT NULL, |
| phone character varying(100), |
| user_url character varying(200), |
| public_key text, |
| is_active boolean NOT NULL, |
| is_admin boolean NOT NULL, |
| is_staff boolean NOT NULL, |
| is_readonly boolean NOT NULL, |
| is_registering boolean NOT NULL, |
| is_appuser boolean NOT NULL, |
| login_page character varying(200), |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| timezone character varying(100) NOT NULL, |
| site_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_user OWNER TO postgres; |
| |
| -- |
| -- Name: core_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_user_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_user_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_user_id_seq OWNED BY core_user.id; |
| |
| |
| -- |
| -- Name: core_usercredential; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_usercredential ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(128) NOT NULL, |
| key_id character varying(1024) NOT NULL, |
| enc_value text NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_usercredential OWNER TO postgres; |
| |
| -- |
| -- Name: core_usercredential_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_usercredential_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_usercredential_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_usercredential_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_usercredential_id_seq OWNED BY core_usercredential.id; |
| |
| |
| -- |
| -- Name: core_userdashboardview; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE core_userdashboardview ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| "order" integer NOT NULL, |
| "dashboardView_id" integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.core_userdashboardview OWNER TO postgres; |
| |
| -- |
| -- Name: core_userdashboardview_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE core_userdashboardview_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.core_userdashboardview_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: core_userdashboardview_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE core_userdashboardview_id_seq OWNED BY core_userdashboardview.id; |
| |
| |
| -- |
| -- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE django_admin_log ( |
| id integer NOT NULL, |
| action_time timestamp with time zone NOT NULL, |
| object_id text, |
| object_repr character varying(200) NOT NULL, |
| action_flag smallint NOT NULL, |
| change_message text NOT NULL, |
| content_type_id integer, |
| user_id integer NOT NULL, |
| CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.django_admin_log OWNER TO postgres; |
| |
| -- |
| -- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id; |
| |
| |
| -- |
| -- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE django_content_type ( |
| id integer NOT NULL, |
| name character varying(100) NOT NULL, |
| app_label character varying(100) NOT NULL, |
| model character varying(100) NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.django_content_type OWNER TO postgres; |
| |
| -- |
| -- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id; |
| |
| |
| -- |
| -- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; |
| |
| -- |
| -- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| 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 postgres; |
| |
| -- |
| -- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id; |
| |
| |
| -- |
| -- Name: django_session; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; |
| |
| -- |
| -- Name: hpc_accessmap; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_accessmap ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(64) NOT NULL, |
| description text, |
| map character varying(100) NOT NULL, |
| "contentProvider_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.hpc_accessmap OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_accessmap_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_accessmap_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_accessmap_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_accessmap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_accessmap_id_seq OWNED BY hpc_accessmap.id; |
| |
| |
| -- |
| -- Name: hpc_cdnprefix; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_cdnprefix ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| cdn_prefix_id integer, |
| prefix character varying(200) NOT NULL, |
| description text, |
| enabled boolean NOT NULL, |
| "contentProvider_id" integer NOT NULL, |
| "defaultOriginServer_id" integer |
| ); |
| |
| |
| ALTER TABLE public.hpc_cdnprefix OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_cdnprefix_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_cdnprefix_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_cdnprefix_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_cdnprefix_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_cdnprefix_id_seq OWNED BY hpc_cdnprefix.id; |
| |
| |
| -- |
| -- Name: hpc_contentprovider; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_contentprovider ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| content_provider_id integer, |
| name character varying(254) NOT NULL, |
| enabled boolean NOT NULL, |
| description text, |
| "serviceProvider_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.hpc_contentprovider OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_contentprovider_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_contentprovider_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_contentprovider_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_contentprovider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_contentprovider_id_seq OWNED BY hpc_contentprovider.id; |
| |
| |
| -- |
| -- Name: hpc_contentprovider_users; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_contentprovider_users ( |
| id integer NOT NULL, |
| contentprovider_id integer NOT NULL, |
| user_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.hpc_contentprovider_users OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_contentprovider_users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_contentprovider_users_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_contentprovider_users_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_contentprovider_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_contentprovider_users_id_seq OWNED BY hpc_contentprovider_users.id; |
| |
| |
| -- |
| -- Name: hpc_hpchealthcheck; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_hpchealthcheck ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| kind character varying(30) NOT NULL, |
| resource_name character varying(1024) NOT NULL, |
| result_contains character varying(1024), |
| result_min_size integer, |
| result_max_size integer, |
| "hpcService_id" integer |
| ); |
| |
| |
| ALTER TABLE public.hpc_hpchealthcheck OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_hpchealthcheck_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_hpchealthcheck_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_hpchealthcheck_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_hpchealthcheck_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_hpchealthcheck_id_seq OWNED BY hpc_hpchealthcheck.id; |
| |
| |
| -- |
| -- Name: hpc_hpcservice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_hpcservice ( |
| service_ptr_id integer NOT NULL, |
| cmi_hostname character varying(254), |
| hpc_port80 boolean NOT NULL, |
| watcher_hpc_network character varying(254), |
| watcher_dnsdemux_network character varying(254), |
| watcher_dnsredir_network character varying(254) |
| ); |
| |
| |
| ALTER TABLE public.hpc_hpcservice OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_originserver; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_originserver ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| origin_server_id integer, |
| url character varying(1024) NOT NULL, |
| authenticated boolean NOT NULL, |
| enabled boolean NOT NULL, |
| protocol character varying(12) NOT NULL, |
| redirects boolean NOT NULL, |
| description text, |
| "contentProvider_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.hpc_originserver OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_originserver_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_originserver_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_originserver_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_originserver_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_originserver_id_seq OWNED BY hpc_originserver.id; |
| |
| |
| -- |
| -- Name: hpc_serviceprovider; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_serviceprovider ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| service_provider_id integer, |
| name character varying(254) NOT NULL, |
| description text, |
| enabled boolean NOT NULL, |
| "hpcService_id" integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.hpc_serviceprovider OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_serviceprovider_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_serviceprovider_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_serviceprovider_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_serviceprovider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_serviceprovider_id_seq OWNED BY hpc_serviceprovider.id; |
| |
| |
| -- |
| -- Name: hpc_sitemap; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE hpc_sitemap ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(64) NOT NULL, |
| description text, |
| map character varying(100) NOT NULL, |
| map_id integer, |
| "cdnPrefix_id" integer, |
| "contentProvider_id" integer, |
| "hpcService_id" integer, |
| "serviceProvider_id" integer |
| ); |
| |
| |
| ALTER TABLE public.hpc_sitemap OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_sitemap_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE hpc_sitemap_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.hpc_sitemap_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: hpc_sitemap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE hpc_sitemap_id_seq OWNED BY hpc_sitemap.id; |
| |
| |
| -- |
| -- Name: requestrouter_requestrouterservice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE requestrouter_requestrouterservice ( |
| service_ptr_id integer NOT NULL, |
| "behindNat" boolean NOT NULL, |
| "defaultTTL" integer NOT NULL, |
| "defaultAction" character varying(30) NOT NULL, |
| "lastResortAction" character varying(30) NOT NULL, |
| "maxAnswers" integer NOT NULL, |
| CONSTRAINT "requestrouter_requestrouterservice_defaultTTL_check" CHECK (("defaultTTL" >= 0)), |
| CONSTRAINT "requestrouter_requestrouterservice_maxAnswers_check" CHECK (("maxAnswers" >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.requestrouter_requestrouterservice OWNER TO postgres; |
| |
| -- |
| -- Name: requestrouter_servicemap; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE requestrouter_servicemap ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(50) NOT NULL, |
| prefix character varying(256) NOT NULL, |
| "siteMap" character varying(100) NOT NULL, |
| "accessMap" character varying(100) NOT NULL, |
| owner_id integer NOT NULL, |
| slice_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.requestrouter_servicemap OWNER TO postgres; |
| |
| -- |
| -- Name: requestrouter_servicemap_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE requestrouter_servicemap_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.requestrouter_servicemap_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: requestrouter_servicemap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE requestrouter_servicemap_id_seq OWNED BY requestrouter_servicemap.id; |
| |
| |
| -- |
| -- Name: syndicate_storage_slicesecret; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_slicesecret ( |
| id integer NOT NULL, |
| secret text NOT NULL, |
| slice_id_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_slicesecret OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_slicesecret_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE syndicate_storage_slicesecret_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.syndicate_storage_slicesecret_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_slicesecret_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE syndicate_storage_slicesecret_id_seq OWNED BY syndicate_storage_slicesecret.id; |
| |
| |
| -- |
| -- Name: syndicate_storage_syndicateprincipal; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_syndicateprincipal ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| principal_id text NOT NULL, |
| public_key_pem text NOT NULL, |
| sealed_private_key text NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_syndicateprincipal OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_syndicateprincipal_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE syndicate_storage_syndicateprincipal_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.syndicate_storage_syndicateprincipal_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_syndicateprincipal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE syndicate_storage_syndicateprincipal_id_seq OWNED BY syndicate_storage_syndicateprincipal.id; |
| |
| |
| -- |
| -- Name: syndicate_storage_syndicateservice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_syndicateservice ( |
| service_ptr_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_syndicateservice OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volume; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_volume ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| name character varying(64) NOT NULL, |
| description text, |
| blocksize integer NOT NULL, |
| private boolean NOT NULL, |
| archive boolean NOT NULL, |
| cap_read_data boolean NOT NULL, |
| cap_write_data boolean NOT NULL, |
| cap_host_data boolean NOT NULL, |
| owner_id_id integer NOT NULL, |
| CONSTRAINT syndicate_storage_volume_blocksize_check CHECK ((blocksize >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_volume OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volume_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE syndicate_storage_volume_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.syndicate_storage_volume_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volume_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE syndicate_storage_volume_id_seq OWNED BY syndicate_storage_volume.id; |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_volumeaccessright ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| cap_read_data boolean NOT NULL, |
| cap_write_data boolean NOT NULL, |
| cap_host_data boolean NOT NULL, |
| owner_id_id integer NOT NULL, |
| volume_id integer NOT NULL |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_volumeaccessright OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE syndicate_storage_volumeaccessright_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.syndicate_storage_volumeaccessright_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE syndicate_storage_volumeaccessright_id_seq OWNED BY syndicate_storage_volumeaccessright.id; |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeslice; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE TABLE syndicate_storage_volumeslice ( |
| id integer NOT NULL, |
| created timestamp with time zone NOT NULL, |
| updated timestamp with time zone NOT NULL, |
| enacted timestamp with time zone, |
| policed timestamp with time zone, |
| backend_register character varying(140), |
| backend_status character varying(1024) NOT NULL, |
| deleted boolean NOT NULL, |
| write_protect boolean NOT NULL, |
| lazy_blocked boolean NOT NULL, |
| no_sync boolean NOT NULL, |
| cap_read_data boolean NOT NULL, |
| cap_write_data boolean NOT NULL, |
| cap_host_data boolean NOT NULL, |
| "UG_portnum" integer NOT NULL, |
| "RG_portnum" integer NOT NULL, |
| credentials_blob text, |
| slice_id_id integer NOT NULL, |
| volume_id_id integer NOT NULL, |
| CONSTRAINT "syndicate_storage_volumeslice_RG_portnum_check" CHECK (("RG_portnum" >= 0)), |
| CONSTRAINT "syndicate_storage_volumeslice_UG_portnum_check" CHECK (("UG_portnum" >= 0)) |
| ); |
| |
| |
| ALTER TABLE public.syndicate_storage_volumeslice OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volumeslice_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres |
| -- |
| |
| CREATE SEQUENCE syndicate_storage_volumeslice_id_seq |
| START WITH 1 |
| INCREMENT BY 1 |
| NO MINVALUE |
| NO MAXVALUE |
| CACHE 1; |
| |
| |
| ALTER TABLE public.syndicate_storage_volumeslice_id_seq OWNER TO postgres; |
| |
| -- |
| -- Name: syndicate_storage_volumeslice_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres |
| -- |
| |
| ALTER SEQUENCE syndicate_storage_volumeslice_id_seq OWNED BY syndicate_storage_volumeslice.id; |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| 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: postgres |
| -- |
| |
| ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_account ALTER COLUMN id SET DEFAULT nextval('core_account_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_charge ALTER COLUMN id SET DEFAULT nextval('core_charge_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controller ALTER COLUMN id SET DEFAULT nextval('core_controller_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllercredential ALTER COLUMN id SET DEFAULT nextval('core_controllercredential_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerdashboardview ALTER COLUMN id SET DEFAULT nextval('core_controllerdashboardview_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerimages ALTER COLUMN id SET DEFAULT nextval('core_controllerimages_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllernetwork ALTER COLUMN id SET DEFAULT nextval('core_controllernetwork_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerrole ALTER COLUMN id SET DEFAULT nextval('core_controllerrole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersite ALTER COLUMN id SET DEFAULT nextval('core_controllersite_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersiteprivilege ALTER COLUMN id SET DEFAULT nextval('core_controllersiteprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerslice ALTER COLUMN id SET DEFAULT nextval('core_controllerslice_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersliceprivilege ALTER COLUMN id SET DEFAULT nextval('core_controllersliceprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controlleruser ALTER COLUMN id SET DEFAULT nextval('core_controlleruser_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview ALTER COLUMN id SET DEFAULT nextval('core_dashboardview_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview_deployments ALTER COLUMN id SET DEFAULT nextval('core_dashboardview_deployments_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deployment ALTER COLUMN id SET DEFAULT nextval('core_deployment_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege ALTER COLUMN id SET DEFAULT nextval('core_deploymentprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deploymentrole ALTER COLUMN id SET DEFAULT nextval('core_deploymentrole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_flavor ALTER COLUMN id SET DEFAULT nextval('core_flavor_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_flavor_deployments ALTER COLUMN id SET DEFAULT nextval('core_flavor_deployments_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_image ALTER COLUMN id SET DEFAULT nextval('core_image_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_imagedeployments ALTER COLUMN id SET DEFAULT nextval('core_imagedeployments_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance ALTER COLUMN id SET DEFAULT nextval('core_instance_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_invoice ALTER COLUMN id SET DEFAULT nextval('core_invoice_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network ALTER COLUMN id SET DEFAULT nextval('core_network_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network_permitted_slices ALTER COLUMN id SET DEFAULT nextval('core_network_permitted_slices_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkparameter ALTER COLUMN id SET DEFAULT nextval('core_networkparameter_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkparametertype ALTER COLUMN id SET DEFAULT nextval('core_networkparametertype_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkslice ALTER COLUMN id SET DEFAULT nextval('core_networkslice_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networktemplate ALTER COLUMN id SET DEFAULT nextval('core_networktemplate_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_node ALTER COLUMN id SET DEFAULT nextval('core_node_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_payment ALTER COLUMN id SET DEFAULT nextval('core_payment_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_port ALTER COLUMN id SET DEFAULT nextval('core_port_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_program ALTER COLUMN id SET DEFAULT nextval('core_program_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_project ALTER COLUMN id SET DEFAULT nextval('core_project_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservation ALTER COLUMN id SET DEFAULT nextval('core_reservation_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservedresource ALTER COLUMN id SET DEFAULT nextval('core_reservedresource_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_role ALTER COLUMN id SET DEFAULT nextval('core_role_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_router ALTER COLUMN id SET DEFAULT nextval('core_router_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_router_networks ALTER COLUMN id SET DEFAULT nextval('core_router_networks_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_router_permittedNetworks" ALTER COLUMN id SET DEFAULT nextval('"core_router_permittedNetworks_id_seq"'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_service ALTER COLUMN id SET DEFAULT nextval('core_service_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceattribute ALTER COLUMN id SET DEFAULT nextval('core_serviceattribute_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceclass ALTER COLUMN id SET DEFAULT nextval('core_serviceclass_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_serviceclass_upgradeFrom" ALTER COLUMN id SET DEFAULT nextval('"core_serviceclass_upgradeFrom_id_seq"'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege ALTER COLUMN id SET DEFAULT nextval('core_serviceprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceresource ALTER COLUMN id SET DEFAULT nextval('core_serviceresource_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_servicerole ALTER COLUMN id SET DEFAULT nextval('core_servicerole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_site ALTER COLUMN id SET DEFAULT nextval('core_site_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitecredential ALTER COLUMN id SET DEFAULT nextval('core_sitecredential_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment ALTER COLUMN id SET DEFAULT nextval('core_sitedeployment_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_siteprivilege ALTER COLUMN id SET DEFAULT nextval('core_siteprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_siterole ALTER COLUMN id SET DEFAULT nextval('core_siterole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice ALTER COLUMN id SET DEFAULT nextval('core_slice_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slicecredential ALTER COLUMN id SET DEFAULT nextval('core_slicecredential_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege ALTER COLUMN id SET DEFAULT nextval('core_sliceprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slicerole ALTER COLUMN id SET DEFAULT nextval('core_slicerole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slicetag ALTER COLUMN id SET DEFAULT nextval('core_slicetag_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tag ALTER COLUMN id SET DEFAULT nextval('core_tag_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant ALTER COLUMN id SET DEFAULT nextval('core_tenant_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantroot ALTER COLUMN id SET DEFAULT nextval('core_tenantroot_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege ALTER COLUMN id SET DEFAULT nextval('core_tenantrootprivilege_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootrole ALTER COLUMN id SET DEFAULT nextval('core_tenantrootrole_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_usableobject ALTER COLUMN id SET DEFAULT nextval('core_usableobject_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_user ALTER COLUMN id SET DEFAULT nextval('core_user_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_usercredential ALTER COLUMN id SET DEFAULT nextval('core_usercredential_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_userdashboardview ALTER COLUMN id SET DEFAULT nextval('core_userdashboardview_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| 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: postgres |
| -- |
| |
| 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: postgres |
| -- |
| |
| ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_accessmap ALTER COLUMN id SET DEFAULT nextval('hpc_accessmap_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_cdnprefix ALTER COLUMN id SET DEFAULT nextval('hpc_cdnprefix_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider ALTER COLUMN id SET DEFAULT nextval('hpc_contentprovider_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider_users ALTER COLUMN id SET DEFAULT nextval('hpc_contentprovider_users_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_hpchealthcheck ALTER COLUMN id SET DEFAULT nextval('hpc_hpchealthcheck_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_originserver ALTER COLUMN id SET DEFAULT nextval('hpc_originserver_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_serviceprovider ALTER COLUMN id SET DEFAULT nextval('hpc_serviceprovider_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap ALTER COLUMN id SET DEFAULT nextval('hpc_sitemap_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY requestrouter_servicemap ALTER COLUMN id SET DEFAULT nextval('requestrouter_servicemap_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_slicesecret ALTER COLUMN id SET DEFAULT nextval('syndicate_storage_slicesecret_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_syndicateprincipal ALTER COLUMN id SET DEFAULT nextval('syndicate_storage_syndicateprincipal_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volume ALTER COLUMN id SET DEFAULT nextval('syndicate_storage_volume_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeaccessright ALTER COLUMN id SET DEFAULT nextval('syndicate_storage_volumeaccessright_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeslice ALTER COLUMN id SET DEFAULT nextval('syndicate_storage_volumeslice_id_seq'::regclass); |
| |
| |
| -- |
| -- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: postgres; 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: postgres; 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: postgres; 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: postgres; 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: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY auth_permission |
| ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_account_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_account |
| ADD CONSTRAINT core_account_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_charge_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_charge |
| ADD CONSTRAINT core_charge_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controller_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controller |
| ADD CONSTRAINT core_controller_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_controller_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controller |
| ADD CONSTRAINT core_controller_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllercredential_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllercredential |
| ADD CONSTRAINT core_controllercredential_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllerdashboardview_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerdashboardview |
| ADD CONSTRAINT core_controllerdashboardview_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllerimages_image_id_77d3516dbca0a5d3_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerimages |
| ADD CONSTRAINT core_controllerimages_image_id_77d3516dbca0a5d3_uniq UNIQUE (image_id, controller_id); |
| |
| |
| -- |
| -- Name: core_controllerimages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerimages |
| ADD CONSTRAINT core_controllerimages_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllernetwork_network_id_30ce4dc681f2844f_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllernetwork |
| ADD CONSTRAINT core_controllernetwork_network_id_30ce4dc681f2844f_uniq UNIQUE (network_id, controller_id); |
| |
| |
| -- |
| -- Name: core_controllernetwork_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllernetwork |
| ADD CONSTRAINT core_controllernetwork_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllerrole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerrole |
| ADD CONSTRAINT core_controllerrole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllerrole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerrole |
| ADD CONSTRAINT core_controllerrole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_controllersite_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersite |
| ADD CONSTRAINT core_controllersite_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllersite_site_id_22f56d79564bc81b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersite |
| ADD CONSTRAINT core_controllersite_site_id_22f56d79564bc81b_uniq UNIQUE (site_id, controller_id); |
| |
| |
| -- |
| -- Name: core_controllersiteprivileg_controller_id_5d0f19c7a7ceb9e5_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersiteprivilege |
| ADD CONSTRAINT core_controllersiteprivileg_controller_id_5d0f19c7a7ceb9e5_uniq UNIQUE (controller_id, site_privilege_id, role_id); |
| |
| |
| -- |
| -- Name: core_controllersiteprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersiteprivilege |
| ADD CONSTRAINT core_controllersiteprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllerslice_controller_id_427703e66574ab83_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerslice |
| ADD CONSTRAINT core_controllerslice_controller_id_427703e66574ab83_uniq UNIQUE (controller_id, slice_id); |
| |
| |
| -- |
| -- Name: core_controllerslice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllerslice |
| ADD CONSTRAINT core_controllerslice_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controllersliceprivile_controller_id_4e8a6f6f999d67c3_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersliceprivilege |
| ADD CONSTRAINT core_controllersliceprivile_controller_id_4e8a6f6f999d67c3_uniq UNIQUE (controller_id, slice_privilege_id); |
| |
| |
| -- |
| -- Name: core_controllersliceprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controllersliceprivilege |
| ADD CONSTRAINT core_controllersliceprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controlleruser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controlleruser |
| ADD CONSTRAINT core_controlleruser_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_controlleruser_user_id_3beb039133bd099b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_controlleruser |
| ADD CONSTRAINT core_controlleruser_user_id_3beb039133bd099b_uniq UNIQUE (user_id, controller_id); |
| |
| |
| -- |
| -- Name: core_dashboardview_deployment_dashboardview_id_deployment_i_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview_deployments |
| ADD CONSTRAINT core_dashboardview_deployment_dashboardview_id_deployment_i_key UNIQUE (dashboardview_id, deployment_id); |
| |
| |
| -- |
| -- Name: core_dashboardview_deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview_deployments |
| ADD CONSTRAINT core_dashboardview_deployments_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_dashboardview_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview |
| ADD CONSTRAINT core_dashboardview_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_dashboardview_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview |
| ADD CONSTRAINT core_dashboardview_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_deployment_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deployment |
| ADD CONSTRAINT core_deployment_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_deployment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deployment |
| ADD CONSTRAINT core_deployment_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_deploymentprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege |
| ADD CONSTRAINT core_deploymentprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_deploymentprivilege_user_id_8f49da97c7cff06_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege |
| ADD CONSTRAINT core_deploymentprivilege_user_id_8f49da97c7cff06_uniq UNIQUE (user_id, deployment_id, role_id); |
| |
| |
| -- |
| -- Name: core_deploymentrole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deploymentrole |
| ADD CONSTRAINT core_deploymentrole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_deploymentrole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_deploymentrole |
| ADD CONSTRAINT core_deploymentrole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_flavor_deployments_flavor_id_deployment_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_flavor_deployments |
| ADD CONSTRAINT core_flavor_deployments_flavor_id_deployment_id_key UNIQUE (flavor_id, deployment_id); |
| |
| |
| -- |
| -- Name: core_flavor_deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_flavor_deployments |
| ADD CONSTRAINT core_flavor_deployments_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_flavor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_flavor |
| ADD CONSTRAINT core_flavor_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_image_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_image |
| ADD CONSTRAINT core_image_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_image_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_image |
| ADD CONSTRAINT core_image_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_imagedeployments_image_id_3bc8a23925d399ff_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_imagedeployments |
| ADD CONSTRAINT core_imagedeployments_image_id_3bc8a23925d399ff_uniq UNIQUE (image_id, deployment_id); |
| |
| |
| -- |
| -- Name: core_imagedeployments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_imagedeployments |
| ADD CONSTRAINT core_imagedeployments_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_instance_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_invoice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_invoice |
| ADD CONSTRAINT core_invoice_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_network_permitted_slices_network_id_slice_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_network_permitted_slices |
| ADD CONSTRAINT core_network_permitted_slices_network_id_slice_id_key UNIQUE (network_id, slice_id); |
| |
| |
| -- |
| -- Name: core_network_permitted_slices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_network_permitted_slices |
| ADD CONSTRAINT core_network_permitted_slices_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_network_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_network |
| ADD CONSTRAINT core_network_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_networkparameter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_networkparameter |
| ADD CONSTRAINT core_networkparameter_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_networkparametertype_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_networkparametertype |
| ADD CONSTRAINT core_networkparametertype_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_networkslice_network_id_78984d02ac7c1fb3_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_networkslice |
| ADD CONSTRAINT core_networkslice_network_id_78984d02ac7c1fb3_uniq UNIQUE (network_id, slice_id); |
| |
| |
| -- |
| -- Name: core_networkslice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_networkslice |
| ADD CONSTRAINT core_networkslice_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_networktemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_networktemplate |
| ADD CONSTRAINT core_networktemplate_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_node_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_node |
| ADD CONSTRAINT core_node_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_node_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_node |
| ADD CONSTRAINT core_node_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_payment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_payment |
| ADD CONSTRAINT core_payment_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_port_network_id_693ab091ccd5a89a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_port |
| ADD CONSTRAINT core_port_network_id_693ab091ccd5a89a_uniq UNIQUE (network_id, instance_id); |
| |
| |
| -- |
| -- Name: core_port_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_port |
| ADD CONSTRAINT core_port_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_program_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_program |
| ADD CONSTRAINT core_program_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_project_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_project |
| ADD CONSTRAINT core_project_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_project |
| ADD CONSTRAINT core_project_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_reservation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_reservation |
| ADD CONSTRAINT core_reservation_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_reservedresource_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_reservedresource |
| ADD CONSTRAINT core_reservedresource_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_role |
| ADD CONSTRAINT core_role_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_router_networks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_router_networks |
| ADD CONSTRAINT core_router_networks_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_router_networks_router_id_network_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_router_networks |
| ADD CONSTRAINT core_router_networks_router_id_network_id_key UNIQUE (router_id, network_id); |
| |
| |
| -- |
| -- Name: core_router_permittedNetworks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY "core_router_permittedNetworks" |
| ADD CONSTRAINT "core_router_permittedNetworks_pkey" PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_router_permittedNetworks_router_id_network_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY "core_router_permittedNetworks" |
| ADD CONSTRAINT "core_router_permittedNetworks_router_id_network_id_key" UNIQUE (router_id, network_id); |
| |
| |
| -- |
| -- Name: core_router_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_router |
| ADD CONSTRAINT core_router_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_service_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_service |
| ADD CONSTRAINT core_service_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_serviceattribute_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_serviceattribute |
| ADD CONSTRAINT core_serviceattribute_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_serviceclass_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_serviceclass |
| ADD CONSTRAINT core_serviceclass_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_serviceclass_upgradeFrom_from_serviceclass_id_to_servi_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY "core_serviceclass_upgradeFrom" |
| ADD CONSTRAINT "core_serviceclass_upgradeFrom_from_serviceclass_id_to_servi_key" UNIQUE (from_serviceclass_id, to_serviceclass_id); |
| |
| |
| -- |
| -- Name: core_serviceclass_upgradeFrom_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY "core_serviceclass_upgradeFrom" |
| ADD CONSTRAINT "core_serviceclass_upgradeFrom_pkey" PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_serviceprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege |
| ADD CONSTRAINT core_serviceprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_serviceprivilege_user_id_3e7ef04b1340e86c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege |
| ADD CONSTRAINT core_serviceprivilege_user_id_3e7ef04b1340e86c_uniq UNIQUE (user_id, service_id, role_id); |
| |
| |
| -- |
| -- Name: core_serviceresource_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_serviceresource |
| ADD CONSTRAINT core_serviceresource_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_servicerole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_servicerole |
| ADD CONSTRAINT core_servicerole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_servicerole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_servicerole |
| ADD CONSTRAINT core_servicerole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_site_login_base_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_site |
| ADD CONSTRAINT core_site_login_base_key UNIQUE (login_base); |
| |
| |
| -- |
| -- Name: core_site_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_site |
| ADD CONSTRAINT core_site_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_sitecredential_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_sitecredential |
| ADD CONSTRAINT core_sitecredential_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_sitedeployment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment |
| ADD CONSTRAINT core_sitedeployment_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_sitedeployment_site_id_ed533b8a1954fbb_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment |
| ADD CONSTRAINT core_sitedeployment_site_id_ed533b8a1954fbb_uniq UNIQUE (site_id, deployment_id, controller_id); |
| |
| |
| -- |
| -- Name: core_siteprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_siteprivilege |
| ADD CONSTRAINT core_siteprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_siterole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_siterole |
| ADD CONSTRAINT core_siterole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_siterole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_siterole |
| ADD CONSTRAINT core_siterole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_slice_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: core_slice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_slicecredential_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slicecredential |
| ADD CONSTRAINT core_slicecredential_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_sliceprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege |
| ADD CONSTRAINT core_sliceprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_sliceprivilege_user_id_6bed734e37df8596_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege |
| ADD CONSTRAINT core_sliceprivilege_user_id_6bed734e37df8596_uniq UNIQUE (user_id, slice_id, role_id); |
| |
| |
| -- |
| -- Name: core_slicerole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slicerole |
| ADD CONSTRAINT core_slicerole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_slicerole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slicerole |
| ADD CONSTRAINT core_slicerole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_slicetag_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_slicetag |
| ADD CONSTRAINT core_slicetag_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tag |
| ADD CONSTRAINT core_tag_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tenant_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core_tenant_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tenantroot_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenantroot |
| ADD CONSTRAINT core_tenantroot_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege |
| ADD CONSTRAINT core_tenantrootprivilege_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege_user_id_2bfebdce70c89f50_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege |
| ADD CONSTRAINT core_tenantrootprivilege_user_id_2bfebdce70c89f50_uniq UNIQUE (user_id, tenant_root_id, role_id); |
| |
| |
| -- |
| -- Name: core_tenantrootrole_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootrole |
| ADD CONSTRAINT core_tenantrootrole_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_tenantrootrole_role_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootrole |
| ADD CONSTRAINT core_tenantrootrole_role_key UNIQUE (role); |
| |
| |
| -- |
| -- Name: core_usableobject_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_usableobject |
| ADD CONSTRAINT core_usableobject_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_user_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_user |
| ADD CONSTRAINT core_user_email_key UNIQUE (email); |
| |
| |
| -- |
| -- Name: core_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_user |
| ADD CONSTRAINT core_user_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_usercredential_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_usercredential |
| ADD CONSTRAINT core_usercredential_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: core_userdashboardview_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY core_userdashboardview |
| ADD CONSTRAINT core_userdashboardview_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY django_admin_log |
| ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: django_content_type_app_label_45f3b1d93ec8c61c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY django_content_type |
| ADD CONSTRAINT django_content_type_app_label_45f3b1d93ec8c61c_uniq UNIQUE (app_label, model); |
| |
| |
| -- |
| -- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY django_migrations |
| ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY django_session |
| ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key); |
| |
| |
| -- |
| -- Name: hpc_accessmap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_accessmap |
| ADD CONSTRAINT hpc_accessmap_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_cdnprefix_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_cdnprefix |
| ADD CONSTRAINT hpc_cdnprefix_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider |
| ADD CONSTRAINT hpc_contentprovider_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_users_contentprovider_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider_users |
| ADD CONSTRAINT hpc_contentprovider_users_contentprovider_id_user_id_key UNIQUE (contentprovider_id, user_id); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider_users |
| ADD CONSTRAINT hpc_contentprovider_users_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_hpchealthcheck_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_hpchealthcheck |
| ADD CONSTRAINT hpc_hpchealthcheck_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_hpcservice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_hpcservice |
| ADD CONSTRAINT hpc_hpcservice_pkey PRIMARY KEY (service_ptr_id); |
| |
| |
| -- |
| -- Name: hpc_originserver_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_originserver |
| ADD CONSTRAINT hpc_originserver_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_serviceprovider_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_serviceprovider |
| ADD CONSTRAINT hpc_serviceprovider_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: hpc_sitemap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap |
| ADD CONSTRAINT hpc_sitemap_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: requestrouter_requestrouterservice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY requestrouter_requestrouterservice |
| ADD CONSTRAINT requestrouter_requestrouterservice_pkey PRIMARY KEY (service_ptr_id); |
| |
| |
| -- |
| -- Name: requestrouter_servicemap_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY requestrouter_servicemap |
| ADD CONSTRAINT requestrouter_servicemap_name_key UNIQUE (name); |
| |
| |
| -- |
| -- Name: requestrouter_servicemap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY requestrouter_servicemap |
| ADD CONSTRAINT requestrouter_servicemap_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: syndicate_storage_slicesecret_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_slicesecret |
| ADD CONSTRAINT syndicate_storage_slicesecret_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: syndicate_storage_syndicateprincipal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_syndicateprincipal |
| ADD CONSTRAINT syndicate_storage_syndicateprincipal_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: syndicate_storage_syndicateprincipal_principal_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_syndicateprincipal |
| ADD CONSTRAINT syndicate_storage_syndicateprincipal_principal_id_key UNIQUE (principal_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_syndicateservice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_syndicateservice |
| ADD CONSTRAINT syndicate_storage_syndicateservice_pkey PRIMARY KEY (service_ptr_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volume_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volume |
| ADD CONSTRAINT syndicate_storage_volume_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeaccessright |
| ADD CONSTRAINT syndicate_storage_volumeaccessright_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeslice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeslice |
| ADD CONSTRAINT syndicate_storage_volumeslice_pkey PRIMARY KEY (id); |
| |
| |
| -- |
| -- Name: auth_group_permissions_0e939a4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX auth_group_permissions_0e939a4f ON auth_group_permissions USING btree (group_id); |
| |
| |
| -- |
| -- Name: auth_group_permissions_8373b171; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX auth_group_permissions_8373b171 ON auth_group_permissions USING btree (permission_id); |
| |
| |
| -- |
| -- Name: auth_permission_417f1b1c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX auth_permission_417f1b1c ON auth_permission USING btree (content_type_id); |
| |
| |
| -- |
| -- Name: core_account_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_account_9365d6e7 ON core_account USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_charge_8a089c2a; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_charge_8a089c2a ON core_charge USING btree (account_id); |
| |
| |
| -- |
| -- Name: core_charge_af31437c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_charge_af31437c ON core_charge USING btree (object_id); |
| |
| |
| -- |
| -- Name: core_charge_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_charge_be7f3a0f ON core_charge USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_charge_f1f5d967; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_charge_f1f5d967 ON core_charge USING btree (invoice_id); |
| |
| |
| -- |
| -- Name: core_controller_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controller_5921cd4f ON core_controller USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_controllercredential_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllercredential_a31c1112 ON core_controllercredential USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllercredential_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllercredential_b068931c ON core_controllercredential USING btree (name); |
| |
| |
| -- |
| -- Name: core_controllerdashboardview_5da0369f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerdashboardview_5da0369f ON core_controllerdashboardview USING btree ("dashboardView_id"); |
| |
| |
| -- |
| -- Name: core_controllerdashboardview_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerdashboardview_a31c1112 ON core_controllerdashboardview USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllerimages_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerimages_a31c1112 ON core_controllerimages USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllerimages_f33175e6; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerimages_f33175e6 ON core_controllerimages USING btree (image_id); |
| |
| |
| -- |
| -- Name: core_controllernetwork_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllernetwork_4e19114d ON core_controllernetwork USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_controllernetwork_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllernetwork_a31c1112 ON core_controllernetwork USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllersite_38543614; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersite_38543614 ON core_controllersite USING btree (tenant_id); |
| |
| |
| -- |
| -- Name: core_controllersite_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersite_9365d6e7 ON core_controllersite USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_controllersite_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersite_a31c1112 ON core_controllersite USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllersiteprivilege_28116b8e; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersiteprivilege_28116b8e ON core_controllersiteprivilege USING btree (site_privilege_id); |
| |
| |
| -- |
| -- Name: core_controllersiteprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersiteprivilege_84566833 ON core_controllersiteprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_controllersiteprivilege_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersiteprivilege_a31c1112 ON core_controllersiteprivilege USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllerslice_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerslice_a31c1112 ON core_controllerslice USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controllerslice_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllerslice_be7f3a0f ON core_controllerslice USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_controllersliceprivilege_25740d9a; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersliceprivilege_25740d9a ON core_controllersliceprivilege USING btree (slice_privilege_id); |
| |
| |
| -- |
| -- Name: core_controllersliceprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersliceprivilege_84566833 ON core_controllersliceprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_controllersliceprivilege_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controllersliceprivilege_a31c1112 ON core_controllersliceprivilege USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controlleruser_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controlleruser_a31c1112 ON core_controlleruser USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_controlleruser_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_controlleruser_e8701ad4 ON core_controlleruser USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_dashboardview_deployments_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_dashboardview_deployments_5921cd4f ON core_dashboardview_deployments USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_dashboardview_deployments_79bd56c8; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_dashboardview_deployments_79bd56c8 ON core_dashboardview_deployments USING btree (dashboardview_id); |
| |
| |
| -- |
| -- Name: core_deploymentprivilege_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_deploymentprivilege_5921cd4f ON core_deploymentprivilege USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_deploymentprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_deploymentprivilege_84566833 ON core_deploymentprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_deploymentprivilege_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_deploymentprivilege_e8701ad4 ON core_deploymentprivilege USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_flavor_deployments_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_flavor_deployments_5921cd4f ON core_flavor_deployments USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_flavor_deployments_dd3f198d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_flavor_deployments_dd3f198d ON core_flavor_deployments USING btree (flavor_id); |
| |
| |
| -- |
| -- Name: core_imagedeployments_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_imagedeployments_5921cd4f ON core_imagedeployments USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_imagedeployments_f33175e6; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_imagedeployments_f33175e6 ON core_imagedeployments USING btree (image_id); |
| |
| |
| -- |
| -- Name: core_instance_3700153c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_3700153c ON core_instance USING btree (creator_id); |
| |
| |
| -- |
| -- Name: core_instance_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_5921cd4f ON core_instance USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_instance_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_be7f3a0f ON core_instance USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_instance_c693ebc8; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_c693ebc8 ON core_instance USING btree (node_id); |
| |
| |
| -- |
| -- Name: core_instance_dd3f198d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_dd3f198d ON core_instance USING btree (flavor_id); |
| |
| |
| -- |
| -- Name: core_instance_f33175e6; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_instance_f33175e6 ON core_instance USING btree (image_id); |
| |
| |
| -- |
| -- Name: core_invoice_8a089c2a; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_invoice_8a089c2a ON core_invoice USING btree (account_id); |
| |
| |
| -- |
| -- Name: core_network_5e7b1936; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_network_5e7b1936 ON core_network USING btree (owner_id); |
| |
| |
| -- |
| -- Name: core_network_74f53564; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_network_74f53564 ON core_network USING btree (template_id); |
| |
| |
| -- |
| -- Name: core_network_permitted_slices_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_network_permitted_slices_4e19114d ON core_network_permitted_slices USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_network_permitted_slices_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_network_permitted_slices_be7f3a0f ON core_network_permitted_slices USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_networkparameter_417f1b1c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_networkparameter_417f1b1c ON core_networkparameter USING btree (content_type_id); |
| |
| |
| -- |
| -- Name: core_networkparameter_80740216; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_networkparameter_80740216 ON core_networkparameter USING btree (parameter_id); |
| |
| |
| -- |
| -- Name: core_networkparametertype_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_networkparametertype_b068931c ON core_networkparametertype USING btree (name); |
| |
| |
| -- |
| -- Name: core_networkslice_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_networkslice_4e19114d ON core_networkslice USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_networkslice_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_networkslice_be7f3a0f ON core_networkslice USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_node_86aed61a; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_node_86aed61a ON core_node USING btree (site_deployment_id); |
| |
| |
| -- |
| -- Name: core_node_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_node_9365d6e7 ON core_node USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_payment_8a089c2a; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_payment_8a089c2a ON core_payment USING btree (account_id); |
| |
| |
| -- |
| -- Name: core_port_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_port_4e19114d ON core_port USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_port_51afcc4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_port_51afcc4f ON core_port USING btree (instance_id); |
| |
| |
| -- |
| -- Name: core_program_5e7b1936; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_program_5e7b1936 ON core_program USING btree (owner_id); |
| |
| |
| -- |
| -- Name: core_reservation_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_reservation_be7f3a0f ON core_reservation USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_reservedresource_51afcc4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_reservedresource_51afcc4f ON core_reservedresource USING btree (instance_id); |
| |
| |
| -- |
| -- Name: core_reservedresource_732beb09; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_reservedresource_732beb09 ON core_reservedresource USING btree ("reservationSet_id"); |
| |
| |
| -- |
| -- Name: core_reservedresource_e2f3ef5b; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_reservedresource_e2f3ef5b ON core_reservedresource USING btree (resource_id); |
| |
| |
| -- |
| -- Name: core_role_417f1b1c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_role_417f1b1c ON core_role USING btree (content_type_id); |
| |
| |
| -- |
| -- Name: core_router_5e7b1936; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_router_5e7b1936 ON core_router USING btree (owner_id); |
| |
| |
| -- |
| -- Name: core_router_networks_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_router_networks_4e19114d ON core_router_networks USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_router_networks_52d4f3af; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_router_networks_52d4f3af ON core_router_networks USING btree (router_id); |
| |
| |
| -- |
| -- Name: core_router_permittednetworks_4e19114d; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_router_permittednetworks_4e19114d ON "core_router_permittedNetworks" USING btree (network_id); |
| |
| |
| -- |
| -- Name: core_router_permittednetworks_52d4f3af; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_router_permittednetworks_52d4f3af ON "core_router_permittedNetworks" USING btree (router_id); |
| |
| |
| -- |
| -- Name: core_serviceattribute_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceattribute_b068931c ON core_serviceattribute USING btree (name); |
| |
| |
| -- |
| -- Name: core_serviceattribute_b0dc1e29; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceattribute_b0dc1e29 ON core_serviceattribute USING btree (service_id); |
| |
| |
| -- |
| -- Name: core_serviceclass_upgradefrom_a90aba97; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceclass_upgradefrom_a90aba97 ON "core_serviceclass_upgradeFrom" USING btree (to_serviceclass_id); |
| |
| |
| -- |
| -- Name: core_serviceclass_upgradefrom_e970e0f1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceclass_upgradefrom_e970e0f1 ON "core_serviceclass_upgradeFrom" USING btree (from_serviceclass_id); |
| |
| |
| -- |
| -- Name: core_serviceprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceprivilege_84566833 ON core_serviceprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_serviceprivilege_b0dc1e29; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceprivilege_b0dc1e29 ON core_serviceprivilege USING btree (service_id); |
| |
| |
| -- |
| -- Name: core_serviceprivilege_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceprivilege_e8701ad4 ON core_serviceprivilege USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_serviceresource_aa578034; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_serviceresource_aa578034 ON core_serviceresource USING btree ("serviceClass_id"); |
| |
| |
| -- |
| -- Name: core_sitecredential_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sitecredential_9365d6e7 ON core_sitecredential USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_sitecredential_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sitecredential_b068931c ON core_sitecredential USING btree (name); |
| |
| |
| -- |
| -- Name: core_sitedeployment_5921cd4f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sitedeployment_5921cd4f ON core_sitedeployment USING btree (deployment_id); |
| |
| |
| -- |
| -- Name: core_sitedeployment_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sitedeployment_9365d6e7 ON core_sitedeployment USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_sitedeployment_a31c1112; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sitedeployment_a31c1112 ON core_sitedeployment USING btree (controller_id); |
| |
| |
| -- |
| -- Name: core_siteprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_siteprivilege_84566833 ON core_siteprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_siteprivilege_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_siteprivilege_9365d6e7 ON core_siteprivilege USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_siteprivilege_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_siteprivilege_e8701ad4 ON core_siteprivilege USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_slice_3700153c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_3700153c ON core_slice USING btree (creator_id); |
| |
| |
| -- |
| -- Name: core_slice_531a000f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_531a000f ON core_slice USING btree (default_flavor_id); |
| |
| |
| -- |
| -- Name: core_slice_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_9365d6e7 ON core_slice USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_slice_a82f732f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_a82f732f ON core_slice USING btree (default_image_id); |
| |
| |
| -- |
| -- Name: core_slice_aa578034; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_aa578034 ON core_slice USING btree ("serviceClass_id"); |
| |
| |
| -- |
| -- Name: core_slice_b0dc1e29; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slice_b0dc1e29 ON core_slice USING btree (service_id); |
| |
| |
| -- |
| -- Name: core_slicecredential_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slicecredential_b068931c ON core_slicecredential USING btree (name); |
| |
| |
| -- |
| -- Name: core_slicecredential_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slicecredential_be7f3a0f ON core_slicecredential USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_sliceprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sliceprivilege_84566833 ON core_sliceprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_sliceprivilege_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sliceprivilege_be7f3a0f ON core_sliceprivilege USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_sliceprivilege_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_sliceprivilege_e8701ad4 ON core_sliceprivilege USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_slicetag_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_slicetag_be7f3a0f ON core_slicetag USING btree (slice_id); |
| |
| |
| -- |
| -- Name: core_tag_417f1b1c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tag_417f1b1c ON core_tag USING btree (content_type_id); |
| |
| |
| -- |
| -- Name: core_tag_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tag_b068931c ON core_tag USING btree (name); |
| |
| |
| -- |
| -- Name: core_tag_b0dc1e29; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tag_b0dc1e29 ON core_tag USING btree (service_id); |
| |
| |
| -- |
| -- Name: core_tenant_6d0512e4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenant_6d0512e4 ON core_tenant USING btree (subscriber_tenant_id); |
| |
| |
| -- |
| -- Name: core_tenant_a5c60fe7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenant_a5c60fe7 ON core_tenant USING btree (subscriber_service_id); |
| |
| |
| -- |
| -- Name: core_tenant_d1fbfb28; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenant_d1fbfb28 ON core_tenant USING btree (provider_service_id); |
| |
| |
| -- |
| -- Name: core_tenant_ec8cbfdc; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenant_ec8cbfdc ON core_tenant USING btree (subscriber_user_id); |
| |
| |
| -- |
| -- Name: core_tenant_f687e49c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenant_f687e49c ON core_tenant USING btree (subscriber_root_id); |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege_84566833; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenantrootprivilege_84566833 ON core_tenantrootprivilege USING btree (role_id); |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege_ad876f96; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenantrootprivilege_ad876f96 ON core_tenantrootprivilege USING btree (tenant_root_id); |
| |
| |
| -- |
| -- Name: core_tenantrootprivilege_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_tenantrootprivilege_e8701ad4 ON core_tenantrootprivilege USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_user_9365d6e7; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_user_9365d6e7 ON core_user USING btree (site_id); |
| |
| |
| -- |
| -- Name: core_usercredential_b068931c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_usercredential_b068931c ON core_usercredential USING btree (name); |
| |
| |
| -- |
| -- Name: core_usercredential_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_usercredential_e8701ad4 ON core_usercredential USING btree (user_id); |
| |
| |
| -- |
| -- Name: core_userdashboardview_5da0369f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_userdashboardview_5da0369f ON core_userdashboardview USING btree ("dashboardView_id"); |
| |
| |
| -- |
| -- Name: core_userdashboardview_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX core_userdashboardview_e8701ad4 ON core_userdashboardview USING btree (user_id); |
| |
| |
| -- |
| -- Name: django_admin_log_417f1b1c; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX django_admin_log_417f1b1c ON django_admin_log USING btree (content_type_id); |
| |
| |
| -- |
| -- Name: django_admin_log_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX django_admin_log_e8701ad4 ON django_admin_log USING btree (user_id); |
| |
| |
| -- |
| -- Name: django_session_de54fa62; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX django_session_de54fa62 ON django_session USING btree (expire_date); |
| |
| |
| -- |
| -- Name: hpc_accessmap_bc4912a0; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_accessmap_bc4912a0 ON hpc_accessmap USING btree ("contentProvider_id"); |
| |
| |
| -- |
| -- Name: hpc_cdnprefix_8473b38b; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_cdnprefix_8473b38b ON hpc_cdnprefix USING btree ("defaultOriginServer_id"); |
| |
| |
| -- |
| -- Name: hpc_cdnprefix_bc4912a0; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_cdnprefix_bc4912a0 ON hpc_cdnprefix USING btree ("contentProvider_id"); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_ebdbc659; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_contentprovider_ebdbc659 ON hpc_contentprovider USING btree ("serviceProvider_id"); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_users_82c06917; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_contentprovider_users_82c06917 ON hpc_contentprovider_users USING btree (contentprovider_id); |
| |
| |
| -- |
| -- Name: hpc_contentprovider_users_e8701ad4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_contentprovider_users_e8701ad4 ON hpc_contentprovider_users USING btree (user_id); |
| |
| |
| -- |
| -- Name: hpc_hpchealthcheck_591847bf; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_hpchealthcheck_591847bf ON hpc_hpchealthcheck USING btree ("hpcService_id"); |
| |
| |
| -- |
| -- Name: hpc_originserver_bc4912a0; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_originserver_bc4912a0 ON hpc_originserver USING btree ("contentProvider_id"); |
| |
| |
| -- |
| -- Name: hpc_serviceprovider_591847bf; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_serviceprovider_591847bf ON hpc_serviceprovider USING btree ("hpcService_id"); |
| |
| |
| -- |
| -- Name: hpc_sitemap_23b3ec8f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_sitemap_23b3ec8f ON hpc_sitemap USING btree ("cdnPrefix_id"); |
| |
| |
| -- |
| -- Name: hpc_sitemap_591847bf; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_sitemap_591847bf ON hpc_sitemap USING btree ("hpcService_id"); |
| |
| |
| -- |
| -- Name: hpc_sitemap_bc4912a0; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_sitemap_bc4912a0 ON hpc_sitemap USING btree ("contentProvider_id"); |
| |
| |
| -- |
| -- Name: hpc_sitemap_ebdbc659; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX hpc_sitemap_ebdbc659 ON hpc_sitemap USING btree ("serviceProvider_id"); |
| |
| |
| -- |
| -- Name: requestrouter_servicemap_5e7b1936; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX requestrouter_servicemap_5e7b1936 ON requestrouter_servicemap USING btree (owner_id); |
| |
| |
| -- |
| -- Name: requestrouter_servicemap_be7f3a0f; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX requestrouter_servicemap_be7f3a0f ON requestrouter_servicemap USING btree (slice_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_slicesecret_b717f5ab; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_slicesecret_b717f5ab ON syndicate_storage_slicesecret USING btree (slice_id_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volume_279564bf; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_volume_279564bf ON syndicate_storage_volume USING btree (owner_id_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright_279564bf; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_volumeaccessright_279564bf ON syndicate_storage_volumeaccessright USING btree (owner_id_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeaccessright_654102bb; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_volumeaccessright_654102bb ON syndicate_storage_volumeaccessright USING btree (volume_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeslice_5b591651; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_volumeslice_5b591651 ON syndicate_storage_volumeslice USING btree (volume_id_id); |
| |
| |
| -- |
| -- Name: syndicate_storage_volumeslice_b717f5ab; Type: INDEX; Schema: public; Owner: postgres; Tablespace: |
| -- |
| |
| CREATE INDEX syndicate_storage_volumeslice_b717f5ab ON syndicate_storage_volumeslice USING btree (slice_id_id); |
| |
| |
| -- |
| -- Name: auth_content_type_id_508cf46651277a81_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY auth_permission |
| ADD CONSTRAINT auth_content_type_id_508cf46651277a81_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: auth_group_permissio_group_id_689710a9a73b7457_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY auth_group_permissions |
| ADD CONSTRAINT auth_group_permissio_group_id_689710a9a73b7457_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: auth_group_permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY auth_group_permissions |
| ADD CONSTRAINT auth_group_permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: b8a90faf34a5dd47a7f1e2f88e99f8a2; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_hpchealthcheck |
| ADD CONSTRAINT b8a90faf34a5dd47a7f1e2f88e99f8a2 FOREIGN KEY ("hpcService_id") REFERENCES hpc_hpcservice(service_ptr_id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: c_from_serviceclass_id_188a83eaefe26390_fk_core_serviceclass_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_serviceclass_upgradeFrom" |
| ADD CONSTRAINT c_from_serviceclass_id_188a83eaefe26390_fk_core_serviceclass_id FOREIGN KEY (from_serviceclass_id) REFERENCES core_serviceclass(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: c_parameter_id_2c17791ba32bd8c8_fk_core_networkparametertype_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkparameter |
| ADD CONSTRAINT c_parameter_id_2c17791ba32bd8c8_fk_core_networkparametertype_id FOREIGN KEY (parameter_id) REFERENCES core_networkparametertype(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: c_site_deployment_id_2dc763428bdc2781_fk_core_sitedeployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_node |
| ADD CONSTRAINT c_site_deployment_id_2dc763428bdc2781_fk_core_sitedeployment_id FOREIGN KEY (site_deployment_id) REFERENCES core_sitedeployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: co_slice_privilege_id_21402f4f2399079_fk_core_sliceprivilege_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersliceprivilege |
| ADD CONSTRAINT co_slice_privilege_id_21402f4f2399079_fk_core_sliceprivilege_id FOREIGN KEY (slice_privilege_id) REFERENCES core_sliceprivilege(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: cor_site_privilege_id_41490e8c05c2e685_fk_core_siteprivilege_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersiteprivilege |
| ADD CONSTRAINT cor_site_privilege_id_41490e8c05c2e685_fk_core_siteprivilege_id FOREIGN KEY (site_privilege_id) REFERENCES core_siteprivilege(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: cor_to_serviceclass_id_4e2748248647c43b_fk_core_serviceclass_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_serviceclass_upgradeFrom" |
| ADD CONSTRAINT cor_to_serviceclass_id_4e2748248647c43b_fk_core_serviceclass_id FOREIGN KEY (to_serviceclass_id) REFERENCES core_serviceclass(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core__reservationset_id_395058233c59a671_fk_core_reservation_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservedresource |
| ADD CONSTRAINT core__reservationset_id_395058233c59a671_fk_core_reservation_id FOREIGN KEY ("reservationSet_id") REFERENCES core_reservation(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core__subscriber_root_id_26f21610cb2711f9_fk_core_tenantroot_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core__subscriber_root_id_26f21610cb2711f9_fk_core_tenantroot_id FOREIGN KEY (subscriber_root_id) REFERENCES core_tenantroot(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core__subscriber_service_id_5049d522dc2feae7_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core__subscriber_service_id_5049d522dc2feae7_fk_core_service_id FOREIGN KEY (subscriber_service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_account_site_id_7d8af010f408acb2_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_account |
| ADD CONSTRAINT core_account_site_id_7d8af010f408acb2_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_charge_account_id_277c66c32427fb_fk_core_account_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_charge |
| ADD CONSTRAINT core_charge_account_id_277c66c32427fb_fk_core_account_id FOREIGN KEY (account_id) REFERENCES core_account(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_charge_invoice_id_7af39adf58aad977_fk_core_invoice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_charge |
| ADD CONSTRAINT core_charge_invoice_id_7af39adf58aad977_fk_core_invoice_id FOREIGN KEY (invoice_id) REFERENCES core_invoice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_charge_object_id_349f8834f1bf5ce6_fk_core_usableobject_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_charge |
| ADD CONSTRAINT core_charge_object_id_349f8834f1bf5ce6_fk_core_usableobject_id FOREIGN KEY (object_id) REFERENCES core_usableobject(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_charge_slice_id_5f33de3b320604f2_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_charge |
| ADD CONSTRAINT core_charge_slice_id_5f33de3b320604f2_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_content_type_id_150a10ada282bcf9_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_role |
| ADD CONSTRAINT core_content_type_id_150a10ada282bcf9_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_content_type_id_3cc30601489a3056_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkparameter |
| ADD CONSTRAINT core_content_type_id_3cc30601489a3056_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_content_type_id_413c7b5400f8ad9c_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tag |
| ADD CONSTRAINT core_content_type_id_413c7b5400f8ad9c_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_11d29f7e2a4a5462_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersiteprivilege |
| ADD CONSTRAINT core_contr_controller_id_11d29f7e2a4a5462_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_1f82c3216437715f_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerdashboardview |
| ADD CONSTRAINT core_contr_controller_id_1f82c3216437715f_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_46178c1d21384e5e_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersite |
| ADD CONSTRAINT core_contr_controller_id_46178c1d21384e5e_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_4fb982de67c3b742_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersliceprivilege |
| ADD CONSTRAINT core_contr_controller_id_4fb982de67c3b742_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_5cd05d37bbdf1d96_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controlleruser |
| ADD CONSTRAINT core_contr_controller_id_5cd05d37bbdf1d96_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_60b467e792b15198_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllernetwork |
| ADD CONSTRAINT core_contr_controller_id_60b467e792b15198_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_controller_id_7095bdbd27f73f56_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerslice |
| ADD CONSTRAINT core_contr_controller_id_7095bdbd27f73f56_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contr_deployment_id_772a055c58b6e43a_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controller |
| ADD CONSTRAINT core_contr_deployment_id_772a055c58b6e43a_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contro_controller_id_5906172a2f34d3a_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllercredential |
| ADD CONSTRAINT core_contro_controller_id_5906172a2f34d3a_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_contro_controller_id_6d1311b7cc69cd7_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerimages |
| ADD CONSTRAINT core_contro_controller_id_6d1311b7cc69cd7_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_controllerimage_image_id_5713221a6b077f6b_fk_core_image_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerimages |
| ADD CONSTRAINT core_controllerimage_image_id_5713221a6b077f6b_fk_core_image_id FOREIGN KEY (image_id) REFERENCES core_image(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_controllern_network_id_3fe7748f6851d06f_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllernetwork |
| ADD CONSTRAINT core_controllern_network_id_3fe7748f6851d06f_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_controllersite_site_id_4fa87f0734a60665_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllersite |
| ADD CONSTRAINT core_controllersite_site_id_4fa87f0734a60665_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_controllerslice_slice_id_7005d287c601356b_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerslice |
| ADD CONSTRAINT core_controllerslice_slice_id_7005d287c601356b_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_controlleruser_user_id_60dc3a7220b1005b_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controlleruser |
| ADD CONSTRAINT core_controlleruser_user_id_60dc3a7220b1005b_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_dashbo_deployment_id_8b902dfc7ab128b_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview_deployments |
| ADD CONSTRAINT core_dashbo_deployment_id_8b902dfc7ab128b_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_dashboardview_id_1241776e11825a15_fk_core_dashboardview_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_controllerdashboardview |
| ADD CONSTRAINT core_dashboardview_id_1241776e11825a15_fk_core_dashboardview_id FOREIGN KEY ("dashboardView_id") REFERENCES core_dashboardview(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_dashboardview_id_623d5d799346e0f8_fk_core_dashboardview_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_dashboardview_deployments |
| ADD CONSTRAINT core_dashboardview_id_623d5d799346e0f8_fk_core_dashboardview_id FOREIGN KEY (dashboardview_id) REFERENCES core_dashboardview(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_dashboardview_id_7d9723f531eefdde_fk_core_dashboardview_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_userdashboardview |
| ADD CONSTRAINT core_dashboardview_id_7d9723f531eefdde_fk_core_dashboardview_id FOREIGN KEY ("dashboardView_id") REFERENCES core_dashboardview(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_deplo_deployment_id_4606c90fff2e5ecf_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege |
| ADD CONSTRAINT core_deplo_deployment_id_4606c90fff2e5ecf_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_deploym_role_id_221f61258b29e608_fk_core_deploymentrole_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege |
| ADD CONSTRAINT core_deploym_role_id_221f61258b29e608_fk_core_deploymentrole_id FOREIGN KEY (role_id) REFERENCES core_deploymentrole(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_deploymentprivile_user_id_2ac00d41376e2a8d_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_deploymentprivilege |
| ADD CONSTRAINT core_deploymentprivile_user_id_2ac00d41376e2a8d_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_flavo_deployment_id_33af1c761c0497e3_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_flavor_deployments |
| ADD CONSTRAINT core_flavo_deployment_id_33af1c761c0497e3_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_flavor_deploy_flavor_id_3e598722be0b3446_fk_core_flavor_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_flavor_deployments |
| ADD CONSTRAINT core_flavor_deploy_flavor_id_3e598722be0b3446_fk_core_flavor_id FOREIGN KEY (flavor_id) REFERENCES core_flavor(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_image_deployment_id_31772dfdcf4b80eb_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_imagedeployments |
| ADD CONSTRAINT core_image_deployment_id_31772dfdcf4b80eb_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_imagedeployment_image_id_4a6df22c06603b40_fk_core_image_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_imagedeployments |
| ADD CONSTRAINT core_imagedeployment_image_id_4a6df22c06603b40_fk_core_image_id FOREIGN KEY (image_id) REFERENCES core_image(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_insta_deployment_id_111e2cdd025ec8ef_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_insta_deployment_id_111e2cdd025ec8ef_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_instance_creator_id_66a7e8c819d15b29_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_creator_id_66a7e8c819d15b29_fk_core_user_id FOREIGN KEY (creator_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_instance_flavor_id_61bc3198a5673218_fk_core_flavor_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_flavor_id_61bc3198a5673218_fk_core_flavor_id FOREIGN KEY (flavor_id) REFERENCES core_flavor(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_instance_image_id_5c8c96fe9a61802c_fk_core_image_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_image_id_5c8c96fe9a61802c_fk_core_image_id FOREIGN KEY (image_id) REFERENCES core_image(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_instance_node_id_ae899cb7a62df9a_fk_core_node_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_node_id_ae899cb7a62df9a_fk_core_node_id FOREIGN KEY (node_id) REFERENCES core_node(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_instance_slice_id_2ddcfe06a9e4c985_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_instance |
| ADD CONSTRAINT core_instance_slice_id_2ddcfe06a9e4c985_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_invoice_account_id_7802a49ab0cec433_fk_core_account_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_invoice |
| ADD CONSTRAINT core_invoice_account_id_7802a49ab0cec433_fk_core_account_id FOREIGN KEY (account_id) REFERENCES core_account(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_ne_template_id_7268a8d58aa4008e_fk_core_networktemplate_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network |
| ADD CONSTRAINT core_ne_template_id_7268a8d58aa4008e_fk_core_networktemplate_id FOREIGN KEY (template_id) REFERENCES core_networktemplate(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_network_owner_id_1b5a720eac1f1d6c_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network |
| ADD CONSTRAINT core_network_owner_id_1b5a720eac1f1d6c_fk_core_slice_id FOREIGN KEY (owner_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_network_perm_network_id_79f8a18a0197dd1_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network_permitted_slices |
| ADD CONSTRAINT core_network_perm_network_id_79f8a18a0197dd1_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_network_permitt_slice_id_7d7e6e1a0b962f45_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_network_permitted_slices |
| ADD CONSTRAINT core_network_permitt_slice_id_7d7e6e1a0b962f45_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_networkslic_network_id_2823f40a154bc2e6_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkslice |
| ADD CONSTRAINT core_networkslic_network_id_2823f40a154bc2e6_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_networkslice_slice_id_801f34a8ab285a0_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_networkslice |
| ADD CONSTRAINT core_networkslice_slice_id_801f34a8ab285a0_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_node_site_id_28bac05ef1a512ce_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_node |
| ADD CONSTRAINT core_node_site_id_28bac05ef1a512ce_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_payment_account_id_3cc9ae7e7b925002_fk_core_account_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_payment |
| ADD CONSTRAINT core_payment_account_id_3cc9ae7e7b925002_fk_core_account_id FOREIGN KEY (account_id) REFERENCES core_account(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_port_instance_id_5bdb1ae59ca1dc73_fk_core_instance_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_port |
| ADD CONSTRAINT core_port_instance_id_5bdb1ae59ca1dc73_fk_core_instance_id FOREIGN KEY (instance_id) REFERENCES core_instance(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_port_network_id_655a9dc4ef32f845_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_port |
| ADD CONSTRAINT core_port_network_id_655a9dc4ef32f845_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_program_owner_id_491cb2182952268e_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_program |
| ADD CONSTRAINT core_program_owner_id_491cb2182952268e_fk_core_user_id FOREIGN KEY (owner_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_re_resource_id_1126f44e743a899d_fk_core_serviceresource_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservedresource |
| ADD CONSTRAINT core_re_resource_id_1126f44e743a899d_fk_core_serviceresource_id FOREIGN KEY (resource_id) REFERENCES core_serviceresource(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_reservation_slice_id_4df07726653daed_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservation |
| ADD CONSTRAINT core_reservation_slice_id_4df07726653daed_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_reservedr_instance_id_626caea355f5195e_fk_core_instance_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_reservedresource |
| ADD CONSTRAINT core_reservedr_instance_id_626caea355f5195e_fk_core_instance_id FOREIGN KEY (instance_id) REFERENCES core_instance(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_router_netw_network_id_12bc59c5ca78fdc0_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_router_networks |
| ADD CONSTRAINT core_router_netw_network_id_12bc59c5ca78fdc0_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_router_networ_router_id_3cf4f94bd7970e88_fk_core_router_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_router_networks |
| ADD CONSTRAINT core_router_networ_router_id_3cf4f94bd7970e88_fk_core_router_id FOREIGN KEY (router_id) REFERENCES core_router(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_router_owner_id_13c4ac38c56512c6_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_router |
| ADD CONSTRAINT core_router_owner_id_13c4ac38c56512c6_fk_core_slice_id FOREIGN KEY (owner_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_router_permi_network_id_8ee54284c93cd43_fk_core_network_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_router_permittedNetworks" |
| ADD CONSTRAINT core_router_permi_network_id_8ee54284c93cd43_fk_core_network_id FOREIGN KEY (network_id) REFERENCES core_network(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_router_permit_router_id_3506769cdaf40bb5_fk_core_router_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY "core_router_permittedNetworks" |
| ADD CONSTRAINT core_router_permit_router_id_3506769cdaf40bb5_fk_core_router_id FOREIGN KEY (router_id) REFERENCES core_router(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_s_serviceclass_id_7fa5b55190a88c84_fk_core_serviceclass_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceresource |
| ADD CONSTRAINT core_s_serviceclass_id_7fa5b55190a88c84_fk_core_serviceclass_id FOREIGN KEY ("serviceClass_id") REFERENCES core_serviceclass(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_serviceattr_service_id_5dd88bdc4a289e9e_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceattribute |
| ADD CONSTRAINT core_serviceattr_service_id_5dd88bdc4a289e9e_fk_core_service_id FOREIGN KEY (service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_servicepri_role_id_2516e31051d592b9_fk_core_servicerole_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege |
| ADD CONSTRAINT core_servicepri_role_id_2516e31051d592b9_fk_core_servicerole_id FOREIGN KEY (role_id) REFERENCES core_servicerole(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_servicepriv_service_id_326f2584a82884fb_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege |
| ADD CONSTRAINT core_servicepriv_service_id_326f2584a82884fb_fk_core_service_id FOREIGN KEY (service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_serviceprivilege_user_id_5e78485b5063e04_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_serviceprivilege |
| ADD CONSTRAINT core_serviceprivilege_user_id_5e78485b5063e04_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sitecredential_site_id_2ede808de256b5ca_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitecredential |
| ADD CONSTRAINT core_sitecredential_site_id_2ede808de256b5ca_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sited_controller_id_30291acda546cff3_fk_core_controller_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment |
| ADD CONSTRAINT core_sited_controller_id_30291acda546cff3_fk_core_controller_id FOREIGN KEY (controller_id) REFERENCES core_controller(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sited_deployment_id_2073c8bc2ac33aee_fk_core_deployment_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment |
| ADD CONSTRAINT core_sited_deployment_id_2073c8bc2ac33aee_fk_core_deployment_id FOREIGN KEY (deployment_id) REFERENCES core_deployment(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sitedeployment_site_id_10d760d1d81e2090_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sitedeployment |
| ADD CONSTRAINT core_sitedeployment_site_id_10d760d1d81e2090_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_siteprivilege_role_id_71e5069ae809cb06_fk_core_siterole_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_siteprivilege |
| ADD CONSTRAINT core_siteprivilege_role_id_71e5069ae809cb06_fk_core_siterole_id FOREIGN KEY (role_id) REFERENCES core_siterole(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_siteprivilege_site_id_33ec92307c1cb3bd_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_siteprivilege |
| ADD CONSTRAINT core_siteprivilege_site_id_33ec92307c1cb3bd_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_siteprivilege_user_id_4a58c40e58eea8c5_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_siteprivilege |
| ADD CONSTRAINT core_siteprivilege_user_id_4a58c40e58eea8c5_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sl_serviceclass_id_77da7f94b58488b_fk_core_serviceclass_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_sl_serviceclass_id_77da7f94b58488b_fk_core_serviceclass_id FOREIGN KEY ("serviceClass_id") REFERENCES core_serviceclass(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slice_creator_id_7c5fa82797e0d281_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_creator_id_7c5fa82797e0d281_fk_core_user_id FOREIGN KEY (creator_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slice_default_flavor_id_7e9b60d7e92ce276_fk_core_flavor_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_default_flavor_id_7e9b60d7e92ce276_fk_core_flavor_id FOREIGN KEY (default_flavor_id) REFERENCES core_flavor(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slice_default_image_id_4cc5967fffec96da_fk_core_image_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_default_image_id_4cc5967fffec96da_fk_core_image_id FOREIGN KEY (default_image_id) REFERENCES core_image(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slice_service_id_56ec7a0b3401bf7c_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_service_id_56ec7a0b3401bf7c_fk_core_service_id FOREIGN KEY (service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slice_site_id_13fe089488dd45_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slice |
| ADD CONSTRAINT core_slice_site_id_13fe089488dd45_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slicecredential_slice_id_1c79ffce7dd61f3c_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slicecredential |
| ADD CONSTRAINT core_slicecredential_slice_id_1c79ffce7dd61f3c_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sliceprivile_role_id_1d55e0b0ac43107a_fk_core_slicerole_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege |
| ADD CONSTRAINT core_sliceprivile_role_id_1d55e0b0ac43107a_fk_core_slicerole_id FOREIGN KEY (role_id) REFERENCES core_slicerole(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sliceprivilege_slice_id_3fbaadbffeb24835_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege |
| ADD CONSTRAINT core_sliceprivilege_slice_id_3fbaadbffeb24835_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_sliceprivilege_user_id_253eeb2ddef0e745_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_sliceprivilege |
| ADD CONSTRAINT core_sliceprivilege_user_id_253eeb2ddef0e745_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_slicetag_slice_id_75dfa2524457256_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_slicetag |
| ADD CONSTRAINT core_slicetag_slice_id_75dfa2524457256_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_tag_service_id_5e53fc9f784e1c0_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tag |
| ADD CONSTRAINT core_tag_service_id_5e53fc9f784e1c0_fk_core_service_id FOREIGN KEY (service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_te_provider_service_id_6f2ead723387396a_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core_te_provider_service_id_6f2ead723387396a_fk_core_service_id FOREIGN KEY (provider_service_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_te_subscriber_tenant_id_5c45dc20d190aa0f_fk_core_tenant_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core_te_subscriber_tenant_id_5c45dc20d190aa0f_fk_core_tenant_id FOREIGN KEY (subscriber_tenant_id) REFERENCES core_tenant(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_tena_tenant_root_id_27d6362f903728d9_fk_core_tenantroot_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege |
| ADD CONSTRAINT core_tena_tenant_root_id_27d6362f903728d9_fk_core_tenantroot_id FOREIGN KEY (tenant_root_id) REFERENCES core_tenantroot(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_tenant_subscriber_user_id_2fad15bb074ed3d6_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenant |
| ADD CONSTRAINT core_tenant_subscriber_user_id_2fad15bb074ed3d6_fk_core_user_id FOREIGN KEY (subscriber_user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_tenantro_role_id_56bfa65de5fb299_fk_core_tenantrootrole_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege |
| ADD CONSTRAINT core_tenantro_role_id_56bfa65de5fb299_fk_core_tenantrootrole_id FOREIGN KEY (role_id) REFERENCES core_tenantrootrole(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_tenantrootprivile_user_id_77f85e71ff279b56_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_tenantrootprivilege |
| ADD CONSTRAINT core_tenantrootprivile_user_id_77f85e71ff279b56_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_user_site_id_3cc7d076f7b58a7_fk_core_site_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_user |
| ADD CONSTRAINT core_user_site_id_3cc7d076f7b58a7_fk_core_site_id FOREIGN KEY (site_id) REFERENCES core_site(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_usercredential_user_id_2db1046eae94c01a_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_usercredential |
| ADD CONSTRAINT core_usercredential_user_id_2db1046eae94c01a_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: core_userdashboardview_user_id_66fac29b72c1b321_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY core_userdashboardview |
| ADD CONSTRAINT core_userdashboardview_user_id_66fac29b72c1b321_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: d9aeae61481f9ccd18f57c7b51a38461; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap |
| ADD CONSTRAINT d9aeae61481f9ccd18f57c7b51a38461 FOREIGN KEY ("hpcService_id") REFERENCES hpc_hpcservice(service_ptr_id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: defaultoriginserver_id_3cb657d79e69f1e9_fk_hpc_originserver_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_cdnprefix |
| ADD CONSTRAINT defaultoriginserver_id_3cb657d79e69f1e9_fk_hpc_originserver_id FOREIGN KEY ("defaultOriginServer_id") REFERENCES hpc_originserver(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: djan_content_type_id_697914295151027a_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY django_admin_log |
| ADD CONSTRAINT djan_content_type_id_697914295151027a_fk_django_content_type_id FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: django_admin_log_user_id_52fdd58701c5f563_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY django_admin_log |
| ADD CONSTRAINT django_admin_log_user_id_52fdd58701c5f563_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: ea3ce8ae9fc3a320680647cef82b1a56; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_serviceprovider |
| ADD CONSTRAINT ea3ce8ae9fc3a320680647cef82b1a56 FOREIGN KEY ("hpcService_id") REFERENCES hpc_hpcservice(service_ptr_id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_contentprovider_id_1420a46480bb1aff_fk_hpc_contentprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider_users |
| ADD CONSTRAINT h_contentprovider_id_1420a46480bb1aff_fk_hpc_contentprovider_id FOREIGN KEY (contentprovider_id) REFERENCES hpc_contentprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_contentprovider_id_2f27d5fdbb2459c8_fk_hpc_contentprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_originserver |
| ADD CONSTRAINT h_contentprovider_id_2f27d5fdbb2459c8_fk_hpc_contentprovider_id FOREIGN KEY ("contentProvider_id") REFERENCES hpc_contentprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_contentprovider_id_63639a8e6ca8e2cd_fk_hpc_contentprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_cdnprefix |
| ADD CONSTRAINT h_contentprovider_id_63639a8e6ca8e2cd_fk_hpc_contentprovider_id FOREIGN KEY ("contentProvider_id") REFERENCES hpc_contentprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_contentprovider_id_7acf72f284b3b30e_fk_hpc_contentprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_accessmap |
| ADD CONSTRAINT h_contentprovider_id_7acf72f284b3b30e_fk_hpc_contentprovider_id FOREIGN KEY ("contentProvider_id") REFERENCES hpc_contentprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_serviceprovider_id_1b9fb41a73ac1b6a_fk_hpc_serviceprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider |
| ADD CONSTRAINT h_serviceprovider_id_1b9fb41a73ac1b6a_fk_hpc_serviceprovider_id FOREIGN KEY ("serviceProvider_id") REFERENCES hpc_serviceprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: h_serviceprovider_id_788bfbe86c90f205_fk_hpc_serviceprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap |
| ADD CONSTRAINT h_serviceprovider_id_788bfbe86c90f205_fk_hpc_serviceprovider_id FOREIGN KEY ("serviceProvider_id") REFERENCES hpc_serviceprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: hp_contentprovider_id_2a37a8e8bee9c03_fk_hpc_contentprovider_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap |
| ADD CONSTRAINT hp_contentprovider_id_2a37a8e8bee9c03_fk_hpc_contentprovider_id FOREIGN KEY ("contentProvider_id") REFERENCES hpc_contentprovider(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: hpc_contentprovider_us_user_id_480a7cd783fecf37_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_contentprovider_users |
| ADD CONSTRAINT hpc_contentprovider_us_user_id_480a7cd783fecf37_fk_core_user_id FOREIGN KEY (user_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: hpc_hpcservi_service_ptr_id_1b2f328c77b1554d_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_hpcservice |
| ADD CONSTRAINT hpc_hpcservi_service_ptr_id_1b2f328c77b1554d_fk_core_service_id FOREIGN KEY (service_ptr_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: hpc_sitemap_cdnprefix_id_3c0b2f75c5a9a81e_fk_hpc_cdnprefix_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY hpc_sitemap |
| ADD CONSTRAINT hpc_sitemap_cdnprefix_id_3c0b2f75c5a9a81e_fk_hpc_cdnprefix_id FOREIGN KEY ("cdnPrefix_id") REFERENCES hpc_cdnprefix(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: requestroute_service_ptr_id_479451a78740d081_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY requestrouter_requestrouterservice |
| ADD CONSTRAINT requestroute_service_ptr_id_479451a78740d081_fk_core_service_id FOREIGN KEY (service_ptr_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: requestrouter_serv_owner_id_5c71a9586041d2bc_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY requestrouter_servicemap |
| ADD CONSTRAINT requestrouter_serv_owner_id_5c71a9586041d2bc_fk_core_service_id FOREIGN KEY (owner_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: requestrouter_servic_slice_id_50e57057a561f22f_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY requestrouter_servicemap |
| ADD CONSTRAINT requestrouter_servic_slice_id_50e57057a561f22f_fk_core_slice_id FOREIGN KEY (slice_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: sy_volume_id_id_7dd16c76bfd7b129_fk_syndicate_storage_volume_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeslice |
| ADD CONSTRAINT sy_volume_id_id_7dd16c76bfd7b129_fk_syndicate_storage_volume_id FOREIGN KEY (volume_id_id) REFERENCES syndicate_storage_volume(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndi_volume_id_3718f5b02d2245ce_fk_syndicate_storage_volume_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeaccessright |
| ADD CONSTRAINT syndi_volume_id_3718f5b02d2245ce_fk_syndicate_storage_volume_id FOREIGN KEY (volume_id) REFERENCES syndicate_storage_volume(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndicate_st_service_ptr_id_26ca3aeabed50b6d_fk_core_service_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_syndicateservice |
| ADD CONSTRAINT syndicate_st_service_ptr_id_26ca3aeabed50b6d_fk_core_service_id FOREIGN KEY (service_ptr_id) REFERENCES core_service(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndicate_storage__owner_id_id_3d3e3d492d6cd6b5_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeaccessright |
| ADD CONSTRAINT syndicate_storage__owner_id_id_3d3e3d492d6cd6b5_fk_core_user_id FOREIGN KEY (owner_id_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndicate_storage__owner_id_id_7a99f36bf51f2c78_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volume |
| ADD CONSTRAINT syndicate_storage__owner_id_id_7a99f36bf51f2c78_fk_core_user_id FOREIGN KEY (owner_id_id) REFERENCES core_user(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndicate_storage_slice_id_id_1c80c36535559ad6_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_slicesecret |
| ADD CONSTRAINT syndicate_storage_slice_id_id_1c80c36535559ad6_fk_core_slice_id FOREIGN KEY (slice_id_id) REFERENCES core_slice(id) DEFERRABLE INITIALLY DEFERRED; |
| |
| |
| -- |
| -- Name: syndicate_storage_slice_id_id_36fa39a9ae458538_fk_core_slice_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres |
| -- |
| |
| ALTER TABLE ONLY syndicate_storage_volumeslice |
| ADD CONSTRAINT syndicate_storage_slice_id_id_36fa39a9ae458538_fk_core_slice_id FOREIGN KEY (slice_id_id) REFERENCES core_slice(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; |
| |
| |
| -- |
| -- PostgreSQL database dump complete |
| -- |
| |