Page History

DROP TABLE IF EXISTS `ucac2`;
CREATE TABLE `ucac2` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `Right_Ascension` double NOT NULL,
  `Declination` double NOT NULL,
  `Magnitude` float NOT NULL,
  `SE_RAm` double NOT NULL,
  `SE_DEm` double NOT NULL,
  `Nobs` int(11) NOT NULL,
  `Error_Position` double NOT NULL,
  `Num_Catalogs` int(11) NOT NULL,
  `CFlag` int(11) NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `Proper_Motion_RA` double NOT NULL,
  `Proper_Motion_Dec` double NOT NULL,
  `E_pmRA` double NOT NULL,
  `E_pmDE` double NOT NULL,
  `Goodness_of_fit_pmRA` float NOT NULL,
  `Goodness_of_fit_pmDec` float NOT NULL,
  `M_ID` double NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `M_Ph` int(11) NOT NULL,
  `M_CC` int(11) NOT NULL,
  `lastModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `ra` (`Right_Ascension`),
  KEY `declination` (`Declination`),
  KEY `mag` (`Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=48330572 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `ucac3`;
CREATE TABLE `ucac3` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `Right_Ascension` double NOT NULL,
  `Declination` double NOT NULL,
  `Fit_Model_Magnitude` float NOT NULL,
  `Aperture_Magnitude` float NOT NULL,
  `E_Mag` float NOT NULL,
  `Object_Type` tinyint(3) NOT NULL,
  `Dbl_Flg` tinyint(3) NOT NULL,
  `SE_RAm` double NOT NULL,
  `SE_DEm` double NOT NULL,
  `CCD_Images` tinyint(3) NOT NULL,
  `Images_Used` tinyint(3) NOT NULL,
  `Num_Catalogs` tinyint(3) NOT NULL,
  `Total_Catalogs` tinyint(3) NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `Proper_Motion_RA` double NOT NULL,
  `Proper_Motion_Dec` double NOT NULL,
  `E_pmRA` double NOT NULL,
  `E_pmDE` double NOT NULL,
  `M_ID` int(11) NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `M_Ph` char(10) NOT NULL,
  `M_Je` float NOT NULL,
  `M_He` float NOT NULL,
  `M_Kse` float NOT NULL,
  `SC_BMag` float NOT NULL,
  `SC_R2Mag` float NOT NULL,
  `SC_IMag` float NOT NULL,
  `SC_QFlag` tinyint(3) NOT NULL,
  `SCB_QFlag` tinyint(3) NOT NULL,
  `SCR2_QFlag` tinyint(3) NOT NULL,
  `SCI_QFlag` tinyint(3) NOT NULL,
  `Cat_Flag` char(10) NOT NULL,
  `Cat_Flag_Bit` tinyint(3) NOT NULL,
  `YaleG_Flag` tinyint(3) NOT NULL,
  `YaleC_Flag` tinyint(3) NOT NULL,
  `Leda_Flag` tinyint(3) NOT NULL,
  `Source_Flag` tinyint(3) NOT NULL,
  `MPOS_Num` int(11) NOT NULL,
  `lastModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Right_Ascension`,`Declination`,`Aperture_Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=50922153 DEFAULT CHARSET=latin1;