-- Periodic Table SQL Dump -- -- Generation Time: Jun 26, 2009 at 04:13 PM -- -- Created by Stephen Akiki - http://akiscode.com/pt -- -- -------------------------------------------------------- CREATE TABLE `elements` ( `atomicnumber` tinyint(3) NOT NULL default '0', `mass` decimal(15,10) NOT NULL default '0.0000000000', `english` varchar(20) NOT NULL default '', `symbol` char(3) NOT NULL default '', PRIMARY KEY (`atomicnumber`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- INSERT INTO `elements` VALUES (1, '1.0079400000', 'Hydrogen', 'H'); INSERT INTO `elements` VALUES (2, '4.0026020000', 'Helium', 'He'); INSERT INTO `elements` VALUES (3, '6.9410000000', 'Lithium', 'Li'); INSERT INTO `elements` VALUES (4, '9.0121820000', 'Beryllium', 'Be'); INSERT INTO `elements` VALUES (5, '10.8110000000', 'Boron', 'B'); INSERT INTO `elements` VALUES (6, '12.0107000000', 'Carbon', 'C'); INSERT INTO `elements` VALUES (7, '14.0067000000', 'Nitrogen', 'N'); INSERT INTO `elements` VALUES (8, '15.9994000000', 'Oxygen', 'O'); INSERT INTO `elements` VALUES (9, '18.9994000000', 'Fluorine', 'F'); INSERT INTO `elements` VALUES (10, '20.1797000000', 'Neon', 'Ne'); INSERT INTO `elements` VALUES (11, '22.9897692800', 'Sodium', 'Na'); INSERT INTO `elements` VALUES (12, '24.3050000000', 'Magnesium', 'Mg'); INSERT INTO `elements` VALUES (13, '26.9815386000', 'aluminium', 'Al'); INSERT INTO `elements` VALUES (14, '28.0855000000', 'Silicon', 'Si'); INSERT INTO `elements` VALUES (15, '30.9737620000', 'Phosphorus', 'P'); INSERT INTO `elements` VALUES (16, '32.0650000000', 'Sulphur', 'S'); INSERT INTO `elements` VALUES (17, '35.4530000000', 'Chlorine', 'Cl'); INSERT INTO `elements` VALUES (18, '39.9480000000', 'Argon', 'Ar'); INSERT INTO `elements` VALUES (19, '39.0983000000', 'Potassium', 'K'); INSERT INTO `elements` VALUES (20, '40.0780000000', 'Calcium', 'Ca'); INSERT INTO `elements` VALUES (21, '44.9559120000', 'Scandium', 'Sc'); INSERT INTO `elements` VALUES (22, '47.8670000000', 'Titanium', 'Ti'); INSERT INTO `elements` VALUES (23, '50.9415000000', 'Vanadium', 'V'); INSERT INTO `elements` VALUES (24, '51.9961000000', 'Chromium', 'Cr'); INSERT INTO `elements` VALUES (25, '54.9380450000', 'Manganese', 'Mn'); INSERT INTO `elements` VALUES (26, '55.8450000000', 'Iron', 'Fe'); INSERT INTO `elements` VALUES (27, '58.9331950000', 'Cobalt', 'Co'); INSERT INTO `elements` VALUES (28, '58.6934000000', 'Nickel', 'Ni'); INSERT INTO `elements` VALUES (29, '63.5460000000', 'Copper', 'Cu'); INSERT INTO `elements` VALUES (30, '65.3800000000', 'Zinc', 'Zn'); INSERT INTO `elements` VALUES (31, '69.7230000000', 'Gallium', 'Ga'); INSERT INTO `elements` VALUES (32, '72.6400000000', 'Germanium', 'Ge'); INSERT INTO `elements` VALUES (33, '74.9216000000', 'Arsenic', 'As'); INSERT INTO `elements` VALUES (34, '78.9600000000', 'Selenium', 'Se'); INSERT INTO `elements` VALUES (35, '79.9040000000', 'Bromine', 'Br'); INSERT INTO `elements` VALUES (36, '83.7980000000', 'Krypton', 'Kr'); INSERT INTO `elements` VALUES (37, '85.4678000000', 'Rubidium', 'Rb'); INSERT INTO `elements` VALUES (38, '87.6200000000', 'Strontium', 'Sr'); INSERT INTO `elements` VALUES (39, '88.9058500000', 'Yttrium', 'Y'); INSERT INTO `elements` VALUES (40, '91.2240000000', 'Zirkonium', 'Zr'); INSERT INTO `elements` VALUES (41, '92.9063800000', 'Niobium', 'Nb'); INSERT INTO `elements` VALUES (42, '95.9600000000', 'Molybdaenum', 'Mo'); INSERT INTO `elements` VALUES (43, '98.0000000000', 'Technetium', 'Tc'); INSERT INTO `elements` VALUES (44, '101.0700000000', 'Ruthenium', 'Ru'); INSERT INTO `elements` VALUES (45, '102.9055000000', 'Rhodium', 'Rh'); INSERT INTO `elements` VALUES (46, '106.4200000000', 'Palladium', 'Pd'); INSERT INTO `elements` VALUES (47, '107.8682000000', 'Silver', 'Ag'); INSERT INTO `elements` VALUES (48, '112.4110000000', 'Cadmium', 'Cd'); INSERT INTO `elements` VALUES (49, '114.8180000000', 'Indium', 'In'); INSERT INTO `elements` VALUES (50, '118.7100000000', 'Tin', 'Sn'); INSERT INTO `elements` VALUES (51, '121.7600000000', 'Antimony', 'Sb'); INSERT INTO `elements` VALUES (52, '127.6000000000', 'Tellurium', 'Te'); INSERT INTO `elements` VALUES (53, '126.9044700000', 'Iodine', 'I'); INSERT INTO `elements` VALUES (54, '131.2930000000', 'Xenon', 'Xe'); INSERT INTO `elements` VALUES (55, '132.9054519000', 'Cesium', 'Cs'); INSERT INTO `elements` VALUES (56, '137.3270000000', 'Barium', 'Ba'); INSERT INTO `elements` VALUES (57, '138.9054700000', 'Lanthanum', 'La'); INSERT INTO `elements` VALUES (58, '140.1160000000', 'Cerium', 'Ce'); INSERT INTO `elements` VALUES (59, '140.9076500000', 'Praseodymium', 'Pr'); INSERT INTO `elements` VALUES (60, '144.2420000000', 'Neodymium', 'Nd'); INSERT INTO `elements` VALUES (61, '145.0000000000', 'Promethium', 'Pm'); INSERT INTO `elements` VALUES (62, '150.3600000000', 'Samarium', 'Sm'); INSERT INTO `elements` VALUES (63, '151.9640000000', 'Europium', 'Eu'); INSERT INTO `elements` VALUES (64, '157.2500000000', 'Gadolinium', 'Gd'); INSERT INTO `elements` VALUES (65, '158.9253500000', 'Terbium', 'Tb'); INSERT INTO `elements` VALUES (66, '162.5001000000', 'Dysprosium', 'Dy'); INSERT INTO `elements` VALUES (67, '164.9303200000', 'Holmium', 'Ho'); INSERT INTO `elements` VALUES (68, '167.2590000000', 'Erbium', 'Er'); INSERT INTO `elements` VALUES (69, '168.9342100000', 'Thulium', 'Tm'); INSERT INTO `elements` VALUES (70, '173.0540000000', 'Ytterbium', 'Yb'); INSERT INTO `elements` VALUES (71, '174.9668000000', 'Lutetium', 'Lu'); INSERT INTO `elements` VALUES (72, '178.4900000000', 'Hafnium', 'Hf'); INSERT INTO `elements` VALUES (73, '180.9478800000', 'Tantalum', 'Ta'); INSERT INTO `elements` VALUES (74, '183.8400000000', 'Tungsten', 'W'); INSERT INTO `elements` VALUES (75, '186.2070000000', 'Rhenium', 'Re'); INSERT INTO `elements` VALUES (76, '190.2300000000', 'Osmium', 'Os'); INSERT INTO `elements` VALUES (77, '192.2170000000', 'Iridium', 'Ir'); INSERT INTO `elements` VALUES (78, '192.0840000000', 'Platinum', 'Pt'); INSERT INTO `elements` VALUES (79, '196.9665690000', 'Gold', 'Au'); INSERT INTO `elements` VALUES (80, '200.5900000000', 'Hydrargyrum', 'Hg'); INSERT INTO `elements` VALUES (81, '204.3833000000', 'Thallium', 'Tl'); INSERT INTO `elements` VALUES (82, '207.2000000000', 'Lead', 'Pb'); INSERT INTO `elements` VALUES (83, '208.9804010000', 'Bismuth', 'Bi'); INSERT INTO `elements` VALUES (84, '210.0000000000', 'Polonium', 'Po'); INSERT INTO `elements` VALUES (85, '210.0000000000', 'Astatine', 'At'); INSERT INTO `elements` VALUES (86, '220.0000000000', 'Radon', 'Rn'); INSERT INTO `elements` VALUES (87, '223.0000000000', 'Francium', 'Fr'); INSERT INTO `elements` VALUES (88, '226.0000000000', 'Radium', 'Ra'); INSERT INTO `elements` VALUES (89, '227.0000000000', 'Actinium', 'Ac'); INSERT INTO `elements` VALUES (90, '232.0380600000', 'Thorium', 'Th'); INSERT INTO `elements` VALUES (91, '231.0358800000', 'Protactinium', 'Pa'); INSERT INTO `elements` VALUES (92, '238.0289100000', 'Uranium', 'U'); INSERT INTO `elements` VALUES (93, '237.0000000000', 'Neptunium', 'Np'); INSERT INTO `elements` VALUES (94, '244.0000000000', 'Plutonium', 'Pu'); INSERT INTO `elements` VALUES (95, '243.0000000000', 'Americium', 'Am'); INSERT INTO `elements` VALUES (96, '247.0000000000', 'Curium', 'Cm'); INSERT INTO `elements` VALUES (97, '247.0000000000', 'Berkelium', 'Bk'); INSERT INTO `elements` VALUES (98, '251.0000000000', 'Californium', 'Cf'); INSERT INTO `elements` VALUES (99, '252.0000000000', 'Einsteinium', 'Es'); INSERT INTO `elements` VALUES (100, '257.0000000000', 'Fermium', 'Fm'); INSERT INTO `elements` VALUES (101, '258.0000000000', 'Mendelevium', 'Md'); INSERT INTO `elements` VALUES (102, '259.0000000000', 'Nobelium', 'No'); INSERT INTO `elements` VALUES (103, '262.0000000000', 'Lawrencium', 'Lr'); INSERT INTO `elements` VALUES (104, '261.0000000000', 'Rutherfordium', 'Rf'); INSERT INTO `elements` VALUES (105, '262.0000000000', 'Dubnium', 'Db'); INSERT INTO `elements` VALUES (106, '266.0000000000', 'Seaborgium', 'Sg'); INSERT INTO `elements` VALUES (107, '264.0000000000', 'Bohrium', 'Bh'); INSERT INTO `elements` VALUES (108, '277.0000000000', 'Hassium', 'Hs'); INSERT INTO `elements` VALUES (109, '268.0000000000', 'Meitnerium', 'Mt'); INSERT INTO `elements` VALUES (110, '271.0000000000', 'Ununnilium', 'Ds'); INSERT INTO `elements` VALUES (111, '272.0000000000', 'Unununium', 'Rg'); INSERT INTO `elements` VALUES (112, '285.0000000000', 'Ununbium', 'Uub'); INSERT INTO `elements` VALUES (113, '284.0000000000', 'Ununtrium', 'Uut'); INSERT INTO `elements` VALUES (114, '289.0000000000', 'Ununquadium', 'Uuq'); INSERT INTO `elements` VALUES (115, '288.0000000000', 'Ununpentium', 'Uup'); INSERT INTO `elements` VALUES (116, '292.0000000000', 'Ununhexium', 'Uuh'); INSERT INTO `elements` VALUES (118, '294.0000000000', 'Ununoctium', 'Uuo');