From: | silly_sad <sad(at)bankir(dot)ru> |
---|---|
To: | Nikolay Samokhvalov <nikolay(at)samokhvalov(dot)com> |
Cc: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | Re: Чудо дивное планировщик явил !!! |
Date: | 2007-03-29 05:21:44 |
Message-ID: | 460B4CE8.3030600@bankir.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ru-general |
Nikolay Samokhvalov wrote:
> А можно схему таблиц посмотреть?
Можно, но она большая.
Поэтому если чо, я могу рассказать.
article.up references article.id
article.topic references topic.id
topic.up references topic.id
Схема ниже, кому не интересно может не читать.
\d topic
Column | Type |
Modifiers
-------------+-----------------------------+---------------------------------------------------------------------
id | integer | not null
name | text | not null
realm | text | not null
guid | text |
usr | text | not null
grp | text | not null
acl | row_acl | not null
created | timestamp without time zone | not null default now()
creator | text | not null
updated | timestamp without time zone | not null default now()
updater | text | not null
exported | timestamp without time zone | not null default
'1970-01-01 00:00:00'::timestamp without time zone
vector | tsvector |
up | integer |
trail | ltree | not null
layer | integer | not null
pid | integer | not null default 0
score | integer | not null default 0
title | text | not null default ''::text
description | text | not null default ''::text
extra | text | not null default ''::text
revision | integer | not null default 0
Indexes:
"topic_pkey" PRIMARY KEY, btree (id)
"topic_guid_idx" UNIQUE, btree (guid)
"topic_name_key" UNIQUE, btree (name, pid)
"topic_acl_idx" gist (acl)
"topic_grp_idx" btree (grp)
"topic_layer_idx" btree (layer)
"topic_realm_idx" btree (realm)
"topic_trail_idx" gist (trail)
"topic_up_idx" btree (up)
"topic_usr_idx" btree (usr)
"topic_vector_key" gist (vector)
\d article
Column | Type |
Modifiers
----------+-----------------------------+-----------------------------------------------------------------------
id | integer | not null
name | text | not null
realm | text | not null
guid | text |
usr | text | not null
grp | text | not null
acl | row_acl | not null
created | timestamp without time zone | not null default now()
creator | text | not null
updated | timestamp without time zone | not null default now()
updater | text | not null
exported | timestamp without time zone | not null default '1970-01-01
00:00:00'::timestamp without time zone
vector | tsvector |
up | integer |
trail | ltree | not null
layer | integer | not null
pid | integer | not null default 0
topic | integer | not null
title | text | not null default ''::text
abstract | text | not null default ''::text
content | text | not null default ''::text
author | text | not null default ''::text
start | timestamp without time zone | not null default now()
stop | timestamp without time zone | not null default
(date_trunc('day'::text, now()) + '1 day'::interval)
extra | text | not null default ''::text
revision | integer | not null default 0
locked | timestamp without time zone | not null default
'infinity'::timestamp without time zone
locker | text | not null default 'anonymous'::text
score | integer | not null default 0
type | integer | not null default 0
section | integer[] | not null default '{}'::integer[]
Indexes:
"article_pkey" PRIMARY KEY, btree (id)
"article_guid_idx" UNIQUE, btree (guid)
"article_name_key" UNIQUE, btree (name, topic)
"article_acl_idx" gist (acl)
"article_grp_idx" btree (grp)
"article_layer_idx" btree (layer)
"article_realm_idx" btree (realm)
"article_section_idx" gist (section)
"article_topic_idx" btree (topic)
"article_trail_idx" gist (trail)
"article_up_idx" btree (up)
"article_usr_idx" btree (usr)
"article_vector_key" gist (vector)
From | Date | Subject | |
---|---|---|---|
Next Message | silly_sad | 2007-03-29 06:02:49 | Re: Чудо дивное планировщик явил !!! |
Previous Message | silly_sad | 2007-03-28 13:50:16 | Re: Чудо дивное планировщик явил !!! |