gistfile1.txt

soup_production=> \d posts
                                        Table "public.posts"
       Column        |           Type           |                     Modifiers                      
---------------------+--------------------------+----------------------------------------------------
 id                  | bigint                   | not null default nextval('posts_id_seq'::regclass)
 created_at          | timestamp with time zone | not null default now()
 updated_at          | timestamp with time zone | 
 type                | post_type                | 
 deleted             | boolean                  | not null default false
 blog_id             | bigint                   | 
 author_id           | integer                  | 
 asset_id            | bigint                   | 
 feed_id             | bigint                   | 
 parent_id           | bigint                   | 
 original_id         | bigint                   | 
 edited_after_repost | boolean                  | 
 inappropriateness   | real                     | default 0.0
 language            | regconfig                | default 'simple'::regconfig
 guid                | text                     | 
 source              | text                     | 
Indexes:
    "posts_pkey1" PRIMARY KEY, btree (id)
    "posts_asset_id" btree (asset_id)
    "posts_author_id" btree (author_id)
    "posts_blog_id" btree (blog_id)
    "posts_feed_id" btree (feed_id)
    "posts_for_friendposts" btree (created_at, id, blog_id, author_id)
    "posts_for_friendposts2" btree (created_at, blog_id, author_id) INVALID
    "posts_for_one_soup" btree (blog_id, created_at, id) WHERE language IS NOT NULL
    "posts_frontpage" btree (created_at, id, feed_id) WHERE parent_id IS NULL
    "posts_guid" btree (guid)
    "posts_lastfm_check" btree (feed_id, blog_id, created_at) WHERE original_id IS NULL
    "posts_original_id" btree (original_id)
    "posts_parent_id" btree (parent_id)
    "posts_repost_info" btree (original_id, created_at)
    "posts_source" btree (source)
    "posts_updated_at" btree (updated_at)
Foreign-key constraints:
    "fk_posts_assets" FOREIGN KEY (asset_id) REFERENCES assets(id) ON DELETE SET NULL
    "fk_posts_authors" FOREIGN KEY (author_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE
    "fk_posts_blogs" FOREIGN KEY (blog_id) REFERENCES blogs(id) ON UPDATE CASCADE ON DELETE CASCADE
Triggers:
    maintain_post_feed_info AFTER INSERT OR UPDATE ON posts FOR EACH ROW EXECUTE PROCEDURE maintain_post_feed_info_trigger()
    refresh_events_for_calendar AFTER UPDATE ON posts FOR EACH ROW EXECUTE PROCEDURE refresh_events_for_calendar()
    refresh_tagcloud AFTER UPDATE ON posts FOR EACH ROW EXECUTE PROCEDURE refresh_tagcloud()