Page History

DROP TABLE IF EXISTS `fk6`;
CREATE TABLE `fk6` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra` double NOT NULL,
  `dec` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `fk6` int(11) DEFAULT NULL,
  `flag` varchar(2) DEFAULT NULL,
  `tra` double DEFAULT NULL,
  `e_ra` double DEFAULT NULL,
  `e_pmra` double DEFAULT NULL,
  `tde` double DEFAULT NULL,
  `e_de` double DEFAULT NULL,
  `e_pmde` double DEFAULT NULL,
  `plx` double DEFAULT NULL,
  `e_plx` double DEFAULT NULL,
  `f_plx` char(1) DEFAULT NULL,
  `rv` double DEFAULT NULL,
  `vmag` float DEFAULT NULL,
  `f_Vmag` float DEFAULT NULL,
  `kbin1` int(11) DEFAULT NULL,
  `kbin2` int(11) DEFAULT NULL,
  `kae` int(11) DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `tycho`;
CREATE TABLE `tycho` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra` double NOT NULL,
  `dec` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `bt_mag` float DEFAULT NULL,
  `vt_mag` float DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Declination`,`Right_Ascension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `gwaves`;
CREATE TABLE `gwaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra` double NOT NULL,
  `dec` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Declination`,`Right_Ascension`,`Magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;