Commits

Arnaud Grausem  committed 929287d

Bad version sql migration files

  • Participants
  • Parent commits c1b3443

Comments (0)

Files changed (2)

File sql/0.9.2/back_pg.sql

-/*
- * Use this script with PostgreSQL
- * Use this to downgrade from v0.9.2 to v0.9.1
- *
- * Drop the colum description of the timesheet_task table
- */
-
-ALTER TABLE "timesheet_task" DROP COLUMN "description";
-ALTER TABLE "timesheet_task" DROP COLUMN "type";
-ALTER TABLE "timesheet_task" DROP COLUMN "is_editable";

File sql/0.9.2/to_pg.sql

-/*
- * Use this script with PostgreSQL
- * Use this to go upgrade from v0.9.1 to v0.9.2
- *
- * Add the colum description to the timesheet_task table
- */
-
-ALTER TABLE "timesheet_task" ADD COLUMN "description" text;
-ALTER TABLE "timesheet_task" ADD COLUMN "type" varchar(1) NOT NULL;
-ALTER TABLE "timesheet_task" ADD COLUMN "is_editable" boolean NOT NULL;