~jstys-z/helioviewer.org/scidata

Viewing all changes in revision 802.

  • Committer: Jeff Stys
  • Date: 2014-03-28 18:29:38 UTC
  • Revision ID: jstys@sesda3.com-20140328182938-lg2sht8hurwy9y7h
Added Data Coverage browser at http://helioviewer.org/coverage/

Requires a new database table:

CREATE TABLE `data_coverage_5_min` (
  `date` datetime NOT NULL,
  `sourceId` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`date`,`sourceId`),
  KEY `index1` (`date`),
  KEY `index2` (`sourceId`),
  KEY `index3` (`sourceId`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: