This repository has been archived by the owner on Jul 20, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdatabase.sql
6 lines (6 loc) · 4.9 KB
/
database.sql
1
2
3
4
5
6
CREATE DATABASE `unolocum_space_objects`;
USE `unolocum_space_objects`;
CREATE TABLE `northern` (`Name` varchar(20) NOT NULL, `Month` varchar(20) DEFAULT NULL,`Direction` varchar(40) DEFAULT NULL);
INSERT INTO `northern` VALUES ('Ursa major','January','Facing North'),('Ursa minor','January','Facing North'),('Andromeda','January','Facing North'),('Andromeda(Galaxy)','January','Facing North'),('Orion','January','Facing East'),('Taurus','January','Facing east-east-north'),('Caelum','January','Facing South-east by Horizon'),('Lepus','January','Facing East'),('Phoenix','January','Facing South'),('Cassiopeia','January','Near Zenith'),('Canis major','January','Facing east'),('Sirius(Star)','January','Brightest star in Canis major'),('Capricornus','January','Facing west'),('Aquarious','January','Facing west(Near zenith)'),('Columba','February','Facing South'),('Pegasus','February','Facing West'),('Auriga','February','At zenith'),('Gemini','February','Facing East'),('Camlopardalus','February','North(near polaris)'),('Monoceros','February','Facing south-east'),('Lepus','February','Facing south'),('Messier81(Galaxy)','February','Near polaris'),('Cepheus','February','North'),('Cygnus','February','Facing North(Horizon)'),('Lynx','March','North(Near polaris)'),('Pyxis','March','Facing east'),('Sextans','March','Facing east'),('Cetus','March','Facing west'),('Cancer','March','Facing south-east'),('Vela','March','Facing south-east(Horizon)'),('Draco','March','Facing north'),('Aries','March','Facing west'),('Ursa major','April','North(above polaris)'),('Leo','April','North East'),('Leo minor','April','North'),('Sextans','April','North(Near zenith'),('Antilia','April','South by horizon'),('Crater','April','East'),('Canes Venatici','May','North'),('Coma Berenices','May','North East'),('Corvus','May','East'),('Virgo','May','South East'),('Centaurus','May','East by horizon'),('Whirlpool Galaxy','May','In canes venatici'),('Bootes','June','North'),('Ursa minor','June','North'),('Libra','June','East'),('Lupus','June','South East by horizon'),('Scorpius','July','South East by horizon'),('Draco','July','North'),('Herculus','July','North East'),('Corona Boraelis','July','North East(Near zenith)'),('Serpens','July','East'),('lyra','August','North'),('Sagitta','August','North East'),('Aquila','August','East'),('Corona Australis','August','South East'),('Telescopium','August','South East by horizon'),('Sagittarius','August','South East'),('Cygnus','September','North'),('Delphinus','September','North'),('Vulpecula','September','Near zenith'),('Equuleus','September','North east'),('Capricornius','September','South east'),('Lacerta','October','North'),('Pegasus','October','North east'),('Grus','October','South east'),('Piscis Austrinus','October','South'),('Aquarius','October','South east'),('Cephius','November','North(near polaris)'),('Cassiopeia','November','North'),('Andromeda','November','North'),('Pisces','November','North'),('Triangulum','December','North'),('Perseus','December','North east'),('Aries','December','North'),('Fornax','December','South east'),('Horologium','December','South east by horizon');
CREATE TABLE `southern` (`Name` varchar(30) DEFAULT NULL, `Month` varchar(15) DEFAULT NULL, `Direction` varchar(40) DEFAULT NULL);
INSERT INTO `southern` VALUES ('Caelum','January','South'),('Dorado','January','South'),('Lepus','January','North east'),('Mensa','January','South(Near polaris)'),('Orion','January','North East'),('Recticulum','January','South'),('Taurus','January','North'),('Canis major','February','Near zenith'),('Columba','February','South(Near zenith)'),('Puppis','February','South'),('Cone nebula','February','North east'),('Apus','February','South'),('Octans','February','South'),('Carina','March','South'),('Pyxis','March','South(Near zenith)'),('Vela','March','South'),('Volans','March','South'),('Canis Minor','March','North'),('Cancer','March','North'),('Sextans','April','North'),('Hydra','April','North'),('Crater','April','North east(Near zenith)'),('Antlia','April','South'),('Chamaeleon','April','South'),('Leo','April','South'),('Cenaturus','May','South'),('Virgo','May','South East'),('Corvus','May','Near Zenith'),('Crux','May','South'),('Musca','May','South(Near polaris)'),('Whirpool Galaxy','May','North'),('Libra','June','Near zenith'),('Lupus','June','South'),('Bootes','June','North'),('Canes venaciti','June','North'),('Herculus','June','North east by horizon'),('Ophiuchus','July','North east'),('Scorpius','July','Near zenith'),('Norma','July','South'),('Ara','July','South East'),('Circinus','July','South'),('Apus','July','South(Near polaris)'),('Scutum','August','North'),('Sagittarius','August','Near zenith'),('Corona Australis','August','South'),('Telescopium','August','South'),('Pavo','August','South'),('Serpens','August','North west'),('Capricornus','September','Near zenith'),('Microscopium','September','South'),('Indus','September','South'),('Cygnus','September','North by horizon'),('Dereb(Star)','September','In cygnus');