--- a/src/main/resources/db/schema-changes-0.2-0.3.sql	Wed May 30 22:51:02 2012 +0200
+++ b/src/main/resources/db/schema-changes-0.2-0.3.sql	Tue Jun 05 15:40:43 2012 +0200
@@ -69,3 +69,21 @@
 alter table "task_attachment" add foreign key ("attachment") references "attachment"("id") on delete cascade;
 alter table "project_attachment" add unique("project","attachment");
 alter table "task_attachment" add unique("task","attachment");
+
+-- task number
+create sequence task_2012;
+create sequence task_2013;
+create sequence task_2014;
+create sequence task_2015;
+create sequence task_2016;
+create sequence task_2017;
+create sequence task_2018;
+create sequence task_2019;
+create sequence task_2020;
+ALTER TABLE task ADD num integer;
+CREATE VIEW vtask AS SELECT * FROM task ORDER BY id;
+CREATE RULE rtask AS ON UPDATE TO vtask DO INSTEAD UPDATE task SET num = NEW.num WHERE id = NEW.id;
+UPDATE vtask SET num = nextval('task_2012');
+DROP RULE rtask ON vtask;
+DROP VIEW vtask;
+ALTER TABLE task ALTER COLUMN num SET NOT NULL;