Author: croberts Date: 2012-10-16 16:40:41 +0000 (Tue, 16 Oct 2012) New Revision: 5510
Modified: trunk/cumin/model/upgrades/1.2_to_1.3 Log: Adding Accountant and Accountant_samples tables to the upgrade path.
Modified: trunk/cumin/model/upgrades/1.2_to_1.3 =================================================================== --- trunk/cumin/model/upgrades/1.2_to_1.3 2012-10-15 15:14:27 UTC (rev 5509) +++ trunk/cumin/model/upgrades/1.2_to_1.3 2012-10-16 16:40:41 UTC (rev 5510) @@ -24,6 +24,11 @@ run 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN usedcpu int8 NOT NULL DEFAULT 0' run 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN availcpu int8 NOT NULL DEFAULT 0' run 'ALTER TABLE "com.redhat.grid.plumage"."OSUtil_samples" ADD COLUMN totalcpu int8 NOT NULL DEFAULT 0' + +run 'create sequence "com.redhat.grid.plumage"."Accountant_id_seq"' +run 'CREATE TABLE "com.redhat.grid.plumage"."Accountant" ("_id" bigint NOT NULL,"host" text NOT NULL,"user" text,"agroup" text,"ts" timestamp without time zone,"prio" real,"wresused" bigint,"resused" bigint,"cquota" real,"equota" real,"squota" real,"wausage" bigint,CONSTRAINT "Accountant_pk" PRIMARY KEY ("_id"))' +run 'CREATE TABLE "com.redhat.grid.plumage"."Accountant_samples" ("user" text NOT NULL,"agroup" text,"ts" timestamp without time zone NOT NULL,"prio" real,"wresused" bigint,"resused" bigint,"cquota" real,"equota" real,"squota" real,"wausage" bigint)' + run 'DROP TABLE "com.redhat.cumin"."BrokerGroup" cascade' run 'DROP TABLE "com.redhat.cumin"."BrokerGroup_samples" cascade' run 'DROP TABLE "com.redhat.cumin"."BrokerGroupMapping" cascade'