DROP TABLE val_1;
CREATE TABLE val_1 (
	epoch TIMESTAMP,
	name CHAR(10),
	alpha double precision,
	delta double precision,
	magI real,
	magV real,
	magU real,
	nObs integer);

INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2007-12-23 23:12:01', 'nullObject', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'1999-11-05 00:00:00', 'objNorth', 89.45, 123.32, 12.3, 14.5, 16.7, 5);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2004-02-14 12:10:14', 'popular', 40.5, 276.0, 1.3, 1.15, 0.67, 159);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'1969-02-14 12:10:14', 'nearPop', 39.5, 276.0, 21.3, 21.15, 20.67, 1);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2008-05-27 01:01:04', 'rightPop', 40.5, 277.0, 12.3, 11.2, 9.7, 12);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2003-01-12 03:03:03', 'south1', -70.5, 0.5, -1.2, 3.4, 7.9, 7);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2003-01-12 03:03:03', 'south2', -70.5, 359.5, 6.2, 5.4, 4.9, 7);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	'2003-01-12 03:03:03', 'south3', -71, 0, 0.25, 0.25, 0.25, 7);
INSERT INTO val_1 (epoch, name, alpha, delta, magI, magV, magU, nObs) VALUES (
	NULL, 'pole', -90, 0, NULL, NULL, NULL, NULL);

