Author: justi9 Date: 2008-10-03 11:21:23 -0400 (Fri, 03 Oct 2008) New Revision: 2588 Modified: mgmt/trunk/mint/python/mint/schema.py mgmt/trunk/mint/sql/schema.sql Log: Update the schema with work around for timestamps Modified: mgmt/trunk/mint/python/mint/schema.py =================================================================== --- mgmt/trunk/mint/python/mint/schema.py 2008-10-03 15:11:54 UTC (rev 2587) +++ mgmt/trunk/mint/python/mint/schema.py 2008-10-03 15:21:23 UTC (rev 2588) @@ -92,7 +92,7 @@ LastPeriodicCheckpoint = TimestampCol(default=None) LoadAvg = FloatCol(default=None) MyCurrentTime = TimestampCol(default=None) - NextFetchWorkDelay = TimestampCol(default=None) + NextFetchWorkDelay = IntCol(default=None) State = StringCol(length=1000, default=None) TimeToLive = IntCol(default=None) TotalCondorLoadAvg = FloatCol(default=None) @@ -291,7 +291,7 @@ statsPrev = ForeignKey('SubmitterStats', cascade='null', default=None) classInfos = dict() # brokerId => classInfo scheduler = ForeignKey('Scheduler', cascade='null', default=None) - JobQueueBirthdate = IntCol(default=None) + JobQueueBirthdate = TimestampCol(default=None) Machine = StringCol(length=1000, default=None) Name = StringCol(length=1000, default=None) ScheddName = StringCol(length=1000, default=None) Modified: mgmt/trunk/mint/sql/schema.sql =================================================================== --- mgmt/trunk/mint/sql/schema.sql 2008-10-03 15:11:54 UTC (rev 2587) +++ mgmt/trunk/mint/sql/schema.sql 2008-10-03 15:21:23 UTC (rev 2588) @@ -665,7 +665,7 @@ last_periodic_checkpoint TIMESTAMP, load_avg FLOAT, my_current_time TIMESTAMP, - next_fetch_work_delay TIMESTAMP, + next_fetch_work_delay INT, state VARCHAR(1000), time_to_live INT, total_condor_load_avg FLOAT, @@ -740,7 +740,7 @@ stats_curr_id INT, stats_prev_id INT, scheduler_id INT, - job_queue_birthdate INT, + job_queue_birthdate TIMESTAMP, machine VARCHAR(1000), name VARCHAR(1000), schedd_name VARCHAR(1000)