-- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 20, 2008 at 11:32 AM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `element` -- -- -------------------------------------------------------- -- -- Table structure for table `elements` -- CREATE TABLE IF NOT EXISTS `elements` ( `atomic_number` tinyint(4) unsigned NOT NULL, `mendeleev_number` tinyint(4) NOT NULL default '0' COMMENT 'From Villars J All 367 2004 167', `Pettifor` tinyint(4) NOT NULL COMMENT 'Pettifor Number', `symbol` varchar(3) NOT NULL, `name` varchar(13) NOT NULL, `valence` float NOT NULL COMMENT 'Ref: http://en.wikipedia.org/w/index.php?title=Valence_%28chemistry%29&oldid=212196829', `mass` float NOT NULL COMMENT 'atomic mass - Ref: http://en.wikipedia.org/w/index.php?title=List_of_elements_by_atomic_mass&oldid=210959492', `grp` tinyint(4) NOT NULL COMMENT 'Group - Ref: http://en.wikipedia.org/w/index.php?title=List_of_elements_by_atomic_mass&oldid=210959492', `period` tinyint(4) NOT NULL COMMENT 'Period - Ref: http://en.wikipedia.org/w/index.php?title=List_of_elements_by_atomic_mass&oldid=210959492', PRIMARY KEY (`atomic_number`), UNIQUE KEY `symbol` (`symbol`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Elemental Properties'; -- -- Dumping data for table `elements` -- INSERT INTO `elements` (`atomic_number`, `mendeleev_number`, `Pettifor`, `symbol`, `name`, `valence`, `mass`, `grp`, `period`) VALUES (1, 92, 103, 'H', 'Hydrogen', 1, 1.00794, 1, 1), (2, 98, 1, 'He', 'Helium', 0, 4.0026, 18, 18), (3, 1, 12, 'Li', 'Lithium', 1, 6.941, 1, 1), (4, 67, 77, 'Be', 'Beryllium', 2, 9.01218, 2, 2), (5, 72, 86, 'B', 'Boron', 3, 10.811, 13, 13), (6, 77, 95, 'C', 'Carbon', 4, 12.0107, 14, 14), (7, 82, 100, 'N', 'Nitrogen', 3, 14.0067, 15, 15), (8, 87, 101, 'O', 'Oxygen', 2, 15.9994, 16, 16), (9, 93, 102, 'F', 'Fluorine', 1, 18.9984, 17, 17), (10, 99, 2, 'Ne', 'Neon', 0, 20.1797, 18, 18), (11, 2, 11, 'Na', 'Sodium', 1, 22.9898, 1, 1), (12, 68, 73, 'Mg', 'Magnesium', 2, 24.305, 2, 2), (13, 73, 80, 'Al', 'Aluminum', 3, 26.9815, 13, 13), (14, 78, 85, 'Si', 'Silicon', 4, 28.0855, 14, 14), (15, 83, 90, 'P', 'Phosphorus', 5, 30.9738, 15, 15), (16, 88, 94, 'S', 'Sulfur', 6, 32.065, 16, 16), (17, 94, 99, 'Cl', 'Chlorine', 5, 35.453, 17, 17), (18, 100, 3, 'Ar', 'Argon', 0, 39.948, 18, 18), (19, 3, 10, 'K', 'Potassium', 1, 39.0983, 1, 1), (20, 7, 16, 'Ca', 'Calcium', 2, 40.078, 2, 2), (21, 11, 19, 'Sc', 'Scandium', 3, 44.9559, 3, 3), (22, 43, 51, 'Ti', 'Titanium', 4, 47.867, 4, 4), (23, 46, 54, 'V', 'Vanadium', 5, 50.9415, 5, 5), (24, 49, 57, 'Cr', 'Chromium', 6, 51.9961, 6, 6), (25, 52, 60, 'Mn', 'Manganese', 4, 54.938, 7, 7), (26, 55, 61, 'Fe', 'Iron', 4, 55.845, 8, 8), (27, 58, 64, 'Co', 'Cobalt', 4, 58.9332, 9, 9), (28, 61, 67, 'Ni', 'Nickel', 4, 58.6934, 10, 10), (29, 64, 72, 'Cu', 'Copper', 2, 63.546, 11, 11), (30, 69, 76, 'Zn', 'Zinc', 2, 65.38, 12, 12), (31, 74, 81, 'Ga', 'Gallium', 3, 69.723, 13, 13), (32, 79, 84, 'Ge', 'Germanium', 4, 72.64, 14, 14), (33, 84, 89, 'As', 'Arsenic', 5, 74.9216, 15, 15), (34, 89, 93, 'Se', 'Selenium', 6, 78.96, 16, 16), (35, 95, 98, 'Br', 'Bromine', 5, 79.904, 17, 17), (36, 101, 4, 'Kr', 'Krypton', 2, 83.798, 18, 18), (37, 4, 9, 'Rb', 'Rubidium', 1, 85.4678, 1, 1), (38, 8, 15, 'Sr', 'Strontium', 2, 87.62, 2, 2), (39, 12, 25, 'Y', 'Yttrium', 3, 88.9059, 3, 3), (40, 44, 49, 'Zr', 'Zirconium', 4, 91.224, 4, 4), (41, 47, 53, 'Nb', 'Niobium', 5, 92.9064, 5, 5), (42, 50, 56, 'Mo', 'Molybdenum', 6, 95.96, 6, 6), (43, 53, 59, 'Tc', 'Technetium', 6, 98, 7, 7), (44, 56, 62, 'Ru', 'Ruthenium', 6, 101.07, 8, 8), (45, 59, 65, 'Rh', 'Rhodium', 6, 102.906, 9, 9), (46, 62, 69, 'Pd', 'Palladium', 4, 106.42, 10, 10), (47, 65, 71, 'Ag', 'Silver', 3, 107.868, 11, 11), (48, 70, 75, 'Cd', 'Cadmium', 2, 112.411, 12, 12), (49, 75, 79, 'In', 'Indium', 3, 114.818, 13, 13), (50, 80, 83, 'Sn', 'Tin', 4, 118.71, 14, 14), (51, 85, 88, 'Sb', 'Antimony', 5, 121.76, 15, 15), (52, 90, 92, 'Te', 'Tellurium', 6, 127.6, 16, 16), (53, 96, 97, 'I', 'Iodine', 7, 126.904, 17, 17), (54, 102, 5, 'Xe', 'Xenon', 6, 131.293, 18, 18), (55, 5, 8, 'Cs', 'Cesium', 1, 132.905, 1, 1), (56, 9, 14, 'Ba', 'Barium', 2, 137.327, 2, 2), (57, 13, 33, 'La', 'Lanthanum', 3, 138.905, 0, 0), (58, 15, 32, 'Ce', 'Cerium', 4, 140.116, 0, 0), (59, 17, 31, 'Pr', 'Praseodymium', 4, 140.908, 0, 0), (60, 19, 30, 'Nd', 'Neodymium', 3, 144.242, 0, 0), (61, 21, 29, 'Pm', 'Promethium', 3, 145, 0, 0), (62, 23, 28, 'Sm', 'Samarium', 3, 150.36, 0, 0), (63, 25, 18, 'Eu', 'Europium', 3, 151.964, 0, 0), (64, 27, 27, 'Gd', 'Gadolinium', 3, 157.25, 0, 0), (65, 29, 26, 'Tb', 'Terbium', 4, 158.925, 0, 0), (66, 31, 24, 'Dy', 'Dysprosium', 3, 162.5, 0, 0), (67, 33, 23, 'Ho', 'Holmium', 3, 164.93, 0, 0), (68, 35, 22, 'Er', 'Erbium', 3, 167.259, 0, 0), (69, 37, 21, 'Tm', 'Thulium', 3, 168.934, 0, 0), (70, 39, 17, 'Yb', 'Ytterbium', 3, 173.054, 0, 0), (71, 41, 20, 'Lu', 'Lutetium', 3, 174.967, 3, 3), (72, 45, 50, 'Hf', 'Hafnium', 4, 178.49, 4, 4), (73, 48, 52, 'Ta', 'Tantalum', 5, 180.948, 5, 5), (74, 51, 55, 'W', 'Tungsten', 6, 183.84, 6, 6), (75, 54, 58, 'Re', 'Rhenium', 7, 186.207, 7, 7), (76, 57, 63, 'Os', 'Osmium', 6, 190.23, 8, 8), (77, 60, 66, 'Ir', 'Iridium', 6, 192.217, 9, 9), (78, 63, 68, 'Pt', 'Platinum', 6, 195.084, 10, 10), (79, 66, 70, 'Au', 'Gold', 5, 196.967, 11, 11), (80, 71, 74, 'Hg', 'Mercury', 0, 200.59, 12, 12), (81, 76, 78, 'Tl', 'Thallium', 3, 204.383, 13, 13), (82, 81, 82, 'Pb', 'Lead', 4, 207.2, 14, 14), (83, 86, 87, 'Bi', 'Bismuth', 5, 208.98, 15, 15), (84, 91, 91, 'Po', 'Polonium', 6, 210, 16, 16), (85, 97, 96, 'At', 'Astatine', 7, 210, 17, 17), (86, 103, 6, 'Rn', 'Radon', 6, 220, 18, 18), (87, 6, 7, 'Fr', 'Francium', 1, 223, 1, 1), (88, 10, 13, 'Ra', 'Radium', 2, 226, 2, 2), (89, 14, 48, 'Ac', 'Actinium', 3, 227, 0, 0), (90, 16, 47, 'Th', 'Thorium', 4, 232.038, 0, 0), (91, 18, 46, 'Pa', 'Protactinium', 5, 231.036, 0, 0), (92, 20, 45, 'U', 'Uranium', 6, 238.029, 0, 0), (93, 22, 44, 'Np', 'Neptunium', 6, 237, 0, 0), (94, 24, 43, 'Pu', 'Plutonium', 6, 244, 0, 0), (95, 26, 42, 'Am', 'Americium', 4, 243, 0, 0), (96, 28, 41, 'Cm', 'Curium', 4, 247, 0, 0), (97, 30, 40, 'Bk', 'Berkelium', 4, 247, 0, 0), (98, 32, 39, 'Cf', 'Californium', 4, 251, 0, 0), (99, 34, 38, 'Es', 'Einsteinium', 4, 252, 0, 0), (100, 36, 37, 'Fm', 'Fermium', 3, 257, 0, 0), (101, 38, 36, 'Md', 'Mendelevium', 3, 258, 0, 0), (102, 40, 35, 'No', 'Nobelium', 3, 259, 0, 0), (103, 42, 34, 'Lr', 'Lawrencium', 3, 262, 3, 3), (104, 0, 0, 'Rf', 'Rutherfordium', 4, 261, 4, 4), (105, 0, 0, 'Db', 'Dubnium', 5, 262, 5, 5), (106, 0, 0, 'Sg', 'Seaborgium', 6, 266, 6, 6), (107, 0, 0, 'Bh', 'Bohrium', 7, 264, 7, 7), (108, 0, 0, 'Hs', 'Hassium', 7, 277, 8, 8), (109, 0, 0, 'Mt', 'Meitnerium', 7, 268, 9, 9), (110, 0, 0, 'Ds', 'Darmstadtium', 7, 271, 10, 10), (111, 0, 0, 'Rg', 'Roentgenium', 7, 272, 11, 11), (112, 0, 0, 'Uub', 'Ununbium', 6, 285, 12, 12), (113, 0, 0, 'Uut', 'Ununtrium', 5, 284, 13, 13), (114, 0, 0, 'Uuq', 'Ununquadium', 4, 289, 14, 14), (115, 0, 0, 'Uup', 'Ununpentium', 0, 288, 15, 15), (116, 0, 0, 'Uuh', 'Ununhexium', 0, 292, 16, 16), (117, 0, 0, 'Uus', 'Ununseptium', 0, 293, 17, 17), (118, 0, 0, 'Uuo', 'Ununoctium', 0, 294, 18, 18);