------------------------------------------------------------------
-- TUTORIAL EUROPLANET , version Mac
-- Adapted to basic table of planetary data, SE 6/2013
------------------------------------------------------------------

BEGIN;



--
-- FROM Database `Planetes`
--
-- Create the schema
CREATE SCHEMA masses;
-- --------------------------------------------------------

--
-- Structure of table `pldesc`
--

CREATE TABLE masses.pldesc (
  id INT4  NOT NULL,
  name varchar(8) NOT NULL,
  mass float NOT NULL,
  diam float NOT NULL

);

--
-- Content of table `Pldesc`
--

INSERT INTO masses.pldesc (id, name, mass, diam) VALUES
(1, 'Mercury', 3.3E23, 4878),
(2, 'Venus', 4.87E24, 12104),
(3, 'Earth', 5.98E24, 12756),
(4, 'Mars', 6.42E23, 6787),
(5, 'Jupiter', 1.90E27, 142796),
(6, 'Saturn', 5.69E26, 120660),
(7, 'Uranus', 8.68E25, 51118),
(8, 'Neptune', 1.02E26, 48600);





/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



COMMIT;
