Skip to content

Instantly share code, notes, and snippets.

@srcr

srcr/POSTGRESQL-structure-delta.sql

Last active October 25, 2019 11:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save srcr/84b81180b4337496757d8defa469d754 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save srcr/84b81180b4337496757d8defa469d754 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. srcr revised this gist Oct 25, 2019. 1 changed file with 20 additions and 20 deletions.
    40 changes: 20 additions & 20 deletions POSTGRESQL-structure-delta.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -57,11 +57,11 @@ CREATE INDEX idx_18020_timestamp ON event_graph (timestamp);
    CREATE SEQUENCE notification_logs_seq;

    CREATE TABLE IF NOT EXISTS notification_logs (
    id int NOT NULL DEFAULT NEXTVAL ('notification_logs_seq'),
    org_id int NOT NULL,
    type varchar(255) NOT NULL,
    timestamp int NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
    id int NOT NULL DEFAULT NEXTVAL ('notification_logs_seq'),
    org_id int NOT NULL,
    type varchar(255) NOT NULL,
    timestamp int NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18030_org_id ON notification_logs (org_id);
    @@ -70,21 +70,21 @@ CREATE INDEX idx_18030_type ON notification_logs (type);
    CREATE SEQUENCE rest_client_histories_seq;

    CREATE TABLE IF NOT EXISTS rest_client_histories (
    id int NOT NULL DEFAULT NEXTVAL ('rest_client_histories_seq'),
    org_id int NOT NULL,
    user_id int NOT NULL,
    headers text,
    body text,
    url text,
    http_method varchar(255),
    timestamp int NOT NULL DEFAULT 0,
    use_full_path smallint DEFAULT 0,
    show_result smallint DEFAULT 0,
    skip_ssl smallint DEFAULT 0,
    outcome int NOT NULL,
    bookmark smallint NOT NULL DEFAUlT 0,
    bookmark_name varchar(255) NULL DEFAULT '',
    PRIMARY KEY (id)
    id int NOT NULL DEFAULT NEXTVAL ('rest_client_histories_seq'),
    org_id int NOT NULL,
    user_id int NOT NULL,
    headers text,
    body text,
    url text,
    http_method varchar(255),
    timestamp int NOT NULL DEFAULT 0,
    use_full_path smallint DEFAULT 0,
    show_result smallint DEFAULT 0,
    skip_ssl smallint DEFAULT 0,
    outcome int NOT NULL,
    bookmark smallint NOT NULL DEFAUlT 0,
    bookmark_name varchar(255) NULL DEFAULT '',
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18040_org_id ON rest_client_histories (org_id);
  2. srcr created this gist Oct 25, 2019.
    139 changes: 139 additions & 0 deletions POSTGRESQL-structure-delta.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,139 @@
    CREATE SEQUENCE decaying_models_seq;

    CREATE TABLE IF NOT EXISTS decaying_models (
    id int NOT NULL DEFAULT NEXTVAL ('decaying_models_seq'),
    uuid varchar(40) DEFAULT NULL,
    name varchar(255) NOT NULL,
    parameters text,
    attribute_types text,
    description text,
    org_id int,
    enabled smallint NOT NULL DEFAULT 0,
    all_orgs smallint NOT NULL DEFAULT 1,
    ref text,
    formula varchar(255) NOT NULL,
    version varchar(255) NOT NULL DEFAULT '',
    "default" smallint NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18000_uuid ON decaying_models (uuid);
    CREATE INDEX idx_18000_name ON decaying_models (name);
    CREATE INDEX idx_18000_org_id ON decaying_models (org_id);
    CREATE INDEX idx_18000_enabled ON decaying_models (enabled);
    CREATE INDEX idx_18000_all_orgs ON decaying_models (all_orgs);
    CREATE INDEX idx_18000_version ON decaying_models (version);

    CREATE SEQUENCE decaying_model_mappings_seq;

    CREATE TABLE IF NOT EXISTS decaying_model_mappings (
    id int NOT NULL DEFAULT NEXTVAL ('decaying_model_mappings_seq'),
    attribute_type varchar(255) NOT NULL,
    model_id int NOT NULL,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18010_model_id ON decaying_model_mappings (model_id);

    CREATE SEQUENCE event_graph_seq;

    CREATE TABLE IF NOT EXISTS event_graph (
    id int NOT NULL DEFAULT NEXTVAL ('event_graph_seq'),
    event_id int NOT NULL,
    user_id int NOT NULL,
    org_id int NOT NULL,
    timestamp int NOT NULL DEFAULT 0,
    network_name varchar(255),
    network_json TEXT NOT NULL,
    preview_img TEXT,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18020_event_id ON event_graph (event_id);
    CREATE INDEX idx_18020_user_id ON event_graph (user_id);
    CREATE INDEX idx_18020_org_id ON event_graph (org_id);
    CREATE INDEX idx_18020_timestamp ON event_graph (timestamp);

    CREATE SEQUENCE notification_logs_seq;

    CREATE TABLE IF NOT EXISTS notification_logs (
    id int NOT NULL DEFAULT NEXTVAL ('notification_logs_seq'),
    org_id int NOT NULL,
    type varchar(255) NOT NULL,
    timestamp int NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18030_org_id ON notification_logs (org_id);
    CREATE INDEX idx_18030_type ON notification_logs (type);

    CREATE SEQUENCE rest_client_histories_seq;

    CREATE TABLE IF NOT EXISTS rest_client_histories (
    id int NOT NULL DEFAULT NEXTVAL ('rest_client_histories_seq'),
    org_id int NOT NULL,
    user_id int NOT NULL,
    headers text,
    body text,
    url text,
    http_method varchar(255),
    timestamp int NOT NULL DEFAULT 0,
    use_full_path smallint DEFAULT 0,
    show_result smallint DEFAULT 0,
    skip_ssl smallint DEFAULT 0,
    outcome int NOT NULL,
    bookmark smallint NOT NULL DEFAUlT 0,
    bookmark_name varchar(255) NULL DEFAULT '',
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18040_org_id ON rest_client_histories (org_id);
    CREATE INDEX idx_18040_user_id ON rest_client_histories (user_id);
    CREATE INDEX idx_18040_timestamp ON rest_client_histories (timestamp);

    CREATE SEQUENCE tag_collections_seq;

    CREATE TABLE IF NOT EXISTS tag_collections (
    id int NOT NULL DEFAULT NEXTVAL ('tag_collections_seq'),
    uuid varchar(40) DEFAULT NULL,
    user_id int NOT NULL,
    org_id int NOT NULL,
    name varchar(255) NOT NULL,
    description TEXT NOT NULL,
    all_orgs smallint NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18050_uuid ON tag_collections (uuid);
    CREATE INDEX idx_18050_user_id ON tag_collections (user_id);
    CREATE INDEX idx_18050_org_id ON tag_collections (org_id);

    CREATE SEQUENCE tag_collection_tags_seq;

    CREATE TABLE IF NOT EXISTS tag_collection_tags (
    id int NOT NULL DEFAULT NEXTVAL ('tag_collection_tags_seq'),
    tag_collection_id int NOT NULL,
    tag_id int NOT NULL,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18060_uuid ON tag_collection_tags (tag_collection_id);
    CREATE INDEX idx_18060_user_id ON tag_collection_tags (tag_id);

    CREATE SEQUENCE user_settings_seq;

    CREATE TABLE IF NOT EXISTS user_settings (
    id int NOT NULL DEFAULT NEXTVAL ('user_settings_seq'),
    setting varchar(255) NOT NULL,
    value text NOT NULL,
    user_id int NOT NULL,
    timestamp int NOT NULL
    ,
    PRIMARY KEY (id)
    ) ;

    CREATE INDEX idx_18070_setting ON user_settings (setting);
    CREATE INDEX idx_18070_user_id ON user_settings (user_id);
    CREATE INDEX idx_18070_timestamp ON user_settings (timestamp);

    CREATE SEQUENCE public.bruteforces_id_seq;