Author: eallen Date: 2010-01-28 14:04:36 -0500 (Thu, 28 Jan 2010) New Revision: 3829 Modified: mgmt/trunk/mint/sql/schema.sql Log: Regenerated to reflect changes to slot and slot.stats Modified: mgmt/trunk/mint/sql/schema.sql =================================================================== --- mgmt/trunk/mint/sql/schema.sql 2010-01-28 19:03:59 UTC (rev 3828) +++ mgmt/trunk/mint/sql/schema.sql 2010-01-28 19:04:36 UTC (rev 3829) @@ -231,7 +231,7 @@ condor_platform TEXT, condor_version TEXT, name TEXT, - public_network_ip_addr TEXT + my_address TEXT ); CREATE UNIQUE INDEX collector_qmfIdsUnique ON collector (qmf_agent_id, qmf_object_id); CREATE INDEX collector_statsPrevIndex ON collector (stats_prev_id); @@ -434,7 +434,6 @@ system TEXT, name TEXT, machine TEXT, - public_network_ip_addr TEXT, my_address TEXT, real_uid INT, condor_platform TEXT, @@ -442,8 +441,8 @@ daemon_start_time TIMESTAMP ); CREATE UNIQUE INDEX master_qmfIdsUnique ON master (qmf_agent_id, qmf_object_id); -CREATE INDEX master_statsCurrIndex ON master (stats_curr_id); CREATE INDEX master_statsPrevIndex ON master (stats_prev_id); +CREATE INDEX master_statsCurrIndex ON master (stats_curr_id); CREATE TABLE master_stats ( id SERIAL PRIMARY KEY, @@ -567,7 +566,6 @@ machine TEXT, my_address TEXT, name TEXT, - public_network_ip_addr TEXT, condor_platform TEXT, condor_version TEXT, daemon_start_time TIMESTAMP @@ -644,6 +642,7 @@ pool TEXT, system TEXT, accounting_group TEXT, + activity TEXT, arch TEXT, checkpoint_platform TEXT, client_machine TEXT, @@ -651,18 +650,25 @@ cpus BIGINT, current_rank FLOAT, disk BIGINT, + entered_current_activity TIMESTAMP, + entered_current_state TIMESTAMP, file_system_domain TEXT, global_job_id TEXT, is_valid_checkpoint_platform TEXT, job_id TEXT, job_start TIMESTAMP, k_flops BIGINT, + last_benchmark TIMESTAMP, + last_fetch_work_completed TIMESTAMP, + last_fetch_work_spawned TIMESTAMP, + last_periodic_checkpoint TIMESTAMP, machine TEXT, max_job_retirement_time TEXT, memory BIGINT, mips BIGINT, my_address TEXT, name TEXT, + next_fetch_work_delay INT, op_sys TEXT, preempting_concurrency_limits TEXT, preempting_owner TEXT, @@ -671,11 +677,12 @@ remote_owner TEXT, remote_user TEXT, requirements TEXT, - public_network_ip_addr TEXT, rank TEXT, slot_id BIGINT, start TEXT, starter_ability_list TEXT, + state TEXT, + time_to_live BIGINT, total_claim_run_time BIGINT, total_claim_suspend_time BIGINT, total_cpus BIGINT, @@ -702,24 +709,14 @@ id SERIAL PRIMARY KEY, qmf_update_time TIMESTAMP NOT NULL, slot_id INT, - activity TEXT, clock_day BIGINT, clock_min BIGINT, condor_load_avg FLOAT, console_idle BIGINT, - entered_current_activity TIMESTAMP, - entered_current_state TIMESTAMP, image_size BIGINT, keyboard_idle BIGINT, - last_benchmark TIMESTAMP, - last_fetch_work_completed TIMESTAMP, - last_fetch_work_spawned TIMESTAMP, - last_periodic_checkpoint TIMESTAMP, load_avg FLOAT, my_current_time TIMESTAMP, - next_fetch_work_delay INT, - state TEXT, - time_to_live BIGINT, total_condor_load_avg FLOAT, total_load_avg FLOAT, total_time_backfill_busy BIGINT,