CREATE TABLE project (mainKey serial ,title text ,description text,filePrefix char(32));


CREATE TABLE membership (
   mainKey serial, 
   project int, 
   _user int
);
CREATE TABLE _user (
   mainKey serial,
   name varchar,
   mail varchar,
   pass varchar,
   profile text
); 

CREATE TABLE comment(
   mainKey serial,
   project int,
   parent int,
   poster int,
   content text,
   date timestamp
);

CREATE TABLE version(
   mainKey serial,
   project int,
   number char(16),
   extension char(16),
   date timestamp
);

CREATE TABLE gerne(
   mainKey serial,
   name varchar
);

CREATE TABLE gerneSet(
   mainKey serial,
   project int,
   gerne int
);