On Nov 25, 2007 7:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> What about the table schemas?
The schema is in the dump. That's the main reason why I've sent the
dump to both of you.
Anyway, here it is:
db=# \d themelang Table "public.themelang" Column | Type | Modifiers
------------------+------------------------+-----------codeth | character varying(3) | not nullcodelang
| character varying(3) | not nulllibtheme | character varying(70) | not nullmotsclesmetatags | character
varying(500)|descriptifmeta | character varying(500) |motcleoverture_l | character varying(100) |motcleoverture_c |
charactervarying(100) |liencourt | character varying(30) |baselinetheme | character varying(300)
|ordrenewsletter | integer |
Indexes: "pk_themelang" PRIMARY KEY, btree (codeth, codelang)
db=# \d vilsite Table "public.vilsite" Column | Type | Modifiers
---------------------+-----------------------+--------------------codevil | character varying(3) | not
nullcodelang | character varying(3) | not nullcodepays | character varying(3) | not
nullregionwap | character varying(3) |codedep | character varying(3) |codetypevil |
charactervarying(1) | not nullouverte | integer | not nullcodeinteret | character
varying(1) | not nullfamilleville | character varying(1) | not nullcodevilpostale | character varying(8)
|capitale | integer | not nullcodemeteodirect | character varying(5) |libvilpubwoo
|character varying(10) |population | integer |codeinsee | character varying(5)
|petiteville | integer | not null default 0logincommercial | character varying(20)
|logincommercialprec| character varying(20) |
Indexes: "pk_vilsite" PRIMARY KEY, btree (codevil)
db=# \d vilsitelang Table "public.vilsitelang" Column | Type | Modifiers
----------+-----------------------+-----------codevil | character varying(3) | not nullcodelang | character
varying(3) | not nulllibvil | character varying(50) | not nulltrafic | integer |
Indexes: "pk_vilsitelang" PRIMARY KEY, btree (codevil, codelang)
Foreign-key constraints: "fk_vilsitel_vilsitela_vilsite" FOREIGN KEY (codevil) REFERENCES
vilsite(codevil) ON DELETE CASCADE
--
Guillaume