
diff -r 196896cc3f58 -r c7d21399c726 db/db-schema.sql
--- a/db/db-schema.sql	Tue Apr 24 20:36:06 2012 +0200
+++ b/db/db-schema.sql	Fri Apr 27 12:04:35 2012 +0200
@@ -175,6 +175,21 @@
     "updated_by" bigint
   );
 create sequence "project_id_seq";
+create table "task" (
+    "name" varchar(100) not null,
+    "updated_at" timestamp not null,
+    "id" bigint primary key not null,
+    "project_id" bigint not null,
+    "responsible" bigint not null,
+    "deadline" timestamp not null,
+    "state" bigint not null,
+    "note" varchar(10240),
+    "created_at" timestamp not null,
+    "created_by" bigint,
+    "task_type" bigint,
+    "updated_by" bigint
+  );
+create sequence "task_id_seq";
 -- foreign key constraints :
 alter table "address" add constraint "addressFK1" foreign key ("city_id") references "city"("id");
 alter table "city" add constraint "cityFK2" foreign key ("country_id") references "country"("id");
@@ -185,6 +200,10 @@
 alter table "project" add constraint "projectFK11" foreign key ("responsible") references "user"("id");
 alter table "project" add constraint "projectFK12" foreign key ("product_line") references "code_list_item"("id") on delete set null;
 alter table "project" add constraint "projectFK13" foreign key ("state") references "code_list_item"("id");
+alter table "task" add constraint "taskFK14" foreign key ("responsible") references "user"("id");
+alter table "task" add constraint "taskFK15" foreign key ("task_type") references "code_list_item"("id");
+alter table "task" add constraint "taskFK16" foreign key ("state") references "code_list_item"("id");
+alter table "task" add constraint "taskFK17" foreign key ("project_id") references "project"("id");
 alter table "company_contact" add constraint "company_contactFK7" foreign key ("entity") references "company"("id") on delete cascade;
 alter table "company_contact" add constraint "company_contactFK8" foreign key ("contact") references "contact"("id") on delete cascade;
 alter table "user_contact" add constraint "user_contactFK9" foreign key ("entity") references "user"("id") on delete cascade;




