r5510 - trunk/cumin/model/upgrades

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'