190   );

   190   );

   191 create sequence "project_id_seq";

   191 create sequence "project_id_seq";

   192 create table "task" (

   192 create table "task" (

   193     "id" bigint primary key not null,

   193     "id" bigint primary key not null,

   194     "name" varchar(100) not null,

   194     "name" varchar(100) not null,

   195     "project_id" bigint not null,

   196     "project_id" bigint not null,

   196     "responsible" bigint not null,

   197     "responsible" bigint not null,

   197     "deadline" timestamp not null,

   198     "deadline" timestamp not null,

   198     "state" bigint not null,

   199     "state" bigint not null,

   199     "task_type" bigint,

   200     "task_type" bigint,