CREATE TABLE github_activity ( event_id int8 PRIMARY KEY NOT NULL, repo text(-5) NOT NULL, branch text(-5), sha text(-5) NOT NULL, author_name text(-5), author_login text(-5), commit_date timestamptz NOT NULL, created_at timestamptz NOT NULL, title text(-5) NOT NULL, url text(-5) NOT NULL, files_changed integer, additions integer, deletions integer, raw_payload text(-5) NOT NULL ); CREATE INDEX github_activity_commit_date_idx ON github_activity (commit_date); CREATE INDEX github_activity_msg_trgm_idx ON github_activity (); CREATE UNIQUE INDEX github_activity_repo_sha_un_idx ON github_activity (repo, sha); CREATE INDEX github_activity_title_trgm_idx ON github_activity (); -- Table size: 13,279,232 bytes -- Table rows: 13,917
Begin main content
