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'
Show replies by date