Contents

CREATE TABLE skynet_message_queues (
  id int(11) NOT NULL auto_increment,
  queue_id int(11) default '0',
  tran_id bigint(20) unsigned default NULL,
  created_on datetime default NULL,
  updated_on datetime default NULL,
  tasktype varchar(255) default NULL,
  task_id bigint(20) unsigned default NULL,
  job_id bigint(20) unsigned default NULL,
  raw_payload longtext,
  payload_type varchar(255) default NULL,
  name varchar(255) default NULL,
  expiry int(11) default NULL,
  expire_time decimal(16,4) default NULL,
  iteration int(11) default NULL,
  version int(11) default NULL,
  timeout decimal(16,4) default NULL,
  retry int(11) default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY index_skynet_message_queues_on_tran_id (tran_id),
  KEY index_skynet_message_queues_on_job_id (job_id),
  KEY index_skynet_message_queues_on_task_id (task_id),
  KEY index_skynet_mqueue_for_take (queue_id,tasktype,payload_type,expire_time)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE skynet_queue_temperature (
  id int(11) NOT NULL auto_increment,
  queue_id int(11) default '0',
  updated_on datetime default NULL,
  count int(11) default '0',
  temperature decimal(6,4) default NULL,
  type varchar(255) default NULL,
  PRIMARY KEY  (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Version data entries

36 entries across 24 versions & 3 rubygems

Version	Path
brendan-skynet-0.9.3.1	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.1	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.2	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.2	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.3	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.3	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.5	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.5	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.6	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.6	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.7	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.7	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.3.8	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.3.8	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.303	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.304	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.305	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.31	app_generators/skynet_install/templates/skynet_mysql_schema.sql
brendan-skynet-0.9.31	examples/rails_mysql_example/db/skynet_mysql_schema.sql
brendan-skynet-0.9.310	app_generators/skynet_install/templates/skynet_mysql_schema.sql