This repository has been archived by the owner on Aug 30, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 24
persistence 3.4 eucalyptus sql
chris grzegorczyk edited this page Jul 16, 2013
·
1 revision
--
-- PostgreSQL database cluster dump
--
\connect postgres
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
--
-- Roles
--
CREATE ROLE eucalyptus;
ALTER ROLE eucalyptus WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION PASSWORD 'md5ed320d148257942b390f914d512370f1';
CREATE ROLE root;
ALTER ROLE root WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN REPLICATION;
--
-- Database creation
--
CREATE DATABASE database_events WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_auth WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_autoscaling WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_cloud WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_cloudwatch WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_config WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_dns WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_faults WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_general WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_imaging WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_loadbalancing WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_records WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_reporting WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_storage WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_vmwarebroker WITH TEMPLATE = template0 OWNER = eucalyptus;
CREATE DATABASE eucalyptus_walrus WITH TEMPLATE = template0 OWNER = eucalyptus;
\connect database_events
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: database_upgrade_log; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE database_upgrade_log (
id character varying(255) NOT NULL,
"timestamp" timestamp without time zone,
upgrade_from_version character varying(255),
upgrade_to_version character varying(255),
upgrade_state character varying(255)
);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_auth
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: auth_access_key; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_access_key (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_access_key_query_id character varying(255),
auth_access_key_active boolean,
auth_access_key_create_date timestamp without time zone,
auth_access_key_key character varying(255),
auth_access_key_owning_user character varying(255)
);
--
-- Name: auth_account; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_account (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_account_number character varying(255),
auth_account_name character varying(255)
);
--
-- Name: auth_auth; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_auth (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_auth_effect character varying(255),
auth_auth_not_action boolean,
auth_auth_not_resource boolean,
auth_auth_type character varying(255),
auth_auth_owning_statement character varying(255)
);
--
-- Name: auth_auth_action_list; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_auth_action_list (
authorizationentity_id character varying(255) NOT NULL,
auth_auth_actions character varying(255)
);
--
-- Name: auth_auth_resource_list; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_auth_resource_list (
authorizationentity_id character varying(255) NOT NULL,
auth_auth_resources character varying(255)
);
--
-- Name: auth_cert; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_cert (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_certificate_active boolean,
auth_certificate_id character varying(255),
auth_certificate_create_date timestamp without time zone,
auth_certificate_pem text,
auth_certificate_revoked boolean,
auth_certificate_owning_user character varying(255)
);
--
-- Name: auth_condition; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_condition (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_condition_key character varying(255),
auth_condition_type character varying(255),
auth_condition_owning_statement character varying(255)
);
--
-- Name: auth_condition_value_list; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_condition_value_list (
conditionentity_id character varying(255) NOT NULL,
auth_condition_values character varying(255)
);
--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_group (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_group_id_external character varying(255),
auth_group_name character varying(255),
auth_group_path character varying(255),
auth_group_user_group boolean,
auth_group_owning_account character varying(255)
);
--
-- Name: auth_group_has_users; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_group_has_users (
auth_group_id character varying(255) NOT NULL,
auth_user_id character varying(255) NOT NULL
);
--
-- Name: auth_instance_profile; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_instance_profile (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_instance_profile_id_external character varying(255) NOT NULL,
auth_instance_profile_name character varying(255) NOT NULL,
auth_instance_profile_path character varying(255) NOT NULL,
auth_instance_profile_unique_name character varying(255) NOT NULL,
auth_instance_profile_owning_account character varying(255) NOT NULL,
auth_instance_profile_role character varying(255)
);
--
-- Name: auth_policy; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_policy (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_policy_name character varying(255),
auth_policy_version character varying(255),
auth_policy_text text,
auth_policy_owning_group character varying(255),
auth_policy_owning_role character varying(255)
);
--
-- Name: auth_principal; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_principal (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_principal_not_principal boolean NOT NULL,
auth_principal_type character varying(255) NOT NULL,
auth_principal_owning_statement character varying(255) NOT NULL
);
--
-- Name: auth_principal_value_list; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_principal_value_list (
principalentity_id character varying(255) NOT NULL,
auth_principal_value character varying(255)
);
--
-- Name: auth_role; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_role (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_role_name character varying(255) NOT NULL,
auth_role_path character varying(255) NOT NULL,
auth_role_id_external character varying(255) NOT NULL,
auth_role_secret character varying(255) NOT NULL,
auth_role_unique_name character varying(255) NOT NULL,
auth_role_owning_account character varying(255) NOT NULL,
auth_role_assume_role_policy_id character varying(255) NOT NULL
);
--
-- Name: auth_statement; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_statement (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_statement_sid character varying(255),
auth_statement_owning_policy character varying(255)
);
--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_user (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
auth_user_confirmation_code character varying(255),
auth_user_is_enabled boolean,
auth_user_name character varying(255),
auth_user_password character varying(255),
auth_user_password_expires bigint,
auth_user_path character varying(255),
auth_user_reg_stat character varying(255),
auth_user_token character varying(255),
auth_user_id_external character varying(255)
);
--
-- Name: auth_user_info_map; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE auth_user_info_map (
userentity_id character varying(255) NOT NULL,
auth_user_info_value character varying(255),
auth_user_info_key character varying(255) NOT NULL
);
--
-- Name: auth_access_key_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_access_key
ADD CONSTRAINT auth_access_key_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_access_key_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_access_key
ADD CONSTRAINT auth_access_key_pkey PRIMARY KEY (id);
--
-- Name: auth_account_auth_account_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_account
ADD CONSTRAINT auth_account_auth_account_name_key UNIQUE (auth_account_name);
--
-- Name: auth_account_auth_account_number_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_account
ADD CONSTRAINT auth_account_auth_account_number_key UNIQUE (auth_account_number);
--
-- Name: auth_account_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_account
ADD CONSTRAINT auth_account_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_account_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_account
ADD CONSTRAINT auth_account_pkey PRIMARY KEY (id);
--
-- Name: auth_auth_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_auth
ADD CONSTRAINT auth_auth_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_auth_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_auth
ADD CONSTRAINT auth_auth_pkey PRIMARY KEY (id);
--
-- Name: auth_cert_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_cert
ADD CONSTRAINT auth_cert_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_cert_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_cert
ADD CONSTRAINT auth_cert_pkey PRIMARY KEY (id);
--
-- Name: auth_condition_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_condition
ADD CONSTRAINT auth_condition_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_condition_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_condition
ADD CONSTRAINT auth_condition_pkey PRIMARY KEY (id);
--
-- Name: auth_group_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_group
ADD CONSTRAINT auth_group_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_group
ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);
--
-- Name: auth_instance_profile_auth_instance_profile_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_instance_profile
ADD CONSTRAINT auth_instance_profile_auth_instance_profile_unique_name_key UNIQUE (auth_instance_profile_unique_name);
--
-- Name: auth_instance_profile_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_instance_profile
ADD CONSTRAINT auth_instance_profile_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_instance_profile_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_instance_profile
ADD CONSTRAINT auth_instance_profile_pkey PRIMARY KEY (id);
--
-- Name: auth_policy_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_policy
ADD CONSTRAINT auth_policy_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_policy_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_policy
ADD CONSTRAINT auth_policy_pkey PRIMARY KEY (id);
--
-- Name: auth_principal_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_principal
ADD CONSTRAINT auth_principal_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_principal_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_principal
ADD CONSTRAINT auth_principal_pkey PRIMARY KEY (id);
--
-- Name: auth_role_auth_role_assume_role_policy_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT auth_role_auth_role_assume_role_policy_id_key UNIQUE (auth_role_assume_role_policy_id);
--
-- Name: auth_role_auth_role_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT auth_role_auth_role_unique_name_key UNIQUE (auth_role_unique_name);
--
-- Name: auth_role_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT auth_role_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_role_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT auth_role_pkey PRIMARY KEY (id);
--
-- Name: auth_statement_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_statement
ADD CONSTRAINT auth_statement_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_statement_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_statement
ADD CONSTRAINT auth_statement_pkey PRIMARY KEY (id);
--
-- Name: auth_user_info_map_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_user_info_map
ADD CONSTRAINT auth_user_info_map_pkey PRIMARY KEY (userentity_id, auth_user_info_key);
--
-- Name: auth_user_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_user
ADD CONSTRAINT auth_user_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_user
ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
--
-- Name: fk42162687f62c5f2f; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_condition_value_list
ADD CONSTRAINT fk42162687f62c5f2f FOREIGN KEY (conditionentity_id) REFERENCES auth_condition(id);
--
-- Name: fk43d534445620f6e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_condition
ADD CONSTRAINT fk43d534445620f6e FOREIGN KEY (auth_condition_owning_statement) REFERENCES auth_statement(id);
--
-- Name: fk570b01df723a0a33; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_auth
ADD CONSTRAINT fk570b01df723a0a33 FOREIGN KEY (auth_auth_owning_statement) REFERENCES auth_statement(id);
--
-- Name: fk570bae5b4bb5efa8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_cert
ADD CONSTRAINT fk570bae5b4bb5efa8 FOREIGN KEY (auth_certificate_owning_user) REFERENCES auth_user(id);
--
-- Name: fk5712a4ad75bbe921; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT fk5712a4ad75bbe921 FOREIGN KEY (auth_role_owning_account) REFERENCES auth_account(id);
--
-- Name: fk5712a4ad9d0bb460; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_role
ADD CONSTRAINT fk5712a4ad9d0bb460 FOREIGN KEY (auth_role_assume_role_policy_id) REFERENCES auth_policy(id);
--
-- Name: fk76dc0ffb8eaedda3; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_access_key
ADD CONSTRAINT fk76dc0ffb8eaedda3 FOREIGN KEY (auth_access_key_owning_user) REFERENCES auth_user(id);
--
-- Name: fk8aa85928f69d4f46; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_group
ADD CONSTRAINT fk8aa85928f69d4f46 FOREIGN KEY (auth_group_owning_account) REFERENCES auth_account(id);
--
-- Name: fk9f02e6a78ba3b7ef; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_auth_action_list
ADD CONSTRAINT fk9f02e6a78ba3b7ef FOREIGN KEY (authorizationentity_id) REFERENCES auth_auth(id);
--
-- Name: fk9fa2e9b63a19d0f8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_instance_profile
ADD CONSTRAINT fk9fa2e9b63a19d0f8 FOREIGN KEY (auth_instance_profile_owning_account) REFERENCES auth_account(id);
--
-- Name: fk9fa2e9b6e52d3623; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_instance_profile
ADD CONSTRAINT fk9fa2e9b6e52d3623 FOREIGN KEY (auth_instance_profile_role) REFERENCES auth_role(id);
--
-- Name: fkaac089946f9b4a4f; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_principal_value_list
ADD CONSTRAINT fkaac089946f9b4a4f FOREIGN KEY (principalentity_id) REFERENCES auth_principal(id);
--
-- Name: fkbb4b0f984beee58e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_statement
ADD CONSTRAINT fkbb4b0f984beee58e FOREIGN KEY (auth_statement_owning_policy) REFERENCES auth_policy(id);
--
-- Name: fkca18a9cc1d534769; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_group_has_users
ADD CONSTRAINT fkca18a9cc1d534769 FOREIGN KEY (auth_group_id) REFERENCES auth_group(id);
--
-- Name: fkca18a9cca88f66d1; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_group_has_users
ADD CONSTRAINT fkca18a9cca88f66d1 FOREIGN KEY (auth_user_id) REFERENCES auth_user(id);
--
-- Name: fkcb925657bf2734bb; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_principal
ADD CONSTRAINT fkcb925657bf2734bb FOREIGN KEY (auth_principal_owning_statement) REFERENCES auth_statement(id);
--
-- Name: fkd5049fcf8ba3b7ef; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_auth_resource_list
ADD CONSTRAINT fkd5049fcf8ba3b7ef FOREIGN KEY (authorizationentity_id) REFERENCES auth_auth(id);
--
-- Name: fkd99297a97b6d53c9; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_policy
ADD CONSTRAINT fkd99297a97b6d53c9 FOREIGN KEY (auth_policy_owning_group) REFERENCES auth_group(id);
--
-- Name: fkd99297a9bf690d67; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_policy
ADD CONSTRAINT fkd99297a9bf690d67 FOREIGN KEY (auth_policy_owning_role) REFERENCES auth_role(id);
--
-- Name: fkef1635e8125523e5; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY auth_user_info_map
ADD CONSTRAINT fkef1635e8125523e5 FOREIGN KEY (userentity_id) REFERENCES auth_user(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_autoscaling
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: metadata_auto_scaling_group_availability_zones; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_availability_zones (
autoscalinggroup_id character varying(255) NOT NULL,
metadata_availability_zone character varying(255),
metadata_availability_zone_index integer NOT NULL
);
--
-- Name: metadata_auto_scaling_group_enabled_metrics; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_enabled_metrics (
autoscalinggroup_id character varying(255) NOT NULL,
metadata_metric character varying(255)
);
--
-- Name: metadata_auto_scaling_group_load_balancers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_load_balancers (
autoscalinggroup_id character varying(255) NOT NULL,
metadata_load_balancer_name character varying(255),
metadata_load_balancer_index integer NOT NULL
);
--
-- Name: metadata_auto_scaling_group_scaling_causes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_scaling_causes (
autoscalinggroup_id character varying(255) NOT NULL,
metadata_detail character varying(255) NOT NULL,
metadata_timestamp timestamp without time zone NOT NULL,
metadata_scaling_causes_index integer NOT NULL
);
--
-- Name: metadata_auto_scaling_group_suspended_processes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_suspended_processes (
autoscalinggroup_id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
metadata_reason character varying(255) NOT NULL,
metadata_scaling_process_type character varying(255) NOT NULL
);
--
-- Name: metadata_auto_scaling_group_termination_policies; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_group_termination_policies (
autoscalinggroup_id character varying(255) NOT NULL,
metadata_termination_policy character varying(255),
metadata_policy_index integer NOT NULL
);
--
-- Name: metadata_auto_scaling_groups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_groups (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_capacity integer NOT NULL,
metadata_capacity_timestamp timestamp without time zone NOT NULL,
metadata_default_cooldown integer NOT NULL,
metadata_desired_capacity integer NOT NULL,
metadata_health_check_grace_period integer,
metadata_health_check_type character varying(255) NOT NULL,
metadata_max_size integer NOT NULL,
metadata_min_size integer NOT NULL,
metadata_scaling_required boolean NOT NULL,
metadata_launch_configuration_id character varying(255) NOT NULL
);
--
-- Name: metadata_auto_scaling_instances; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_auto_scaling_instances (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_auto_scaling_group_name character varying(255) NOT NULL,
metadata_availability_zone character varying(255) NOT NULL,
metadata_configuration_state character varying(255) NOT NULL,
metadata_health_status character varying(255) NOT NULL,
metadata_in_service_timestamp timestamp without time zone,
metadata_launch_configuration_name character varying(255) NOT NULL,
metadata_lifecycle_state character varying(255) NOT NULL,
metadata_registration_attempts integer NOT NULL,
metadata_auto_scaling_group_id character varying(255) NOT NULL
);
--
-- Name: metadata_launch_configuration_block_device_mappings; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_launch_configuration_block_device_mappings (
launchconfiguration_id character varying(255) NOT NULL,
metadata_device_name character varying(255) NOT NULL,
metadata_snapshot_id character varying(255),
metadata_virtual_name character varying(255),
metadata_volume_size integer,
metadata_device_mapping_index integer NOT NULL
);
--
-- Name: metadata_launch_configuration_security_groups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_launch_configuration_security_groups (
launchconfiguration_id character varying(255) NOT NULL,
metadata_security_group character varying(255),
metadata_security_group_index integer NOT NULL
);
--
-- Name: metadata_launch_configurations; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_launch_configurations (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_instance_profile character varying(1600),
metadata_image_id character varying(255) NOT NULL,
metadata_instance_monitoring boolean,
metadata_instance_type character varying(255) NOT NULL,
metadata_kernel_id character varying(255),
metadata_key_name character varying(255),
metadata_ramdisk_id character varying(255),
metadata_user_data text
);
--
-- Name: metadata_scaling_activities; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_scaling_activities (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_auto_scaling_group_name character varying(255) NOT NULL,
metadata_client_token character varying(255),
metadata_description character varying(255),
metadata_details character varying(255),
metadata_end_time timestamp without time zone,
metadata_progress integer NOT NULL,
metadata_status_code character varying(255) NOT NULL,
metadata_status_message character varying(255),
metadata_group_id character varying(255) NOT NULL
);
--
-- Name: metadata_scaling_activity_causes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_scaling_activity_causes (
scalingactivity_id character varying(255) NOT NULL,
metadata_cause character varying(255) NOT NULL,
metadata_timestamp timestamp without time zone NOT NULL,
metadata_cause_index integer NOT NULL
);
--
-- Name: metadata_scaling_policies; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_scaling_policies (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_adjustment_type character varying(255) NOT NULL,
metadata_auto_scaling_group_name character varying(255) NOT NULL,
metadata_cooldown integer,
metadata_min_adjustment_step integer,
metadata_scaling_adjustment integer NOT NULL,
metadata_group_id character varying(255) NOT NULL
);
--
-- Name: metadata_tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(128) NOT NULL,
metadata_account_id character varying(255),
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_unique_name character varying(600) NOT NULL,
metadata_propagate_at_launch boolean NOT NULL,
metadata_resource_id character varying(255) NOT NULL,
metadata_tag_value character varying(256) NOT NULL
);
--
-- Name: metadata_tags_groups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_groups (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_unavailable_zones; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_unavailable_zones (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_name character varying(255) NOT NULL
);
--
-- Name: metadata_auto_scaling_group_availability_zones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_availability_zones
ADD CONSTRAINT metadata_auto_scaling_group_availability_zones_pkey PRIMARY KEY (autoscalinggroup_id, metadata_availability_zone_index);
--
-- Name: metadata_auto_scaling_group_load_balancers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_load_balancers
ADD CONSTRAINT metadata_auto_scaling_group_load_balancers_pkey PRIMARY KEY (autoscalinggroup_id, metadata_load_balancer_index);
--
-- Name: metadata_auto_scaling_group_scaling_causes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_scaling_causes
ADD CONSTRAINT metadata_auto_scaling_group_scaling_causes_pkey PRIMARY KEY (autoscalinggroup_id, metadata_scaling_causes_index);
--
-- Name: metadata_auto_scaling_group_suspended_processes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_suspended_processes
ADD CONSTRAINT metadata_auto_scaling_group_suspended_processes_pkey PRIMARY KEY (autoscalinggroup_id, creation_timestamp, metadata_reason, metadata_scaling_process_type);
--
-- Name: metadata_auto_scaling_group_termination_policies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_termination_policies
ADD CONSTRAINT metadata_auto_scaling_group_termination_policies_pkey PRIMARY KEY (autoscalinggroup_id, metadata_policy_index);
--
-- Name: metadata_auto_scaling_groups_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_groups
ADD CONSTRAINT metadata_auto_scaling_groups_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_auto_scaling_groups_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_groups
ADD CONSTRAINT metadata_auto_scaling_groups_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_auto_scaling_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_groups
ADD CONSTRAINT metadata_auto_scaling_groups_pkey PRIMARY KEY (id);
--
-- Name: metadata_auto_scaling_instances_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_instances
ADD CONSTRAINT metadata_auto_scaling_instances_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_auto_scaling_instances_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_instances
ADD CONSTRAINT metadata_auto_scaling_instances_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_auto_scaling_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_instances
ADD CONSTRAINT metadata_auto_scaling_instances_pkey PRIMARY KEY (id);
--
-- Name: metadata_launch_configuration_block_device_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configuration_block_device_mappings
ADD CONSTRAINT metadata_launch_configuration_block_device_mappings_pkey PRIMARY KEY (launchconfiguration_id, metadata_device_mapping_index);
--
-- Name: metadata_launch_configuration_security_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configuration_security_groups
ADD CONSTRAINT metadata_launch_configuration_security_groups_pkey PRIMARY KEY (launchconfiguration_id, metadata_security_group_index);
--
-- Name: metadata_launch_configurations_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configurations
ADD CONSTRAINT metadata_launch_configurations_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_launch_configurations_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configurations
ADD CONSTRAINT metadata_launch_configurations_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_launch_configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configurations
ADD CONSTRAINT metadata_launch_configurations_pkey PRIMARY KEY (id);
--
-- Name: metadata_scaling_activities_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activities
ADD CONSTRAINT metadata_scaling_activities_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_scaling_activities_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activities
ADD CONSTRAINT metadata_scaling_activities_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_scaling_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activities
ADD CONSTRAINT metadata_scaling_activities_pkey PRIMARY KEY (id);
--
-- Name: metadata_scaling_activity_causes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activity_causes
ADD CONSTRAINT metadata_scaling_activity_causes_pkey PRIMARY KEY (scalingactivity_id, metadata_cause_index);
--
-- Name: metadata_scaling_policies_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_policies
ADD CONSTRAINT metadata_scaling_policies_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_scaling_policies_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_policies
ADD CONSTRAINT metadata_scaling_policies_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_scaling_policies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_policies
ADD CONSTRAINT metadata_scaling_policies_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_groups
ADD CONSTRAINT metadata_tags_groups_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_tags_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_pkey PRIMARY KEY (id);
--
-- Name: metadata_unavailable_zones_metadata_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_unavailable_zones
ADD CONSTRAINT metadata_unavailable_zones_metadata_name_key UNIQUE (metadata_name);
--
-- Name: metadata_unavailable_zones_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_unavailable_zones
ADD CONSTRAINT metadata_unavailable_zones_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_unavailable_zones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_unavailable_zones
ADD CONSTRAINT metadata_unavailable_zones_pkey PRIMARY KEY (id);
--
-- Name: fk10c6295b23a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_availability_zones
ADD CONSTRAINT fk10c6295b23a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk186a32b5c40ae852; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activities
ADD CONSTRAINT fk186a32b5c40ae852 FOREIGN KEY (metadata_group_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk1e354e0123a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_suspended_processes
ADD CONSTRAINT fk1e354e0123a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk35e2b7773480bac3; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configuration_block_device_mappings
ADD CONSTRAINT fk35e2b7773480bac3 FOREIGN KEY (launchconfiguration_id) REFERENCES metadata_launch_configurations(id);
--
-- Name: fk408b5d0cf761bb0c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_groups
ADD CONSTRAINT fk408b5d0cf761bb0c FOREIGN KEY (metadata_launch_configuration_id) REFERENCES metadata_launch_configurations(id);
--
-- Name: fk452211ee3480bac3; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_launch_configuration_security_groups
ADD CONSTRAINT fk452211ee3480bac3 FOREIGN KEY (launchconfiguration_id) REFERENCES metadata_launch_configurations(id);
--
-- Name: fk492f2fda23a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_scaling_causes
ADD CONSTRAINT fk492f2fda23a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk4befea9298afb153; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_activity_causes
ADD CONSTRAINT fk4befea9298afb153 FOREIGN KEY (scalingactivity_id) REFERENCES metadata_scaling_activities(id);
--
-- Name: fk5262312323a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_termination_policies
ADD CONSTRAINT fk5262312323a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk62b8d8fc23a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_load_balancers
ADD CONSTRAINT fk62b8d8fc23a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk7246fa18c40ae852; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_scaling_policies
ADD CONSTRAINT fk7246fa18c40ae852 FOREIGN KEY (metadata_group_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fk73f510462b56a27a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_instances
ADD CONSTRAINT fk73f510462b56a27a FOREIGN KEY (metadata_auto_scaling_group_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fkd39a0faa55063b1e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_groups
ADD CONSTRAINT fkd39a0faa55063b1e FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- Name: fkd39a0faac505731a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_groups
ADD CONSTRAINT fkd39a0faac505731a FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkdd5d35cd23a1c03a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_auto_scaling_group_enabled_metrics
ADD CONSTRAINT fkdd5d35cd23a1c03a FOREIGN KEY (autoscalinggroup_id) REFERENCES metadata_auto_scaling_groups(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_cloud
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: cloud_address_configuration; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE cloud_address_configuration (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_addr_do_dynamic_public_addresses boolean DEFAULT true NOT NULL,
config_addr_orphan_ticks integer NOT NULL,
config_addr_orphan_grace integer NOT NULL,
config_addr_reserved_public_addresses integer
);
--
-- Name: cloud_cluster_configuration; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE cloud_cluster_configuration (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_cluster_interval_disabled bigint NOT NULL,
config_cluster_interval_enabled bigint NOT NULL,
config_cluster_interval_notready bigint NOT NULL,
config_cluster_interval_pending bigint NOT NULL,
config_cluster_workers integer NOT NULL,
config_cluster_startup_sync_retries integer NOT NULL
);
--
-- Name: cloud_image_configuration; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE cloud_image_configuration (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_image_default_kernel_id character varying(255),
config_image_default_ramdisk_id character varying(255),
config_image_is_public boolean DEFAULT false NOT NULL
);
--
-- Name: cloud_vm_type; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE cloud_vm_type (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_vm_type_cpu integer,
config_vm_type_disk integer,
config_vm_type_ebs_iops integer,
config_vm_type_ebs_only boolean,
config_vm_type_memory integer,
config_vm_type_name character varying(255),
config_vm_type_64bit_only boolean
);
--
-- Name: config_vm_types_ephemeral_disks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_vm_types_ephemeral_disks (
vmtype_id character varying(255) NOT NULL,
config_vm_type_ephemeral_device_name character varying(255),
config_vm_type_ephemeral_disk_name character varying(255),
config_vm_type_ephemeral_format character varying(255),
config_vm_type_ephemeral_size integer
);
--
-- Name: metadata_addresses; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_addresses (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255)
);
--
-- Name: metadata_conversion_images; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_conversion_images (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_conversion_expiration_time timestamp without time zone,
metadata_conversion_manifest_location character varying(255),
metadata_conversion_status_message character varying(255)
);
--
-- Name: metadata_conversion_instances; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_conversion_instances (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_conversion_expiration_time timestamp without time zone,
metadata_conversion_manifest_location character varying(255),
metadata_conversion_status_message character varying(255),
metadata_conversion_state character varying(255)
);
--
-- Name: metadata_conversion_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_conversion_volumes (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_conversion_expiration_time timestamp without time zone,
metadata_conversion_manifest_location character varying(255),
metadata_conversion_status_message character varying(255),
metadata_conversion_state character varying(255)
);
--
-- Name: metadata_device_mappings; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_device_mappings (
metadata_device_mapping_discriminator character varying(31) NOT NULL,
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_device_mapping_type character varying(255),
metadata_device_mapping_device_name character varying(255),
metadata_device_mapping_virtual_name character varying(255),
metadata_device_mapping_blockstorage_delete boolean,
metadata_device_mapping_blockstorage_size integer,
metadata_device_mapping_blockstorage_snapshot_id character varying(255),
metadata_device_mapping_ephemeral_number integer,
metadata_image_dev_map_fk character varying(255)
);
--
-- Name: metadata_extant_network; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_extant_network (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_extant_network_tag integer,
networkgroup_id character varying(255)
);
--
-- Name: metadata_images; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_images (
metadata_image_discriminator character varying(31) NOT NULL,
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_image_arch character varying(255) NOT NULL,
metadata_image_description character varying(255),
metadata_image_name character varying(255) NOT NULL,
metadata_image_is_public boolean DEFAULT false,
metadata_image_size_bytes bigint NOT NULL,
metadata_image_type character varying(255),
metadata_image_platform character varying(255) NOT NULL,
metadata_image_del_vol_on_terminate boolean,
metadata_image_kernel_id character varying(255),
metadata_image_ramdisk_id character varying(255),
metadata_image_root_device character varying(255),
metadata_image_snapshot_id character varying(255),
metadata_image_bundle_size bigint,
metadata_image_unencrypted_checksum character varying(255),
metadata_image_unencrypted_checksum_type character varying(255),
metadata_image_manifest_path character varying(255),
metadata_image_signature text
);
--
-- Name: metadata_images_pcodes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_images_pcodes (
imageinfo_id character varying(255) NOT NULL,
productcodes character varying(255)
);
--
-- Name: metadata_images_permissions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_images_permissions (
imageinfo_id character varying(255) NOT NULL,
permissions character varying(255)
);
--
-- Name: metadata_instances; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_vm_monitoring boolean,
metadata_vm_platform character varying(255),
metadata_vm_sshkey text,
metadata_vm_user_data bytea,
metadata_vm_expiration timestamp without time zone,
metadata_vm_launch_index integer,
metadata_vm_launch_time timestamp without time zone,
metadata_vm_mac_address character varying(255),
metadata_vm_private_address character varying(255),
metadata_vm_private_dns character varying(255),
metadata_vm_public_address character varying(255),
metadata_vm_public_dns character varying(255),
metadata_vm_private_addressing boolean,
metadata_vm_cluster_name character varying(255),
metadata_vm_partition_name character varying(255),
metadata_vm_placement character varying(255),
metadata_vm_private_networking boolean,
metadata_vm_bundle_bucket character varying(255),
metadata_vm_bundle_error_code character varying(255),
metadata_vm_bundle_error_msg character varying(255),
metadata_vm_bundle_policy character varying(255),
metadata_vm_bundle_prefix character varying(255),
metadata_vm_bundle_progress integer,
metadata_vm_bundle_start_time timestamp without time zone,
metadata_vm_bundle_state character varying(255),
metadata_vm_bundle_update_time timestamp without time zone,
metadata_vm_createimage_error_code character varying(255),
metadata_vm_createimage_error_msg character varying(255),
metadata_vm_createimage_progress character varying(255),
metadata_vm_createimage_start_time timestamp without time zone,
metadata_vm_createimage_state character varying(255),
metadata_vm_createimage_update_time timestamp without time zone,
metadata_vm_migration_dest_host character varying(255),
metadata_vm_migration_state_timer timestamp without time zone,
metadata_vm_migration_source_host character varying(255),
metadata_vm_migration_state character varying(255),
metadata_vm_password_data text,
metadata_vm_pending boolean,
metadata_vm_reason character varying(255),
metadata_vm_service_tag character varying(255),
metadata_vm_block_bytes bigint,
metadata_vm_network_bytes bigint,
metadata_vm_client_token character varying(255),
metadata_vm_instance_id character varying(255),
metadata_vm_nameorarn character varying(255),
metadata_vm_reservation_id character varying(255),
metadata_vm_client_token_unique character varying(255),
kernel_id character varying(255),
machineimage_id character varying(255),
ramdisk_id character varying(255),
metadata_vm_type_id character varying(255),
metadata_vm_network_index character varying(255)
);
--
-- Name: metadata_instances_ephemeral_storage; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances_ephemeral_storage (
vminstance_id character varying(255) NOT NULL,
metadata_vm_device character varying(255),
metadata_vm_ephemeral_id character varying(255)
);
--
-- Name: metadata_instances_metadata_network_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances_metadata_network_group (
metadata_instances_id character varying(255) NOT NULL,
networkgroups_id character varying(255) NOT NULL
);
--
-- Name: metadata_instances_persistent_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances_persistent_volumes (
vminstance_id character varying(255) NOT NULL,
metadata_vm_volume_attach_time timestamp without time zone,
metadata_vm_vol_delete_on_terminate boolean,
metadata_vm_volume_device character varying(255),
metadata_vm_volume_is_root_device boolean DEFAULT false,
metadata_vm_volume_remote_device text DEFAULT ''::text,
metadata_vm_volume_status character varying(255),
metadata_vm_volume_id character varying(255)
);
--
-- Name: metadata_instances_state_reasons; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances_state_reasons (
vminstance_id character varying(255) NOT NULL,
reasondetails character varying(255)
);
--
-- Name: metadata_instances_volume_attachments; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_instances_volume_attachments (
vminstance_id character varying(255) NOT NULL,
metadata_vm_volume_attach_time timestamp without time zone,
metadata_vm_vol_delete_on_terminate boolean,
metadata_vm_volume_device character varying(255),
metadata_vm_volume_is_root_device boolean DEFAULT false,
metadata_vm_volume_remote_device text DEFAULT ''::text,
metadata_vm_volume_status character varying(255),
metadata_vm_volume_id character varying(255)
);
--
-- Name: metadata_keypairs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_keypairs (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_keypair_finger_print character varying(255),
metadata_keypair_public_key text
);
--
-- Name: metadata_network_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_network_group (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_network_group_description character varying(255),
metadata_network_group_id character varying(255),
vm_network_index character varying(255)
);
--
-- Name: metadata_network_group_rule_peers; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_network_group_rule_peers (
networkrule_id character varying(255) NOT NULL,
network_rule_peer_network_group_id character varying(255),
network_rule_peer_network_user_group character varying(255),
network_rule_peer_network_user_query_key character varying(255)
);
--
-- Name: metadata_network_indices; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_network_indices (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_network_index_bogus_id character varying(255),
metadata_network_index bigint,
metadata_network_index_extant_network_fk character varying(255),
metadata_extant_network_index_fk character varying(255)
);
--
-- Name: metadata_network_rule; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_network_rule (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_network_rule_high_port integer,
metadata_network_rule_low_port integer,
metadata_network_rule_protocol character varying(255),
metadata_network_group_rule_fk character varying(255)
);
--
-- Name: metadata_network_rule_ip_ranges; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_network_rule_ip_ranges (
networkrule_id character varying(255) NOT NULL,
ipranges character varying(255)
);
--
-- Name: metadata_snapshots; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_snapshots (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_snapshot_description character varying(255),
metadata_snapshot_parentvolume character varying(255),
metadata_snapshot_progress character varying(255),
metadata_snapshot_vol_partition character varying(255),
metadata_snapshot_vol_sc character varying(255),
metadata_snapshot_vol_size integer
);
--
-- Name: metadata_tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(128) NOT NULL,
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_resource_id character varying(255) NOT NULL,
metadata_tag_value character varying(256) NOT NULL
);
--
-- Name: metadata_tags_images; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_images (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_tags_instances; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_instances (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_tags_network_groups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_network_groups (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_tags_snapshots; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_snapshots (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_tags_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_tags_volumes (
id character varying(255) NOT NULL,
metadata_tag_resource_id character varying(255) NOT NULL
);
--
-- Name: metadata_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_volumes (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
metadata_volume_localdevice character varying(255),
metadata_volume_parentsnapshot character varying(255),
metadata_volume_partition character varying(255),
metadata_volume_remotedevice text,
metadata_volume_sc_name character varying(255),
metadata_volume_size integer
);
--
-- Name: cloud_address_configuration_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_address_configuration
ADD CONSTRAINT cloud_address_configuration_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: cloud_address_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_address_configuration
ADD CONSTRAINT cloud_address_configuration_pkey PRIMARY KEY (id);
--
-- Name: cloud_cluster_configuration_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_cluster_configuration
ADD CONSTRAINT cloud_cluster_configuration_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: cloud_cluster_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_cluster_configuration
ADD CONSTRAINT cloud_cluster_configuration_pkey PRIMARY KEY (id);
--
-- Name: cloud_image_configuration_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_image_configuration
ADD CONSTRAINT cloud_image_configuration_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: cloud_image_configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_image_configuration
ADD CONSTRAINT cloud_image_configuration_pkey PRIMARY KEY (id);
--
-- Name: cloud_vm_type_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_vm_type
ADD CONSTRAINT cloud_vm_type_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: cloud_vm_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cloud_vm_type
ADD CONSTRAINT cloud_vm_type_pkey PRIMARY KEY (id);
--
-- Name: metadata_addresses_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_addresses
ADD CONSTRAINT metadata_addresses_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_addresses_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_addresses
ADD CONSTRAINT metadata_addresses_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_addresses_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_addresses
ADD CONSTRAINT metadata_addresses_pkey PRIMARY KEY (id);
--
-- Name: metadata_conversion_images_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_images
ADD CONSTRAINT metadata_conversion_images_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_conversion_images_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_images
ADD CONSTRAINT metadata_conversion_images_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_conversion_images_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_images
ADD CONSTRAINT metadata_conversion_images_pkey PRIMARY KEY (id);
--
-- Name: metadata_conversion_instances_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_instances
ADD CONSTRAINT metadata_conversion_instances_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_conversion_instances_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_instances
ADD CONSTRAINT metadata_conversion_instances_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_conversion_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_instances
ADD CONSTRAINT metadata_conversion_instances_pkey PRIMARY KEY (id);
--
-- Name: metadata_conversion_volumes_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_volumes
ADD CONSTRAINT metadata_conversion_volumes_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_conversion_volumes_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_volumes
ADD CONSTRAINT metadata_conversion_volumes_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_conversion_volumes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_conversion_volumes
ADD CONSTRAINT metadata_conversion_volumes_pkey PRIMARY KEY (id);
--
-- Name: metadata_device_mappings_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_device_mappings
ADD CONSTRAINT metadata_device_mappings_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_device_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_device_mappings
ADD CONSTRAINT metadata_device_mappings_pkey PRIMARY KEY (id);
--
-- Name: metadata_extant_network_metadata_extant_network_tag_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_extant_network
ADD CONSTRAINT metadata_extant_network_metadata_extant_network_tag_key UNIQUE (metadata_extant_network_tag);
--
-- Name: metadata_extant_network_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_extant_network
ADD CONSTRAINT metadata_extant_network_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_extant_network_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_extant_network
ADD CONSTRAINT metadata_extant_network_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_extant_network_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_extant_network
ADD CONSTRAINT metadata_extant_network_pkey PRIMARY KEY (id);
--
-- Name: metadata_images_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_images
ADD CONSTRAINT metadata_images_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_images_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_images
ADD CONSTRAINT metadata_images_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_images_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_images
ADD CONSTRAINT metadata_images_pkey PRIMARY KEY (id);
--
-- Name: metadata_instances_metadata_network_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_metadata_network_group
ADD CONSTRAINT metadata_instances_metadata_network_group_pkey PRIMARY KEY (metadata_instances_id, networkgroups_id);
--
-- Name: metadata_instances_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT metadata_instances_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_instances_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT metadata_instances_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_instances_metadata_vm_client_token_unique_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT metadata_instances_metadata_vm_client_token_unique_key UNIQUE (metadata_vm_client_token_unique);
--
-- Name: metadata_instances_persistent_volumes_metadata_vm_volume_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_persistent_volumes
ADD CONSTRAINT metadata_instances_persistent_volumes_metadata_vm_volume_id_key UNIQUE (metadata_vm_volume_id);
--
-- Name: metadata_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT metadata_instances_pkey PRIMARY KEY (id);
--
-- Name: metadata_instances_volume_attachments_metadata_vm_volume_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_volume_attachments
ADD CONSTRAINT metadata_instances_volume_attachments_metadata_vm_volume_id_key UNIQUE (metadata_vm_volume_id);
--
-- Name: metadata_keypairs_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_keypairs
ADD CONSTRAINT metadata_keypairs_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_keypairs_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_keypairs
ADD CONSTRAINT metadata_keypairs_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_keypairs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_keypairs
ADD CONSTRAINT metadata_keypairs_pkey PRIMARY KEY (id);
--
-- Name: metadata_network_group_metadata_network_group_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group
ADD CONSTRAINT metadata_network_group_metadata_network_group_id_key UNIQUE (metadata_network_group_id);
--
-- Name: metadata_network_group_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group
ADD CONSTRAINT metadata_network_group_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_network_group_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group
ADD CONSTRAINT metadata_network_group_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_network_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group
ADD CONSTRAINT metadata_network_group_pkey PRIMARY KEY (id);
--
-- Name: metadata_network_indices_metadata_network_index_bogus_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT metadata_network_indices_metadata_network_index_bogus_id_key UNIQUE (metadata_network_index_bogus_id);
--
-- Name: metadata_network_indices_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT metadata_network_indices_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_network_indices_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT metadata_network_indices_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_network_indices_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT metadata_network_indices_pkey PRIMARY KEY (id);
--
-- Name: metadata_network_rule_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_rule
ADD CONSTRAINT metadata_network_rule_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_network_rule_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_rule
ADD CONSTRAINT metadata_network_rule_pkey PRIMARY KEY (id);
--
-- Name: metadata_snapshots_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_snapshots
ADD CONSTRAINT metadata_snapshots_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_snapshots_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_snapshots
ADD CONSTRAINT metadata_snapshots_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_snapshots
ADD CONSTRAINT metadata_snapshots_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_images_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_images
ADD CONSTRAINT metadata_tags_images_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_instances
ADD CONSTRAINT metadata_tags_instances_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_tags_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_tags_network_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_network_groups
ADD CONSTRAINT metadata_tags_network_groups_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags
ADD CONSTRAINT metadata_tags_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_snapshots
ADD CONSTRAINT metadata_tags_snapshots_pkey PRIMARY KEY (id);
--
-- Name: metadata_tags_volumes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_volumes
ADD CONSTRAINT metadata_tags_volumes_pkey PRIMARY KEY (id);
--
-- Name: metadata_volumes_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_volumes
ADD CONSTRAINT metadata_volumes_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_volumes_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_volumes
ADD CONSTRAINT metadata_volumes_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_volumes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_volumes
ADD CONSTRAINT metadata_volumes_pkey PRIMARY KEY (id);
--
-- Name: fk13183ff03475beed; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_state_reasons
ADD CONSTRAINT fk13183ff03475beed FOREIGN KEY (vminstance_id) REFERENCES metadata_instances(id);
--
-- Name: fk26c6860f212a216d; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_metadata_network_group
ADD CONSTRAINT fk26c6860f212a216d FOREIGN KEY (networkgroups_id) REFERENCES metadata_network_group(id);
--
-- Name: fk26c6860f84f70a8b; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_metadata_network_group
ADD CONSTRAINT fk26c6860f84f70a8b FOREIGN KEY (metadata_instances_id) REFERENCES metadata_instances(id);
--
-- Name: fk28560cac4a600596; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_rule_ip_ranges
ADD CONSTRAINT fk28560cac4a600596 FOREIGN KEY (networkrule_id) REFERENCES metadata_network_rule(id);
--
-- Name: fk2d7769623475beed; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_persistent_volumes
ADD CONSTRAINT fk2d7769623475beed FOREIGN KEY (vminstance_id) REFERENCES metadata_instances(id);
--
-- Name: fk34fff57d21a84a3c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_rule
ADD CONSTRAINT fk34fff57d21a84a3c FOREIGN KEY (metadata_network_group_rule_fk) REFERENCES metadata_network_group(id);
--
-- Name: fk3c35284dedaf6c8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_images_permissions
ADD CONSTRAINT fk3c35284dedaf6c8 FOREIGN KEY (imageinfo_id) REFERENCES metadata_images(id);
--
-- Name: fk45157a25f1ac537e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_extant_network
ADD CONSTRAINT fk45157a25f1ac537e FOREIGN KEY (networkgroup_id) REFERENCES metadata_network_group(id);
--
-- Name: fk6207681e3dcbec9d; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_device_mappings
ADD CONSTRAINT fk6207681e3dcbec9d FOREIGN KEY (metadata_image_dev_map_fk) REFERENCES metadata_images(id);
--
-- Name: fk6a62681ed068841d; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group
ADD CONSTRAINT fk6a62681ed068841d FOREIGN KEY (vm_network_index) REFERENCES metadata_extant_network(id);
--
-- Name: fk7171f87c3475beed; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_volume_attachments
ADD CONSTRAINT fk7171f87c3475beed FOREIGN KEY (vminstance_id) REFERENCES metadata_instances(id);
--
-- Name: fk85cec5483475beed; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances_ephemeral_storage
ADD CONSTRAINT fk85cec5483475beed FOREIGN KEY (vminstance_id) REFERENCES metadata_instances(id);
--
-- Name: fkac754cdb67b32ae4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_network_groups
ADD CONSTRAINT fkac754cdb67b32ae4 FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkac754cdb9822352c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_network_groups
ADD CONSTRAINT fkac754cdb9822352c FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_network_group(id);
--
-- Name: fkaf58f0e867b32ae4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_instances
ADD CONSTRAINT fkaf58f0e867b32ae4 FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkaf58f0e8ef8ee1b6; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_instances
ADD CONSTRAINT fkaf58f0e8ef8ee1b6 FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_instances(id);
--
-- Name: fkb3dc818331d9d86d; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_volumes
ADD CONSTRAINT fkb3dc818331d9d86d FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_volumes(id);
--
-- Name: fkb3dc818367b32ae4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_volumes
ADD CONSTRAINT fkb3dc818367b32ae4 FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkbbfcd59967b32ae4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_snapshots
ADD CONSTRAINT fkbbfcd59967b32ae4 FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkbbfcd5997a891017; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_snapshots
ADD CONSTRAINT fkbbfcd5997a891017 FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_snapshots(id);
--
-- Name: fkbdc151865dab4005; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT fkbdc151865dab4005 FOREIGN KEY (metadata_network_index_extant_network_fk) REFERENCES metadata_extant_network(id);
--
-- Name: fkbdc15186e5313450; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_indices
ADD CONSTRAINT fkbdc15186e5313450 FOREIGN KEY (metadata_extant_network_index_fk) REFERENCES metadata_extant_network(id);
--
-- Name: fkd6b6b84e4f4dcaee; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_images
ADD CONSTRAINT fkd6b6b84e4f4dcaee FOREIGN KEY (metadata_tag_resource_id) REFERENCES metadata_images(id);
--
-- Name: fkd6b6b84e67b32ae4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_tags_images
ADD CONSTRAINT fkd6b6b84e67b32ae4 FOREIGN KEY (id) REFERENCES metadata_tags(id);
--
-- Name: fkdd81d70f4a600596; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_network_group_rule_peers
ADD CONSTRAINT fkdd81d70f4a600596 FOREIGN KEY (networkrule_id) REFERENCES metadata_network_rule(id);
--
-- Name: fkdea106358b6ca4a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_vm_types_ephemeral_disks
ADD CONSTRAINT fkdea106358b6ca4a FOREIGN KEY (vmtype_id) REFERENCES cloud_vm_type(id);
--
-- Name: fked02a84dedaf6c8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_images_pcodes
ADD CONSTRAINT fked02a84dedaf6c8 FOREIGN KEY (imageinfo_id) REFERENCES metadata_images(id);
--
-- Name: fkf1c9856e1f7bea69; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT fkf1c9856e1f7bea69 FOREIGN KEY (metadata_vm_type_id) REFERENCES cloud_vm_type(id);
--
-- Name: fkf1c9856e3f4b7fff; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT fkf1c9856e3f4b7fff FOREIGN KEY (ramdisk_id) REFERENCES metadata_images(id);
--
-- Name: fkf1c9856e63e1b9fd; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT fkf1c9856e63e1b9fd FOREIGN KEY (machineimage_id) REFERENCES metadata_images(id);
--
-- Name: fkf1c9856eca2aec57; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT fkf1c9856eca2aec57 FOREIGN KEY (kernel_id) REFERENCES metadata_images(id);
--
-- Name: fkf1c9856ef1c0f6c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_instances
ADD CONSTRAINT fkf1c9856ef1c0f6c FOREIGN KEY (metadata_vm_network_index) REFERENCES metadata_network_indices(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_cloudwatch
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: absolute_metric_history; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE absolute_metric_history (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dimension_name character varying(255) NOT NULL,
dimension_value character varying(255) NOT NULL,
last_metric_value double precision NOT NULL,
metric_name character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
"timestamp" timestamp without time zone NOT NULL
);
--
-- Name: alarm_history; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE alarm_history (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
account_id character varying(255) NOT NULL,
alarm_name character varying(255) NOT NULL,
history_data character varying(4095),
history_item_type character varying(255) NOT NULL,
history_summary character varying(255) NOT NULL,
"timestamp" timestamp without time zone NOT NULL
);
--
-- Name: alarms; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE alarms (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
actions_enabled boolean NOT NULL,
alarm_action_1 text,
alarm_action_2 text,
alarm_action_3 text,
alarm_action_4 text,
alarm_action_5 text,
alarm_configuration_updated_timestamp timestamp without time zone NOT NULL,
alarm_description character varying(255),
alarm_name character varying(255) NOT NULL,
comparison_operator character varying(255) NOT NULL,
evaluation_periods integer NOT NULL,
insufficient_data_action_1 text,
insufficient_data_action_2 text,
insufficient_data_action_3 text,
insufficient_data_action_4 text,
insufficient_data_action_5 text,
last_actions_executed_timestamp timestamp without time zone NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
ok_action_1 text,
ok_action_2 text,
ok_action_3 text,
ok_action_4 text,
ok_action_5 text,
period integer NOT NULL,
state_reason character varying(1023),
state_reason_data character varying(4000),
state_updated_timestamp timestamp without time zone NOT NULL,
state_value character varying(255) NOT NULL,
statistic character varying(255) NOT NULL,
threshold double precision NOT NULL,
unit character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_0; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_0 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_1; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_1 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_2; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_2 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_3; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_3 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_4; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_4 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_5; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_5 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_6; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_6 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_7; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_7 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_8; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_8 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_9; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_9 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_a; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_a (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_b; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_b (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_c; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_c (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_d; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_d (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_e; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_e (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: custom_metric_data_f; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE custom_metric_data_f (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: list_metrics; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE list_metrics (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL
);
--
-- Name: metric_data; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metric_data (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_0; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_0 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_1; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_1 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_2; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_2 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_3; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_3 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_4; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_4 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_5; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_5 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_6; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_6 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_7; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_7 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_8; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_8 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_9; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_9 (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_a; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_a (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_b; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_b (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_c; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_c (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_d; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_d (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_e; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_e (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: system_metric_data_f; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_metric_data_f (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dim_10_name character varying(255),
dim_10_value character varying(255),
dim_1_name character varying(255),
dim_1_value character varying(255),
dim_2_name character varying(255),
dim_2_value character varying(255),
dim_3_name character varying(255),
dim_3_value character varying(255),
dim_4_name character varying(255),
dim_4_value character varying(255),
dim_5_name character varying(255),
dim_5_value character varying(255),
dim_6_name character varying(255),
dim_6_value character varying(255),
dim_7_name character varying(255),
dim_7_value character varying(255),
dim_8_name character varying(255),
dim_8_value character varying(255),
dim_9_name character varying(255),
dim_9_value character varying(255),
account_id character varying(255) NOT NULL,
dimension_hash character varying(255) NOT NULL,
metric_name character varying(255) NOT NULL,
metric_type character varying(255) NOT NULL,
namespace character varying(255) NOT NULL,
sample_max double precision NOT NULL,
sample_min double precision NOT NULL,
sample_size double precision NOT NULL,
sample_sum double precision NOT NULL,
"timestamp" timestamp without time zone NOT NULL,
units character varying(255) NOT NULL
);
--
-- Name: absolute_metric_history_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY absolute_metric_history
ADD CONSTRAINT absolute_metric_history_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: absolute_metric_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY absolute_metric_history
ADD CONSTRAINT absolute_metric_history_pkey PRIMARY KEY (id);
--
-- Name: alarm_history_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY alarm_history
ADD CONSTRAINT alarm_history_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: alarm_history_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY alarm_history
ADD CONSTRAINT alarm_history_pkey PRIMARY KEY (id);
--
-- Name: alarms_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY alarms
ADD CONSTRAINT alarms_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: alarms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY alarms
ADD CONSTRAINT alarms_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_0_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_0
ADD CONSTRAINT custom_metric_data_0_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_0_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_0
ADD CONSTRAINT custom_metric_data_0_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_1_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_1
ADD CONSTRAINT custom_metric_data_1_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_1_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_1
ADD CONSTRAINT custom_metric_data_1_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_2_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_2
ADD CONSTRAINT custom_metric_data_2_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_2_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_2
ADD CONSTRAINT custom_metric_data_2_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_3_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_3
ADD CONSTRAINT custom_metric_data_3_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_3_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_3
ADD CONSTRAINT custom_metric_data_3_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_4_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_4
ADD CONSTRAINT custom_metric_data_4_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_4_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_4
ADD CONSTRAINT custom_metric_data_4_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_5_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_5
ADD CONSTRAINT custom_metric_data_5_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_5_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_5
ADD CONSTRAINT custom_metric_data_5_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_6_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_6
ADD CONSTRAINT custom_metric_data_6_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_6_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_6
ADD CONSTRAINT custom_metric_data_6_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_7_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_7
ADD CONSTRAINT custom_metric_data_7_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_7_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_7
ADD CONSTRAINT custom_metric_data_7_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_8_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_8
ADD CONSTRAINT custom_metric_data_8_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_8_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_8
ADD CONSTRAINT custom_metric_data_8_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_9_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_9
ADD CONSTRAINT custom_metric_data_9_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_9_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_9
ADD CONSTRAINT custom_metric_data_9_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_a_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_a
ADD CONSTRAINT custom_metric_data_a_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_a_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_a
ADD CONSTRAINT custom_metric_data_a_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_b_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_b
ADD CONSTRAINT custom_metric_data_b_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_b_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_b
ADD CONSTRAINT custom_metric_data_b_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_c_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_c
ADD CONSTRAINT custom_metric_data_c_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_c_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_c
ADD CONSTRAINT custom_metric_data_c_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_d_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_d
ADD CONSTRAINT custom_metric_data_d_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_d_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_d
ADD CONSTRAINT custom_metric_data_d_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_e_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_e
ADD CONSTRAINT custom_metric_data_e_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_e_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_e
ADD CONSTRAINT custom_metric_data_e_pkey PRIMARY KEY (id);
--
-- Name: custom_metric_data_f_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_f
ADD CONSTRAINT custom_metric_data_f_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: custom_metric_data_f_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY custom_metric_data_f
ADD CONSTRAINT custom_metric_data_f_pkey PRIMARY KEY (id);
--
-- Name: list_metrics_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY list_metrics
ADD CONSTRAINT list_metrics_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: list_metrics_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY list_metrics
ADD CONSTRAINT list_metrics_pkey PRIMARY KEY (id);
--
-- Name: metric_data_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metric_data
ADD CONSTRAINT metric_data_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metric_data_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metric_data
ADD CONSTRAINT metric_data_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_0_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_0
ADD CONSTRAINT system_metric_data_0_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_0_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_0
ADD CONSTRAINT system_metric_data_0_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_1_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_1
ADD CONSTRAINT system_metric_data_1_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_1_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_1
ADD CONSTRAINT system_metric_data_1_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_2_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_2
ADD CONSTRAINT system_metric_data_2_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_2_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_2
ADD CONSTRAINT system_metric_data_2_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_3_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_3
ADD CONSTRAINT system_metric_data_3_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_3_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_3
ADD CONSTRAINT system_metric_data_3_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_4_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_4
ADD CONSTRAINT system_metric_data_4_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_4_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_4
ADD CONSTRAINT system_metric_data_4_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_5_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_5
ADD CONSTRAINT system_metric_data_5_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_5_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_5
ADD CONSTRAINT system_metric_data_5_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_6_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_6
ADD CONSTRAINT system_metric_data_6_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_6_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_6
ADD CONSTRAINT system_metric_data_6_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_7_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_7
ADD CONSTRAINT system_metric_data_7_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_7_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_7
ADD CONSTRAINT system_metric_data_7_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_8_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_8
ADD CONSTRAINT system_metric_data_8_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_8_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_8
ADD CONSTRAINT system_metric_data_8_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_9_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_9
ADD CONSTRAINT system_metric_data_9_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_9_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_9
ADD CONSTRAINT system_metric_data_9_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_a_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_a
ADD CONSTRAINT system_metric_data_a_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_a_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_a
ADD CONSTRAINT system_metric_data_a_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_b_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_b
ADD CONSTRAINT system_metric_data_b_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_b_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_b
ADD CONSTRAINT system_metric_data_b_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_c_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_c
ADD CONSTRAINT system_metric_data_c_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_c_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_c
ADD CONSTRAINT system_metric_data_c_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_d_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_d
ADD CONSTRAINT system_metric_data_d_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_d_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_d
ADD CONSTRAINT system_metric_data_d_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_e_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_e
ADD CONSTRAINT system_metric_data_e_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_e_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_e
ADD CONSTRAINT system_metric_data_e_pkey PRIMARY KEY (id);
--
-- Name: system_metric_data_f_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_f
ADD CONSTRAINT system_metric_data_f_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_metric_data_f_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_metric_data_f
ADD CONSTRAINT system_metric_data_f_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_config
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: config_component_base; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_component_base (
dtype character varying(31) NOT NULL,
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_component_hostname character varying(255),
config_component_name character varying(255) NOT NULL,
config_component_partition character varying(255),
config_component_port integer,
config_component_service_path character varying(255),
cluster_addrs_per_net integer,
cluster_min_vlan bigint,
cluster_max_network_tag integer,
cluster_min_addr bigint,
cluster_min_network_tag integer,
cluster_network_mode character varying(255),
cluster_alt_source_hostname character varying(255),
cluster_use_network_tags boolean,
cluster_vnet_netmask character varying(255),
cluster_vnet_subnet character varying(255),
cluster_vnet_type character varying(255),
arbitrator_gateway_host character varying(255),
propertyprefix character varying(255),
available_storage_backends character varying(255),
system_storage_ebs_backend character varying(255)
);
--
-- Name: config_partition; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_partition (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_partition_name character varying(255),
config_partition_x509_certificate text,
config_partition_node_x509_certificate text,
config_partition_node_kp text,
config_partition_kp text
);
--
-- Name: config_static_property; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_static_property (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_static_field_name character varying(255) NOT NULL,
config_static_prop_name character varying(255) NOT NULL,
config_static_field_value text
);
--
-- Name: config_system; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_system (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_system_default_kernel character varying(255),
config_system_default_ramdisk character varying(255),
config_system_registration_id character varying(255)
);
--
-- Name: config_unique_ids_sets; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE config_unique_ids_sets (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
config_unique_ids_current_base bigint,
config_unique_ids_set_name character varying(255)
);
--
-- Name: config_component_base_config_component_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_component_base
ADD CONSTRAINT config_component_base_config_component_name_key UNIQUE (config_component_name);
--
-- Name: config_component_base_metadata_perm_uuid_config_component_n_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_component_base
ADD CONSTRAINT config_component_base_metadata_perm_uuid_config_component_n_key UNIQUE (metadata_perm_uuid, config_component_name);
--
-- Name: config_component_base_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_component_base
ADD CONSTRAINT config_component_base_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: config_component_base_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_component_base
ADD CONSTRAINT config_component_base_pkey PRIMARY KEY (id);
--
-- Name: config_partition_config_partition_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_partition
ADD CONSTRAINT config_partition_config_partition_name_key UNIQUE (config_partition_name);
--
-- Name: config_partition_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_partition
ADD CONSTRAINT config_partition_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: config_partition_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_partition
ADD CONSTRAINT config_partition_pkey PRIMARY KEY (id);
--
-- Name: config_static_property_config_static_field_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_static_property
ADD CONSTRAINT config_static_property_config_static_field_name_key UNIQUE (config_static_field_name);
--
-- Name: config_static_property_config_static_prop_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_static_property
ADD CONSTRAINT config_static_property_config_static_prop_name_key UNIQUE (config_static_prop_name);
--
-- Name: config_static_property_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_static_property
ADD CONSTRAINT config_static_property_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: config_static_property_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_static_property
ADD CONSTRAINT config_static_property_pkey PRIMARY KEY (id);
--
-- Name: config_system_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_system
ADD CONSTRAINT config_system_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: config_system_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_system
ADD CONSTRAINT config_system_pkey PRIMARY KEY (id);
--
-- Name: config_unique_ids_sets_config_unique_ids_set_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_unique_ids_sets
ADD CONSTRAINT config_unique_ids_sets_config_unique_ids_set_name_key UNIQUE (config_unique_ids_set_name);
--
-- Name: config_unique_ids_sets_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_unique_ids_sets
ADD CONSTRAINT config_unique_ids_sets_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: config_unique_ids_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY config_unique_ids_sets
ADD CONSTRAINT config_unique_ids_sets_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_dns
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: arecordaddresses; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE arecordaddresses (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
address character varying(255),
unique_name character varying(255) NOT NULL,
metadata_name_fk character varying(255) NOT NULL
);
--
-- Name: arecordnames; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE arecordnames (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
name character varying(255),
recordclass integer,
ttl bigint,
zone character varying(255)
);
--
-- Name: arecords; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE arecords (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
address character varying(255),
name character varying(255),
recordclass integer,
ttl bigint,
zone character varying(255)
);
--
-- Name: cnamerecords; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE cnamerecords (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
alias character varying(255),
name character varying(255),
recordclass integer,
ttl bigint,
zone character varying(255)
);
--
-- Name: nsrecords; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE nsrecords (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
name character varying(255),
recordclass integer,
target character varying(255),
ttl bigint,
zone character varying(255)
);
--
-- Name: soarecords; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE soarecords (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
admin character varying(255),
expires bigint,
minimum bigint,
name character varying(255),
nameserver character varying(255),
recordclass integer,
refresh bigint,
retry bigint,
serialnumber bigint,
ttl bigint,
zone character varying(255)
);
--
-- Name: zones; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE zones (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
name character varying(255)
);
--
-- Name: arecordaddresses_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordaddresses
ADD CONSTRAINT arecordaddresses_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: arecordaddresses_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordaddresses
ADD CONSTRAINT arecordaddresses_pkey PRIMARY KEY (id);
--
-- Name: arecordaddresses_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordaddresses
ADD CONSTRAINT arecordaddresses_unique_name_key UNIQUE (unique_name);
--
-- Name: arecordnames_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordnames
ADD CONSTRAINT arecordnames_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: arecordnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordnames
ADD CONSTRAINT arecordnames_pkey PRIMARY KEY (id);
--
-- Name: arecords_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecords
ADD CONSTRAINT arecords_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: arecords_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecords
ADD CONSTRAINT arecords_pkey PRIMARY KEY (id);
--
-- Name: cnamerecords_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cnamerecords
ADD CONSTRAINT cnamerecords_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: cnamerecords_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY cnamerecords
ADD CONSTRAINT cnamerecords_pkey PRIMARY KEY (id);
--
-- Name: nsrecords_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY nsrecords
ADD CONSTRAINT nsrecords_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: nsrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY nsrecords
ADD CONSTRAINT nsrecords_pkey PRIMARY KEY (id);
--
-- Name: soarecords_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY soarecords
ADD CONSTRAINT soarecords_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: soarecords_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY soarecords
ADD CONSTRAINT soarecords_pkey PRIMARY KEY (id);
--
-- Name: zones_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY zones
ADD CONSTRAINT zones_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: zones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY zones
ADD CONSTRAINT zones_pkey PRIMARY KEY (id);
--
-- Name: fk239e87d06be0abf8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY arecordaddresses
ADD CONSTRAINT fk239e87d06be0abf8 FOREIGN KEY (metadata_name_fk) REFERENCES arecordnames(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_faults
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: faults_records; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE faults_records (
id character varying(255) NOT NULL,
fault_msg_correlation_id character varying(255),
creation_timestamp timestamp without time zone,
fault_event_epoch integer,
fault_service_state integer,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
fault_service_full_name character varying(255),
fault_service_name character varying(255),
severity character varying(255),
fault_stack_trace text,
fault_timestamp timestamp without time zone,
version integer
);
--
-- Name: faults_records_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY faults_records
ADD CONSTRAINT faults_records_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: faults_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY faults_records
ADD CONSTRAINT faults_records_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_general
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: system_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE system_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dns_domain character varying(255),
nameserver character varying(255),
ns_address character varying(255),
system_registration_id character varying(255)
);
--
-- Name: system_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_info
ADD CONSTRAINT system_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: system_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY system_info
ADD CONSTRAINT system_info_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_imaging
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: imaging_task_state; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE imaging_task_state (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text
);
--
-- Name: imaging_workflow_state; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE imaging_workflow_state (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text
);
--
-- Name: imaging_task_state_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imaging_task_state
ADD CONSTRAINT imaging_task_state_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: imaging_task_state_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imaging_task_state
ADD CONSTRAINT imaging_task_state_pkey PRIMARY KEY (id);
--
-- Name: imaging_workflow_state_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imaging_workflow_state
ADD CONSTRAINT imaging_workflow_state_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: imaging_workflow_state_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imaging_workflow_state
ADD CONSTRAINT imaging_workflow_state_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_loadbalancing
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: metadata_autoscale_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_autoscale_group (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_capacity integer,
metadata_group_name character varying(255) NOT NULL,
metadata_launch_config_name character varying(255) NOT NULL,
unique_name character varying(255) NOT NULL,
metadata_loadbalancer_fk character varying(255)
);
--
-- Name: metadata_backend_instance; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_backend_instance (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
description character varying(255),
instance_update_timestamp timestamp without time zone,
reason_code character varying(255),
metadata_loadbalancer_fk character varying(255),
metadata_zone_fk character varying(255)
);
--
-- Name: metadata_dns; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_dns (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
dns_name character varying(255) NOT NULL,
dns_zone character varying(255) NOT NULL,
unique_name character varying(255) NOT NULL,
metadata_loadbalancer_fk character varying(255) NOT NULL
);
--
-- Name: metadata_group; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_group (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
group_name character varying(255) NOT NULL,
group_owner_account_id character varying(255) NOT NULL,
metadata_state character varying(255) NOT NULL,
metadata_unique_name character varying(255) NOT NULL,
metadata_loadbalancer_fk character varying(255)
);
--
-- Name: metadata_listener; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_listener (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
instance_port integer NOT NULL,
instance_protocol character varying(255),
loadbalancer_port integer NOT NULL,
protocol character varying(255) NOT NULL,
certificate_id character varying(255),
unique_name character varying(255) NOT NULL,
metadata_loadbalancer_fk character varying(255)
);
--
-- Name: metadata_loadbalancer; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_loadbalancer (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_display_name character varying(255),
metadata_last_state character varying(255),
metadata_state character varying(255),
metadata_state_change_stack text,
metadata_account_name character varying(255),
metadata_account_id character varying(255),
metadata_unique_name character varying(255) NOT NULL,
metadata_user_id character varying(255),
metadata_user_name character varying(255),
loadbalancer_healthy_threshold integer,
loadbalancer_healthcheck_interval integer,
loadbalancer_healthcheck_target character varying(255),
loadbalancer_healthcheck_timeout integer,
loadbalancer_unhealthy_threshold integer,
loadbalancer_scheme character varying(255)
);
--
-- Name: metadata_servo_instance; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_servo_instance (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
metadata_address character varying(255),
metadata_dns_state character varying(255),
metadata_instance_id character varying(255) NOT NULL,
metadata_private_ip character varying(255),
metadata_state character varying(255) NOT NULL,
metadata_asg_fk character varying(255),
metadata_dns_fk character varying(255),
metadata_group_fk character varying(255),
metadata_zone_fk character varying(255)
);
--
-- Name: metadata_zone; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata_zone (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
unique_name character varying(255) NOT NULL,
zone_name character varying(255) NOT NULL,
zone_state character varying(255),
metadata_loadbalancer_fk character varying(255) NOT NULL
);
--
-- Name: metadata_autoscale_group_metadata_launch_config_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_autoscale_group
ADD CONSTRAINT metadata_autoscale_group_metadata_launch_config_name_key UNIQUE (metadata_launch_config_name);
--
-- Name: metadata_autoscale_group_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_autoscale_group
ADD CONSTRAINT metadata_autoscale_group_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_autoscale_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_autoscale_group
ADD CONSTRAINT metadata_autoscale_group_pkey PRIMARY KEY (id);
--
-- Name: metadata_autoscale_group_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_autoscale_group
ADD CONSTRAINT metadata_autoscale_group_unique_name_key UNIQUE (unique_name);
--
-- Name: metadata_backend_instance_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_backend_instance
ADD CONSTRAINT metadata_backend_instance_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_backend_instance_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_backend_instance
ADD CONSTRAINT metadata_backend_instance_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_backend_instance_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_backend_instance
ADD CONSTRAINT metadata_backend_instance_pkey PRIMARY KEY (id);
--
-- Name: metadata_dns_dns_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_dns
ADD CONSTRAINT metadata_dns_dns_name_key UNIQUE (dns_name);
--
-- Name: metadata_dns_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_dns
ADD CONSTRAINT metadata_dns_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_dns_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_dns
ADD CONSTRAINT metadata_dns_pkey PRIMARY KEY (id);
--
-- Name: metadata_dns_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_dns
ADD CONSTRAINT metadata_dns_unique_name_key UNIQUE (unique_name);
--
-- Name: metadata_group_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_group
ADD CONSTRAINT metadata_group_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_group_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_group
ADD CONSTRAINT metadata_group_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_group
ADD CONSTRAINT metadata_group_pkey PRIMARY KEY (id);
--
-- Name: metadata_listener_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_listener
ADD CONSTRAINT metadata_listener_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_listener_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_listener
ADD CONSTRAINT metadata_listener_pkey PRIMARY KEY (id);
--
-- Name: metadata_listener_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_listener
ADD CONSTRAINT metadata_listener_unique_name_key UNIQUE (unique_name);
--
-- Name: metadata_loadbalancer_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_loadbalancer
ADD CONSTRAINT metadata_loadbalancer_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_loadbalancer_metadata_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_loadbalancer
ADD CONSTRAINT metadata_loadbalancer_metadata_unique_name_key UNIQUE (metadata_unique_name);
--
-- Name: metadata_loadbalancer_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_loadbalancer
ADD CONSTRAINT metadata_loadbalancer_pkey PRIMARY KEY (id);
--
-- Name: metadata_servo_instance_metadata_instance_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT metadata_servo_instance_metadata_instance_id_key UNIQUE (metadata_instance_id);
--
-- Name: metadata_servo_instance_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT metadata_servo_instance_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_servo_instance_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT metadata_servo_instance_pkey PRIMARY KEY (id);
--
-- Name: metadata_zone_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_zone
ADD CONSTRAINT metadata_zone_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_zone_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_zone
ADD CONSTRAINT metadata_zone_pkey PRIMARY KEY (id);
--
-- Name: metadata_zone_unique_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_zone
ADD CONSTRAINT metadata_zone_unique_name_key UNIQUE (unique_name);
--
-- Name: fk15ea9fc45d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_listener
ADD CONSTRAINT fk15ea9fc45d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- Name: fk42e4e0b14992bf9; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT fk42e4e0b14992bf9 FOREIGN KEY (metadata_group_fk) REFERENCES metadata_group(id);
--
-- Name: fk42e4e0b1f7cbf84; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT fk42e4e0b1f7cbf84 FOREIGN KEY (metadata_asg_fk) REFERENCES metadata_autoscale_group(id);
--
-- Name: fk42e4e0b5e9dcfef; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT fk42e4e0b5e9dcfef FOREIGN KEY (metadata_zone_fk) REFERENCES metadata_zone(id);
--
-- Name: fk42e4e0b8c95974a; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_servo_instance
ADD CONSTRAINT fk42e4e0b8c95974a FOREIGN KEY (metadata_dns_fk) REFERENCES metadata_dns(id);
--
-- Name: fk4ebb00195d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_dns
ADD CONSTRAINT fk4ebb00195d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- Name: fk88af06bc5d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_zone
ADD CONSTRAINT fk88af06bc5d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- Name: fk8c27756f5d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_group
ADD CONSTRAINT fk8c27756f5d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- Name: fk9df3b0f05d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_backend_instance
ADD CONSTRAINT fk9df3b0f05d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- Name: fk9df3b0f05e9dcfef; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_backend_instance
ADD CONSTRAINT fk9df3b0f05e9dcfef FOREIGN KEY (metadata_zone_fk) REFERENCES metadata_zone(id);
--
-- Name: fk9ff1652b5d929353; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata_autoscale_group
ADD CONSTRAINT fk9ff1652b5d929353 FOREIGN KEY (metadata_loadbalancer_fk) REFERENCES metadata_loadbalancer(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_records
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: records; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE records (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
record_code_location character varying(255),
record_correlation_id character varying(255),
record_creator character varying(255),
record_class character varying(255),
record_extra text,
record_level character varying(255),
record_timestamp timestamp without time zone,
record_type character varying(255),
record_user_id character varying(255)
);
--
-- Name: records_logs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE records_logs (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
record_code_location character varying(255),
record_correlation_id character varying(255),
record_creator character varying(255),
record_class character varying(255),
record_extra text,
record_level character varying(255),
record_timestamp timestamp without time zone,
record_type character varying(255),
record_user_id character varying(255),
record_caller character varying(255)
);
--
-- Name: records_logs_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY records_logs
ADD CONSTRAINT records_logs_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: records_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY records_logs
ADD CONSTRAINT records_logs_pkey PRIMARY KEY (id);
--
-- Name: records_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY records
ADD CONSTRAINT records_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY records
ADD CONSTRAINT records_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_reporting
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: reporting_account; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_account (
account_id character varying(255) NOT NULL,
account_name character varying(255) NOT NULL
);
--
-- Name: reporting_elastic_ip_attach_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_elastic_ip_attach_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
instance_uuid character varying(255) NOT NULL,
ip character varying(255) NOT NULL
);
--
-- Name: reporting_elastic_ip_create_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_elastic_ip_create_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
ip character varying(255) NOT NULL,
user_id character varying(255) NOT NULL
);
--
-- Name: reporting_elastic_ip_delete_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_elastic_ip_delete_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
ip character varying(255) NOT NULL
);
--
-- Name: reporting_elastic_ip_detach_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_elastic_ip_detach_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
instance_uuid character varying(255) NOT NULL,
ip character varying(255) NOT NULL
);
--
-- Name: reporting_instance_create_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_instance_create_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
availability_zone character varying(255) NOT NULL,
instance_id character varying(255) NOT NULL,
instance_type character varying(255) NOT NULL,
user_id character varying(255) NOT NULL,
uuid character varying(255) NOT NULL
);
--
-- Name: reporting_instance_usage_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_instance_usage_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
dimension character varying(255) NOT NULL,
metric character varying(255) NOT NULL,
sequencenum bigint NOT NULL,
uuid character varying(255) NOT NULL,
value double precision NOT NULL
);
--
-- Name: reporting_s3_object_create_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_s3_object_create_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
s3_object_version character varying(255),
s3_bucket_name character varying(255) NOT NULL,
s3_object_name character varying(255) NOT NULL,
size bigint NOT NULL,
user_id character varying(255) NOT NULL
);
--
-- Name: reporting_s3_object_delete_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_s3_object_delete_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
s3_object_version character varying(255),
s3_bucket_name character varying(255) NOT NULL,
s3_object_key character varying(255) NOT NULL
);
--
-- Name: reporting_user; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_user (
user_id character varying(255) NOT NULL,
account_id character varying(255) DEFAULT ''::character varying NOT NULL,
user_name character varying(255) NOT NULL
);
--
-- Name: reporting_volume_attach_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_attach_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
instance_uuid character varying(255) NOT NULL,
size_gb bigint NOT NULL,
volume_uuid character varying(255) NOT NULL
);
--
-- Name: reporting_volume_create_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_create_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
availability_zone character varying(255) NOT NULL,
sizegb bigint NOT NULL,
user_id character varying(255) NOT NULL,
uuid character varying(255) NOT NULL,
volume_id character varying(255) NOT NULL
);
--
-- Name: reporting_volume_delete_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_delete_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
uuid character varying(255) NOT NULL
);
--
-- Name: reporting_volume_detach_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_detach_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
instance_uuid character varying(255) NOT NULL,
volume_uuid character varying(255) NOT NULL
);
--
-- Name: reporting_volume_snapshot_create_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_snapshot_create_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
sizegb bigint NOT NULL,
user_id character varying(255) NOT NULL,
uuid character varying(255) NOT NULL,
volume_snapshot_id character varying(255) NOT NULL,
volume_uuid character varying(255) NOT NULL
);
--
-- Name: reporting_volume_snapshot_delete_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reporting_volume_snapshot_delete_events (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone NOT NULL,
timestamp_ms bigint NOT NULL,
uuid character varying(255) NOT NULL
);
--
-- Name: reporting_account_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_account
ADD CONSTRAINT reporting_account_pkey PRIMARY KEY (account_id);
--
-- Name: reporting_elastic_ip_attach_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_elastic_ip_attach_events
ADD CONSTRAINT reporting_elastic_ip_attach_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_elastic_ip_create_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_elastic_ip_create_events
ADD CONSTRAINT reporting_elastic_ip_create_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_elastic_ip_delete_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_elastic_ip_delete_events
ADD CONSTRAINT reporting_elastic_ip_delete_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_elastic_ip_detach_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_elastic_ip_detach_events
ADD CONSTRAINT reporting_elastic_ip_detach_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_instance_create_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_instance_create_events
ADD CONSTRAINT reporting_instance_create_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_instance_usage_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_instance_usage_events
ADD CONSTRAINT reporting_instance_usage_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_s3_object_create_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_s3_object_create_events
ADD CONSTRAINT reporting_s3_object_create_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_s3_object_delete_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_s3_object_delete_events
ADD CONSTRAINT reporting_s3_object_delete_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_user
ADD CONSTRAINT reporting_user_pkey PRIMARY KEY (user_id);
--
-- Name: reporting_volume_attach_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_attach_events
ADD CONSTRAINT reporting_volume_attach_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_volume_create_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_create_events
ADD CONSTRAINT reporting_volume_create_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_volume_create_events_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_create_events
ADD CONSTRAINT reporting_volume_create_events_uuid_key UNIQUE (uuid);
--
-- Name: reporting_volume_delete_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_delete_events
ADD CONSTRAINT reporting_volume_delete_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_volume_detach_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_detach_events
ADD CONSTRAINT reporting_volume_detach_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_volume_snapshot_create_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_snapshot_create_events
ADD CONSTRAINT reporting_volume_snapshot_create_events_pkey PRIMARY KEY (id);
--
-- Name: reporting_volume_snapshot_create_events_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_snapshot_create_events
ADD CONSTRAINT reporting_volume_snapshot_create_events_uuid_key UNIQUE (uuid);
--
-- Name: reporting_volume_snapshot_delete_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reporting_volume_snapshot_delete_events
ADD CONSTRAINT reporting_volume_snapshot_delete_events_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_storage
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: chapuserinfo; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE chapuserinfo (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
encryptedpassword text,
scname character varying(255),
username character varying(255)
);
--
-- Name: das_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE das_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
das_device character varying(255),
storage_name character varying(255)
);
--
-- Name: direct_storage_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE direct_storage_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
storage_name character varying(255),
timeout_in_millis bigint,
system_storage_volumes_dir character varying(255),
zero_fill_volumes boolean
);
--
-- Name: emcvnx_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE emcvnx_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
active_storage_group_cleaning boolean,
naviseccli_path character varying(255),
use_migrate_for_volume boolean,
enable_sync_snaps boolean,
login_scope character varying(255),
lun_migration_timeout integer,
lun_sp_allocator character varying(255),
storage_name character varying(255),
quiesce_threshold_sec character varying(255),
storage_pool character varying(255),
sync_rate character varying(255)
);
--
-- Name: equallogic_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE equallogic_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
multihost_access boolean,
storage_name character varying(255)
);
--
-- Name: equallogicvolumeinfo; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE equallogicvolumeinfo (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
encryptedpassword text,
iqn character varying(255),
scname character varying(255),
size integer,
snapshot_of character varying(255),
status character varying(255),
storeuser character varying(255),
volumeid character varying(255)
);
--
-- Name: igroups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE igroups (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
igroup_name character varying(255),
iqn character varying(255),
lun_id integer,
volume_name character varying(255)
);
--
-- Name: iscsimetadata; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE iscsimetadata (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
hostname character varying(255),
store_number integer,
store_prefix character varying(255),
store_user character varying(255),
tid integer
);
--
-- Name: iscsivolumeinfo; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE iscsivolumeinfo (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
cleanup boolean,
lodev_name character varying(255),
lofile_name character varying(255),
lv_name character varying(255),
pv_name character varying(255),
sc_name character varying(255),
size integer,
snapshot_of character varying(255),
status character varying(255),
vg_name character varying(255),
volume_name character varying(255),
encryptedpassword text,
lun integer,
storename character varying(255),
storeuser character varying(255),
tid integer
);
--
-- Name: netapp_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE netapp_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
netapp_aggregate character varying(255),
auto_snapshots boolean,
clone_retries integer,
convert_ucode character varying(255),
create_ucode character varying(255),
enable_autosize boolean,
fractional_reserve integer,
guarantee character varying(255),
storage_name character varying(255),
no_atime_update character varying(255),
no_snap character varying(255),
snap_percent integer,
snap_sched_days integer,
snap_sched_hours integer,
snap_sched_weeks integer,
snapshot_policy character varying(255),
try_first character varying(255),
use_largest_aggregate boolean,
autosize_increment_mb integer,
autosize_max_multiplier integer,
vserver_name character varying(255)
);
--
-- Name: san_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE san_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
chap_user character varying(255),
storage_name character varying(255),
ncpaths character varying(255),
san_host character varying(255),
san_password text,
san_user character varying(255),
scpaths character varying(255),
task_timeout bigint
);
--
-- Name: snapshots; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE snapshots (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
progress character varying(255),
sc_name character varying(255),
should_transfer boolean,
snapshot_point_id character varying(255),
snapshot_name character varying(255),
start_time timestamp without time zone,
status character varying(255),
snapshot_user_name character varying(255),
volume_name character varying(255)
);
--
-- Name: storage_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE storage_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
max_snap_transfer_retries integer,
system_storage_volume_size_gb integer,
system_storage_max_volume_size_gb integer,
storage_name character varying(255),
system_storage_transfer_snapshots boolean
);
--
-- Name: volume_exports; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE volume_exports (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
connection_string character varying(4096),
host_ip character varying(255) NOT NULL,
host_iqn character varying(255) NOT NULL,
is_active boolean,
token character varying(255) NOT NULL,
volume character varying(255) NOT NULL
);
--
-- Name: volume_tokens; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE volume_tokens (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
is_valid boolean,
token character varying(255) NOT NULL,
volume character varying(255)
);
--
-- Name: volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE volumes (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
create_time timestamp without time zone,
sc_name character varying(255),
size integer,
snapshot_id character varying(255),
status character varying(255),
volume_user_name character varying(255),
volume_name character varying(255),
zone character varying(255)
);
--
-- Name: chapuserinfo_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY chapuserinfo
ADD CONSTRAINT chapuserinfo_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: chapuserinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY chapuserinfo
ADD CONSTRAINT chapuserinfo_pkey PRIMARY KEY (id);
--
-- Name: das_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY das_info
ADD CONSTRAINT das_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: das_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY das_info
ADD CONSTRAINT das_info_pkey PRIMARY KEY (id);
--
-- Name: das_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY das_info
ADD CONSTRAINT das_info_storage_name_key UNIQUE (storage_name);
--
-- Name: direct_storage_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY direct_storage_info
ADD CONSTRAINT direct_storage_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: direct_storage_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY direct_storage_info
ADD CONSTRAINT direct_storage_info_pkey PRIMARY KEY (id);
--
-- Name: direct_storage_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY direct_storage_info
ADD CONSTRAINT direct_storage_info_storage_name_key UNIQUE (storage_name);
--
-- Name: emcvnx_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY emcvnx_info
ADD CONSTRAINT emcvnx_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: emcvnx_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY emcvnx_info
ADD CONSTRAINT emcvnx_info_pkey PRIMARY KEY (id);
--
-- Name: emcvnx_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY emcvnx_info
ADD CONSTRAINT emcvnx_info_storage_name_key UNIQUE (storage_name);
--
-- Name: equallogic_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY equallogic_info
ADD CONSTRAINT equallogic_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: equallogic_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY equallogic_info
ADD CONSTRAINT equallogic_info_pkey PRIMARY KEY (id);
--
-- Name: equallogic_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY equallogic_info
ADD CONSTRAINT equallogic_info_storage_name_key UNIQUE (storage_name);
--
-- Name: equallogicvolumeinfo_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY equallogicvolumeinfo
ADD CONSTRAINT equallogicvolumeinfo_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: equallogicvolumeinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY equallogicvolumeinfo
ADD CONSTRAINT equallogicvolumeinfo_pkey PRIMARY KEY (id);
--
-- Name: igroups_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY igroups
ADD CONSTRAINT igroups_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: igroups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY igroups
ADD CONSTRAINT igroups_pkey PRIMARY KEY (id);
--
-- Name: iscsimetadata_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY iscsimetadata
ADD CONSTRAINT iscsimetadata_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: iscsimetadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY iscsimetadata
ADD CONSTRAINT iscsimetadata_pkey PRIMARY KEY (id);
--
-- Name: iscsivolumeinfo_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY iscsivolumeinfo
ADD CONSTRAINT iscsivolumeinfo_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: iscsivolumeinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY iscsivolumeinfo
ADD CONSTRAINT iscsivolumeinfo_pkey PRIMARY KEY (id);
--
-- Name: netapp_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY netapp_info
ADD CONSTRAINT netapp_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: netapp_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY netapp_info
ADD CONSTRAINT netapp_info_pkey PRIMARY KEY (id);
--
-- Name: netapp_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY netapp_info
ADD CONSTRAINT netapp_info_storage_name_key UNIQUE (storage_name);
--
-- Name: san_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY san_info
ADD CONSTRAINT san_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: san_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY san_info
ADD CONSTRAINT san_info_pkey PRIMARY KEY (id);
--
-- Name: san_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY san_info
ADD CONSTRAINT san_info_storage_name_key UNIQUE (storage_name);
--
-- Name: snapshots_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY snapshots
ADD CONSTRAINT snapshots_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY snapshots
ADD CONSTRAINT snapshots_pkey PRIMARY KEY (id);
--
-- Name: storage_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY storage_info
ADD CONSTRAINT storage_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: storage_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY storage_info
ADD CONSTRAINT storage_info_pkey PRIMARY KEY (id);
--
-- Name: storage_info_storage_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY storage_info
ADD CONSTRAINT storage_info_storage_name_key UNIQUE (storage_name);
--
-- Name: volume_exports_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_exports
ADD CONSTRAINT volume_exports_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: volume_exports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_exports
ADD CONSTRAINT volume_exports_pkey PRIMARY KEY (id);
--
-- Name: volume_tokens_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_tokens
ADD CONSTRAINT volume_tokens_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: volume_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_tokens
ADD CONSTRAINT volume_tokens_pkey PRIMARY KEY (id);
--
-- Name: volume_tokens_token_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_tokens
ADD CONSTRAINT volume_tokens_token_key UNIQUE (token);
--
-- Name: volumes_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volumes
ADD CONSTRAINT volumes_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: volumes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volumes
ADD CONSTRAINT volumes_pkey PRIMARY KEY (id);
--
-- Name: volumes_volume_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volumes
ADD CONSTRAINT volumes_volume_name_key UNIQUE (volume_name);
--
-- Name: fk47224a5fdc6aa97e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_tokens
ADD CONSTRAINT fk47224a5fdc6aa97e FOREIGN KEY (volume) REFERENCES volumes(id);
--
-- Name: fk9350371a926accfc; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_exports
ADD CONSTRAINT fk9350371a926accfc FOREIGN KEY (token) REFERENCES volume_tokens(id);
--
-- Name: fk9350371adc6aa97e; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY volume_exports
ADD CONSTRAINT fk9350371adc6aa97e FOREIGN KEY (volume) REFERENCES volumes(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_vmwarebroker
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: broker_config; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_config (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
vmware_config_xml text,
broker_name character varying(255)
);
--
-- Name: broker_groups; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_groups (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
broker_group_name_broker_id character varying(255),
broker_group_name character varying(255)
);
--
-- Name: broker_hosts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_hosts (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
broker_instance_broker_id character varying(255),
broker_host_name character varying(255),
broker_host_state integer
);
--
-- Name: broker_instance_has_group_names; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_instance_has_group_names (
broker_instance_id character varying(255) NOT NULL,
broker_group_name character varying(255) NOT NULL
);
--
-- Name: broker_instance_has_vbrs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_instance_has_vbrs (
broker_instance_id character varying(255) NOT NULL,
broker_vbr character varying(255) NOT NULL
);
--
-- Name: broker_instance_has_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_instance_has_volumes (
broker_instance_id character varying(255) NOT NULL,
broker_volume_id character varying(255) NOT NULL
);
--
-- Name: broker_instances; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_instances (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
broker_instance_account_id character varying(255),
broker_instance_broker_id character varying(255),
broker_instance_bundletaskstatename character varying(255),
broker_instance_creation_date timestamp without time zone,
broker_instance_datastore character varying(255),
broker_instance_expiry_time character varying(255),
broker_instance_goal integer,
broker_instance_host character varying(255),
broker_instance_mage_id character varying(255),
broker_instance_image_url character varying(1024),
broker_instance_id character varying(255),
broker_instance_kernel_id character varying(255),
broker_instance_kernel_url character varying(255),
broker_instance_key_name character varying(8192),
broker_instance_last_migration_time bigint,
broker_instance_launch_index character varying(255),
broker_instance_launch_time character varying(255),
broker_instance_migration_destination character varying(255),
broker_instance_migration_dest_root_volume_connection_string character varying(4096),
broker_instance_destination_state integer,
broker_instance_migration_source character varying(255),
broker_instance_source_state integer,
broker_instance_network_index integer,
broker_instance_owner_id character varying(255),
broker_instance_platform character varying(255),
broker_instance_private_ip character varying(255),
broker_instance_private_mac_address character varying(255),
broker_instance_public_ip character varying(255),
broker_instance_ramdisk_id character varying(255),
broker_instance_ramdisk_url character varying(255),
broker_instance_reached_running_time character varying(255),
broker_instance_reservation_id character varying(255),
broker_instance_root_volume_connection_string character varying(4096),
broker_instance_service_tag character varying(255),
broker_instance_state integer,
broker_instance_state_name character varying(255),
broker_instance_user_data character varying(32768),
broker_instance_user_id character varying(255),
broker_instance_uuid character varying(255),
broker_instance_vlan integer,
broker_instance_cores integer,
broker_instance_disk integer,
broker_instance_memory integer,
broker_instance_vmtype_name character varying(255)
);
--
-- Name: broker_vbrs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_vbrs (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
volume_attachment_token character varying(255),
broker_vbr_format character varying(255),
broker_vbr_guest_device_name character varying(255),
broker_vbr_resource_location character varying(1024),
broker_vbr_size bigint,
broker_vbr_type character varying(255),
broker_vbr_id character varying(255)
);
--
-- Name: broker_volumes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE broker_volumes (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
broker_volume_connection_string character varying(4096),
broker_volume_device character varying(255),
broker_migration_dest_volume_connection_string character varying(4096),
broker_volume_remote_device character varying(1024),
broker_volume_status character varying(255),
broker_volume_vmware_id character varying(255),
broker_volume_id character varying(255)
);
--
-- Name: broker_config_broker_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_config
ADD CONSTRAINT broker_config_broker_name_key UNIQUE (broker_name);
--
-- Name: broker_config_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_config
ADD CONSTRAINT broker_config_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_config_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_config
ADD CONSTRAINT broker_config_pkey PRIMARY KEY (id);
--
-- Name: broker_groups_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_groups
ADD CONSTRAINT broker_groups_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_groups
ADD CONSTRAINT broker_groups_pkey PRIMARY KEY (id);
--
-- Name: broker_hosts_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_hosts
ADD CONSTRAINT broker_hosts_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_hosts
ADD CONSTRAINT broker_hosts_pkey PRIMARY KEY (id);
--
-- Name: broker_instance_has_group_names_broker_group_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_group_names
ADD CONSTRAINT broker_instance_has_group_names_broker_group_name_key UNIQUE (broker_group_name);
--
-- Name: broker_instance_has_vbrs_broker_vbr_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_vbrs
ADD CONSTRAINT broker_instance_has_vbrs_broker_vbr_key UNIQUE (broker_vbr);
--
-- Name: broker_instance_has_volumes_broker_volume_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_volumes
ADD CONSTRAINT broker_instance_has_volumes_broker_volume_id_key UNIQUE (broker_volume_id);
--
-- Name: broker_instances_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instances
ADD CONSTRAINT broker_instances_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instances
ADD CONSTRAINT broker_instances_pkey PRIMARY KEY (id);
--
-- Name: broker_vbrs_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_vbrs
ADD CONSTRAINT broker_vbrs_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_vbrs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_vbrs
ADD CONSTRAINT broker_vbrs_pkey PRIMARY KEY (id);
--
-- Name: broker_volumes_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_volumes
ADD CONSTRAINT broker_volumes_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: broker_volumes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_volumes
ADD CONSTRAINT broker_volumes_pkey PRIMARY KEY (id);
--
-- Name: fk3a0cebf03ec561b0; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_volumes
ADD CONSTRAINT fk3a0cebf03ec561b0 FOREIGN KEY (broker_volume_id) REFERENCES broker_volumes(id);
--
-- Name: fk3a0cebf0a401fc50; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_volumes
ADD CONSTRAINT fk3a0cebf0a401fc50 FOREIGN KEY (broker_instance_id) REFERENCES broker_instances(id);
--
-- Name: fk6f0f49f6a401fc50; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_vbrs
ADD CONSTRAINT fk6f0f49f6a401fc50 FOREIGN KEY (broker_instance_id) REFERENCES broker_instances(id);
--
-- Name: fk6f0f49f6af7a52ee; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_vbrs
ADD CONSTRAINT fk6f0f49f6af7a52ee FOREIGN KEY (broker_vbr) REFERENCES broker_vbrs(id);
--
-- Name: fkc575815f4d766b30; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_group_names
ADD CONSTRAINT fkc575815f4d766b30 FOREIGN KEY (broker_group_name) REFERENCES broker_groups(id);
--
-- Name: fkc575815fa401fc50; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY broker_instance_has_group_names
ADD CONSTRAINT fkc575815fa401fc50 FOREIGN KEY (broker_instance_id) REFERENCES broker_instances(id);
--
-- PostgreSQL database dump complete
--
\connect eucalyptus_walrus
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
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_with_oids = false;
--
-- Name: bucket_has_grants; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE bucket_has_grants (
bucket_id character varying(255) NOT NULL,
grant_id character varying(255) NOT NULL
);
--
-- Name: buckets; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE buckets (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
bucket_name character varying(255),
bucket_size bigint,
bucket_creation_date timestamp without time zone,
global_read boolean,
global_read_acp boolean,
global_write boolean,
global_write_acp boolean,
hidden boolean,
bucket_location character varying(255),
logging_enabled boolean,
owner_id character varying(255),
target_bucket character varying(255),
target_prefix character varying(255),
user_id character varying(255),
versioning character varying(255)
);
--
-- Name: drbd_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE drbd_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
block_device character varying(255),
walrus_name character varying(255),
resource_name character varying(255)
);
--
-- Name: grants; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE grants (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
allow_read boolean,
allow_read_acp boolean,
allow_write boolean,
allow_write_acp boolean,
grantgroup character varying(255),
user_id character varying(255)
);
--
-- Name: imagecache; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE imagecache (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
bucket_name character varying(255),
image_name character varying(255),
in_cache boolean,
manifest_name character varying(255),
size bigint,
use_count integer
);
--
-- Name: metadata; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metadata (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
name character varying(255),
object_id character varying(255),
value character varying(255)
);
--
-- Name: object_has_grants; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE object_has_grants (
object_id character varying(255) NOT NULL,
grant_id character varying(255) NOT NULL
);
--
-- Name: object_has_metadata; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE object_has_metadata (
object_id character varying(255) NOT NULL,
metadata_id character varying(255) NOT NULL
);
--
-- Name: objects; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE objects (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
bucket_name character varying(255),
content_disposition character varying(255),
content_type character varying(255),
is_deleted boolean,
etag character varying(255),
global_read boolean,
global_read_acp boolean,
global_write boolean,
global_write_acp boolean,
is_last boolean,
last_modified timestamp without time zone,
object_key character varying(255),
object_name character varying(255),
owner_id character varying(255),
size bigint,
storage_class character varying(255),
version_id character varying(255)
);
--
-- Name: torrents; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE torrents (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
bucket_name character varying(255),
object_key character varying(255),
torrent_file character varying(255)
);
--
-- Name: walrus_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE walrus_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
walrus_name character varying(255),
storage_dir character varying(255),
storage_max_bucket_size_mb integer,
storage_max_buckets_per_user integer,
storage_cache_size_mb integer,
storage_walrus_total_capacity integer,
storage_snapshot_size_gb integer
);
--
-- Name: walrus_stats_info; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE walrus_stats_info (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
walrus_name character varying(255),
number_buckets integer,
total_space_used bigint
);
--
-- Name: walrussnapshots; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE walrussnapshots (
id character varying(255) NOT NULL,
creation_timestamp timestamp without time zone,
last_update_timestamp timestamp without time zone,
metadata_perm_uuid character varying(255) NOT NULL,
version integer,
size integer,
snapshot_bucket character varying(255),
snapshot_name character varying(255)
);
--
-- Name: bucket_has_grants_grant_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY bucket_has_grants
ADD CONSTRAINT bucket_has_grants_grant_id_key UNIQUE (grant_id);
--
-- Name: buckets_bucket_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY buckets
ADD CONSTRAINT buckets_bucket_name_key UNIQUE (bucket_name);
--
-- Name: buckets_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY buckets
ADD CONSTRAINT buckets_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: buckets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY buckets
ADD CONSTRAINT buckets_pkey PRIMARY KEY (id);
--
-- Name: drbd_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY drbd_info
ADD CONSTRAINT drbd_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: drbd_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY drbd_info
ADD CONSTRAINT drbd_info_pkey PRIMARY KEY (id);
--
-- Name: drbd_info_walrus_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY drbd_info
ADD CONSTRAINT drbd_info_walrus_name_key UNIQUE (walrus_name);
--
-- Name: grants_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY grants
ADD CONSTRAINT grants_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: grants_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY grants
ADD CONSTRAINT grants_pkey PRIMARY KEY (id);
--
-- Name: imagecache_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imagecache
ADD CONSTRAINT imagecache_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: imagecache_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY imagecache
ADD CONSTRAINT imagecache_pkey PRIMARY KEY (id);
--
-- Name: metadata_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT metadata_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metadata
ADD CONSTRAINT metadata_pkey PRIMARY KEY (id);
--
-- Name: object_has_grants_grant_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_grants
ADD CONSTRAINT object_has_grants_grant_id_key UNIQUE (grant_id);
--
-- Name: object_has_metadata_metadata_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_metadata
ADD CONSTRAINT object_has_metadata_metadata_id_key UNIQUE (metadata_id);
--
-- Name: objects_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY objects
ADD CONSTRAINT objects_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: objects_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY objects
ADD CONSTRAINT objects_pkey PRIMARY KEY (id);
--
-- Name: torrents_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY torrents
ADD CONSTRAINT torrents_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: torrents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY torrents
ADD CONSTRAINT torrents_pkey PRIMARY KEY (id);
--
-- Name: walrus_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrus_info
ADD CONSTRAINT walrus_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: walrus_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrus_info
ADD CONSTRAINT walrus_info_pkey PRIMARY KEY (id);
--
-- Name: walrus_info_walrus_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrus_info
ADD CONSTRAINT walrus_info_walrus_name_key UNIQUE (walrus_name);
--
-- Name: walrus_stats_info_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrus_stats_info
ADD CONSTRAINT walrus_stats_info_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: walrus_stats_info_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrus_stats_info
ADD CONSTRAINT walrus_stats_info_pkey PRIMARY KEY (id);
--
-- Name: walrussnapshots_metadata_perm_uuid_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrussnapshots
ADD CONSTRAINT walrussnapshots_metadata_perm_uuid_key UNIQUE (metadata_perm_uuid);
--
-- Name: walrussnapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrussnapshots
ADD CONSTRAINT walrussnapshots_pkey PRIMARY KEY (id);
--
-- Name: walrussnapshots_snapshot_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY walrussnapshots
ADD CONSTRAINT walrussnapshots_snapshot_name_key UNIQUE (snapshot_name);
--
-- Name: fk64e02191196224c4; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY bucket_has_grants
ADD CONSTRAINT fk64e02191196224c4 FOREIGN KEY (bucket_id) REFERENCES buckets(id);
--
-- Name: fk64e021916e00780c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY bucket_has_grants
ADD CONSTRAINT fk64e021916e00780c FOREIGN KEY (grant_id) REFERENCES grants(id);
--
-- Name: fk9ef7ac344c442d44; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_metadata
ADD CONSTRAINT fk9ef7ac344c442d44 FOREIGN KEY (metadata_id) REFERENCES metadata(id);
--
-- Name: fk9ef7ac3450177624; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_metadata
ADD CONSTRAINT fk9ef7ac3450177624 FOREIGN KEY (object_id) REFERENCES objects(id);
--
-- Name: fkc74111c50177624; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_grants
ADD CONSTRAINT fkc74111c50177624 FOREIGN KEY (object_id) REFERENCES objects(id);
--
-- Name: fkc74111c6e00780c; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY object_has_grants
ADD CONSTRAINT fkc74111c6e00780c FOREIGN KEY (grant_id) REFERENCES grants(id);
--
-- PostgreSQL database dump complete
--
\connect postgres
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: postgres; Type: COMMENT; Schema: -; Owner: -
--
COMMENT ON DATABASE postgres IS 'default administrative connection database';
--
-- 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';
--
-- PostgreSQL database dump complete
--
\connect template1
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: template1; Type: COMMENT; Schema: -; Owner: -
--
COMMENT ON DATABASE template1 IS 'default template for new databases';
--
-- 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';
--
-- PostgreSQL database dump complete
--
--
-- PostgreSQL database cluster dump complete
--