DROP TABLE IF EXISTS `ucac3`;
CREATE TABLE `ucac3` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`right_ascension` double NOT NULL,
`declination` double NOT NULL,
`epoch` double NOT NULL,
`pm_ra` double DEFAULT NULL,
`pm_dec` double DEFAULT NULL,
`magnitude` float 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;
|