CREATE TABLE `InMemoryDIASource` (
	`id` bigint(20) NOT NULL,
	`ampExposureId` bigint(20) NOT NULL,
	`filterId` tinyint(4) NOT NULL,
	`objectId` bigint(20) default NULL,
	`movingObjectId` bigint(20) default NULL,
	`procHistoryId` int(11) NOT NULL,
	`scId` int(11) NOT NULL,
	`zoneId` int(11) NOT NULL,
	`ra` double NOT NULL,
	`decl` double NOT NULL,
	`x` double NOT NULL,
	`y` double NOT NULL,
	`z` double NOT NULL,
	`stripeId` smallint(6) NOT NULL,
	`fineStripeId` smallint(6) NOT NULL,
	`chunkId` int(11) NOT NULL,
	`fineChunkId` int(11) NOT NULL,
	`raErr4detection` decimal(7,5) NOT NULL,
	`decErr4detection` decimal(7,5) NOT NULL,
	`raErr4wcs` decimal(7,5) default NULL,
	`decErr4wcs` decimal(7,5) default NULL,
	`xpos` decimal(7,2) NOT NULL,
	`ypos` decimal(7,2) NOT NULL,
	`xposErr` decimal(4,2) NOT NULL,
	`yposErr` decimal(4,2) NOT NULL,
	`cx` float NOT NULL,
	`cy` float NOT NULL,
	`cz` float NOT NULL,
	`taiMidPoint` decimal(12,7) NOT NULL,
	`taiRange` decimal(12,7) NOT NULL,
	`fwhmA` decimal(4,2) NOT NULL,
	`fwhmB` decimal(4,2) NOT NULL,
	`fwhmTheta` decimal(4,1) NOT NULL,
	`flux` decimal(12,2) NOT NULL,
	`fluxErr` decimal(10,2) NOT NULL,
	`psfMag` decimal(7,3) NOT NULL,
	`psfMagErr` decimal(6,3) NOT NULL,
	`apMag` decimal(7,3) NOT NULL,
	`apMagErr` decimal(6,3) NOT NULL,
	`apDia` float default NULL,
	`petroMag` float default NULL,
	`petroMagErr` float default NULL,
	`Ixx` float default NULL,
	`IxxErr` float default NULL,
	`Iyy` float default NULL,
	`IyyErr` float default NULL,
	`Ixy` float default NULL,
	`IxyErr` float default NULL,
	`snr` float NOT NULL,
	`chi2` float NOT NULL,
	`flag4association` smallint(6) default NULL,
	`flag4detection` smallint(6) default NULL,
	`flag4wcs` smallint(6) default NULL,
	PRIMARY KEY  (`id`),
	KEY `idx_zone_ra` USING BTREE (`zoneId`,`ra`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

CREATE TABLE `InMemoryObject` (
	`id` bigint(20) NOT NULL,
	`ra` decimal(8,5) NOT NULL,
	`decl` decimal(8,5) NOT NULL,
	`pm_ra` decimal(8,5) NOT NULL,
	`pm_raErr` smallint(6) NOT NULL,
	`pm_decl` decimal(8,5) NOT NULL,
	`pm_decErr` smallint(6) NOT NULL,
	`epoch` decimal(6,1) NOT NULL,
	`bMag` decimal(5,3) NOT NULL,
	`bErr` decimal(5,3) NOT NULL,
	`rMag` decimal(5,3) NOT NULL,
	`rErr` decimal(5,3) NOT NULL,
	`bMag2` decimal(5,3) NOT NULL,
	`bErr2` decimal(5,3) NOT NULL,
	`rMag2` decimal(5,3) NOT NULL,
	`rErr2` decimal(5,3) NOT NULL,
	`zoneId` int(11) NOT NULL default '0',
	`stripeId` smallint(6) NOT NULL default '0',
	`fineStripeId` smallint(6) NOT NULL default '0',
	`chunkId` int(11) NOT NULL default '0',
	`fineChunkId` int(11) NOT NULL default '0',
	`x` double NOT NULL default '0',
	`y` double NOT NULL default '0',
	`z` double NOT NULL default '0',
	`isDirty` tinyint(1) NOT NULL default '0',
	PRIMARY KEY  (`id`),
	KEY `idx_zone_ra` USING BTREE (`zoneId`,`ra`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;


CREATE TABLE `ZoneZone` (
  `zoneId` int(11) NOT NULL,
  `matchZoneId` int(11) NOT NULL,
  `deltaRa` double NOT NULL,
  PRIMARY KEY  USING BTREE (`zoneId`,`matchZoneId`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;


CREATE TABLE `LooseMatch` (
  `id1` bigint(20) NOT NULL,
  `id2` bigint(20) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;