Stupid foreign key question

Hi,

I am trying to create a database with some cross references. From readings the
doku I am quite sure I didn't understand the use of foreign key/references.

I wrote it the following way:
CREATE TABLE "ccs" (
        "name" character varying(20),
        "id" integer PRIMARY KEY DEFAULT NEXTVAL('serial')
);
 CREATE TABLE "users" (
        "name" character varying(10),
        "id" integer PRIMARY KEY DEFAULT NEXTVAL('serial'),
        "admin" boolean,
        "teamid" integer FOREIGN KEY (id) REFERENCES ccs (id)
);

This does not work and does not look right \:) So how do I do this correctly?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres