Backup instance_singlevmopenedxinstance

gistfile1.txt

CREATE TABLE instance_singlevmopenedxinstance_backup (
    id integer NOT NULL,
    created timestamp with time zone NOT NULL,
    modified timestamp with time zone NOT NULL,
    sub_domain character varying(50) NOT NULL,
    email character varying(254) NOT NULL,
    name character varying(250) NOT NULL,
    base_domain character varying(50) NOT NULL,
    protocol character varying(5) NOT NULL,
    branch_name character varying(50) NOT NULL,
    commit_id character varying(40) NOT NULL,
    github_organization_name character varying(200) NOT NULL,
    github_repository_name character varying(200) NOT NULL,
    ansible_playbook_name character varying(50) NOT NULL,
    ansible_extra_settings text NOT NULL,
    s3_access_key character varying(50) NOT NULL,
    s3_bucket_name character varying(50) NOT NULL,
    s3_secret_access_key character varying(50) NOT NULL,
    ref_type character varying(50) NOT NULL,
    last_provisioning_started timestamp with time zone,
    github_admin_organization_name character varying(200) NOT NULL,
    certs_version character varying(50) NOT NULL,
    configuration_version character varying(50) NOT NULL,
    forum_version character varying(50) NOT NULL,
    notifier_version character varying(50) NOT NULL,
    xqueue_version character varying(50) NOT NULL,
    ansible_source_repo_url character varying(256) NOT NULL,
    github_pr_url character varying(200) NOT NULL,
    attempts smallint NOT NULL,
    ansible_settings text NOT NULL,
    mongo_pass character varying(32) NOT NULL,
    mongo_provisioned boolean NOT NULL,
    mongo_user character varying(16) NOT NULL,
    mysql_pass character varying(32) NOT NULL,
    mysql_provisioned boolean NOT NULL,
    mysql_user character varying(16) NOT NULL,
    use_ephemeral_databases boolean NOT NULL,
    swift_openstack_auth_url character varying(200) NOT NULL,
    swift_openstack_password character varying(64) NOT NULL,
    swift_openstack_region character varying(16) NOT NULL,
    swift_openstack_tenant character varying(32) NOT NULL,
    swift_openstack_user character varying(32) NOT NULL,
    swift_provisioned boolean NOT NULL,
    status character varying(20) NOT NULL
);

INSERT INTO instance_singlevmopenedxinstance_backup SELECT * FROM instance_singlevmopenedxinstance;